X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=content%2Fdata%2Fmysql%2Fmtweb.sql;fp=content%2Fdata%2Fmysql%2Fmtweb.sql;h=0000000000000000000000000000000000000000;hb=0ada6496e6c552c473a5816734b38896ccdd345b;hp=0151c510c66869539f843afc5f0720739f8a691b;hpb=c8731e3a31f51a93cfff9fe7206dd6fb007bc733;p=mtweb

diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql
deleted file mode 100644
index 0151c51..0000000
--- a/content/data/mysql/mtweb.sql
+++ /dev/null
@@ -1,153 +0,0 @@
--- 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');
-
--- --------------------------------------------------------
-
---
--- 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`);