From c4c6a9839645c49a981de6f9dcf82fe0c7a0c739 Mon Sep 17 00:00:00 2001
From: Savetheinternet <savetheinternet@tinyboard.org>
Date: Thu, 4 Aug 2011 15:47:34 +1000
Subject: various bug fixed, introduced ban ID, temporarily broke caching bans
 with memcached

---
 install.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'install.sql')

diff --git a/install.sql b/install.sql
index dfdb62f0..508de215 100644
--- a/install.sql
+++ b/install.sql
@@ -19,13 +19,16 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 --
 
 CREATE TABLE IF NOT EXISTS `bans` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `ip` varchar(45) NOT NULL,
   `mod` int(11) NOT NULL COMMENT 'which mod made the ban',
   `set` int(11) NOT NULL,
   `expires` int(11) DEFAULT NULL,
   `reason` text,
-  `board` smallint(6) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  `board` smallint(6) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `id` (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
 
 --
 -- Dumping data for table `bans`
-- 
cgit v1.3