diff options
| -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`)  ); | 
