我选择了 【【MYSQL == 4.1.* 的升级以下】】
DROP TABLE IF EXISTS `cdb_cards` ;
CREATE TABLE `cdb_cards` (
`cardid` mediumint(8) unsigned NOT NULL auto_increment,
`cards` char(255) NOT NULL,
`canuse` char(2) NOT NULL,
`cardextcredits` char(50) NOT NULL,
`count` DECIMAL(20, 1) NOT NULL,
`value` DECIMAL(20, 2),
`creatuid` mediumint(8) unsigned NOT NULL,
`creattime` int(10),
`buyuid` mediumint(8) unsigned NOT NULL default '0',
`canbuy` char(2) NOT NULL,
`inuid` mediumint(8) unsigned NULL,
`intime` int(10),
`buying` char(2) NOT NULL,
`morebz` char(80),
`canjs` char(2) NOT NULL,
PRIMARY KEY (`cardid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `cdb_cardsorder` ;
CREATE TABLE `cdb_cardsorder` (
`orderid` char(32) NOT NULL,
`orcardid` mediumint(8) unsigned NOT NULL,
`orderuid` mediumint(8) UNSIGNED NOT NULL,
`ordertime` int(10) UNSIGNED NOT NULL default '0',
`overtime` int(10) NOT NULL default '0',
`ordertype` char(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
提示 你想干吗 |