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

`items` varchar(2000) NOT NULL  DEFAULT ''  COMMENT '物品' ,
`subject` varchar(500) NOT NULL  DEFAULT ''  COMMENT '邮件头' ,
`content` varchar(500) NOT NULL  DEFAULT ''  COMMENT '邮件内容' ,
`send_time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '发送时间' ,
PRIMARY KEY (`id`),
INDEX `send_time`  (`send_time`),
INDEX `rid2`  (`rid2`),
INDEX `rid1`  (`rid1`)
)
COMMENT='邮件日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_send_flower` (
`id` int(11) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '自增id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`role_name` varchar(32) NOT NULL  DEFAULT ''  COMMENT '玩家名字' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作时间' ,
`target_role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '被送玩家id' ,
`target_role_name` varchar(32) NOT NULL  DEFAULT ''  COMMENT '被送玩家名字' ,
`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 '消耗类型' ,