* Refactored stage table into new data model

1 files changed, 7 insertions, 15 deletions

diff --git a/schema.sql b/schema.sql
index 7bd2bf0..0867a75 100644
--- a/schema.sql
+++ b/schema.sql
@@ -45,7 +45,8 @@ CREATE TABLE `object` (
     `type`   enum(
         'user',
         'group',
-        'pad'
+        'pad',
+        'stage'
     )                             NOT NULL,
     PRIMARY KEY (`guid`)
 );
@@ -74,23 +75,14 @@ CREATE TABLE `user` (
 DROP TABLE IF EXISTS `pad`;
 CREATE TABLE `pad` (
     `guid`   varchar(10)          NOT NULL,
-    `stage`  varchar(10)          NOT NULL,
+    `stage`  varchar(10)      DEFAULT NULL,
     PRIMARY KEY (`guid`)
 );
 
-
-
-/* TODO -- WIP FROM HERE */
-
+/* Stage objects - special attributes */
 DROP TABLE IF EXISTS `stage`;
 CREATE TABLE `stage` (
-    `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,
-    `parent` varchar(10)              NOT NULL,
-    /* TODO -- wip */
-
-    PRIMARY KEY (`id`)
+    `guid`   varchar(10)          NOT NULL,
+    `stage`  varchar(10)      DEFAULT NULL,
+    PRIMARY KEY (`guid`)
 );