升级数据库:
# --------------------------------------------------------
alter table cdb_members add hw varchar(15) NULL;
# --------------------------------------------------------
#
# 表的结构 `jhzhufu`
#
CREATE TABLE `jhzhufu` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`jhid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`lmoney` int(10) unsigned default NULL,
`message` text,
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
# --------------------------------------------------------
#
# 表的结构 `jie`
#
CREATE TABLE `jie` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`thename` varchar(15) NOT NULL default '',
`year` int(10) unsigned default NULL,
`longs` int(10) unsigned default NULL,
`addtime` int(10) unsigned default NULL,
`TYPE` tinyint(3) unsigned NOT NULL default '0',
`content` text,
`jiehun` tinyint(1) unsigned NOT NULL default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
# --------------------------------------------------------
#
# 表的结构 `lihun`
#
CREATE TABLE `lihun` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`reason` text,
`indict` smallint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
# --------------------------------------------------------
#
# 表的结构 `qiuhun`
#
CREATE TABLE `qiuhun` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`message` text,
`dlg` tinyint(1) unsigned NOT NULL default '0',
`jiehun` tinyint(1) unsigned NOT NULL default '0',
`content` text,
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=10 ; |