RoConfig/open_server/ro.sql

CREATE TABLE `role` (
  `uid` varchar(255) NOT NULL,
  `serverid` int(32) NOT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `nick_name` varchar(255) DEFAULT NULL,
  `base_level` int(32) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `last_login_date` datetime DEFAULT NULL,
  `map_level` varchar(255) DEFAULT NULL,
  `max_fight_power` varchar(255) DEFAULT NULL,
  `fight_power` varchar(255) DEFAULT NULL,
  `active_code` varchar(255) DEFAULT NULL,
  `open_id` varchar(255) DEFAULT NULL,
  `sub_platform` varchar(255) DEFAULT NULL,
  `tower_level` varchar(255) DEFAULT NULL,
  `vip` varchar(255) DEFAULT NULL,
  `money` varchar(255) DEFAULT NULL,
  `zeny` varchar(255) DEFAULT NULL,
  `total_recharge` varchar(255) DEFAULT NULL,
  `ban_date` datetime DEFAULT NULL,
  `ban_chat_date` datetime DEFAULT NULL,
  `last_recharge_time` datetime DEFAULT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

CREATE TABLE `role_log` (
  `uid` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `sub_type` varchar(255) DEFAULT NULL,
  `log_date` datetime DEFAULT NULL,
  `old_val` varchar(255) DEFAULT NULL,
  `new_val` varchar(255) DEFAULT NULL,
  `delta_val` varchar(255) DEFAULT NULL,
  `param` varchar(255) DEFAULT NULL,
  `strparam` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

CREATE TABLE `role_msg` (
  `uid` varchar(255) NOT NULL,
  `target_uid` varchar(255) DEFAULT NULL,
  `msg_type` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `msg_date` datetime DEFAULT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

CREATE TABLE `role_order_list` (
  `uid` varchar(255) NOT NULL,
  `rmb` int(11) DEFAULT NULL,
  `reward_list` varchar(255) DEFAULT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `order_date` varchar(255) DEFAULT NULL,
  `goods_type` varchar(255) DEFAULT NULL,
  `goods_id` varchar(255) DEFAULT NULL,
  `sdk_order_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

CREATE TABLE `server_online_log` (
  `server_id` int(11) NOT NULL,
  `server_sub_id` varchar(255) DEFAULT NULL,
  `log_date` date DEFAULT NULL,
  `online_num` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;