From e978bfd2b01e249cb4debf0bf4c610a049d0e627 Mon Sep 17 00:00:00 2001 From: Savetheinternet Date: Wed, 30 Mar 2011 21:47:06 +1100 Subject: Moderator noticeboard --- install.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'install.sql') diff --git a/install.sql b/install.sql index 6123bc6c..a20b1451 100644 --- a/install.sql +++ b/install.sql @@ -204,3 +204,22 @@ CREATE TABLE IF NOT EXISTS `robot` ( -- Dumping data for table `robot` -- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `noticeboard` +-- + +CREATE TABLE IF NOT EXISTS `noticeboard` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `mod` int(11) NOT NULL, + `time` int(11) NOT NULL, + `subject` text NOT NULL, + `body` text NOT NULL, + UNIQUE KEY `id` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; + +-- +-- Dumping data for table `noticeboard` +-- -- cgit v1.3