X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=doc%2FtableStructure.sql;h=3619308d7aa361bf6188d55194538bee8df11c08;hp=468f2bbef35002c90abcb62fd52b9c3af417a355;hb=dbf052542a0dcf892be9a130aa83babaa7fc1ceb;hpb=d96203a1db1af08b38b80a0b9c26d78fc6e422c5 diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql index 468f2bbe..3619308d 100644 --- a/doc/tableStructure.sql +++ b/doc/tableStructure.sql @@ -79,6 +79,7 @@ CREATE TABLE `pingconfig` ( `domainid` int(11) NOT NULL, `type` enum('email', 'ssl', 'http', 'dns') NOT NULL, `info` varchar(255) NOT NULL, + `reping` enum('y','n') NOT NULL DEFAULT 'n', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; @@ -261,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