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

`isappenter` tinyint(3) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '微端登录' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `role_id`  (`role_id`)
)
COMMENT='登录日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_task` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`task_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '任务id' ,
`log_type` tinyint(3) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '日志类型 0-接收 1-完成' ,
`role_lv` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家等级' ,
`task_type` tinyint(3) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '任务类型' ,
`task_name` varchar(60) NOT NULL  DEFAULT ''  COMMENT '任务名' ,
`task_lev` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '任务等级' ,
`atime` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '任务接收时间(没什么用)' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '记录时间' ,
PRIMARY KEY (`id`),
INDEX `task_id`  (`task_id`),
INDEX `role_id`  (`role_id`)
)
COMMENT='任务日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_activity_op` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`aid` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '活动id' ,
`type` tinyint(3) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作类型 1-开启 2-结束 3-发奖励 4-清数据' ,
`start_time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '开始时间' ,
`end_time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '结束时间' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '时间' ,
PRIMARY KEY (`id`)
)
COMMENT='运营活动日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_advance` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`sys_type` int(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '进阶系统类型' ,
`operate_type` int(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作类型' ,
`target_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '目标ID' ,
`old_value` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧值' ,
`new_value` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作时间' ,
PRIMARY KEY (`id`),
INDEX `role_id`  (`role_id`)
)
COMMENT='进阶系统操作日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_market` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`sell_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '摊主id' ,
`buy_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '买主id' ,
`base_id` int(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '购买的物品' ,
`num` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '数量' ,
`price` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '价格' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作时间' ,
PRIMARY KEY (`id`),
INDEX `base_id`  (`base_id`),
INDEX `buy_id`  (`buy_id`),
INDEX `sell_id`  (`sell_id`)
)
COMMENT='市场购买日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_market_request` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`buy_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '买主id' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作时间' ,
`num` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '数量' ,
`base_id` int(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '购买的物品' ,
`price` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '价格' ,
`sell_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '发布求购玩家id' ,
PRIMARY KEY (`id`),
INDEX `base_id`  (`base_id`),
INDEX `buy_id`  (`buy_id`),
INDEX `id`  (`id`)
)
COMMENT='求购出售日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_sword_up` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`old_lv` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧值' ,
`new_lv` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新值' ,
`new_exp` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作时间' ,
PRIMARY KEY (`id`),
INDEX `role_id`  (`role_id`)