From: Janis Streib <janis@dogcraft.de>
Date: Wed, 10 Sep 2014 18:02:53 +0000 (+0200)
Subject: ADD: User groups table
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=63a4693f5d9f8109b66492bdbc6129f5d6e58b56;hp=dbf052542a0dcf892be9a130aa83babaa7fc1ceb

ADD: User groups table
---

diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql
index 3619308d..b2e3b068 100644
--- a/doc/tableStructure.sql
+++ b/doc/tableStructure.sql
@@ -268,4 +268,16 @@ CREATE TABLE IF NOT EXISTS `arbitrations` (
   `user` int(11) NOT NULL,
   `arbitration` varchar(20) NOT NULL,
   PRIMARY KEY (`user`,`arbitration`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\ No newline at end of file
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `user_groups`;
+CREATE TABLE IF NOT EXISTS `user_groups` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `user` int(11) NOT NULL,
+  `permission` enum('supporter','arbitrator','blockedassuree','blockedassurer','ttp-assuer','codesigning') NOT NULL,
+  `granted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `deleted` timestamp NULL DEFAULT NULL,
+  `grantedby` int(11) NOT NULL,
+  `revokedby` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;