
CREATE TABLE IF NOT EXISTS `PageThemeStyles` (
  `ptID` int(10) unsigned NOT NULL DEFAULT '0',
  `ptsHandle` varchar(128) NOT NULL,
  `ptsValue` longtext,
  `ptsType` varchar(32) NOT NULL,
  PRIMARY KEY (`ptID`,`ptsHandle`,`ptsType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `PageThemes` (
  `ptID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ptHandle` varchar(64) NOT NULL,
  `ptName` varchar(255) DEFAULT NULL,
  `ptDescription` text,
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ptID`),
  UNIQUE KEY `ptHandle` (`ptHandle`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

INSERT INTO PageThemes VALUES(31,'pic29_theme','Pic29\r\n','Un thème dédié au site pic29.com\r\n',44);


CREATE TABLE IF NOT EXISTS `PageTypeAttributes` (
  `ctID` int(10) unsigned NOT NULL DEFAULT '0',
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ctID`,`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO PageTypeAttributes VALUES(3,1)
 ,(3,2)
 ,(3,3)
 ,(3,4)
 ,(8,1)
 ,(8,2)
 ,(8,3)
 ,(8,4)
 ,(8,17)
 ,(9,1)
 ,(9,2)
 ,(9,3)
 ,(9,4)
 ,(9,17)
 ,(10,1)
 ,(10,2)
 ,(10,3)
 ,(10,4)
 ,(10,17)
 ,(11,1)
 ,(11,2)
 ,(11,3)
 ,(11,4)
 ,(11,17)
 ,(12,1)
 ,(12,2)
 ,(12,3)
 ,(12,4)
 ,(12,17)
 ,(13,1)
 ,(13,2)
 ,(13,3)
 ,(13,4)
 ,(13,17)
 ,(14,4)
 ,(14,8);


CREATE TABLE IF NOT EXISTS `PageTypes` (
  `ctID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ctHandle` varchar(32) NOT NULL,
  `ctIcon` varchar(128) DEFAULT NULL,
  `ctName` varchar(90) NOT NULL,
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ctID`),
  UNIQUE KEY `ctHandle` (`ctHandle`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

INSERT INTO PageTypes VALUES(12,'en_marine','pic29_en_marine.png','English Marine',0)
 ,(10,'fr_terrestre','pic29_fr_terrestre.png','Francais Terrestre',0)
 ,(3,'full','pic29_full.png','Full Width',0)
 ,(13,'en_terrestre','pic29_en_terrestre.png','English Terrestre',0)
 ,(8,'fr_marine','pic29_fr_marine.png','Francais Marine',0)
 ,(9,'en','pic29_en.png','English',0)
 ,(11,'fr','pic29_fr.png','Francais',0)
 ,(14,'popup','pic29_full.png','popup',0);


CREATE TABLE IF NOT EXISTS `Pages` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `ctID` int(10) unsigned NOT NULL DEFAULT '0',
  `cIsTemplate` varchar(1) NOT NULL DEFAULT '0',
  `uID` int(10) unsigned DEFAULT NULL,
  `cIsCheckedOut` tinyint(1) NOT NULL DEFAULT '0',
  `cCheckedOutUID` int(10) unsigned DEFAULT NULL,
  `cCheckedOutDatetime` datetime DEFAULT NULL,
  `cCheckedOutDatetimeLastEdit` datetime DEFAULT NULL,
  `cPendingAction` varchar(6) DEFAULT NULL,
  `cPendingActionDatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cPendingActionUID` int(10) unsigned DEFAULT NULL,
  `cPendingActionTargetCID` int(10) unsigned DEFAULT NULL,
  `cOverrideTemplatePermissions` tinyint(1) NOT NULL DEFAULT '1',
  `cInheritPermissionsFromCID` int(10) unsigned NOT NULL DEFAULT '0',
  `cInheritPermissionsFrom` varchar(8) NOT NULL DEFAULT 'PARENT',
  `cFilename` varchar(255) DEFAULT NULL,
  `cPointerID` int(10) unsigned NOT NULL DEFAULT '0',
  `cPointerExternalLink` varchar(255) DEFAULT NULL,
  `cPointerExternalLinkNewWindow` tinyint(1) NOT NULL DEFAULT '0',
  `cChildren` int(10) unsigned NOT NULL DEFAULT '0',
  `cDisplayOrder` int(10) unsigned NOT NULL DEFAULT '0',
  `cParentID` int(10) unsigned NOT NULL DEFAULT '0',
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  `ptID` int(10) unsigned NOT NULL DEFAULT '0',
  `cCacheFullPageContent` int(4) NOT NULL DEFAULT '-1',
  `cCacheFullPageContentOverrideLifetime` varchar(32) NOT NULL DEFAULT '0',
  `cCacheFullPageContentLifetimeCustom` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`),
  KEY `cParentID` (`cParentID`),
  KEY `cCheckedOutUID` (`cCheckedOutUID`),
  KEY `cPointerID` (`cPointerID`),
  KEY `uID` (`uID`),
  KEY `ctID` (`ctID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO Pages VALUES(1,3,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'OVERRIDE',NULL,0,NULL,0,9,0,0,0,31,-1,'0',0)
 ,(89,9,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,4,1,1,0,31,-1,'0',0)
 ,(5,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,5,'OVERRIDE','/login.php',0,NULL,0,0,0,1,0,31,-1,'0',0)
 ,(6,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,6,'OVERRIDE','/register.php',0,NULL,0,0,3,1,0,31,-1,'0',0)
 ,(7,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/profile/view.php',0,NULL,0,4,4,1,0,31,-1,'0',0)
 ,(8,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/profile/edit.php',0,NULL,0,0,0,7,0,31,-1,'0',0)
 ,(10,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/profile/avatar.php',0,NULL,0,0,1,7,0,31,-1,'0',0)
 ,(11,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/profile/messages.php',0,NULL,0,0,2,7,0,31,-1,'0',0)
 ,(12,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/profile/friends.php',0,NULL,0,0,3,7,0,31,-1,'0',0)
 ,(13,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/page_not_found.php',0,NULL,0,0,6,1,0,31,-1,'0',0)
 ,(14,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/page_forbidden.php',0,NULL,0,0,7,1,0,31,-1,'0',0)
 ,(15,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'OVERRIDE','/dashboard/view.php',0,NULL,0,9,8,1,0,31,-1,'0',0)
 ,(16,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/sitemap/view.php',0,NULL,0,4,0,15,0,31,-1,'0',0)
 ,(17,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/sitemap/full.php',0,NULL,0,0,0,16,0,31,-1,'0',0)
 ,(18,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/sitemap/explore.php',0,NULL,0,0,1,16,0,31,-1,'0',0)
 ,(19,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/sitemap/search.php',0,NULL,0,0,2,16,0,31,-1,'0',0)
 ,(20,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/sitemap/access.php',0,NULL,0,0,3,16,0,31,-1,'0',0)
 ,(21,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/files/view.php',0,NULL,0,4,1,15,0,31,-1,'0',0)
 ,(22,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/files/search.php',0,NULL,0,0,0,21,0,31,-1,'0',0)
 ,(23,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/files/attributes.php',0,NULL,0,0,1,21,0,31,-1,'0',0)
 ,(24,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/files/sets.php',0,NULL,0,0,2,21,0,31,-1,'0',0)
 ,(25,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/files/access.php',0,NULL,0,0,3,21,0,31,-1,'0',0)
 ,(26,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/reports.php',0,NULL,0,3,2,15,0,31,-1,'0',0)
 ,(27,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/reports/forms.php',0,NULL,0,0,0,26,0,31,-1,'0',0)
 ,(28,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/reports/surveys.php',0,NULL,0,0,1,26,0,31,-1,'0',0)
 ,(29,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/reports/logs.php',0,NULL,0,0,2,26,0,31,-1,'0',0)
 ,(30,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/users/view.php',0,NULL,0,5,3,15,0,31,-1,'0',0)
 ,(31,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/users/search.php',0,NULL,0,0,0,30,0,31,-1,'0',0)
 ,(32,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/users/add.php',0,NULL,0,0,1,30,0,31,-1,'0',0)
 ,(33,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/users/groups.php',0,NULL,0,0,2,30,0,31,-1,'0',0)
 ,(34,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/users/attributes.php',0,NULL,0,0,3,30,0,31,-1,'0',0)
 ,(35,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/users/registration.php',0,NULL,0,0,4,30,0,31,-1,'0',0)
 ,(36,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/scrapbook/view.php',0,NULL,0,0,4,15,0,31,-1,'0',0)
 ,(37,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/view.php',0,NULL,0,4,5,15,0,31,-1,'0',0)
 ,(38,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/themes/view.php',0,NULL,0,4,0,37,0,31,-1,'0',0)
 ,(39,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/themes/add.php',0,NULL,0,0,0,38,0,31,-1,'0',0)
 ,(40,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/themes/inspect.php',0,NULL,0,0,1,38,0,31,-1,'0',0)
 ,(41,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/themes/customize.php',0,NULL,0,0,2,38,0,31,-1,'0',0)
 ,(42,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','0',0,NULL,0,0,3,38,0,31,-1,'0',0)
 ,(43,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/types/view.php',0,NULL,0,0,1,37,0,31,-1,'0',0)
 ,(44,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/attributes.php',0,NULL,0,0,2,37,0,31,-1,'0',0)
 ,(45,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/pages/single.php',0,NULL,0,0,3,37,0,31,-1,'0',0)
 ,(46,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/install.php',0,NULL,0,0,6,15,0,31,-1,'0',0)
 ,(47,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/system/view.php',0,NULL,0,4,7,15,0,31,-1,'0',0)
 ,(48,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/system/jobs.php',0,NULL,0,0,0,47,0,31,-1,'0',0)
 ,(49,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/system/backup.php',0,NULL,0,0,1,47,0,31,-1,'0',0)
 ,(50,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/system/update.php',0,NULL,0,0,2,47,0,31,-1,'0',0)
 ,(51,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/system/notifications.php',0,NULL,0,0,3,47,0,31,-1,'0',0)
 ,(52,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/settings/view.php',0,NULL,0,2,8,15,0,31,-1,'0',0)
 ,(53,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/settings/mail/view.php',0,NULL,0,0,0,52,0,31,-1,'0',0)
 ,(54,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,15,'PARENT','/dashboard/settings/marketplace.php',0,NULL,0,0,1,52,0,31,-1,'0',0)
 ,(55,0,'0',1,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,1,'PARENT','/download_file.php',0,NULL,0,0,9,1,0,31,-1,'0',0)
 ,(86,9,'1',NULL,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(65,3,'1',NULL,0,NULL,NULL,NULL,NULL,'2010-11-09 00:04:48',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(87,10,'1',NULL,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(101,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,5,3,100,0,31,-1,'0',0)
 ,(90,8,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,3,0,100,0,31,-1,'0',0)
 ,(91,10,'0',1,0,NULL,NULL,'2011-03-10 17:08:04',NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,5,1,100,0,31,-1,'0',0)
 ,(92,11,'1',NULL,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(93,12,'1',NULL,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(85,8,'1',NULL,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(94,13,'1',NULL,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(108,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,1,104,0,31,-1,'0',0)
 ,(140,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,4,115,0,31,-1,'0',0)
 ,(98,14,'1',NULL,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,0,'PARENT',NULL,0,NULL,0,0,0,0,0,0,-1,'0',0)
 ,(115,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,4,2,91,0,31,-1,'0',0)
 ,(100,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,4,0,1,0,31,-1,'0',0)
 ,(136,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,8,125,0,31,-1,'0',0)
 ,(124,8,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,1,90,0,31,-1,'0',0)
 ,(104,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,4,4,100,0,31,-1,'0',0)
 ,(105,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,2,104,0,31,-1,'0',0)
 ,(106,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,104,0,31,-1,'0',0)
 ,(107,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,91,0,31,-1,'0',0)
 ,(125,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,6,5,91,0,31,-1,'0',0)
 ,(109,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,3,104,0,31,-1,'0',0)
 ,(110,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,2,101,0,31,-1,'0',0)
 ,(111,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,3,101,0,31,-1,'0',0)
 ,(112,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,4,101,0,31,-1,'0',0)
 ,(113,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,5,101,0,31,-1,'0',0)
 ,(114,11,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,6,101,0,31,-1,'0',0)
 ,(141,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,5,115,0,31,-1,'0',0)
 ,(142,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,6,115,0,31,-1,'0',0)
 ,(143,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,7,115,0,31,-1,'0',0)
 ,(120,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,3,91,0,31,-1,'0',0)
 ,(122,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,4,91,0,31,-1,'0',0)
 ,(123,8,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,90,0,31,-1,'0',0)
 ,(134,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,6,125,0,31,-1,'0',0)
 ,(135,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,7,125,0,31,-1,'0',0)
 ,(137,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,9,125,0,31,-1,'0',0)
 ,(138,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,10,125,0,31,-1,'0',0)
 ,(139,10,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,11,125,0,31,-1,'0',0)
 ,(132,8,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,1,2,90,0,31,-1,'0',0)
 ,(133,8,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,132,0,31,-1,'0',0)
 ,(145,9,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,2,0,89,0,31,-1,'0',0)
 ,(146,13,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,2,1,89,0,31,-1,'0',0)
 ,(147,9,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,1,2,89,0,31,-1,'0',0)
 ,(148,9,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,1,3,89,0,31,-1,'0',0)
 ,(149,12,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,145,0,31,-1,'0',0)
 ,(150,12,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,1,1,145,0,31,-1,'0',0)
 ,(151,12,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,150,0,31,-1,'0',0)
 ,(152,13,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,146,0,31,-1,'0',0)
 ,(153,13,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,1,1,146,0,31,-1,'0',0)
 ,(157,13,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,153,0,31,-1,'0',0)
 ,(159,9,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,148,0,31,-1,'0',0)
 ,(158,9,'0',1,0,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,1,1,'PARENT',NULL,0,NULL,0,0,0,147,0,31,-1,'0',0);


CREATE TABLE IF NOT EXISTS `PileContents` (
  `pcID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pID` int(10) unsigned NOT NULL DEFAULT '0',
  `itemID` int(10) unsigned NOT NULL DEFAULT '0',
  `itemType` varchar(64) NOT NULL,
  `quantity` int(10) unsigned NOT NULL DEFAULT '1',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `displayOrder` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`pcID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO PileContents VALUES(1,1,323,'BLOCK',1,'2011-03-10 15:07:10',0);


CREATE TABLE IF NOT EXISTS `Piles` (
  `pID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uID` int(10) unsigned DEFAULT NULL,
  `isDefault` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` varchar(255) DEFAULT NULL,
  `state` varchar(64) NOT NULL,
  PRIMARY KEY (`pID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO Piles VALUES(1,1,1,'2010-11-09 23:19:37',NULL,'READY');


CREATE TABLE IF NOT EXISTS `SignupRequests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ipFrom` int(10) unsigned NOT NULL DEFAULT '0',
  `date_access` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `index_ipFrom` (`ipFrom`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `SystemNotifications` (
  `snID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `snTypeID` int(3) unsigned NOT NULL DEFAULT '0',
  `snURL` text,
  `snURL2` text,
  `snDateTime` datetime NOT NULL,
  `snIsArchived` int(1) NOT NULL DEFAULT '0',
  `snIsNew` int(1) NOT NULL DEFAULT '0',
  `snTitle` varchar(255) DEFAULT NULL,
  `snDescription` text,
  `snBody` text,
  PRIMARY KEY (`snID`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

INSERT INTO SystemNotifications VALUES(1,11,'http://www.concrete5.org/index.php?cID=38654',NULL,'2010-03-12 00:05:00',0,0,'concrete5 Documentation Overhaul','We have completely overhauled our documentation system, and the results are much improved.....','We have completely overhauled our documentation system, and the results are much improved.....')
 ,(2,11,'http://www.concrete5.org/documentation/background/news-and-updates/help/updated_documentation_site_with_forums/',NULL,'2008-11-01 18:00:00',0,0,'Updated Documentation Site with Forums','Concrete5.org\'s documentation is much improved, including the ability to search our forums and get quick answers to your questions.....','Concrete5.org\'s documentation is much improved, including the ability to search our forums and get quick answers to your questions.....')
 ,(3,12,'http://www.concrete5.org/documentation/background/news-and-updates/news/concrete-5-4-1-now-available/',NULL,'2010-10-05 01:33:00',0,0,'concrete 5.4.1 Now Available!','The latest version of concrete5 adds some significant file manager improvements, improved performance across the board, full page caching, better block caching, and lots of bug fixes.....','The latest version of concrete5 adds some significant file manager improvements, improved performance across the board, full page caching, better block caching, and lots of bug fixes.....')
 ,(4,12,'http://www.concrete5.org/documentation/background/news-and-updates/news/totally-random-episode-9/',NULL,'2010-08-09 15:00:00',0,0,'News: Multi-Site-Manager Released, plus lots of add-ons','concrete5 for cPanel/WHM is released, along with a bunch of add-ons and themes in the marketplace. ....','concrete5 for cPanel/WHM is released, along with a bunch of add-ons and themes in the marketplace. ....')
 ,(5,10,'/concrete5pic29/index.php/dashboard/system/update/',NULL,'2010-11-27 12:04:02',0,0,'A new version of concrete5 is now available.','','\n<h2>5.4.1.1</h2>\n\n<h3>Feature Updates</h3>\n\n<ul>\n<li>Better file upload details box. Remove the blank metadata since some of that can be imported. Instead use the bulk metadata tools. Fix bulk metadata tools so that they do a better job showing multiple values.</li>\n<li>Add an \"install packages\" task permission and set it to the Administrators group.</li>\n</ul>\n\n<h3>Bug Fixes</h3>\n\n<ul>\n<li>Fix the task permissions so that administrators the group have access to them.</li>\n<li>Fix issue with upgrading from 5.3.3.1 to 5.4.1</li>\n<li>Made single pages uncacheable unless explicitly cached in the page properties.</li>\n<li>Fixing JavaScript error in TinyMCE with the image editor window</li>\n<li>Including cPath, cvName and atSelectOptionID in indexes on their tables</li>\n<li>Advanced permissions: Click permissions tab on the top of the page, close it, then click on the block, and you\'re unable to add users/groups</li>\n<li>Lack of \"default 0\" on ocID column in Files table was causing problems in Windows.</li>\n<li>Fixed bug when CollectionAttributeKey::getByID would return a valid attribute even if akID was NOT a collection attribute key</li>\n<li>Fixed bug in presentation of search block where multiple search blocks on a page would display search results on both.</li>\n<li>Fixed bug when uploading a file in IE resulting in a blank page.</li>\n<li>Fixed bug where user could not be updated in Internet Explorer</li>\n<li>Fixed bug where date nav \"under another page\" option didn\'t work.</li>\n<li>Fixed bug in select attribute when server didn\'t have the JSON extension installed (resulting in no page add or edit button being displayed at certain points.)</li>\n<li>Fixed javascript errors when working with select attribute types in IE</li>\n<li>Added EmulateIE8 to IE7 to get it to work better in the dashboard</li>\n<li>Improved file sets list view in IE7</li>\n<li>No longer installing broken marketplace themes page (that you couldn\'t navigate to using the menus but would show in the sitemap when clicking \"show system pages\")</li>\n<li>Better button display in non-default uses of TinyMCE</li>\n<li>Create blog_entry page type on upgrade</li>\n<li>When duplicating a file, make sure that the new file is the one that gets the metadata change if any metadata is tweaked</li>\n<li>http://www.concrete5.org/developers/bugs/5-4-1/edit-multiple-user-properties/#84118</li>\n<li>Search block\'s default simple search now can handle indexed attributes</li>\n<li>Adding a trailing slash on the end of a secondary URL will now correctly route to the original post</li>\n<li>Better unique ID generation when dealing with presets on design</li>\n</ul>\n\n\n')
 ,(6,12,'http://www.concrete5.org/documentation/background/news-and-updates/news/concrete-5-4-1-1-now-available/',NULL,'2010-11-19 21:52:00',0,0,'concrete 5.4.1.1 Now Available','Fixing 26 bugs and improving the file uploading experience, this update is recommended for users of 5.4.1....','Fixing 26 bugs and improving the file uploading experience, this update is recommended for users of 5.4.1....')
 ,(7,12,'http://www.concrete5.org/documentation/background/news-and-updates/news/30-in-30/',NULL,'2010-11-11 15:55:00',0,0,'30 Themes in 30 Days','Production Developers & Designers Can Earn Licenses for Making concrete5 Themes....','Production Developers & Designers Can Earn Licenses for Making concrete5 Themes....')
 ,(8,11,'http://www.concrete5.org/about/blog/concrete5-sightings/karma-is-back-other-cool-features/',NULL,'2011-01-22 01:35:00',0,0,'Karma is back, other cool features','As we slowly roll out features from the redesign we\'ve got Karma back as well as a new Special Offers feature.','As we slowly roll out features from the redesign we\'ve got Karma back as well as a new Special Offers feature.')
 ,(9,11,'http://www.concrete5.org/about/blog/concrete5-sightings/wow-concrete5-org-is-totally-new/',NULL,'2011-01-13 01:14:00',0,0,'Clevyr.com helps redesign concrete5.org!','You\'ve got to check this out.','You\'ve got to check this out.')
 ,(10,11,'http://www.concrete5.org/about/blog/concrete5-sightings/concrete5-featured-as-system-to-watch/',NULL,'2010-12-14 23:25:00',0,0,'concrete5 featured as &quot;System to Watch&quot;','2010 Open Source CMS Market Share Report Lists concrete5 as Growing Fast','2010 Open Source CMS Market Share Report Lists concrete5 as Growing Fast')
 ,(11,11,'http://www.concrete5.org/about/blog/concrete5-sightings/developer-bundle-deal-at-massive-discount/',NULL,'2010-12-14 23:23:00',0,0,'Developer Bundle Deal at Massive Discount','Get a whole pile of add-ons and themes for one tiny price at c5bundle.net.','Get a whole pile of add-ons and themes for one tiny price at c5bundle.net.')
 ,(12,11,'http://www.concrete5.org/about/blog/concrete5-sightings/developer-introduction-with-derek-allard/',NULL,'2010-12-07 21:07:00',0,1,'Developer Introduction with Derek Allard','We take Derek Allard (ExpressionEngine, CodeIgniter, MojoMotor) through the basics of what concrete5 can do and how it\'s put together.','We take Derek Allard (ExpressionEngine, CodeIgniter, MojoMotor) through the basics of what concrete5 can do and how it\'s put together.')
 ,(13,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-nobility/',NULL,'2011-01-29 02:13:24',0,0,'Theme Approved: Nobility','<p>A Nobile theme with hidden menus and built in styling</p><p><a href=\"http://www.concrete5.org/marketplace/themes/nobility/\">View this item in the marketplace.</a></p>','<p>A Nobile theme with hidden menus and built in styling</p><p><a href=\"http://www.concrete5.org/marketplace/themes/nobility/\">View this item in the marketplace.</a></p>')
 ,(14,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-versatility/',NULL,'2011-01-28 02:06:40',0,0,'Theme Approved: Versatility','<p>A versatile theme for concrete5</p><p><a href=\"http://www.concrete5.org/marketplace/themes/versatility/\">View this item in the marketplace.</a></p>','<p>A versatile theme for concrete5</p><p><a href=\"http://www.concrete5.org/marketplace/themes/versatility/\">View this item in the marketplace.</a></p>')
 ,(15,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-quick-loader/',NULL,'2011-01-28 01:37:04',0,0,'Theme Approved: Quick Loader','<p>Sharp and modern style with with multiple columns on multiple rows to suit all Concrete5 sites and your needs.</p><p><a href=\"http://www.concrete5.org/marketplace/themes/quick-loader/\">View this item in the marketplace.</a></p>','<p>Sharp and modern style with with multiple columns on multiple rows to suit all Concrete5 sites and your needs.</p><p><a href=\"http://www.concrete5.org/marketplace/themes/quick-loader/\">View this item in the marketplace.</a></p>')
 ,(16,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-serendipity/',NULL,'2011-01-28 01:34:03',0,0,'Theme Approved: Serendipity','<p>Sleek Black theme with chromatic hightlights</p><p><a href=\"http://www.concrete5.org/marketplace/themes/serendipity/\">View this item in the marketplace.</a></p>','<p>Sleek Black theme with chromatic hightlights</p><p><a href=\"http://www.concrete5.org/marketplace/themes/serendipity/\">View this item in the marketplace.</a></p>')
 ,(17,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-hostingtheme/',NULL,'2011-01-28 01:30:45',0,1,'Theme Approved: HostingTheme','<p>A dark, clean, and professional theme that is excellent for a hosting company or any other business.</p><p><a href=\"http://www.concrete5.org/marketplace/themes/hostingtheme/\">View this item in the marketplace.</a></p>','<p>A dark, clean, and professional theme that is excellent for a hosting company or any other business.</p><p><a href=\"http://www.concrete5.org/marketplace/themes/hostingtheme/\">View this item in the marketplace.</a></p>')
 ,(18,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-full-moon/',NULL,'2011-02-23 21:09:04',0,0,'Theme Approved: Full Moon','<p>A nature inspired theme</p><p><a href=\"http://www.concrete5.org/marketplace/themes/full-moon/\">View this item in the marketplace.</a></p>','<p>A nature inspired theme</p><p><a href=\"http://www.concrete5.org/marketplace/themes/full-moon/\">View this item in the marketplace.</a></p>')
 ,(19,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-link-tracking/',NULL,'2011-02-21 22:54:04',0,0,'Add-on Approved: Link Tracking','<p>Track every external link on your website automatically. You do not need to add anything to your code. The add-on will do everything automatically.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/link-tracking/\">View this item in the marketplace.</a></p>','<p>Track every external link on your website automatically. You do not need to add anything to your code. The add-on will do everything automatically.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/link-tracking/\">View this item in the marketplace.</a></p>')
 ,(20,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-simplicity-theme/',NULL,'2011-02-21 22:49:35',0,0,'Theme Approved: Simplicity Theme','<p>Simplicity is the key to success!</p><p><a href=\"http://www.concrete5.org/marketplace/themes/simplicity-theme/\">View this item in the marketplace.</a></p>','<p>Simplicity is the key to success!</p><p><a href=\"http://www.concrete5.org/marketplace/themes/simplicity-theme/\">View this item in the marketplace.</a></p>')
 ,(21,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-properties/',NULL,'2011-02-21 22:45:50',0,0,'Add-on Approved: Properties','<p>Manage real estate listings on your website</p><p><a href=\"http://www.concrete5.org/marketplace/addons/properties/\">View this item in the marketplace.</a></p>','<p>Manage real estate listings on your website</p><p><a href=\"http://www.concrete5.org/marketplace/addons/properties/\">View this item in the marketplace.</a></p>')
 ,(22,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-raptorize/',NULL,'2011-02-21 22:31:25',0,1,'Add-on Approved: Raptorize','<p>Instantly make your website the best in the world! Have a RAPTOR fly across your screen!</p><p><a href=\"http://www.concrete5.org/marketplace/addons/raptorize/\">View this item in the marketplace.</a></p>','<p>Instantly make your website the best in the world! Have a RAPTOR fly across your screen!</p><p><a href=\"http://www.concrete5.org/marketplace/addons/raptorize/\">View this item in the marketplace.</a></p>')
 ,(23,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-ustream-status-simple/',NULL,'2011-03-04 18:42:36',0,0,'Add-on Approved: Ustream Status - Simple','<p>Display live or offline status of a desired Ustream channel</p><p><a href=\"http://www.concrete5.org/marketplace/addons/ustream-status-simple/\">View this item in the marketplace.</a></p>','<p>Display live or offline status of a desired Ustream channel</p><p><a href=\"http://www.concrete5.org/marketplace/addons/ustream-status-simple/\">View this item in the marketplace.</a></p>')
 ,(24,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-webby-2-0/',NULL,'2011-03-08 02:45:14',0,0,'Theme Approved: Webby 2.0','<p>Webby is a brilliant, web 2.0 style theme for Concrete5</p><p><a href=\"http://www.concrete5.org/marketplace/themes/webby-2-0/\">View this item in the marketplace.</a></p>','<p>Webby is a brilliant, web 2.0 style theme for Concrete5</p><p><a href=\"http://www.concrete5.org/marketplace/themes/webby-2-0/\">View this item in the marketplace.</a></p>')
 ,(25,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-bookmark/',NULL,'2011-03-09 01:30:41',0,0,'Theme Approved: Bookmark','<p>Writers styled theme for wordsmiths</p><p><a href=\"http://www.concrete5.org/marketplace/themes/bookmark/\">View this item in the marketplace.</a></p>','<p>Writers styled theme for wordsmiths</p><p><a href=\"http://www.concrete5.org/marketplace/themes/bookmark/\">View this item in the marketplace.</a></p>')
 ,(26,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-deepit-slider/',NULL,'2011-03-09 01:22:11',0,0,'Add-on Approved: DeepIt Slider','<p>A slider that give to websites\' users a amazing live-background experience.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/deepit-slider/\">View this item in the marketplace.</a></p>','<p>A slider that give to websites\' users a amazing live-background experience.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/deepit-slider/\">View this item in the marketplace.</a></p>')
 ,(27,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-dropdown-box/',NULL,'2011-03-09 01:13:36',0,0,'Add-on Approved: Dropdown Box','<p>A simple Header dropdown box</p><p><a href=\"http://www.concrete5.org/marketplace/addons/dropdown-box/\">View this item in the marketplace.</a></p>','<p>A simple Header dropdown box</p><p><a href=\"http://www.concrete5.org/marketplace/addons/dropdown-box/\">View this item in the marketplace.</a></p>')
 ,(28,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-users-pages/',NULL,'2011-03-09 00:32:54',0,0,'Add-on Approved: Users\' Pages','<p>Displays a list of pages a user can edit, approve, delete, or view.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/users-pages/\">View this item in the marketplace.</a></p>','<p>Displays a list of pages a user can edit, approve, delete, or view.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/users-pages/\">View this item in the marketplace.</a></p>')
 ,(29,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-vertical-content/',NULL,'2011-03-09 00:24:57',0,1,'Add-on Approved: Vertical Content','<p>Flip your text vertically in both directions. Works in all browsers.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/vertical-content/\">View this item in the marketplace.</a></p>','<p>Flip your text vertically in both directions. Works in all browsers.</p><p><a href=\"http://www.concrete5.org/marketplace/addons/vertical-content/\">View this item in the marketplace.</a></p>')
 ,(30,11,'http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-ecommerce-ideal-payments/',NULL,'2011-03-09 22:38:27',0,0,'Add-on Approved: eCommerce - iDEAL Payments','<p>Accept Payments using Mollie\'s iDEAL Payment Gateway</p><p><a href=\"http://www.concrete5.org/marketplace/addons/ecommerce-ideal-payments/\">View this item in the marketplace.</a></p>','<p>Accept Payments using Mollie\'s iDEAL Payment Gateway</p><p><a href=\"http://www.concrete5.org/marketplace/addons/ecommerce-ideal-payments/\">View this item in the marketplace.</a></p>')
 ,(31,11,'http://www.concrete5.org/about/blog/theme-releases/theme-approved-rosecrete/',NULL,'2011-03-09 22:23:57',0,0,'Theme Approved: ROSEcrete','<p>A romantic / floral theme! BONUS INCLUDED!</p><p><a href=\"http://www.concrete5.org/marketplace/themes/rosecrete/\">View this item in the marketplace.</a></p>','<p>A romantic / floral theme! BONUS INCLUDED!</p><p><a href=\"http://www.concrete5.org/marketplace/themes/rosecrete/\">View this item in the marketplace.</a></p>');


CREATE TABLE IF NOT EXISTS `TaskPermissionUserGroups` (
  `tpID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `canRead` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tpID`,`gID`,`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `TaskPermissions` (
  `tpID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tpHandle` varchar(255) DEFAULT NULL,
  `tpName` varchar(255) DEFAULT NULL,
  `tpDescription` text,
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tpID`),
  UNIQUE KEY `tpHandle` (`tpHandle`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

INSERT INTO TaskPermissions VALUES(1,'access_task_permissions','Change Task Permissions','',0)
 ,(2,'access_sitemap','Access Sitemap and Page Search','',0)
 ,(3,'access_user_search','Access User Search','',0)
 ,(4,'access_group_search','Access Group Search','',0)
 ,(5,'access_page_defaults','Change Content on Page Type Default Pages','',0)
 ,(6,'backup','Perform Full Database Backups','',0)
 ,(7,'sudo','Sign in as User','',0)
 ,(8,'uninstall_packages','Uninstall Packages','',0);


CREATE TABLE IF NOT EXISTS `UserAttributeKeys` (
  `akID` int(10) unsigned NOT NULL,
  `uakProfileDisplay` tinyint(1) NOT NULL DEFAULT '0',
  `uakMemberListDisplay` tinyint(1) NOT NULL DEFAULT '0',
  `uakProfileEdit` tinyint(1) NOT NULL DEFAULT '1',
  `uakProfileEditRequired` tinyint(1) NOT NULL DEFAULT '0',
  `uakRegisterEdit` tinyint(1) NOT NULL DEFAULT '0',
  `uakRegisterEditRequired` tinyint(1) NOT NULL DEFAULT '0',
  `displayOrder` int(10) unsigned DEFAULT '0',
  `uakIsActive` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserAttributeValues` (
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `avID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uID`,`akID`,`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserBannedIPs` (
  `ipFrom` int(10) unsigned NOT NULL DEFAULT '0',
  `ipTo` int(10) unsigned NOT NULL DEFAULT '0',
  `banCode` int(1) unsigned NOT NULL DEFAULT '1',
  `expires` int(10) unsigned NOT NULL DEFAULT '0',
  `isManual` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ipFrom`,`ipTo`),
  KEY `ipFrom` (`ipFrom`),
  KEY `ipTo` (`ipTo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserGroups` (
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `ugEntered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`uID`,`gID`),
  KEY `uID` (`uID`),
  KEY `gID` (`gID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserOpenIDs` (
  `uID` int(10) unsigned NOT NULL,
  `uOpenID` varchar(255) NOT NULL,
  PRIMARY KEY (`uOpenID`),
  KEY `uID` (`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserPrivateMessages` (
  `msgID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uAuthorID` int(10) unsigned NOT NULL DEFAULT '0',
  `msgDateCreated` datetime NOT NULL,
  `msgSubject` varchar(255) NOT NULL,
  `msgBody` text,
  `uToID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`msgID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserPrivateMessagesTo` (
  `msgID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `uAuthorID` int(10) unsigned NOT NULL DEFAULT '0',
  `msgMailboxID` int(11) NOT NULL,
  `msgIsNew` int(1) NOT NULL DEFAULT '0',
  `msgIsUnread` int(1) NOT NULL DEFAULT '0',
  `msgIsReplied` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`msgID`,`uID`,`uAuthorID`),
  KEY `uID` (`uID`),
  KEY `uAuthorID` (`uAuthorID`),
  KEY `msgFolderID` (`msgMailboxID`),
  KEY `msgIsNew` (`msgIsNew`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserSearchIndexAttributes` (
  `uID` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `UserValidationHashes` (
  `uvhID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uID` int(10) unsigned DEFAULT NULL,
  `uHash` varchar(64) NOT NULL,
  `type` int(4) unsigned NOT NULL DEFAULT '0',
  `uDateGenerated` int(10) unsigned NOT NULL DEFAULT '0',
  `uDateRedeemed` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uvhID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `Users` (
  `uID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uName` varchar(64) NOT NULL,
  `uEmail` varchar(64) NOT NULL,
  `uPassword` varchar(255) NOT NULL,
  `uIsActive` varchar(1) NOT NULL DEFAULT '0',
  `uIsValidated` tinyint(4) NOT NULL DEFAULT '-1',
  `uIsFullRecord` tinyint(1) NOT NULL DEFAULT '1',
  `uDateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `uHasAvatar` tinyint(1) NOT NULL DEFAULT '0',
  `uLastOnline` int(10) unsigned NOT NULL DEFAULT '0',
  `uLastLogin` int(10) unsigned NOT NULL DEFAULT '0',
  `uPreviousLogin` int(10) unsigned NOT NULL DEFAULT '0',
  `uNumLogins` int(10) unsigned NOT NULL DEFAULT '0',
  `uTimezone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uID`),
  UNIQUE KEY `uName` (`uName`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO Users VALUES(1,'admin','christian.merour@yahoo.fr','ec18bb2074b72371033a5f79f3e0ebe7','1',-1,1,'2010-11-09 00:05:22',0,1299849158,1299789178,1299753245,60,NULL);


CREATE TABLE IF NOT EXISTS `UsersFriends` (
  `ufID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uID` int(10) unsigned DEFAULT NULL,
  `status` varchar(64) NOT NULL,
  `friendUID` int(10) unsigned DEFAULT NULL,
  `uDateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ufID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `atAddress` (
  `avID` int(10) unsigned NOT NULL DEFAULT '0',
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_province` varchar(255) DEFAULT NULL,
  `country` varchar(4) DEFAULT NULL,
  `postal_code` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `atAddressCustomCountries` (
  `atAddressCustomCountryID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `country` varchar(5) NOT NULL,
  PRIMARY KEY (`atAddressCustomCountryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `atAddressSettings` (
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `akHasCustomCountries` int(1) NOT NULL DEFAULT '0',
  `akDefaultCountry` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `atBoolean` (
  `avID` int(10) unsigned NOT NULL,
  `value` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO atBoolean VALUES(146,0)
 ,(142,0)
 ,(130,0)
 ,(177,1)
 ,(138,0)
 ,(120,0)
 ,(182,0)
 ,(267,0)
 ,(312,1)
 ,(172,0)
 ,(173,0)
 ,(178,1)
 ,(183,0)
 ,(187,0)
 ,(188,0)
 ,(192,0)
 ,(193,0)
 ,(308,0)
 ,(307,0)
 ,(398,0)
 ,(313,1)
 ,(207,1)
 ,(208,1)
 ,(212,0)
 ,(213,0)
 ,(217,0)
 ,(218,0)
 ,(222,0)
 ,(223,0)
 ,(227,1)
 ,(228,1)
 ,(232,0)
 ,(233,0)
 ,(237,0)
 ,(238,0)
 ,(242,0)
 ,(243,0)
 ,(247,0)
 ,(248,0)
 ,(252,0)
 ,(253,0)
 ,(257,0)
 ,(258,0)
 ,(262,0)
 ,(263,0)
 ,(268,0)
 ,(393,0)
 ,(392,0)
 ,(378,0)
 ,(377,0)
 ,(388,0)
 ,(387,0)
 ,(383,0)
 ,(382,0)
 ,(292,0)
 ,(293,0)
 ,(303,0)
 ,(302,0)
 ,(397,0)
 ,(358,0)
 ,(357,0)
 ,(363,0)
 ,(362,0)
 ,(368,0)
 ,(367,0)
 ,(373,0)
 ,(372,0)
 ,(342,1)
 ,(343,1)
 ,(347,0)
 ,(348,0)
 ,(352,1)
 ,(353,1)
 ,(402,0)
 ,(403,1)
 ,(407,0)
 ,(408,1)
 ,(412,0)
 ,(413,1)
 ,(423,0)
 ,(422,1)
 ,(427,1)
 ,(428,1)
 ,(432,0)
 ,(433,0)
 ,(437,0)
 ,(438,0)
 ,(442,0)
 ,(443,0)
 ,(447,0)
 ,(448,1)
 ,(452,0)
 ,(453,1)
 ,(457,0)
 ,(458,0)
 ,(462,0)
 ,(463,0)
 ,(467,0)
 ,(468,0)
 ,(472,0)
 ,(473,0)
 ,(477,0)
 ,(478,0)
 ,(484,0)
 ,(485,0)
 ,(489,0)
 ,(490,1)
 ,(494,0)
 ,(495,1)
 ,(499,0)
 ,(500,0)
 ,(504,1)
 ,(505,1)
 ,(509,0)
 ,(510,0)
 ,(514,0)
 ,(515,0)
 ,(519,1)
 ,(520,1)
 ,(544,0)
 ,(543,0)
 ,(554,0)
 ,(553,0)
 ,(549,0)
 ,(548,0)
 ,(558,0)
 ,(559,1);


CREATE TABLE IF NOT EXISTS `atBooleanSettings` (
  `akID` int(10) unsigned NOT NULL,
  `akCheckedByDefault` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO atBooleanSettings VALUES(14,0)
 ,(17,0);


CREATE TABLE IF NOT EXISTS `atDateTime` (
  `avID` int(10) unsigned NOT NULL,
  `value` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `atDateTimeSettings` (
  `akID` int(10) unsigned NOT NULL,
  `akDateDisplayMode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `atDefault` (
  `avID` int(10) unsigned NOT NULL,
  `value` longtext,
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO atDefault VALUES(137,'')
 ,(136,'')
 ,(135,'Welcome')
 ,(174,'')
 ,(175,'')
 ,(145,'')
 ,(143,'Secteur Terrestre')
 ,(141,'')
 ,(144,'')
 ,(128,'Ma description de page')
 ,(127,'Mon titre meta')
 ,(140,'')
 ,(139,'Secteur Marine')
 ,(129,'mes mots clé')
 ,(117,'Mon titre meta')
 ,(118,'Ma description de page')
 ,(119,'mes mots clé')
 ,(181,'')
 ,(180,'')
 ,(179,'')
 ,(264,'Equipements Mobiles')
 ,(311,'')
 ,(310,'')
 ,(309,'')
 ,(169,'')
 ,(170,'')
 ,(171,'')
 ,(176,'')
 ,(184,'Secteur Marine')
 ,(185,'')
 ,(186,'')
 ,(189,'Secteur Terrestre')
 ,(190,'')
 ,(191,'')
 ,(305,'')
 ,(304,'Accueil Marine')
 ,(394,'Page d\'accueil du site français')
 ,(395,'')
 ,(204,'')
 ,(205,'')
 ,(206,'')
 ,(209,'')
 ,(210,'')
 ,(211,'')
 ,(214,'')
 ,(215,'')
 ,(216,'')
 ,(219,'')
 ,(220,'')
 ,(221,'')
 ,(224,'')
 ,(225,'')
 ,(226,'')
 ,(229,'')
 ,(230,'')
 ,(231,'')
 ,(234,'')
 ,(235,'')
 ,(236,'')
 ,(239,'')
 ,(240,'')
 ,(241,'')
 ,(244,'')
 ,(245,'')
 ,(246,'')
 ,(249,'')
 ,(250,'')
 ,(251,'')
 ,(254,'')
 ,(255,'')
 ,(256,'')
 ,(259,'')
 ,(260,'')
 ,(261,'')
 ,(265,'')
 ,(266,'')
 ,(391,'')
 ,(390,'')
 ,(389,'')
 ,(376,'')
 ,(375,'')
 ,(374,'')
 ,(386,'')
 ,(385,'')
 ,(384,'')
 ,(381,'')
 ,(380,'')
 ,(379,'')
 ,(289,'Equipements fixes')
 ,(290,'')
 ,(291,'')
 ,(300,'')
 ,(299,'Services')
 ,(301,'')
 ,(306,'')
 ,(356,'')
 ,(355,'')
 ,(354,'')
 ,(361,'')
 ,(360,'')
 ,(359,'')
 ,(366,'')
 ,(365,'')
 ,(364,'')
 ,(371,'')
 ,(370,'')
 ,(369,'')
 ,(339,'Secteurs')
 ,(340,'')
 ,(341,'')
 ,(344,'Construction navale')
 ,(345,'')
 ,(346,'')
 ,(349,'Secteurs')
 ,(350,'')
 ,(351,'')
 ,(396,'')
 ,(399,'Secteur Marine')
 ,(400,'')
 ,(401,'')
 ,(404,'Secteur Terrestre')
 ,(405,'')
 ,(406,'')
 ,(409,'Equipements Mobiles')
 ,(410,'')
 ,(411,'')
 ,(421,'')
 ,(420,'')
 ,(419,'Home')
 ,(424,'')
 ,(425,'')
 ,(426,'')
 ,(429,'Home')
 ,(430,'')
 ,(431,'')
 ,(434,'Home')
 ,(435,'')
 ,(436,'')
 ,(439,'Home')
 ,(440,'')
 ,(441,'')
 ,(444,'')
 ,(445,'')
 ,(446,'')
 ,(449,'')
 ,(450,'')
 ,(451,'')
 ,(454,'Page d\'accueil du site français')
 ,(455,'')
 ,(456,'')
 ,(459,'Page d\'accueil du site français')
 ,(460,'')
 ,(461,'')
 ,(464,'')
 ,(465,'')
 ,(466,'')
 ,(469,'')
 ,(470,'')
 ,(471,'')
 ,(474,'Equipements Mobiles')
 ,(475,'')
 ,(476,'')
 ,(481,'')
 ,(482,'')
 ,(483,'')
 ,(486,'')
 ,(487,'')
 ,(488,'')
 ,(491,'')
 ,(492,'')
 ,(493,'')
 ,(496,'')
 ,(497,'')
 ,(498,'')
 ,(501,'')
 ,(502,'')
 ,(503,'')
 ,(506,'')
 ,(507,'')
 ,(508,'')
 ,(511,'')
 ,(512,'')
 ,(513,'')
 ,(516,'')
 ,(517,'')
 ,(518,'')
 ,(542,'')
 ,(541,'')
 ,(540,'')
 ,(552,'')
 ,(551,'')
 ,(550,'')
 ,(547,'')
 ,(546,'')
 ,(545,'')
 ,(555,'')
 ,(556,'')
 ,(557,'');


CREATE TABLE IF NOT EXISTS `atFile` (
  `avID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `atNumber` (
  `avID` int(10) unsigned NOT NULL,
  `value` decimal(14,4) DEFAULT '0.0000',
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO atNumber VALUES(1,800.0000)
 ,(2,192.0000)
 ,(3,800.0000)
 ,(4,192.0000)
 ,(5,800.0000)
 ,(6,192.0000)
 ,(7,800.0000)
 ,(8,215.0000)
 ,(9,800.0000)
 ,(10,192.0000)
 ,(46,1024.0000)
 ,(47,768.0000)
 ,(48,1024.0000)
 ,(49,768.0000)
 ,(50,1024.0000)
 ,(51,768.0000)
 ,(52,768.0000)
 ,(53,1024.0000)
 ,(54,640.0000)
 ,(55,480.0000)
 ,(56,600.0000)
 ,(57,300.0000)
 ,(58,600.0000)
 ,(59,300.0000)
 ,(60,600.0000)
 ,(61,300.0000)
 ,(62,216.0000)
 ,(63,94.0000)
 ,(64,237.0000)
 ,(65,148.0000)
 ,(66,264.0000)
 ,(67,142.0000)
 ,(74,233.0000)
 ,(75,392.0000)
 ,(76,233.0000)
 ,(77,392.0000)
 ,(86,36.0000)
 ,(87,36.0000)
 ,(88,36.0000)
 ,(89,36.0000)
 ,(90,140.0000)
 ,(91,120.0000)
 ,(92,36.0000)
 ,(93,36.0000)
 ,(94,36.0000)
 ,(95,36.0000)
 ,(96,36.0000)
 ,(97,36.0000)
 ,(98,36.0000)
 ,(99,36.0000)
 ,(100,36.0000)
 ,(101,36.0000)
 ,(102,36.0000)
 ,(103,36.0000)
 ,(104,36.0000)
 ,(105,36.0000)
 ,(106,36.0000)
 ,(107,36.0000)
 ,(147,216.0000)
 ,(148,94.0000)
 ,(149,237.0000)
 ,(150,148.0000)
 ,(151,264.0000)
 ,(152,142.0000)
 ,(153,36.0000)
 ,(154,36.0000)
 ,(155,36.0000)
 ,(156,36.0000)
 ,(479,84.0000)
 ,(480,86.0000)
 ,(536,36.0000)
 ,(537,36.0000)
 ,(538,36.0000)
 ,(539,36.0000);


CREATE TABLE IF NOT EXISTS `atSelectOptions` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `akID` int(10) unsigned DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `displayOrder` int(10) unsigned DEFAULT NULL,
  `isEndUserAdded` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO atSelectOptions VALUES(1,11,'sample',0,1)
 ,(2,11,'Hello World',1,1)
 ,(3,11,'test',2,1)
 ,(4,11,'test 2',3,1)
 ,(5,11,'test 3',4,1);


CREATE TABLE IF NOT EXISTS `atSelectOptionsSelected` (
  `avID` int(10) unsigned NOT NULL,
  `atSelectOptionID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`avID`,`atSelectOptionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO atSelectOptionsSelected VALUES(68,3)
 ,(68,4)
 ,(68,5)
 ,(69,3)
 ,(69,4)
 ,(69,5);


CREATE TABLE IF NOT EXISTS `atSelectSettings` (
  `akID` int(10) unsigned NOT NULL,
  `akSelectAllowMultipleValues` tinyint(1) NOT NULL DEFAULT '0',
  `akSelectOptionDisplayOrder` varchar(255) NOT NULL DEFAULT 'display_asc',
  `akSelectAllowOtherValues` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO atSelectSettings VALUES(11,1,'display_asc',1);


CREATE TABLE IF NOT EXISTS `atTextareaSettings` (
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `akTextareaDisplayMode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btContentAroundImage` (
  `bID` int(10) unsigned NOT NULL,
  `content` longtext,
  `fID` int(10) unsigned DEFAULT '0',
  `link` varchar(255) DEFAULT NULL,
  `newTab` tinyint(4) DEFAULT '0',
  `altText` varchar(255) DEFAULT NULL,
  `maxWidth` int(10) unsigned DEFAULT '0',
  `maxHeight` int(10) unsigned DEFAULT '0',
  `alignment` int(10) unsigned DEFAULT '0',
  `caption` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btContentAroundImage VALUES(46,'<p>dwvfxwcbwxcvxw</p>\r\n<p>cvw</p>\r\n<p>xcvxwcvwxcvwxcvwxc</p>\r\n<p>vwxcvwxcvwxcv</p>\r\n<p>wxc</p>\r\n<p>vwxc</p>\r\n<p>vw</p>\r\n<p>xcv</p>',5,'',0,'Alt text',50,50,0,'Caption')
 ,(348,'<p>Notre savoir-faire le plus ancien est celui de la Marine, initi&eacute; par Charles Basset en 1986 dans le pays de Cornouaille et le pays Bigouden (Finist&egrave;re sud).<br />Nous avons constamment adapt&eacute; nos m&eacute;thodes de travail aux besoins et aux attentes de la Marine.</p>',29,'',0,'Bateaux',0,0,0,'')
 ,(349,'<p>Notre savoir-faire le plus ancien est celui de la Marine, initi&eacute; par Charles Basset en 1986 dans le <strong>pays de Cornouaille</strong> et le <em>pays Bigouden (Finist&egrave;re sud)</em>.<br />Nous avons constamment adapt&eacute; nos m&eacute;thodes de travail aux besoins et aux attentes de la <strong>Marine</strong>.</p>\r\n<p>Nous intervenons sur la c&ocirc;te atlantique de Brest &agrave; Arcachon et depuis quelques ann&eacute;es pour des chantiers &agrave;&nbsp; l&rsquo;international (<strong>Vietnam, Nig&eacute;ria, Seychelles</strong>).</p>\r\n<p>Cette expertise, nous l&rsquo;avons transpos&eacute;e au milieu <strong>Terrestre</strong> d&egrave;s 1995 afin de proposer nos <strong>services de proximit&eacute;</strong>. Nous intervenons sur le <strong>Finist&egrave;re</strong>, le <strong>Morbihan </strong>et les <strong>C&ocirc;tes d&rsquo;Armor</strong>.</p>',29,'',0,'Bateaux',0,0,0,'')
 ,(353,'<p style=\"text-align: justify;\">Notre savoir-faire le plus ancien est celui de la Marine, initi&eacute; par Charles Basset en 1986 dans le <strong>pays de Cornouaille</strong> et le <em>pays Bigouden (Finist&egrave;re sud)</em>.<br />Nous avons constamment adapt&eacute; nos m&eacute;thodes de travail aux besoins et aux attentes de la <strong>Marine</strong>.</p>\r\n<p style=\"text-align: justify;\">Nous intervenons sur la c&ocirc;te atlantique de Brest &agrave; Arcachon et depuis quelques ann&eacute;es pour des chantiers &agrave;&nbsp; l&rsquo;international (<strong>Vietnam, Nig&eacute;ria, Seychelles</strong>).</p>\r\n<p style=\"text-align: justify;\">Cette expertise, nous l&rsquo;avons transpos&eacute;e au milieu <strong>Terrestre</strong> d&egrave;s 1995 afin de proposer nos <strong>services de proximit&eacute;</strong>. Nous intervenons sur le <strong>Finist&egrave;re</strong>, le <strong>Morbihan </strong>et les <strong>C&ocirc;tes d&rsquo;Armor</strong>.</p>',29,'',0,'Bateaux',0,0,0,'');


CREATE TABLE IF NOT EXISTS `btContentFile` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `fileLinkText` varchar(255) DEFAULT NULL,
  `filePassword` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btContentImage` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT '0',
  `fOnstateID` int(10) unsigned DEFAULT '0',
  `maxWidth` int(10) unsigned DEFAULT '0',
  `maxHeight` int(10) unsigned DEFAULT '0',
  `externalLink` varchar(255) DEFAULT NULL,
  `altText` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btContentImage VALUES(63,11,0,0,0,'http://127.0.0.1/concrete5pic29','Logo du Protection Incendie Cornouaille')
 ,(64,11,0,0,0,'http://127.0.0.1/concrete5pic29','Logo du Protection Incendie Cornouaille')
 ,(70,12,0,0,0,'','')
 ,(71,13,0,0,0,'','')
 ,(243,18,0,100,100,'http://www.adobe.com/jp/events/cs3_web_edition_tour/swfs/perform.swf','test')
 ,(310,28,0,0,40,'','');


CREATE TABLE IF NOT EXISTS `btContentLocal` (
  `bID` int(10) unsigned NOT NULL,
  `content` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btContentLocal VALUES(4,'<h2>Sidebar</h2>\r\n<p>Everything about concrete5 is completely customizable through the CMS. This is a separate area from the main content on the homepage. You can&nbsp;<a title=\"Move blocks in concrete5\" href=\"http://www.concrete5.org/documentation/general-topics/blocks-and-areas\" target=\"_blank\">drag and drop blocks</a>&nbsp;like this around your layout.</p>\r\n<p>&nbsp;</p>')
 ,(5,'<h1>Welcome to concrete5 - an Open Source CMS</h1>\r\n<p>Content Management is easy with concrete5\'s in-context editing. Just&nbsp;<a title=\"Login\" href=\"/index.php/login\">login</a>&nbsp;and you can add and change things as you browse your site.&nbsp;</p>\r\n<p>Here\'s some videos you can watch learn how to:</p>\r\n<ul>\r\n<li><a title=\"In-context editing CMS\" href=\"http://www.concrete5.org/documentation/general-topics/in-context-editing/\">Edit</a>&nbsp;this page.</li>\r\n<li>Add a&nbsp;<a title=\"Add a page in concrete5\" href=\"http://www.concrete5.org/documentation/general-topics/add-a-page/\" target=\"_blank\">new page</a>.</li>\r\n<li>Add some basic functionality, like&nbsp;<a title=\"Add a simple form in concrete5\" href=\"http://www.concrete5.org/documentation/general-topics/add_a_form\" target=\"_blank\">a Form</a>.</li>\r\n<li><a title=\"add-on marketplace for concrete5\" href=\"http://www.concrete5.org/marketplace/how_to_install_add_ons_and_themes_/\" target=\"_blank\">Finding &amp; adding</a>&nbsp;more functionality and themes.</li>\r\n</ul>\r\n<p>We\'ve taken the liberty to build out the rest of this site with some sample content that will help you learn concrete5. Wander around a bit, or just goto the&nbsp;<a title=\"Sitemap\" href=\"/index.php/dashboard/sitemap/full/\">Dashboard &gt; Sitemap</a>&nbsp;and delete the parts you don\'t want quickly.</p>\r\n<p>&nbsp;</p>')
 ,(58,'<p><a title=\"Adding a New Post\" href=\"{CCM:CID_73}\">Adding a New Post</a></p>')
 ,(59,'<p><a title=\"Adding a New Post\" href=\"{CCM:CID_73}\">Adding a New Post</a></p>')
 ,(60,'<p>xcvbxcvbx</p>\r\n<p>&nbsp;</p>\r\n<p>xcvbxcvb</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p><a class=\"test\" title=\"Adding a New Post\" href=\"{CCM:CID_73}\">Adding a New Post</a>dvb</p>\r\n<p>vxcv</p>\r\n<p>vc</p>')
 ,(61,'<p>xcvbxcvbx</p>\r\n<p>&nbsp;</p>\r\n<p>xcvbxcvb</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p><a class=\"test\" title=\"Adding a New Post\" href=\"{CCM:CID_73}\">Adding a New Post</a>dvb</p>\r\n<p>vxcv</p>\r\n<p>vc</p>')
 ,(62,'<p><a title=\"Search\" href=\"{CCM:CID_67}\">Search</a></p>')
 ,(72,'<h1><a title=\"Guestbook\" href=\"{CCM:CID_70}\">SOLUTIONS INCENDIE <br /><strong>TERRESTRE</strong></a></h1>\r\n<ul>\r\n<li>Bureaux d&rsquo;&eacute;tudes</li>\r\n<li>Industries</li>\r\n<li>Entreprises</li>\r\n<li>&Eacute;tablissements Recevant du Public (ERP)</li>\r\n<li>Collectivit&eacute;s</li>\r\n<li>Immobilier</li>\r\n</ul>')
 ,(167,'<p>Mon text de test</p>')
 ,(169,'<H1>Marine</H1>')
 ,(172,'<h3 style=\"text-align: center;\"><span style=\"color: #19565f;\">Solutions Incendie</span></h3>\r\n<h2 style=\"text-align: center;\"><span style=\"color: #19565f;\">Marine</span></h2>')
 ,(138,'<p><a title=\"Home\" href=\"{CCM:CID_1}\">page1</a></p>\r\n<p><a title=\"Home\" href=\"{CCM:CID_1}\">page2</a></p>\r\n<p><a title=\"Home\" href=\"{CCM:CID_1}\">page3</a></p>')
 ,(173,'<div style=\"margin-top:30px; text-align: center; color: #19565f; font-weight:bold\">\r\n\r\n    <span style=\"font-size: 18px;\">Solutions Incendie</span>\r\n<br /> \r\n<span style=\"font-size: 20px;\">   Marine</span>\r\n</div>')
 ,(174,'<div style=\"margin-top:30px; text-align: center; color: #19565f; font-weight:bold\">\r\n<span style=\"font-size: 20px;\">\r\n\r\nSolutions Incendie\r\n\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\n\r\nMarine\r\n\r\n</span>\r\n</div>')
 ,(179,'<p style=\"text-align: center;\">Protection Incendie Cornouaille - BP 220 - 15 Rue des Thoniers - Quai Est - 29182 Concarneau cedex</p>\r\n<p style=\"text-align: center;\">T&eacute;l&eacute;phone : (33)-(0)2.97.97.01.65 &gt;T&eacute;l&eacute;copie (33)-(0)2.98.50.84.20 &gt; courriel : info@pic29.com</p>')
 ,(180,'<p><a title=\"Blog\" href=\"{CCM:CID_71}\">Mentions l&eacute;gales</a> - <a title=\"About\" href=\"{CCM:CID_69}\">Protection des Donn&eacute;es</a> - <a title=\"Search\" href=\"{CCM:CID_67}\">Plan du Site </a>- <a title=\"Members\" href=\"{CCM:CID_74}\">Recrutement</a></p>')
 ,(187,'<h2>Installations fixes d\'extinction</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<h2>Installations fixes d\'extinction par Gaz</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<h2>Installation Fixe d\'extinction par Eau</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>')
 ,(188,'<h1>H1H1H1</h1>\r\n<h2>H2H2H2</h2>\r\n<h3>H3H3H3</h3>\r\n<h4>H4H4H4</h4>\r\n<h5>H5H5H5</h5>\r\n<h6>H6H6H6</h6>\r\n<p>sdfgsdfgsdfh dfs s df dfg</p>\r\n<h2>Installations fixes d\'extinction</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<h2>Installations fixes d\'extinction par Gaz</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<h2>Installation Fixe d\'extinction par Eau</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>')
 ,(189,'<h1>H1H1H1</h1>\r\n<h2>H2H2H2</h2>\r\n<h3>H3H3H3</h3>\r\n<h4>H4H4H4</h4>\r\n<h5>H5H5H5</h5>\r\n<h6>H6H6H6</h6>\r\n<p>sdfgsdfgsdfh dfs s df dfg</p>\r\n<h2>Installations fixes d\'extinction</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod   tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim   veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea   commodo consequat. Duis aute irure dolor in reprehenderit in voluptate   velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint   occaecat cupidatat non proident, sunt in culpa qui officia deserunt   mollit anim id est laborum</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod   tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim   veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea   commodo consequat. Duis aute irure dolor in reprehenderit in voluptate   velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint   occaecat cupidatat non proident, sunt in culpa qui officia deserunt   mollit anim id est laborum</p>\r\n<h2>Installations fixes d\'extinction par Gaz</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<h2>Installation Fixe d\'extinction par Eau</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>')
 ,(190,'<h1>H1H1H1</h1>\r\n<h2>H2H2H2</h2>\r\n<h3>H3H3H3</h3>\r\n<h4>H4H4H4</h4>\r\n<h5>H5H5H5</h5>\r\n<h6>H6H6H6</h6>\r\n<p>sdfgsdfgsdfh dfs s df dfg</p>\r\n<h2>Installations fixes d\'extinction</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod   tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim   veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea   commodo consequat. Duis aute irure dolor in reprehenderit in voluptate   velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint   occaecat cupidatat non proident, sunt in culpa qui officia deserunt   mollit anim id est laborum</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod   tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim   veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea   commodo consequat. Duis aute irure dolor in reprehenderit in voluptate   velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint   occaecat cupidatat non proident, sunt in culpa qui officia deserunt   mollit anim id est laborum</p>\r\n<h2>Installations fixes d\'extinction par Gaz</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<h2>Installation Fixe d\'extinction par Eau</h2>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod  tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim  veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea  commodo consequat. Duis aute irure dolor in reprehenderit in voluptate  velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint  occaecat cupidatat non proident, sunt in culpa qui officia deserunt  mollit anim id est laborum</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li>liste 1</li>\r\n<li>liste 2</li>\r\n<li>liste 3</li>\r\n</ul>\r\n<p><a title=\"Lien vers Google\" href=\"http://www.google.fr\">liens vers google</a></p>\r\n<p><img src=\"{CCM:FID_13}\" alt=\"buildings.png\" width=\"264\" height=\"142\" /></p>\r\n<p><a href=\"{CCM:FID_DL_12}\">bateau.png</a></p>')
 ,(206,'<h3>Actualit&eacute;s</h3>\r\n<p>&nbsp;</p>\r\n<p>&gt;&gt;&gt; Salon Maritime professionnel</p>\r\n<p>d&eacute;cembre - Nantes</p>\r\n<p>&nbsp;</p>')
 ,(207,'<h3>Actualit&eacute;s</h3>\r\n<p>&gt;&gt;&gt; Salon Maritime professionnel</p>\r\n<p>d&eacute;cembre - Nantes</p>\r\n<p>&nbsp;</p>')
 ,(208,'<h3>ACTUALITES</h3>\r\n<p>&gt;&gt;&gt; Salon Maritime professionnel</p>\r\n<p>d&eacute;cembre - Nantes</p>\r\n<p>&nbsp;</p>')
 ,(210,'<h3>ACTUALITES</h3>\r\n<p>&gt;&gt;&gt; Salon Maritime professionnel</p>\r\n<p>d&eacute;cembre - Nantes</p>\r\n<p><img src=\"{CCM:FID_18}\" alt=\"Actualit&eacute;s Marine\" width=\"140\" height=\"120\" /></p>')
 ,(344,'<h2>Plan du Site</h2>')
 ,(347,'<h2 style=\"text-align: justify;\">P.I.C., un savoir-faire reconnu &laquo;&nbsp;entre Terre et Mer&nbsp;&raquo;</h2>\r\n<p style=\"text-align: justify;\">&nbsp;</p>\r\n<p style=\"text-align: justify;\">Depuis novembre 2010, notre soci&eacute;t&eacute; a chang&eacute; d&rsquo;&eacute;quipe dirigeante. Catherine et Charles BASSET ont transmis leur soci&eacute;t&eacute; &agrave; Dominique LELAY directeur associ&eacute; &agrave; St&eacute;phanie BASSET.<br />Nous poursuivrons l&rsquo;&eacute;lan donn&eacute; depuis 25 ans &agrave; porter des projets dans le respect de nos engagements.</p>')
 ,(321,'<table style=\"margin-bottom: 0px; width: 460px; height: 100px;\" border=\"0\" width=\"540\" height=\"156\">\r\n<tbody>\r\n<tr>\r\n<td style=\"padding-top: 5px;\"><img src=\"{CCM:FID_30}\" alt=\"buildings.png\" width=\"264\" height=\"142\" /><br /></td>\r\n<td style=\"vertical-align: middle;\">\r\n<h1 style=\"text-align: center;\">Terrestre</h1>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>')
 ,(318,'<table style=\"margin-bottom: 0px; width: 416px; height: 100px;\" border=\"0\">\r\n<tbody>\r\n<tr>\r\n<td><img src=\"{CCM:FID_29}\" alt=\"bateau.png\" width=\"237\" height=\"148\" /></td>\r\n<td style=\"vertical-align: middle;\">\r\n<h1 style=\"text-align: center;\">Marine</h1>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>')
 ,(350,'<h2 style=\"text-align: justify;\">P.I.C., un savoir-faire reconnu &laquo;&nbsp;entre Terre et Mer&nbsp;&raquo;</h2>\r\n<p style=\"text-align: justify;\">&nbsp;</p>\r\n<p style=\"text-align: justify;\">Depuis novembre 2010, notre soci&eacute;t&eacute; a chang&eacute; d&rsquo;&eacute;quipe dirigeante. Catherine et Charles BASSET ont transmis leur soci&eacute;t&eacute; &agrave; <strong>Dominique LELAY directeur </strong>associ&eacute; &agrave; <strong>St&eacute;phanie BASSET</strong>.<br />Nous poursuivrons l&rsquo;&eacute;lan donn&eacute; <strong>depuis 25 an</strong>s &agrave; porter des projets dans le r<strong>espect de nos engagements</strong>.</p>')
 ,(351,'<p>En <strong>25 ans d&rsquo;exp&eacute;rience</strong>, nous sommes devenus un partenaire de confiance aupr&egrave;s de nos <strong>1 500 clients</strong>.</p>\r\n<p>Pour assurer une qualit&eacute; de service et une rapidit&eacute; d&rsquo;intervention, notre &eacute;quipe s&rsquo;est constamment renforc&eacute;e de nouvelles comp&eacute;tences et nous avons int&eacute;gr&eacute; un nouveau local en 2009 sur le port de <strong>Concarneau</strong>.</p>')
 ,(352,'<h2 style=\"text-align: justify;\">P.I.C.,</h2>\r\n<h2 style=\"text-align: justify;\">un savoir-faire reconnu &laquo;&nbsp;entre Terre et Mer&nbsp;&raquo;</h2>\r\n<p style=\"text-align: justify;\">&nbsp;</p>\r\n<p style=\"text-align: justify;\">Depuis novembre 2010, notre soci&eacute;t&eacute; a chang&eacute; d&rsquo;&eacute;quipe dirigeante. Catherine et Charles BASSET ont transmis leur soci&eacute;t&eacute; &agrave; <strong>Dominique LELAY directeur </strong>associ&eacute; &agrave; <strong>St&eacute;phanie BASSET</strong>.<br />Nous poursuivrons l&rsquo;&eacute;lan donn&eacute; <strong>depuis 25 an</strong>s &agrave; porter des projets dans le r<strong>espect de nos engagements</strong>.</p>')
 ,(354,'<p style=\"text-align: justify;\">En <strong>25 ans d&rsquo;exp&eacute;rience</strong>, nous sommes devenus un partenaire de confiance aupr&egrave;s de nos <strong>1 500 clients</strong>.</p>\r\n<p style=\"text-align: justify;\">Pour assurer une qualit&eacute; de service et une rapidit&eacute; d&rsquo;intervention, notre &eacute;quipe s&rsquo;est constamment renforc&eacute;e de nouvelles comp&eacute;tences et nous avons int&eacute;gr&eacute; un nouveau local en 2009 sur le port de <strong>Concarneau</strong>.</p>')
 ,(355,'<h3>Partenariat</h3>\r\n<p><a title=\"Vers le site d\'IPC, l\'Interprofession du Port\" href=\"http://www.ipc.com\" target=\"_blank\"><img src=\"{CCM:FID_33}\" alt=\"ipc.png\" width=\"84\" height=\"86\" /></a></p>')
 ,(356,'<h3>Partenariat</h3>\r\n<p>&nbsp;</p>\r\n<p><a title=\"Vers le site d\'IPC, l\'Interprofession du Port\" href=\"http://www.ipc-concarneau.com\" target=\"_blank\"><img style=\"float: left;\" src=\"{CCM:FID_33}\" alt=\"ipc.png\" width=\"84\" height=\"86\" /></a></p>')
 ,(357,'<h3>Partenariat</h3>\r\n<p>&nbsp;</p>\r\n<p><a title=\"Vers le site d\'IPC, l\'Interprofession du Port\" href=\"http://www.ipc-concarneau.com\" target=\"_blank\"><img src=\"{CCM:FID_33}\" alt=\"ipc.png\" width=\"84\" height=\"86\" /></a></p>')
 ,(359,'<h1>Titre H1</h1>\r\n<h2>Titre H2</h2>\r\n<h3>Titre H3</h3>\r\n<p>Texte normal</p>\r\n<ul>\r\n<li>liste 1</li>\r\n<li>liste 2</li>\r\n<li>liste 3</li>\r\n</ul>')
 ,(360,'<h1>Tire h1</h1>\r\n<h2>Tire h1</h2>\r\n<h3>Tire h1</h3>\r\n<p>Paragraphe normal sedfgsdf ghsdfgsdfg  qsdfqgdc dfgs</p>')
 ,(362,'<h1>Titre h1</h1>\r\n<h2>Titre h2</h2>\r\n<h3>Titre h3</h3>\r\n<h4>Titre h4</h4>\r\n<h5>Titre h5</h5>\r\n<h6>Titre h6</h6>\r\n<p>Paragraphe normal  sqdfgqv qdfgf qsdg qdfgqd qds qsdgfqsd</p>')
 ,(377,'<table style=\"margin-bottom: 0px; width: 416px; height: 100px;\" border=\"0\">\r\n<tbody>\r\n<tr>\r\n<td><img src=\"{CCM:FID_29}\" alt=\"bateau.png\" width=\"237\" height=\"148\" /></td>\r\n<td style=\"vertical-align: middle;\">\r\n<h1 style=\"text-align: center;\">Marine</h1>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>')
 ,(387,'<table style=\"margin-bottom: 0px; width: 460px; height: 100px;\" border=\"0\" width=\"540\" height=\"156\">\r\n<tbody>\r\n<tr>\r\n<td style=\"padding-top: 5px;\"><img src=\"{CCM:FID_30}\" alt=\"buildings.png\" width=\"264\" height=\"142\" /><br /></td>\r\n<td style=\"vertical-align: middle;\">\r\n<h1 style=\"text-align: center;\">Terrestrial</h1>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>');


CREATE TABLE IF NOT EXISTS `btCu3er` (
  `bID` int(10) unsigned NOT NULL,
  `fsID` int(10) unsigned DEFAULT NULL,
  `playback` varchar(50) DEFAULT NULL,
  `duration` double unsigned DEFAULT NULL,
  `fadeDuration` double unsigned DEFAULT NULL,
  `linkImage` tinyint(4) DEFAULT '0',
  `defaultnumslices` varchar(10) DEFAULT NULL,
  `defaultslice` varchar(255) DEFAULT NULL,
  `defaultdirection` varchar(255) DEFAULT NULL,
  `defaultdelay` varchar(10) DEFAULT NULL,
  `defaultcubecolour` varchar(255) DEFAULT NULL,
  `defaultFader` varchar(255) DEFAULT NULL,
  `defaultZmultiplier` double DEFAULT NULL,
  `enableShadow` tinyint(4) DEFAULT '0',
  `shadowImage` varchar(255) DEFAULT NULL,
  `shadowfID` int(10) unsigned DEFAULT NULL,
  `maxHeight` decimal(10,0) unsigned DEFAULT NULL,
  `maxWidth` decimal(10,0) unsigned DEFAULT NULL,
  `nobuttons` int(10) unsigned DEFAULT NULL,
  `xmloutput` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btCu3er VALUES(105,0,'ORDER',NULL,NULL,0,NULL,NULL,NULL,NULL,'0x333333',NULL,NULL,NULL,NULL,NULL,300,800,1,'<?php xml version=\"1.0\" encoding=\"utf-8\" ?>\n<cu3er>\n	<settings>\n		<auto_play> \n			<defaults symbol=\"circular\" time=\"4\" /> \n			<tweenIn x=\"20\" y=\"20\" width=\"20\" height=\"20\" tint=\"0xFFFFFF\" alpha=\"0.3\" />\n			<tweenOut scaleX=\"0\" scaleY=\"0\" alpha=\"0\" />\n			<tweenOver alpha=\"0.8\"/> \n		</auto_play> \n		\n    	\n		\n		<description>\n	<defaults \n	round_corners=\"0, 0, 0, 0\"\n	heading_text_size=\"22\"\n	heading_text_color=\"0xFFFFFF\"          \n	heading_text_margin=\"10, 0, 0,10\"  \n	 \n	paragraph_text_size=\"13\"\n	paragraph_text_color=\"0xFFFFFF\"\n	paragraph_text_margin=\"10, 0, 0, 10\"\n\n	/>\n	<tweenIn tint=\"0x000000\" alpha=\"0.15\" />\n	<tweenOut time=\"0.5\" />\n	<tweenOver tint=\"0x000000\" alpha=\"0.4\" />\n</description>\n		\n		<preloader>\n          <defaults \n		  symbol=\"linear\"\n		  width=\"100\"\n		  height=\"3\"\n		  alpha=\"0.6\"\n		  />\n          <tweenIn tint=\"0x000000\" alpha=\"0.2\" />\n		  <tweenOut time=\"0.5\" />\n		</preloader>\n	  \n		<transitions\n			slicing=\"vertical\"\n			num=\"4\"\n			direction=\"left\"\n			duration=\"0.5\"\n			delay=\"0.1\"\n			cube_color=\"0x333333\"\n		/> \n	</settings>    \n\n	<slides>\n		<slide>\n					<url>/concrete5pic29/files/7112/8536/9026/inneroptics_dot_net_portland.jpg</url></slide>\n					<transition duration=\"0.5\" num=\"3\" slicing=\"vertical\" direction=\"down\" shader=\"none\" delay=\"0.1\" z_multiplier=\"2\" />\n					<slide>\n					<url>/concrete5pic29/files/3712/8536/9023/inneroptics_dot_net_aspens.jpg</url></slide>\n					<transition duration=\"0.5\" num=\"3\" slicing=\"horizontal\" direction=\"left\" shader=\"phong\" delay=\"0.1\" z_multiplier=\"2\" />\n					<slide>\n					<url>/concrete5pic29/files/7012/8536/9026/inneroptics_dot_net_starfish.jpg</url></slide>\n					<transition duration=\"0.5\" num=\"3\" slicing=\"vertical\" direction=\"right\" shader=\"flat\" delay=\"0.1\" z_multiplier=\"2\" />\n									\n	</slides>\n</cu3er>\n')
 ,(106,0,'ORDER',NULL,NULL,0,NULL,NULL,NULL,NULL,'0x333333',NULL,NULL,NULL,NULL,NULL,392,233,1,'<?php xml version=\"1.0\" encoding=\"utf-8\" ?>\n<cu3er>\n	<settings>\n		<auto_play> \n			<defaults symbol=\"circular\" time=\"4\" /> \n			<tweenIn x=\"20\" y=\"20\" width=\"20\" height=\"20\" tint=\"0xFFFFFF\" alpha=\"0.3\" />\n			<tweenOut scaleX=\"0\" scaleY=\"0\" alpha=\"0\" />\n			<tweenOver alpha=\"0.8\"/> \n		</auto_play> \n		\n    	\n		\n		<description>\n	<defaults \n	round_corners=\"0, 0, 0, 0\"\n	heading_text_size=\"22\"\n	heading_text_color=\"0xFFFFFF\"          \n	heading_text_margin=\"10, 0, 0,10\"  \n	 \n	paragraph_text_size=\"13\"\n	paragraph_text_color=\"0xFFFFFF\"\n	paragraph_text_margin=\"10, 0, 0, 10\"\n\n	/>\n	<tweenIn tint=\"0x000000\" alpha=\"0.15\" />\n	<tweenOut time=\"0.5\" />\n	<tweenOver tint=\"0x000000\" alpha=\"0.4\" />\n</description>\n		\n		<preloader>\n          <defaults \n		  symbol=\"linear\"\n		  width=\"100\"\n		  height=\"3\"\n		  alpha=\"0.6\"\n		  />\n          <tweenIn tint=\"0x000000\" alpha=\"0.2\" />\n		  <tweenOut time=\"0.5\" />\n		</preloader>\n	  \n		<transitions\n			slicing=\"vertical\"\n			num=\"4\"\n			direction=\"left\"\n			duration=\"0.5\"\n			delay=\"0.1\"\n			cube_color=\"0x333333\"\n		/> \n	</settings>    \n\n	<slides>\n		<slide>\n					<url>/concrete5pic29/files/2712/9651/0808/terrestre.png</url><link>http://www.google.fr</link>\n						<description>  \n						<heading>Terrestre heading</heading>\n						<paragraph>Terrestre body</paragraph>\n					</description>\n					</slide>\n					<transition duration=\"0.5\" num=\"5\" slicing=\"vertical\" direction=\"up\" shader=\"flat\" delay=\"0.2\" z_multiplier=\"2\" />\n					<slide>\n					<url>/concrete5pic29/files/6712/9651/1264/terrestre_2.png</url></slide>\n					<transition duration=\"0.5\" num=\"5\" slicing=\"vertical\" direction=\"down\" shader=\"flat\" delay=\"0.2\" z_multiplier=\"2\" />\n									\n	</slides>\n</cu3er>\n')
 ,(157,0,'ORDER',NULL,NULL,0,NULL,NULL,NULL,NULL,'0x333333',NULL,NULL,NULL,NULL,NULL,148,264,1,'<?php xml version=\"1.0\" encoding=\"utf-8\" ?>\n<cu3er>\n	<settings>\n		<auto_play> \n			<defaults symbol=\"circular\" time=\"4\" /> \n			<tweenIn x=\"20\" y=\"20\" width=\"20\" height=\"20\" tint=\"0xFFFFFF\" alpha=\"0.3\" />\n			<tweenOut scaleX=\"0\" scaleY=\"0\" alpha=\"0\" />\n			<tweenOver alpha=\"0.8\"/> \n		</auto_play> \n		\n    	\n		\n		<description>\n	<defaults \n	round_corners=\"0, 0, 0, 0\"\n	heading_text_size=\"22\"\n	heading_text_color=\"0xFFFFFF\"          \n	heading_text_margin=\"10, 0, 0,10\"  \n	 \n	paragraph_text_size=\"13\"\n	paragraph_text_color=\"0xFFFFFF\"\n	paragraph_text_margin=\"10, 0, 0, 10\"\n\n	/>\n	<tweenIn tint=\"0x000000\" alpha=\"0.15\" />\n	<tweenOut time=\"0.5\" />\n	<tweenOver tint=\"0x000000\" alpha=\"0.4\" />\n</description>\n		\n		<preloader>\n          <defaults \n		  symbol=\"linear\"\n		  width=\"100\"\n		  height=\"3\"\n		  alpha=\"0.6\"\n		  />\n          <tweenIn tint=\"0x000000\" alpha=\"0.2\" />\n		  <tweenOut time=\"0.5\" />\n		</preloader>\n	  \n		<transitions\n			slicing=\"vertical\"\n			num=\"4\"\n			direction=\"left\"\n			duration=\"0.5\"\n			delay=\"0.1\"\n			cube_color=\"0x333333\"\n		/> \n	</settings>    \n\n	<slides>\n		<slide>\n					<url>/concrete5pic29/files/3812/9573/3592/buildings.png</url></slide>\n					<transition duration=\"0.5\" num=\"3\" slicing=\"vertical\" direction=\"down\" shader=\"none\" delay=\"0.1\" z_multiplier=\"2\" />\n					<slide>\n					<url>/concrete5pic29/files/2012/9573/3541/bateau.png</url></slide>\n					<transition duration=\"0.5\" num=\"3\" slicing=\"vertical\" direction=\"down\" shader=\"none\" delay=\"0.1\" z_multiplier=\"2\" />\n									\n	</slides>\n</cu3er>\n')
 ,(158,0,'ORDER',NULL,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,148,264,1,'<?php xml version=\"1.0\" encoding=\"utf-8\" ?>\n<cu3er>\n	<settings>\n		<auto_play> \n			<defaults symbol=\"circular\" time=\"4\" /> \n			<tweenIn x=\"20\" y=\"20\" width=\"20\" height=\"20\" tint=\"0xFFFFFF\" alpha=\"0.3\" />\n			<tweenOut scaleX=\"0\" scaleY=\"0\" alpha=\"0\" />\n			<tweenOver alpha=\"0.8\"/> \n		</auto_play> \n		\n    	\n		\n		<description>\n	<defaults \n	round_corners=\"0, 0, 0, 0\"\n	heading_text_size=\"22\"\n	heading_text_color=\"0xFFFFFF\"          \n	heading_text_margin=\"10, 0, 0,10\"  \n	 \n	paragraph_text_size=\"13\"\n	paragraph_text_color=\"0xFFFFFF\"\n	paragraph_text_margin=\"10, 0, 0, 10\"\n\n	/>\n	<tweenIn tint=\"0x000000\" alpha=\"0.15\" />\n	<tweenOut time=\"0.5\" />\n	<tweenOver tint=\"0x000000\" alpha=\"0.4\" />\n</description>\n		\n		<preloader>\n          <defaults \n		  symbol=\"linear\"\n		  width=\"100\"\n		  height=\"3\"\n		  alpha=\"0.6\"\n		  />\n          <tweenIn tint=\"0x000000\" alpha=\"0.2\" />\n		  <tweenOut time=\"0.5\" />\n		</preloader>\n	  \n		<transitions\n			slicing=\"vertical\"\n			num=\"4\"\n			direction=\"left\"\n			duration=\"0.5\"\n			delay=\"0.1\"\n			cube_color=\"\"\n		/> \n	</settings>    \n\n	<slides>\n		<slide>\n					<url>/concrete5pic29/files/3812/9573/3592/buildings.png</url></slide>\n					<transition duration=\"0.5\" num=\"3\" slicing=\"vertical\" direction=\"down\" shader=\"none\" delay=\"0.1\" z_multiplier=\"2\" />\n					<slide>\n					<url>/concrete5pic29/files/2012/9573/3541/bateau.png</url></slide>\n					<transition duration=\"0.5\" num=\"3\" slicing=\"vertical\" direction=\"down\" shader=\"none\" delay=\"0.1\" z_multiplier=\"2\" />\n									\n	</slides>\n</cu3er>\n');


CREATE TABLE IF NOT EXISTS `btCu3erImg` (
  `slideshowImgId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bID` int(10) unsigned DEFAULT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `duration` double unsigned DEFAULT NULL,
  `fadeDuration` double unsigned DEFAULT NULL,
  `groupSet` int(10) unsigned DEFAULT NULL,
  `position` int(10) unsigned DEFAULT NULL,
  `imgHeight` int(10) unsigned DEFAULT NULL,
  `descriptionLink` varchar(255) DEFAULT NULL,
  `descriptionHeading` longtext,
  `descriptionParagraph` longtext,
  `transitionNum` int(10) unsigned DEFAULT NULL,
  `transitionSlicing` varchar(255) DEFAULT NULL,
  `transitionDirection` varchar(255) DEFAULT NULL,
  `transitionFader` varchar(255) DEFAULT NULL,
  `transitionDelay` double DEFAULT NULL,
  `transitionZmultiplier` double DEFAULT NULL,
  PRIMARY KEY (`slideshowImgId`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

INSERT INTO btCu3erImg VALUES(1,105,4,'',0.5,0,0,0,215,NULL,'','',3,'vertical','down','none',0.1,2)
 ,(2,105,1,'',0.5,0,0,1,192,NULL,'','',3,'horizontal','left','phong',0.1,2)
 ,(3,105,5,'',0.5,0,0,2,192,NULL,'','',3,'vertical','right','flat',0.1,2)
 ,(17,106,15,'',0.5,0,0,1,392,NULL,'','',5,'vertical','down','flat',0.2,2)
 ,(16,106,14,'http://www.google.fr',0.5,0,0,0,392,NULL,'Terrestre heading','Terrestre body',5,'vertical','up','flat',0.2,2)
 ,(21,157,12,'',0.5,0,0,1,148,NULL,'','',3,'vertical','down','none',0.1,2)
 ,(20,157,13,'',0.5,0,0,0,142,NULL,'','',3,'vertical','down','none',0.1,2)
 ,(27,158,12,'',0.5,0,0,1,148,NULL,'','',3,'vertical','down','none',0.1,2)
 ,(26,158,13,'',0.5,0,0,0,142,NULL,'','',3,'vertical','down','none',0.1,2);


CREATE TABLE IF NOT EXISTS `btDPSyntaxHighlighter` (
  `bID` int(10) unsigned NOT NULL,
  `code` longtext,
  `language` varchar(100) DEFAULT 'php',
  `clazz` varchar(100) DEFAULT 'dp-highlighter',
  `showGutter` tinyint(3) unsigned DEFAULT '1',
  `showControls` tinyint(3) unsigned DEFAULT '1',
  `collapseAll` tinyint(3) unsigned DEFAULT '0',
  `firstLine` tinyint(3) unsigned DEFAULT '0',
  `showColumns` tinyint(3) unsigned DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btDateNav` (
  `bID` int(10) unsigned NOT NULL,
  `num` smallint(5) unsigned NOT NULL,
  `cParentID` int(10) unsigned NOT NULL DEFAULT '1',
  `cThis` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ctID` smallint(5) unsigned DEFAULT NULL,
  `flatDisplay` int(11) DEFAULT '0',
  `defaultNode` varchar(64) DEFAULT 'current_page',
  `truncateTitles` int(11) DEFAULT '0',
  `truncateSummaries` int(11) DEFAULT '0',
  `displayFeaturedOnly` int(11) DEFAULT '0',
  `truncateChars` int(11) DEFAULT '128',
  `truncateTitleChars` int(11) DEFAULT '128',
  `showDescriptions` int(11) DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btDateNav VALUES(18,0,0,0,4,0,'current_page',0,0,0,0,0,0)
 ,(28,0,71,1,0,0,'current_month',0,0,0,0,0,0);


CREATE TABLE IF NOT EXISTS `btEmployeeProfile` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT '0',
  `name` longtext,
  `jobtitle` longtext,
  `phone` longtext,
  `email` longtext,
  `description` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btExternalForm` (
  `bID` int(10) unsigned NOT NULL,
  `filename` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btFile` (
  `bID` int(10) unsigned NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `origfilename` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `type` varchar(32) DEFAULT NULL,
  `generictype` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btFlashContent` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `quality` varchar(255) DEFAULT NULL,
  `minVersion` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btForm` (
  `bID` int(10) unsigned NOT NULL,
  `questionSetId` int(10) unsigned DEFAULT '0',
  `surveyName` varchar(255) DEFAULT NULL,
  `thankyouMsg` text,
  `notifyMeOnSubmission` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `recipientEmail` varchar(255) DEFAULT NULL,
  `displayCaptcha` int(11) DEFAULT '1',
  `redirectCID` int(11) DEFAULT '0',
  PRIMARY KEY (`bID`),
  KEY `questionSetIdForeign` (`questionSetId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btFormAnswerSet` (
  `asID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `questionSetId` int(10) unsigned DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uID` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`asID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btFormAnswers` (
  `aID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asID` int(10) unsigned DEFAULT '0',
  `msqID` int(10) unsigned DEFAULT '0',
  `answer` varchar(255) DEFAULT NULL,
  `answerLong` text,
  PRIMARY KEY (`aID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btFormQuestions` (
  `qID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `msqID` int(10) unsigned DEFAULT '0',
  `bID` int(10) unsigned DEFAULT '0',
  `questionSetId` int(10) unsigned DEFAULT '0',
  `question` varchar(255) DEFAULT NULL,
  `inputType` varchar(255) DEFAULT NULL,
  `options` text,
  `position` int(10) unsigned DEFAULT '1000',
  `width` int(10) unsigned DEFAULT '50',
  `height` int(10) unsigned DEFAULT '3',
  `required` int(11) DEFAULT '0',
  PRIMARY KEY (`qID`),
  KEY `questionSetId` (`questionSetId`),
  KEY `msqID` (`msqID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btGoogleMap` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `api_key` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `zoom` int(8) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btGoogleMap VALUES(240,'My Map','ABQIAAAA303mn4YJ-AjrOmQqRT0aGhQ8hea5Y60EfqxCxU8S_QXYftuCaRQwdH-xFrEud-73y156OT7PbI7OVw','Concarneau',47.8723731,-3.9215582,14);


CREATE TABLE IF NOT EXISTS `btGuestBook` (
  `bID` int(10) unsigned NOT NULL,
  `requireApproval` int(11) DEFAULT '0',
  `title` varchar(100) DEFAULT 'Comments',
  `dateFormat` varchar(100) DEFAULT NULL,
  `displayGuestBookForm` int(11) DEFAULT '1',
  `displayCaptcha` int(11) DEFAULT '1',
  `authenticationRequired` int(11) DEFAULT '0',
  `notifyEmail` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btGuestBook VALUES(17,0,'Comments:','M jS, Y',1,1,0,'')
 ,(27,0,'Comments:','M jS, Y',1,1,0,'');


CREATE TABLE IF NOT EXISTS `btGuestBookEntries` (
  `bID` int(11) DEFAULT NULL,
  `cID` int(11) DEFAULT '1',
  `entryID` int(11) NOT NULL AUTO_INCREMENT,
  `uID` int(11) DEFAULT '0',
  `commentText` longtext,
  `user_name` varchar(100) DEFAULT NULL,
  `user_email` varchar(100) DEFAULT NULL,
  `entryDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `approved` int(11) DEFAULT '1',
  PRIMARY KEY (`entryID`),
  KEY `cID` (`cID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btMenuPic29` (
  `bID` int(10) unsigned NOT NULL,
  `data` varchar(5000) DEFAULT '',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btMenuPic29 VALUES(91,'')
 ,(92,'')
 ,(94,'a:17:{s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:1;s:23:\"displaySubPageLevelsNum\";s:1:\"3\";s:23:\"displayUnavailablePages\";i:1;s:9:\"menuColor\";s:7:\"#79c6d4\";s:14:\"menuColorHover\";s:7:\"#6fd8eb\";s:12:\"menuColorTxt\";s:7:\"#555555\";s:11:\"displayTime\";i:800;s:8:\"floatNav\";s:5:\"right\";s:6:\"layout\";s:10:\"horizontal\";s:13:\"autoWidthMode\";i:1;s:9:\"cellWidth\";i:150;s:17:\"autonavCurrentCID\";i:1;s:15:\"displaySubPages\";s:3:\"all\";s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayPagesIncludeSelf\";i:0;}')
 ,(95,'O:9:\"Pic29Menu\":17:{s:15:\"displaySubPages\";s:3:\"all\";s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:1;s:23:\"displaySubPageLevelsNum\";s:1:\"3\";s:23:\"displayUnavailablePages\";i:0;s:9:\"menuColor\";s:7:\"#79c6d4\";s:14:\"menuColorHover\";s:7:\"#6fd8eb\";s:12:\"menuColorTxt\";s:7:\"#555555\";s:11:\"displayTime\";i:800;s:8:\"floatNav\";s:5:\"right\";s:6:\"layout\";s:8:\"vertical\";s:13:\"autoWidthMode\";i:0;s:9:\"cellWidth\";i:140;s:17:\"autonavCurrentCID\";i:1;s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayPagesIncludeSelf\";i:0;}');


CREATE TABLE IF NOT EXISTS `btNavigation` (
  `bID` int(10) unsigned NOT NULL,
  `orderBy` varchar(255) DEFAULT 'alpha_asc',
  `displayPages` varchar(255) DEFAULT 'top',
  `displayPagesCID` int(10) unsigned NOT NULL DEFAULT '1',
  `displayPagesIncludeSelf` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `displaySubPages` varchar(255) DEFAULT 'none',
  `displaySubPageLevels` varchar(255) DEFAULT 'none',
  `displaySubPageLevelsNum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `displayUnavailablePages` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btNavigation VALUES(1,'display_asc','top',0,0,'none','enough',0,0)
 ,(3,'display_asc','second_level',0,0,'relevant','enough',0,0)
 ,(7,'display_asc','top',0,0,'none','enough',0,0)
 ,(9,'display_asc','second_level',0,0,'relevant','enough',0,0)
 ,(10,'display_asc','top',0,0,'none','enough',0,0)
 ,(12,'display_asc','top',0,0,'none','enough',0,0)
 ,(14,'display_asc','top',0,0,'relevant_breadcrumb','enough',0,0)
 ,(20,'display_asc','top',0,0,'all','all',0,0)
 ,(76,'display_asc','custom',1,0,'all','custom',2,0)
 ,(66,'display_asc','custom',1,0,'all','custom',2,0)
 ,(68,'display_asc','custom',71,0,'none','enough',0,0)
 ,(69,'display_asc','custom',71,0,'none','enough',0,0)
 ,(77,'display_asc','custom',71,0,'none','enough',0,0)
 ,(78,'display_asc','custom',71,0,'none','enough',0,0)
 ,(79,'display_asc','custom',1,0,'all','custom',2,0)
 ,(80,'display_asc','custom',1,0,'all','custom',2,0)
 ,(226,'display_asc','custom',1,0,'all','all',0,0);


CREATE TABLE IF NOT EXISTS `btNextPrevious` (
  `bID` int(10) unsigned NOT NULL,
  `linkStyle` varchar(32) DEFAULT NULL,
  `nextLabel` varchar(128) DEFAULT NULL,
  `previousLabel` varchar(128) DEFAULT NULL,
  `showArrows` int(11) DEFAULT '1',
  `loopSequence` int(11) DEFAULT '1',
  `excludeSystemPages` int(11) DEFAULT '1',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btNextPrevious VALUES(40,'next_previous','Next','Previous',1,1,1);


CREATE TABLE IF NOT EXISTS `btPageList` (
  `bID` int(10) unsigned NOT NULL,
  `num` smallint(5) unsigned NOT NULL,
  `orderBy` varchar(32) DEFAULT NULL,
  `cParentID` int(10) unsigned NOT NULL DEFAULT '1',
  `cThis` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `paginate` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `displayAliases` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `ctID` smallint(5) unsigned DEFAULT NULL,
  `rss` int(11) DEFAULT '0',
  `rssTitle` varchar(255) DEFAULT NULL,
  `rssDescription` longtext,
  `truncateSummaries` int(11) DEFAULT '0',
  `displayFeaturedOnly` int(11) DEFAULT '0',
  `truncateChars` int(11) DEFAULT '128',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btPic29ButtonBlockBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29ButtonBlockBlock VALUES(125,'O:16:\"Pic29ButtonBlock\":16:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:12:\"Go to search\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(126,'O:16:\"Pic29ButtonBlock\":16:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:12:\"Go to search\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(127,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:7:\"Go home\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:33:\"fgh\r\nsdfsdfhgsdf\r\ngsd\r\nfgsdfgsdfg\";s:5:\"width\";i:50;s:6:\"height\";i:100;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(128,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:7:\"Go home\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:33:\"fgh\r\nsdfsdfhgsdf\r\ngsd\r\nfgsdfgsdfg\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:-10;s:17:\"imageOffsetBottom\";i:-10;}')
 ,(129,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:7:\"Go home\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:10:\"Test title\";s:7:\"content\";s:41:\"> fgh\r\n> sdfsdfhgsdf\r\n> gsd\r\n> fgsdfgsdfg\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:-10;s:17:\"imageOffsetBottom\";i:-10;}')
 ,(130,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:7:\"Go home\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:10:\"Test title\";s:7:\"content\";s:104:\"> fgh\r\n> sdfsdfhgsdf\r\n> gsd\r\n> fgsdfgsdfg\r\ndfg\r\ndfghdfghdf<b><span style=\'color:red;\'>QERGQDQ</span></b>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(131,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:19:\"Vers la page marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:20:\"Le domaine terrestre\";s:7:\"content\";s:56:\"> item 1\r\n> item 2\r\n> item \r\n> item \r\n> item \r\n> item \r\n\";s:5:\"width\";i:200;s:6:\"height\";i:338;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:-10;}')
 ,(132,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"13\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:19:\"Vers page Terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:20:\"Le domaine terrestre\";s:7:\"content\";s:42:\"Item\r\nItem\r\nItem\r\nItem\r\nItem\r\nItem\r\nItem\r\n\";s:5:\"width\";i:200;s:6:\"height\";i:338;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-20;s:17:\"imageOffsetBottom\";i:-40;}')
 ,(133,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:19:\"Vers la page marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:17:\"Le domaine marine\";s:7:\"content\";s:56:\"> item 1\r\n> item 2\r\n> item \r\n> item \r\n> item \r\n> item \r\n\";s:5:\"width\";i:200;s:6:\"height\";i:338;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:-10;}')
 ,(134,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"13\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:19:\"Vers page Terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:20:\"Le domaine terrestre\";s:7:\"content\";s:42:\"Item\r\nItem\r\nItem\r\nItem\r\nItem\r\nItem\r\nItem\r\n\";s:5:\"width\";i:200;s:6:\"height\";i:338;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-20;s:17:\"imageOffsetBottom\";i:-40;}')
 ,(150,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers About\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:9:\"Mon titre\";s:7:\"content\";s:28:\"Mon contenu 1\r\nMon contenu 2\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(154,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:8:\"external\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers About\";s:11:\"externalUrl\";s:21:\"http://www.google.com\";s:19:\"externalDescription\";s:11:\"Vers Google\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:9:\"Mon titre\";s:7:\"content\";s:28:\"Mon contenu 1\r\nMon contenu 2\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(163,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:8:\"external\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers About\";s:11:\"externalUrl\";s:21:\"http://www.google.com\";s:19:\"externalDescription\";s:11:\"Vers Google\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:9:\"Mon titre\";s:7:\"content\";s:32:\"> Mon contenu 1\r\n> Mon contenu 2\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(175,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:8:\"external\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers About\";s:11:\"externalUrl\";s:21:\"http://www.google.com\";s:19:\"externalDescription\";s:11:\"Vers Google\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:0:\"\";s:7:\"content\";s:209:\"<div style=\"font-weight:bold;\">\r\n<span style=\"font-size: 20px;\">\r\n\r\nSolutions Incendie\r\n\r\n</span>\r\n<br>\r\n<span style=\"font-size: 30px;\">\r\n\r\nMarine\r\n\r\n</span>\r\n</div>\r\n<br>\r\n> Mon contenu 1<br>\r\n> Mon contenu 2\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(176,'O:16:\"Pic29ButtonBlock\":23:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:8:\"external\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers About\";s:11:\"externalUrl\";s:21:\"http://www.google.com\";s:19:\"externalDescription\";s:11:\"Vers Google\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:5:\"title\";s:0:\"\";s:7:\"content\";s:352:\"<div style=\"font-weight:bold;\">\r\n<span style=\"font-size: 20px;\">\r\n\r\nSolutions Incendie\r\n\r\n</span>\r\n<br>\r\n<span style=\"font-size: 30px;\">\r\n\r\nMarine\r\n\r\n</span>\r\n</div>\r\n<br>\r\n\r\n\r\n<ul class=\"no_puce\">\r\n<li> > Construction navale</li>\r\n<li> > Pêche professionnelle</li>\r\n<li> > Transports maritimes</li>\r\n<li> > Plaisance</li>\r\n<li> > Offshore</li>\r\n</ul>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(178,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers About\";s:11:\"externalUrl\";s:21:\"http://www.google.com\";s:19:\"externalDescription\";s:11:\"Vers Google\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:352:\"<div style=\"font-weight:bold;\">\r\n<span style=\"font-size: 20px;\">\r\n\r\nSolutions Incendie\r\n\r\n</span>\r\n<br>\r\n<span style=\"font-size: 30px;\">\r\n\r\nMarine\r\n\r\n</span>\r\n</div>\r\n<br>\r\n\r\n\r\n<ul class=\"no_puce\">\r\n<li> > Construction navale</li>\r\n<li> > Pêche professionnelle</li>\r\n<li> > Transports maritimes</li>\r\n<li> > Plaisance</li>\r\n<li> > Offshore</li>\r\n</ul>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(198,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers Blog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:176:\"\r\n<span style=\"font-size: 20px;\">\r\nSolutions Incendie\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\n\r\nMarine\r\n\r\n</span>\r\n\r\n<H2>Solutions Incendie</H2>\r\n<H1>Marine</H1>\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:-10;s:17:\"imageOffsetBottom\";i:-10;}')
 ,(199,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers Blog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:187:\"<span style=\"font-size: 20px;\">\r\nSolutions Incendie\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\nMarine\r\n</span>\r\n<br /> \r\n\r\n> element 1<br/>\r\n> element 2<br/>\r\n> element 3<br/>\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:-10;s:17:\"imageOffsetBottom\";i:-10;}')
 ,(200,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"13\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:19:\"Vers page Terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:135:\"<span style=\"font-size: 20px;\">\r\n\r\nSolutions Incendie\r\n\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\n\r\nTerrestre\r\n\r\n</span>\r\n\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-10;s:17:\"imageOffsetBottom\";i:-60;}')
 ,(202,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"13\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:19:\"Vers page Terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:135:\"<span style=\"font-size: 20px;\">\r\n\r\nSolutions Incendie\r\n\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\n\r\nTerrestre\r\n\r\n</span>\r\n\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-20;s:17:\"imageOffsetBottom\";i:40;}')
 ,(203,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers Blog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:174:\"<span style=\"font-size: 20px;\">\r\nSolutions Incendie\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\n\r\nMarine\r\n\r\n</span>\r\n\r\n<H2>Solutions Incendie</H2>\r\n<H1>Marine</H1>\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:20;}')
 ,(204,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers Blog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:177:\"<span style=\"font-size: 20px;\">\r\nSolutions Incendie\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\nMarine\r\n</span>\r\n<br/>\r\n> ligne 1<br/>\r\n> ligne 2<br/>\r\n> ligne 3<br/>\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:20;}')
 ,(205,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"13\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:19:\"Vers page Terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:180:\"<span style=\"font-size: 20px;\">\r\nSolutions Incendie\r\n</span>\r\n<br /> \r\n<span style=\"font-size: 35px;\">   \r\nTerrestre\r\n</span>\r\n<br/>\r\n> ligne 1<br/>\r\n> ligne 2<br/>\r\n> ligne 3<br/>\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-20;s:17:\"imageOffsetBottom\";i:40;}')
 ,(218,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers Blog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:104:\"<H2>SOLUTIONS INCENDIE</H2>\r\n<H1> MARINE</H1>\r\n<p>\r\n> ligne 1<br/>\r\n> ligne 2<br/>\r\n> ligne 3<br/>\r\n</p>\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:20;}')
 ,(219,'O:16:\"Pic29ButtonBlock\":22:{s:25:\"\0Pic29ButtonBlock\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"13\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:19:\"Vers page Terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:106:\"<H2>SOLUTIONS INCENDIE</H2>\r\n<H1>TERRESTRE</H1>\r\n<p>\r\n> ligne 1<br/>\r\n> ligne 2<br/>\r\n> ligne 3<br/>\r\n</p>\";s:5:\"width\";i:200;s:6:\"height\";i:300;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-20;s:17:\"imageOffsetBottom\";i:40;}')
 ,(341,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"29\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:123;s:15:\"pageDescription\";s:19:\"Vers la page marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:133:\"<h2>SOLUTIONS INCENDIE</h2>\r\n<h1>MARINE</h1>\r\n<br/>\r\n\r\n> Ligne 1<br/>\r\n> Ligne 2<br/>\r\n> Ligne 3<br/>\r\n> Ligne 4<br/>\r\n> Ligne 5<br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(342,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"30\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:107;s:15:\"pageDescription\";s:22:\"Vers Accueil terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:136:\"<h2>SOLUTIONS INCENDIE</h2>\r\n<h1>TERRESTRE</h1>\r\n<br/>\r\n\r\n> Ligne 1<br/>\r\n> Ligne 2<br/>\r\n> Ligne 3<br/>\r\n> Ligne 4<br/>\r\n> Ligne 5<br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-25;s:17:\"imageOffsetBottom\";i:40;}')
 ,(346,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"29\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:123;s:15:\"pageDescription\";s:19:\"Vers la page marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:176:\"<h2>SOLUTIONS INCENDIE</h2>\r\n<h1>MARINE</h1>\r\n<br/>\r\n\r\n> Construction navale<br/>\r\n> Pêche professionnelle<br/>\r\n> Transports maritimes<br/>\r\n> PLaisance<br/>\r\n> Offshore<br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(345,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"30\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:107;s:15:\"pageDescription\";s:22:\"Vers Accueil terrestre\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:205:\"<h2>SOLUTIONS INCENDIE</h2>\r\n<h1>TERRESTRE</h1>\r\n<br/>\r\n\r\n> Bureaux d\'études<br/>\r\n> Industrie<br/>\r\n> Entreprises (PME, TPE)<br/>\r\n> Ets Recevant du Public<br/>\r\n> Collectivités<br/>\r\n> Immobilier<br/> \";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-25;s:17:\"imageOffsetBottom\";i:40;}')
 ,(394,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"29\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:145;s:15:\"pageDescription\";s:17:\"Go to Marine page\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:162:\"<h2> SOLUTIONS FIRE </ h2>\r\n<h1> MARINE </ h1>\r\n<br/>\r\n\r\n> Shipbuilding <br/>\r\n> Professional Fishing <br/>\r\n> Shipping <br/>\r\n> Plaisance <br/>\r\n> Offshore <br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(395,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"30\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:146;s:15:\"pageDescription\";s:22:\"Go to Terrestrial page\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:203:\"<h2> SOLUTIONS FIRE </ h2>\r\n<h1> TERRESTRIAL </ h1>\r\n<br/>\r\n\r\n> Consultants <br/>\r\n> Industry <br/>\r\n> Enterprise (SME, SOHO) <br/>\r\n> Ets Receiving Public <br/>\r\n> Communities <br/>\r\n> Real Estate <br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-25;s:17:\"imageOffsetBottom\";i:40;}')
 ,(396,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"29\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:145;s:15:\"pageDescription\";s:17:\"Go to Marine page\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:162:\"<h2> SOLUTIONS FIRE </ h2>\r\n<h1> MARINE </ h1>\r\n<br/>\r\n\r\n> Shipbuilding <br/>\r\n> Professional Fishing <br/>\r\n> Shipping <br/>\r\n> Plaisance <br/>\r\n> Offshore <br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(397,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"30\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:146;s:15:\"pageDescription\";s:22:\"Go to Terrestrial page\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:203:\"<h2> SOLUTIONS FIRE </ h2>\r\n<h1> TERRESTRIAL </ h1>\r\n<br/>\r\n\r\n> Consultants <br/>\r\n> Industry <br/>\r\n> Enterprise (SME, SOHO) <br/>\r\n> Ets Receiving Public <br/>\r\n> Communities <br/>\r\n> Real Estate <br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-25;s:17:\"imageOffsetBottom\";i:40;}')
 ,(398,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"29\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:145;s:15:\"pageDescription\";s:17:\"Go to Marine page\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:196:\"<h2> SOLUTIONS FIRE </h2>\r\n<h1> MARINE </h1>\r\n<br/>\r\n\r\n> Consultants <br/>\r\n> Industry <br/>\r\n> Enterprise (SME, SOHO) <br/>\r\n> Ets Receiving Public <br/>\r\n> Communities <br/>\r\n> Real Estate <br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}')
 ,(399,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"30\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:146;s:15:\"pageDescription\";s:22:\"Go to Terrestrial page\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:201:\"<h2> SOLUTIONS FIRE </h2>\r\n<h1> TERRESTRIAL </h1>\r\n<br/>\r\n\r\n> Consultants <br/>\r\n> Industry <br/>\r\n> Enterprise (SME, SOHO) <br/>\r\n> Ets Receiving Public <br/>\r\n> Communities <br/>\r\n> Real Estate <br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:5:\"green\";s:15:\"imageOffsetLeft\";i:-25;s:17:\"imageOffsetBottom\";i:40;}')
 ,(401,'O:16:\"Pic29ButtonBlock\":21:{s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:3:\"fID\";s:2:\"29\";s:7:\"fIDOver\";N;s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:145;s:15:\"pageDescription\";s:17:\"Go to Marine page\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:1;s:7:\"content\";s:160:\"<h2> SOLUTIONS FIRE </h2>\r\n<h1> MARINE </h1>\r\n<br/>\r\n\r\n> Shipbuilding <br/>\r\n> Professional Fishing <br/>\r\n> Shipping <br/>\r\n> Plaisance <br/>\r\n> Offshore <br/>\";s:5:\"width\";i:200;s:6:\"height\";i:350;s:5:\"color\";s:4:\"blue\";s:15:\"imageOffsetLeft\";i:10;s:17:\"imageOffsetBottom\";i:10;}');


CREATE TABLE IF NOT EXISTS `btPic29ButtonImageBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29ButtonImageBlock VALUES(117,'O:16:\"Pic29ButtonImage\":15:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";N;s:5:\"color\";N;s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"14\";s:7:\"fIDOver\";s:2:\"15\";s:3:\"url\";s:0:\"\";s:11:\"description\";s:0:\"\";s:10:\"canbeShown\";b:1;s:7:\"pageCID\";i:67;s:8:\"pagePath\";N;s:23:\"pagePointerExternalLink\";N;s:23:\"displayUnavailablePages\";b:0;}')
 ,(119,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:8:\"external\";s:5:\"width\";N;s:5:\"color\";N;s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"14\";s:7:\"fIDOver\";s:2:\"15\";s:3:\"url\";s:20:\"http://www.google.fr\";s:11:\"description\";s:11:\"Vers Google\";s:10:\"canbeShown\";b:1;s:7:\"pageCID\";i:67;s:8:\"pagePath\";N;s:23:\"pagePointerExternalLink\";N;s:15:\"openInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:0;}')
 ,(120,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";N;s:5:\"color\";N;s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"14\";s:7:\"fIDOver\";s:2:\"15\";s:3:\"url\";s:20:\"http://www.google.fr\";s:11:\"description\";s:11:\"Vers Google\";s:10:\"canbeShown\";b:1;s:7:\"pageCID\";i:67;s:8:\"pagePath\";N;s:23:\"pagePointerExternalLink\";N;s:15:\"openInNewWindow\";b:1;s:23:\"displayUnavailablePages\";b:0;}')
 ,(121,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";i:50;s:9:\"maxHeight\";i:80;s:3:\"fID\";s:2:\"14\";s:7:\"fIDOver\";s:2:\"15\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:4:\"test\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(124,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"14\";s:7:\"fIDOver\";s:2:\"15\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:4:\"test\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(135,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"14\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:13:\"Ver la marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(166,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";i:250;s:9:\"maxHeight\";i:140;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:14:\"Accueil Marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(168,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";i:200;s:9:\"maxHeight\";i:140;s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:19:\"Vers accueil Marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(170,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:19:\"Vers accueil Marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(177,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"12\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:19:\"Vers accueil Marine\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(209,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"16\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers BLog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(211,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"16\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers BLog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(212,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"19\";s:7:\"fIDOver\";s:2:\"20\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers BLog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(213,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"19\";s:7:\"fIDOver\";s:2:\"21\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers BLog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(214,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"22\";s:7:\"fIDOver\";s:2:\"23\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers BLog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(215,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"24\";s:7:\"fIDOver\";s:2:\"25\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers anout\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(216,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"24\";s:7:\"fIDOver\";s:2:\"26\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers anout\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(217,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"22\";s:7:\"fIDOver\";s:2:\"23\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers BLog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(220,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"22\";s:7:\"fIDOver\";s:2:\"23\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:9:\"Vers BLog\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(221,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"24\";s:7:\"fIDOver\";s:2:\"26\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:69;s:15:\"pageDescription\";s:10:\"Vers anout\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(223,'O:16:\"Pic29ButtonImage\":16:{s:25:\"\0Pic29ButtonImage\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"11\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:4:\"home\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(244,'O:16:\"Pic29ButtonImage\":15:{s:8:\"typeLink\";s:8:\"external\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"18\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:0;s:15:\"pageDescription\";s:0:\"\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:4:\"test\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}');


CREATE TABLE IF NOT EXISTS `btPic29ButtonSimpleBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29ButtonSimpleBlock VALUES(107,'')
 ,(108,'O:17:\"Pic29ButtonSimple\":11:{s:8:\"typeLink\";s:8:\"external\";s:5:\"width\";i:130;s:5:\"color\";s:5:\"green\";s:3:\"url\";s:20:\"http://www.google.fr\";s:4:\"name\";s:6:\"Google\";s:11:\"description\";s:16:\"Lien vers Google\";s:10:\"canbeShown\";b:1;s:7:\"pageCID\";i:69;s:8:\"pagePath\";N;s:23:\"pagePointerExternalLink\";N;s:23:\"displayUnavailablePages\";b:0;}')
 ,(110,'O:17:\"Pic29ButtonSimple\":11:{s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";i:130;s:5:\"color\";s:5:\"green\";s:3:\"url\";s:20:\"http://www.google.fr\";s:4:\"name\";s:6:\"Google\";s:11:\"description\";s:16:\"Lien vers Google\";s:10:\"canbeShown\";b:1;s:7:\"pageCID\";i:69;s:8:\"pagePath\";N;s:23:\"pagePointerExternalLink\";N;s:23:\"displayUnavailablePages\";b:0;}')
 ,(111,'O:17:\"Pic29ButtonSimple\":12:{s:26:\"\0Pic29ButtonSimple\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";s:1:\"0\";s:5:\"color\";s:4:\"blue\";s:3:\"url\";s:0:\"\";s:4:\"name\";s:0:\"\";s:11:\"description\";s:0:\"\";s:10:\"canbeShown\";b:1;s:7:\"pageCID\";i:69;s:8:\"pagePath\";N;s:23:\"pagePointerExternalLink\";N;s:23:\"displayUnavailablePages\";b:0;}')
 ,(113,'O:17:\"Pic29ButtonSimple\":12:{s:26:\"\0Pic29ButtonSimple\0_logger\";N;s:8:\"typeLink\";s:8:\"external\";s:5:\"width\";s:1:\"0\";s:5:\"color\";s:5:\"green\";s:3:\"url\";s:20:\"http://www.google.fr\";s:4:\"name\";s:6:\"Google\";s:11:\"description\";s:16:\"Lien vers Google\";s:10:\"canbeShown\";b:1;s:7:\"pageCID\";i:0;s:8:\"pagePath\";N;s:23:\"pagePointerExternalLink\";N;s:23:\"displayUnavailablePages\";b:0;}')
 ,(122,'O:17:\"Pic29ButtonSimple\":16:{s:26:\"\0Pic29ButtonSimple\0_logger\";N;s:8:\"typeLink\";s:8:\"external\";s:5:\"width\";i:100;s:5:\"color\";s:4:\"blue\";s:3:\"url\";N;s:5:\"label\";N;s:11:\"description\";N;s:11:\"externalUrl\";s:21:\"http://www.google.com\";s:13:\"externalLabel\";s:6:\"Google\";s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:15:\"Une description\";s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:19:\"externalDescription\";s:11:\"Vers Google\";s:23:\"externalOpenInNewWindow\";b:1;}')
 ,(123,'O:17:\"Pic29ButtonSimple\":16:{s:26:\"\0Pic29ButtonSimple\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";i:100;s:5:\"color\";s:5:\"green\";s:3:\"url\";N;s:5:\"label\";N;s:11:\"description\";N;s:11:\"externalUrl\";s:21:\"http://www.google.com\";s:13:\"externalLabel\";s:6:\"Google\";s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:15:\"Une description\";s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:19:\"externalDescription\";s:11:\"Vers Google\";s:23:\"externalOpenInNewWindow\";b:1;}')
 ,(136,'O:17:\"Pic29ButtonSimple\":16:{s:26:\"\0Pic29ButtonSimple\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";i:150;s:5:\"color\";s:4:\"blue\";s:3:\"url\";N;s:5:\"label\";N;s:11:\"description\";N;s:11:\"externalUrl\";s:0:\"\";s:13:\"externalLabel\";s:0:\"\";s:7:\"pageCID\";i:1;s:15:\"pageDescription\";s:9:\"sdfgzdfgz\";s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;}')
 ,(146,'O:17:\"Pic29ButtonSimple\":16:{s:26:\"\0Pic29ButtonSimple\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";i:100;s:5:\"color\";s:4:\"blue\";s:3:\"url\";N;s:5:\"label\";N;s:11:\"description\";N;s:11:\"externalUrl\";s:0:\"\";s:13:\"externalLabel\";s:0:\"\";s:7:\"pageCID\";i:71;s:15:\"pageDescription\";s:12:\"Vers le Blog\";s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;}')
 ,(222,'O:17:\"Pic29ButtonSimple\":16:{s:26:\"\0Pic29ButtonSimple\0_logger\";N;s:8:\"typeLink\";s:4:\"page\";s:5:\"width\";i:150;s:5:\"color\";s:4:\"blue\";s:3:\"url\";N;s:5:\"label\";N;s:11:\"description\";N;s:11:\"externalUrl\";s:0:\"\";s:13:\"externalLabel\";s:0:\"\";s:7:\"pageCID\";i:67;s:15:\"pageDescription\";s:8:\"xfbxwcvb\";s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;s:19:\"externalDescription\";s:0:\"\";s:23:\"externalOpenInNewWindow\";b:0;}');


CREATE TABLE IF NOT EXISTS `btPic29GooglemapBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29GooglemapBlock VALUES(234,'O:14:\"Pic29Googlemap\":8:{s:9:\"googlekey\";s:86:\"ABQIAAAA303mn4YJ-AjrOmQqRT0aGhQ8hea5Y60EfqxCxU8S_QXYftuCaRQwdH-xFrEud-73y156OT7PbI7OVw\";s:9:\"longitude\";s:9:\"47.876008\";s:8:\"latitude\";s:9:\"-3.910087\";s:4:\"zoom\";s:2:\"15\";s:5:\"width\";s:3:\"600\";s:6:\"height\";s:3:\"400\";s:7:\"mapType\";s:12:\"G_HYBRID_MAP\";s:10:\"infoWindow\";N;}')
 ,(235,'O:14:\"Pic29Googlemap\":8:{s:9:\"googlekey\";s:86:\"ABQIAAAA303mn4YJ-AjrOmQqRT0aGhQ8hea5Y60EfqxCxU8S_QXYftuCaRQwdH-xFrEud-73y156OT7PbI7OVw\";s:9:\"longitude\";s:9:\"47.876008\";s:8:\"latitude\";s:9:\"-3.910087\";s:4:\"zoom\";s:2:\"15\";s:5:\"width\";s:3:\"600\";s:6:\"height\";s:3:\"400\";s:7:\"mapType\";s:12:\"G_HYBRID_MAP\";s:10:\"infoWindow\";s:0:\"\";}')
 ,(237,'O:14:\"Pic29Googlemap\":8:{s:9:\"longitude\";s:8:\"-3.91008\";s:8:\"latitude\";s:8:\"47.87600\";s:4:\"zoom\";s:2:\"16\";s:5:\"width\";s:3:\"600\";s:6:\"height\";s:3:\"400\";s:4:\"isUI\";b:1;s:7:\"mapType\";s:12:\"G_HYBRID_MAP\";s:10:\"infoWindow\";s:23:\"<p>C&#180;est ici !</p>\";}')
 ,(238,'O:14:\"Pic29Googlemap\":8:{s:9:\"longitude\";s:8:\"-3.91399\";s:8:\"latitude\";s:8:\"47.87258\";s:4:\"zoom\";s:2:\"15\";s:5:\"width\";s:3:\"300\";s:6:\"height\";s:3:\"300\";s:4:\"isUI\";b:0;s:7:\"mapType\";s:12:\"G_HYBRID_MAP\";s:10:\"infoWindow\";s:0:\"\";}')
 ,(239,'O:14:\"Pic29Googlemap\":8:{s:9:\"longitude\";s:9:\"-3.910087\";s:8:\"latitude\";s:9:\"47.876008\";s:4:\"zoom\";s:2:\"15\";s:5:\"width\";s:3:\"600\";s:6:\"height\";s:3:\"400\";s:4:\"isUI\";b:1;s:7:\"mapType\";s:12:\"G_HYBRID_MAP\";s:10:\"infoWindow\";s:147:\"<p><img src=\"/concrete5pic29/index.php/download_file/view_inline/11/\" alt=\"logo.png\" width=\"111\" height=\"48\" /><br />On est ici !</p> <p>&nbsp;</p>\";}')
 ,(241,'O:14:\"Pic29Googlemap\":11:{s:9:\"longitude\";d:-3.91008699999999986829379849950782954692840576171875;s:8:\"latitude\";d:47.8760079999999987876435625366866588592529296875;s:4:\"zoom\";i:15;s:5:\"width\";i:600;s:6:\"height\";i:400;s:7:\"mapType\";s:12:\"G_HYBRID_MAP\";s:10:\"infoWindow\";s:301:\"<p><a title=\"About\" href=\"http://127.0.0.1/concrete5pic29/index.php?cID=69\">About</a></p> <p><a title=\"Search\" href=\"http://127.0.0.1/concrete5pic29/index.php?cID=67\"><img src=\"/concrete5pic29/index.php/download_file/view_inline/11/\" alt=\"logo.png\" width=\"111\" height=\"48\" /></a><br />On est ici !</p>\";s:12:\"isInfoWindow\";b:1;s:4:\"isUI\";b:1;s:10:\"isEditMode\";s:4:\"true\";s:9:\"isPreview\";b:0;}')
 ,(242,'O:14:\"Pic29Googlemap\":8:{s:9:\"longitude\";d:-3.9139900000000000801492205937393009662628173828125;s:8:\"latitude\";d:47.872579999999999245119397528469562530517578125;s:4:\"zoom\";i:15;s:5:\"width\";i:300;s:6:\"height\";i:300;s:4:\"isUI\";b:0;s:7:\"mapType\";s:12:\"G_HYBRID_MAP\";s:10:\"infoWindow\";s:20:\"<p>fgndsfghsdfhg</p>\";}');


CREATE TABLE IF NOT EXISTS `btPic29HeaderBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29HeaderBlock VALUES(183,'O:11:\"Pic29Header\":5:{s:20:\"\0Pic29Header\0_logger\";N;s:5:\"line1\";s:42:\"Notre Expertise, Votre sécurité Incendie\";s:5:\"line2\";s:52:\"Distribution, installation, conformité, maintenance\";s:5:\"line3\";s:62:\"des équipements incendie, ingénierie, conseils, diagnostics,\";s:5:\"line4\";s:51:\"réglementations, formations en sécurité incendie\";}');


CREATE TABLE IF NOT EXISTS `btPic29ImageLightboxBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29ImageLightboxBlock VALUES(245,'O:18:\"Pic29ImageLightbox\":15:{s:8:\"typeLink\";s:8:\"external\";s:8:\"maxWidth\";s:1:\"0\";s:9:\"maxHeight\";s:1:\"0\";s:3:\"fID\";s:2:\"18\";s:7:\"fIDOver\";s:1:\"0\";s:3:\"url\";N;s:11:\"description\";N;s:10:\"canbeShown\";b:1;s:15:\"openInNewWindow\";b:0;s:7:\"pageCID\";i:0;s:15:\"pageDescription\";s:0:\"\";s:11:\"externalUrl\";s:0:\"\";s:19:\"externalDescription\";s:4:\"test\";s:23:\"externalOpenInNewWindow\";b:0;s:23:\"displayUnavailablePages\";b:1;}')
 ,(246,'O:18:\"Pic29ImageLightbox\":6:{s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:11:\"description\";s:19:\"Test de description\";s:12:\"image_big_id\";s:2:\"14\";s:14:\"image_small_id\";s:2:\"24\";s:19:\"image_small_over_id\";s:2:\"26\";}')
 ,(247,'O:18:\"Pic29ImageLightbox\":12:{s:8:\"maxWidth\";i:0;s:9:\"maxHeight\";i:0;s:11:\"description\";s:19:\"Test de description\";s:14:\"image_small_id\";s:2:\"24\";s:19:\"image_small_over_id\";s:2:\"26\";s:8:\"image_id\";s:2:\"14\";s:7:\"file_id\";s:1:\"0\";s:7:\"page_id\";s:1:\"0\";s:3:\"url\";N;s:14:\"lightbox_width\";i:0;s:15:\"lightbox_height\";i:0;s:8:\"isIFrame\";b:0;}')
 ,(248,'O:18:\"Pic29ImageLightbox\":12:{s:8:\"maxWidth\";i:0;s:9:\"maxHeight\";i:0;s:11:\"description\";s:19:\"Test de description\";s:14:\"image_small_id\";s:2:\"24\";s:19:\"image_small_over_id\";s:2:\"26\";s:8:\"image_id\";s:2:\"14\";s:7:\"file_id\";s:1:\"0\";s:7:\"page_id\";s:2:\"69\";s:3:\"url\";N;s:14:\"lightbox_width\";i:0;s:15:\"lightbox_height\";i:0;s:8:\"isIFrame\";b:0;}');


CREATE TABLE IF NOT EXISTS `btPic29LightboxBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29LightboxBlock VALUES(249,'O:13:\"Pic29Lightbox\":19:{s:14:\"image_small_id\";N;s:19:\"image_small_over_id\";N;s:8:\"maxWidth\";N;s:9:\"maxHeight\";N;s:14:\"lightbox_width\";i:200;s:15:\"lightbox_height\";i:100;s:20:\"lightbox_description\";s:15:\"Image Terrestre\";s:11:\"description\";N;s:8:\"image_id\";s:1:\"0\";s:7:\"file_id\";s:1:\"0\";s:7:\"page_id\";s:2:\"82\";s:4:\"html\";s:193:\"<p>TEST HTML fdhsfdhsdfghs&nbsp; fzgdfgk&nbsp; sdfgsdfgs</p>\r\n<p><img src=\"/concrete5pic29/index.php/download_file/view_inline/24/\" alt=\"francais_glow_1_36x36.png\" width=\"36\" height=\"36\" /></p>\";s:3:\"url\";s:0:\"\";s:8:\"isIFrame\";b:0;s:16:\"link_description\";s:16:\"Visualiser image\";s:13:\"link_image_id\";s:2:\"24\";s:18:\"link_image_over_id\";s:2:\"26\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(252,'O:13:\"Pic29Lightbox\":15:{s:14:\"lightbox_width\";i:0;s:15:\"lightbox_height\";i:0;s:20:\"lightbox_description\";s:10:\"Background\";s:8:\"image_id\";s:1:\"0\";s:7:\"file_id\";s:1:\"0\";s:7:\"page_id\";s:1:\"0\";s:4:\"html\";s:0:\"\";s:3:\"url\";s:49:\"http://www.backgroundlabs.com/backgrounds/238.jpg\";s:8:\"isIFrame\";b:0;s:10:\"link_label\";s:22:\"Afficher un background\";s:12:\"link_tooltip\";s:22:\"Afficher un background\";s:13:\"link_image_id\";s:1:\"0\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}');


CREATE TABLE IF NOT EXISTS `btPic29LigneBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29LigneBlock VALUES(184,'O:10:\"Pic29Ligne\":3:{s:19:\"\0Pic29Ligne\0_logger\";N;s:5:\"lines\";a:5:{i:0;s:42:\"Notre Expertise, Votre sécurité Incendie\";i:1;s:52:\"Distribution, installation, conformité, maintenance\";i:2;s:62:\"des équipements incendie, ingénierie, conseils, diagnostics,\";i:3;s:51:\"réglementations, formations en sécurité incendie\";i:4;s:0:\"\";}s:5:\"style\";s:11:\"line_header\";}')
 ,(185,'O:10:\"Pic29Ligne\":3:{s:19:\"\0Pic29Ligne\0_logger\";N;s:5:\"lines\";a:5:{i:0;s:14:\"02 98 97 01 65\";i:1;s:14:\"info@pic29.com\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";}s:5:\"style\";s:19:\"line_header_address\";}')
 ,(186,'O:10:\"Pic29Ligne\":3:{s:19:\"\0Pic29Ligne\0_logger\";N;s:5:\"lines\";a:5:{i:0;s:98:\"Protection Incendie Cornouaille - BP 220 - 15 Rue des Thoniers - Quai Est - 29182 Concarneau cedex\";i:1;s:98:\"Téléphone : (33)-(0)2.97.97.01.65 >Télécopie (33)-(0)2.98.50.84.20 > courriel : info@pic29.com\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";}s:5:\"style\";s:11:\"line_footer\";}')
 ,(262,'O:10:\"Pic29Ligne\":2:{s:5:\"lines\";a:5:{i:0;s:14:\"02 98 97 01 65\";i:1;s:71:\"<a href=\'mailto:info@pic29.com\' title=\'Ecrivez nous\'>info@pic29.com</a>\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";}s:5:\"style\";s:19:\"line_header_address\";}')
 ,(260,'O:10:\"Pic29Ligne\":2:{s:5:\"lines\";a:5:{i:0;s:42:\"Notre Expertise, Votre sécurité Incendie\";i:1;s:52:\"Distribution, installation, conformité, maintenance\";i:2;s:62:\"des équipements incendie, ingénierie, conseils, diagnostics,\";i:3;s:51:\"réglementations, formations en sécurité incendie\";i:4;s:0:\"\";}s:5:\"style\";s:11:\"line_header\";}')
 ,(368,'O:10:\"Pic29Ligne\":2:{s:5:\"lines\";a:5:{i:0;s:14:\"02 98 97 01 65\";i:1;s:69:\"<a href=\'mailto:info@pic29.com\' title=\'Contact us\'>info@pic29.com</a>\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";}s:5:\"style\";s:19:\"line_header_address\";}')
 ,(366,'O:10:\"Pic29Ligne\":2:{s:5:\"lines\";a:5:{i:0;s:31:\"Our Expertise, Your Fire Safety\";i:1;s:51:\"Distribution, installation, compliance, maintenance\";i:2;s:55:\"fire equipment, engineering, medical advice, diagnosis,\";i:3;s:33:\"regulations, fire safety training\";i:4;s:0:\"\";}s:5:\"style\";s:11:\"line_header\";}')
 ,(297,'O:10:\"Pic29Ligne\":2:{s:5:\"lines\";a:5:{i:0;s:98:\"Protection Incendie Cornouaille - BP 220 - 15 Rue des Thoniers - Quai Est - 29182 Concarneau cedex\";i:1;s:155:\"Téléphone : (33)-(0)2.98.97.01.65 >Télécopie (33)-(0)2.98.50.84.20 > courriel : <a href=\'mailto:info@pic29.com\' title=\'Ecrivez nous\'>info@pic29.com</a>\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";}s:5:\"style\";s:11:\"line_footer\";}')
 ,(374,'O:10:\"Pic29Ligne\":2:{s:5:\"lines\";a:5:{i:0;s:98:\"Protection Incendie Cornouaille - BP 220 - 15 Rue des Thoniers - Quai Est - 29182 Concarneau cedex\";i:1;s:144:\"Telephone : (33)-(0)2.98.97.01.65 > Fax (33)-(0)2.98.50.84.20 > courriel : <a href=\'mailto:info@pic29.com\' title=\'Contact us\'>info@pic29.com</a>\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";}s:5:\"style\";s:11:\"line_footer\";}');


CREATE TABLE IF NOT EXISTS `btPic29LinkBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29LinkBlock VALUES(250,'O:9:\"Pic29Link\":12:{s:17:\"isOpenInNewWindow\";b:1;s:7:\"file_id\";s:2:\"27\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:2:\"82\";s:10:\"link_label\";s:12:\"Mon Libellé\";s:12:\"link_tooltip\";s:14:\"Mon Info Bulle\";s:9:\"link_type\";s:12:\"button_green\";s:17:\"link_button_width\";i:150;s:13:\"link_image_id\";s:2:\"24\";s:18:\"link_image_over_id\";s:2:\"26\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(251,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:1;s:10:\"isDownload\";b:1;s:7:\"file_id\";s:2:\"27\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:1:\"0\";s:10:\"link_label\";s:12:\"Mon Libellé\";s:12:\"link_tooltip\";s:9:\"Infobulle\";s:9:\"link_type\";s:6:\"simple\";s:17:\"link_button_width\";i:0;s:13:\"link_image_id\";s:1:\"0\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(254,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:1:\"1\";s:10:\"link_label\";s:4:\"Logo\";s:12:\"link_tooltip\";s:14:\"Vers l\'accueil\";s:9:\"link_type\";s:5:\"image\";s:17:\"link_button_width\";i:0;s:13:\"link_image_id\";s:2:\"11\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(331,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:3:\"107\";s:10:\"link_label\";s:9:\"Terrestre\";s:12:\"link_tooltip\";s:24:\"Vers l\'accueil Terrestre\";s:9:\"link_type\";s:12:\"button_green\";s:17:\"link_button_width\";i:158;s:13:\"link_image_id\";s:1:\"0\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(336,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:3:\"123\";s:10:\"link_label\";s:6:\"Marine\";s:12:\"link_tooltip\";s:31:\"Vers l\'acueil du secteur marine\";s:9:\"link_type\";s:11:\"button_blue\";s:17:\"link_button_width\";i:158;s:13:\"link_image_id\";s:1:\"0\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(264,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:2:\"89\";s:10:\"link_label\";s:15:\"English version\";s:12:\"link_tooltip\";s:15:\"English version\";s:9:\"link_type\";s:5:\"image\";s:17:\"link_button_width\";i:0;s:13:\"link_image_id\";s:2:\"31\";s:18:\"link_image_over_id\";s:2:\"32\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(364,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:2:\"89\";s:10:\"link_label\";s:4:\"Logo\";s:12:\"link_tooltip\";s:7:\"To Home\";s:9:\"link_type\";s:5:\"image\";s:17:\"link_button_width\";i:0;s:13:\"link_image_id\";s:2:\"28\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(290,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:3:\"100\";s:10:\"link_label\";s:4:\"Logo\";s:12:\"link_tooltip\";s:14:\"Vers l\'accueil\";s:9:\"link_type\";s:5:\"image\";s:17:\"link_button_width\";i:0;s:13:\"link_image_id\";s:2:\"28\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(393,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:3:\"149\";s:10:\"link_label\";s:6:\"Marine\";s:12:\"link_tooltip\";s:14:\"Go Marine home\";s:9:\"link_type\";s:11:\"button_blue\";s:17:\"link_button_width\";i:158;s:13:\"link_image_id\";s:1:\"0\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(370,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:3:\"100\";s:10:\"link_label\";s:18:\"Version française\";s:12:\"link_tooltip\";s:18:\"Version française\";s:9:\"link_type\";s:5:\"image\";s:17:\"link_button_width\";i:0;s:13:\"link_image_id\";s:2:\"34\";s:18:\"link_image_over_id\";s:2:\"35\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}')
 ,(383,'O:9:\"Pic29Link\":13:{s:17:\"isOpenInNewWindow\";b:0;s:10:\"isDownload\";b:0;s:7:\"file_id\";s:1:\"0\";s:3:\"url\";s:0:\"\";s:7:\"page_id\";s:3:\"152\";s:10:\"link_label\";s:11:\"Terrestrial\";s:12:\"link_tooltip\";s:19:\"Go Terrestrial home\";s:9:\"link_type\";s:12:\"button_green\";s:17:\"link_button_width\";i:158;s:13:\"link_image_id\";s:1:\"0\";s:18:\"link_image_over_id\";s:1:\"0\";s:16:\"link_image_width\";i:0;s:17:\"link_image_height\";i:0;}');


CREATE TABLE IF NOT EXISTS `btPic29MainMenuBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29MainMenuBlock VALUES(139,'O:13:\"Pic29MainMenu\":9:{s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:1;s:23:\"displaySubPageLevelsNum\";s:1:\"4\";s:9:\"cellWidth\";i:150;s:15:\"displaySubPages\";s:3:\"all\";s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayUnavailablePages\";b:0;s:9:\"menuColor\";s:4:\"blue\";}')
 ,(193,'O:13:\"Pic29MainMenu\":9:{s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:1;s:23:\"displaySubPageLevelsNum\";s:1:\"4\";s:9:\"cellWidth\";i:150;s:15:\"displaySubPages\";s:3:\"all\";s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayUnavailablePages\";b:0;s:9:\"menuColor\";s:4:\"blue\";}')
 ,(201,'O:13:\"Pic29MainMenu\":9:{s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:1;s:23:\"displaySubPageLevelsNum\";s:1:\"4\";s:9:\"cellWidth\";i:150;s:15:\"displaySubPages\";s:3:\"all\";s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayUnavailablePages\";b:0;s:9:\"menuColor\";s:4:\"blue\";}')
 ,(224,'O:13:\"Pic29MainMenu\":9:{s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:1;s:23:\"displaySubPageLevelsNum\";s:1:\"4\";s:9:\"cellWidth\";i:150;s:15:\"displaySubPages\";s:3:\"all\";s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayUnavailablePages\";b:0;s:9:\"menuColor\";s:4:\"blue\";}')
 ,(225,'O:13:\"Pic29MainMenu\":9:{s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:1;s:23:\"displaySubPageLevelsNum\";s:1:\"1\";s:9:\"cellWidth\";i:150;s:15:\"displaySubPages\";s:3:\"all\";s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayUnavailablePages\";b:0;s:9:\"menuColor\";s:4:\"blue\";}')
 ,(272,'O:13:\"Pic29MainMenu\":9:{s:12:\"displayPages\";s:6:\"custom\";s:15:\"displayPagesCID\";i:88;s:23:\"displaySubPageLevelsNum\";s:1:\"3\";s:9:\"cellWidth\";i:150;s:15:\"displaySubPages\";s:3:\"all\";s:20:\"displaySubPageLevels\";s:6:\"custom\";s:7:\"orderBy\";s:11:\"display_asc\";s:23:\"displayUnavailablePages\";b:0;s:9:\"menuColor\";s:4:\"blue\";}');


CREATE TABLE IF NOT EXISTS `btPic29MenuBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29MenuBlock VALUES(97,NULL)
 ,(98,NULL)
 ,(99,NULL)
 ,(112,NULL)
 ,(118,NULL)
 ,(104,NULL)
 ,(109,NULL)
 ,(137,NULL)
 ,(140,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:6:\"simple\";}')
 ,(141,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:6:\"simple\";}')
 ,(142,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:6:\"simple\";}')
 ,(143,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:6:\"simple\";}')
 ,(144,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:6:\"simple\";}')
 ,(145,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:6:\"simple\";}')
 ,(147,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:11:\"menu_button\";}')
 ,(148,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:11:\"menu_simple\";}')
 ,(149,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:11:\"menu_simple\";}')
 ,(151,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:11:\"menu_simple\";}')
 ,(153,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:9:\"menu_blue\";}')
 ,(152,'O:9:\"Pic29Menu\":4:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:13:\"parentPageCID\";i:1;s:5:\"style\";s:14:\"menu_red_arrow\";}')
 ,(155,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:9:\"Mon Titre\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:15:\"menu_green_halo\";}')
 ,(156,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:9:\"Mon Titre\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:14:\"menu_blue_halo\";}')
 ,(162,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:9:\"Mon Titre\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:14:\"menu_red_arrow\";}')
 ,(181,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:11:\"menu_footer\";}')
 ,(191,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:0;s:5:\"style\";s:15:\"menu_breadcrumb\";}')
 ,(192,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:14:\"Vous êtes ici\";s:13:\"parentPageCID\";i:0;s:5:\"style\";s:15:\"menu_breadcrumb\";}')
 ,(194,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:9:\"Société\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:14:\"menu_red_arrow\";}')
 ,(195,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:5:\"Titre\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:14:\"menu_blue_halo\";}')
 ,(196,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:6:\"footer\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:11:\"menu_footer\";}')
 ,(197,'O:9:\"Pic29Menu\":5:{s:18:\"\0Pic29Menu\0_logger\";N;s:17:\"pic29MenuElements\";N;s:5:\"title\";s:5:\"Titre\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:14:\"menu_red_arrow\";}')
 ,(227,'O:9:\"Pic29Menu\":4:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:12:\"menu_sitemap\";}')
 ,(229,'O:9:\"Pic29Menu\":4:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:17:\"menu_sitemap_blue\";}')
 ,(230,'O:9:\"Pic29Menu\":4:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:18:\"menu_sitemap_green\";}')
 ,(231,'O:9:\"Pic29Menu\":4:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:1;s:5:\"style\";s:17:\"menu_sitemap_blue\";}')
 ,(274,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:104;s:5:\"style\";s:11:\"menu_footer\";s:9:\"cellWidth\";i:135;}')
 ,(273,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:9:\"Société\";s:13:\"parentPageCID\";i:101;s:5:\"style\";s:14:\"menu_red_arrow\";s:9:\"cellWidth\";i:135;}')
 ,(343,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:12:\"Plan du Site\";s:13:\"parentPageCID\";i:100;s:5:\"style\";s:17:\"menu_sitemap_blue\";s:9:\"cellWidth\";i:135;}')
 ,(338,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:8:\"Secteurs\";s:13:\"parentPageCID\";i:125;s:5:\"style\";s:15:\"menu_green_halo\";s:9:\"cellWidth\";i:135;}')
 ,(340,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:8:\"Secteurs\";s:13:\"parentPageCID\";i:132;s:5:\"style\";s:14:\"menu_blue_halo\";s:9:\"cellWidth\";i:135;}')
 ,(322,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:91;s:5:\"style\";s:15:\"menu_main_green\";s:9:\"cellWidth\";i:158;}')
 ,(328,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:90;s:5:\"style\";s:14:\"menu_main_blue\";s:9:\"cellWidth\";i:158;}')
 ,(358,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:14:\"Vous êtes ici\";s:13:\"parentPageCID\";i:0;s:5:\"style\";s:15:\"menu_breadcrumb\";s:9:\"cellWidth\";i:135;}')
 ,(361,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:0;s:5:\"style\";s:15:\"menu_breadcrumb\";s:9:\"cellWidth\";i:135;}')
 ,(400,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:7:\"Sitemap\";s:13:\"parentPageCID\";i:89;s:5:\"style\";s:17:\"menu_sitemap_blue\";s:9:\"cellWidth\";i:135;}')
 ,(372,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:8:\"About us\";s:13:\"parentPageCID\";i:147;s:5:\"style\";s:14:\"menu_red_arrow\";s:9:\"cellWidth\";i:135;}')
 ,(389,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:146;s:5:\"style\";s:15:\"menu_main_green\";s:9:\"cellWidth\";i:158;}')
 ,(379,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:145;s:5:\"style\";s:14:\"menu_main_blue\";s:9:\"cellWidth\";i:158;}')
 ,(392,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:7:\"Sectors\";s:13:\"parentPageCID\";i:153;s:5:\"style\";s:15:\"menu_green_halo\";s:9:\"cellWidth\";i:135;}')
 ,(381,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:7:\"Sectors\";s:13:\"parentPageCID\";i:150;s:5:\"style\";s:14:\"menu_blue_halo\";s:9:\"cellWidth\";i:135;}')
 ,(385,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:148;s:5:\"style\";s:11:\"menu_footer\";s:9:\"cellWidth\";i:135;}')
 ,(403,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:0:\"\";s:13:\"parentPageCID\";i:0;s:5:\"style\";s:15:\"menu_breadcrumb\";s:9:\"cellWidth\";i:135;}')
 ,(405,'O:9:\"Pic29Menu\":5:{s:17:\"pic29MenuElements\";N;s:5:\"title\";s:14:\"Vous êtes ici\";s:13:\"parentPageCID\";i:0;s:5:\"style\";s:15:\"menu_breadcrumb\";s:9:\"cellWidth\";i:135;}');


CREATE TABLE IF NOT EXISTS `btPic29MultiLanguageBlock` (
  `bID` int(10) unsigned NOT NULL,
  `serialize` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btPic29MultiLanguageBlock VALUES(232,'O:18:\"Pic29MultiLanguage\":1:{s:8:\"elements\";a:0:{}}')
 ,(233,'O:18:\"Pic29MultiLanguage\":1:{s:8:\"elements\";a:2:{i:0;O:25:\"Pic29MultiLanguageElement\":2:{s:6:\"langue\";s:2:\"fr\";s:7:\"pageCID\";s:2:\"67\";}i:1;O:25:\"Pic29MultiLanguageElement\":2:{s:6:\"langue\";s:2:\"en\";s:7:\"pageCID\";s:2:\"69\";}}}')
 ,(253,'O:18:\"Pic29MultiLanguage\":1:{s:8:\"elements\";a:2:{i:0;O:25:\"Pic29MultiLanguageElement\":2:{s:6:\"langue\";s:2:\"fr\";s:7:\"pageCID\";s:2:\"88\";}i:1;O:25:\"Pic29MultiLanguageElement\":2:{s:6:\"langue\";s:2:\"en\";s:7:\"pageCID\";s:2:\"89\";}}}')
 ,(313,'O:18:\"Pic29MultiLanguage\":1:{s:8:\"elements\";a:2:{i:0;O:25:\"Pic29MultiLanguageElement\":2:{s:6:\"langue\";s:2:\"fr\";s:7:\"pageCID\";s:3:\"100\";}i:1;O:25:\"Pic29MultiLanguageElement\":2:{s:6:\"langue\";s:2:\"en\";s:7:\"pageCID\";s:2:\"89\";}}}');


CREATE TABLE IF NOT EXISTS `btRssDisplay` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `dateFormat` varchar(100) DEFAULT NULL,
  `itemsToDisplay` int(10) unsigned DEFAULT '5',
  `showSummary` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `launchInNewWindow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btSearch` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `buttonText` varchar(128) DEFAULT NULL,
  `baseSearchPath` varchar(255) DEFAULT NULL,
  `resultsURL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btSearch VALUES(19,'Search Results','Search','','')
 ,(22,'Search Your Site','Go','','/search/search-results')
 ,(29,'Tags','','','/search/search-results');


CREATE TABLE IF NOT EXISTS `btSlideshow` (
  `bID` int(10) unsigned NOT NULL,
  `fsID` int(10) unsigned DEFAULT NULL,
  `playback` varchar(50) DEFAULT NULL,
  `duration` int(10) unsigned DEFAULT NULL,
  `fadeDuration` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btSlideshow VALUES(47,0,'ORDER',NULL,NULL)
 ,(48,0,'ORDER',NULL,NULL)
 ,(49,0,'ORDER',NULL,NULL);


CREATE TABLE IF NOT EXISTS `btSlideshowImg` (
  `slideshowImgId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bID` int(10) unsigned DEFAULT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `duration` int(10) unsigned DEFAULT NULL,
  `fadeDuration` int(10) unsigned DEFAULT NULL,
  `groupSet` int(10) unsigned DEFAULT NULL,
  `position` int(10) unsigned DEFAULT NULL,
  `imgHeight` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`slideshowImgId`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=latin1;

INSERT INTO btSlideshowImg VALUES(5,47,10,'',5,2,0,0,480)
 ,(6,47,9,'',5,2,0,1,1024)
 ,(7,47,8,'',5,2,0,2,768)
 ,(8,47,7,'',5,2,0,3,768)
 ,(9,47,6,'',5,2,0,4,768)
 ,(19,48,6,'',5,2,0,4,768)
 ,(18,48,7,'',5,2,0,3,768)
 ,(17,48,8,'',5,2,0,2,768)
 ,(16,48,9,'',5,2,0,1,1024)
 ,(15,48,10,'',5,2,0,0,480)
 ,(27,49,8,'',5,2,0,2,768)
 ,(26,49,9,'',5,2,0,1,1024)
 ,(25,49,10,'',5,2,0,0,480);


CREATE TABLE IF NOT EXISTS `btSlideshowImgJs` (
  `slideshowImgId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bID` int(10) unsigned DEFAULT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `duration` int(10) unsigned DEFAULT NULL,
  `fadeDuration` int(10) unsigned DEFAULT NULL,
  `groupSet` int(10) unsigned DEFAULT NULL,
  `position` int(10) unsigned DEFAULT NULL,
  `imgHeight` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`slideshowImgId`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

INSERT INTO btSlideshowImgJs VALUES(6,54,4,'',0,0,0,2,0)
 ,(5,54,3,'',0,0,0,1,0)
 ,(4,54,2,'',0,0,0,0,0)
 ,(12,55,2,'',0,0,0,2,0)
 ,(11,55,3,'',0,0,0,1,0)
 ,(10,55,4,'',0,0,0,0,0)
 ,(42,57,1,'',0,0,0,2,0)
 ,(41,57,4,'',0,0,0,1,0)
 ,(40,57,3,'',0,0,0,0,0)
 ,(43,81,2,'',0,0,0,0,0)
 ,(44,81,5,'',0,0,0,1,0)
 ,(45,81,4,'',0,0,0,2,0)
 ,(46,81,1,'',0,0,0,3,0)
 ,(73,82,3,'',0,0,0,2,0)
 ,(72,82,2,'',0,0,0,1,0)
 ,(71,82,4,'',0,0,0,0,0);


CREATE TABLE IF NOT EXISTS `btSlideshowJs` (
  `bID` int(10) unsigned NOT NULL,
  `fsID` int(10) unsigned DEFAULT NULL,
  `data` varchar(5000) DEFAULT '',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btSlideshowJs VALUES(54,0,'')
 ,(55,0,'')
 ,(57,0,'')
 ,(81,0,'')
 ,(82,0,'')
 ,(164,NULL,'a:38:{s:5:\"width\";i:300;s:6:\"height\";i:120;s:12:\"button_width\";i:24;s:13:\"button_height\";i:24;s:13:\"button_margin\";i:4;s:10:\"auto_start\";i:1;s:16:\"transition_delay\";i:2000;s:10:\"transition\";s:6:\"random\";s:16:\"transition_speed\";i:500;s:12:\"cpanel_align\";s:2:\"BR\";s:15:\"cpanel_position\";s:6:\"inside\";s:11:\"timer_align\";s:3:\"top\";s:14:\"display_thumbs\";i:0;s:16:\"display_dbuttons\";i:0;s:18:\"display_playbutton\";i:0;s:13:\"display_timer\";i:0;s:15:\"display_numbers\";i:0;s:12:\"tooltip_type\";s:5:\"image\";s:15:\"mouseover_pause\";i:0;s:16:\"cpanel_mouseover\";i:0;s:14:\"text_mouseover\";i:0;s:11:\"text_effect\";s:4:\"fade\";s:9:\"text_sync\";i:1;s:7:\"shuffle\";i:0;s:10:\"block_size\";s:2:\"75\";s:9:\"vert_size\";s:2:\"50\";s:9:\"horz_size\";s:2:\"50\";s:11:\"block_delay\";s:2:\"25\";s:13:\"vstripe_delay\";s:2:\"75\";s:13:\"hstripe_delay\";s:2:\"75\";s:7:\"imgFIDs\";a:0:{}s:3:\"url\";a:0:{}s:8:\"duration\";a:0:{}s:12:\"fadeDuration\";a:0:{}s:8:\"groupSet\";a:0:{}s:9:\"imgHeight\";a:0:{}s:4:\"fsID\";i:0;s:6:\"images\";a:2:{i:0;a:18:{s:3:\"fID\";i:13;s:8:\"duration\";s:1:\"0\";s:12:\"fadeDuration\";s:1:\"0\";s:8:\"groupSet\";s:0:\"\";s:9:\"imgHeight\";s:0:\"\";s:5:\"title\";s:0:\"\";s:12:\"with_textbox\";i:0;s:9:\"with_link\";i:0;s:19:\"with_img_transition\";i:0;s:8:\"box_text\";s:0:\"\";s:7:\"box_top\";s:1:\"0\";s:8:\"box_left\";s:1:\"0\";s:9:\"box_width\";s:1:\"0\";s:9:\"box_color\";s:0:\"\";s:11:\"box_bgcolor\";s:0:\"\";s:3:\"url\";s:0:\"\";s:14:\"img_transition\";s:4:\"fade\";s:5:\"delay\";s:4:\"2000\";}i:1;a:18:{s:3:\"fID\";i:12;s:8:\"duration\";s:0:\"\";s:12:\"fadeDuration\";s:0:\"\";s:8:\"groupSet\";s:0:\"\";s:9:\"imgHeight\";s:0:\"\";s:5:\"title\";s:0:\"\";s:12:\"with_textbox\";i:0;s:9:\"with_link\";i:0;s:19:\"with_img_transition\";i:0;s:8:\"box_text\";s:0:\"\";s:7:\"box_top\";s:1:\"0\";s:8:\"box_left\";s:1:\"0\";s:9:\"box_width\";s:1:\"0\";s:9:\"box_color\";s:0:\"\";s:11:\"box_bgcolor\";s:0:\"\";s:3:\"url\";s:0:\"\";s:14:\"img_transition\";s:4:\"fade\";s:5:\"delay\";s:4:\"2000\";}}}')
 ,(165,NULL,'a:38:{s:5:\"width\";i:300;s:6:\"height\";i:145;s:12:\"button_width\";i:24;s:13:\"button_height\";i:24;s:13:\"button_margin\";i:4;s:10:\"auto_start\";i:1;s:16:\"transition_delay\";i:2000;s:10:\"transition\";s:6:\"random\";s:16:\"transition_speed\";i:500;s:12:\"cpanel_align\";s:2:\"BR\";s:15:\"cpanel_position\";s:6:\"inside\";s:11:\"timer_align\";s:3:\"top\";s:14:\"display_thumbs\";i:0;s:16:\"display_dbuttons\";i:0;s:18:\"display_playbutton\";i:0;s:13:\"display_timer\";i:0;s:15:\"display_numbers\";i:0;s:12:\"tooltip_type\";s:5:\"image\";s:15:\"mouseover_pause\";i:0;s:16:\"cpanel_mouseover\";i:0;s:14:\"text_mouseover\";i:0;s:11:\"text_effect\";s:4:\"fade\";s:9:\"text_sync\";i:1;s:7:\"shuffle\";i:0;s:10:\"block_size\";s:2:\"75\";s:9:\"vert_size\";s:2:\"50\";s:9:\"horz_size\";s:2:\"50\";s:11:\"block_delay\";s:2:\"25\";s:13:\"vstripe_delay\";s:2:\"75\";s:13:\"hstripe_delay\";s:2:\"75\";s:7:\"imgFIDs\";a:0:{}s:3:\"url\";a:0:{}s:8:\"duration\";a:0:{}s:12:\"fadeDuration\";a:0:{}s:8:\"groupSet\";a:0:{}s:9:\"imgHeight\";a:0:{}s:4:\"fsID\";i:0;s:6:\"images\";a:2:{i:0;a:18:{s:3:\"fID\";i:13;s:8:\"duration\";s:1:\"0\";s:12:\"fadeDuration\";s:1:\"0\";s:8:\"groupSet\";s:0:\"\";s:9:\"imgHeight\";s:0:\"\";s:5:\"title\";s:0:\"\";s:12:\"with_textbox\";i:0;s:9:\"with_link\";i:0;s:19:\"with_img_transition\";i:0;s:8:\"box_text\";s:0:\"\";s:7:\"box_top\";s:1:\"0\";s:8:\"box_left\";s:1:\"0\";s:9:\"box_width\";s:1:\"0\";s:9:\"box_color\";s:0:\"\";s:11:\"box_bgcolor\";s:0:\"\";s:3:\"url\";s:0:\"\";s:14:\"img_transition\";s:4:\"fade\";s:5:\"delay\";s:4:\"2000\";}i:1;a:18:{s:3:\"fID\";i:12;s:8:\"duration\";s:0:\"\";s:12:\"fadeDuration\";s:0:\"\";s:8:\"groupSet\";s:0:\"\";s:9:\"imgHeight\";s:0:\"\";s:5:\"title\";s:0:\"\";s:12:\"with_textbox\";i:0;s:9:\"with_link\";i:0;s:19:\"with_img_transition\";i:0;s:8:\"box_text\";s:0:\"\";s:7:\"box_top\";s:1:\"0\";s:8:\"box_left\";s:1:\"0\";s:9:\"box_width\";s:1:\"0\";s:9:\"box_color\";s:0:\"\";s:11:\"box_bgcolor\";s:0:\"\";s:3:\"url\";s:0:\"\";s:14:\"img_transition\";s:4:\"fade\";s:5:\"delay\";s:4:\"2000\";}}}');


CREATE TABLE IF NOT EXISTS `btSuperfish` (
  `bID` int(10) unsigned NOT NULL,
  `orderBy` varchar(255) DEFAULT 'alpha_asc',
  `displayPages` varchar(255) DEFAULT 'top',
  `displayPagesCID` int(10) unsigned NOT NULL DEFAULT '1',
  `displayPagesIncludeSelf` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `displaySubPages` varchar(255) DEFAULT 'none',
  `displaySubPageLevels` varchar(255) DEFAULT 'none',
  `displaySubPageLevelsNum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `displayUnavailablePages` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `menuColor` varchar(7) DEFAULT '#eeeeee',
  `menuColorHover` varchar(7) DEFAULT '#cccccc',
  `menuColorTxt` varchar(7) DEFAULT '#333333',
  `displayTime` smallint(6) DEFAULT '5',
  `floatNav` varchar(32) DEFAULT 'right',
  `layout` varchar(32) DEFAULT 'horizontal',
  `cellWidth` smallint(6) DEFAULT NULL,
  `autoWidthMode` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btSuperfish VALUES(87,'display_asc','top',0,0,'all','custom',2,0,'#79c6d4','#6fd8eb','#555555',800,'left','horizontal',135,1)
 ,(88,'display_asc','top',0,0,'all','custom',2,0,'#79c6d4','#6fd8eb','#555555',800,'left','horizontal',135,1)
 ,(89,'display_asc','top',0,0,'all','custom',3,0,'#79c6d4','#6fd8eb','#555555',800,'right','vertical',140,1)
 ,(90,'display_asc','custom',1,0,'all','custom',1,0,'#79c6d4','#6fd8eb','#555555',800,'right','vertical',140,1);


CREATE TABLE IF NOT EXISTS `btSurvey` (
  `bID` int(10) unsigned NOT NULL,
  `question` varchar(255) DEFAULT '',
  `requiresRegistration` int(11) DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btSurvey VALUES(37,'What\'s easiest?',0);


CREATE TABLE IF NOT EXISTS `btSurveyOptions` (
  `optionID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bID` int(11) DEFAULT NULL,
  `optionName` varchar(255) DEFAULT NULL,
  `displayOrder` int(11) DEFAULT '0',
  PRIMARY KEY (`optionID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO btSurveyOptions VALUES(1,37,'Fixing a typo when I see it.',0)
 ,(2,37,'Adding a form as easily as content.',1)
 ,(3,37,'Block area layouts are pretty cool.',2);


CREATE TABLE IF NOT EXISTS `btSurveyResults` (
  `resultID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `optionID` int(10) unsigned DEFAULT '0',
  `uID` int(10) unsigned DEFAULT '0',
  `bID` int(11) DEFAULT NULL,
  `cID` int(11) DEFAULT NULL,
  `ipAddress` varchar(128) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`resultID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btTags` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `targetCID` int(11) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btTags VALUES(23,'Tags',68)
 ,(33,'Tags',68)
 ,(39,'Tags',68)
 ,(74,'Tags',0)
 ,(75,'',1);


CREATE TABLE IF NOT EXISTS `btTestimonial` (
  `bID` int(10) unsigned NOT NULL,
  `testimonial` longtext,
  `name` longtext,
  `company` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btTfePanoramaViewer` (
  `bID` int(10) unsigned NOT NULL,
  `fID` longtext,
  `AutorotatorStatus` longtext,
  `AutorotatorSpeed` longtext,
  `AutorotatorStartDelay` longtext,
  `AutorotatorRestartDelay` longtext,
  `PanoramaHeight` longtext,
  `PanoramaWidth` longtext,
  `RotationOrder` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btTfePanoramaViewer VALUES(0,'8','false','0.0625','0','0','200','800','clockwise');


CREATE TABLE IF NOT EXISTS `btTravisnSpacer` (
  `bID` int(10) unsigned NOT NULL,
  `spacerHeight` varchar(10) DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btTravisnSpacer VALUES(44,'10');


CREATE TABLE IF NOT EXISTS `btVideo` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `width` int(10) unsigned DEFAULT NULL,
  `height` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




CREATE TABLE IF NOT EXISTS `btYouTube` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `videoURL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btYouTube VALUES(6,'Basic Editing','http://www.youtube.com/watch?v=oYSOFTNLbKY');


CREATE TABLE IF NOT EXISTS `btZoomImage` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT '0',
  `altText` varchar(255) DEFAULT NULL,
  `thumbnailWidth` int(11) DEFAULT NULL,
  `thumbnailHeight` int(11) DEFAULT NULL,
  `displayCaption` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO btZoomImage VALUES(42,4,'',200,200,0)
 ,(43,4,'',100,100,0)
 ,(45,1,'',200,200,0);

