首页 > sangguo_zone > sanguobw_test_5/log/dbinitlog_2025_8_20.txt

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

总行数: 1812 当前页: 2/19
下载完整日志 
INDEX `consume_type`  (`consume_type`)
)
COMMENT='铜钱消费日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_gold` (
`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 '玩家等级' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费时间' ,
`consume_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费类型，1为购买' ,
`cost_gold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消耗元宝' ,
`cost_bgold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消耗绑定元宝' ,
`remain_gold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '元宝余额' ,
`remain_bgold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '绑定元宝余额' ,
`type_str` varchar(60) NOT NULL  DEFAULT ''  COMMENT '类型字符串' ,
`spent` int(11) NOT NULL  DEFAULT '0'  COMMENT '' ,
`pf` varchar(255) NOT NULL  DEFAULT ''  COMMENT '注册平台' ,
`currentpf` varchar(255) NOT NULL  DEFAULT ''  COMMENT '消费时平台' ,
`createtime` int(11) NOT NULL  DEFAULT '0'  COMMENT '注册时间' ,
`openid` varchar(100) NOT NULL  DEFAULT ''  COMMENT '账号' ,
`ilevel` int(11) NOT NULL  DEFAULT '0'  COMMENT '角色等级' ,
`zoneid` int(11) NOT NULL  DEFAULT '0'  COMMENT '角色等级' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `role_id`  (`role_id`),
INDEX `consume_type`  (`consume_type`)
)
COMMENT='元宝消费日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_gold` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产时间' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产类型' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`role_lv` int(6) NOT NULL  DEFAULT '0'  COMMENT '玩家等级' ,
`got_gold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产金币' ,
`got_bgold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产银两' ,
`remain_gold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '金币余额' ,
`remain_bgold` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '银两余额' ,
`type_str` varchar(60) NOT NULL  DEFAULT ''  COMMENT '类型字符串' ,
`spent` int(11) NOT NULL  DEFAULT '0'  COMMENT '' ,
`pf` varchar(255) NOT NULL  DEFAULT ''  COMMENT '注册平台' ,
`currentpf` varchar(255) NOT NULL  DEFAULT ''  COMMENT '消费时平台' ,
`createtime` int(11) NOT NULL  DEFAULT '0'  COMMENT '注册时间' ,
`openid` varchar(100) NOT NULL  DEFAULT ''  COMMENT '账号' ,
`ilevel` int(11) NOT NULL  DEFAULT '0'  COMMENT '角色等级' ,
`zoneid` int(11) NOT NULL  DEFAULT '0'  COMMENT '角色等级' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `role_id`  (`role_id`),
INDEX `produce_type`  (`produce_type`)
)
COMMENT='元宝生产日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_coin` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产时间' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产类型' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`role_lv` int(6) NOT NULL  DEFAULT '0'  COMMENT '玩家等级' ,
`got_coin` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产铜钱' ,
`got_bcoin` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产绑定的铜钱' ,
`remain_coin` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '铜钱余额' ,
`remain_bcoin` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '绑定的铜钱余额' ,
`type_str` varchar(60) NOT NULL  DEFAULT ''  COMMENT '类型字符串' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `role_id`  (`role_id`),
INDEX `produce_type`  (`produce_type`)
)
COMMENT='铜钱生产日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_uplv` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`lv` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '等级' ,
`exp` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '当前经验' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '升级时间' ,
PRIMARY KEY (`id`),
INDEX `lv`  (`lv`),
INDEX `role_id`  (`role_id`)
)
COMMENT='玩家升级日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_login` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`ip` varchar(100) NOT NULL  DEFAULT ''  COMMENT '登录IP' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '登录时间' ,
`vip` tinyint(3) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT 'vip等级' ,