操作前,请先备份数据库!
如果你是 big5 版
复制内容到剪贴板
代码:
DROP TABLE IF EXISTS `cdb_nkflash_player`;
CREATE TABLE cdb_nkflash_player (
uid mediumint(8) unsigned NOT NULL default '0',
timestamp int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM DEFAULT CHARSET=big5;
DROP TABLE IF EXISTS `cdb_nkflash`;
CREATE TABLE cdb_nkflash (
game_id varchar(15) NOT NULL default '',
game_type char(1) NOT NULL default '1',
lastplay_time int(10) unsigned NOT NULL default '0',
flash_url varchar(30) NOT NULL default '',
flash_width smallint(5) unsigned NOT NULL default '500',
flash_height smallint(5) unsigned NOT NULL default '500',
flash_bgcolor varchar(10) NOT NULL default '#FFFFFF',
game_title varchar(20) NOT NULL default '',
play_fee smallint(6) NOT NULL default '0',
bonus_rate float unsigned NOT NULL default '1',
rate_limit float NOT NULL default '1',
score_unit varchar(10) NOT NULL default '',
game_img varchar(30) NOT NULL default '',
game_details text NOT NULL,
played_times smallint(5) unsigned NOT NULL default '0',
favorates char(1) NOT NULL default '0',
medal_id smallint(5) unsigned NOT NULL default '0',
uid_1 varchar(11) NOT NULL default '0',
score_1 double unsigned NOT NULL default '0',
level_1 tinyint(3) unsigned NOT NULL default '0',
dateline_1 int(10) unsigned NOT NULL default '0',
others_1 varchar(250) NOT NULL default '',
uid_2 varchar(11) NOT NULL default '0',
score_2 double unsigned NOT NULL default '0',
level_2 tinyint(3) unsigned NOT NULL default '0',
dateline_2 int(10) unsigned NOT NULL default '0',
others_2 varchar(250) NOT NULL default '',
uid_3 varchar(11) NOT NULL default '0',
score_3 double unsigned NOT NULL default '0',
level_3 tinyint(3) unsigned NOT NULL default '0',
dateline_3 int(10) unsigned NOT NULL default '0',
others_3 varchar(250) NOT NULL default '',
uid_4 varchar(11) NOT NULL default '0',
score_4 double unsigned NOT NULL default '0',
level_4 tinyint(3) unsigned NOT NULL default '0',
dateline_4 int(10) unsigned NOT NULL default '0',
others_4 varchar(250) NOT NULL default '',
uid_5 varchar(11) NOT NULL default '0',
score_5 double unsigned NOT NULL default '0',
level_5 tinyint(3) unsigned NOT NULL default '0',
dateline_5 int(10) unsigned NOT NULL default '0',
others_5 varchar(250) NOT NULL default '',
uid_6 varchar(11) NOT NULL default '0',
score_6 double unsigned NOT NULL default '0',
level_6 tinyint(3) unsigned NOT NULL default '0',
dateline_6 int(10) unsigned NOT NULL default '0',
others_6 varchar(250) NOT NULL default '',
uid_7 varchar(11) NOT NULL default '0',
score_7 double unsigned NOT NULL default '0',
level_7 tinyint(3) unsigned NOT NULL default '0',
dateline_7 int(10) unsigned NOT NULL default '0',
others_7 varchar(250) NOT NULL default '',
uid_8 varchar(11) NOT NULL default '0',
score_8 double unsigned NOT NULL default '0',
level_8 tinyint(3) unsigned NOT NULL default '0',
dateline_8 int(10) unsigned NOT NULL default '0',
others_8 varchar(250) NOT NULL default '',
uid_9 varchar(11) NOT NULL default '0',
score_9 double unsigned NOT NULL default '0',
level_9 tinyint(3) unsigned NOT NULL default '0',
dateline_9 int(10) unsigned NOT NULL default '0',
others_9 varchar(250) NOT NULL default '',
uid_10 varchar(11) NOT NULL default '0',
score_10 double unsigned NOT NULL default '0',
level_10 tinyint(3) unsigned NOT NULL default '0',
dateline_10 int(10) unsigned NOT NULL default '0',
others_10 varchar(250) NOT NULL default '',
PRIMARY KEY (game_id),
KEY played_times (played_times),
KEY medal_id (medal_id)
) ENGINE=MyISAM DEFAULT CHARSET=big5;如果你是 UTF-8版
复制内容到剪贴板
代码:
DROP TABLE IF EXISTS `cdb_nkflash_player`;
CREATE TABLE cdb_nkflash_player (
uid mediumint(8) unsigned NOT NULL default '0',
timestamp int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `cdb_nkflash`;
CREATE TABLE cdb_nkflash (
game_id varchar(15) NOT NULL default '',
game_type char(1) NOT NULL default '1',
lastplay_time int(10) unsigned NOT NULL default '0',
flash_url varchar(30) NOT NULL default '',
flash_width smallint(5) unsigned NOT NULL default '500',
flash_height smallint(5) unsigned NOT NULL default '500',
flash_bgcolor varchar(10) NOT NULL default '#FFFFFF',
game_title varchar(20) NOT NULL default '',
play_fee smallint(6) NOT NULL default '0',
bonus_rate float unsigned NOT NULL default '1',
rate_limit float NOT NULL default '1',
score_unit varchar(10) NOT NULL default '',
game_img varchar(30) NOT NULL default '',
game_details text NOT NULL,
played_times smallint(5) unsigned NOT NULL default '0',
favorates char(1) NOT NULL default '0',
medal_id smallint(5) unsigned NOT NULL default '0',
uid_1 varchar(11) NOT NULL default '0',
score_1 double unsigned NOT NULL default '0',
level_1 tinyint(3) unsigned NOT NULL default '0',
dateline_1 int(10) unsigned NOT NULL default '0',
others_1 varchar(250) NOT NULL default '',
uid_2 varchar(11) NOT NULL default '0',
score_2 double unsigned NOT NULL default '0',
level_2 tinyint(3) unsigned NOT NULL default '0',
dateline_2 int(10) unsigned NOT NULL default '0',
others_2 varchar(250) NOT NULL default '',
uid_3 varchar(11) NOT NULL default '0',
score_3 double unsigned NOT NULL default '0',
level_3 tinyint(3) unsigned NOT NULL default '0',
dateline_3 int(10) unsigned NOT NULL default '0',
others_3 varchar(250) NOT NULL default '',
uid_4 varchar(11) NOT NULL default '0',
score_4 double unsigned NOT NULL default '0',
level_4 tinyint(3) unsigned NOT NULL default '0',
dateline_4 int(10) unsigned NOT NULL default '0',
others_4 varchar(250) NOT NULL default '',
uid_5 varchar(11) NOT NULL default '0',
score_5 double unsigned NOT NULL default '0',
level_5 tinyint(3) unsigned NOT NULL default '0',
dateline_5 int(10) unsigned NOT NULL default '0',
others_5 varchar(250) NOT NULL default '',
uid_6 varchar(11) NOT NULL default '0',
score_6 double unsigned NOT NULL default '0',
level_6 tinyint(3) unsigned NOT NULL default '0',
dateline_6 int(10) unsigned NOT NULL default '0',
others_6 varchar(250) NOT NULL default '',
uid_7 varchar(11) NOT NULL default '0',
score_7 double unsigned NOT NULL default '0',
level_7 tinyint(3) unsigned NOT NULL default '0',
dateline_7 int(10) unsigned NOT NULL default '0',
others_7 varchar(250) NOT NULL default '',
uid_8 varchar(11) NOT NULL default '0',
score_8 double unsigned NOT NULL default '0',
level_8 tinyint(3) unsigned NOT NULL default '0',
dateline_8 int(10) unsigned NOT NULL default '0',
others_8 varchar(250) NOT NULL default '',
uid_9 varchar(11) NOT NULL default '0',
score_9 double unsigned NOT NULL default '0',
level_9 tinyint(3) unsigned NOT NULL default '0',
dateline_9 int(10) unsigned NOT NULL default '0',
others_9 varchar(250) NOT NULL default '',
uid_10 varchar(11) NOT NULL default '0',
score_10 double unsigned NOT NULL default '0',
level_10 tinyint(3) unsigned NOT NULL default '0',
dateline_10 int(10) unsigned NOT NULL default '0',
others_10 varchar(250) NOT NULL default '',
PRIMARY KEY (game_id),
KEY played_times (played_times),
KEY medal_id (medal_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;如果你是 GBK 版
复制内容到剪贴板
代码:
DROP TABLE IF EXISTS `cdb_nkflash_player`;
CREATE TABLE cdb_nkflash_player (
uid mediumint(8) unsigned NOT NULL default '0',
timestamp int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `cdb_nkflash`;
CREATE TABLE cdb_nkflash (
game_id varchar(15) NOT NULL default '',
game_type char(1) NOT NULL default '1',
lastplay_time int(10) unsigned NOT NULL default '0',
flash_url varchar(30) NOT NULL default '',
flash_width smallint(5) unsigned NOT NULL default '500',
flash_height smallint(5) unsigned NOT NULL default '500',
flash_bgcolor varchar(10) NOT NULL default '#FFFFFF',
game_title varchar(20) NOT NULL default '',
play_fee smallint(6) NOT NULL default '0',
bonus_rate float unsigned NOT NULL default '1',
rate_limit float NOT NULL default '1',
score_unit varchar(10) NOT NULL default '',
game_img varchar(30) NOT NULL default '',
game_details text NOT NULL,
played_times smallint(5) unsigned NOT NULL default '0',
favorates char(1) NOT NULL default '0',
medal_id smallint(5) unsigned NOT NULL default '0',
uid_1 varchar(11) NOT NULL default '0',
score_1 double unsigned NOT NULL default '0',
level_1 tinyint(3) unsigned NOT NULL default '0',
dateline_1 int(10) unsigned NOT NULL default '0',
others_1 varchar(250) NOT NULL default '',
uid_2 varchar(11) NOT NULL default '0',
score_2 double unsigned NOT NULL default '0',
level_2 tinyint(3) unsigned NOT NULL default '0',
dateline_2 int(10) unsigned NOT NULL default '0',
others_2 varchar(250) NOT NULL default '',
uid_3 varchar(11) NOT NULL default '0',
score_3 double unsigned NOT NULL default '0',
level_3 tinyint(3) unsigned NOT NULL default '0',
dateline_3 int(10) unsigned NOT NULL default '0',
others_3 varchar(250) NOT NULL default '',
uid_4 varchar(11) NOT NULL default '0',
score_4 double unsigned NOT NULL default '0',
level_4 tinyint(3) unsigned NOT NULL default '0',
dateline_4 int(10) unsigned NOT NULL default '0',
others_4 varchar(250) NOT NULL default '',
uid_5 varchar(11) NOT NULL default '0',
score_5 double unsigned NOT NULL default '0',
level_5 tinyint(3) unsigned NOT NULL default '0',
dateline_5 int(10) unsigned NOT NULL default '0',
others_5 varchar(250) NOT NULL default '',
uid_6 varchar(11) NOT NULL default '0',
score_6 double unsigned NOT NULL default '0',
level_6 tinyint(3) unsigned NOT NULL default '0',
dateline_6 int(10) unsigned NOT NULL default '0',
others_6 varchar(250) NOT NULL default '',
uid_7 varchar(11) NOT NULL default '0',
score_7 double unsigned NOT NULL default '0',
level_7 tinyint(3) unsigned NOT NULL default '0',
dateline_7 int(10) unsigned NOT NULL default '0',
others_7 varchar(250) NOT NULL default '',
uid_8 varchar(11) NOT NULL default '0',
score_8 double unsigned NOT NULL default '0',
level_8 tinyint(3) unsigned NOT NULL default '0',
dateline_8 int(10) unsigned NOT NULL default '0',
others_8 varchar(250) NOT NULL default '',
uid_9 varchar(11) NOT NULL default '0',
score_9 double unsigned NOT NULL default '0',
level_9 tinyint(3) unsigned NOT NULL default '0',
dateline_9 int(10) unsigned NOT NULL default '0',
others_9 varchar(250) NOT NULL default '',
uid_10 varchar(11) NOT NULL default '0',
score_10 double unsigned NOT NULL default '0',
level_10 tinyint(3) unsigned NOT NULL default '0',
dateline_10 int(10) unsigned NOT NULL default '0',
others_10 varchar(250) NOT NULL default '',
PRIMARY KEY (game_id),
KEY played_times (played_times),
KEY medal_id (medal_id)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;以上方法由 别问我是谁 提供,
http://lthung.org 大家应该特别感谢他!
另外 新增mysql 4.0 适用的升级语句,详情看 65楼的回帖。
另外 新增超400个新天下游戏数据文件打包下载,下载地址看这里:http://www.7ree.com/thread-2491-1-1.html
[
本帖最后由 红蓝白 于 2007-9-26 09:16 编辑 ]