summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--schema.sql24
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`)
+);