DROP TABLE IF EXISTS `easy_cms_infos`;
CREATE TABLE `easy_cms_infos` (
  `version` varchar(15) NOT NULL default '',
  `released` date NOT NULL default '0000-00-00',
  `installed` date NOT NULL default '0000-00-00',
  `codename` varchar(255) NOT NULL default ''
);

DROP TABLE IF EXISTS `easy_cms_directories`;
CREATE TABLE `easy_cms_directories` (
  `id` int(11) NOT NULL default '0',
  `name_id` int(11) NOT NULL default '0',
  `parent_id` int(11) NOT NULL default '0',
  `deleted` tinyint(1) NOT NULL default '0',
  `acl_id` int(4) NOT NULL default '0',
	PRIMARY KEY (`id`)
);

DROP TABLE IF EXISTS `easy_cms_files`;
CREATE TABLE `easy_cms_files` (
	`id` int(11) NOT NULL auto_increment,
	`name_id` int(11) NOT NULL,
	`creation_date` date NOT NULL,
	`user_id` int(4) NOT NULL,
	`directory_id` int(11) NOT NULL,
	`original_name` varchar(255) NOT NULL,
	`deleted` tinyint(1) NOT NULL,
	`acl_id` int(4) NOT NULL,
	PRIMARY KEY (`id`)
);

DROP TABLE IF EXISTS `easy_cms_acl`;
CREATE TABLE `easy_cms_acl` (
  `id` int(4) NOT NULL auto_increment,
  `deleted` tinyint(1) default '0',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_acl_groups`;
CREATE TABLE `easy_cms_acl_groups` (
  `acl_id` int(4) NOT NULL default '0',
  `group_id` int(4) NOT NULL default '0',
  `view` tinyint(1) default '0',
  `edit` tinyint(1) default '0',
  `publish` tinyint(1) default '0',
  `remove` tinyint(1) default '0',
  `admin` tinyint(1) default '0',
  PRIMARY KEY  (`acl_id`,`group_id`)
);

DROP TABLE IF EXISTS `easy_cms_acl_users`;
CREATE TABLE `easy_cms_acl_users` (
  `acl_id` int(4) NOT NULL default '0',
  `user_id` int(4) NOT NULL default '0',
  `view` tinyint(1) default '0',
  `edit` tinyint(1) default '0',
  `publish` tinyint(1) default '0',
  `remove` tinyint(1) default '0',
  `admin` tinyint(1) default '0',
  PRIMARY KEY  (`acl_id`,`user_id`)
);

DROP TABLE IF EXISTS `easy_cms_container_contents`;
CREATE TABLE `easy_cms_container_contents` (
  `container_id` int(11) NOT NULL default '0',
  `content_id` int(11) NOT NULL default '0',
  `index` int(11) default '0',
  PRIMARY KEY  (`container_id`,`content_id`)
);

DROP TABLE IF EXISTS `easy_cms_containers`;
CREATE TABLE `easy_cms_containers` (
  `id` int(11) NOT NULL auto_increment,
  `type` int(11) default '0',
  `repository` blob,
  `name_id` int(11) default '0',
  `type_name` varchar(255) NOT NULL,
  `template_id` int(11) default '0',
  `sorting_type` tinyint(4) NOT NULL default '1',
  `sort_field` varchar(255) NOT NULL,
  `sort_order` tinyint(4) NOT NULL default '1',
  `shown_from` int(11) default '0',
  `count_shown` int(11) default '0',
  `clone_id` int(11) default '0',
  `deleted` tinyint(1) default '0',
  `published` tinyint(1) default '0',
  `acl_id` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_containers_lists`;
CREATE TABLE `easy_cms_containers_lists` (
  `id` int(11) NOT NULL auto_increment,
  `sorting_type` tinyint(4) NOT NULL default '1',
  `sort_field` varchar(255) NOT NULL ,
  `sort_order` tinyint(4) NOT NULL default '1',
  `count_shown` int(11) default '0',
  `clone_id` int(11) default '0',
  `deleted` tinyint(1) default '0',
  `published` tinyint(1) default '0',
  `acl_id` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_containers_lists_containers`;
CREATE TABLE `easy_cms_containers_lists_containers` (
  `containers_list_id` int(11) NOT NULL default '0',
  `container_id` int(11) NOT NULL default '0',
  `index` int(11) default '0',
  PRIMARY KEY  (`containers_list_id`,`container_id`)
);

DROP TABLE IF EXISTS `easy_cms_frame_containers`;
CREATE TABLE `easy_cms_frame_containers` (
  `page_id` int(11) NOT NULL default '0',
  `frame_id` int(11) NOT NULL default '0',
  `container_name` varchar(255) NOT NULL ,
  `container_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`frame_id`,`container_name`,`container_id`,`page_id`)
);

DROP TABLE IF EXISTS `easy_cms_frame_containers_lists`;
CREATE TABLE `easy_cms_frame_containers_lists` (
  `page_id` int(11) NOT NULL default '0',
  `frame_id` int(11) NOT NULL default '0',
  `containers_list_id` int(11) NOT NULL default '0',
  `containers_list_name` varchar(255) NOT NULL ,
  PRIMARY KEY  (`frame_id`,`containers_list_id`,`containers_list_name`,`page_id`)
);

DROP TABLE IF EXISTS `easy_cms_frame_menus`;
CREATE TABLE `easy_cms_frame_menus` (
  `frame_id` int(11) NOT NULL default '0',
  `menu_name` varchar(255) NOT NULL ,
  `menu_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`frame_id`,`menu_name`,`menu_id`)
);

DROP TABLE IF EXISTS `easy_cms_frame_scripts`;
CREATE TABLE `easy_cms_frame_scripts` (
  `frame_id` int(11) NOT NULL default '0',
  `script_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`frame_id`,`script_id`)
);

DROP TABLE IF EXISTS `easy_cms_frame_styles`;
CREATE TABLE `easy_cms_frame_styles` (
  `frame_id` int(11) NOT NULL default '0',
  `style_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`frame_id`,`style_id`)
);

DROP TABLE IF EXISTS `easy_cms_frames`;
CREATE TABLE `easy_cms_frames` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL ,
  `file` mediumtext NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
);

DROP TABLE IF EXISTS `easy_cms_users`;
CREATE TABLE `easy_cms_users` (
  `id` int(4) NOT NULL auto_increment,
  `login` varchar(255) NOT NULL ,
  `password` varchar(32) NOT NULL ,
  `firstname` varchar(50),
  `lastname` varchar(50),
  `email` varchar(255),
  `lang_id` int(4) default '1',
  `home_page_id` blob,
  `disabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_groups`;
CREATE TABLE `easy_cms_groups` (
  `id` int(4) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) NOT NULL,
  `disabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_group_users`;
CREATE TABLE `easy_cms_group_users` (
  `group_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`group_id`,`user_id`)
);

DROP TABLE IF EXISTS `easy_cms_labels`;
CREATE TABLE `easy_cms_labels` (
  `id` int(11) NOT NULL auto_increment,
  `lang_id` int(4) NOT NULL default '0',
  `value` mediumtext NOT NULL,
  PRIMARY KEY  (`id`,`lang_id`)
);

DROP TABLE IF EXISTS `easy_cms_languages`;
CREATE TABLE `easy_cms_languages` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL ,
  `short` varchar(4) NOT NULL ,
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_menus`;
CREATE TABLE `easy_cms_menus` (
  `id` int(11) NOT NULL auto_increment,
  `root_page_id` int(11) default '0',
  `name_id` int(11) default '0',
  `template_id` int(11) default '0',
  `sorting_type` tinyint(4) NOT NULL default '0',
  `sort_field` varchar(255) NOT NULL ,
  `sort_order` tinyint(4) default '0',
  `count_shown` int(11) default '0',
  `max_level` int(11) NOT NULL default '0',
  `deleted` tinyint(1) NOT NULL default '0',
  `published` tinyint(1) default '0',
  `acl_id` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_menu_nodes`;
CREATE TABLE `easy_cms_menu_nodes` (
  `id` int(11) NOT NULL auto_increment,
  `menu_id` int(11) NOT NULL default '0',
  `page_id` int(11) NOT NULL default '0',
  `parent_node_id` int(11) NOT NULL default '0',
  `index` int(11) default '0',
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_pages`;
CREATE TABLE `easy_cms_pages` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default '0',
  `name_id` int(11) default '0',
  `alias_id` int(11) default '0',
  `title_id` int(11) default '0',
  `description_id` int(11) default '0',
  `keywords_id` int(11) default '0',
  `frame_id` int(11) default '0',
  `link` blob,
  `cache` tinyint(1) default '0',
  `deleted` tinyint(1) default '0',
  `published` tinyint(1) default '0',
  `acl_id` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_scripts`;
CREATE TABLE `easy_cms_scripts` (
  `id` int(11) NOT NULL auto_increment,
  `file` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_styles`;
CREATE TABLE `easy_cms_styles` (
  `id` int(11) NOT NULL auto_increment,
  `file` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_templates`;
CREATE TABLE `easy_cms_templates` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(255) NOT NULL ,
  `name` varchar(255) NOT NULL ,
  `xsl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_versions`;
CREATE TABLE `easy_cms_versions` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `content_id` int(5) unsigned default '0',
  `date` datetime NOT NULL,
  `type_name` varchar(255) NOT NULL,
  `user_id` int(4) unsigned default '0',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_mailing_queue`;
CREATE TABLE `easy_cms_mailing_queue` (
  `id` int(11) NOT NULL auto_increment,
  `message_id` int(11) NOT NULL default '0',
  `subscriber_id` int(11) NOT NULL default '0',
  `date_in` date NOT NULL default '0000-00-00',
  `date_out` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS `easy_cms_content_type_gallery_photo`;
CREATE TABLE `easy_cms_content_type_gallery_photo` (
  `id` int(11) NOT NULL auto_increment,
  `lang_id` int(4) NOT NULL default '1',
  `acl_id` int(11) NOT NULL default '1',
  `author_id` int(11) default '0',
  `published` tinyint(1) default '0',
  `deleted` tinyint(1) default '0',
  `date` date NOT NULL,
  `title` varchar(255) NOT NULL ,
  `image` tinyblob NOT NULL ,
  `comment` text NOT NULL,
  PRIMARY KEY  (`id`,`lang_id`)
);

DROP TABLE IF EXISTS `easy_cms_content_type_article`;
CREATE TABLE `easy_cms_content_type_article` (
  `id` int(11) NOT NULL auto_increment,
  `lang_id` int(4) NOT NULL default '1',
  `acl_id` int(11) NOT NULL default '1',
  `author_id` int(11) default '0',
  `published` tinyint(1) default '0',
  `deleted` tinyint(1) default '0',
  `date` date NOT NULL,
  `title` varchar(255) NOT NULL ,
  `subtitle` varchar(255) NOT NULL ,
  `content` longtext NOT NULL,
  PRIMARY KEY  (`id`,`lang_id`)
);

DROP TABLE IF EXISTS `easy_cms_content_type_simple_link`;
CREATE TABLE `easy_cms_content_type_simple_link` (
  `id` int(11) NOT NULL auto_increment,
  `lang_id` int(4) NOT NULL default '1',
  `acl_id` int(11) NOT NULL default '1',
  `author_id` int(11) default '0',
  `published` tinyint(1) default '0',
  `deleted` tinyint(1) default '0',
  `title` varchar(255) NOT NULL,
  `link` blob NOT NULL,
  PRIMARY KEY  (`id`,`lang_id`)
);

DROP TABLE IF EXISTS `easy_cms_content_type_mailing_list`;
CREATE TABLE `easy_cms_content_type_mailing_list` (
  `id` int(11) NOT NULL auto_increment,
  `lang_id` int(4) NOT NULL default '0',
  `acl_id` int(11) NOT NULL default '0',
  `author_id` int(11) default '0',
  `published` tinyint(1) NOT NULL default '0',
  `deleted` tinyint(1) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`,`lang_id`)
);

DROP TABLE IF EXISTS `easy_cms_content_type_mailing_message`;
CREATE TABLE `easy_cms_content_type_mailing_message` (
  `id` int(11) NOT NULL auto_increment,
  `lang_id` int(4) NOT NULL default '0',
  `acl_id` int(11) NOT NULL default '0',
  `author_id` int(11) default '0',
  `published` tinyint(1) NOT NULL default '0',
  `deleted` tinyint(1) NOT NULL default '0',
  `mailing_list_id` int(11) NOT NULL default '0',
  `sent` tinyint(1) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `subject` varchar(255) NOT NULL default '',
  `body` longtext NOT NULL,
  PRIMARY KEY  (`id`,`lang_id`)
);

DROP TABLE IF EXISTS `easy_cms_content_type_mailing_subscriber`;
CREATE TABLE `easy_cms_content_type_mailing_subscriber` (
  `id` int(11) NOT NULL auto_increment,
  `lang_id` int(4) NOT NULL default '0',
  `acl_id` int(11) NOT NULL default '0',
  `author_id` int(11) default '0',
  `published` tinyint(1) NOT NULL default '0',
  `deleted` tinyint(1) NOT NULL default '0',
  `mailing_list_id` int(11) NOT NULL default '0',
  `firstname` varchar(255) NOT NULL default '',
  `lastname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`,`lang_id`)
);

DROP TABLE IF EXISTS `easy_cms_engines`;
CREATE TABLE `easy_cms_engines` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `last_run` int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS `easy_mlm`;
CREATE TABLE `easy_mlm` (
  `id` int(11) NOT NULL auto_increment,
  `list_id` int(11) NOT NULL default '1',
  `first_name` varchar(255) NOT NULL default '',
  `last_name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `send` tinyint(1) NOT NULL default '0',
  `remove` tinyint(1) NOT NULL default '0',
  `code` varchar(32) NOT NULL default '',
  `gender` char(1) NOT NULL default '',
  `position` varchar(255) NOT NULL,
  `about` varchar(255) NOT NULL,
  `lang` varchar(50) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `organisation` varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
);

INSERT INTO `easy_cms_infos` VALUES ('2.0.0rc1', '2008-08-27', '0000-00-00', 'limache');
INSERT INTO `easy_cms_acl` VALUES (1, 0);
INSERT INTO `easy_cms_acl_groups` VALUES (1, 1, 1, 1, 1, 1, 1);
INSERT INTO `easy_cms_acl_users` VALUES (1, 1, 1, 1, 1, 1, 1);
INSERT INTO `easy_cms_acl_users` VALUES (1, 2, 1, 1, 1, 1, 1);
INSERT INTO `easy_cms_acl_users` VALUES (1, 3, 1, 0, 0, 0, 0);
INSERT INTO `easy_cms_users` VALUES (1, 'ROOT', '21232f297a57a5a743894a0e4a801fc3', '', '', '', 1, '?pid=1', 0);
INSERT INTO `easy_cms_users` VALUES (2, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'C&eacute;dric', 'Fran&ccedil;oys', '', 1, '?pid=1', 0);
INSERT INTO `easy_cms_users` VALUES (3, 'GUEST', '084e0343a0486ff05530df6c705c8bb4', '', '', '', 1, '?pid=1', 0);
INSERT INTO `easy_cms_groups` VALUES (1, 'ADMINISTRATORS', '', 0);
INSERT INTO `easy_cms_groups` VALUES (2, 'EVERYONE', '', 0);
INSERT INTO `easy_cms_group_users` VALUES (1, 1);
INSERT INTO `easy_cms_group_users` VALUES (1, 2);
INSERT INTO `easy_cms_group_users` VALUES (2, 3);
INSERT INTO `easy_cms_container_contents` VALUES (1, 1, 1);
INSERT INTO `easy_cms_container_contents` VALUES (2, 1, 1);
INSERT INTO `easy_cms_containers` VALUES (1, 0, '', 6, 'simple_link', 1, 1, 'index', 1, 0, 0, 0, 0, 1, 1);
INSERT INTO `easy_cms_containers` VALUES (2, 0, '', 7, 'article', 3, 1, 'title', 2, 0, 0, 0, 0, 1, 1);
INSERT INTO `easy_cms_containers_lists` VALUES (1, 1, 'id', 1, 0, 0, 0, 1, 1);
INSERT INTO `easy_cms_containers_lists_containers` VALUES (1, 2, 1);
INSERT INTO `easy_cms_content_type_article` VALUES (1, 1, 1, 2, 1, 0, '2008-08-01', 'Welcome to easy-CMS', 'good to see you here', 'Congratulations, You successfully installed easy-CMS!<br />\r\n');
INSERT INTO `easy_cms_content_type_article` VALUES (1, 2, 1, 2, 1, 0, '2008-08-01', 'Bienvenue dans easy-CMS', 'content de vous voir', 'F&eacute;licitations, vous avez correctement install&eacute; easy-CMS!<br />\r\n');
INSERT INTO `easy_cms_content_type_simple_link` VALUES (1, 1, 1, 2, 1, 0, 'Home', 0x696e6465782e7068703f7069643d31);
INSERT INTO `easy_cms_content_type_simple_link` VALUES (2, 1, 1, 2, 1, 0, 'Homepage', 0x696e6465782e7068703f7069643d31);
INSERT INTO `easy_cms_content_type_simple_link` VALUES (1, 2, 1, 2, 1, 0, 'Accueil', 0x696e6465782e7068703f7069643d31);
INSERT INTO `easy_cms_content_type_simple_link` VALUES (2, 2, 1, 2, 1, 0, 'Bienvenue', 0x696e6465782e7068703f7069643d31);
INSERT INTO `easy_cms_frame_containers` VALUES (1, 1, 'top_menu', 1);
INSERT INTO `easy_cms_frame_containers` VALUES (1, 1, 'quick_nav', 2);
INSERT INTO `easy_cms_frame_containers_lists` VALUES (1, 1, 1, 'content');
INSERT INTO `easy_cms_frame_styles` VALUES (1, 1);
INSERT INTO `easy_cms_frames` VALUES (1, 'main', 'main.xhtml');
INSERT INTO `easy_cms_labels` VALUES (1, 1, 'home');
INSERT INTO `easy_cms_labels` VALUES (2, 1, 'home');
INSERT INTO `easy_cms_labels` VALUES (3, 1, 'homepage');
INSERT INTO `easy_cms_labels` VALUES (4, 1, '');
INSERT INTO `easy_cms_labels` VALUES (5, 1, '');
INSERT INTO `easy_cms_labels` VALUES (1, 2, 'Accueil');
INSERT INTO `easy_cms_labels` VALUES (2, 2, '');
INSERT INTO `easy_cms_labels` VALUES (3, 2, 'Bienvenue');
INSERT INTO `easy_cms_labels` VALUES (4, 2, '');
INSERT INTO `easy_cms_labels` VALUES (5, 2, '');
INSERT INTO `easy_cms_labels` VALUES (6, 1, 'first container');
INSERT INTO `easy_cms_labels` VALUES (7, 1, 'another container');
INSERT INTO `easy_cms_labels` VALUES (6, 2, 'premier conteneur');
INSERT INTO `easy_cms_labels` VALUES (7, 2, 'autre conteneur');
INSERT INTO `easy_cms_languages` VALUES (1, 'english', 'en');
INSERT INTO `easy_cms_languages` VALUES (2, 'french', 'fr');
INSERT INTO `easy_cms_pages` VALUES (1, 0, 1, 2, 3, 4, 5, 1, '', 0, 0, 1, 1);
INSERT INTO `easy_cms_styles` VALUES (1, 'styles.css');
INSERT INTO `easy_cms_templates` VALUES (1, 'simple_link', 'horiz_menu', '<xsl:template match="container">\r\n<table id="top_menu">\r\n  <tr>\r\n         <xsl:apply-templates select="contents" />\r\n  </tr>\r\n</table>\r\n</xsl:template>\r\n\r\n<xsl:template match="simple_link">\r\n <td class="menu_item"><a href="{./link}"><xsl:value-of select="./title" disable-output-escaping="yes" /></a></td>\r\n  <td class="controls"><xsl:apply-templates select="content_controls" /><b /></td>\r\n  <td class="separator"><img border="0" src="Repositories/Images/sep_top_menu.png" /></td>\r\n</xsl:template>');
INSERT INTO `easy_cms_templates` VALUES (2, 'simple_link', 'left_menu', '<xsl:template match="container">\r\n<table class="left_group">\r\n         <xsl:apply-templates select="contents" />\r\n</table>\r\n</xsl:template>\r\n\r\n<xsl:template match="simple_link">\r\n    <tr>\r\n  <td class="menu_item">\r\n      <table>\r\n   <tr>\r\n        <td class="puce"><img border="0" src="Repositories/Images/puce_left_menu.png" /></td>\r\n       <td><a href="{./link}"><xsl:value-of select="./title" disable-output-escaping="yes" /></a></td>\r\n                    <td class="controls"><xsl:apply-templates select="content_controls" /><b /></td>\r\n   </tr>\r\n     </table>\r\n  </td>\r\n    </tr>\r\n</xsl:template>\r\n');
INSERT INTO `easy_cms_templates` VALUES (3, 'article', 'default', '<xsl:template match="container">\r\n         <xsl:apply-templates select="contents" />\r\n</xsl:template>\r\n\r\n<xsl:template match="article">\r\n<div class="article">\r\n<table border="0" cellspacing="0" cellpadding="0">\r\n<tr>\r\n<td class="controls"><xsl:apply-templates select="content_controls" /><b /></td>\r\n<td class="article_titre"><xsl:value-of select="./title" disable-output-escaping="yes" /></td>\r\n</tr>\r\n<tr>\r\n<td colspan="2" class="article_soustitre"><xsl:value-of select="./subtitle" disable-output-escaping="yes" /></td>\r\n</tr>\r\n</table>\r\n<div class="article_contenu"><xsl:value-of select="./content" disable-output-escaping="yes" /></div>\r\n</div>\r\n</xsl:template>\r\n');
INSERT INTO `easy_cms_templates` VALUES (4, 'easy_cms_page', 'left_menu', '<xsl:template match="easy_cms_menu">\r\n<table class="left_group">\r\n         <xsl:apply-templates select="pages">\r\n            <xsl:with-param name="level" select="0" />\r\n         </xsl:apply-templates>\r\n</table>\r\n</xsl:template>\r\n\r\n\r\n<xsl:template match="page">\r\n   <xsl:param name="level" />\r\n    <tr>\r\n	<td class="menu_item">\r\n	    <table>\r\n		<tr>\r\n                    <td class="controls"><xsl:apply-templates select="page_controls" /><b /></td>\r\n                    <td width="{$level * 10}"><b /></td>\r\n		    <td class="puce"><img border="0" src="Repositories/Images/puce_left_menu.png" /></td>\r\n		    <td><a href="{./link}"><xsl:value-of select="./name" disable-output-escaping="yes" /></a></td>                    \r\n		</tr>\r\n	    </table>\r\n	</td>\r\n    </tr>\r\n    <xsl:apply-templates select="page" >\r\n        <xsl:with-param name="level" select="$level + 1" />\r\n    </xsl:apply-templates>\r\n</xsl:template>');
INSERT INTO `easy_cms_templates` VALUES (5, 'easy_cms_page', 'nav_menu', '<xsl:template match="easy_cms_menu">\r\n   <xsl:apply-templates select="pages">\r\n        <xsl:with-param name="page_id" select="./page_id" />\r\n        <xsl:with-param name="level" select="0" />\r\n   </xsl:apply-templates>\r\n</xsl:template>\r\n\r\n<xsl:template match="page">\r\n   <xsl:param name="page_id" />\r\n   <xsl:param name="level" />\r\n   <xsl:param name="link" />\r\n   <xsl:param name="name" />\r\n\r\n   <xsl:choose>\r\n           <xsl:when test="$page_id = id">\r\n                   <xsl:if test="position() = 1">\r\n                       <xsl:if test="$level &gt; 0">&gt; </xsl:if> \r\n                       <a href="{$link}"><xsl:value-of select="$name" disable-output-escaping="yes" /></a> &gt; \r\n                   </xsl:if>\r\n                   <xsl:value-of select="name" disable-output-escaping="yes" />\r\n             </xsl:when>\r\n             <xsl:otherwise>\r\n                   <xsl:if test="position() = 1">\r\n                       <xsl:if test="$level &gt; 0">&gt; </xsl:if> \r\n                       <a href="{$link}"><xsl:value-of select="$name" disable-output-escaping="yes" /></a> &gt; \r\n                   </xsl:if>\r\n                   <xsl:apply-templates select="page" >\r\n                           <xsl:with-param name="level" select="$level" />\r\n                           <xsl:with-param name="page_id" select="$page_id" />\r\n                           <xsl:with-param name="link" select="./link" />\r\n                           <xsl:with-param name="name" select="./name" />\r\n                   </xsl:apply-templates>\r\n           </xsl:otherwise>\r\n   </xsl:choose>\r\n\r\n</xsl:template>');
INSERT INTO `easy_cms_templates` VALUES (6, 'gallery_photo', 'default', '<xsl:template match="container">\r\n        <xsl:apply-templates select="contents" />\r\n</xsl:template>\r\n\r\n<xsl:template match="gallery_photo">\r\n<div class="item_photo_frame">\r\n<div class="item_photo">\r\n       <div class="photo">\r\n               <div class="image"><img src="display_img.php?filename={./image/path}" /></div>\r\n               <div class="options">\r\n<a href="#" onclick="javascript:window.open(''show_dia.php?index={./id}&amp;dia_mode=ctn_{./container-id}'',''diaWin'',''fullscreen=yes,scrollbars=no'');">\r\n<img src="includes/images/icon_dia.gif" border="0" /></a><xsl:text\r\ndisable-output-escaping="yes">&#160;&#160;&#160;</xsl:text>\r\n<a href="{./image/path}" target="_blank">\r\n<img src="includes/images/icon_full.gif" border="0" /></a><xsl:text\r\ndisable-output-escaping="yes">&#160;&#160;&#160;</xsl:text>\r\n</div>\r\n       </div>\r\n       <div class="infos">\r\n               <div class="date"><xsl:value-of select="./date/month_name"\r\ndisable-output-escaping="yes" /><xsl:text\r\ndisable-output-escaping="yes">&#160;</xsl:text><xsl:value-of\r\nselect="./date/year" disable-output-escaping="yes" /></div>\r\n               <div class="titre"><xsl:apply-templates select="content_controls"\r\n/><xsl:value-of select="./title" disable-output-escaping="yes"\r\n/></div>\r\n               <div class="texte"><xsl:value-of select="./comment"\r\ndisable-output-escaping="yes" /></div>\r\n       </div>\r\n</div>\r\n</div>\r\n</xsl:template>');