查看日志: sanguobw_test_8/log/dbinitlog_2025_8_20.txt
总行数: 1812
当前页: 1/19
dbtools start run in [{{2025,8,20},{13,42,51}}]
CREATE TABLE IF NOT EXISTS `node` (
`gs_type` varchar(20) NOT NULL DEFAULT '' COMMENT '启动类型' ,
`ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'ip地址' ,
`port` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '端口号' ,
`node` varchar(100) NOT NULL DEFAULT '' COMMENT '节点' ,
`cookie` varchar(100) NULL DEFAULT '' COMMENT 'cookie' ,
PRIMARY KEY (`gs_type`)
)
COMMENT='节点'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
ALTER TABLE `role_login` MODIFY COLUMN `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id';
alter table `role_login` add column `zone_aid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分区唯一Id' ;
alter table `role_login` add column `reg_channel` varchar(255) NOT NULL DEFAULT '' COMMENT '注冊渠道' ;
alter table `role_login` add column `device_id` varchar(255) NOT NULL DEFAULT '' COMMENT '设备号' ;
alter table `role_login` add column `dispense` varchar(255) NOT NULL DEFAULT '' COMMENT '分发号' ;
alter table `role_login` add column `device_type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '设备类型' ;
ALTER TABLE `role_login` DROP COLUMN `sid`;
ALTER TABLE `role_login` DROP INDEX `zone_unique`;
ALTER TABLE `role_login` ADD INDEX `zone_index` (`account`,`zone_aid`);
CREATE TABLE IF NOT EXISTS `role` (
`id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'id' ,
`name` varchar(32) NOT NULL DEFAULT '' COMMENT '姓名' ,
`first_charge_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上次充值时间' ,
`last_charge_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后一次充值时间' ,
PRIMARY KEY (`id`),
INDEX `last_charge_time` (`last_charge_time`),
INDEX `first_charge_time` (`first_charge_time`),
INDEX `name` (`name`)
)
COMMENT='玩家信息，给后台显示用'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `zj_user` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' ,
`accname` varchar(60) NOT NULL DEFAULT '' COMMENT '帐号' ,
`password` varchar(60) NOT NULL DEFAULT '' COMMENT '密码' ,
`create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `username` (`accname`)
)
COMMENT='专家表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_item_use` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' ,
`role_lv` int(6) NOT NULL DEFAULT '0' COMMENT '玩家等级' ,
`type` smallint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT '类型' ,
`item_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品ID' ,
`item_num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品数量' ,
`time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '时间' ,
`type_str` varchar(60) NOT NULL DEFAULT '' COMMENT '类型字符串' ,
PRIMARY KEY (`id`),
INDEX `time` (`time`),
INDEX `item_id` (`item_id`),
INDEX `role_id` (`role_id`)
)
COMMENT='物品使用日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_item` (
`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 '玩家等级' ,
`type` smallint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT '类型' ,
`item_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品类型ID' ,
`item_num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品数量' ,
`time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '产出时间' ,
`type_str` varchar(60) NOT NULL DEFAULT '' COMMENT '类型字符串' ,
PRIMARY KEY (`id`),
INDEX `role_id` (`role_id`),
INDEX `item_id` (`item_id`),
INDEX `type` (`type`),
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`),