diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-02-20 17:23:21 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-02-20 17:23:21 +1100 |
| commit | ad3af856b3e8a70b71f80a3086104f36d149184a (patch) | |
| tree | 6e73ec98a5bb4f1b022e0dea8e8b6575727a0103 /install.sql | |
| parent | ce18d43bcd5f23aabab2c6bd60a6b01128772d42 (diff) | |
Added reports table
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 21 |
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` -- |
