查看日志: sanguobw_test_2/log/dbinitlog_2025_8_13.txt

dbtools start run in [{{2025,8,13},{17,35,34}}]

CREATE TABLE IF NOT EXISTS `node` (
`gs_type` varchar(20) NOT NULL  DEFAULT ''  COMMENT '启动类型' ,
`ip` varchar(50) NOT NULL  DEFAULT ''  COMMENT 'ip地址' ,
`port` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '端口号' ,
`node` varchar(100) NOT NULL  DEFAULT ''  COMMENT '节点' ,
`cookie` varchar(100) NULL  DEFAULT ''  COMMENT 'cookie' ,
PRIMARY KEY (`gs_type`)
)
COMMENT='节点'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `role_login` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`zone_aid` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '分区唯一Id' ,
`zone_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '区服id' ,
`account` varchar(100) NOT NULL  DEFAULT ''  COMMENT '平台账户' ,
`pf` varchar(255) NOT NULL  DEFAULT ''  COMMENT '配置平台标识' ,
`reg_time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '注册时间' ,
`reg_ip` varchar(30) NOT NULL  DEFAULT ''  COMMENT '注册IP' ,
`reg_pf` varchar(255) NOT NULL  DEFAULT ''  COMMENT '注册平台' ,
`source` varchar(100) NOT NULL  DEFAULT ''  COMMENT '渠道来源' ,
`rollmark` tinyint(1) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '滚服标识,0-否，1-是' ,
`is_market` tinyint(1) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '是否集市用户，0-否，1-是' ,
`app_custom` varchar(100) NOT NULL  DEFAULT ''  COMMENT 'app_custom' ,
`via` varchar(100) NOT NULL  DEFAULT ''  COMMENT 'via' ,
`province_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '省份id' ,
`reg_channel` varchar(255) NOT NULL  DEFAULT ''  COMMENT '注冊渠道' ,
`device_id` varchar(255) NOT NULL  DEFAULT ''  COMMENT '设备号' ,
`dispense` varchar(255) NOT NULL  DEFAULT ''  COMMENT '分发号' ,
`device_type` tinyint(1) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '设备类型' ,
PRIMARY KEY (`id`),
INDEX `reg_ip`  (`reg_ip`),
INDEX `reg_time`  (`reg_time`),
INDEX `account`  (`account`),
INDEX `zone_index`  (`account`,`zone_aid`)
)
COMMENT='玩家登陆信息'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `role` (
`id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT 'id' ,
`name` varchar(32) NOT NULL  DEFAULT ''  COMMENT '姓名' ,
`first_charge_time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '上次充值时间' ,
`last_charge_time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '最后一次充值时间' ,
PRIMARY KEY (`id`),
INDEX `last_charge_time`  (`last_charge_time`),
INDEX `first_charge_time`  (`first_charge_time`),
INDEX `name`  (`name`)
)
COMMENT='玩家信息，给后台显示用'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `zj_user` (
`id` int(11) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`accname` varchar(60) NOT NULL  DEFAULT ''  COMMENT '帐号' ,
`password` varchar(60) NOT NULL  DEFAULT ''  COMMENT '密码' ,
`create_time` int(11) NOT NULL  DEFAULT '0'  COMMENT '创建时间' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `username`  (`accname`)
)
COMMENT='专家表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_item_use` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`role_lv` int(6) NOT NULL  DEFAULT '0'  COMMENT '玩家等级' ,
`type` smallint(6) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '类型' ,
`item_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '物品ID' ,
`item_num` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '物品数量' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '时间' ,
`type_str` varchar(60) NOT NULL  DEFAULT ''  COMMENT '类型字符串' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `item_id`  (`item_id`),
INDEX `role_id`  (`role_id`)
)
COMMENT='物品使用日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_item` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`role_lv` int(6) NOT NULL  DEFAULT '0'  COMMENT '玩家等级' ,
`type` smallint(6) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '类型' ,
`item_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '物品类型ID' ,
`item_num` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '物品数量' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '产出时间' ,
`type_str` varchar(60) NOT NULL  DEFAULT ''  COMMENT '类型字符串' ,
PRIMARY KEY (`id`),
INDEX `role_id`  (`role_id`),
INDEX `item_id`  (`item_id`),
INDEX `type`  (`type`),