summaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql18
1 files changed, 8 insertions, 10 deletions
diff --git a/schema.sql b/schema.sql
index f29948f..78ad375 100644
--- a/schema.sql
+++ b/schema.sql
@@ -56,15 +56,13 @@ CREATE TABLE `user` (
PRIMARY KEY (`id`)
);
-
-
-
-
-
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `guid` varchar(10) NOT NULL,
- `owner` varchar(10) NOT NULL,
- `name` varchar(50) NOT NULL,
- /* TODO -- wip */
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `guid` varchar(10) NOT NULL,
+ `owner` varchar(10) NOT NULL,
+ `perms` int(10) unsigned NOT NULL,
+ `name` varchar(50) NOT NULL,
+
+ PRIMARY KEY (`id`)
+);