summaryrefslogtreecommitdiff
path: root/install.sql
diff options
context:
space:
mode:
authorSavetheinternet <savetheinternet@n0v4.com>2011-02-20 17:23:21 +1100
committerSavetheinternet <savetheinternet@n0v4.com>2011-02-20 17:23:21 +1100
commitad3af856b3e8a70b71f80a3086104f36d149184a (patch)
tree6e73ec98a5bb4f1b022e0dea8e8b6575727a0103 /install.sql
parentce18d43bcd5f23aabab2c6bd60a6b01128772d42 (diff)
Added reports table
Diffstat (limited to 'install.sql')
-rw-r--r--install.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/install.sql b/install.sql
index d2831a02..7ee6b127 100644
--- a/install.sql
+++ b/install.sql
@@ -16,6 +16,27 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- --------------------------------------------------------
--
+-- Table structure for table `reports`
+--
+
+CREATE TABLE IF NOT EXISTS `reports` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `time` int(11) NOT NULL,
+ `ip` varchar(45) NOT NULL,
+ `board` smallint(6) NOT NULL,
+ `post` int(11) NOT NULL,
+ `reason` text NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `id` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `reports`
+--
+
+-- --------------------------------------------------------
+
+--
-- Table structure for table `bans`
--