X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=content%2Fdata%2Fmysql%2Fmtweb.sql;fp=content%2Fdata%2Fmysql%2Fmtweb.sql;h=368c36c57b3632526f515975bec9d6b5b22d4dfe;hb=2ff0191d4033a2e45ca57e478ff81132c132ed1f;hp=dfc90689272baa8dcc044b12d29f9372ba31bd45;hpb=3c17f81e1d2fb68f69cfa620ca00ad63e83cc17c;p=mtweb diff --git a/content/data/mysql/mtweb.sql b/content/data/mysql/mtweb.sql index dfc9068..368c36c 100644 --- 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` -- -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=116 ; - --- --- Contenu de la table `mw_action_status` --- - -INSERT INTO `mw_action_status` (`id`, `action`, `id_status`) VALUES -(115, 'users/identification', 0), -(111, 'users', 2), -(113, 'admin', 1); +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); -- --------------------------------------------------------