From 4cea4b5494c6660d03614d8ea59214f1ad924de3 Mon Sep 17 00:00:00 2001 From: M Date: Thu, 19 Nov 2015 20:35:32 -0500 Subject: * Refactored pad table into new core data model --- schema.sql | 22 ++++++++++------------ 1 file changed, 10 insertions(+), 12 deletions(-) (limited to 'schema.sql') 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, -- cgit v1.2.3