diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-01-20 19:24:06 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-01-20 19:24:06 +1100 |
| commit | 29d0cab28ed81d8feeab3a1660daa3a427f12e2e (patch) | |
| tree | 0b38d877eb32b941d66f34358b006ffd7b624730 | |
| parent | cff753d8da889e6cd2180cb97f84876979cd49aa (diff) | |
Added robot and mute tables
| -rw-r--r-- | install.sql | 12 |
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 |
