From dbf052542a0dcf892be9a130aa83babaa7fc1ceb Mon Sep 17 00:00:00 2001 From: Janis Streib Date: Wed, 10 Sep 2014 19:40:47 +0200 Subject: [PATCH] ADD: Arbitrations table --- doc/tableStructure.sql | 7 +++++++ 1 file changed, 7 insertions(+) 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 -- 2.39.2