| 1234567891011121314151617 |
- CREATE TABLE IF NOT EXISTS `forums` (
- `forum_id` int(8) NOT NULL DEFAULT '0',
- `forum_name` varchar(255) NOT NULL DEFAULT '',
- `forum_parent` int(8) NOT NULL DEFAULT '0',
- `forum_post` int(8) NOT NULL DEFAULT '0',
- `forum_type` int(8) NOT NULL DEFAULT '0',
- `forum_perm` int(8) NOT NULL DEFAULT '0',
- `forum_owner_id` int(8) NOT NULL DEFAULT '0',
- PRIMARY KEY (`forum_id`),
- KEY `forum_owner_id` (`forum_owner_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT IGNORE INTO `forums` VALUES
- (1, 'NormalRoot', 0, 0, 0, 1, 0),
- (2, 'ClanRoot', 0, 0, 0, 0, 0),
- (3, 'MemoRoot', 0, 0, 0, 0, 0),
- (4, 'MailRoot', 0, 0, 0, 0, 0);
|
