DROP TABLE IF EXISTS cdb_jhzhufu;
CREATE TABLE `cdb_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 CHARSET=gbk;
DROP TABLE IF EXISTS cdb_jie;
CREATE TABLE `cdb_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 CHARSET=gbk;
DROP TABLE IF EXISTS cdb_lihun;
CREATE TABLE `cdb_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 CHARSET=gbk;
DROP TABLE IF EXISTS cdb_qiuhun;
CREATE TABLE `cdb_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 CHARSET=gbk;
已经解决 1267的错误,是因为数据库字体的错误,把这个 复制到SQL里面升级就可以了 |