ajout d'un installeur en ligne

[mtweb] / content / data / mysql / mtweb.sql

diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql
deleted file mode 100644 (file)
index 0151c51..0000000
--- a/content/data/mysql/mtweb.sql
+++ /dev/null
@@ -1,153 +0,0 @@
--- phpMyAdmin SQL Dump\r
--- version 3.3.2deb1ubuntu1\r
--- http://www.phpmyadmin.net\r
---\r
--- Serveur: localhost\r
--- Généré le : Dim 26 Mai 2013 à 15:46\r
--- Version du serveur: 5.1.69\r
--- Version de PHP: 5.3.2-1ubuntu4.19\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_actions_roles`\r
---\r
-\r
-CREATE TABLE IF NOT EXISTS `mw_actions_roles` (\r
-  `id` int(11) NOT NULL AUTO_INCREMENT,\r
-  `action` varchar(255) NOT NULL,\r
-  `id_role` int(11) NOT NULL,\r
-  PRIMARY KEY (`id`),\r
-  KEY `id_role` (`id_role`)\r
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;\r
-\r
---\r
--- Contenu de la table `mw_actions_roles`\r
---\r
-\r
-INSERT INTO `mw_actions_roles` (`id`, `action`, `id_role`) VALUES\r
-(13, 'admin', 1),\r
-(14, 'users', 2),\r
-(19, 'users/identification', 0),\r
-(20, 'config', 3);\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=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;\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
-(16, 'start_action_params', ''),\r
-(20, 'out_navig_menu_top', 'on'),\r
-(22, 'out_colonne', 'on'),\r
-(29, 'default_allow', '1');\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
-  KEY `id` (`id`)\r
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;\r
-\r
---\r
--- Contenu de la table `mw_roles`\r
---\r
-\r
-INSERT INTO `mw_roles` (`id`, `nom`, `intitule`) VALUES\r
-(0, 'guest', 'invité'),\r
-(1, 'admin', 'administrateur'),\r
-(2, 'membre', 'membre'),\r
-(3, 'webmaster', 'webmaster');\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=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;\r
-\r
---\r
--- Contenu de la table `mw_users`\r
---\r
-\r
-INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES\r
-(19, '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
-  KEY `id_role` (`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
-(19, 1),\r
-(19, 2),\r
-(19, 3);\r
-\r
---\r
--- Contraintes pour les tables exportées\r
---
--- DECOMMENTER POUR AJOUTER LES CONTRAINTES\r
-\r
---\r
--- Contraintes pour la table `mw_actions_roles`\r
---\r
--- ALTER TABLE `mw_actions_roles`\r
---   ADD CONSTRAINT `mw_actions_roles_ibfk_1` FOREIGN KEY (`id_role`) REFERENCES `mw_roles` (`id`);\r
-\r
---\r
--- Contraintes pour la table `mw_users_roles`\r
---\r
--- ALTER TABLE `mw_users_roles`\r
---   ADD CONSTRAINT `mw_users_roles_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `mw_users` (`id`),\r
---   ADD CONSTRAINT `mw_users_roles_ibfk_2` FOREIGN KEY (`id_role`) REFERENCES `mw_roles` (`id`);\r