X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=content%2Fdata%2Fmysql%2Fmtweb.sql;h=982650c6b47ef7f73bc5cc392c6e33d26cf9dbc4;hb=e1b64e4088232b9d7b4acb2dc24279bb38fcafba;hp=79d3c80c68d347ea77f49985bd84fbf373a3b0d1;hpb=36ed114046cbe3d72a3589230e9f306a54fcc79d;p=mtweb diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql index 79d3c80..982650c 100644 --- a/content/data/mysql/mtweb.sql +++ b/content/data/mysql/mtweb.sql @@ -1,108 +1,156 @@ --- 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 : 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"; + +-- +-- Base de données: `mtweb` +-- + +-- -------------------------------------------------------- + +-- +-- 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`), + 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); + +-- -------------------------------------------------------- + +-- +-- 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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ; + +-- +-- 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'), +(16, 'start_action_params', ''), +(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'); + +-- -------------------------------------------------------- + +-- +-- 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, + 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'), +(3, 'webmaster', 'webmaster'); + +-- -------------------------------------------------------- + +-- +-- 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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ; + +-- +-- Contenu de la table `mw_users` +-- + +INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES +(19, '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`), + KEY `id_role` (`id_role`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Contenu de la table `mw_users_roles` +-- + +INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES +(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`);