summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--schema.sql22
1 files changed, 10 insertions, 12 deletions
diff --git a/schema.sql b/schema.sql
index c6a6370..7bd2bf0 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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,