--- 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\r
+-- version 3.3.2deb1ubuntu1\r
+-- 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
+\r
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";\r
+\r
+--\r
+-- Base de données: `mtweb`\r
+--\r
+\r
+-- --------------------------------------------------------\r
+\r
+--\r
+-- Structure de la table `mw_action_status`\r
+--\r
+\r
+CREATE TABLE IF NOT EXISTS `mw_action_status` (\r
+ `id` int(11) NOT NULL AUTO_INCREMENT,\r
+ `action` varchar(255) NOT NULL,\r
+ `id_status` int(11) NOT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;\r
+\r
+--\r
+-- Contenu de la table `mw_action_status`\r
+--\r
+\r
+INSERT INTO `mw_action_status` (`id`, `action`, `id_status`) VALUES\r
+(115, 'users/identification', 0),\r
+(111, 'users', 2),\r
+(113, 'admin', 1);\r
+\r
+-- --------------------------------------------------------\r
+\r
+--\r
+-- Structure de la table `mw_config`\r
+--\r
+\r
+CREATE TABLE IF NOT EXISTS `mw_config` (\r
+ `id` int(11) NOT NULL AUTO_INCREMENT,\r
+ `key` varchar(255) NOT NULL,\r
+ `value` text NOT NULL,\r
+ PRIMARY KEY (`id`)\r
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;\r
+\r
+--\r
+-- Contenu de la table `mw_config`\r
+--\r
+\r
+INSERT INTO `mw_config` (`id`, `key`, `value`) VALUES\r
+(1, 'site_name', 'mtweb'),\r
+(2, 'max_list', '10'),\r
+(3, 'description', ''),\r
+(4, 'out', 'default'),\r
+(5, 'start_action', ''),\r
+(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
+\r
+-- --------------------------------------------------------\r
+\r
+--\r
+-- Structure de la table `mw_roles`\r
+--\r
+\r
+CREATE TABLE IF NOT EXISTS `mw_roles` (\r
+ `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
+\r
+--\r
+-- Contenu de la table `mw_roles`\r
+--\r
+\r
+INSERT INTO `mw_roles` (`id`, `nom`, `intitule`) VALUES\r
+(1, 'admin', 'administrateur'),\r
+(2, 'membre', 'membre');\r
+\r
+-- --------------------------------------------------------\r
+\r
+--\r
+-- Structure de la table `mw_users`\r
+--\r
+\r
+CREATE TABLE IF NOT EXISTS `mw_users` (\r
+ `id` int(11) NOT NULL AUTO_INCREMENT,\r
+ `login` varchar(255) NOT NULL,\r
+ `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
+\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
+\r
+-- --------------------------------------------------------\r
+\r
+--\r
+-- Structure de la table `mw_users_roles`\r
+--\r
+\r
+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
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r
+\r
+--\r
+-- Contenu de la table `mw_users_roles`\r
+--\r
+\r
+INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES\r
+(17, 1),\r
+(17, 2);\r
projects / mtweb / blobdiff