diff options
Diffstat (limited to '')
-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`) +); |