From c94008be7dad72d4fee27aa0e39d5c286d22c292 Mon Sep 17 00:00:00 2001
From: M <m@lfurio.us>
Date: Wed, 18 Nov 2015 21:49:48 -0500
Subject: + Defined membership association table

---
 schema.sql | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index d586c35..f29948f 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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 */
-- 
cgit v1.2.3

