1 -- phpMyAdmin SQL Dump
\r
2 -- version 3.3.2deb1ubuntu1
\r
3 -- http://www.phpmyadmin.net
\r
5 -- Serveur: localhost
\r
6 -- Généré le : Mer 13 Février 2013 à 23:03
\r
7 -- Version du serveur: 5.1.67
\r
8 -- Version de PHP: 5.3.2-1ubuntu4.18
\r
10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
\r
13 -- Base de données: `mtweb`
\r
16 -- --------------------------------------------------------
\r
19 -- Structure de la table `mw_action_status`
\r
22 CREATE TABLE IF NOT EXISTS `mw_actions_roles` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `action` varchar(255) NOT NULL,
25 `id_role` int(11) NOT NULL,
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
30 -- Contenu de la table `mw_actions_roles`
33 INSERT INTO `mw_actions_roles` (`id`, `action`, `id_role`) VALUES
36 (15, 'users/identification', 0);
38 -- --------------------------------------------------------
\r
41 -- Structure de la table `mw_config`
\r
44 CREATE TABLE IF NOT EXISTS `mw_config` (
\r
45 `id` int(11) NOT NULL AUTO_INCREMENT,
\r
46 `key` varchar(255) NOT NULL,
\r
47 `value` text NOT NULL,
\r
49 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
\r
52 -- Contenu de la table `mw_config`
\r
55 INSERT INTO `mw_config` (`id`, `key`, `value`) VALUES
\r
56 (1, 'site_name', 'mtweb'),
\r
57 (2, 'max_list', '10'),
\r
58 (3, 'description', ''),
\r
59 (4, 'out', 'default'),
\r
60 (5, 'start_action', ''),
\r
61 (6, 'contact_form', '0'),
\r
63 (9, 'captcha', '0'),
\r
64 (29, 'default_allow', '1'),
\r
65 (22, 'out_colonne', 'on'),
\r
66 (16, 'start_action_params', ''),
\r
67 (20, 'out_navig_menu_top', 'on');
\r
69 -- --------------------------------------------------------
\r
72 -- Structure de la table `mw_roles`
\r
75 CREATE TABLE IF NOT EXISTS `mw_roles` (
\r
76 `id` int(11) NOT NULL AUTO_INCREMENT,
\r
77 `nom` varchar(255) NOT NULL,
\r
78 `intitule` varchar(255) NOT NULL,
\r
80 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
\r
83 -- Contenu de la table `mw_roles`
\r
86 INSERT INTO `mw_roles` (`id`, `nom`, `intitule`) VALUES
\r
87 (1, 'admin', 'administrateur'),
\r
88 (2, 'membre', 'membre');
\r
90 -- --------------------------------------------------------
\r
93 -- Structure de la table `mw_users`
\r
96 CREATE TABLE IF NOT EXISTS `mw_users` (
\r
97 `id` int(11) NOT NULL AUTO_INCREMENT,
\r
98 `login` varchar(255) NOT NULL,
\r
99 `password` varchar(255) NOT NULL,
\r
100 `email` varchar(255) NOT NULL,
\r
102 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
\r
105 -- Contenu de la table `mw_users`
\r
108 INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES
\r
109 (17, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld');
\r
111 -- --------------------------------------------------------
\r
114 -- Structure de la table `mw_users_roles`
\r
117 CREATE TABLE IF NOT EXISTS `mw_users_roles` (
\r
118 `id_user` int(11) NOT NULL,
\r
119 `id_role` int(11) NOT NULL,
\r
120 PRIMARY KEY (`id_user`,`id_role`)
\r
121 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\r
124 -- Contenu de la table `mw_users_roles`
\r
127 INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES
\r