diff options
| -rw-r--r-- | schema.sql | 24 | 
1 files changed, 24 insertions, 0 deletions
| @@ -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`) +); | 
