From 359c276b3cd853f0f9688dc5c3d5806be43e9b0b Mon Sep 17 00:00:00 2001
From: M <m@lfurio.us>
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

