diff options
-rw-r--r-- | schema.sql | 22 |
1 files changed, 10 insertions, 12 deletions
@@ -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, |