diff options
Diffstat (limited to 'config/SQL/privs.sql')
| -rw-r--r-- | config/SQL/privs.sql | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/config/SQL/privs.sql b/config/SQL/privs.sql index 77342a8..0c3605e 100644 --- a/config/SQL/privs.sql +++ b/config/SQL/privs.sql @@ -5,17 +5,16 @@ CREATE TABLE `privs` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(255) NOT NULL, - `type` enum('c','n','e') NOT NULL, `readaccess` text NOT NULL, `writeaccess` text NOT NULL, PRIMARY KEY (`id`), - UNIQUE KEY `name` (`name`,`type`) + UNIQUE KEY `name` (`name`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; -- -- Daten für Tabelle `privs` -- -INSERT INTO `privs` (`id`, `name`, `type`, `readaccess`, `writeaccess`) VALUES (6, 'Home:Startseite', 'c', '9', '0'); -INSERT INTO `privs` (`id`, `name`, `type`, `readaccess`, `writeaccess`) VALUES (2, 'Test:LoremIpsum', 'c', '9', '0'); -INSERT INTO `privs` (`id`, `name`, `type`, `readaccess`, `writeaccess`) VALUES (3, 'Test:BBCode', 'c', '9', '0'); +INSERT INTO `privs` (`id`, `name`, `readaccess`, `writeaccess`) VALUES (6, 'Home:Startseite', '9', '0'); +INSERT INTO `privs` (`id`, `name`, `readaccess`, `writeaccess`) VALUES (2, 'Test:LoremIpsum', '9', '0'); +INSERT INTO `privs` (`id`, `name`, `readaccess`, `writeaccess`) VALUES (3, 'Test:BBCode', '9', '0'); |