reorganisation des dossiers

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

diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql
new file mode 100644 (file)
index 0000000..79d3c80
--- /dev/null
+++ b/content/data/mysql/mtweb.sql
@@ -0,0 +1,108 @@
+-- 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);