Skip to content

Latest commit

 

History

History
86 lines (68 loc) · 1.11 KB

NewArt.md

File metadata and controls

86 lines (68 loc) · 1.11 KB

Table:

  • Business tb_business
  • Game tb_game
  • GameServer tb_game_server
  • Device tb_device
  • AgentRecord tb_agent_record
  • DeviceQueue tb_device_queue

Business tb_business

id
business_name
business_desc
allot_limit_type
allot_limit_num
add_time

Game: tb_game

id
game_name
icon_url
banner_url
data_file_names
game_desc
gift_desc
gift_url
music_url
package_name
qr_url
apk_url
add_time
state

GameServer tb_game_server

id
game_id
server_des
server_name
data_file_names
package_name
qr_url
apk_url
add_time

Device tb_device

不变

AgentRecord tb_agent_record

新增 bussiness_id,其他不变

DeviceQueue tb_device_queue

business_id
game_id
server_id
device_id
add_time

Redis

  • business-game; KEY: business_id, VALUE: game_id zset
  • game-server; KEY: game_id, VALUE: server_id list
  • apk-device; KEY: business_id:game_id:server_id VALUE: device_id set
  • free device; KEY: , VALUE: device_id set
  • device-game; KEY: device_id, VALUE: json_encode(business_id, game_id,server_id) zset
  • user-num; KEY: user_id, VALUE: allot_num, allot_limit hash