-- MySQL dump 10.10
--
-- Host: localhost    Database: test2
-- ------------------------------------------------------
-- Server version	5.0.30-Debian_1-log

/*!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 */;

--
-- Temporary table structure for view `__vue_arborescence_fr`
--

DROP TABLE IF EXISTS `__vue_arborescence_fr`;
/*!50001 DROP VIEW IF EXISTS `__vue_arborescence_fr`*/;
/*!50001 CREATE TABLE `__vue_arborescence_fr` (
  `id` mediumint(8) unsigned,
  `ref_arborescence` mediumint(8) unsigned,
  `ref_arborescence_redir` mediumint(8) unsigned,
  `ref_portail` tinyint(3) unsigned,
  `ref_page` mediumint(8) unsigned,
  `ordre` mediumint(8) unsigned,
  `profil` enum('publique','utilisateur','structure','admin'),
  `root` tinyint(1),
  `position` enum('haut','bas'),
  `visible_menu` tinyint(1),
  `visible_plan` tinyint(1),
  `titre` longtext,
  `titre_rewriting` longtext
) */;

--
-- Temporary table structure for view `__vue_pages_fr`
--

DROP TABLE IF EXISTS `__vue_pages_fr`;
/*!50001 DROP VIEW IF EXISTS `__vue_pages_fr`*/;
/*!50001 CREATE TABLE `__vue_pages_fr` (
  `id` mediumint(8) unsigned,
  `date_modification` timestamp,
  `reference` varchar(255),
  `profil` enum('publique','utilisateur','structure','admin'),
  `description` text,
  `accesskey` varchar(255),
  `rel` varchar(255),
  `type` enum('statique','dynamique','fichier'),
  `design` enum('normal','simple','none'),
  `path` varchar(255),
  `criteres` text,
  `cache_this` tinyint(1),
  `locked` tinyint(1),
  `titre` longtext,
  `ref_langue` int(5),
  `meta_description` longtext,
  `meta_mots_cles` longtext,
  `contenu` longtext
) */;

--
-- Table structure for table `arborescence`
--

DROP TABLE IF EXISTS `arborescence`;
CREATE TABLE `arborescence` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `ref_arborescence` mediumint(8) unsigned default NULL,
  `ref_arborescence_redir` mediumint(8) unsigned default NULL,
  `ref_portail` tinyint(3) unsigned NOT NULL,
  `ref_page` mediumint(8) unsigned NOT NULL,
  `titre` varchar(255) NOT NULL,
  `titre_rewriting` varchar(255) NOT NULL,
  `ordre` mediumint(8) unsigned NOT NULL,
  `profil` enum('publique','utilisateur','structure','admin') NOT NULL,
  `root` tinyint(1) NOT NULL default '0',
  `position` enum('haut','bas') NOT NULL,
  `visible_menu` tinyint(1) NOT NULL default '1',
  `visible_plan` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `cle` (`ref_arborescence`,`ref_portail`,`ref_page`,`titre`,`profil`,`position`),
  KEY `ref_arborescence` (`ref_arborescence`),
  KEY `ref_portail` (`ref_portail`),
  KEY `ref_page` (`ref_page`),
  KEY `ref_arborescence_redir` (`ref_arborescence_redir`),
  CONSTRAINT `arborescence_ibfk_15` FOREIGN KEY (`ref_arborescence`) REFERENCES `arborescence` (`id`) ON DELETE CASCADE,
  CONSTRAINT `arborescence_ibfk_16` FOREIGN KEY (`ref_arborescence_redir`) REFERENCES `arborescence` (`id`) ON DELETE CASCADE,
  CONSTRAINT `arborescence_ibfk_17` FOREIGN KEY (`ref_page`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `arborescence`
--

LOCK TABLES `arborescence` WRITE;
/*!40000 ALTER TABLE `arborescence` DISABLE KEYS */;
INSERT INTO `arborescence` VALUES (4,NULL,NULL,2,5,'','',1,'publique',0,'bas',1,1);
/*!40000 ALTER TABLE `arborescence` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pages`
--

DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `ref_langue` tinyint(3) unsigned NOT NULL,
  `date_modification` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `reference` varchar(255) NOT NULL,
  `profil` enum('publique','utilisateur','structure','admin') NOT NULL default 'publique',
  `titre` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `accesskey` varchar(255) default NULL,
  `rel` varchar(255) default NULL,
  `meta_description` varchar(255) NOT NULL,
  `meta_mots_cles` text NOT NULL,
  `type` enum('statique','dynamique','fichier') NOT NULL default 'dynamique',
  `design` enum('normal','simple','none') NOT NULL default 'normal',
  `contenu` longtext NOT NULL,
  `path` varchar(255) NOT NULL,
  `criteres` text NOT NULL,
  `cache_this` tinyint(1) NOT NULL default '0',
  `locked` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `reference` (`reference`),
  UNIQUE KEY `accesskey` (`accesskey`),
  KEY `ref_langue` (`ref_langue`),
  CONSTRAINT `pages_ibfk_1` FOREIGN KEY (`ref_langue`) REFERENCES `langues` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages`
--

LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` VALUES (1,5,'2006-12-16 12:08:14','index','publique','...','','1',NULL,'...','','dynamique','none','','index.php','',0,1),(5,5,'2006-12-16 12:04:25','info','publique','...','',NULL,NULL,'...','','statique','normal','','','',0,0);
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rewriting`
--

DROP TABLE IF EXISTS `rewriting`;
CREATE TABLE `rewriting` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `ref_portail` tinyint(3) unsigned NOT NULL,
  `ref_rewrite` mediumint(8) unsigned default NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  `path` varchar(255) NOT NULL,
  `ref_page` mediumint(8) unsigned default NULL,
  `ref_arborescence` mediumint(8) unsigned default NULL,
  `args` text NOT NULL,
  `cache_file` varchar(255) NOT NULL,
  `date_cache` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`ref_portail`,`path`),
  KEY `ref_portail` (`ref_portail`),
  KEY `ref_rewrite` (`ref_rewrite`),
  KEY `ref_page` (`ref_page`),
  KEY `ref_arborescence` (`ref_arborescence`),
  CONSTRAINT `rewriting_ibfk_11` FOREIGN KEY (`ref_portail`) REFERENCES `portails` (`id`),
  CONSTRAINT `rewriting_ibfk_12` FOREIGN KEY (`ref_rewrite`) REFERENCES `rewriting` (`id`) ON DELETE CASCADE,
  CONSTRAINT `rewriting_ibfk_13` FOREIGN KEY (`ref_page`) REFERENCES `pages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `rewriting_ibfk_14` FOREIGN KEY (`ref_arborescence`) REFERENCES `arborescence` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rewriting`
--

LOCK TABLES `rewriting` WRITE;
/*!40000 ALTER TABLE `rewriting` DISABLE KEYS */;
INSERT INTO `rewriting` VALUES (1,2,NULL,0,'/',1,NULL,'','',NULL);
/*!40000 ALTER TABLE `rewriting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `traductions`
--

DROP TABLE IF EXISTS `traductions`;
CREATE TABLE `traductions` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `label_table` varchar(255) NOT NULL,
  `label_champ` varchar(255) NOT NULL,
  `ref` mediumint(8) unsigned NOT NULL,
  `ref_langue` tinyint(3) unsigned NOT NULL,
  `texte` text NOT NULL,
  `texte_clean` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `label_table` (`label_table`),
  KEY `label_champ` (`label_champ`),
  KEY `ref` (`ref`),
  KEY `ref_langue` (`ref_langue`),
  CONSTRAINT `traductions_ibfk_1` FOREIGN KEY (`ref_langue`) REFERENCES `langues` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `traductions`
--

LOCK TABLES `traductions` WRITE;
/*!40000 ALTER TABLE `traductions` DISABLE KEYS */;
/*!40000 ALTER TABLE `traductions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Final view structure for view `__vue_arborescence_fr`
--

/*!50001 DROP TABLE IF EXISTS `__vue_arborescence_fr`*/;
/*!50001 DROP VIEW IF EXISTS `__vue_arborescence_fr`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `__vue_arborescence_fr` AS select `arborescence`.`id` AS `id`,`arborescence`.`ref_arborescence` AS `ref_arborescence`,`arborescence`.`ref_arborescence_redir` AS `ref_arborescence_redir`,`arborescence`.`ref_portail` AS `ref_portail`,`arborescence`.`ref_page` AS `ref_page`,`arborescence`.`ordre` AS `ordre`,`arborescence`.`profil` AS `profil`,`arborescence`.`root` AS `root`,`arborescence`.`position` AS `position`,`arborescence`.`visible_menu` AS `visible_menu`,`arborescence`.`visible_plan` AS `visible_plan`,if((`traduc1`.`texte` is not null),`traduc1`.`texte`,`arborescence`.`titre`) AS `titre`,if((`traduc2`.`texte` is not null),`traduc2`.`texte`,`arborescence`.`titre_rewriting`) AS `titre_rewriting` from ((`arborescence` left join `traductions` `traduc1` on(((`traduc1`.`label_table` = _utf8'arborescence') and (`traduc1`.`label_champ` = _utf8'titre') and (`traduc1`.`ref` = `arborescence`.`id`) and (`traduc1`.`ref_langue` = _utf8'5')))) left join `traductions` `traduc2` on(((`traduc2`.`label_table` = _utf8'arborescence') and (`traduc2`.`label_champ` = _utf8'titre_rewriting') and (`traduc2`.`ref` = `arborescence`.`id`) and (`traduc2`.`ref_langue` = _utf8'5')))) */;

--
-- Final view structure for view `__vue_pages_fr`
--

/*!50001 DROP TABLE IF EXISTS `__vue_pages_fr`*/;
/*!50001 DROP VIEW IF EXISTS `__vue_pages_fr`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `__vue_pages_fr` AS select `pages`.`id` AS `id`,`pages`.`date_modification` AS `date_modification`,`pages`.`reference` AS `reference`,`pages`.`profil` AS `profil`,`pages`.`description` AS `description`,`pages`.`accesskey` AS `accesskey`,`pages`.`rel` AS `rel`,`pages`.`type` AS `type`,`pages`.`design` AS `design`,`pages`.`path` AS `path`,`pages`.`criteres` AS `criteres`,`pages`.`cache_this` AS `cache_this`,`pages`.`locked` AS `locked`,if((`traduc1`.`texte` is not null),`traduc1`.`texte`,`pages`.`titre`) AS `titre`,if((`traduc1`.`texte` is not null),`traduc1`.`ref_langue`,`pages`.`ref_langue`) AS `ref_langue`,if((`traduc2`.`texte` is not null),`traduc2`.`texte`,`pages`.`meta_description`) AS `meta_description`,if((`traduc3`.`texte` is not null),`traduc3`.`texte`,`pages`.`meta_mots_cles`) AS `meta_mots_cles`,if((`traduc4`.`texte` is not null),`traduc4`.`texte`,`pages`.`contenu`) AS `contenu` from ((((`pages` left join `traductions` `traduc1` on(((`traduc1`.`label_table` = _utf8'pages') and (`traduc1`.`label_champ` = _utf8'titre') and (`traduc1`.`ref` = `pages`.`id`) and (`traduc1`.`ref_langue` = _utf8'5')))) left join `traductions` `traduc2` on(((`traduc2`.`label_table` = _utf8'pages') and (`traduc2`.`label_champ` = _utf8'meta_description') and (`traduc2`.`ref` = `pages`.`id`) and (`traduc2`.`ref_langue` = _utf8'5')))) left join `traductions` `traduc3` on(((`traduc3`.`label_table` = _utf8'pages') and (`traduc3`.`label_champ` = _utf8'meta_mots_cles') and (`traduc3`.`ref` = `pages`.`id`) and (`traduc3`.`ref_langue` = _utf8'5')))) left join `traductions` `traduc4` on(((`traduc4`.`label_table` = _utf8'pages') and (`traduc4`.`label_champ` = _utf8'contenu') and (`traduc4`.`ref` = `pages`.`id`) and (`traduc4`.`ref_langue` = _utf8'5')))) */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2006-12-16 12:08:56