📄 v0.54-v0.55.sql
字号:
#==========================================================================
# fix some problems
#--------------------------------------------------------------------------
UPDATE `char` SET `base_exp` = 0 WHERE `base_exp`>=9223372036854775807;
ALTER TABLE `char` CHANGE `base_exp` `base_exp` bigint(20) NOT NULL default '0';
UPDATE `char` SET `job_exp` = 0 WHERE `job_exp`>=9223372036854775807;
ALTER TABLE `char` CHANGE `job_exp` `job_exp` bigint(20) NOT NULL default '0';
ALTER TABLE `char` CHANGE `last_x` `last_x` int(11) NOT NULL default '53';
ALTER TABLE `char` CHANGE `last_y` `last_y` int(11) NOT NULL default '111';
ALTER TABLE `char` CHANGE `save_x` `save_x` int(11) NOT NULL default '53';
ALTER TABLE `char` CHANGE `save_y` `save_y` int(11) NOT NULL default '111';
UPDATE `guild_member` SET `exp` = 0 WHERE `exp`>=9223372036854775807;
ALTER TABLE `guild_member` CHANGE `exp` `exp` bigint(20) NOT NULL default '0';
UPDATE `guild` SET `exp` = 0 WHERE `exp`>=2147483647;
ALTER TABLE `guild` CHANGE `exp` `exp` int(11) NOT NULL default '0';
UPDATE `guild` SET `next_exp` = 0 WHERE `next_exp`>=2147483647;
ALTER TABLE `guild` CHANGE `next_exp` `next_exp` int(11) NOT NULL default '0';
UPDATE `homunculus` SET `base_exp` = 0 WHERE `base_exp`>=9223372036854775807;
ALTER TABLE `homunculus` CHANGE `base_exp` `base_exp` bigint(20) NOT NULL default '0';
#==========================================================================
# change some columns
#--------------------------------------------------------------------------
ALTER TABLE `cart_inventory` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `nameid` `nameid` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `amount` `amount` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `exp` `exp` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `char_id` `char_id` int(11) NOT NULL auto_increment;
ALTER TABLE `char` CHANGE `account_id` `account_id` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `char_num` `char_num` tinyint(4) NOT NULL default '0';
ALTER TABLE `char` CHANGE `class` `class` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `base_level` `base_level` bigint(20) unsigned NOT NULL default '1';
ALTER TABLE `char` CHANGE `job_level` `job_level` bigint(20) unsigned NOT NULL default '1';
ALTER TABLE `char` CHANGE `zeny` `zeny` int(11) NOT NULL default '500';
ALTER TABLE `char` CHANGE `max_hp` `max_hp` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `hp` `hp` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `max_sp` `max_sp` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `sp` `sp` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `party_id` `party_id` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `pet_id` `pet_id` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `hair` `hair` tinyint(4) NOT NULL default '0';
ALTER TABLE `char` CHANGE `hair_color` `hair_color` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `clothes_color` `clothes_color` tinyint(4) NOT NULL default '0';
ALTER TABLE `char` CHANGE `weapon` `weapon` int(11) NOT NULL default '1';
ALTER TABLE `char` CHANGE `shield` `shield` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `head_top` `head_top` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `head_mid` `head_mid` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `head_bottom` `head_bottom` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `partner_id` `partner_id` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `parent_id` `parent_id` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `parent_id2` `parent_id2` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `baby_id` `baby_id` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `online` `online` tinyint(4) NOT NULL default '0';
ALTER TABLE `char` CHANGE `homun_id` `homun_id` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `friend` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `friend` CHANGE `id1` `id1` int(11) NOT NULL default '0';
ALTER TABLE `friend` CHANGE `id2` `id2` int(11) NOT NULL default '0';
ALTER TABLE `friend` CHANGE `name` `name` varchar(24) NOT NULL default '';
ALTER TABLE `global_reg_value` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `global_reg_value` CHANGE `account_id` `account_id` int(11) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '10000';
ALTER TABLE `guild` CHANGE `name` `name` varchar(24) NOT NULL default '';
ALTER TABLE `guild` CHANGE `master` `master` varchar(24) NOT NULL default '';
ALTER TABLE `guild` CHANGE `guild_lv` `guild_lv` smallint(6) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `connect_member` `connect_member` smallint(6) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `max_member` `max_member` smallint(6) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `average_lv` `average_lv` smallint(6) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `skill_point` `skill_point` int(11) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `mes1` `mes1` varchar(60) NOT NULL default '';
ALTER TABLE `guild` CHANGE `mes2` `mes2` varchar(120) NOT NULL default '';
ALTER TABLE `guild` CHANGE `emblem_len` `emblem_len` int(11) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `emblem_id` `emblem_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_alliance` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_alliance` CHANGE `alliance_id` `alliance_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_alliance` CHANGE `name` `name` varchar(24) NOT NULL default '';
ALTER TABLE `guild_castle` CHANGE `castle_id` `castle_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `economy` `economy` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `defense` `defense` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `triggerE` `triggerE` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `triggerD` `triggerD` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleC` `visibleC` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG0` `visibleG0` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG1` `visibleG1` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG2` `visibleG2` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG3` `visibleG3` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG4` `visibleG4` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG5` `visibleG5` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG6` `visibleG6` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG7` `visibleG7` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP0` `gHP0` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP1` `gHP1` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP2` `gHP2` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP3` `gHP3` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP4` `gHP4` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP5` `gHP5` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP6` `gHP6` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP7` `gHP7` int(11) NOT NULL default '0';
ALTER TABLE `guild_expulsion` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_expulsion` CHANGE `name` `name` varchar(24) NOT NULL default '';
ALTER TABLE `guild_expulsion` CHANGE `mes` `mes` varchar(40) NOT NULL default '';
ALTER TABLE `guild_expulsion` CHANGE `acc` `acc` varchar(40) NOT NULL default '';
ALTER TABLE `guild_expulsion` CHANGE `account_id` `account_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `account_id` `account_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `hair` `hair` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `hair_color` `hair_color` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `gender` `gender` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `class` `class` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `lv` `lv` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `online` `online` tinyint(4) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `position` `position` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `name` `name` varchar(24) NOT NULL default '';
ALTER TABLE `guild_position` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_position` CHANGE `position` `position` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_position` CHANGE `name` `name` varchar(24) NOT NULL default '';
ALTER TABLE `guild_position` CHANGE `mode` `mode` int(11) NOT NULL default '0';
ALTER TABLE `guild_position` CHANGE `exp_mode` `exp_mode` int(11) NOT NULL default '0';
ALTER TABLE `guild_skill` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_skill` CHANGE `id` `id` int(11) NOT NULL default '0';
ALTER TABLE `guild_skill` CHANGE `lv` `lv` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `nameid` `nameid` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `amount` `amount` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `identify` `identify` smallint(6) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `exp` `exp` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `homun_id` `homun_id` int(11) NOT NULL auto_increment;
ALTER TABLE `homunculus` CHANGE `class` `class` mediumint(9) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `account_id` `account_id` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `base_level` `base_level` tinyint(4) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `max_hp` `max_hp` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `hp` `hp` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `max_sp` `max_sp` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `sp` `sp` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `intimate` `intimate` mediumint(9) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `hungry` `hungry` mediumint(9) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `rename_flag` `rename_flag` tinyint(4) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `incubate` `incubate` int(11) NOT NULL default '0';
ALTER TABLE `homunculus_skill` CHANGE `homun_id` `homun_id` int(11) NOT NULL default '0';
ALTER TABLE `homunculus_skill` CHANGE `id` `id` int(11) NOT NULL default '0';
ALTER TABLE `homunculus_skill` CHANGE `lv` `lv` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `nameid` `nameid` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `amount` `amount` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `identify` `identify` smallint(6) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `exp` `exp` int(11) NOT NULL default '0';
ALTER TABLE `login` CHANGE `account_id` `account_id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `login` CHANGE `logincount` `logincount` mediumint(9) NOT NULL default '0';
ALTER TABLE `login_error` CHANGE `err_id` `err_id` int(11) NOT NULL default '0';
ALTER TABLE `loginlog` CHANGE `user` `user` varchar(32) NOT NULL default '';
ALTER TABLE `memo` CHANGE `memo_id` `memo_id` int(11) NOT NULL auto_increment;
ALTER TABLE `memo` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `memo` CHANGE `x` `x` mediumint(9) NOT NULL default '0';
ALTER TABLE `memo` CHANGE `y` `y` mediumint(9) NOT NULL default '0';
ALTER TABLE `party` CHANGE `party_id` `party_id` int(11) NOT NULL default '100';
ALTER TABLE `party` CHANGE `exp` `exp` int(11) NOT NULL default '0';
ALTER TABLE `party` CHANGE `item` `item` int(11) NOT NULL default '0';
ALTER TABLE `party` CHANGE `leader_id` `leader_id` int(11) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `pet_id` `pet_id` int(11) NOT NULL auto_increment;
ALTER TABLE `pet` CHANGE `class` `class` mediumint(9) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `account_id` `account_id` int(11) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `level` `level` tinyint(4) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `egg_id` `egg_id` int(11) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `intimate` `intimate` mediumint(9) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `hungry` `hungry` mediumint(9) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `rename_flag` `rename_flag` tinyint(4) NOT NULL default '0';
ALTER TABLE `pet` CHANGE `incubate` `incubate` int(11) NOT NULL default '0';
ALTER TABLE `ragsrvinfo` CHANGE `index` `index` int(11) NOT NULL default '0';
ALTER TABLE `ragsrvinfo` CHANGE `exp` `exp` int(11) NOT NULL default '0';
ALTER TABLE `ragsrvinfo` CHANGE `jexp` `jexp` int(11) NOT NULL default '0';
ALTER TABLE `skill` CHANGE `char_id` `char_id` int(11) NOT NULL default '0';
ALTER TABLE `skill` CHANGE `id` `id` int(11) NOT NULL default '0';
ALTER TABLE `skill` CHANGE `lv` `lv` tinyint(4) NOT NULL default '0';
ALTER TABLE `sstatus` CHANGE `index` `index` tinyint(4) NOT NULL default '0';
ALTER TABLE `sstatus` CHANGE `user` `user` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `account_id` `account_id` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `nameid` `nameid` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `amount` `amount` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `identify` `identify` smallint(6) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `exp` `exp` int(11) NOT NULL default '0';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -