forums.sql 610 B

12345678910111213141516
  1. CREATE TABLE IF NOT EXISTS `forums` (
  2. `forum_id` int(8) NOT NULL default '0',
  3. `forum_name` varchar(255) NOT NULL default '',
  4. `forum_parent` int(8) NOT NULL default '0',
  5. `forum_post` int(8) NOT NULL default '0',
  6. `forum_type` int(8) NOT NULL default '0',
  7. `forum_perm` int(8) NOT NULL default '0',
  8. `forum_owner_id` int(8) NOT NULL default '0',
  9. UNIQUE KEY `forum_id` (`forum_id`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  11. INSERT IGNORE INTO `forums` VALUES
  12. (1, 'NormalRoot', 0, 0, 0, 1, 0),
  13. (2, 'ClanRoot', 0, 0, 0, 0, 0),
  14. (3, 'MemoRoot', 0, 0, 0, 0, 0),
  15. (4, 'MailRoot', 0, 0, 0, 0, 0);