* Refactored pad table into new core data model

1 files changed, 10 insertions, 12 deletions

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,