-- Table structure for table `servicemanager_servicedefaultrole`
--

CREATE TABLE `servicemanager_servicedefaultrole` (
  `ServiceDefaultRoleId` bigint(20) NOT NULL,
  `roleId` bigint(20) DEFAULT NULL,
  `serviceId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ServiceDefaultRoleId`),
  KEY `IX_D025BC91` (`serviceId`),
  KEY `IX_41283AF6` (`serviceId`,`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servicemanager_servicedefaultrole`
--

INSERT INTO `servicemanager_servicedefaultrole` VALUES (313902,0,313901),(313904,0,313903),(313906,11120,313905),(313907,11121,313905),(313908,11211,313905),(313909,11212,313905),(313910,11214,313905),(313911,11215,313905),(313914,11217,313905),(313912,11218,313905),(313913,11219,313905),(313915,11220,313905),(313916,11221,313905),(313917,11222,313905),(313918,11223,313905),(313919,19558,313905),(313920,19559,313905),(313921,19560,313905),(313922,19561,313905),(313923,36723,313905),(313924,165743,313905),(313926,0,313925),(313928,0,313927),(313930,11120,313929),(313931,11121,313929),(313933,0,313932),(313935,0,313934),(313937,11120,313936),(313938,11121,313936),(313940,11120,313939),(313941,11121,313939),(313943,11120,313942),(313944,11121,313942),(313946,0,313945),(313948,0,313947),(313950,0,313949),(313952,0,313951),(313954,11120,313953),(313955,11121,313953),(313957,11120,313956),(313958,11121,313956),(313960,0,313959),(313962,0,313961),(313964,0,313963),(313966,0,313965),(313968,11214,313967),(313969,11220,313967),(313970,36723,313967),(314302,0,314301),(314321,11120,314303),(314322,11121,314303),(314323,11208,314303),(314324,11211,314303),(314325,11212,314303),(314326,11214,314303),(314327,11215,314303),(314328,11217,314303),(314329,11218,314303),(314330,11219,314303),(314331,11220,314303),(314332,11221,314303),(314333,19558,314303),(314334,19559,314303),(314335,19560,314303),(314336,19561,314303),(314337,36723,314303),(314339,0,314338),(314341,11120,314340),(314342,11208,314340),(314343,11220,314340),(314344,11221,314340),(314346,11120,314345),(314347,11121,314345),(314348,11208,314345),(314349,11211,314345),(314350,11212,314345),(314351,11214,314345),(314352,11215,314345),(314353,11217,314345),(314354,11218,314345),(314355,11219,314345),(314356,11220,314345),(314357,11221,314345),(314358,11222,314345),(314359,11223,314345),(314360,19558,314345),(314361,19559,314345),(314362,19560,314345),(314363,19561,314345),(314364,36723,314345),(314366,11208,314365),(314367,11220,314365),(314369,0,314368),(314371,0,314370),(314373,0,314372),(314375,0,314374),(314377,11120,314376),(314378,11121,314376),(314379,11211,314376),(314380,11212,314376),(314381,11214,314376),(314382,11215,314376),(314383,11217,314376),(314384,11218,314376),(314385,11219,314376),(314386,11220,314376),(314387,11221,314376),(314388,11222,314376),(314389,11223,314376),(314390,19558,314376),(314391,19559,314376),(314392,19560,314376),(314393,19561,314376),(314394,36723,314376),(314396,11120,314395),(314397,11121,314395),(314398,11211,314395),(314399,11212,314395),(314400,11214,314395),(314401,11215,314395),(314402,11217,314395),(314403,11218,314395),(314404,11219,314395),(314405,11220,314395),(314406,11221,314395),(314407,11222,314395),(314408,19558,314395),(314409,19559,314395),(314410,19560,314395),(314411,19561,314395),(314412,36723,314395),(314414,11120,314413),(314415,11208,314413),(314416,11209,314413),(314417,11215,314413),(314418,11220,314413),(314419,11222,314413),(314421,0,314420),(314423,11120,314422),(314424,11121,314422),(314425,11208,314422),(314426,11209,314422),(314427,11211,314422),(314428,11212,314422),(314429,11214,314422),(314430,11215,314422),(314431,11217,314422),(314432,11218,314422),(314433,11219,314422),(314434,11220,314422),(314435,11221,314422),(314436,11222,314422),(314437,19558,314422),(314438,19559,314422),(314439,19560,314422),(314440,19561,314422),(314441,36723,314422),(314443,0,314442),(314445,11120,314444),(314446,11121,314444),(314447,11209,314444),(314448,11211,314444),(314449,11212,314444),(314450,11214,314444),(314451,11215,314444),(314452,11217,314444),(314453,11218,314444),(314454,11219,314444),(314455,11220,314444),(314456,11221,314444),(314457,11222,314444),(314458,11223,314444),(314459,19558,314444),(314460,19560,314444),(314461,36723,314444),(314463,11208,314462),(314464,11209,314462),(314673,11120,314672),(314674,11121,314672),(314676,0,314675),(314683,11120,314682),(314684,11121,314682);

--
-- Table structure for table `servicemanager_servicediffusion`
--

CREATE TABLE `servicemanager_servicediffusion` (
  `serviceDiffusionId` bigint(20) NOT NULL,
  `etabId` bigint(20) DEFAULT NULL,
  `serviceId` bigint(20) DEFAULT NULL,
  `isAvailable` tinyint(4) DEFAULT NULL,
  `serviceUrl` longtext,
  PRIMARY KEY (`serviceDiffusionId`),
  KEY `IX_F6506ADC` (`etabId`),
  KEY `IX_41024963` (`serviceId`),
  KEY `IX_D1FC2162` (`serviceId`,`etabId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servicemanager_servicediffusion`
--

INSERT INTO `servicemanager_servicediffusion` VALUES (314472,0,313901,1,''),(314480,0,313932,1,''),(314488,0,313903,1,''),(314514,0,313905,1,''),(314523,0,313942,1,''),(314531,0,313934,1,''),(314539,0,313947,1,''),(314548,0,313953,1,''),(314557,0,313939,1,''),(314565,0,313925,1,''),(314573,0,313927,1,''),(314582,0,313936,1,''),(314591,0,313929,1,''),(314599,0,313945,1,''),(314607,0,313959,1,''),(314615,0,313949,1,''),(314624,0,313956,1,''),(314632,0,313951,1,''),(314643,18210,313967,1,''),(314693,0,314682,1,''),(314707,18210,314413,1,'');

--
-- Table structure for table `servicemanager_servicefilteretab`
--

CREATE TABLE `servicemanager_servicefilteretab` (
  `ServiceFilterEtabId` bigint(20) NOT NULL,
  `serviceId` bigint(20) DEFAULT NULL,
  `etabId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ServiceFilterEtabId`),
  KEY `IX_BE5D0AC4` (`serviceId`),
  KEY `IX_1AF3F1C3` (`serviceId`,`etabId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servicemanager_servicefilteretab`
--


--
-- Table structure for table `servicemanager_servicepopulation`
--

CREATE TABLE `servicemanager_servicepopulation` (
  `ServicePopulationId` bigint(20) NOT NULL,
  `populationId` bigint(20) DEFAULT NULL,
  `serviceId` bigint(20) DEFAULT NULL,
  `etabId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ServicePopulationId`),
  KEY `IX_C8364EFD` (`populationId`),
  KEY `IX_15BE383F` (`serviceId`),
  KEY `IX_C5B9743E` (`serviceId`,`etabId`),
  KEY `IX_E31DF33B` (`serviceId`,`populationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servicemanager_servicepopulation`
--

INSERT INTO `servicemanager_servicepopulation` VALUES (314466,314465,313901,0),(314474,314473,313932,0),(314482,314481,313903,0),(314490,314489,313905,0),(314516,314515,313942,0),(314525,314524,313934,0),(314533,314532,313947,0),(314541,314540,313953,0),(314550,314549,313939,0),(314559,314558,313925,0),(314567,314566,313927,0),(314575,314574,313936,0),(314584,314583,313929,0),(314593,314592,313945,0),(314601,314600,313959,0),(314609,314608,313949,0),(314617,314616,313956,0),(314626,314625,313951,0),(314634,314633,313967,18210),(314686,314685,314682,0),(314695,314694,314413,18210);

--
-- Table structure for table `shard`
--

CREATE TABLE `shard` (
  `shardId` bigint(20) NOT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`shardId`),
  KEY `IX_DA5F4359` (`classNameId`,`classPK`),
  KEY `IX_941BA8C3` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shard`
--

INSERT INTO `shard` VALUES (10203,10010,10202,'default');

--
-- Table structure for table `shoppingcart`
--

CREATE TABLE `shoppingcart` (
  `cartId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `itemIds` longtext,
  `couponCodes` varchar(75) DEFAULT NULL,
  `altShipping` int(11) DEFAULT NULL,
  `insure` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`cartId`),
  UNIQUE KEY `IX_FC46FE16` (`groupId`,`userId`),
  KEY `IX_C28B41DC` (`groupId`),
  KEY `IX_54101CC8` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingcart`
--


--
-- Table structure for table `shoppingcategory`
--

CREATE TABLE `shoppingcategory` (
  `categoryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `parentCategoryId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext,
  PRIMARY KEY (`categoryId`),
  KEY `IX_5F615D3E` (`groupId`),
  KEY `IX_1E6464F5` (`groupId`,`parentCategoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingcategory`
--


--
-- Table structure for table `shoppingcoupon`
--

CREATE TABLE `shoppingcoupon` (
  `couponId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `code_` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext,
  `startDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  `limitCategories` longtext,
  `limitSkus` longtext,
  `minOrder` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `discountType` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`couponId`),
  UNIQUE KEY `IX_DC60CFAE` (`code_`),
  KEY `IX_3251AF16` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingcoupon`
--


--
-- Table structure for table `shoppingitem`
--

CREATE TABLE `shoppingitem` (
  `itemId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `categoryId` bigint(20) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `description` longtext,
  `properties` longtext,
  `fields_` tinyint(4) DEFAULT NULL,
  `fieldsQuantities` longtext,
  `minQuantity` int(11) DEFAULT NULL,
  `maxQuantity` int(11) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `taxable` tinyint(4) DEFAULT NULL,
  `shipping` double DEFAULT NULL,
  `useShippingFormula` tinyint(4) DEFAULT NULL,
  `requiresShipping` tinyint(4) DEFAULT NULL,
  `stockQuantity` int(11) DEFAULT NULL,
  `featured_` tinyint(4) DEFAULT NULL,
  `sale_` tinyint(4) DEFAULT NULL,
  `smallImage` tinyint(4) DEFAULT NULL,
  `smallImageId` bigint(20) DEFAULT NULL,
  `smallImageURL` longtext,
  `mediumImage` tinyint(4) DEFAULT NULL,
  `mediumImageId` bigint(20) DEFAULT NULL,
  `mediumImageURL` longtext,
  `largeImage` tinyint(4) DEFAULT NULL,
  `largeImageId` bigint(20) DEFAULT NULL,
  `largeImageURL` longtext,
  `groupId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`itemId`),
  UNIQUE KEY `IX_1C717CA6` (`companyId`,`sku`),
  KEY `IX_C8EACF2E` (`categoryId`),
  KEY `IX_903DC750` (`largeImageId`),
  KEY `IX_D217AB30` (`mediumImageId`),
  KEY `IX_FF203304` (`smallImageId`),
  KEY `IX_FEFE7D76` (`groupId`,`categoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingitem`
--


--
-- Table structure for table `shoppingitemfield`
--

CREATE TABLE `shoppingitemfield` (
  `itemFieldId` bigint(20) NOT NULL,
  `itemId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `values_` longtext,
  `description` longtext,
  PRIMARY KEY (`itemFieldId`),
  KEY `IX_6D5F9B87` (`itemId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingitemfield`
--


--
-- Table structure for table `shoppingitemprice`
--

CREATE TABLE `shoppingitemprice` (
  `itemPriceId` bigint(20) NOT NULL,
  `itemId` bigint(20) DEFAULT NULL,
  `minQuantity` int(11) DEFAULT NULL,
  `maxQuantity` int(11) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `taxable` tinyint(4) DEFAULT NULL,
  `shipping` double DEFAULT NULL,
  `useShippingFormula` tinyint(4) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`itemPriceId`),
  KEY `IX_EA6FD516` (`itemId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingitemprice`
--


--
-- Table structure for table `shoppingorder`
--

CREATE TABLE `shoppingorder` (
  `orderId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `number_` varchar(75) DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `shipping` double DEFAULT NULL,
  `altShipping` varchar(75) DEFAULT NULL,
  `requiresShipping` tinyint(4) DEFAULT NULL,
  `insure` tinyint(4) DEFAULT NULL,
  `insurance` double DEFAULT NULL,
  `couponCodes` varchar(75) DEFAULT NULL,
  `couponDiscount` double DEFAULT NULL,
  `billingFirstName` varchar(75) DEFAULT NULL,
  `billingLastName` varchar(75) DEFAULT NULL,
  `billingEmailAddress` varchar(75) DEFAULT NULL,
  `billingCompany` varchar(75) DEFAULT NULL,
  `billingStreet` varchar(75) DEFAULT NULL,
  `billingCity` varchar(75) DEFAULT NULL,
  `billingState` varchar(75) DEFAULT NULL,
  `billingZip` varchar(75) DEFAULT NULL,
  `billingCountry` varchar(75) DEFAULT NULL,
  `billingPhone` varchar(75) DEFAULT NULL,
  `shipToBilling` tinyint(4) DEFAULT NULL,
  `shippingFirstName` varchar(75) DEFAULT NULL,
  `shippingLastName` varchar(75) DEFAULT NULL,
  `shippingEmailAddress` varchar(75) DEFAULT NULL,
  `shippingCompany` varchar(75) DEFAULT NULL,
  `shippingStreet` varchar(75) DEFAULT NULL,
  `shippingCity` varchar(75) DEFAULT NULL,
  `shippingState` varchar(75) DEFAULT NULL,
  `shippingZip` varchar(75) DEFAULT NULL,
  `shippingCountry` varchar(75) DEFAULT NULL,
  `shippingPhone` varchar(75) DEFAULT NULL,
  `ccName` varchar(75) DEFAULT NULL,
  `ccType` varchar(75) DEFAULT NULL,
  `ccNumber` varchar(75) DEFAULT NULL,
  `ccExpMonth` int(11) DEFAULT NULL,
  `ccExpYear` int(11) DEFAULT NULL,
  `ccVerNumber` varchar(75) DEFAULT NULL,
  `comments` longtext,
  `ppTxnId` varchar(75) DEFAULT NULL,
  `ppPaymentStatus` varchar(75) DEFAULT NULL,
  `ppPaymentGross` double DEFAULT NULL,
  `ppReceiverEmail` varchar(75) DEFAULT NULL,
  `ppPayerEmail` varchar(75) DEFAULT NULL,
  `sendOrderEmail` tinyint(4) DEFAULT NULL,
  `sendShippingEmail` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`orderId`),
  UNIQUE KEY `IX_D7D6E87A` (`number_`),
  KEY `IX_1D15553E` (`groupId`),
  KEY `IX_119B5630` (`groupId`,`userId`,`ppPaymentStatus`),
  KEY `IX_F474FD89` (`ppTxnId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingorder`
--


--
-- Table structure for table `shoppingorderitem`
--

CREATE TABLE `shoppingorderitem` (
  `orderItemId` bigint(20) NOT NULL,
  `orderId` bigint(20) DEFAULT NULL,
  `itemId` varchar(75) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `description` longtext,
  `properties` longtext,
  `price` double DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `shippedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`orderItemId`),
  KEY `IX_B5F82C7A` (`orderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shoppingorderitem`
--


--
-- Table structure for table `shortcut`
--

CREATE TABLE `shortcut` (
  `shortCutId` bigint(20) NOT NULL,
  `shortCutName` varchar(75) DEFAULT NULL,
  `entryId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `shortCutUrl` text,
  `type_` varchar(75) DEFAULT NULL,
  `dateShortCut` date DEFAULT NULL,
  `shortCutFolderId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`shortCutId`),
  KEY `entryId` (`entryId`),
  KEY `shortCutFolderId` (`shortCutFolderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shortcut`
--


--
-- Table structure for table `shortcut_shortcut`
--

CREATE TABLE `shortcut_shortcut` (
  `shortCutId` bigint(20) NOT NULL,
  `shortCutName` varchar(75) DEFAULT NULL,
  `entryId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `shortCutUrl` varchar(250) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `dateShortCut` datetime DEFAULT NULL,
  `shortCutFolderId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`shortCutId`),
  KEY `IX_750A9587` (`dateShortCut`,`userId`),
  KEY `IX_BD0C1698` (`entryId`),
  KEY `IX_59F9E6C2` (`shortCutFolderId`,`userId`),
  KEY `IX_72FCFB5F` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shortcut_shortcut`
--


--
-- Table structure for table `shortcut_shortcutfolder`
--

CREATE TABLE `shortcut_shortcutfolder` (
  `shortCutFolderId` bigint(20) NOT NULL,
  `shortCutFolderName` varchar(250) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `parentShortCutFolderId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`shortCutFolderId`),
  KEY `IX_D97AF39A` (`parentShortCutFolderId`,`userId`),
  KEY `IX_5CB8672D` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shortcut_shortcutfolder`
--

INSERT INTO `shortcut_shortcutfolder` VALUES (93140,'Actualités',11105,0),(100031,'Messagerie',11105,0),(100733,'Casier',11105,0),(101528,'Cartable',11105,0),(101529,'Signets',11105,101528),(106356,'HTML',11105,101528),(108422,'Forum',11105,0),(108504,'Cahier de textes',11105,0);

--
-- Table structure for table `shortcutfolder`
--

CREATE TABLE `shortcutfolder` (
  `shortCutFolderId` bigint(20) NOT NULL,
  `shortCutFolderName` varchar(75) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `parentShortCutFolderId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`shortCutFolderId`),
  KEY `userId` (`userId`),
  KEY `parentShortCutFolderId` (`parentShortCutFolderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shortcutfolder`
--


--
-- Table structure for table `so_favoritesite`
--

CREATE TABLE `so_favoritesite` (
  `favoriteSiteId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`favoriteSiteId`),
  UNIQUE KEY `IX_3AA03DF8` (`groupId`,`userId`),
  KEY `IX_DE2F16A6` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `so_favoritesite`
--


--
-- Table structure for table `so_memberrequest`
--

CREATE TABLE `so_memberrequest` (
  `memberRequestId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `receiverUserId` bigint(20) DEFAULT NULL,
  `invitedRoleId` bigint(20) DEFAULT NULL,
  `invitedTeamId` bigint(20) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`memberRequestId`),
  KEY `IX_D34593C1` (`groupId`,`receiverUserId`,`status`),
  KEY `IX_212FA0EC` (`key_`),
  KEY `IX_D6810661` (`receiverUserId`),
  KEY `IX_16475447` (`receiverUserId`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `so_memberrequest`
--


--
-- Table structure for table `so_projectsentry`
--

CREATE TABLE `so_projectsentry` (
  `projectsEntryId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `title` varchar(75) DEFAULT NULL,
  `description` longtext,
  `startDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `data_` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`projectsEntryId`),
  KEY `IX_3371C715` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `so_projectsentry`
--


--
-- Table structure for table `socialactivity`
--

CREATE TABLE `socialactivity` (
  `activityId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` bigint(20) DEFAULT NULL,
  `mirrorActivityId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `extraData` longtext,
  `receiverUserId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`activityId`),
  UNIQUE KEY `IX_8F32DEC9` (`groupId`,`userId`,`createDate`,`classNameId`,`classPK`,`type_`,`receiverUserId`),
  KEY `IX_82E39A0C` (`classNameId`),
  KEY `IX_A853C757` (`classNameId`,`classPK`),
  KEY `IX_64B1BC66` (`companyId`),
  KEY `IX_2A2468` (`groupId`),
  KEY `IX_1271F25F` (`mirrorActivityId`),
  KEY `IX_1F00C374` (`mirrorActivityId`,`classNameId`,`classPK`),
  KEY `IX_121CA3CB` (`receiverUserId`),
  KEY `IX_3504B8BC` (`userId`),
  KEY `IX_FB604DC7` (`groupId`,`userId`,`classNameId`,`classPK`,`type_`,`receiverUserId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `socialactivity`
--

INSERT INTO `socialactivity` VALUES (6801,18406,10202,11105,1406312300471,0,10054,274720,2,'{\"title\":\"re\"}',0),(6802,18202,10202,11105,1406312550840,0,10054,274734,2,'{\"title\":\"z\"}',0),(6901,11107,10202,11105,1509630262656,0,10059,313003,1,'{\"title\":\"test3.7z\"}',0),(6902,11107,10202,11105,1509630337330,0,10059,313020,1,'{\"title\":\"test3 (1).7z\"}',0),(6903,11107,10202,11105,1509630344216,0,10059,313036,1,'{\"title\":\"Capture_d\\u2019écran_2017-07-06_à_15.54.51.png\"}',0),(6904,11107,10202,11105,1509630344878,0,10059,313049,1,'{\"title\":\"exportedPaé____éçèd (1).html\"}',0),(6905,11107,10202,11105,1509630345618,0,10059,313058,1,'{\"title\":\"g.aFrILXXSqyZzV6Vg$testExportë ê --.zfrezf.html\"}',0),(6906,11107,10202,11105,1509630369591,0,10059,313058,2,'{\"title\":\"g.aFrILXXSqyZzV6Vg$testExportë ê --.zfrezf.html\"}',0),(7002,11107,10202,11105,1509633344486,0,10059,313253,1,'{\"title\":\"butterfly.png\"}',0),(7003,11107,10202,11105,1509633347200,0,10059,313267,1,'{\"title\":\"butterfly_2.png\"}',0),(7004,11107,10202,11105,1509633486083,0,10059,313281,1,'{\"title\":\"unnamed.png\"}',0),(7005,11107,10202,11105,1509633486725,0,10059,313295,1,'{\"title\":\"unnamed_2.png\"}',0),(7006,18202,10202,11105,1509633522674,0,10059,313311,1,'{\"title\":\"unnamed_2.png\"}',0),(7007,18202,10202,11105,1509633523380,0,10054,313320,2,'{\"title\":\"Bienvenue sur l\'ENT Néro\"}',0);

--
-- Table structure for table `socialactivityachievement`
--

CREATE TABLE `socialactivityachievement` (
  `activityAchievementId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `firstInGroup` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`activityAchievementId`),
  UNIQUE KEY `IX_D4390CAA` (`groupId`,`userId`,`name`),
  KEY `IX_E14B1F1` (`groupId`),
  KEY `IX_83E16F2F` (`groupId`,`firstInGroup`),
  KEY `IX_8F6408F0` (`groupId`,`name`),
  KEY `IX_C8FD892B` (`groupId`,`userId`),
  KEY `IX_AABC18E9` (`groupId`,`userId`,`firstInGroup`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `socialactivityachievement`
--


--
-- Table structure for table `socialactivitycounter`
--

CREATE TABLE `socialactivitycounter` (
  `activityCounterId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `ownerType` int(11) DEFAULT NULL,
  `currentValue` int(11) DEFAULT NULL,
  `totalValue` int(11) DEFAULT NULL,
  `graceValue` int(11) DEFAULT NULL,
  `startPeriod` int(11) DEFAULT NULL,
  `endPeriod` int(11) DEFAULT NULL,
  PRIMARY KEY (`activityCounterId`),
  UNIQUE KEY `IX_1B7E3B67` (`groupId`,`classNameId`,`classPK`,`name`,`ownerType`,`endPeriod`),
  UNIQUE KEY `IX_374B35AE` (`groupId`,`classNameId`,`classPK`,`name`,`ownerType`,`startPeriod`),
  KEY `IX_A4B9A23B` (`classNameId`,`classPK`),
  KEY `IX_926CDD04` (`groupId`,`classNameId`,`classPK`,`ownerType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `socialactivitycounter`
--


--
-- Table structure for table `socialactivitylimit`
--

CREATE TABLE `socialactivitylimit` (
  `activityLimitId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `activityType` int(11) DEFAULT NULL,
  `activityCounterName` varchar(75) DEFAULT NULL,
  `value` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`activityLimitId`),
  UNIQUE KEY `IX_F1C1A617` (`groupId`,`userId`,`classNameId`,`classPK`,`activityType`,`activityCounterName`),
  KEY `IX_B15863FA` (`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `socialactivitylimit`
--


--
-- Table structure for table `socialactivitysetting`
--

CREATE TABLE `socialactivitysetting` (
  `activitySettingId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `activityType` int(11) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `value` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`activitySettingId`),
  KEY `IX_384788CD` (`groupId`,`activityType`),
  KEY `IX_1E9CF33B` (`groupId`,`classNameId`,`activityType`),
  KEY `IX_D984AABA` (`groupId`,`classNameId`,`activityType`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `socialactivitysetting`
--


--
-- Table structure for table `socialrelation`
--

CREATE TABLE `socialrelation` (
  `uuid_` varchar(75) DEFAULT NULL,
  `relationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` bigint(20) DEFAULT NULL,
  `userId1` bigint(20) DEFAULT NULL,
  `userId2` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  PRIMARY KEY (`relationId`),
  UNIQUE KEY `IX_12A92145` (`userId1`,`userId2`,`type_`),
  KEY `IX_61171E99` (`companyId`),
  KEY `IX_95135D1C` (`companyId`,`type_`),
  KEY `IX_C31A64C6` (`type_`),
  KEY `IX_5A40CDCC` (`userId1`),
  KEY `IX_4B52BE89` (`userId1`,`type_`),
  KEY `IX_5A40D18D` (`userId2`),
  KEY `IX_3F9C2FA8` (`userId2`,`type_`),
  KEY `IX_F0CA24A5` (`uuid_`),
  KEY `IX_B5C9C690` (`userId1`,`userId2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `socialrelation`
--


--
-- Table structure for table `socialrequest`
--

CREATE TABLE `socialrequest` (
  `uuid_` varchar(75) DEFAULT NULL,
  `requestId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` bigint(20) DEFAULT NULL,
  `modifiedDate` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `extraData` longtext,
  `receiverUserId` bigint(20) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`requestId`),
  UNIQUE KEY `IX_36A90CA7` (`userId`,`classNameId`,`classPK`,`type_`,`receiverUserId`),
  UNIQUE KEY `IX_4F973EFE` (`uuid_`,`groupId`),
  KEY `IX_D3425487` (`classNameId`,`classPK`,`type_`,`receiverUserId`,`status`),
  KEY `IX_A90FE5A0` (`companyId`),
  KEY `IX_32292ED1` (`receiverUserId`),
  KEY `IX_D9380CB7` (`receiverUserId`,`status`),
  KEY `IX_80F7A9C2` (`userId`),
  KEY `IX_CC86A444` (`userId`,`classNameId`,`classPK`,`type_`,`status`),
  KEY `IX_AB5906A8` (`userId`,`status`),
  KEY `IX_49D5872C` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `socialrequest`
--


--
-- Table structure for table `statistics_statistics`
--

CREATE TABLE `statistics_statistics` (
  `statId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `etabId` bigint(20) DEFAULT NULL,
  `dateTime` datetime DEFAULT NULL,
  `service` varchar(75) DEFAULT NULL,
  `profil` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`statId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `statistics_statistics`
--


--
-- Table structure for table `subjectcdt`
--

CREATE TABLE `subjectcdt` (
  `subjectId` bigint(20) NOT NULL,
  `color` varchar(75) DEFAULT NULL,
  `etabId` bigint(20) DEFAULT NULL,
  `enseignementId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`subjectId`),
  KEY `etabId` (`etabId`),
  KEY `enseignementId` (`enseignementId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `subjectcdt`
--


--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `subscriptionId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `frequency` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`subscriptionId`),
  UNIQUE KEY `IX_2E1A92D4` (`companyId`,`userId`,`classNameId`,`classPK`),
  KEY `IX_786D171A` (`companyId`,`classNameId`,`classPK`),
  KEY `IX_54243AFD` (`userId`),
  KEY `IX_E8F34171` (`userId`,`classNameId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `subscription`
--


--
-- Table structure for table `tagsasset`
--

CREATE TABLE `tagsasset` (
  `assetId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `visible` tinyint(4) DEFAULT NULL,
  `startDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `publishDate` datetime DEFAULT NULL,
  `expirationDate` datetime DEFAULT NULL,
  `mimeType` varchar(75) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext,
  `summary` longtext,
  `url` longtext,
  `height` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `viewCount` int(11) DEFAULT NULL,
  PRIMARY KEY (`assetId`),
  UNIQUE KEY `IX_1AB6D6D2` (`classNameId`,`classPK`),
  KEY `IX_AB3D8BCB` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tagsasset`
--

INSERT INTO `tagsasset` VALUES (11110,0,10202,11105,'L&#039;equipe Technique','2011-06-14 17:39:43','2012-08-30 10:37:35',10043,11105,1,NULL,NULL,NULL,NULL,'','L&#039;equipe Technique','','','',0,0,0,0),(12252,11107,10202,11105,'L&#039;equipe Technique','2011-06-16 10:56:35','2011-06-16 10:56:35',10054,12247,1,NULL,NULL,'2011-06-16 10:56:00',NULL,'text/html','Test','','','',0,0,0,0),(12261,11107,10202,11105,'L&#039;equipe Technique','2011-06-16 11:36:44','2011-06-16 11:36:44',10054,12257,1,NULL,NULL,'2011-06-16 11:36:00',NULL,'text/html','Test','','','',0,0,0,0),(13010,0,10202,10205,'','2011-06-17 15:48:24','2011-06-17 16:37:48',10023,13002,1,NULL,NULL,NULL,NULL,'','Forum Europeen de la montagne','','','',0,0,0,0),(14981,11107,10202,11105,'L&#039;equipe Technique','2011-09-20 11:39:59','2011-09-20 11:39:59',10054,14977,1,NULL,NULL,'2011-09-20 11:39:00',NULL,'text/html','Forum Européen','','','',0,0,0,0),(14987,11107,10202,11105,'L&#039;equipe Technique','2011-09-20 11:40:00','2011-09-20 11:40:00',10054,14983,1,NULL,NULL,'2011-09-20 11:39:00',NULL,'text/html','Forum Européen','','','',0,0,0,0),(15270,11107,10202,11105,'L&#039;equipe Technique','2011-09-20 12:09:37','2011-09-20 12:09:37',10059,15266,1,NULL,NULL,NULL,NULL,'application/pdf','32674086358_1.0','','','',0,0,0,0),(15277,11107,10202,11105,'L&#039;equipe Technique','2011-09-20 12:09:37','2011-09-20 12:09:37',10059,15273,1,NULL,NULL,NULL,NULL,'image/jpeg','collegeTab1 (3)','','','',0,0,0,0),(15310,11107,10202,11105,'L&#039;equipe Technique','2011-09-20 12:09:41','2011-09-20 12:09:41',10059,15306,1,NULL,NULL,NULL,NULL,'application/pdf','32674086358_1.0','','','',0,0,0,6),(15317,11107,10202,11105,'L&#039;equipe Technique','2011-09-20 12:09:41','2011-09-20 12:09:41',10059,15313,1,NULL,NULL,NULL,NULL,'image/jpeg','collegeTab1 (3)','','','',0,0,0,0),(16598,11107,10202,11105,'L&#039;equipe Technique','2011-12-16 10:49:00','2011-12-16 10:49:00',10054,16594,1,NULL,NULL,'2011-12-16 10:48:00',NULL,'text/html','Formation Pierre Jean','','','',0,0,0,0),(16907,0,10202,10205,'','2012-01-03 11:59:10','2012-01-03 11:59:10',10023,16899,1,NULL,NULL,NULL,NULL,'','Commissariat de massif du Massif Central','','','',0,0,0,0),(16922,0,10202,10205,'','2012-01-03 11:59:11','2012-01-03 11:59:11',10023,16914,1,NULL,NULL,NULL,NULL,'','Conseil Régional Aquitaine','','','',0,0,0,0),(16937,0,10202,10205,'','2012-01-03 11:59:11','2012-01-03 11:59:11',10023,16929,1,NULL,NULL,NULL,NULL,'','Conseil Régional Auvergne','','','',0,0,0,0),(16952,0,10202,10205,'','2012-01-03 11:59:12','2012-01-03 11:59:12',10023,16944,1,NULL,NULL,NULL,NULL,'','DATAR','','','',0,0,0,0),(16967,0,10202,10205,'','2012-01-03 11:59:13','2012-01-03 11:59:13',10023,16959,1,NULL,NULL,NULL,NULL,'','Conseil Régional Languedoc Roussillon','','','',0,0,0,0),(16982,0,10202,10205,'','2012-01-03 11:59:13','2012-01-03 11:59:13',10023,16974,1,NULL,NULL,NULL,NULL,'','Commissariat de Massif Pyrénées','','','',0,0,0,0),(16997,0,10202,10205,'','2012-01-03 11:59:14','2012-01-03 11:59:14',10023,16989,1,NULL,NULL,NULL,NULL,'','Conseil Régional Midi Pyrénées','','','',0,0,0,0),(17018,0,10202,10205,'','2012-01-03 11:59:15','2012-01-03 11:59:15',10023,17010,1,NULL,NULL,NULL,NULL,'','Commissariat de massif des Alpes','','','',0,0,0,0),(17063,0,10202,10205,'','2012-01-03 11:59:18','2012-01-03 11:59:18',10023,17055,1,NULL,NULL,NULL,NULL,'','GIP Massif Central','','','',0,0,0,0),(18209,0,10202,10205,'','2012-04-23 20:19:30','2012-04-23 20:19:30',10023,18201,1,NULL,NULL,NULL,NULL,'','Nero Demo','','','',0,0,0,0),(18218,0,10202,10205,'','2012-04-23 20:19:31','2012-04-24 16:50:10',10023,18210,1,NULL,NULL,NULL,NULL,'','Etablissement démo','','','',0,0,0,0),(18231,0,10202,10205,'','2012-04-23 20:19:31','2012-04-24 16:51:44',10023,18223,1,NULL,NULL,NULL,NULL,'','Etablissement démo - Parent','','','',0,0,0,0),(18240,0,10202,10205,'','2012-04-23 20:19:31','2012-04-24 16:51:29',10023,18232,1,NULL,NULL,NULL,NULL,'','Etablissement démo - Enseignants','','','',0,0,0,0),(18249,0,10202,10205,'','2012-04-23 20:19:31','2012-04-24 16:51:59',10023,18241,1,NULL,NULL,NULL,NULL,'','Etablissement démo - Personnels','','','',0,0,0,0),(18258,0,10202,10205,'','2012-04-23 20:19:31','2012-04-23 20:19:31',10023,18250,1,NULL,NULL,NULL,NULL,'','Forum Europeen de la montagne - Enseignants','','','',0,0,0,0),(18267,0,10202,10205,'','2012-04-23 20:19:32','2012-04-23 20:19:32',10023,18259,1,NULL,NULL,NULL,NULL,'','Forum Europeen de la montagne - Personnels','','','',0,0,0,0),(18276,0,10202,10205,'','2012-04-23 20:19:32','2012-04-23 20:19:32',10023,18268,1,NULL,NULL,NULL,NULL,'','Forum Europeen de la montagne - Parent','','','',0,0,0,0),(18413,0,10202,10205,'','2012-04-23 21:17:59','2012-04-24 16:50:41',10023,18405,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 3a','','','',0,0,0,0),(18422,0,10202,10205,'','2012-04-23 21:18:00','2012-04-24 16:51:13',10023,18414,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 3a - Parents','','','',0,0,0,0),(19519,11107,10202,11105,'L&#039;equipe Technique','2012-04-24 11:52:26','2012-04-24 11:52:26',10059,19515,1,NULL,NULL,NULL,NULL,'application/octet-stream','agenda','','','',0,0,0,19),(21406,11107,10202,11105,'L&#039;equipe Technique','2012-04-24 17:57:02','2012-04-24 17:57:02',10059,21402,1,NULL,NULL,NULL,NULL,'application/octet-stream','LES DIX COMPETENCES PROFESSIONNELLES','','','',0,0,0,9),(29617,0,10202,10205,'','2012-05-03 16:34:58','2012-05-03 16:34:58',10023,29609,1,NULL,NULL,NULL,NULL,'','Etablissement démo - ts-profs','','','',0,0,0,0),(29626,0,10202,10205,'','2012-05-03 16:34:58','2012-05-03 16:34:58',10023,29618,1,NULL,NULL,NULL,NULL,'','Etablissement démo - ts-profs - Parents','','','',0,0,0,0),(29794,0,10202,10205,'','2012-05-03 16:35:05','2012-05-03 16:35:05',10023,29786,1,NULL,NULL,NULL,NULL,'','Etablissement démo - professeurs','','','',0,0,0,0),(29803,0,10202,10205,'','2012-05-03 16:35:05','2012-05-03 16:35:05',10023,29795,1,NULL,NULL,NULL,NULL,'','Etablissement démo - professeurs - Parents','','','',0,0,0,0),(29971,0,10202,10205,'','2012-05-03 16:35:11','2012-05-03 16:35:11',10023,29963,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 6a-eleves','','','',0,0,0,0),(29980,0,10202,10205,'','2012-05-03 16:35:11','2012-05-03 16:35:11',10023,29972,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 6a-eleves - Parents','','','',0,0,0,0),(30148,0,10202,10205,'','2012-05-03 16:35:15','2012-05-03 16:35:15',10023,30140,1,NULL,NULL,NULL,NULL,'','Etablissement démo - eleves','','','',0,0,0,0),(30157,0,10202,10205,'','2012-05-03 16:35:15','2012-05-03 16:35:15',10023,30149,1,NULL,NULL,NULL,NULL,'','Etablissement démo - eleves - Parents','','','',0,0,0,0),(30321,0,10202,10205,'','2012-05-03 16:35:20','2012-05-03 16:35:20',10023,30313,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 6a-profs','','','',0,0,0,0),(30330,0,10202,10205,'','2012-05-03 16:35:20','2012-05-03 16:35:20',10023,30322,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 6a-profs - Parents','','','',0,0,0,0),(30352,0,10202,10205,'','2012-05-03 16:35:22','2012-05-03 16:35:22',10023,30344,1,NULL,NULL,NULL,NULL,'','Etablissement démo - ts-eleves','','','',0,0,0,0),(30361,0,10202,10205,'','2012-05-03 16:35:22','2012-05-03 16:35:22',10023,30353,1,NULL,NULL,NULL,NULL,'','Etablissement démo - ts-eleves - Parents','','','',0,0,0,0),(30375,0,10202,10205,'','2012-05-03 16:35:22','2012-05-03 16:35:22',10023,30367,1,NULL,NULL,NULL,NULL,'','Etablissement démo - ts','','','',0,0,0,0),(30384,0,10202,10205,'','2012-05-03 16:35:22','2012-05-03 16:35:22',10023,30376,1,NULL,NULL,NULL,NULL,'','Etablissement démo - ts - Parents','','','',0,0,0,0),(30398,0,10202,10205,'','2012-05-03 16:35:25','2012-05-03 16:35:25',10023,30390,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 6a','','','',0,0,0,0),(30407,0,10202,10205,'','2012-05-03 16:35:25','2012-05-03 16:35:25',10023,30399,1,NULL,NULL,NULL,NULL,'','Etablissement démo - 6a - Parents','','','',0,0,0,0),(32279,11107,10202,11105,'L&#039;equipe Technique','2012-05-09 10:21:50','2013-01-07 16:04:04',10059,32275,1,NULL,NULL,NULL,NULL,'image/png','rss (1) (2)','','','',0,0,0,6),(32389,11107,10202,11105,'L&#039;equipe Technique','2012-05-09 11:04:05','2013-03-01 10:26:46',10059,32379,1,NULL,NULL,NULL,NULL,'text/html','polo (1)','','','',0,0,0,14),(32867,11107,10202,11105,'L&#039;equipe Technique','2012-05-21 18:40:10','2012-05-21 18:40:10',10059,32859,1,NULL,NULL,NULL,NULL,'image/jpeg','screenshot_01 (1)','','','',0,0,0,0),(32878,11107,10202,11105,'L&#039;equipe Technique','2012-05-21 18:40:10','2012-05-21 18:40:10',10059,32871,1,NULL,NULL,NULL,NULL,'image/jpeg','screenshot_01 (1)','','','',0,0,0,3),(40685,11107,10202,11105,'L&#039;equipe Technique','2012-12-03 17:11:46','2012-12-03 17:11:46',10059,40681,1,NULL,NULL,NULL,NULL,'application/octet-stream','pentila_EUROPE_Complet_20121203_Eleve_0000','pentila_EUROPE_Complet_20121203_Eleve_0000.xml','','',0,0,0,2),(40690,11107,10202,11105,'L&#039;equipe Technique','2012-12-03 17:11:47','2012-12-03 17:11:47',10059,40686,1,NULL,NULL,NULL,NULL,'application/octet-stream','pentila_EUROPE_Complet_20121203_PersEducNat_0000','pentila_EUROPE_Complet_20121203_PersEducNat_0000.xml','','',0,0,0,2),(40695,11107,10202,11105,'L&#039;equipe Technique','2012-12-03 17:11:47','2012-12-03 17:11:47',10059,40691,1,NULL,NULL,NULL,NULL,'application/octet-stream','pentila_EUROPE_Complet_20121203_PersRelEleve_0000','pentila_EUROPE_Complet_20121203_PersRelEleve_0000.xml','','',0,0,0,2),(40700,11107,10202,11105,'L&#039;equipe Technique','2012-12-03 17:11:47','2012-12-03 17:11:47',10059,40696,1,NULL,NULL,NULL,NULL,'application/octet-stream','pentila_EUROPE_Complet_20121203_EtabEducNat_0000','pentila_EUROPE_Complet_20121203_EtabEducNat_0000.xml','','',0,0,0,1),(41551,11107,10202,11105,'L&#039;equipe Technique','2013-01-07 16:41:42','2013-01-09 17:09:00',10059,41547,1,NULL,NULL,NULL,NULL,'text/html','test','','','',0,0,0,21),(41615,11107,10202,11105,'L&#039;equipe Technique','2013-01-07 16:52:05','2013-01-07 16:52:05',10059,41611,1,NULL,NULL,NULL,NULL,'application/octet-stream','BUG','','','',0,0,0,4),(44354,11107,10202,11105,'L&#039;equipe Technique','2013-01-08 11:19:40','2013-01-08 11:19:40',10059,44350,1,NULL,NULL,NULL,NULL,'application/pdf','Janvier 2013','Janvier 2013.pdf','','',0,0,0,4),(44363,11107,10202,11105,'L&#039;equipe Technique','2013-01-08 11:20:14','2013-01-08 11:20:14',10059,44359,1,NULL,NULL,NULL,NULL,'application/vnd.ms-excel','Janvier 2013','Janvier 2013.xls','','',0,0,0,2),(44370,11107,10202,11105,'L&#039;equipe Technique','2013-01-08 11:21:00','2013-01-08 11:21:00',10059,44366,1,NULL,NULL,NULL,NULL,'application/pdf','Menu','Menu.pdf','','',0,0,0,2),(45102,11107,10202,11105,'L&#039;equipe Technique','2013-01-09 14:40:43','2013-01-09 14:40:43',10059,45098,1,NULL,NULL,NULL,NULL,'application/msword','Plan alimentaire (1)','','','',0,0,0,7),(45130,11107,10202,11105,'L&#039;equipe Technique','2013-01-09 15:03:01','2013-01-09 15:03:01',10059,45126,1,NULL,NULL,NULL,NULL,'image/jpeg','screenshot_01 (1)','','','',0,0,0,3),(45137,11107,10202,11105,'L&#039;equipe Technique','2013-01-09 15:04:38','2013-01-09 15:04:38',10059,45133,1,NULL,NULL,NULL,NULL,'application/octet-stream','pentila_EUROPE_Complet_20121203_Eleve_0000 (1)','pentila_EUROPE_Complet_20121203_Eleve_0000.xml','','',0,0,0,8),(45786,11107,10202,11105,'L&#039;equipe Technique','2013-01-10 17:09:03','2013-01-10 17:09:03',10059,45782,1,NULL,NULL,NULL,NULL,'application/pdf','Janvier 2013 (1)','Janvier 2013.pdf','','',0,0,0,2),(49128,11107,10202,11105,'L&#039;equipe Technique','2013-03-01 10:26:54','2013-03-01 10:26:54',10059,49124,1,NULL,NULL,NULL,NULL,'text/html','oo','','','',0,0,0,8),(49299,11107,10202,11105,'L&#039;equipe Technique','2013-03-04 15:44:16','2013-03-04 15:44:16',10069,49294,1,NULL,NULL,NULL,NULL,'jpg','screenshot_01 (1)','','','',471,821,0,0),(49305,11107,10202,11105,'L&#039;equipe Technique','2013-03-04 15:49:13','2013-03-04 15:49:13',10069,49300,1,NULL,NULL,NULL,NULL,'jpg','Formation','','','',320,320,0,0),(49311,18202,10202,11105,'L&#039;equipe Technique','2013-03-04 15:49:16','2013-03-04 15:49:16',10069,49306,1,NULL,NULL,NULL,NULL,'jpg','Formation_2','','','',320,320,0,0),(50957,11107,10202,11105,'L&#039;equipe Technique','2013-03-20 10:03:11','2013-03-20 10:03:11',10054,50953,1,NULL,NULL,'2013-03-20 10:03:00',NULL,'text/html','polo','','','',0,0,0,0),(50963,11107,10202,11105,'L&#039;equipe Technique','2013-03-20 10:03:11','2013-03-20 10:03:11',10054,50959,1,NULL,NULL,'2013-03-20 10:03:00',NULL,'text/html','polo','','','',0,0,0,0),(50969,11107,10202,11105,'L&#039;equipe Technique','2013-03-20 10:27:17','2013-03-20 10:27:17',10054,50965,1,NULL,NULL,'2013-03-20 10:03:00',NULL,'text/html','polo','','','',0,0,0,0),(53922,11107,10202,11105,'L&#039;equipe Technique','2013-03-28 12:28:23','2013-03-28 12:28:23',10059,53921,1,NULL,NULL,NULL,NULL,'application/pdf','Mai 2013','Mai 2013.pdf','','',0,0,0,2),(54364,11107,10202,11105,'L&#039;equipe Technique','2013-03-29 14:38:15','2013-03-29 14:38:15',10059,54360,1,NULL,NULL,NULL,NULL,'application/pdf','Mars 2013','Mars 2013.pdf','','',0,0,0,1),(54658,11107,10202,11105,'L&#039;equipe Technique','2013-03-29 15:21:30','2013-03-29 15:21:30',10059,54657,1,NULL,NULL,NULL,NULL,'image/png','agenda','','','',0,0,0,1),(54660,11107,10202,11105,'L&#039;equipe Technique','2013-03-29 15:21:30','2013-03-29 15:21:30',10059,54659,1,NULL,NULL,NULL,NULL,'text/html','polo','','','',0,0,0,1),(54662,11107,10202,11105,'L&#039;equipe Technique','2013-03-29 15:21:30','2013-03-29 15:21:30',10059,54661,1,NULL,NULL,NULL,NULL,'image/png','rss','','','',0,0,0,1),(54670,11107,10202,11105,'L&#039;equipe Technique','2013-03-29 15:23:00','2013-03-29 15:23:00',10059,54666,1,NULL,NULL,NULL,NULL,'text/html','rouge gorge','','','',0,0,0,0),(54676,11107,10202,11105,'L&#039;equipe Technique','2013-03-29 15:23:06','2013-03-29 15:23:06',10059,54672,1,NULL,NULL,NULL,NULL,'application/msword',' Vhugo','','','',0,0,0,2),(56091,18211,10202,11105,'L&#039;equipe Technique','2013-05-28 13:44:11','2013-05-28 13:44:11',10059,56087,1,NULL,NULL,NULL,NULL,'image/png','agenda','','','',0,0,0,0),(56363,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:41:00','2013-05-30 14:41:00',10059,56359,1,NULL,NULL,NULL,NULL,'image/png','screenshot_08','','','',0,0,0,1),(56368,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:41:07','2013-05-30 14:41:07',10059,56364,1,NULL,NULL,NULL,NULL,'image/gif','clic_droit','','','',0,0,0,2),(56380,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:41:11','2013-05-30 14:41:11',10054,56376,1,NULL,NULL,'2013-05-30 14:41:00',NULL,'text/html','Actualité','','','',0,0,0,0),(56390,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:42:20','2013-05-30 14:42:20',10059,56384,1,NULL,NULL,NULL,NULL,'image/png','screenshot_12','','','',0,0,0,1),(56396,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:42:20','2013-05-30 14:42:20',10059,56385,1,NULL,NULL,NULL,NULL,'image/png','screenshot_14','','','',0,0,0,1),(56398,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:42:20','2013-05-30 14:42:20',10059,56386,1,NULL,NULL,NULL,NULL,'image/png','screenshot_13','','','',0,0,0,0),(56405,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:42:24','2013-05-30 14:42:24',10059,56401,1,NULL,NULL,NULL,NULL,'image/png','screenshot_12','','','',0,0,0,0),(56411,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:42:24','2013-05-30 14:42:24',10059,56407,1,NULL,NULL,NULL,NULL,'image/png','screenshot_14','','','',0,0,0,0),(56418,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:42:24','2013-05-30 14:42:24',10059,56414,1,NULL,NULL,NULL,NULL,'image/png','screenshot_12','','','',0,0,0,0),(56425,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:42:25','2013-05-30 14:42:25',10059,56421,1,NULL,NULL,NULL,NULL,'image/png','screenshot_14','','','',0,0,0,0),(56450,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:45:46','2013-05-30 14:45:46',10059,56446,1,NULL,NULL,NULL,NULL,'image/gif','deposer','','','',0,0,0,1),(56469,11107,10202,11105,'L&#039;equipe Technique','2013-05-30 14:49:00','2013-05-30 14:49:00',10059,56465,1,NULL,NULL,NULL,NULL,'text/html','Document','','','',0,0,0,2),(57313,11107,10202,11105,'L&#039;equipe Technique','2013-06-12 16:54:31','2013-06-12 16:54:31',10059,57309,1,NULL,NULL,NULL,NULL,'application/pdf','Plantest','Plantest.pdf','','',0,0,0,2),(57528,11107,10202,11105,'L&#039;equipe Technique','2013-06-12 16:56:35','2013-06-12 16:56:35',10059,57524,1,NULL,NULL,NULL,NULL,'application/pdf','Menu (1)','Menu.pdf','','',0,0,0,5),(58676,11107,10202,11105,'L&#039;equipe Technique','2013-06-13 15:02:21','2013-06-13 15:02:21',10059,58672,1,NULL,NULL,NULL,NULL,'application/pdf','facture_ABD_Voyages_janvier','','','',0,0,0,4);

--
-- Table structure for table `tagsassets_tagsentries`
--

CREATE TABLE `tagsassets_tagsentries` (
  `assetId` bigint(20) NOT NULL,
  `entryId` bigint(20) NOT NULL,
  PRIMARY KEY (`assetId`,`entryId`),
  KEY `IX_B22F3A1` (`assetId`),
  KEY `IX_A02A8023` (`entryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tagsassets_tagsentries`
--


--
-- Table structure for table `tagsentry`
--

CREATE TABLE `tagsentry` (
  `entryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `parentEntryId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `vocabularyId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`entryId`),
  KEY `IX_EE55ED49` (`parentEntryId`,`vocabularyId`),
  KEY `IX_28E8954` (`vocabularyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tagsentry`
--


--
-- Table structure for table `tagsproperty`
--

CREATE TABLE `tagsproperty` (
  `propertyId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `entryId` bigint(20) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`propertyId`),
  UNIQUE KEY `IX_F505253D` (`entryId`,`key_`),
  KEY `IX_C134234` (`companyId`),
  KEY `IX_EB974D08` (`companyId`,`key_`),
  KEY `IX_5200A629` (`entryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tagsproperty`
--


--
-- Table structure for table `tagssource`
--

CREATE TABLE `tagssource` (
  `sourceId` bigint(20) NOT NULL,
  `parentSourceId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `acronym` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`sourceId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tagssource`
--


--
-- Table structure for table `tagsvocabulary`
--

CREATE TABLE `tagsvocabulary` (
  `vocabularyId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` varchar(75) DEFAULT NULL,
  `folksonomy` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`vocabularyId`),
  UNIQUE KEY `IX_F9E51044` (`groupId`,`name`),
  KEY `IX_E0D51848` (`companyId`,`folksonomy`),
  KEY `IX_9F26308A` (`groupId`,`folksonomy`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tagsvocabulary`
--


--
-- Table structure for table `tasksproposal`
--

CREATE TABLE `tasksproposal` (
  `proposalId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext,
  `publishDate` datetime DEFAULT NULL,
  `dueDate` datetime DEFAULT NULL,
  PRIMARY KEY (`proposalId`),
  UNIQUE KEY `IX_181A4A1B` (`classNameId`,`classPK`),
  KEY `IX_7FB27324` (`groupId`),
  KEY `IX_6EEC675E` (`groupId`,`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tasksproposal`
--


--
-- Table structure for table `tasksreview`
--

CREATE TABLE `tasksreview` (
  `reviewId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `proposalId` bigint(20) DEFAULT NULL,
  `assignedByUserId` bigint(20) DEFAULT NULL,
  `assignedByUserName` varchar(75) DEFAULT NULL,
  `stage` int(11) DEFAULT NULL,
  `completed` tinyint(4) DEFAULT NULL,
  `rejected` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`reviewId`),
  UNIQUE KEY `IX_5C6BE4C7` (`userId`,`proposalId`),
  KEY `IX_4D0C7F8D` (`proposalId`),
  KEY `IX_70AFEA01` (`proposalId`,`stage`),
  KEY `IX_1894B29A` (`proposalId`,`stage`,`completed`),
  KEY `IX_41AFC20C` (`proposalId`,`stage`,`completed`,`rejected`),
  KEY `IX_36F512E6` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tasksreview`
--


--
-- Table structure for table `team`
--

CREATE TABLE `team` (
  `teamId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext,
  PRIMARY KEY (`teamId`),
  UNIQUE KEY `IX_143DC786` (`groupId`,`name`),
  KEY `IX_AE6E9907` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team`
--


--
-- Table structure for table `tms_tasksentry`
--

CREATE TABLE `tms_tasksentry` (
  `tasksEntryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `title` varchar(75) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `assigneeUserId` bigint(20) DEFAULT NULL,
  `resolverUserId` bigint(20) DEFAULT NULL,
  `dueDate` datetime DEFAULT NULL,
  `finishDate` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`tasksEntryId`),
  KEY `IX_9DB062B8` (`assigneeUserId`),
  KEY `IX_DF694DFB` (`groupId`),
  KEY `IX_EE672124` (`groupId`,`assigneeUserId`),
  KEY `IX_EB40A85B` (`groupId`,`resolverUserId`),
  KEY `IX_84A27B35` (`groupId`,`userId`),
  KEY `IX_9A89E9EF` (`resolverUserId`),
  KEY `IX_5D4090C9` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tms_tasksentry`
--

INSERT INTO `tms_tasksentry` VALUES (173301,11107,10202,11105,'L\'equipe Technique','2014-02-21 16:20:24','2014-02-21 16:20:24','polo',2,11105,0,'2014-02-21 16:20:00',NULL,1);

--
-- Table structure for table `updateinformation_updateinformation`
--

CREATE TABLE `updateinformation_updateinformation` (
  `updateInfoId` bigint(20) NOT NULL,
  `description` text,
  `modifyDate` date DEFAULT NULL,
  PRIMARY KEY (`updateInfoId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `updateinformation_updateinformation`
--

INSERT INTO `updateinformation_updateinformation` VALUES (120104,'Mise &agrave; jour','2013-07-19');

--
-- Table structure for table `usergroup`
--

CREATE TABLE `usergroup` (
  `userGroupId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `parentUserGroupId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext,
  `addedByLDAPImport` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`userGroupId`),
  UNIQUE KEY `IX_23EAD0D` (`companyId`,`name`),
  KEY `IX_524FEFCE` (`companyId`),
  KEY `IX_69771487` (`companyId`,`parentUserGroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usergroup`
--

INSERT INTO `usergroup` VALUES (11101,10202,0,'entpentila','Groupe des membres de l\'ENT',NULL),(11122,10202,0,'groupaccesssconet','Groupe des membres ayant droit d\'accès aux reports',NULL),(11126,10202,0,'administrateurent','administrateurENT',NULL),(11130,10202,0,'groupaccessreport','Groupe des membres ayant droit d\'accès aux reports',NULL),(11227,10202,0,'application-acces-ateliers','',NULL),(11231,10202,0,'application-actualites','',NULL),(11235,10202,0,'application-amis','',NULL),(11239,10202,0,'application-annuaire','',NULL),(11243,10202,0,'application-applicationManager','',NULL),(11251,10202,0,'application-carnet-d-adresses','',NULL),(11255,10202,0,'application-cartable','',NULL),(11259,10202,0,'application-casier','',NULL),(11263,10202,0,'application-chat','',NULL),(11279,10202,0,'application-gestion-menu','',NULL),(11283,10202,0,'application-gestion-user','',NULL),(11295,10202,0,'application-mesForum','',NULL),(11299,10202,0,'application-messagerie','',NULL),(11303,10202,0,'application-moteurDeRecherche','',NULL),(11323,10202,0,'application-visio','',NULL),(18219,10202,0,'nerodemo','Groupe des membres de l\'ENT',NULL),(18401,10202,0,'00001$3a','00001$3A',NULL),(19574,10202,0,'application-agenda','',NULL),(26447,10202,0,'application-cantineClg','',NULL),(26451,10202,0,'application-cantineDpt','',NULL),(36760,10202,0,'application-casManager','',NULL),(45916,10202,0,'application-gestionSites','',NULL),(118003,10202,0,'application-blog','',0),(142501,10202,0,'application-statistics','',0),(152501,10202,0,'application-wiki','',0),(166706,10202,0,'top-secret','',0),(176501,10202,0,'00001$4a','00001$4A',0),(183743,10202,0,'portal_members','Groupe des membres de l\'ENT',0),(219833,10202,0,'student','',0),(269702,10202,0,'ldapracine','Groupe des membres de l\'ENT',0),(311378,10202,0,'application-nero','',0),(311503,10202,0,'application-dashboard','',0),(313091,10202,0,'application-administrationTools','',0),(313701,10202,0,'application-gestionApplications','',0),(313705,10202,0,'application-gestionVieScolaire','',0),(313971,10202,0,'application-cns','',0),(313985,10202,0,'application-esidoc','',0),(313999,10202,0,'application-edumedia','',0),(314014,10202,0,'application-folios','',0),(314028,10202,0,'application-lesiteTV','',0),(314042,10202,0,'application-moodle','',0),(314056,10202,0,'application-paraschool','',0),(314070,10202,0,'application-teacherEDU','',0),(314084,10202,0,'application-universalis','',0),(314098,10202,0,'application-universalisJunior','',0),(314112,10202,0,'application-grr','',0),(314126,10202,0,'application-arena','',0),(314141,10202,0,'application-cdt','',0),(314155,10202,0,'application-gestionCDT','',0),(314164,10202,0,'application-gepi','',0),(314178,10202,0,'application-sacoche','',0),(314190,10202,0,'application-pronote','',0),(314201,10202,0,'application-sconet','',0),(314210,10202,0,'application-teleservices','',0),(314644,10202,0,'application-kne','',0),(314648,10202,0,'application-pearltrees','',0);

--
-- Table structure for table `usergroupgrouprole`
--

CREATE TABLE `usergroupgrouprole` (
  `userGroupId` bigint(20) NOT NULL,
  `groupId` bigint(20) NOT NULL,
  `roleId` bigint(20) NOT NULL,
  PRIMARY KEY (`userGroupId`,`groupId`,`roleId`),
  KEY `IX_CCBE4063` (`groupId`),
  KEY `IX_CAB0CCC8` (`groupId`,`roleId`),
  KEY `IX_1CDF88C` (`roleId`),
  KEY `IX_DCDED558` (`userGroupId`),
  KEY `IX_73C52252` (`userGroupId`,`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usergroupgrouprole`
--


--
-- Table structure for table `usergrouprole`
--

CREATE TABLE `usergrouprole` (
  `userId` bigint(20) NOT NULL,
  `groupId` bigint(20) NOT NULL,
  `roleId` bigint(20) NOT NULL,
  PRIMARY KEY (`userId`,`groupId`,`roleId`),
  KEY `IX_1B988D7A` (`groupId`),
  KEY `IX_871412DF` (`groupId`,`roleId`),
  KEY `IX_887A2C95` (`roleId`),
  KEY `IX_887BE56A` (`userId`),
  KEY `IX_4D040680` (`userId`,`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usergrouprole`
--

INSERT INTO `usergrouprole` VALUES (11105,14041,10213),(11105,14041,10215),(11105,35966,10213),(11105,35966,10215),(11105,56890,10215),(11105,58604,10213),(11105,58604,10215),(11105,86001,10213),(11105,86001,10215),(11105,86101,10213),(11105,86101,10215),(11105,106399,10213),(11105,106399,10215),(11105,106609,10213),(11105,106609,10215),(11105,106619,10213),(11105,106619,10215),(11105,106803,10213),(11105,106803,10215),(11105,106881,10213),(10205,160137,10218),(10205,160279,10218),(10205,160323,10218),(10205,160528,10218),(10205,160628,10218),(10205,160665,10218),(10205,160716,10218),(10205,160753,10218),(10205,160797,10218),(10205,160834,10218),(10205,160857,10218),(10205,160880,10218),(10205,160917,10218),(10205,160982,10218),(10205,161019,10218),(10205,161070,10218),(10205,161086,10218),(10205,161102,10218),(10205,161118,10218),(10205,161148,10218),(10205,161223,10218),(10205,161267,10218),(10205,161283,10218),(10205,161299,10218),(10205,161378,10218),(10205,161408,10218),(10205,161438,10218),(10205,161454,10218),(10205,161484,10218),(10205,161528,10218),(10205,161551,10218),(10205,161609,10218),(10205,161625,10218),(10205,161711,10218),(10205,161755,10218),(10205,161792,10218),(10205,161808,10218),(10205,161838,10218),(10205,161854,10218),(10205,161870,10218),(10205,161956,10218),(10205,161979,10218),(10205,162051,10218),(10205,162067,10218),(10205,162083,10218),(10205,162183,10218),(10205,162213,10218),(10205,162236,10218),(10205,162252,10218),(10205,162289,10218),(10205,162312,10218),(10205,162335,10218),(10205,162351,10218),(10205,162423,10218),(10205,162453,10218),(10205,162483,10218),(10205,162499,10218),(10205,162515,10218),(10205,162531,10218),(10205,162561,10218),(10205,162591,10218),(10205,162607,10218),(10205,162623,10218),(10205,162646,10218),(11105,175510,10215),(11105,176401,10213),(11105,176401,10215),(10205,176508,10218),(10205,205602,10218),(10205,205685,10218),(10205,205787,10218),(10205,205960,10218),(10205,223302,10218),(10205,223402,10218),(10205,223502,10218),(10205,223602,10218),(10205,223802,10218),(11105,224902,10213),(11105,224902,10215),(10205,225704,10218),(10205,225802,10218),(10205,268702,10218),(10205,269509,10218),(10205,310902,10218);

--
-- Table structure for table `usergroups_teams`
--

CREATE TABLE `usergroups_teams` (
  `userGroupId` bigint(20) NOT NULL,
  `teamId` bigint(20) NOT NULL,
  PRIMARY KEY (`userGroupId`,`teamId`),
  KEY `IX_31FB0B08` (`teamId`),
  KEY `IX_7F187E63` (`userGroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usergroups_teams`
--


--
-- Table structure for table `useridmapper`
--

CREATE TABLE `useridmapper` (
  `userIdMapperId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `description` varchar(75) DEFAULT NULL,
  `externalUserId` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`userIdMapperId`),
  UNIQUE KEY `IX_41A32E0D` (`type_`,`externalUserId`),
  UNIQUE KEY `IX_D1C44A6E` (`userId`,`type_`),
  KEY `IX_E60EA987` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `useridmapper`
--


--
-- Table structure for table `usermanagement_ldapmapping`
--

CREATE TABLE `usermanagement_ldapmapping` (
  `UserId` bigint(20) NOT NULL,
  `UID` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`UserId`),
  KEY `IX_7CC9AA4` (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usermanagement_ldapmapping`
--

INSERT INTO `usermanagement_ldapmapping` VALUES (11105,'pentila');

--
-- Table structure for table `usermatiere`
--

CREATE TABLE `usermatiere` (
  `userMatiereId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userSTSId` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`userMatiereId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usermatiere`
--


--
-- Table structure for table `usernotificationevent`
--

CREATE TABLE `usernotificationevent` (
  `uuid_` varchar(75) DEFAULT NULL,
  `userNotificationEventId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `timestamp` bigint(20) DEFAULT NULL,
  `deliverBy` bigint(20) DEFAULT NULL,
  `payload` longtext,
  `archived` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`userNotificationEventId`),
  KEY `IX_3E5D78C4` (`userId`),
  KEY `IX_3DBB361A` (`userId`,`archived`),
  KEY `IX_ECD8CFEA` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usernotificationevent`
--


--
-- Table structure for table `userproperties_contact`
--

CREATE TABLE `userproperties_contact` (
  `contactId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `address` varchar(75) DEFAULT NULL,
  `isAddressAuthorized` tinyint(4) DEFAULT NULL,
  `mail` varchar(75) DEFAULT NULL,
  `isMailAuthorized` tinyint(4) DEFAULT NULL,
  `mobile` varchar(75) DEFAULT NULL,
  `isMobileAuthorized` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`contactId`),
  KEY `IX_5917535F` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_contact`
--


--
-- Table structure for table `userproperties_dashboardconfig`
--

CREATE TABLE `userproperties_dashboardconfig` (
  `userId` bigint(20) NOT NULL,
  `configuration` longtext,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_dashboardconfig`
--


--
-- Table structure for table `userproperties_dashboarddefaultconfig`
--

CREATE TABLE `userproperties_dashboarddefaultconfig` (
  `roleId` bigint(20) NOT NULL,
  `configuration` longtext,
  PRIMARY KEY (`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_dashboarddefaultconfig`
--

INSERT INTO `userproperties_dashboarddefaultconfig` VALUES (11120,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11208,'{\"structure\":\"5-5-2\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482159681574-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350927-19\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482159681576-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350929-20\"},{\"widgets\":[{\"title\":\"EDT\",\"wid\":\"1482159681567-5\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/scheduler/scheduler-widget/actions.html\",\"type\":\"scheduler-widget\"}],\"styleClass\":\"col-md-2\",\"cid\":\"1484666350931-21\"}]}]}'),(11209,'{\"structure\":\"5-5-2\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482159681574-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350927-19\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482159681576-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350929-20\"},{\"widgets\":[{\"title\":\"EDT\",\"wid\":\"1482159681567-5\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/scheduler/scheduler-widget/actions.html\",\"type\":\"scheduler-widget\"}],\"styleClass\":\"col-md-2\",\"cid\":\"1484666350931-21\"}]}]}'),(11210,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11211,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11212,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11213,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11214,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11215,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11216,'{\"structure\":\"5-5-2\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482159681574-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350927-19\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482159681576-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350929-20\"},{\"widgets\":[{\"title\":\"EDT\",\"wid\":\"1482159681567-5\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/scheduler/scheduler-widget/actions.html\",\"type\":\"scheduler-widget\"}],\"styleClass\":\"col-md-2\",\"cid\":\"1484666350931-21\"}]}]}'),(11217,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11218,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11219,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11220,'{\"structure\":\"5-5-2\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482159681574-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350927-19\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482159681576-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-5\",\"cid\":\"1484666350929-20\"},{\"widgets\":[{\"title\":\"EDT\",\"wid\":\"1482159681567-5\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/scheduler/scheduler-widget/actions.html\",\"type\":\"scheduler-widget\"}],\"styleClass\":\"col-md-2\",\"cid\":\"1484666350931-21\"}]}]}'),(11221,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11222,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}'),(11223,'{\"structure\":\"6-6\",\"title\":\"Tableau de bord\",\"titleTemplateUrl\":\"../src/templates/dashboard-title.html\",\"rows\":[{\"columns\":[{\"widgets\":[{\"title\":\"Actualités de mes groupes\",\"wid\":\"1482225960904-6\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/news-widget/actions.html\",\"type\":\"news-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960887-3\"},{\"widgets\":[{\"title\":\"Actualités du chef d\'établissement\",\"wid\":\"1482225960906-7\",\"config\":{},\"editTemplateUrl\":\"../src/templates/widget-edit.html\",\"titleTemplateUrl\":\"/dashboard-portlet/js/news/newsHM-widget/actions.html\",\"type\":\"newsHM-widget\"}],\"styleClass\":\"col-md-6\",\"cid\":\"1482225960888-4\"}]}]}');

--
-- Table structure for table `userproperties_internaloauth`
--

CREATE TABLE `userproperties_internaloauth` (
  `internalOauthId` bigint(20) NOT NULL,
  `token` varchar(75) DEFAULT NULL,
  `url` varchar(75) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `timeMarker` datetime DEFAULT NULL,
  PRIMARY KEY (`internalOauthId`),
  KEY `IX_BC45456A` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_internaloauth`
--


--
-- Table structure for table `userproperties_notifyconfig`
--

CREATE TABLE `userproperties_notifyconfig` (
  `notifyConfigId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `activate` tinyint(4) DEFAULT NULL,
  `notifyCasier` tinyint(4) DEFAULT NULL,
  `notifyActu` tinyint(4) DEFAULT NULL,
  `notifyGrpDoc` tinyint(4) DEFAULT NULL,
  `notifyForum` tinyint(4) DEFAULT NULL,
  `notifyAgenda` tinyint(4) DEFAULT NULL,
  `digestPeriod` int(11) DEFAULT NULL,
  PRIMARY KEY (`notifyConfigId`),
  KEY `IX_2E3370B9` (`activate`),
  KEY `IX_E05CAA52` (`activate`,`digestPeriod`),
  KEY `IX_7C23864C` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_notifyconfig`
--

INSERT INTO `userproperties_notifyconfig` VALUES (19507,11105,0,0,0,0,0,0,0),(106501,10205,0,0,0,0,0,0,0);

--
-- Table structure for table `userproperties_usercontact`
--

CREATE TABLE `userproperties_usercontact` (
  `contactId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `isAddressAuthorized` tinyint(4) DEFAULT NULL,
  `mail` varchar(150) DEFAULT NULL,
  `isMailAuthorized` tinyint(4) DEFAULT NULL,
  `mobilePhone` varchar(75) DEFAULT NULL,
  `mobilePhoneSMS` varchar(75) DEFAULT NULL,
  `homePhone` varchar(75) DEFAULT NULL,
  `proPhone` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`contactId`),
  KEY `IX_39E59F54` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_usercontact`
--


--
-- Table structure for table `userproperties_userinternalsso`
--

CREATE TABLE `userproperties_userinternalsso` (
  `userInternalSSOId` bigint(20) NOT NULL,
  `ssoKey` longtext,
  `ssoValue` longtext,
  `timeMarker` datetime DEFAULT NULL,
  PRIMARY KEY (`userInternalSSOId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_userinternalsso`
--

INSERT INTO `userproperties_userinternalsso` VALUES (54717,'ST-ISC-48df3780-4d7b-4606-b6d2-39db524ccba6','http://etablissementdemo.site.pentila.com/wp-login.php?redirect_to=http%3A%2F%2Fetablissementdemo.site.pentila.com%2Fwp-admin%2F&reauth=111105','2013-04-02 09:33:58');

--
-- Table structure for table `userproperties_usermailsynchronisation`
--

CREATE TABLE `userproperties_usermailsynchronisation` (
  `userId` bigint(20) NOT NULL,
  `lastSynchronisation` datetime DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_usermailsynchronisation`
--

INSERT INTO `userproperties_usermailsynchronisation` VALUES (10205,'2011-06-14 17:20:36'),(11105,'2017-11-16 13:00:13');

--
-- Table structure for table `userproperties_usermatching`
--

CREATE TABLE `userproperties_usermatching` (
  `userMatchingId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `withUserId` bigint(20) DEFAULT NULL,
  `valid` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`userMatchingId`),
  KEY `IX_DFF68309` (`userId`),
  KEY `IX_121593A9` (`userId`,`withUserId`),
  KEY `IX_128BC3E3` (`userId`,`withUserId`,`valid`),
  KEY `IX_5129816F` (`withUserId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_usermatching`
--


--
-- Table structure for table `userproperties_usermobilenotification`
--

CREATE TABLE `userproperties_usermobilenotification` (
  `userMobileNotificationId` bigint(20) NOT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `etabId` bigint(20) DEFAULT NULL,
  `enable` tinyint(4) DEFAULT NULL,
  `token` varchar(500) DEFAULT NULL,
  `device` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`userMobileNotificationId`),
  KEY `IX_2114297E` (`etabId`),
  KEY `IX_58103FB5` (`etabId`,`enable`),
  KEY `IX_71F596B9` (`userId`),
  KEY `IX_86FA41F0` (`userId`,`enable`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_usermobilenotification`
--


--
-- Table structure for table `userproperties_userrelationship`
--

CREATE TABLE `userproperties_userrelationship` (
  `userRelationshipId` bigint(20) NOT NULL,
  `fromUserId` bigint(20) DEFAULT NULL,
  `toUserId` bigint(20) DEFAULT NULL,
  `toUserSconetId` varchar(150) DEFAULT NULL,
  `relationType` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`userRelationshipId`),
  KEY `IX_F3313098` (`fromUserId`,`relationType`),
  KEY `IX_C38ED323` (`fromUserId`,`toUserId`),
  KEY `IX_6E6672EB` (`fromUserId`,`toUserSconetId`,`relationType`),
  KEY `IX_C16E77A9` (`toUserId`,`relationType`),
  KEY `IX_FD37D7E7` (`toUserSconetId`,`relationType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userproperties_userrelationship`
--


--
-- Table structure for table `users_groups`
--

CREATE TABLE `users_groups` (
  `userId` bigint(20) NOT NULL,
  `groupId` bigint(20) NOT NULL,
  PRIMARY KEY (`userId`,`groupId`),
  KEY `IX_C4F9E699` (`groupId`),
  KEY `IX_F10B6C6B` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_groups`
--

INSERT INTO `users_groups` VALUES (11105,175510);

--
-- Table structure for table `users_orgs`
--

CREATE TABLE `users_orgs` (
  `userId` bigint(20) NOT NULL,
  `organizationId` bigint(20) NOT NULL,
  PRIMARY KEY (`userId`,`organizationId`),
  KEY `IX_7EF4EC0E` (`organizationId`),
  KEY `IX_FB646CA6` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_orgs`
--

INSERT INTO `users_orgs` VALUES (11105,18201),(11105,18210),(11105,18223),(11105,18241);

--
-- Table structure for table `users_permissions`
--

CREATE TABLE `users_permissions` (
  `userId` bigint(20) NOT NULL,
  `permissionId` bigint(20) NOT NULL,
  PRIMARY KEY (`userId`,`permissionId`),
  KEY `IX_8AE58A91` (`permissionId`),
  KEY `IX_C26AA64D` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_permissions`
--


--
-- Table structure for table `users_roles`
--

CREATE TABLE `users_roles` (
  `userId` bigint(20) NOT NULL,
  `roleId` bigint(20) NOT NULL,
  PRIMARY KEY (`userId`,`roleId`),
  KEY `IX_C19E5F31` (`roleId`),
  KEY `IX_C1A01806` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_roles`
--

INSERT INTO `users_roles` VALUES (11105,10208),(10205,10209),(11105,10211),(11105,10212),(11105,11120),(11105,11121),(11105,19560),(11105,168614);

--
-- Table structure for table `users_teams`
--

CREATE TABLE `users_teams` (
  `userId` bigint(20) NOT NULL,
  `teamId` bigint(20) NOT NULL,
  PRIMARY KEY (`userId`,`teamId`),
  KEY `IX_4D06AD51` (`teamId`),
  KEY `IX_A098EFBF` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_teams`
--


--
-- Table structure for table `users_usergroups`
--

CREATE TABLE `users_usergroups` (
  `userGroupId` bigint(20) NOT NULL,
  `userId` bigint(20) NOT NULL,
  PRIMARY KEY (`userGroupId`,`userId`),
  KEY `IX_66FF2503` (`userGroupId`),
  KEY `IX_BE8102D6` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_usergroups`
--

INSERT INTO `users_usergroups` VALUES (11101,11105),(11122,11105),(11126,11105),(11130,11105),(11227,11105),(11235,11105),(11239,11105),(11243,11105),(11251,11105),(11255,11105),(11259,11105),(11279,11105),(11283,11105),(11295,11105),(11299,11105),(11303,11105),(12601,11105),(18219,11105),(19574,11105),(29778,11105),(36760,11105),(45916,11105),(118003,11105),(142501,11105),(166706,11105),(176501,11105),(183743,11105),(311378,11105),(311503,11105),(313091,11105),(313701,11105),(313705,11105),(314141,11105),(314155,11105);

--
-- Table structure for table `usertracker`
--

CREATE TABLE `usertracker` (
  `userTrackerId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `sessionId` varchar(200) DEFAULT NULL,
  `remoteAddr` varchar(75) DEFAULT NULL,
  `remoteHost` varchar(75) DEFAULT NULL,
  `userAgent` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`userTrackerId`),
  KEY `IX_29BA1CF5` (`companyId`),
  KEY `IX_46B0AE8E` (`sessionId`),
  KEY `IX_E4EFBA8D` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usertracker`
--


--
-- Table structure for table `usertrackerpath`
--

CREATE TABLE `usertrackerpath` (
  `userTrackerPathId` bigint(20) NOT NULL,
  `userTrackerId` bigint(20) DEFAULT NULL,
  `path_` longtext,
  `pathDate` datetime DEFAULT NULL,
  PRIMARY KEY (`userTrackerPathId`),
  KEY `IX_14D8BCC0` (`userTrackerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `usertrackerpath`
--


--
-- Table structure for table `virtualhost`
--

CREATE TABLE `virtualhost` (
  `virtualHostId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `layoutSetId` bigint(20) DEFAULT NULL,
  `hostname` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`virtualHostId`),
  UNIQUE KEY `IX_A083D394` (`companyId`,`layoutSetId`),
  UNIQUE KEY `IX_431A3960` (`hostname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `virtualhost`
--

INSERT INTO `virtualhost` VALUES (62187,10202,0,'ent-nero.com');

--
-- Table structure for table `visioconf_visioconf`
--

CREATE TABLE `visioconf_visioconf` (
  `visioId` bigint(20) NOT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext,
  `visioUrl` longtext,
  `beginDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `authorId` bigint(20) NOT NULL,
  `roomId` bigint(20) NOT NULL,
  PRIMARY KEY (`visioId`),
  KEY `IX_3BB6CB15` (`authorId`),
  KEY `IX_188ACB1E` (`endDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `visioconf_visioconf`
--


--
-- Table structure for table `visioconf_visioconfusers`
--

CREATE TABLE `visioconf_visioconfusers` (
  `visioConfUsersId` bigint(20) NOT NULL,
  `visioId` bigint(20) NOT NULL,
  `userId` bigint(20) NOT NULL,
  PRIMARY KEY (`visioConfUsersId`),
  KEY `IX_E8DC7473` (`userId`),
  KEY `IX_8F727AD8` (`visioId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `visioconf_visioconfusers`
--


--
-- Table structure for table `vocabulary`
--

CREATE TABLE `vocabulary` (
  `vocabularyId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` varchar(75) DEFAULT NULL,
  `folksonomy` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`vocabularyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vocabulary`
--


--
-- Table structure for table `webdavprops`
--

CREATE TABLE `webdavprops` (
  `webDavPropsId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `props` longtext,
  PRIMARY KEY (`webDavPropsId`),
  UNIQUE KEY `IX_97DFA146` (`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `webdavprops`
--

INSERT INTO `webdavprops` VALUES (41229,10202,'2013-01-03 16:09:41','2013-01-03 16:09:41',10063,20225,'<properties />'),(41231,10202,'2013-01-03 16:09:43','2013-01-03 16:09:43',10059,20233,'<properties />'),(41232,10202,'2013-01-03 16:09:43','2013-01-03 16:09:43',10059,20239,'<properties />'),(41233,10202,'2013-01-03 16:09:43','2013-01-03 16:09:43',10059,20245,'<properties />');

--
-- Table structure for table `website`
--

CREATE TABLE `website` (
  `websiteId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `url` longtext,
  `typeId` int(11) DEFAULT NULL,
  `primary_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`websiteId`),
  KEY `IX_96F07007` (`companyId`),
  KEY `IX_4F0F0CA7` (`companyId`,`classNameId`),
  KEY `IX_F960131C` (`companyId`,`classNameId`,`classPK`),
  KEY `IX_1AA07A6D` (`companyId`,`classNameId`,`classPK`,`primary_`),
  KEY `IX_F75690BB` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `website`
--


--
-- Table structure for table `wikinode`
--

CREATE TABLE `wikinode` (
  `uuid_` varchar(75) DEFAULT NULL,
  `nodeId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext,
  `lastPostDate` datetime DEFAULT NULL,
  PRIMARY KEY (`nodeId`),
  UNIQUE KEY `IX_920CD8B1` (`groupId`,`name`),
  UNIQUE KEY `IX_7609B2AE` (`uuid_`,`groupId`),
  KEY `IX_5D6FE3F0` (`companyId`),
  KEY `IX_B480A672` (`groupId`),
  KEY `IX_6C112D7C` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wikinode`
--

INSERT INTO `wikinode` VALUES ('8155371c-f920-4111-a9f7-ef53db932392',152515,152502,10202,10205,'','2013-09-25 09:54:36','2013-09-25 09:54:36','Main','','2013-09-25 09:54:36'),('aa2705b6-df96-46a6-98bd-933f47fd023b',152540,106881,10202,10205,'','2013-09-25 11:44:18','2013-09-25 11:44:18','Main','','2013-09-25 11:44:18'),('d9134943-d37d-42b4-bd37-66dd35a80637',152550,18202,10202,10205,'','2013-09-25 11:51:59','2013-09-25 11:51:59','Main','','2013-09-25 14:14:17'),('b0c7de18-0c52-42bb-ba2c-def39f1e3747',153605,86001,10202,10205,'','2013-09-26 11:46:52','2013-09-26 11:46:52','Main','','2013-09-26 11:48:44'),('d7a5386e-8bf0-4c23-8edb-003944dcff2d',170318,106803,10202,10205,'','2014-01-23 16:14:33','2014-01-23 16:14:33','Main','','2014-01-30 09:48:32'),('cc4542b7-b6b2-4842-96ba-16f6e323342a',172503,18406,10202,10205,'','2014-02-19 13:55:18','2014-02-19 13:55:18','Main','','2014-02-19 13:55:19'),('abb43c68-a23a-4b69-8b39-226e621515ac',175611,175510,10202,10205,'','2014-04-01 15:32:02','2014-04-01 15:32:02','Main','','2014-04-01 15:32:02'),('e29f7a26-d6d5-4641-8b8e-ea4a7d4222d0',226013,11107,10202,10205,'','2014-05-30 07:32:49','2014-05-30 07:32:49','Main','',NULL),('4f555d8a-356a-4333-bf6e-0d4d9e728ade',226015,59503,10202,10205,'','2014-05-30 07:35:23','2014-05-30 07:35:23','Main','',NULL),('99c5842d-2af2-4d86-a00b-d1187977ee6e',226017,18211,10202,10205,'','2014-05-30 07:36:30','2014-05-30 07:36:30','Main','','2014-05-30 08:52:58'),('971bbdee-488b-4de3-b524-dce8306ec388',226119,13003,10202,10205,'','2014-05-30 08:54:39','2014-05-30 08:54:39','Main','','2014-05-30 08:54:39'),('bb6b9e77-923d-4aaa-bc08-9c4f0ee26100',226130,86101,10202,10205,'','2014-05-30 08:55:15','2014-05-30 08:55:15','Main','','2014-05-30 08:55:15');

--
-- Table structure for table `wikipage`
--

CREATE TABLE `wikipage` (
  `uuid_` varchar(75) DEFAULT NULL,
  `pageId` bigint(20) NOT NULL,
  `resourcePrimKey` bigint(20) DEFAULT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `nodeId` bigint(20) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `version` double DEFAULT NULL,
  `minorEdit` tinyint(4) DEFAULT NULL,
  `content` longtext,
  `summary` longtext,
  `format` varchar(75) DEFAULT NULL,
  `head` tinyint(4) DEFAULT NULL,
  `parentTitle` varchar(255) DEFAULT NULL,
  `redirectTitle` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime DEFAULT NULL,
  PRIMARY KEY (`pageId`),
  UNIQUE KEY `IX_3D4AF476` (`nodeId`,`title`,`version`),
  UNIQUE KEY `IX_899D3DFB` (`uuid_`,`groupId`),
  UNIQUE KEY `IX_2CD67C81` (`resourcePrimKey`,`nodeId`,`version`),
  KEY `IX_A2001730` (`format`),
  KEY `IX_C8A9C476` (`nodeId`),
  KEY `IX_E7F635CA` (`nodeId`,`head`),
  KEY `IX_65E84AF4` (`nodeId`,`head`,`parentTitle`),
  KEY `IX_46EEF3C8` (`nodeId`,`parentTitle`),
  KEY `IX_1ECC7656` (`nodeId`,`redirectTitle`),
  KEY `IX_997EEDD2` (`nodeId`,`title`),
  KEY `IX_E745EA26` (`nodeId`,`title`,`head`),
  KEY `IX_9C0E478F` (`uuid_`),
  KEY `IX_9F7655DA` (`nodeId`,`head`,`parentTitle`,`status`),
  KEY `IX_432F0AB0` (`nodeId`,`head`,`status`),
  KEY `IX_546F2D5C` (`nodeId`,`status`),
  KEY `IX_BEA33AB8` (`nodeId`,`title`,`status`),
  KEY `IX_B771D67` (`resourcePrimKey`,`nodeId`),
  KEY `IX_94D1054D` (`resourcePrimKey`,`nodeId`,`status`),
  KEY `IX_FBBE7C96` (`userId`,`nodeId`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wikipage`
--

INSERT INTO `wikipage` VALUES ('fe0f51fe-d4c5-496b-893f-973ba7f687cd',152516,152517,152502,10202,10205,'','2013-09-25 09:54:36','2013-09-25 09:54:36',152515,'FrontPage',1,1,'','New','html',1,'','',0,10205,'','2013-09-25 09:54:36'),('e3eb168f-a0a8-433a-a2cb-7c53de9c090f',152551,152552,18202,10202,10205,'','2013-09-25 11:51:59','2013-09-25 11:51:59',152550,'FrontPage',1,1,'','New','html',0,'','',0,10205,'','2013-09-25 11:51:59'),('8e9deb2a-419b-44fd-bfb8-8280553cc652',152801,152552,18202,10202,11105,'L\'equipe Technique','2013-09-25 12:17:02','2013-09-25 12:17:02',152550,'FrontPage',1.1,0,'<table style=\"font-size: 13px; font-family: sans-serif; line-height: 19.1875px; margin-top: 10px; background-image: none;\">\n	<tbody>\n		<tr>\n			<td style=\"width: 644px; border-style: solid; border-color: rgb(167, 215, 249); vertical-align: top; padding-right: 10px; padding-bottom: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; border-bottom-right-radius: 10px; border-bottom-left-radius: 10px;\">\n				<table cellpadding=\"2\" cellspacing=\"5\" style=\"width: 644px; vertical-align: top; background-color: transparent;\">\n					<tbody>\n						<tr>\n							<td>\n								<div style=\"position: relative; left: 4px; top: 2px;\">\n									<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n										<img alt=\"\" height=\"25\" src=\"http://upload.wikimedia.org/wikipedia/commons/4/46/Bluebg_rounded.png\" style=\"border-style: none; vertical-align: middle; margin: 0px;\" width=\"350\" /></p>\n									<div style=\"position: absolute; left: 5px; top: -6px;\">\n										<img alt=\"\" height=\"38\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/38px-HSutvald2.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/57px-HSutvald2.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/76px-HSutvald2.svg.png 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"38\" /></div>\n									<div style=\"position: absolute; left: 40px; top: 2px;\">\n										<h2 id=\"accueil-lumieresurHead\" style=\"background-image: none; margin-top: 0px; margin-bottom: 0.6em; overflow: hidden; padding: 0.15em 0.4em; border-bottom-style: none; font-size: 17px;\">\n											<span class=\"mw-headline\" id=\"Lumi.C3.A8re_sur\">Lumière sur</span></h2>\n									</div>\n								</div>\n							</td>\n						</tr>\n						<tr>\n							<td>\n								<div id=\"accueil-lumieresur\" style=\"padding-left: 10px; padding-bottom: 5px;\">\n									<div id=\"mf-lumieresur\" title=\"Lumière sur\">\n										<div class=\"floatright\" style=\"clear: right; float: right; position: relative; margin-bottom: 0.5em; margin-left: 0.5em; border: 0px;\">\n											<a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:MacIntosh_Plus_img_1317.jpg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\"><img alt=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\" height=\"100\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/150px-MacIntosh_Plus_img_1317.jpg\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/225px-MacIntosh_Plus_img_1317.jpg 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/300px-MacIntosh_Plus_img_1317.jpg 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"150\" /></a></div>\n										<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n											<b>Logiciel Système 6</b>, souvent simplifié en&nbsp;<b><a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_6\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 6\">Système 6</a></b>, est la sixième version du<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_d%27exploitation\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système d\'exploitation\">système d\'exploitation</a>&nbsp;des ordinateurs&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Macintosh\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Macintosh\">Macintosh</a>, publiée par&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Apple\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Apple\">Apple</a>&nbsp;en avril<a href=\"http://fr.wikipedia.org/wiki/1988_en_informatique\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1988 en informatique\">1988</a>. Il supporte, comme le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_5\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 5\">Système 5</a>, le&nbsp;<i><a href=\"http://fr.wikipedia.org/wiki/MultiFinder\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"MultiFinder\">MultiFinder</a></i>, qui permet l\'utilisation simultanée de plusieurs applications grâce à un système&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Multit%C3%A2che#Multit.C3.A2che_coop.C3.A9ratif\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Multitâche\">multitâche coopératif</a>. Il est fourni avec plusieurs Macintosh à partir de sa publication et jusqu\'à la sortie du&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_7\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 7\">Système 7</a>&nbsp;en&nbsp;<a href=\"http://fr.wikipedia.org/wiki/1991\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1991\">1991</a>. La version boîte coûte alors&nbsp;<span class=\"nowrap\" style=\"white-space: nowrap;\">49&nbsp;$</span>.</p>\n									</div>\n								</div>\n							</td>\n						</tr>\n					</tbody>\n				</table>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>','','html',0,'','',0,11105,'L\'equipe Technique','2013-09-25 12:17:02'),('4af21cc0-d450-44e3-8a18-03f9c1b5740a',152806,152807,18202,10202,11105,'L\'equipe Technique','2013-09-25 12:19:23','2013-09-25 12:19:23',152550,'Nero',1,0,'<div class=\"thumb tleft\" style=\"float: left; clear: left; margin-top: 0.5em; margin-right: 1.4em; margin-bottom: 1.3em; width: auto; font-family: sans-serif; font-size: 13px; line-height: 19.1875px;\">\n	<div class=\"thumbinner\" style=\"border: 1px solid rgb(204, 204, 204); background-color: rgb(249, 249, 249); font-size: 12px; text-align: center; overflow: hidden; padding: 3px !important; width: 222px;\">\n		<a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Nero_Glyptothek_Munich_321.jpg\" style=\"text-decoration: underline; color: rgb(11, 0, 128); background-image: none; background-position: initial initial; background-repeat: initial initial;\"><img alt=\"\" class=\"thumbimage\" height=\"299\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/1/12/Nero_Glyptothek_Munich_321.jpg/220px-Nero_Glyptothek_Munich_321.jpg\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/1/12/Nero_Glyptothek_Munich_321.jpg/330px-Nero_Glyptothek_Munich_321.jpg 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/1/12/Nero_Glyptothek_Munich_321.jpg/440px-Nero_Glyptothek_Munich_321.jpg 2x\" style=\"border: 1px solid rgb(204, 204, 204); vertical-align: middle;\" width=\"220\" /></a>\n		<div class=\"thumbcaption\" style=\"border: none; line-height: 1.4em; font-size: 11px; padding: 3px !important; text-align: left;\">\n			<div class=\"magnify\" style=\"margin-left: 3px; border: none !important; background-image: none !important; float: right; background-position: initial initial !important; background-repeat: initial initial !important;\">\n				<a class=\"internal\" href=\"http://fr.wikipedia.org/wiki/Fichier:Nero_Glyptothek_Munich_321.jpg\" style=\"color: rgb(11, 0, 128); display: block; background-image: none !important; border: none !important;\" title=\"Agrandir\"><img alt=\"\" height=\"11\" src=\"http://bits.wikimedia.org/static-1.22wmf17/skins/common/images/magnify-clip.png\" style=\"vertical-align: middle; display: block; border-style: none !important; background-image: none !important;\" width=\"15\" /></a></div>\n			Néron,&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Glyptoth%C3%A8que_de_Munich\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Glyptothèque de Munich\">Glyptothèque de Munich</a></div>\n		<div>\n			&nbsp;</div>\n	</div>\n</div>\n<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 19.1875px; font-family: sans-serif; font-size: 13px;\">\n	<b>Néron</b>&nbsp;(<a href=\"http://fr.wikipedia.org/wiki/Latin\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Latin\">latin</a>&nbsp;:&nbsp;<small>IMPERATOR NERO CLAVDIVS CAESAR AVGVSTVS GERMANICVS</small>), né&nbsp;<i>Lucius Domitius Ahenobarbus</i>&nbsp;le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/15_d%C3%A9cembre\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"15 décembre\">15 décembre</a><a href=\"http://fr.wikipedia.org/wiki/37\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"37\">37</a>&nbsp;et mort le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/9_juin\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"9 juin\">9 juin</a>&nbsp;<a href=\"http://fr.wikipedia.org/wiki/68\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"68\">68</a>, est le cinquième et dernier&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Empereur_romain\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Empereur romain\">empereur romain</a>&nbsp;de la&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Julio-Claudiens\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Julio-Claudiens\">dynastie julio-claudienne</a>&nbsp;; il régna de 54 à 68.</p>\n<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 19.1875px; font-family: sans-serif; font-size: 13px;\">\n	Il accède au trône le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/13_octobre\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"13 octobre\">13 octobre</a>&nbsp;<a href=\"http://fr.wikipedia.org/wiki/54\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"54\">54</a>, à la mort de son grand-oncle et père adoptif&nbsp;<a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Claude_Ier\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Claude Ier\">Claude</a>&nbsp;(<i>Claudius</i>), Empereur de Rome. En<a href=\"http://fr.wikipedia.org/wiki/66\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"66\">66</a>, il ajoute le titre&nbsp;<i>Imperator</i>&nbsp;à son nom. Il est dépossédé de son pouvoir en&nbsp;<a href=\"http://fr.wikipedia.org/wiki/68\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"68\">68</a>&nbsp;et se suicide assisté de son scribe<a href=\"http://fr.wikipedia.org/wiki/%C3%89paphrodite_(affranchi)\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Épaphrodite (affranchi)\">Épaphrodite</a>.</p>\n<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 19.1875px; font-family: sans-serif; font-size: 13px;\">\n	Bien que&nbsp;<a href=\"http://fr.wikipedia.org/wiki/S%C3%A9n%C3%A8que\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Sénèque\">Sénèque</a>&nbsp;ait été son précepteur, on se souvient de lui comme un despote cruel, notamment pour avoir assassiné sa mère&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Agrippine_la_Jeune\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Agrippine la Jeune\">Agrippine</a>&nbsp;en 59, et pour ses persécutions arbitraires des chrétiens<span class=\"reference\" id=\"cite_ref-1\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-1\" style=\"color: rgb(11, 0, 128); background-image: none;\">1</a></span>. Il est célèbre pour avoir bâti la&nbsp;<a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Domus_Aurea\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Domus Aurea\">Domus Aurea</a>, après l\'incendie de Rome de juillet 64, et pour être un prince poète, chanteur et musicien, un grand organisateur de célébrations sportives et artistiques (les&nbsp;<i>Neronia</i>)<span class=\"reference\" id=\"cite_ref-2\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-2\" style=\"color: rgb(11, 0, 128); background-image: none;\">2</a></span>. Il est aussi un homme d\'une ambition démesurée, ayant lutté de toutes ses forces contre l\'immense conjuration politique dressée contre lui<span class=\"reference\" id=\"cite_ref-3\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-3\" style=\"color: rgb(11, 0, 128); background-image: none;\">3</a></span>. Certains historiens débattent de la folie, réelle ou mise en scène, de Néron<span class=\"reference\" id=\"cite_ref-4\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-4\" style=\"color: rgb(11, 0, 128); background-image: none;\">4</a></span>.</p>\n<p>\n	&nbsp;</p>','','html',0,'','',0,11105,'L\'equipe Technique','2013-09-25 12:19:23'),('7079aaa3-7ba2-4e6e-8967-9949d975c913',152902,152807,18202,10202,11105,'L\'equipe Technique','2013-09-25 12:28:01','2013-09-25 12:28:01',152550,'Nero',1.1,0,'<div class=\"thumb tleft\" style=\"float: left; clear: left; margin-top: 0.5em; margin-right: 1.4em; margin-bottom: 1.3em; width: auto; font-family: sans-serif; font-size: 13px; line-height: 19.1875px;\">\n	<div class=\"thumbinner\" style=\"border: 1px solid rgb(204, 204, 204); background-color: rgb(249, 249, 249); font-size: 12px; text-align: center; overflow: hidden; padding: 3px !important; width: 222px;\">\n		<a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Nero_Glyptothek_Munich_321.jpg\" style=\"text-decoration: underline; color: rgb(11, 0, 128); background-image: none; background-position: initial initial; background-repeat: initial initial;\"><img alt=\"\" class=\"thumbimage\" height=\"299\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/1/12/Nero_Glyptothek_Munich_321.jpg/220px-Nero_Glyptothek_Munich_321.jpg\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/1/12/Nero_Glyptothek_Munich_321.jpg/330px-Nero_Glyptothek_Munich_321.jpg 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/1/12/Nero_Glyptothek_Munich_321.jpg/440px-Nero_Glyptothek_Munich_321.jpg 2x\" style=\"border: 1px solid rgb(204, 204, 204); vertical-align: middle;\" width=\"220\" /></a>\n		<div class=\"thumbcaption\" style=\"border: none; line-height: 1.4em; font-size: 11px; padding: 3px !important; text-align: left;\">\n			<div class=\"magnify\" style=\"margin-left: 3px; border: none !important; background-image: none !important; float: right; background-position: initial initial !important; background-repeat: initial initial !important;\">\n				<a class=\"internal\" href=\"http://fr.wikipedia.org/wiki/Fichier:Nero_Glyptothek_Munich_321.jpg\" style=\"color: rgb(11, 0, 128); display: block; background-image: none !important; border: none !important;\" title=\"Agrandir\"><img alt=\"\" height=\"11\" src=\"http://bits.wikimedia.org/static-1.22wmf17/skins/common/images/magnify-clip.png\" style=\"vertical-align: middle; display: block; border-style: none !important; background-image: none !important;\" width=\"15\" /></a></div>\n			Néron,&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Glyptoth%C3%A8que_de_Munich\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Glyptothèque de Munich\">Glyptothèque de Munich</a></div>\n		<div>\n			&nbsp;</div>\n	</div>\n</div>\n<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 19.1875px; font-family: sans-serif; font-size: 13px;\">\n	<b>Néron</b>&nbsp;(<a href=\"http://fr.wikipedia.org/wiki/Latin\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Latin\">latin</a>&nbsp;:&nbsp;<small>IMPERATOR NERO CLAVDIVS CAESAR AVGVSTVS GERMANICVS</small>), né&nbsp;<i>Lucius Domitius Ahenobarbus</i>&nbsp;le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/15_d%C3%A9cembre\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"15 décembre\">15 décembre</a><a href=\"http://fr.wikipedia.org/wiki/37\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"37\">37</a>&nbsp;et mort le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/9_juin\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"9 juin\">9 juin</a>&nbsp;<a href=\"http://fr.wikipedia.org/wiki/68\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"68\">68</a>, est le cinquième et dernier&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Empereur_romain\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Empereur romain\">empereur romain</a>&nbsp;de la&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Julio-Claudiens\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Julio-Claudiens\">dynastie julio-claudienne</a>&nbsp;; il régna de 54 à 68.</p>\n<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 19.1875px; font-family: sans-serif; font-size: 13px;\">\n	Il accède au trône le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/13_octobre\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"13 octobre\">13 octobre</a>&nbsp;<a href=\"http://fr.wikipedia.org/wiki/54\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"54\">54</a>, à la mort de son grand-oncle et père adoptif&nbsp;<a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Claude_Ier\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Claude Ier\">Claude</a>&nbsp;(<i>Claudius</i>), Empereur de Rome. En<a href=\"http://fr.wikipedia.org/wiki/66\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"66\">66</a>, il ajoute le titre&nbsp;<i>Imperator</i>&nbsp;à son nom. Il est dépossédé de son pouvoir en&nbsp;<a href=\"http://fr.wikipedia.org/wiki/68\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"68\">68</a>&nbsp;et se suicide assisté de son scribe<a href=\"http://fr.wikipedia.org/wiki/%C3%89paphrodite_(affranchi)\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Épaphrodite (affranchi)\">Épaphrodite</a>.</p>\n<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 19.1875px; font-family: sans-serif; font-size: 13px;\">\n	Bien que&nbsp;<a href=\"http://fr.wikipedia.org/wiki/S%C3%A9n%C3%A8que\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Sénèque\">Sénèque</a>&nbsp;ait été son précepteur, on se souvient de lui comme un despote cruel, notamment pour avoir assassiné sa mère&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Agrippine_la_Jeune\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Agrippine la Jeune\">Agrippine</a>&nbsp;en 59, et pour ses persécutions arbitraires des chrétiens<span class=\"reference\" id=\"cite_ref-1\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-1\" style=\"color: rgb(11, 0, 128); background-image: none;\">1</a></span>. Il est célèbre pour avoir bâti la&nbsp;<a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Domus_Aurea\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Domus Aurea\">Domus Aurea</a>, après l\'incendie de Rome de juillet 64, et pour être un prince poète, chanteur et musicien, un grand organisateur de célébrations sportives et artistiques (les&nbsp;<i>Neronia</i>)<span class=\"reference\" id=\"cite_ref-2\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-2\" style=\"color: rgb(11, 0, 128); background-image: none;\">2</a></span>. Il est aussi un homme d\'une ambition démesurée, ayant lutté de toutes ses forces contre l\'immense conjuration politique dressée contre lui<span class=\"reference\" id=\"cite_ref-3\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-3\" style=\"color: rgb(11, 0, 128); background-image: none;\">3</a></span>. Certains historiens débattent de la folie, réelle ou mise en scène, de Néron<span class=\"reference\" id=\"cite_ref-4\" style=\"line-height: 1em; vertical-align: text-top; position: relative; font-size: 0.8em; top: -5px; padding-left: 1px; unicode-bidi: -webkit-isolate; white-space: nowrap;\"><a href=\"http://fr.wikipedia.org/wiki/N%C3%A9ron#cite_note-4\" style=\"color: rgb(11, 0, 128); background-image: none;\">4</a></span>.</p>\n<p>\n	&nbsp;</p>','','html',1,'','',0,11105,'L\'equipe Technique','2013-09-25 12:28:01'),('5438b8d5-86c3-4673-8bf9-ff11beb4966d',153201,153202,18202,10202,11105,'L\'equipe Technique','2013-09-25 13:48:16','2013-09-25 13:48:16',152550,'Saut à ski - 2004',1,0,'<h1 class=\"firstHeading\" id=\"firstHeading\" lang=\"fr\" style=\"background-image: none; font-weight: normal; margin-top: 0px; margin-bottom: 0.1em; overflow: visible; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(170, 170, 170); font-size: 1.6em; line-height: 1.2em;\">\n	<span dir=\"auto\">Grand Prix d\'été de saut à ski 2004</span></h1>\n<div id=\"bodyContent\" style=\"font-size: 0.8em; position: relative; width: 1038px; line-height: 1.5em;\">\n	<div id=\"contentSub\" style=\"font-size: 11px; line-height: 1.2em; margin-bottom: 1.4em; margin-left: 1em; color: rgb(125, 125, 125); width: auto;\">\n		&nbsp;</div>\n	<div class=\"mw-jump\" id=\"jump-to-nav\" style=\"overflow: hidden; height: 0px; zoom: 1; margin-top: -1.4em; margin-bottom: 1.4em;\">\n	</div>\n	<div class=\"mw-content-ltr\" dir=\"ltr\" id=\"mw-content-text\" lang=\"fr\" style=\"direction: ltr;\">\n		<h2 style=\"background-image: none; font-weight: normal; margin-top: 0px; margin-bottom: 0.6em; overflow: hidden; padding-top: 0.65em; padding-bottom: 0.17em; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(170, 170, 170); font-size: 19px; font-family: sans-serif; line-height: 19.1875px;\">\n			<span class=\"mw-headline\" id=\"Classement_g.C3.A9n.C3.A9ral\">Classement général</span><span class=\"mw-editsection mw-editsection-expanded\" style=\"-webkit-user-select: none; font-size: x-small; margin-left: 1em; vertical-align: baseline; line-height: 1em; display: inline-block; white-space: nowrap; padding-right: 0.25em; unicode-bidi: -webkit-isolate; direction: ltr;\"><span class=\"mw-editsection-bracket\" style=\"margin-left: -0.25em; margin-right: 0.25em; color: rgb(85, 85, 85);\">[</span><a class=\"mw-editsection-visualeditor\" href=\"http://fr.wikipedia.org/w/index.php?title=Grand_Prix_d%27%C3%A9t%C3%A9_de_saut_%C3%A0_ski_2004&amp;veaction=edit&amp;section=1\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Modifier la section : Classement général\">modifier</a><span class=\"mw-editsection-divider\" style=\"color: rgb(85, 85, 85);\">&nbsp;|&nbsp;</span><a href=\"http://fr.wikipedia.org/w/index.php?title=Grand_Prix_d%27%C3%A9t%C3%A9_de_saut_%C3%A0_ski_2004&amp;action=edit&amp;section=1\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Modifier la section : Classement général\">modifier le code</a><span class=\"mw-editsection-bracket\" style=\"margin-right: -0.25em; margin-left: 0.25em; color: rgb(85, 85, 85);\">]</span></span></h2>\n		<table class=\"wikitable alternance\" style=\"font-size: 13px; margin: 1em 0px; background-color: rgb(249, 249, 249); border-style: solid; border-color: rgb(170, 170, 170); font-family: sans-serif; line-height: 19.1875px;\">\n			<tbody>\n				<tr style=\"background-color: rgb(238, 238, 238); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"col\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170); background-color: rgb(230, 230, 230); text-align: center;\">\n						Place</th>\n					<th scope=\"col\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170); background-color: rgb(230, 230, 230); text-align: center;\">\n						Nom</th>\n					<th scope=\"col\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170); background-color: rgb(230, 230, 230); text-align: center;\">\n						Pays</th>\n					<th scope=\"col\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170); background-color: rgb(230, 230, 230); text-align: center;\">\n						Points</th>\n				</tr>\n				<tr style=\"background-color: rgb(252, 252, 252); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						1</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<b><a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Adam_Malysz\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Adam Malysz\">Adam Malysz</a></b></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Pologne\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Poland.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de la Pologne\"><img alt=\"Drapeau de la Pologne\" class=\"thumbborder\" height=\"13\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/1/12/Flag_of_Poland.svg/20px-Flag_of_Poland.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/1/12/Flag_of_Poland.svg/30px-Flag_of_Poland.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/1/12/Flag_of_Poland.svg/40px-Flag_of_Poland.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Pologne\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Pologne\">Pologne</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						520</td>\n				</tr>\n				<tr style=\"background-color: rgb(238, 238, 238); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						2</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Martin_Hoellwarth\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Martin Hoellwarth\">Martin Hoellwarth</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Autriche\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Austria.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de l\'Autriche\"><img alt=\"Drapeau de l\'Autriche\" class=\"thumbborder\" height=\"13\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/20px-Flag_of_Austria.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/30px-Flag_of_Austria.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/40px-Flag_of_Austria.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Autriche\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Autriche\">Autriche</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						362</td>\n				</tr>\n				<tr style=\"background-color: rgb(252, 252, 252); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						3</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a href=\"http://fr.wikipedia.org/wiki/Daniel_Forfang\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Daniel Forfang\">Daniel Forfang</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Norvege\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Norway.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de la Norvège\"><img alt=\"Drapeau de la Norvège\" class=\"thumbborder\" height=\"15\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/d/d9/Flag_of_Norway.svg/20px-Flag_of_Norway.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/d/d9/Flag_of_Norway.svg/30px-Flag_of_Norway.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/d/d9/Flag_of_Norway.svg/40px-Flag_of_Norway.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Norv%C3%A8ge\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Norvège\">Norvège</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						312</td>\n				</tr>\n				<tr style=\"background-color: rgb(238, 238, 238); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						4</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a href=\"http://fr.wikipedia.org/wiki/Thomas_Morgenstern\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Thomas Morgenstern\">Thomas Morgenstern</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Autriche\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Austria.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de l\'Autriche\"><img alt=\"Drapeau de l\'Autriche\" class=\"thumbborder\" height=\"13\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/20px-Flag_of_Austria.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/30px-Flag_of_Austria.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/40px-Flag_of_Austria.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Autriche\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Autriche\">Autriche</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						273</td>\n				</tr>\n				<tr style=\"background-color: rgb(252, 252, 252); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						5</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a href=\"http://fr.wikipedia.org/wiki/Noriaki_Kasai\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Noriaki Kasai\">Noriaki Kasai</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Japon\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Japan.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau du Japon\"><img alt=\"Drapeau du Japon\" class=\"thumbborder\" height=\"13\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/9/9e/Flag_of_Japan.svg/20px-Flag_of_Japan.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/9/9e/Flag_of_Japan.svg/30px-Flag_of_Japan.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/9/9e/Flag_of_Japan.svg/40px-Flag_of_Japan.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Japon\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Japon\">Japon</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						263</td>\n				</tr>\n				<tr style=\"background-color: rgb(238, 238, 238); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						6</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Matti_Hautamaeki\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Matti Hautamaeki\">Matti Hautamaeki</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Finlande\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Finland.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de la Finlande\"><img alt=\"Drapeau de la Finlande\" class=\"thumbborder\" height=\"12\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/b/bc/Flag_of_Finland.svg/20px-Flag_of_Finland.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/b/bc/Flag_of_Finland.svg/30px-Flag_of_Finland.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/b/bc/Flag_of_Finland.svg/40px-Flag_of_Finland.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Finlande\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Finlande\">Finlande</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						255</td>\n				</tr>\n				<tr style=\"background-color: rgb(252, 252, 252); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						7</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a class=\"mw-redirect\" href=\"http://fr.wikipedia.org/wiki/Andreas_Kuettel\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Andreas Kuettel\">Andreas Kuettel</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Suisse\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Switzerland.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de la Suisse\"><img alt=\"Drapeau de la Suisse\" class=\"thumbborder\" height=\"15\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/f/f3/Flag_of_Switzerland.svg/15px-Flag_of_Switzerland.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/f/f3/Flag_of_Switzerland.svg/23px-Flag_of_Switzerland.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/f/f3/Flag_of_Switzerland.svg/30px-Flag_of_Switzerland.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"15\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Suisse\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Suisse\">Suisse</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						200</td>\n				</tr>\n				<tr style=\"background-color: rgb(238, 238, 238); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						8</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a href=\"http://fr.wikipedia.org/wiki/Michael_Neumayer\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Michael Neumayer\">Michael Neumayer</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Allemagne\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Germany.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de l\'Allemagne\"><img alt=\"Drapeau de l\'Allemagne\" class=\"thumbborder\" height=\"12\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/b/ba/Flag_of_Germany.svg/20px-Flag_of_Germany.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/b/ba/Flag_of_Germany.svg/30px-Flag_of_Germany.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/b/ba/Flag_of_Germany.svg/40px-Flag_of_Germany.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Allemagne\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Allemagne\">Allemagne</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						192</td>\n				</tr>\n				<tr style=\"background-color: rgb(252, 252, 252); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						9</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a href=\"http://fr.wikipedia.org/wiki/Robert_Kranjec\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Robert Kranjec\">Robert Kranjec</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Slovenie\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Slovenia.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de la Slovénie\"><img alt=\"Drapeau de la Slovénie\" class=\"thumbborder\" height=\"10\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/f/f0/Flag_of_Slovenia.svg/20px-Flag_of_Slovenia.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/f/f0/Flag_of_Slovenia.svg/30px-Flag_of_Slovenia.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/f/f0/Flag_of_Slovenia.svg/40px-Flag_of_Slovenia.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Slov%C3%A9nie\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Slovénie\">Slovénie</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						188</td>\n				</tr>\n				<tr style=\"background-color: rgb(238, 238, 238); background-position: initial initial; background-repeat: initial initial;\">\n					<th scope=\"row\" style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						10</th>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<a href=\"http://fr.wikipedia.org/wiki/Reinhard_Schwarzenberger\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Reinhard Schwarzenberger\">Reinhard Schwarzenberger</a></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						<span class=\"datasortkey\" data-sort-value=\"Autriche\"><span class=\"flagicon\"><a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:Flag_of_Austria.svg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Drapeau de l\'Autriche\"><img alt=\"Drapeau de l\'Autriche\" class=\"thumbborder\" height=\"13\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/20px-Flag_of_Austria.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/30px-Flag_of_Austria.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/4/41/Flag_of_Austria.svg/40px-Flag_of_Austria.svg.png 2x\" style=\"border: 1px solid rgb(221, 221, 221); vertical-align: middle;\" width=\"20\" /></a>&nbsp;</span><a href=\"http://fr.wikipedia.org/wiki/Autriche\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Autriche\">Autriche</a></span></td>\n					<td style=\"padding: 0.2em; border-style: solid; border-color: rgb(170, 170, 170);\">\n						182<br />\n						&nbsp;</td>\n				</tr>\n			</tbody>\n		</table>\n	</div>\n</div>\n<p>\n	&nbsp;</p>','','html',1,'FrontPage','',0,11105,'L\'equipe Technique','2013-09-25 13:48:16'),('3a5a65eb-ec0d-4682-b0e1-7c2375d5d0ec',153211,152552,18202,10202,11105,'L\'equipe Technique','2013-09-25 13:53:10','2013-09-25 13:53:10',152550,'FrontPage',1.2,0,'<table style=\"font-size: 13px; font-family: sans-serif; line-height: 19.1875px; margin-top: 10px; background-image: none;\">\n	<tbody>\n		<tr>\n			<td style=\"width: 644px; border-style: solid; border-color: rgb(167, 215, 249); vertical-align: top; padding-right: 10px; padding-bottom: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; border-bottom-right-radius: 10px; border-bottom-left-radius: 10px;\">\n				<table cellpadding=\"2\" cellspacing=\"5\" style=\"width: 644px; vertical-align: top; background-color: transparent;\">\n					<tbody>\n						<tr>\n							<td>\n								<div style=\"position: relative; left: 4px; top: 2px;\">\n									<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n										<img alt=\"\" height=\"25\" src=\"http://upload.wikimedia.org/wikipedia/commons/4/46/Bluebg_rounded.png\" style=\"border-style: none; vertical-align: middle; margin: 0px;\" width=\"350\" /></p>\n									<div style=\"position: absolute; left: 5px; top: -6px;\">\n										<img alt=\"\" height=\"38\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/38px-HSutvald2.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/57px-HSutvald2.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/76px-HSutvald2.svg.png 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"38\" /></div>\n									<div style=\"position: absolute; left: 40px; top: 2px;\">\n										<h2 id=\"accueil-lumieresurHead\" style=\"background-image: none; margin-top: 0px; margin-bottom: 0.6em; overflow: hidden; padding: 0.15em 0.4em; border-bottom-style: none; font-size: 17px;\">\n											<span class=\"mw-headline\" id=\"Lumi.C3.A8re_sur\">Lumière sur</span></h2>\n									</div>\n								</div>\n							</td>\n						</tr>\n						<tr>\n							<td>\n								<div id=\"accueil-lumieresur\" style=\"padding-left: 10px; padding-bottom: 5px;\">\n									<div id=\"mf-lumieresur\" title=\"Lumière sur\">\n										<div class=\"floatright\" style=\"clear: right; float: right; position: relative; margin-bottom: 0.5em; margin-left: 0.5em; border: 0px;\">\n											<a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:MacIntosh_Plus_img_1317.jpg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\"><img alt=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\" height=\"100\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/150px-MacIntosh_Plus_img_1317.jpg\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/225px-MacIntosh_Plus_img_1317.jpg 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/300px-MacIntosh_Plus_img_1317.jpg 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"150\" /></a></div>\n										<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n											<b>Logiciel Système 6</b>, souvent simplifié en&nbsp;<b><a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_6\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 6\">Système 6</a></b>, est la sixième version du<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_d%27exploitation\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système d\'exploitation\">système d\'exploitation</a>&nbsp;des ordinateurs&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Macintosh\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Macintosh\">Macintosh</a>, publiée par&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Apple\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Apple\">Apple</a>&nbsp;en avril<a href=\"http://fr.wikipedia.org/wiki/1988_en_informatique\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1988 en informatique\">1988</a>. Il supporte, comme le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_5\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 5\">Système 5</a>, le&nbsp;<i><a href=\"http://fr.wikipedia.org/wiki/MultiFinder\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"MultiFinder\">MultiFinder</a></i>, qui permet l\'utilisation simultanée de plusieurs applications grâce à un système&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Multit%C3%A2che#Multit.C3.A2che_coop.C3.A9ratif\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Multitâche\">multitâche coopératif</a>. Il est fourni avec plusieurs Macintosh à partir de sa publication et jusqu\'à la sortie du&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_7\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 7\">Système 7</a>&nbsp;en&nbsp;<a href=\"http://fr.wikipedia.org/wiki/1991\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1991\">1991</a>. La version boîte coûte alors&nbsp;<span class=\"nowrap\" style=\"white-space: nowrap;\">49&nbsp;$</span>.</p>\n									</div>\n								</div>\n							</td>\n						</tr>\n					</tbody>\n				</table>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n\nSaut à ski : \n<a href=\"http://localhost:8580/group/nero-demo/atelier/-/wiki/Main/Saut+%C3%A0%20ski+-+2004/maximized\">Saut à ski - 2004</a>','','html',0,'','',0,11105,'L\'equipe Technique','2013-09-25 13:53:10'),('58ee2933-c1df-433a-961e-8b7cbb012cc7',153215,152552,18202,10202,11105,'L\'equipe Technique','2013-09-25 13:54:52','2013-09-25 13:54:52',152550,'FrontPage',1.3,0,'<table style=\"font-size: 13px; font-family: sans-serif; line-height: 19.1875px; margin-top: 10px; background-image: none;\">\n	<tbody>\n		<tr>\n			<td style=\"width: 644px; border-style: solid; border-color: rgb(167, 215, 249); vertical-align: top; padding-right: 10px; padding-bottom: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; border-bottom-right-radius: 10px; border-bottom-left-radius: 10px;\">\n				<table cellpadding=\"2\" cellspacing=\"5\" style=\"width: 644px; vertical-align: top; background-color: transparent;\">\n					<tbody>\n						<tr>\n							<td>\n								<div style=\"position: relative; left: 4px; top: 2px;\">\n									<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n										<img alt=\"\" height=\"25\" src=\"http://upload.wikimedia.org/wikipedia/commons/4/46/Bluebg_rounded.png\" style=\"border-style: none; vertical-align: middle; margin: 0px;\" width=\"350\" /></p>\n									<div style=\"position: absolute; left: 5px; top: -6px;\">\n										<img alt=\"\" height=\"38\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/38px-HSutvald2.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/57px-HSutvald2.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/76px-HSutvald2.svg.png 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"38\" /></div>\n									<div style=\"position: absolute; left: 40px; top: 2px;\">\n										<h2 id=\"accueil-lumieresurHead\" style=\"background-image: none; margin-top: 0px; margin-bottom: 0.6em; overflow: hidden; padding: 0.15em 0.4em; border-bottom-style: none; font-size: 17px;\">\n											<span class=\"mw-headline\" id=\"Lumi.C3.A8re_sur\">Lumière sur</span></h2>\n									</div>\n								</div>\n							</td>\n						</tr>\n						<tr>\n							<td>\n								<div id=\"accueil-lumieresur\" style=\"padding-left: 10px; padding-bottom: 5px;\">\n									<div id=\"mf-lumieresur\" title=\"Lumière sur\">\n										<div class=\"floatright\" style=\"clear: right; float: right; position: relative; margin-bottom: 0.5em; margin-left: 0.5em; border: 0px;\">\n											<a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:MacIntosh_Plus_img_1317.jpg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\"><img alt=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\" height=\"100\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/150px-MacIntosh_Plus_img_1317.jpg\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/225px-MacIntosh_Plus_img_1317.jpg 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/300px-MacIntosh_Plus_img_1317.jpg 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"150\" /></a></div>\n										<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n											<b>Logiciel Système 6</b>, souvent simplifié en&nbsp;<b><a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_6\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 6\">Système 6</a></b>, est la sixième version du<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_d%27exploitation\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système d\'exploitation\">système d\'exploitation</a>&nbsp;des ordinateurs&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Macintosh\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Macintosh\">Macintosh</a>, publiée par&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Apple\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Apple\">Apple</a>&nbsp;en avril<a href=\"http://fr.wikipedia.org/wiki/1988_en_informatique\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1988 en informatique\">1988</a>. Il supporte, comme le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_5\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 5\">Système 5</a>, le&nbsp;<i><a href=\"http://fr.wikipedia.org/wiki/MultiFinder\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"MultiFinder\">MultiFinder</a></i>, qui permet l\'utilisation simultanée de plusieurs applications grâce à un système&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Multit%C3%A2che#Multit.C3.A2che_coop.C3.A9ratif\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Multitâche\">multitâche coopératif</a>. Il est fourni avec plusieurs Macintosh à partir de sa publication et jusqu\'à la sortie du&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_7\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 7\">Système 7</a>&nbsp;en&nbsp;<a href=\"http://fr.wikipedia.org/wiki/1991\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1991\">1991</a>. La version boîte coûte alors&nbsp;<span class=\"nowrap\" style=\"white-space: nowrap;\">49&nbsp;$</span>.</p>\n									</div>\n								</div>\n							</td>\n						</tr>\n					</tbody>\n				</table>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<h3>\n	Saut à ski : <a href=\"http://localhost:8580/group/nero-demo/atelier/-/wiki/Main/Saut+%C3%A0%20ski+-+2004/maximized\">Saut à ski - 2004</a></h3>\n<h3>\n	Néron : <a href=\"http://localhost:8580/group/nero-demo/atelier/-/wiki/Main/Nero/maximized\">Saut à ski - 2004</a></h3>','','html',0,'','',0,11105,'L\'equipe Technique','2013-09-25 13:54:52'),('c0c89e95-5e31-4a90-9f1e-e05ef100360f',153303,152552,18202,10202,11105,'L\'equipe Technique','2013-09-25 14:14:17','2013-09-25 14:14:17',152550,'FrontPage',1.4,0,'<table style=\"font-size: 13px; font-family: sans-serif; line-height: 19.1875px; margin-top: 10px; background-image: none;\">\n	<tbody>\n		<tr>\n			<td style=\"width: 644px; border-style: solid; border-color: rgb(167, 215, 249); vertical-align: top; padding-right: 10px; padding-bottom: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; border-bottom-right-radius: 10px; border-bottom-left-radius: 10px;\">\n				<table cellpadding=\"2\" cellspacing=\"5\" style=\"width: 644px; vertical-align: top; background-color: transparent;\">\n					<tbody>\n						<tr>\n							<td>\n								<div style=\"position: relative; left: 4px; top: 2px;\">\n									<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n										<img alt=\"\" height=\"25\" src=\"http://upload.wikimedia.org/wikipedia/commons/4/46/Bluebg_rounded.png\" style=\"border-style: none; vertical-align: middle; margin: 0px;\" width=\"350\" /></p>\n									<div style=\"position: absolute; left: 5px; top: -6px;\">\n										<img alt=\"\" height=\"38\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/38px-HSutvald2.svg.png\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/57px-HSutvald2.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/f/fd/HSutvald2.svg/76px-HSutvald2.svg.png 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"38\" /></div>\n									<div style=\"position: absolute; left: 40px; top: 2px;\">\n										<h2 id=\"accueil-lumieresurHead\" style=\"background-image: none; margin-top: 0px; margin-bottom: 0.6em; overflow: hidden; padding: 0.15em 0.4em; border-bottom-style: none; font-size: 17px;\">\n											<span class=\"mw-headline\" id=\"Lumi.C3.A8re_sur\">Lumière sur</span></h2>\n									</div>\n								</div>\n							</td>\n						</tr>\n						<tr>\n							<td>\n								<div id=\"accueil-lumieresur\" style=\"padding-left: 10px; padding-bottom: 5px;\">\n									<div id=\"mf-lumieresur\" title=\"Lumière sur\">\n										<div class=\"floatright\" style=\"clear: right; float: right; position: relative; margin-bottom: 0.5em; margin-left: 0.5em; border: 0px;\">\n											<a class=\"image\" href=\"http://commons.wikimedia.org/wiki/File:MacIntosh_Plus_img_1317.jpg\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\"><img alt=\"Un Macintosh Plus&nbsp;: sorti en 1986, il est un des plus anciens ordinateurs supportés officiellement par le Système 6.\" height=\"100\" src=\"http://upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/150px-MacIntosh_Plus_img_1317.jpg\" srcset=\"//upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/225px-MacIntosh_Plus_img_1317.jpg 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/9/93/MacIntosh_Plus_img_1317.jpg/300px-MacIntosh_Plus_img_1317.jpg 2x\" style=\"border-style: none; vertical-align: middle;\" width=\"150\" /></a></div>\n										<p style=\"margin-top: 0.4em; margin-bottom: 0.5em; line-height: 1.5em;\">\n											<b>Logiciel Système 6</b>, souvent simplifié en&nbsp;<b><a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_6\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 6\">Système 6</a></b>, est la sixième version du<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_d%27exploitation\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système d\'exploitation\">système d\'exploitation</a>&nbsp;des ordinateurs&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Macintosh\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Macintosh\">Macintosh</a>, publiée par&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Apple\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Apple\">Apple</a>&nbsp;en avril<a href=\"http://fr.wikipedia.org/wiki/1988_en_informatique\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1988 en informatique\">1988</a>. Il supporte, comme le&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_5\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 5\">Système 5</a>, le&nbsp;<i><a href=\"http://fr.wikipedia.org/wiki/MultiFinder\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"MultiFinder\">MultiFinder</a></i>, qui permet l\'utilisation simultanée de plusieurs applications grâce à un système&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Multit%C3%A2che#Multit.C3.A2che_coop.C3.A9ratif\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Multitâche\">multitâche coopératif</a>. Il est fourni avec plusieurs Macintosh à partir de sa publication et jusqu\'à la sortie du&nbsp;<a href=\"http://fr.wikipedia.org/wiki/Syst%C3%A8me_7\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"Système 7\">Système 7</a>&nbsp;en&nbsp;<a href=\"http://fr.wikipedia.org/wiki/1991\" style=\"color: rgb(11, 0, 128); background-image: none;\" title=\"1991\">1991</a>. La version boîte coûte alors&nbsp;<span class=\"nowrap\" style=\"white-space: nowrap;\">49&nbsp;$</span>.</p>\n									</div>\n								</div>\n							</td>\n						</tr>\n					</tbody>\n				</table>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<h3>\n	Saut à ski : <a href=\"http://localhost:8580/group/nero-demo/atelier/-/wiki/Main/Saut+%C3%A0%20ski+-+2004/maximized\">Saut à ski - 2004</a></h3>\n<h3>\n	Néron : <a href=\"http://localhost:8580/group/nero-demo/atelier/-/wiki/Main/Nero/maximized\">Saut à ski - 2004</a></h3>','','html',1,'','',0,11105,'L\'equipe Technique','2013-09-25 14:14:17'),('859b5fbf-40af-4d3c-9980-c64b09aa7937',175612,175613,175510,10202,10205,'','2014-04-01 15:32:02','2014-04-01 15:32:02',175611,'FrontPage',1,1,'','New','html',1,'','',0,10205,'','2014-04-01 15:32:03'),('c190d1df-3409-4ce7-9460-6a219b6a199c',226103,226104,18211,10202,10205,'','2014-05-30 08:49:14','2014-05-30 08:49:14',226017,'FrontPage',1,1,'','New','html',0,'','',0,10205,'','2014-05-30 08:49:14'),('aae13289-822a-4658-94b4-17df08ebe350',226112,226104,18211,10202,11105,'L\'equipe Technique','2014-05-30 08:52:58','2014-05-30 08:52:58',226017,'FrontPage',1.1,0,'<div class=\"portlet-msg-info\">\n	Je test actuellement l\'ajout de page Wiki. Afin de voir la portée de ces dernières. J\'en profite également pour vérifier les traductions.</div>','','html',1,'','',0,11105,'L\'equipe Technique','2014-05-30 08:52:58');

--
-- Table structure for table `wikipageresource`
--

CREATE TABLE `wikipageresource` (
  `resourcePrimKey` bigint(20) NOT NULL,
  `nodeId` bigint(20) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `uuid_` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`resourcePrimKey`),
  UNIQUE KEY `IX_21277664` (`nodeId`,`title`),
  KEY `IX_BE898221` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wikipageresource`
--

INSERT INTO `wikipageresource` VALUES (152517,152515,'FrontPage','bc43f839-c470-453a-8c29-f9f30ed46222'),(152542,152540,'FrontPage','34cb2b86-ff3e-4d6f-9df0-4e0060ae90c2'),(152552,152550,'FrontPage','63efbb3b-3f3b-479d-a4b9-bb79d0e89033'),(152807,152550,'Nero','9ee1e48c-0233-4409-a57c-308ae838bcf8'),(153202,152550,'Saut à ski - 2004','4eeb8829-2ffd-46ac-af8c-999950b4e86f'),(153607,153605,'FrontPage','d81cf539-3f0e-4c35-8049-2fbd2d7b4330'),(170320,170318,'FrontPage','b6a45418-2022-4b4b-b8bd-9e20deacbd18'),(172505,172503,'FrontPage','b56fa3e7-cab0-4f1b-9c40-fb99496fa04d'),(175613,175611,'FrontPage','636da135-309a-4d29-84c0-80ce7dc1a4d8'),(226104,226017,'FrontPage','3aea792a-6a9b-44f3-8bec-2355e6c349d9'),(226121,226119,'FrontPage','414c01e6-40e2-43a6-917f-9e1c56929175'),(226132,226130,'FrontPage','1755ebcc-b835-41b2-8b04-b6ae54598f2e');

--
-- Table structure for table `workflowdefinitionlink`
--

CREATE TABLE `workflowdefinitionlink` (
  `workflowDefinitionLinkId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `workflowDefinitionName` varchar(75) DEFAULT NULL,
  `workflowDefinitionVersion` int(11) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `typePK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`workflowDefinitionLinkId`),
  KEY `IX_A8B0D276` (`companyId`),
  KEY `IX_A4DB1F0F` (`companyId`,`workflowDefinitionName`,`workflowDefinitionVersion`),
  KEY `IX_B6EE8C9E` (`groupId`,`companyId`,`classNameId`),
  KEY `IX_1E5B9905` (`groupId`,`companyId`,`classNameId`,`classPK`),
  KEY `IX_705B40EE` (`groupId`,`companyId`,`classNameId`,`classPK`,`typePK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `workflowdefinitionlink`
--


--
-- Table structure for table `workflowinstancelink`
--

CREATE TABLE `workflowinstancelink` (
  `workflowInstanceLinkId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifiedDate` datetime DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `workflowInstanceId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`workflowInstanceLinkId`),
  KEY `IX_415A7007` (`groupId`,`companyId`,`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `workflowinstancelink`
--



