X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=content%2Fdata%2Fmysql%2Fmtweb.sql;fp=content%2Fdata%2Fmysql%2Fmtweb.sql;h=982650c6b47ef7f73bc5cc392c6e33d26cf9dbc4;hb=e1b64e4088232b9d7b4acb2dc24279bb38fcafba;hp=368c36c57b3632526f515975bec9d6b5b22d4dfe;hpb=5dfe5e84a7007ddd9737707ce15f0155e6415066;p=mtweb

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