sql.sql

小蜜蜂商务网站门户系统(BBWPS)平台系统 v1.0 Build 061113

CREATE TABLE `bbwps_pm` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `from` varchar(20) NOT NULL default '',
  `to` varchar(20) NOT NULL default '0',
  `posttime` int(10) unsigned NOT NULL default '0',
  `title` varchar(75) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `frombox` tinyint(4) default NULL,
  `new` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  KEY `from` (`from`),
  KEY `from_2` (`from`),
  KEY `to` (`to`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `bbwps_pmbox` (
  `pbid` int(10) unsigned NOT NULL auto_increment,
  `from` varchar(20) NOT NULL default '',
  `to` varchar(20) NOT NULL default '0',
  `posttime` int(10) unsigned NOT NULL default '0',
  `title` varchar(75) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `new` tinyint(1) NOT NULL default '1',
  `system` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`pbid`),
  KEY `from` (`from`),
  KEY `to` (`to`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `bbwps_friend` (
  `friendid` smallint(8) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `friendname` varchar(20) NOT NULL default '',
  `addtime` int(10) NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `validatetype` tinyint(1) NOT NULL default '0',
  `annexmess` text NOT NULL,
  PRIMARY KEY  (`friendid`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;


ALTER TABLE `bbwps_members` ADD `validate` tinyint( 1 ) NOT NULL ;
ALTER TABLE `bbwps_members` ADD `messprotect` tinyint( 1 ) NOT NULL ;
ALTER TABLE `bbwps_members` ADD `newmess` tinyint( 1 ) NOT NULL ;
ALTER TABLE `bbwps_members` ADD `newvalidate` tinyint( 1 ) NOT NULL ;
ALTER TABLE `bbwps_members` ADD `delmess` tinyint( 1 ) NOT NULL ;