X-Git-Url: http://git.dj3c1t.com/index.cgi?a=blobdiff_plain;f=content%2Fdata%2Fmysql%2Fmtweb.sql;fp=content%2Fdata%2Fmysql%2Fmtweb.sql;h=dfc90689272baa8dcc044b12d29f9372ba31bd45;hb=3c17f81e1d2fb68f69cfa620ca00ad63e83cc17c;hp=79d3c80c68d347ea77f49985bd84fbf373a3b0d1;hpb=44c1abaa9a140edaeee8e30dcc557214b9f00903;p=mtweb

diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql
index 79d3c80..dfc9068 100644
--- a/content/data/mysql/mtweb.sql
+++ b/content/data/mysql/mtweb.sql
@@ -1,108 +1,129 @@
--- phpMyAdmin SQL Dump
--- version 3.3.2deb1
--- http://www.phpmyadmin.net
---
--- Serveur: localhost
--- Généré le : Dim 25 Décembre 2011 à 15:01
--- Version du serveur: 5.1.41
--- Version de PHP: 5.3.2-1ubuntu4.11
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-
---
--- Base de données: `mtweb`
---
-
--- --------------------------------------------------------
-
---
--- Structure de la table `mw_action_status`
---
-
-CREATE TABLE IF NOT EXISTS `mw_action_status` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `action` varchar(255) NOT NULL,
-  `id_status` int(11) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
-
---
--- Contenu de la table `mw_action_status`
---
-
-INSERT INTO `mw_action_status` (`id`, `action`, `id_status`) VALUES
-(1, 'admin', 1),
-(2, 'users', 1),
-(3, 'users', 2),
-(4, 'users/identification', 0);
-
--- --------------------------------------------------------
-
---
--- Structure de la table `mw_config`
---
-
-CREATE TABLE IF NOT EXISTS `mw_config` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `key` varchar(255) NOT NULL,
-  `value` text NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
-
---
--- Contenu de la table `mw_config`
---
-
-INSERT INTO `mw_config` (`id`, `key`, `value`) VALUES
-(1, 'site_name', 'mtweb'),
-(2, 'max_list', '10'),
-(3, 'description', ''),
-(4, 'out', 'dist'),
-(5, 'start_action', ''),
-(6, 'contact_form', '0'),
-(8, 'email', ''),
-(9, 'captcha', '0'),
-(16, 'start_action_params', '');
-
--- --------------------------------------------------------
-
---
--- Structure de la table `mw_users`
---
-
-CREATE TABLE IF NOT EXISTS `mw_users` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `login` varchar(255) NOT NULL,
-  `password` varchar(255) NOT NULL,
-  `email` varchar(255) NOT NULL,
-  `status` int(11) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
-
---
--- Contenu de la table `mw_users`
---
-
-INSERT INTO `mw_users` (`id`, `login`, `password`, `email`, `status`) VALUES
-(1, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld', 1);
-
--- --------------------------------------------------------
-
---
--- Structure de la table `mw_user_status`
---
-
-CREATE TABLE IF NOT EXISTS `mw_user_status` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `nom` varchar(255) NOT NULL,
-  `creation_default` tinyint(4) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-
---
--- Contenu de la table `mw_user_status`
---
-
-INSERT INTO `mw_user_status` (`id`, `nom`, `creation_default`) VALUES
-(1, 'admin', 0),
-(2, 'membre', 1);
+-- phpMyAdmin SQL Dump
+-- version 3.3.2deb1ubuntu1
+-- 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
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+--
+-- Base de données: `mtweb`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `mw_action_status`
+--
+
+CREATE TABLE IF NOT EXISTS `mw_action_status` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `action` varchar(255) NOT NULL,
+  `id_status` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;
+
+--
+-- Contenu de la table `mw_action_status`
+--
+
+INSERT INTO `mw_action_status` (`id`, `action`, `id_status`) VALUES
+(115, 'users/identification', 0),
+(111, 'users', 2),
+(113, 'admin', 1);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `mw_config`
+--
+
+CREATE TABLE IF NOT EXISTS `mw_config` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `key` varchar(255) NOT NULL,
+  `value` text NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
+
+--
+-- Contenu de la table `mw_config`
+--
+
+INSERT INTO `mw_config` (`id`, `key`, `value`) VALUES
+(1, 'site_name', 'mtweb'),
+(2, 'max_list', '10'),
+(3, 'description', ''),
+(4, 'out', 'default'),
+(5, 'start_action', ''),
+(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');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `mw_roles`
+--
+
+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 ;
+
+--
+-- Contenu de la table `mw_roles`
+--
+
+INSERT INTO `mw_roles` (`id`, `nom`, `intitule`) VALUES
+(1, 'admin', 'administrateur'),
+(2, 'membre', 'membre');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `mw_users`
+--
+
+CREATE TABLE IF NOT EXISTS `mw_users` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `login` varchar(255) NOT NULL,
+  `password` varchar(255) NOT NULL,
+  `email` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
+
+--
+-- Contenu de la table `mw_users`
+--
+
+INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES
+(17, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `mw_users_roles`
+--
+
+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`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `mw_users_roles`
+--
+
+INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES
+(17, 1),
+(17, 2);