-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathupdate.sql
3 lines (2 loc) · 1.04 KB
/
update.sql
1
2
3
insert w_games (name, title, shop_id, jpg_id, label, device, gamebank, chanceFirepot1, chanceFirepot2, chanceFirepot3,fireCount1,fireCount2,fireCount3, lines_percent_config_spin, lines_percent_config_spin_bonus, lines_percent_config_bonus,lines_percent_config_bonus_bonus, rezerv,cask,advanced,bet,scaleMode,slotViewState,view,denomination,category_temp,original_id,bids,stat_in,stat_out,current_rtp,rtp_stat_in,rtp_stat_out) select name, title, 14, jpg_id, label, device, gamebank, chanceFirepot1, chanceFirepot2, chanceFirepot3,fireCount1,fireCount2,fireCount3, lines_percent_config_spin, lines_percent_config_spin_bonus, lines_percent_config_bonus,lines_percent_config_bonus_bonus, rezerv,cask,advanced,bet,scaleMode,slotViewState,view,denomination,category_temp,original_id,bids,stat_in,stat_out,current_rtp,rtp_stat_in,rtp_stat_out from w_games where shop_id=1;
ALTER TABLE `w_apis` CHANGE `endpoint` `update_endpoint` VARCHAR(255) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, ADD COLUMN `get_endpoint` VARCHAR(255) NOT NULL AFTER `update_endpoint`;