1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
--
-- Tabellenstruktur für Tabelle `privs`
--
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`)
) 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');
|