From 4cea4b5494c6660d03614d8ea59214f1ad924de3 Mon Sep 17 00:00:00 2001
From: M <m@lfurio.us>
Date: Thu, 19 Nov 2015 20:35:32 -0500
Subject: * Refactored pad table into new core data model

---
 schema.sql | 22 ++++++++++------------
 1 file changed, 10 insertions(+), 12 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index c6a6370..7bd2bf0 100644
--- a/schema.sql
+++ b/schema.sql
@@ -44,7 +44,8 @@ CREATE TABLE `object` (
     `name`   varchar(50)          NOT NULL,
     `type`   enum(
         'user',
-        'group'
+        'group',
+        'pad'
     )                             NOT NULL,
     PRIMARY KEY (`guid`)
 );
@@ -69,21 +70,18 @@ CREATE TABLE `user` (
 
 /* object type 'group' has no unique attributes */
 
-
-
-/* TODO -- WIP FROM HERE */
-
+/* Pad objects - special attributes */
 DROP TABLE IF EXISTS `pad`;
 CREATE TABLE `pad` (
-    `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`)
+    `guid`   varchar(10)          NOT NULL,
+    `stage`  varchar(10)          NOT NULL,
+    PRIMARY KEY (`guid`)
 );
 
+
+
+/* TODO -- WIP FROM HERE */
+
 DROP TABLE IF EXISTS `stage`;
 CREATE TABLE `stage` (
     `id`     int(10)     unsigned     NOT NULL AUTO_INCREMENT,
-- 
cgit v1.2.3

