diff options
-rw-r--r-- | schema.sql | 18 |
1 files changed, 8 insertions, 10 deletions
@@ -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`) +); |