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 : Dim 26 Mai 2013 à 15:46
\r
7 -- Version du serveur: 5.1.69
\r
8 -- Version de PHP: 5.3.2-1ubuntu4.19
\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_actions_roles`
\r
22 CREATE TABLE IF NOT EXISTS `mw_actions_roles` (
\r
23 `id` int(11) NOT NULL AUTO_INCREMENT,
\r
24 `action` varchar(255) NOT NULL,
\r
25 `id_role` int(11) NOT NULL,
\r
27 KEY `id_role` (`id_role`)
\r
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
\r
31 -- Contenu de la table `mw_actions_roles`
\r
34 INSERT INTO `mw_actions_roles` (`id`, `action`, `id_role`) VALUES
\r
37 (19, 'users/identification', 0),
\r
40 -- --------------------------------------------------------
\r
43 -- Structure de la table `mw_config`
\r
46 CREATE TABLE IF NOT EXISTS `mw_config` (
\r
47 `id` int(11) NOT NULL AUTO_INCREMENT,
\r
48 `key` varchar(255) NOT NULL,
\r
49 `value` text NOT NULL,
\r
51 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;
\r
54 -- Contenu de la table `mw_config`
\r
57 INSERT INTO `mw_config` (`id`, `key`, `value`) VALUES
\r
58 (1, 'site_name', 'mtweb'),
\r
59 (2, 'max_list', '10'),
\r
60 (3, 'description', ''),
\r
61 (4, 'out', 'default'),
\r
62 (5, 'start_action', ''),
\r
63 (6, 'contact_form', '0'),
\r
65 (9, 'captcha', '0'),
\r
66 (16, 'start_action_params', ''),
\r
67 (20, 'out_navig_menu_top', 'on'),
\r
68 (22, 'out_colonne', 'on'),
\r
69 (29, 'default_allow', '1'),
\r
70 (30, 'cache_actif', '0'),
\r
71 (31, 'cache_maj_auto', '0'),
\r
72 (32, 'cache_time', '72');
\r
74 -- --------------------------------------------------------
\r
77 -- Structure de la table `mw_roles`
\r
80 CREATE TABLE IF NOT EXISTS `mw_roles` (
\r
81 `id` int(11) NOT NULL AUTO_INCREMENT,
\r
82 `nom` varchar(255) NOT NULL,
\r
83 `intitule` varchar(255) NOT NULL,
\r
85 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
\r
88 -- Contenu de la table `mw_roles`
\r
91 INSERT INTO `mw_roles` (`id`, `nom`, `intitule`) VALUES
\r
92 (0, 'guest', 'invité'),
\r
93 (1, 'admin', 'administrateur'),
\r
94 (2, 'membre', 'membre'),
\r
95 (3, 'webmaster', 'webmaster');
\r
97 -- --------------------------------------------------------
\r
100 -- Structure de la table `mw_users`
\r
103 CREATE TABLE IF NOT EXISTS `mw_users` (
\r
104 `id` int(11) NOT NULL AUTO_INCREMENT,
\r
105 `login` varchar(255) NOT NULL,
\r
106 `password` varchar(255) NOT NULL,
\r
107 `email` varchar(255) NOT NULL,
\r
109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
\r
112 -- Contenu de la table `mw_users`
\r
115 INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES
\r
116 (19, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld');
\r
118 -- --------------------------------------------------------
\r
121 -- Structure de la table `mw_users_roles`
\r
124 CREATE TABLE IF NOT EXISTS `mw_users_roles` (
\r
125 `id_user` int(11) NOT NULL,
\r
126 `id_role` int(11) NOT NULL,
\r
127 PRIMARY KEY (`id_user`,`id_role`),
\r
128 KEY `id_role` (`id_role`)
\r
129 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\r
132 -- Contenu de la table `mw_users_roles`
\r
135 INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES
\r
141 -- Contraintes pour les tables exportées
\r
143 -- DECOMMENTER POUR AJOUTER LES CONTRAINTES
\r
146 -- Contraintes pour la table `mw_actions_roles`
\r
148 -- ALTER TABLE `mw_actions_roles`
\r
149 -- ADD CONSTRAINT `mw_actions_roles_ibfk_1` FOREIGN KEY (`id_role`) REFERENCES `mw_roles` (`id`);
\r
152 -- Contraintes pour la table `mw_users_roles`
\r
154 -- ALTER TABLE `mw_users_roles`
\r
155 -- ADD CONSTRAINT `mw_users_roles_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `mw_users` (`id`),
\r
156 -- ADD CONSTRAINT `mw_users_roles_ibfk_2` FOREIGN KEY (`id_role`) REFERENCES `mw_roles` (`id`);
\r