dms-api/app/process/CreateTables.php

<?php

namespace app\process;
use support\think\Db;
use Workerman\Crontab\Crontab;

/**
 * 建表
 */
class CreateTables
{
    public function onWorkerStart(): void
    {
        // 每天的0点10执行，注意这里省略了秒位
        new Crontab('10 0 * * *', function(){
            $this->initStart();
        });
    }

    protected function initStart()
    {
        echo "开始创建表\n";

        $centerTablesSqlList = [
            $this->base_total_day,
            $this->base_total_hour,
            $this->basic_active_day,
            $this->game_reg_pay_day
        ];

        foreach ($centerTablesSqlList as $sql){
            try {
                $year  = date('Y', strtotime('+1 year'));
                $month = date('Ym', strtotime('+1 month'));

                $sql = str_replace('{{YEAR}}', $year, $sql);
                $sql = str_replace('{{MONTH}}', $month, $sql);

                Db::connect("db_data_report")->execute($sql);
            }catch (\Exception $e){
                echo $e->getMessage();
            }
        }


        $logTablesSqlList = [
            $this->sdk_active_info,
            $this->sdk_reg_log,
            $this->sdk_login_log,
            $this->sdk_order,
            $this->role_log,
            $this->sdk_activate_log,
        ];

        foreach ($logTablesSqlList as $sql){
            try {
                $year  = date('Y', strtotime('+1 year'));
                $month = date('Ym', strtotime('+1 month'));

                $sql = str_replace('{{YEAR}}', $year, $sql);
                $sql = str_replace('{{MONTH}}', $month, $sql);

                Db::connect("db_game_log")->execute($sql);
            }catch (\Exception $e){
                echo $e->getMessage();
            }
        }
    }

    protected string $base_total_day = "CREATE TABLE IF NOT EXISTS `base_total_day_{{YEAR}}` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `tdate` date NOT NULL COMMENT '日期',
          `game_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '游戏ID',
          `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
          `agent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '渠道ID',
          `site_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告位ID',
          `auth_id` int(10) NOT NULL DEFAULT '0' COMMENT '负责人ID',
          `ad_show_pv` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告展示PV',
          `ad_show_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告展示IP',
          `ad_click_pv` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告安装PV',
          `ad_click_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告安装IP',
          `download` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下载数',
          `install` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装数',
          `install_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装IP',
          `reg_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册数',
          `reg_login_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '当天注册当天登陆用户数',
          `reg_dev` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册设备',
          `login_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登陆总数',
          `login_reg_game` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登陆数（注册游戏相同）',
          `old_login_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '老用户登陆',
          `role_create_user` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建角色用户数',
          `reg_pay_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册付费数',
          `reg_pay_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册付费金额',
          `reg_pay_amount` float unsigned NOT NULL DEFAULT '0' COMMENT '注册付费分成金额',
          `pay_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总用户数',
          `pay_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总金额',
          `pay_amount` float unsigned NOT NULL DEFAULT '0' COMMENT '付费分成总金额',
          `reg_pay_num_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册付费数（剔除跨游戏）',
          `reg_pay_total_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册付费金额（剔除跨游戏）',
          `reg_pay_amount_rg` float unsigned NOT NULL DEFAULT '0' COMMENT '注册付费分成金额（剔除跨游戏）',
          `pay_num_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总用户数（剔除跨游戏）',
          `pay_total_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总金额（剔除跨游戏）',
          `pay_amount_rg` float unsigned NOT NULL DEFAULT '0' COMMENT '付费分成总金额（剔除跨游戏）',
          PRIMARY KEY (`id`) USING BTREE,
          UNIQUE KEY `select_index` (`tdate`,`agent_id`,`site_id`,`game_id`) USING BTREE,
          KEY `agent_id` (`agent_id`) USING BTREE,
          KEY `site_id` (`site_id`) USING BTREE,
          KEY `game_id` (`game_id`) USING BTREE,
          KEY `auth_id` (`auth_id`) USING BTREE,
          KEY `media_id` (`media_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

    protected string $base_total_hour = "CREATE TABLE IF NOT EXISTS `base_total_hour_{{MONTH}}` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tdate` date NOT NULL COMMENT '日期',
  `thour` tinyint(3) unsigned NOT NULL COMMENT '小时',
  `game_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '游戏ID',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '渠道ID',
  `site_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告位ID',
  `auth_id` int(10) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `ad_show_pv` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告展示PV',
  `ad_show_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告展示IP',
  `ad_click_pv` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告安装PV',
  `ad_click_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告安装IP',
  `cost` decimal(14,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '消耗金额',
  `download` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下载数',
  `install` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装数',
  `install_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装IP',
  `reg_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册数',
  `reg_login_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册登陆用户',
  `reg_dev` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册设备',
  `login_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登陆总数',
  `login_reg_game` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登陆数（注册游戏相同）',
  `old_login_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '老用户登陆',
  `role_create_user` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建用户数',
  `reg_pay_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '小时注册当天付费数',
  `reg_pay_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '小时注册当天付费金额',
  `reg_pay_amount` float unsigned NOT NULL DEFAULT '0' COMMENT '小时注册当天分成金额',
  `reg_pay_num_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册累计付费数',
  `reg_pay_total_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册累计付费金额',
  `reg_pay_amount_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册累计分成金额',
  `pay_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总用户数',
  `pay_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总金额',
  `pay_amount` float unsigned NOT NULL DEFAULT '0' COMMENT '付费分成总金额',
  `pay_num_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总用户数（剔除跨游戏）',
  `pay_total_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费总金额（剔除跨游戏）',
  `pay_amount_rg` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付费分成总金额（剔除跨游戏）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `select_index` (`tdate`,`thour`,`agent_id`,`site_id`,`game_id`) USING BTREE,
  KEY `tdate` (`tdate`) USING BTREE,
  KEY `thour` (`thour`) USING BTREE,
  KEY `agent_id` (`agent_id`) USING BTREE,
  KEY `media_id` (`media_id`) USING BTREE,
  KEY `auth_id` (`auth_id`) USING BTREE,
  KEY `site_id` (`site_id`) USING BTREE,
  KEY `game_id` (`game_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

    protected string $game_reg_pay_day = "CREATE TABLE IF NOT EXISTS `game_reg_pay_day_{{YEAR}}` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `reg_date` varchar(10) NOT NULL COMMENT '注册日期',
  `pay_date` varchar(10) NOT NULL COMMENT '充值日期',
  `game_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '游戏ID',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '渠道ID',
  `site_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告位ID',
  `auth_id` int(10) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `pay_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '充值人数',
  `pay_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '充值金额',
  `pay_amount` float unsigned NOT NULL DEFAULT '0' COMMENT '付费金额（分成）',
  `addup_pay_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册累计付费',
  `addup_pay_total` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册累计付费金额',
  `addup_pay_amount` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册总充值(扣除分成)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `select_index` (`reg_date`,`pay_date`,`agent_id`,`site_id`,`game_id`) USING BTREE,
  KEY `reg_date` (`reg_date`) USING BTREE,
  KEY `pay_date` (`pay_date`) USING BTREE,
  KEY `agent_id` (`agent_id`) USING BTREE,
  KEY `site_id` (`site_id`) USING BTREE,
  KEY `media_id` (`media_id`) USING BTREE,
  KEY `auth_id` (`auth_id`) USING BTREE,
  KEY `game_id` (`game_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='注册充值统计';";

    protected string $basic_active_day = "CREATE TABLE IF NOT EXISTS `basic_active_day_{{YEAR}}` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tdate` date NOT NULL COMMENT '登录日期',
  `game_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '游戏ID',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '渠道ID',
  `site_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告位ID',
  `auth_id` int(10) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `reg_date` date NOT NULL COMMENT '日期',
  `active` int(10) unsigned NOT NULL COMMENT '活跃天数(0:当天)',
  `login_count` int(11) NOT NULL COMMENT '登录账号数',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `tdate` (`tdate`) USING BTREE,
  KEY `agent_id` (`agent_id`) USING BTREE,
  KEY `site_id` (`site_id`) USING BTREE,
  KEY `game_id` (`game_id`) USING BTREE,
  KEY `active` (`active`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户活跃统计';";

    protected string $sdk_active_info = "CREATE TABLE IF NOT EXISTS `sdk_active_log_{{MONTH}}` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tdate` date NOT NULL,
  `game_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '游戏ID',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '渠道ID',
  `site_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告位ID',
  `auth_id` int(10) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `user_name` varchar(50) NOT NULL,
  `uid` int(11) NOT NULL DEFAULT '0',
  `login_time` int(10) unsigned NOT NULL,
  `reg_time` int(10) unsigned NOT NULL,
  `active` int(11) NOT NULL DEFAULT '0' COMMENT '（登录减注册的天数）',
  PRIMARY KEY (`id`),
  UNIQUE KEY `tdate_2` (`game_id`,`tdate`,`uid`),
  KEY `tdate` (`tdate`),
  KEY `user_name` (`user_name`),
  KEY `uid` (`uid`),
  KEY `game_id` (`game_id`),
  KEY `agent_id` (`agent_id`),
  KEY `site_id` (`site_id`),
  KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户活跃表';";


    protected string $sdk_activate_log = "CREATE TABLE IF NOT EXISTS `sdk_activate_log_{{MONTH}}` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `game_id` int(11) NOT NULL COMMENT '游戏game_id',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '渠道id',
  `site_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '广告位id',
  `auth_id` int(11) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `imei` varchar(64) DEFAULT '' COMMENT 'imei/idfa',
  `oaid` varchar(128) DEFAULT '' COMMENT 'oaid/cid',
  `ip` varchar(128) NOT NULL DEFAULT '',
  `vt` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0:模拟器1:真机2:未知',
  `brand` varchar(32) DEFAULT '' COMMENT '品牌',
  `model` varchar(32) DEFAULT '' COMMENT '机型',
  `system_version` varchar(32) DEFAULT '' COMMENT '系统版本',
  `sdk_version` varchar(32) DEFAULT '' COMMENT 'sdk版本',
  `package_name` varchar(64) DEFAULT '' COMMENT '包名',
  PRIMARY KEY (`id`),
  KEY `imei` (`imei`),
  KEY `agent_id` (`agent_id`),
  KEY `game_id` (`game_id`),
  KEY `site_id` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='激活日志';";

    protected string $sdk_reg_log = "CREATE TABLE IF NOT EXISTS `sdk_reg_log_{{MONTH}}` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) DEFAULT '',
  `uid` bigint(20) NOT NULL DEFAULT '0',
  `game_id` int(11) NOT NULL COMMENT '游戏game_id',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '渠道id',
  `site_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '广告位id',
  `auth_id` int(11) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `reg_time` int(11) NOT NULL,
  `imei` varchar(64) DEFAULT '' COMMENT 'imei/idfa',
  `oaid` varchar(128) DEFAULT '' COMMENT 'oaid/cid',
  `ip` varchar(128) NOT NULL DEFAULT '',
  `ip_location` varchar(128) NOT NULL DEFAULT '',
  `vt` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0:模拟器1:真机2:未知',
  `brand` varchar(32) DEFAULT '' COMMENT '品牌',
  `model` varchar(32) DEFAULT '' COMMENT '机型',
  `system_version` varchar(32) DEFAULT '' COMMENT '系统版本',
  `sdk_version` varchar(32) DEFAULT '' COMMENT 'sdk版本',
  `package_name` varchar(64) DEFAULT '' COMMENT '包名',
  PRIMARY KEY (`id`),
  KEY `user_name` (`user_name`),
  KEY `imei` (`imei`),
  KEY `reg_time` (`reg_time`),
  KEY `agent_id` (`agent_id`),
  KEY `game_id` (`game_id`),
  KEY `site_id` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='注册日志';";

    protected string $sdk_login_log = "CREATE TABLE IF NOT EXISTS `sdk_login_log_{{MONTH}}` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) DEFAULT '',
  `uid` bigint(20) NOT NULL DEFAULT '0',
  `game_id` int(11) NOT NULL COMMENT '游戏game_id',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '渠道id',
  `site_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '广告位id',
  `auth_id` int(11) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `ip` varchar(128) NOT NULL DEFAULT '',
  `ip_location` varchar(128) NOT NULL DEFAULT '',
  `login_time` int(10) unsigned NOT NULL,
  `reg_time` int(10) unsigned NOT NULL,
  `imei` varchar(64) DEFAULT '' COMMENT 'imei/idfa',
  `oaid` varchar(128) DEFAULT '' COMMENT 'oaid/cid',
  `vt` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0:模拟器1:真机2:未知',
  `brand` varchar(32) DEFAULT '' COMMENT '品牌',
  `model` varchar(32) DEFAULT '' COMMENT '机型',
  `system_version` varchar(32) DEFAULT '' COMMENT '系统版本',
  `sdk_version` varchar(32) DEFAULT '' COMMENT 'sdk版本',
  `package_name` varchar(64) DEFAULT '' COMMENT '包名',
  PRIMARY KEY (`id`),
  KEY `user_name` (`user_name`),
  KEY `agent_id` (`agent_id`),
  KEY `game_id` (`game_id`),
  KEY `ip` (`ip`),
  KEY `login_time` (`login_time`),
  KEY `reg_time` (`reg_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录日志';";

    protected string $role_log = "CREATE TABLE IF NOT EXISTS `role_log_{{MONTH}}` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `game_id` int(11) NOT NULL COMMENT '游戏game_id',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `agent_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '渠道id',
  `site_id` int(10) unsigned NOT NULL DEFAULT '1000' COMMENT '广告位id',
  `auth_id` int(11) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `data_type` tinyint(4) NOT NULL COMMENT '调用时机:1选服 2创角 3进入 4升级 5退出',
  `server_id` int(11) NOT NULL COMMENT '服务器ID',
  `server_name` varchar(15) NOT NULL COMMENT '服务器名称',
  `user_name` varchar(30) NOT NULL COMMENT '用户账号',
  `uid` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` varchar(64) NOT NULL COMMENT '角色ID',
  `role_name` varchar(64) NOT NULL COMMENT '角色名',
  `role_level` int(11) NOT NULL COMMENT '角色等级',
  `ip` varchar(128) NOT NULL COMMENT 'IP',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`),
  KEY `game_id` (`game_id`),
  KEY `user_name` (`user_name`),
  KEY `uid` (`uid`),
  KEY `data_type` (`data_type`),
  KEY `role_id` (`role_id`),
  KEY `agent_id` (`agent_id`),
  KEY `site_id` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色日志';";

    protected string $sdk_order = "CREATE TABLE IF NOT EXISTS `sdk_order_{{MONTH}}` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(60) NOT NULL COMMENT '我方订单号',
  `trade_id` varchar(60) DEFAULT '' COMMENT '交易流水号',
  `cp_order_id` varchar(60) NOT NULL COMMENT '研发订单号',
  `ext` varchar(200) DEFAULT NULL COMMENT 'CP扩展参数',
  `pay_channel_id` smallint(6) DEFAULT '0' COMMENT '支付渠道ID',
  `money` float NOT NULL COMMENT '面额(元)',
  `paid_amount` float unsigned NOT NULL COMMENT '净额(元)',
  `game_id` int(11) NOT NULL DEFAULT '0',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '媒体ID',
  `auth_id` int(11) NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `agent_id` int(11) NOT NULL DEFAULT '0',
  `site_id` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL,
  `user_name` varchar(30) NOT NULL,
  `ip` varchar(128) NOT NULL DEFAULT '' COMMENT '用户IP',
  `server_id` int(11) NOT NULL,
  `server_name` varchar(20) DEFAULT '',
  `role_id` varchar(32) DEFAULT '',
  `role_name` varchar(32) DEFAULT '',
  `reg_date`  datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  `pay_date`  datetime DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `sync_date` datetime DEFAULT NULL COMMENT '支付通知时间',
  `sync_data` text COMMENT '支付回调信息',
  `sync_result` text COMMENT '第三方支付返回值',
  `sync_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '支付回调状态 0未支付, 1已支付, 2异常回调',
  `send_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '发货状态 0未发货, 1已发货',
  `other_data` varchar(1000) DEFAULT '' COMMENT '其他数据',
  `imei` varchar(64) DEFAULT '' COMMENT 'imei/idfa',
  `oaid` varchar(128) DEFAULT '' COMMENT 'oaid/cid',
  `brand` varchar(32) DEFAULT '' COMMENT '品牌',
  `model` varchar(32) DEFAULT '' COMMENT '手机型号',
  `system_version` varchar(32) DEFAULT '' COMMENT '系统版本',
  `sdk_version` varchar(32) DEFAULT '' COMMENT 'SDK版本',
  `product_id` varchar(64) DEFAULT NULL COMMENT '充值商品ID',
  `product_name` varchar(64) DEFAULT NULL COMMENT '充值商品名',
  `package_name` varchar(64) DEFAULT NULL COMMENT '包名',
  `reg_time` int(10) unsigned NOT NULL COMMENT '注册时间',
  `login_time` int(10) unsigned NOT NULL COMMENT '登录时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id` (`order_id`),
  KEY `uid` (`uid`),
  KEY `user_name` (`user_name`),
  KEY `trade_id` (`trade_id`),
  KEY `cp_order_id` (`cp_order_id`),
  KEY `game_id` (`game_id`),
  KEY `sync_status` (`sync_status`),
  KEY `send_status` (`send_status`),
  KEY `auth_id` (`auth_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单记录表';";


}