From 359c276b3cd853f0f9688dc5c3d5806be43e9b0b Mon Sep 17 00:00:00 2001 From: M Date: Wed, 18 Nov 2015 22:04:33 -0500 Subject: + Defined group table --- schema.sql | 18 ++++++++---------- 1 file changed, 8 insertions(+), 10 deletions(-) (limited to 'schema.sql') 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`) +); -- cgit v1.2.3