diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-01-01 22:58:13 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-01-01 22:58:13 +1100 |
| commit | 45e8727fef45dfa2e37c4e734909f4291c119be8 (patch) | |
| tree | bcfbe45703ea23e2b06f4b4008ecd9e293a8d980 | |
| parent | f1c48f61227475fad5faa95796b04888089ed589 (diff) | |
Added bans table
| -rw-r--r-- | install.sql | 14 |
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; |
