From 63a4693f5d9f8109b66492bdbc6129f5d6e58b56 Mon Sep 17 00:00:00 2001 From: Janis Streib Date: Wed, 10 Sep 2014 20:02:53 +0200 Subject: [PATCH] ADD: User groups table --- doc/tableStructure.sql | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) 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; -- 2.39.2