GongFuServer/webServer/src/config/sdk.sql

DROP TABLE IF EXISTS `game_order`;
CREATE TABLE `game_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_id` varchar(50) NOT NULL DEFAULT '' COMMENT '订单id',
  `uid` varchar(100) NOT NULL DEFAULT '' COMMENT '用户id',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '订单状态 1未支付 2成功 3失败',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `out_trade_no` varchar(255) NOT NULL DEFAULT '' COMMENT '第三方订单id',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级',
  `role_id` varchar(50) NOT NULL DEFAULT '' COMMENT '角色id',
  `role_name` varchar(100) NOT NULL DEFAULT '' COMMENT '角色名',
  `product_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '订单金额 单位分',
  `server_id` int(11) NOT NULL DEFAULT '0' COMMENT '区服id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';


DROP TABLE IF EXISTS `game_server`;
CREATE TABLE `game_server` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '区服名',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'ip',
  `port` int(11) NOT NULL DEFAULT '0' COMMENT '端口',
  `tag` varchar(50) NOT NULL DEFAULT 'default' COMMENT '标识',
  `tips` varchar(1000) NOT NULL DEFAULT '' COMMENT '公告',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='区服表';


DROP TABLE IF EXISTS `game_version`;
CREATE TABLE `game_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `version` varchar(50) NOT NULL DEFAULT '' COMMENT '版本',
  `download_url` varchar(100) NOT NULL DEFAULT '' COMMENT '下载链接',
  `tag` varchar(50) NOT NULL DEFAULT 'default' COMMENT '标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='游戏版本';

CREATE TABLE `game_enter_server` (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` varchar(50) NOT NULL DEFAULT '' COMMENT '区服名',
  `server_id` varchar(50) NOT NULL DEFAULT '' COMMENT '区服id',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '进区时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='进区记录表';

ALTER TABLE game_server ADD white_list varchar(1000) NOT NULL DEFAULT '';

ALTER TABLE game_server ADD open_time int(11) NOT NULL DEFAULT 0 COMMENT '开区时间';

ALTER TABLE game_order ADD token text NOT NULL DEFAULT '';
ALTER TABLE game_order ADD platform varchar(50) NOT NULL DEFAULT '';

//加区服
 INSERT INTO `game_server` (`id`, `name`, `status`, `ip`, `port`, `tag`, `tips`,`white_list`) VALUES (29, 'ขอบเขต 29', 3, '110.234.192.112', 8220, 'default', '','');
 INSERT INTO `game_server` (`id`, `name`, `status`, `ip`, `port`, `tag`, `tips`,`white_list`) VALUES (35, 'เซิร์ฟเวอร์ 35', 1, '110.234.192.112', 8226, 'default', '','');

// 加白名单
 update game_server set white_list = '171.216.76.130,101.24.120.82' where id =3;

//关闭
 update game_server set status = 0 where id =3;
 //开启
 update game_server set status = 1 where id =5;
 //改公告

 update game_server set tips = '服务器将于2024-09-07 13:00开启 官方QQ群：992058780' where id =3;


  INSERT INTO `game_server` (`id`, `name`, `status`, `ip`, `port`, `tag`, `tips`,`white_list`) VALUES (3, '寻宝3区', 1, '118.145.139.78', 28192, 'default', '服务器将于2024-09-07 13:00开启 官方QQ群：992058780','');


  INSERT INTO `game_server` (`id`, `name`, `status`, `ip`, `port`, `tag`, `tips`,`white_list`) VALUES (1, 'ขอบเขต 1', 3, '110.234.192.112', 8192, 'default', '','');
  INSERT INTO `game_server` (`id`, `name`, `status`, `ip`, `port`, `tag`, `tips`,`white_list`) VALUES (2, 'ขอบเขต 2', 3, '110.234.192.112', 8193, 'default', '','');
  INSERT INTO `game_server` (`id`, `name`, `status`, `ip`, `port`, `tag`, `tips`,`white_list`) VALUES (3, 'ขอบเขต 3', 3, '110.234.192.112', 8194, 'default', '','');