diff options
Diffstat (limited to '')
-rw-r--r-- | schema.sql | 22 |
1 files changed, 7 insertions, 15 deletions
@@ -45,7 +45,8 @@ CREATE TABLE `object` ( `type` enum( 'user', 'group', - 'pad' + 'pad', + 'stage' ) NOT NULL, PRIMARY KEY (`guid`) ); @@ -74,23 +75,14 @@ CREATE TABLE `user` ( DROP TABLE IF EXISTS `pad`; CREATE TABLE `pad` ( `guid` varchar(10) NOT NULL, - `stage` varchar(10) NOT NULL, + `stage` varchar(10) DEFAULT NULL, PRIMARY KEY (`guid`) ); - - -/* TODO -- WIP FROM HERE */ - +/* Stage objects - special attributes */ 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`) + `guid` varchar(10) NOT NULL, + `stage` varchar(10) DEFAULT NULL, + PRIMARY KEY (`guid`) ); |