nouveau SQL import / maj donnees XML

[mtweb] / content / data / mysql / mtweb.sql

diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql
index 368c36c..982650c 100644 (file)
--- a/content/data/mysql/mtweb.sql
+++ b/content/data/mysql/mtweb.sql
@@ -3,9 +3,9 @@
 -- http://www.phpmyadmin.net\r
 --\r
 -- Serveur: localhost\r
--- Généré le : Mer 13 Février 2013 à 23:03\r
--- Version du serveur: 5.1.67\r
--- Version de PHP: 5.3.2-1ubuntu4.18\r
+-- Généré le : Dim 26 Mai 2013 à 15:46\r
+-- Version du serveur: 5.1.69\r
+-- Version de PHP: 5.3.2-1ubuntu4.19\r
 \r
 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";\r
 \r
@@ -16,24 +16,26 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 -- --------------------------------------------------------\r
 \r
 --\r
--- Structure de la table `mw_action_status`\r
+-- Structure de la table `mw_actions_roles`\r
 --\r
 \r
-CREATE TABLE IF NOT EXISTS `mw_actions_roles` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `action` varchar(255) NOT NULL,
-  `id_role` int(11) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
-
---
--- Contenu de la table `mw_actions_roles`
---
-
-INSERT INTO `mw_actions_roles` (`id`, `action`, `id_role`) VALUES
-(13, 'admin', 1),
-(14, 'users', 2),
-(15, 'users/identification', 0);
+CREATE TABLE IF NOT EXISTS `mw_actions_roles` (\r
+  `id` int(11) NOT NULL AUTO_INCREMENT,\r
+  `action` varchar(255) NOT NULL,\r
+  `id_role` int(11) NOT NULL,\r
+  PRIMARY KEY (`id`),\r
+  KEY `id_role` (`id_role`)\r
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;\r
+\r
+--\r
+-- Contenu de la table `mw_actions_roles`\r
+--\r
+\r
+INSERT INTO `mw_actions_roles` (`id`, `action`, `id_role`) VALUES\r
+(13, 'admin', 1),\r
+(14, 'users', 2),\r
+(19, 'users/identification', 0),\r
+(20, 'config', 3);\r
 \r
 -- --------------------------------------------------------\r
 \r
@@ -46,7 +48,7 @@ CREATE TABLE IF NOT EXISTS `mw_config` (
   `key` varchar(255) NOT NULL,\r
   `value` text NOT NULL,\r
   PRIMARY KEY (`id`)\r
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;\r
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;\r
 \r
 --\r
 -- Contenu de la table `mw_config`\r
@@ -61,10 +63,13 @@ INSERT INTO `mw_config` (`id`, `key`, `value`) VALUES
 (6, 'contact_form', '0'),\r
 (8, 'email', ''),\r
 (9, 'captcha', '0'),\r
-(29, 'default_allow', '1'),\r
-(22, 'out_colonne', 'on'),\r
 (16, 'start_action_params', ''),\r
-(20, 'out_navig_menu_top', 'on');\r
+(20, 'out_navig_menu_top', 'on'),\r
+(22, 'out_colonne', 'on'),\r
+(29, 'default_allow', '1'),\r
+(30, 'cache_actif', '0'),\r
+(31, 'cache_maj_auto', '0'),\r
+(32, 'cache_time', '72');\r
 \r
 -- --------------------------------------------------------\r
 \r
@@ -76,16 +81,18 @@ CREATE TABLE IF NOT EXISTS `mw_roles` (
   `id` int(11) NOT NULL AUTO_INCREMENT,\r
   `nom` varchar(255) NOT NULL,\r
   `intitule` varchar(255) NOT NULL,\r
-  PRIMARY KEY (`id`)\r
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;\r
+  KEY `id` (`id`)\r
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;\r
 \r
 --\r
 -- Contenu de la table `mw_roles`\r
 --\r
 \r
 INSERT INTO `mw_roles` (`id`, `nom`, `intitule`) VALUES\r
+(0, 'guest', 'invité'),\r
 (1, 'admin', 'administrateur'),\r
-(2, 'membre', 'membre');\r
+(2, 'membre', 'membre'),\r
+(3, 'webmaster', 'webmaster');\r
 \r
 -- --------------------------------------------------------\r
 \r
@@ -99,14 +106,14 @@ CREATE TABLE IF NOT EXISTS `mw_users` (
   `password` varchar(255) NOT NULL,\r
   `email` varchar(255) NOT NULL,\r
   PRIMARY KEY (`id`)\r
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;\r
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;\r
 \r
 --\r
 -- Contenu de la table `mw_users`\r
 --\r
 \r
 INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES\r
-(17, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld');\r
+(19, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld');\r
 \r
 -- --------------------------------------------------------\r
 \r
@@ -117,7 +124,8 @@ INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES
 CREATE TABLE IF NOT EXISTS `mw_users_roles` (\r
   `id_user` int(11) NOT NULL,\r
   `id_role` int(11) NOT NULL,\r
-  PRIMARY KEY (`id_user`,`id_role`)\r
+  PRIMARY KEY (`id_user`,`id_role`),\r
+  KEY `id_role` (`id_role`)\r
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r
 \r
 --\r
@@ -125,5 +133,24 @@ CREATE TABLE IF NOT EXISTS `mw_users_roles` (
 --\r
 \r
 INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES\r
-(17, 1),\r
-(17, 2);\r
+(19, 1),\r
+(19, 2),\r
+(19, 3);\r
+\r
+--\r
+-- Contraintes pour les tables exportées\r
+--
+-- DECOMMENTER POUR AJOUTER LES CONTRAINTES\r
+\r
+--\r
+-- Contraintes pour la table `mw_actions_roles`\r
+--\r
+-- ALTER TABLE `mw_actions_roles`\r
+--   ADD CONSTRAINT `mw_actions_roles_ibfk_1` FOREIGN KEY (`id_role`) REFERENCES `mw_roles` (`id`);\r
+\r
+--\r
+-- Contraintes pour la table `mw_users_roles`\r
+--\r
+-- ALTER TABLE `mw_users_roles`\r
+--   ADD CONSTRAINT `mw_users_roles_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `mw_users` (`id`),\r
+--   ADD CONSTRAINT `mw_users_roles_ibfk_2` FOREIGN KEY (`id_role`) REFERENCES `mw_roles` (`id`);\r