查看日志: sanguobw_test_5/log/dbinitlog_2025_8_20.txt

`goods_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '物品id' ,
`goods_name` varchar(32) NOT NULL  DEFAULT ''  COMMENT '物品名字' ,
`goods_num` 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_produce_charm` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_charm` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧魅力值' ,
`new_charm` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新魅力值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '产出类型' ,
PRIMARY KEY (`id`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='魅力值产出日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_charm` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_charm` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧魅力值' ,
`new_charm` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新魅力值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`consume_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消耗类型' ,
PRIMARY KEY (`id`),
INDEX `consume_type`  (`consume_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='魅力值消耗日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_svip` (
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_charm` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧魅力值,废弃' ,
`new_charm` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新魅力值,废弃' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`real_name` varchar(20) NOT NULL  DEFAULT ''  COMMENT '姓名' ,
`phone` varchar(20) NOT NULL  DEFAULT ''  COMMENT '电话' ,
`sex` tinyint(1) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '性别' ,
`qq` varchar(20) NOT NULL  DEFAULT ''  COMMENT 'qq' ,
`birthday` varchar(20) NOT NULL  DEFAULT ''  COMMENT '生日' ,
`address` varchar(100) NOT NULL  DEFAULT ''  COMMENT '地址' ,
PRIMARY KEY (`role_id`),
INDEX `time`  (`time`)
)
COMMENT='超级会员日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_f_soul` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧魂魄值' ,
`new_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新魂魄值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '产出类型' ,
PRIMARY KEY (`id`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='凌云臂魂值产出日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_f_soul` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧魂魄值' ,
`new_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新魂魄值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`consume_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消耗类型' ,
PRIMARY KEY (`id`),
INDEX `consume_type`  (`consume_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='凌云臂魂值消耗日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_intimacy` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_intimacy` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧亲密度值' ,
`new_intimacy` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新亲密度值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '产出类型' ,
PRIMARY KEY (`id`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='亲密度值产出日志'