forums.sql 575 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. );
  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);