diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-04-14 00:24:49 +1000 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-04-14 00:24:49 +1000 |
| commit | d17e756881e009031519ae7e62361cefe0442daf (patch) | |
| tree | 2af99d93758c889a5f4d5c509c7c87ebf4b5c777 /install.sql | |
| parent | 99b1ffe35a46869ee2c617c6c25581b41290fe7b (diff) | |
news
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/install.sql b/install.sql index 4ceb4c85..6e032007 100644 --- a/install.sql +++ b/install.sql @@ -247,3 +247,39 @@ CREATE TABLE IF NOT EXISTS `robot` ( -- Dumping data for table `robot` -- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `theme_settings` +-- + +CREATE TABLE IF NOT EXISTS `theme_settings` ( + `name` varchar(40) NOT NULL, + `value` text, + UNIQUE KEY `name` (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `theme_settings` +-- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `news` +-- + +CREATE TABLE IF NOT EXISTS `news` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` text 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=1 ; + +-- +-- Dumping data for table `news` +-- + |
