- เครดิต
- 130
- เพื่อน
- ทักทาย
- บล็อก
- อัลบั้ม
- โพสต์
- กระทู้
- แชร์
- สำคัญ
- สิทธิ์อ่าน
- 10
- จำนวนผู้ติดตาม
- จำนวนผู้กำลังติดตาม
- เพศ
- ไม่บอก
|
MYSQL 4.1 หรือตำกว่าใช้ตัวนี้ ในการดั้มฐานข้อมูลที่ phpmyadmin
==========================================================================================
CREATE TABLE cdb_nkflash_player (
uid mediumint(8) unsigned NOT NULL default '0',
timestamp int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
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)
) TYPE=MyISAM;
[ แก้ไขล่าสุด powermacc เมื่อ 2008-2-19 16:41 ] |
|