v0.44-v0.45.sql

JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-

# Jathena++ v0.44-v0.45 upgrade sql-script
# Jathena v1925(or later) - Jathena++ v0.45 sql-script


# =====================================================
# Table : `cart_inventory`
# -----------------------------------------------------
ALTER TABLE `cart_inventory` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;
ALTER TABLE `cart_inventory` CHANGE `char_id` `char_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `nameid` `nameid` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `amount` `amount` int(11) unsigned NOT NULL default '0';


# =====================================================
# Table : `char`
# -----------------------------------------------------
ALTER TABLE `char` CHANGE `char_id` `char_id` int(11) unsigned NOT NULL auto_increment;
ALTER TABLE `char` CHANGE `account_id` `account_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `char_num` `char_num` tinyint(4) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `class` `class` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `zeny` `zeny` int(11) unsigned NOT NULL default '500';
ALTER TABLE `char` CHANGE `max_hp` `max_hp` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `hp` `hp` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `max_sp` `max_sp` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `sp` `sp` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `party_id` `party_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `guild_id` `guild_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `pet_id` `pet_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `hair` `hair` tinyint(4) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `hair_color` `hair_color` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `clothes_color` `clothes_color` tinyint(4) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `weapon` `weapon` int(11) unsigned NOT NULL default '1';
ALTER TABLE `char` CHANGE `shield` `shield` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `head_top` `head_top` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `head_mid` `head_mid` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `head_bottom` `head_bottom` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `last_x` `last_x` tinyint(4) unsigned NOT NULL default '53';
ALTER TABLE `char` CHANGE `last_y` `last_y` tinyint(4) unsigned NOT NULL default '111';
ALTER TABLE `char` CHANGE `save_x` `save_x` tinyint(4) unsigned NOT NULL default '53';
ALTER TABLE `char` CHANGE `save_y` `save_y` tinyint(4) unsigned NOT NULL default '111';
ALTER TABLE `char` CHANGE `partner_id` `partner_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `parent_id` `parent_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `parent_id2` `parent_id2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `baby_id` `baby_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `online` `online` tinyint(4) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `homun_id` `homun_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `base_level` `base_level` tinyint(4) unsigned NOT NULL default '1';
ALTER TABLE `char` CHANGE `job_level` `job_level` tinyint(4) unsigned NOT NULL default '1';
ALTER TABLE `char` CHANGE `base_exp` `base_exp` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `job_exp` `job_exp` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `last_map` `last_map` varchar(20) NOT NULL default 'new_1-1.gat';
ALTER TABLE `char` CHANGE `save_map` `save_map` varchar(20) NOT NULL default 'new_1-1.gat';


# =====================================================
# Table : `charlog`
# -----------------------------------------------------
ALTER TABLE `charlog` ADD `id` bigint(20) unsigned NOT NULL;
ALTER TABLE `charlog` ADD PRIMARY KEY (`id`);
ALTER TABLE `charlog` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;


# =====================================================
# Table : `friend`
# -----------------------------------------------------
ALTER TABLE `friend` CHANGE `char_id` `char_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `friend` CHANGE `id1` `id1` int(11) unsigned NOT NULL default '0';
ALTER TABLE `friend` CHANGE `id2` `id2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `friend` CHANGE `name` `name` varchar(255) NOT NULL default '';


# =====================================================
# Table : `global_reg_value`
# -----------------------------------------------------
ALTER TABLE `global_reg_value` CHANGE `account_id` `account_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `global_reg_value` CHANGE `char_id` `char_id` int(11) unsigned NOT NULL default '0';


# =====================================================
# Table : `guild`
# -----------------------------------------------------
ALTER TABLE `guild` CHANGE `guild_id` `guild_id` int(11) unsigned NOT NULL default '10000';
ALTER TABLE `guild` CHANGE `guild_lv` `guild_lv` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `connect_member` `connect_member` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `max_member` `max_member` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `average_lv` `average_lv` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `exp` `exp` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `next_exp` `next_exp` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `skill_point` `skill_point` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `emblem_len` `emblem_len` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `emblem_id` `emblem_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild` CHANGE `name` `name` varchar(255) NOT NULL default '';
ALTER TABLE `guild` CHANGE `master` `master` varchar(255) NOT NULL default '';
ALTER TABLE `guild` CHANGE `mes1` `mes1` varchar(255) NOT NULL default '';
ALTER TABLE `guild` CHANGE `mes2` `mes2` varchar(255) NOT NULL default '';


# =====================================================
# Table : `guild_alliance`
# -----------------------------------------------------
ALTER TABLE `guild_alliance` CHANGE `guild_id` `guild_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_alliance` CHANGE `alliance_id` `alliance_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_alliance` CHANGE `name` `name` varchar(255) NOT NULL default '';


# =====================================================
# Table : `guild_castle`
# -----------------------------------------------------
ALTER TABLE `guild_castle` CHANGE `castle_id` `castle_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `guild_id` `guild_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `economy` `economy` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `defense` `defense` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `triggerE` `triggerE` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `triggerD` `triggerD` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleC` `visibleC` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG0` `visibleG0` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG1` `visibleG1` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG2` `visibleG2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG3` `visibleG3` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG4` `visibleG4` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG5` `visibleG5` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG6` `visibleG6` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `visibleG7` `visibleG7` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP0` `gHP0` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP1` `gHP1` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP2` `gHP2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP3` `gHP3` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP4` `gHP4` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP5` `gHP5` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP6` `gHP6` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `gHP7` `gHP7` int(11) unsigned NOT NULL default '0';


# =====================================================
# Table : `guild_expulsion`
# -----------------------------------------------------
ALTER TABLE `guild_expulsion` CHANGE `guild_id` `guild_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_expulsion` CHANGE `account_id` `account_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_expulsion` CHANGE `name` `name` varchar(255) NOT NULL default '';
ALTER TABLE `guild_expulsion` CHANGE `mes` `mes` varchar(255) NOT NULL default '';
ALTER TABLE `guild_expulsion` CHANGE `acc` `acc` varchar(255) NOT NULL default '';


# =====================================================
# Table : `guild_member`
# -----------------------------------------------------
ALTER TABLE `guild_member` CHANGE `guild_id` `guild_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `account_id` `account_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `char_id` `char_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `hair` `hair` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `hair_color` `hair_color` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `gender` `gender` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `class` `class` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `lv` `lv` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `exp` `exp` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `online` `online` tinyint(4) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `position` `position` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `name` `name` varchar(255) NOT NULL default '';


# =====================================================
# Table : `guild_position`
# -----------------------------------------------------
ALTER TABLE `guild_position` CHANGE `guild_id` `guild_id` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_position` CHANGE `position` `position` smallint(6) unsigned NOT NULL default '0';
ALTER TABLE `guild_position` CHANGE `mode` `mode` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_position` CHANGE `exp_mode` `exp_mode` int(11) unsigned NOT NULL default '0';