* Draft definitions for pad and stage schemas

1 files changed, 24 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
index 78ad375..26f7d8e 100644
--- a/schema.sql
+++ b/schema.sql
@@ -66,3 +66,27 @@ CREATE TABLE `group` (
 
     PRIMARY KEY (`id`)
 );
+
+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`)
+);
+
+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`)
+);