diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-03-30 21:47:06 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-03-30 21:47:06 +1100 |
| commit | e978bfd2b01e249cb4debf0bf4c610a049d0e627 (patch) | |
| tree | d5305452a5d98f17a7bd5ed744b7ff09af38ec5c /install.sql | |
| parent | 44aeb4d97d472a12669a6f686c7011e1e71e446b (diff) | |
Moderator noticeboard
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 19 |
1 files changed, 19 insertions, 0 deletions
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` +-- |