summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSavetheinternet <savetheinternet@n0v4.com>2011-01-01 22:58:13 +1100
committerSavetheinternet <savetheinternet@n0v4.com>2011-01-01 22:58:13 +1100
commit45e8727fef45dfa2e37c4e734909f4291c119be8 (patch)
treebcfbe45703ea23e2b06f4b4008ecd9e293a8d980
parentf1c48f61227475fad5faa95796b04888089ed589 (diff)
Added bans table
-rw-r--r--install.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/install.sql b/install.sql
index 051b596b..9df580a0 100644
--- a/install.sql
+++ b/install.sql
@@ -98,3 +98,17 @@ CREATE TABLE IF NOT EXISTS `mods` (
INSERT INTO `mods` (`id`, `username`, `password`, `type`) VALUES
(1, 'admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 2);
+
+
+-- --------------------------------------------------------
+
+--
+-- 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',
+ `expires` int NOT NULL,
+ `reason` text NULL
+) ENGINE = InnoDB;