From 8b0f72d095fc5cb894c6ed19612d98fb03224d9f Mon Sep 17 00:00:00 2001 From: M 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