From 8b0f72d095fc5cb894c6ed19612d98fb03224d9f Mon Sep 17 00:00:00 2001
From: M <m@lfurio.us>
Date: Wed, 18 Nov 2015 23:48:35 -0500
Subject: * Draft definitions for pad and stage schemas

---
 schema.sql | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)

(limited to 'schema.sql')

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`)
+);
-- 
cgit v1.2.3

