diff options
Diffstat (limited to '')
-rw-r--r-- | schema.sql | 9 |
1 files changed, 8 insertions, 1 deletions
@@ -34,6 +34,14 @@ USE `db_scrott`; * Permissions can be overridden down-stream, but permissions will cascade otherwise. */ +DROP TABLE IF EXISTS `member`; +CREATE TABLE `member` ( + `object` varchar(10) NOT NULL, + `member` varchar(10) NOT NULL, + + PRIMARY KEY (`object`,`member`) +); + DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, @@ -60,4 +68,3 @@ CREATE TABLE `group` ( `owner` varchar(10) NOT NULL, `name` varchar(50) NOT NULL, /* TODO -- wip */ - /* TODO -- remember members table */ |