summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSavetheinternet <savetheinternet@n0v4.com>2011-01-20 19:24:06 +1100
committerSavetheinternet <savetheinternet@n0v4.com>2011-01-20 19:24:06 +1100
commit29d0cab28ed81d8feeab3a1660daa3a427f12e2e (patch)
tree0b38d877eb32b941d66f34358b006ffd7b624730
parentcff753d8da889e6cd2180cb97f84876979cd49aa (diff)
Added robot and mute tables
-rw-r--r--install.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/install.sql b/install.sql
index 0955c153..7e1af765 100644
--- a/install.sql
+++ b/install.sql
@@ -107,6 +107,7 @@ INSERT INTO `mods` (`id`, `username`, `password`, `type`) VALUES
-- Table structure for table `bans`
--
+
CREATE TABLE IF NOT EXISTS `bans` (
`ip` varchar( 15 ) NOT NULL ,
`mod` int NOT NULL COMMENT 'which mod made the ban',
@@ -114,3 +115,14 @@ CREATE TABLE IF NOT EXISTS `bans` (
`expires` int NULL,
`reason` text NULL
) ENGINE = InnoDB;
+
+
+CREATE TABLE `robot` (
+`hash` VARCHAR( 40 ) NOT NULL COMMENT 'SHA1'
+) ENGINE = INNODB; */
+
+
+CREATE TABLE `mutes` (
+`ip` VARCHAR( 15 ) NOT NULL ,
+`time` INT NOT NULL
+) ENGINE = MYISAM ; \ No newline at end of file