DROP TABLE IF EXISTS `{DB_TABLE_PREFIX}broadcast`;
CREATE TABLE IF NOT EXISTS `{DB_TABLE_PREFIX}broadcast` (
  `bid` mediumint(8) NOT NULL auto_increment COMMENT '广播id',
  `sortid` mediumint(8) NOT NULL default '0' COMMENT '排序,越大越靠前',
  `content` varchar(300) NOT NULL COMMENT '内容',
  PRIMARY KEY  (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `{DB_TABLE_PREFIX}items`;
CREATE TABLE IF NOT EXISTS `{DB_TABLE_PREFIX}items` (
  `itemid` mediumint(8) unsigned NOT NULL auto_increment,
  `uid` mediumint(8) unsigned NOT NULL COMMENT '发布者uid',
  `account` char(15) NOT NULL COMMENT '账户名',
  `content` varchar(300) NOT NULL COMMENT '内容',
  `dateline` int(10) unsigned NOT NULL COMMENT '发布日期',
  `digg` mediumint(8) unsigned NOT NULL default '0' COMMENT '顶客',
  `reply` mediumint(5) unsigned NOT NULL default '0' COMMENT '回复数',
  PRIMARY KEY  (`itemid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `{DB_TABLE_PREFIX}reply`;
CREATE TABLE IF NOT EXISTS `{DB_TABLE_PREFIX}reply` (
  `rid` mediumint(8) NOT NULL auto_increment COMMENT '回复ID',
  `replyto` mediumint(8) unsigned NOT NULL COMMENT '所回复内容的id',
  `uid` mediumint(8) NOT NULL COMMENT '回复者id',
  `account` varchar(15) NOT NULL COMMENT '用户名',
  `content` varchar(300) NOT NULL COMMENT '内容',
  `dateline` int(10) unsigned NOT NULL COMMENT '回复时间',
  PRIMARY KEY  (`rid`),
  KEY `uid` (`uid`),
  KEY `replyto` (`replyto`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
