projects
/
mtweb
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
nouveau SQL import / maj donnees XML
[mtweb]
/
content
/
data
/
mysql
/
mtweb.sql
diff --git
a/content/data/mysql/mtweb.sql
b/content/data/mysql/mtweb.sql
index
368c36c
..
982650c
100644
(file)
--- a/
content/data/mysql/mtweb.sql
+++ b/
content/data/mysql/mtweb.sql
@@
-3,9
+3,9
@@
-- http://www.phpmyadmin.net
\r
--
\r
-- Serveur: localhost
\r
-- http://www.phpmyadmin.net
\r
--
\r
-- Serveur: localhost
\r
--- Généré le :
Mer 13 Février 2013 à 23:03
\r
--- Version du serveur: 5.1.6
7
\r
--- Version de PHP: 5.3.2-1ubuntu4.1
8
\r
+-- Généré le :
Dim 26 Mai 2013 à 15:46
\r
+-- Version du serveur: 5.1.6
9
\r
+-- Version de PHP: 5.3.2-1ubuntu4.1
9
\r
\r
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
\r
\r
\r
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
\r
\r
@@
-16,24
+16,26
@@
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- --------------------------------------------------------
\r
\r
--
\r
-- --------------------------------------------------------
\r
\r
--
\r
--- Structure de la table `mw_action
_statu
s`
\r
+-- Structure de la table `mw_action
s_role
s`
\r
--
\r
\r
--
\r
\r
-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`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
-
---
--- Contenu de la table `mw_actions_roles`
---
-
-INSERT INTO `mw_actions_roles` (`id`, `action`, `id_role`) VALUES
-(13, 'admin', 1),
-(14, 'users', 2),
-(15, 'users/identification', 0);
+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
-- --------------------------------------------------------
\r
\r
@@
-46,7
+48,7
@@
CREATE TABLE IF NOT EXISTS `mw_config` (
`key` varchar(255) NOT NULL,
\r
`value` text NOT NULL,
\r
PRIMARY KEY (`id`)
\r
`key` varchar(255) NOT NULL,
\r
`value` text NOT NULL,
\r
PRIMARY KEY (`id`)
\r
-) ENGINE=
MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30
;
\r
+) ENGINE=
InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=38
;
\r
\r
--
\r
-- Contenu de la table `mw_config`
\r
\r
--
\r
-- Contenu de la table `mw_config`
\r
@@
-61,10
+63,13
@@
INSERT INTO `mw_config` (`id`, `key`, `value`) VALUES
(6, 'contact_form', '0'),
\r
(8, 'email', ''),
\r
(9, 'captcha', '0'),
\r
(6, 'contact_form', '0'),
\r
(8, 'email', ''),
\r
(9, 'captcha', '0'),
\r
-(29, 'default_allow', '1'),
\r
-(22, 'out_colonne', 'on'),
\r
(16, 'start_action_params', ''),
\r
(16, 'start_action_params', ''),
\r
-(20, 'out_navig_menu_top', 'on');
\r
+(20, 'out_navig_menu_top', 'on'),
\r
+(22, 'out_colonne', 'on'),
\r
+(29, 'default_allow', '1'),
\r
+(30, 'cache_actif', '0'),
\r
+(31, 'cache_maj_auto', '0'),
\r
+(32, 'cache_time', '72');
\r
\r
-- --------------------------------------------------------
\r
\r
\r
-- --------------------------------------------------------
\r
\r
@@
-76,16
+81,18
@@
CREATE TABLE IF NOT EXISTS `mw_roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
\r
`nom` varchar(255) NOT NULL,
\r
`intitule` varchar(255) NOT NULL,
\r
`id` int(11) NOT NULL AUTO_INCREMENT,
\r
`nom` varchar(255) NOT NULL,
\r
`intitule` varchar(255) NOT NULL,
\r
-
PRIMARY KEY
(`id`)
\r
-) ENGINE=
MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8
;
\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
\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
(1, 'admin', 'administrateur'),
\r
-(2, 'membre', 'membre');
\r
+(2, 'membre', 'membre'),
\r
+(3, 'webmaster', 'webmaster');
\r
\r
-- --------------------------------------------------------
\r
\r
\r
-- --------------------------------------------------------
\r
\r
@@
-99,14
+106,14
@@
CREATE TABLE IF NOT EXISTS `mw_users` (
`password` varchar(255) NOT NULL,
\r
`email` varchar(255) NOT NULL,
\r
PRIMARY KEY (`id`)
\r
`password` varchar(255) NOT NULL,
\r
`email` varchar(255) NOT NULL,
\r
PRIMARY KEY (`id`)
\r
-) ENGINE=
MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18
;
\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
\r
--
\r
-- Contenu de la table `mw_users`
\r
--
\r
\r
INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES
\r
-(1
7
, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld');
\r
+(1
9
, 'admin', '25e4ee4e9229397b6b17776bfceaf8e7', 'admin@domain.tld');
\r
\r
-- --------------------------------------------------------
\r
\r
\r
-- --------------------------------------------------------
\r
\r
@@
-117,7
+124,8
@@
INSERT INTO `mw_users` (`id`, `login`, `password`, `email`) VALUES
CREATE TABLE IF NOT EXISTS `mw_users_roles` (
\r
`id_user` int(11) NOT NULL,
\r
`id_role` int(11) NOT NULL,
\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
+ PRIMARY KEY (`id_user`,`id_role`),
\r
+ KEY `id_role` (`id_role`)
\r
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\r
\r
--
\r
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\r
\r
--
\r
@@
-125,5
+133,24
@@
CREATE TABLE IF NOT EXISTS `mw_users_roles` (
--
\r
\r
INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES
\r
--
\r
\r
INSERT INTO `mw_users_roles` (`id_user`, `id_role`) VALUES
\r
-(17, 1),
\r
-(17, 2);
\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