[問題]關於水怪RPG的SQL

[Avenger]

= =
搜尋很多文章後
還是不知道怎麼辦

SQL一直裝不上去....

# 頭彩
這一段有出現問題 我刪了

結果又出現這個

代碼: 選擇全部

ALTER TABLE `phpbb_users` ADD `user_bank` int( 11 ) unsigned NOT NULL default '0',
ADD `user_bank_time` int( 11 ) default '0',
ADD `user_robfail` smallint( 5 ) default '0',
ADD `rpg_rob_cnt` smallint( 5 ) unsigned default '0',
ADD `rpg_robbed_cnt` smallint( 5 ) unsigned default '0',
ADD `rpg_rob_succ` smallint( 5 ) unsigned default '0',
ADD `rpg_rob_fail` smallint( 5 ) unsigned default '0',
ADD `rpg_rob_money` int( 11 ) unsigned default '0',
ADD `rpg_robbed_money` int( 11 ) unsigned default '0',
ADD `rpg_level` smallint( 5 ) NOT NULL default '1',
ADD `rpg_cur_exp` mediumint( 8 ) NOT NULL default '0',
ADD `rpg_max_exp` mediumint( 8 ) NOT NULL default '9',
ADD `rpg_cur_hp` mediumint( 8 ) NOT NULL default '18',
ADD `rpg_max_hp` mediumint( 8 ) NOT NULL default '18',
ADD `rpg_cur_mp` mediumint( 8 ) NOT NULL default '8',
ADD `rpg_max_mp` mediumint( 8 ) NOT NULL default '8',
ADD `rpg_attack` mediumint( 8 ) NOT NULL default '1',
ADD `rpg_defense` mediumint( 8 ) NOT NULL default '1',
ADD `rpg_magic` mediumint( 8 ) NOT NULL default '1',
ADD `rpg_speed` mediumint( 8 ) NOT NULL default '1',
ADD `rpg_medals` varchar( 200 ) default '路人',
ADD `rpg_richer_pos` int( 10 ) default NULL 

MySQL 傳回： 


#1060 - Duplicate column name 'user_bank'

HELP~

目前有裝CASH MOD 221 論壇銀行0923

[hk_andy_hk]

你的資料庫已經有了user_bank這個欄位, 刪除這一段:
ADD `user_bank` int(11) unsigned NOT NULL default '0',
再匯入SQL吧

[Avenger]

感謝~