Atlantal Content Management System-开源

-- MySQL dump 10.10 -- -- Host: localhost Database: ewaloo -- ------------------------------------------------------ -- Server version 5.0.22-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `ewaloo` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ewaloo` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `ewaloo`; -- -- Table structure for table `_com_ewaloo_ann_affaire` -- DROP TABLE IF EXISTS `_com_ewaloo_ann_affaire`; CREATE TABLE `_com_ewaloo_ann_affaire` ( `_object_id` int(10) unsigned NOT NULL, `_object_id_tree` int(10) unsigned NOT NULL, `_object_id_context` int(10) unsigned default NULL, `_object_id_root` int(10) unsigned default NULL, `_object_id_parent` int(10) unsigned default NULL, `_object_id_application` int(10) unsigned NOT NULL, `_object_id_owner` int(10) unsigned NOT NULL, `_object_id_version` int(10) unsigned NOT NULL, `_object_state` int(10) unsigned NOT NULL, `_object_guid` varchar(21) NOT NULL, `_label_id` int(10) unsigned NOT NULL, `_affaire_id` int(10) unsigned NOT NULL, `_label_label` varchar(100) default NULL, `_label_description` text, PRIMARY KEY (`_object_id`), KEY `object_id_tree` (`_object_id_tree`), KEY `object_id_root` (`_object_id_root`), KEY `object_id_parent` (`_object_id_parent`), KEY `object_id_version` (`_object_id_version`), KEY `object_state` (`_object_state`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `_com_ewaloo_ann_affaire` -- /*!40000 ALTER TABLE `_com_ewaloo_ann_affaire` DISABLE KEYS */; LOCK TABLES `_com_ewaloo_ann_affaire` WRITE; INSERT INTO `_com_ewaloo_ann_affaire` VALUES (27390,27385,15461,15461,23324,0,3255,3,0,'27390_27385',3648,1,'Test de marché N°1','Description de mon test de marché N°1'); UNLOCK TABLES; /*!40000 ALTER TABLE `_com_ewaloo_ann_affaire` ENABLE KEYS */; -- -- Table structure for table `_com_ewaloo_ann_affairecandidat` -- DROP TABLE IF EXISTS `_com_ewaloo_ann_affairecandidat`; CREATE TABLE `_com_ewaloo_ann_affairecandidat` ( `_object_id` int(10) unsigned NOT NULL, `_object_id_tree` int(10) unsigned NOT NULL, `_object_id_context` int(10) unsigned default NULL, `_object_id_root` int(10) unsigned default NULL, `_object_id_parent` int(10) unsigned default NULL, `_object_id_application` int(10) unsigned NOT NULL, `_object_id_owner` int(10) unsigned NOT NULL, `_object_id_version` int(10) unsigned NOT NULL, `_object_state` int(10) unsigned NOT NULL, `_object_guid` varchar(21) NOT NULL, `_label_id` int(10) unsigned NOT NULL, `_affairecandidat_id` int(10) unsigned NOT NULL, `_label_label` varchar(100) default NULL, `_label_description` text, `_affairecandidat_id_candidat` int(10) unsigned default NULL, `_affairecandidat_date_reception` datetime default NULL, PRIMARY KEY (`_object_id`), KEY `object_id_tree` (`_object_id_tree`), KEY `object_id_root` (`_object_id_root`), KEY `object_id_parent` (`_object_id_parent`), KEY `object_id_version` (`_object_id_version`), KEY `object_state` (`_object_state`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `_com_ewaloo_ann_affairecandidat` -- /*!40000 ALTER TABLE `_com_ewaloo_ann_affairecandidat` DISABLE KEYS */; LOCK TABLES `_com_ewaloo_ann_affairecandidat` WRITE; INSERT INTO `_com_ewaloo_ann_affairecandidat` VALUES (29970,29962,15461,15461,27390,0,3255,3,0,'29970_29962',4810,2,'Conseil Régional d\'Aquitaine','test',16172,'2005-02-18 11:00:00'); UNLOCK TABLES; /*!40000 ALTER TABLE `_com_ewaloo_ann_affairecandidat` ENABLE KEYS */; -- -- Table structure for table `_com_ewaloo_ann_bedroom` -- DROP TABLE IF EXISTS `_com_ewaloo_ann_bedroom`; CREATE TABLE `_com_ewaloo_ann_bedroom` ( `_object_id` int(10) unsigned NOT NULL, `_object_id_tree` int(10) unsigned NOT NULL, `_object_id_context` int(10) unsigned default NULL, `_object_id_root` int(10) unsigned default NULL, `_object_id_parent` int(10) unsigned default NULL, `_object_id_application` int(10) unsigned NOT NULL, `_object_id_owner` int(10) unsigned NOT NULL, `_object_id_version` int(10) unsigned NOT NULL, `_object_state` int(10) unsigned NOT NULL, `_object_guid` varchar(21) NOT NULL, `_bedroom_id` int(10) unsigned NOT NULL, `_bedroom_label` varchar(50) default NULL, `_bedroom_beds` int(10) unsigned default NULL, `_bedroom_quantity` int(10) unsigned default NULL, PRIMARY KEY (`_object_id`), KEY `object_id_tree` (`_object_id_tree`), KEY `object_id_root` (`_object_id_root`), KEY `object_id_parent` (`_object_id_parent`), KEY `object_id_version` (`_object_id_version`), KEY `object_state` (`_object_state`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `_com_ewaloo_ann_bedroom` -- /*!40000 ALTER TABLE `_com_ewaloo_ann_bedroom` DISABLE KEYS */; LOCK TABLES `_com_ewaloo_ann_bedroom` WRITE; INSERT INTO `_com_ewaloo_ann_bedroom` VALUES (97,3879,5,5,96,1,3253,1,0,'97_3879',1,'Chambres',2,18),(1244,3879,5,5,1242,1,3253,3,0,'1244_3879',2,'Chambres',2,12),(1367,3879,5,5,1348,1,3253,3,0,'1367_3879',3,'Chambres',2,31),(1368,3879,5,5,1348,1,3253,1,0,'1368_3879',4,'Suites',2,4),(1370,3879,5,5,1369,1,3253,1,0,'1370_3879',5,'Chambres',2,91),(1371,3879,5,5,1369,1,3253,1,0,'1371_3879',6,'Suites',2,5),(1373,3879,5,5,1372,1,3253,1,0,'1373_3879',7,'Chambres',2,68),(1374,3879,5,5,1372,1,3253,1,0,'1374_3879',8,'Suites',2,15),(1376,3879,5,5,1375,1,3253,1,0,'1376_3879',9,'Chambres',2,79),(1378,3879,5,5,1377,1,3253,1,0,'1378_3879',10,'Chambres',2,102),(1379,3879,5,5,1350,1,3253,1,0,'1379_3879',11,'Chambres',2,49),(1380,3879,5,5,1350,1,3253,1,0,'1380_3879',12,'Suites',2,1),(1381,3879,5,5,1361,1,3253,1,0,'1381_3879',13,'Chambres',2,137),(1382,3879,5,5,1361,1,3253,1,0,'1382_3879',14,'Suites',2,7),(1383,3879,5,5,1351,1,3253,1,0,'1383_3879',15,'Chambres',2,194),(1384,3879,5,5,1351,1,3253,1,0,'1384_3879',16,'Suites',2,2),(1385,3879,5,5,1352,1,3253,1,0,'1385_3879',17,'Chambres',2,98),(1386,3879,5,5,1352,1,3253,1,0,'1386_3879',18,'Suites',2,2),(1389,3879,5,5,1388,1,3253,1,0,'1389_3879',19,'Chambres',2,37),(1390,3879,5,5,1360,1,3253,1,0,'1390_3879',20,'Chambres',2,23),(1391,3879,5,5,1360,1,3253,1,0,'1391_3879',21,'Suites',2,1),(1392,3879,5,5,1359,1,3253,1,0,'1392_3879',22,'Chambres',2,45),(1393,3879,5,5,1357,1,3253,1,0,'1393_3879',23,'Chambres',2,84),(1394,3879,5,5,1357,1,3253,1,0,'1394_3879',24,'Suites',2,3),(1395,3879,5,5,1356,1,3253,1,0,'1395_3879',25,'Chambres',2,27),(1396,3879,5,5,1355,1,3253,1,0,'1396_3879',26,'Chambres',2,136),(1397,3879,5,5,1355,1,3253,1,0,'1397_3879',27,'Suites',2,2),(1398,3879,5,5,1354,1,3253,1,0,'1398_3879',28,'Chambres',2,98),(1400,3879,5,5,1399,1,3253,1,0,'1400_3879',29,'Chambres',2,176),(1401,3879,5,5,1366,1,3253,1,0,'1401_3879',30,'Chambres',2,15),(1403,3879,5,5,1402,1,3253,1,0,'1403_3879',31,'Chambres',2,26),(1404,3879,5,5,1347,1,3253,1,0,'1404_3879',32,'Chambres',2,62),(1405,3879,5,5,1347,1,3253,1,0,'1405_3879',33,'Suites',2,1),(1406,3879,5,5,1364,1,3253,1,0,'1406_3879',34,'Chambres',2,20),(1407,3879,5,5,1363,1,3253,1,0,'1407_3879',35,'Chambres',2,15),(1409,3879,5,5,1408,1,3253,1,0,'1409_3879',36,'Chambres',2,9),(1411,3879,5,5,1410,1,3253,1,0,'1411_3879',37,'Chambres',2,36),(1413,3879,5,5,1412,1,3253,1,0,'1413_3879',38,'Chambres',2,60),(1415,3879,5,5,1414,1,3253,1,0,'1415_3879',39,'Chambres'