diff options
Diffstat (limited to 'config/SQL/groups.sql')
-rw-r--r-- | config/SQL/groups.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/config/SQL/groups.sql b/config/SQL/groups.sql new file mode 100644 index 0000000..b8b9065 --- /dev/null +++ b/config/SQL/groups.sql @@ -0,0 +1,17 @@ +-- +-- Tabellenstruktur für Tabelle `groups` +-- + +CREATE TABLE `groups` ( + `id` bigint(20) NOT NULL auto_increment, + `name` varchar(100) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +) TYPE=MyISAM AUTO_INCREMENT=4 ; + +-- +-- Daten für Tabelle `groups` +-- + +INSERT INTO `groups` (`id`, `name`) VALUES (3, 'Mitglied'); +INSERT INTO `groups` (`id`, `name`) VALUES (-1, '{{Administrator}}'); |