posts.sql 607 B

1234567891011121314
  1. CREATE TABLE IF NOT EXISTS `posts` (
  2. `serverId` int(8) NOT NULL DEFAULT '0',
  3. `post_id` int(8) NOT NULL DEFAULT '0',
  4. `post_ownerid` int(8) NOT NULL DEFAULT '0',
  5. `post_recipient_list` varchar(255) NOT NULL DEFAULT '0',
  6. `post_parent_id` int(8) NOT NULL DEFAULT '0',
  7. `post_date` decimal(20,0) NOT NULL DEFAULT '0',
  8. `post_topic_id` int(8) NOT NULL DEFAULT '0',
  9. `post_forum_id` int(8) NOT NULL DEFAULT '0',
  10. `post_txt` text NOT NULL,
  11. `post_title` text,
  12. `post_type` int(8) NOT NULL DEFAULT '0',
  13. `post_read_count` int(8) NOT NULL DEFAULT '0'
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;