From: Janis Streib Date: Wed, 10 Sep 2014 17:40:47 +0000 (+0200) Subject: ADD: Arbitrations table X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=dbf052542a0dcf892be9a130aa83babaa7fc1ceb ADD: Arbitrations table --- diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql index 9ad4d134..3619308d 100644 --- a/doc/tableStructure.sql +++ b/doc/tableStructure.sql @@ -262,3 +262,10 @@ CREATE TABLE `cats_type` ( PRIMARY KEY (`id`), UNIQUE KEY `type_text` (`type_text`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1; + +DROP TABLE IF EXISTS `arbitrations`; +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