首页 > sangguo_zone > sanguobw_test_2/log/dbinitlog_2025_8_13.txt

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

总行数: 1832 当前页: 2/19
下载完整日志 
INDEX `time`  (`time`)
)
COMMENT='物品产出日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_coin` (
`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_coin` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消耗铜钱' ,
`cost_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 `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
;