renommage de "status" en "role" (bdd et code)

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

diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql
index dfc9068..368c36c 100644 (file)
--- a/content/data/mysql/mtweb.sql
+++ b/content/data/mysql/mtweb.sql
@@ -19,21 +19,21 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 -- Structure de la table `mw_action_status`\r
 --\r
 \r
-CREATE TABLE IF NOT EXISTS `mw_action_status` (\r
-  `id` int(11) NOT NULL AUTO_INCREMENT,\r
-  `action` varchar(255) NOT NULL,\r
-  `id_status` int(11) NOT NULL,\r
-  PRIMARY KEY (`id`)\r
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;\r
-\r
---\r
--- Contenu de la table `mw_action_status`\r
---\r
-\r
-INSERT INTO `mw_action_status` (`id`, `action`, `id_status`) VALUES\r
-(115, 'users/identification', 0),\r
-(111, 'users', 2),\r
-(113, 'admin', 1);\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);
 \r
 -- --------------------------------------------------------\r
 \r