DROP TABLE IF EXISTS `pre_nkflash`;
CREATE TABLE IF NOT EXISTS `pre_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;
DROP TABLE IF EXISTS `pre_nkflash_player`;
CREATE TABLE IF NOT EXISTS `pre_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 `pre_threadtags`;
CREATE TABLE IF NOT EXISTS `pre_threadtags` (
`tagname` char(20) NOT NULL,
`tid` int(10) unsigned NOT NULL,
KEY `tagname` (`tagname`),
KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk; |