xa -- ja++0.70.sql

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

# Xathena -----> Jathena v0.70


# =====================================================
# Table : `cart_inventory`
# -----------------------------------------------------
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 `card0` `card0` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `card1` `card1` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `card2` `card2` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `card3` `card3` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `broken` `broken` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` ADD `lockid` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` ADD `exp` int(11) NOT NULL default '0';
ALTER TABLE `cart_inventory` ADD `endurance` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` ADD `max_endurance` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` ADD `sp_lv` int(11) NOT NULL default '0';


# =====================================================
# Table : `char`
# -----------------------------------------------------
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 `base_exp` `base_exp` bigint(20) NOT NULL default '0';
ALTER TABLE `char` CHANGE `job_exp` `job_exp` bigint(20) NOT NULL default '0';
ALTER TABLE `char` CHANGE `zeny` `zeny` int(11) NOT NULL default '500';
ALTER TABLE `char` CHANGE `status_point` `status_point` int(11) NOT NULL default '0';
ALTER TABLE `char` CHANGE `skill_point` `skill_point` 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 `last_map` `last_map` varchar(20) NOT NULL default 'new_1-1.gat';
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_map` `save_map` varchar(20) NOT NULL default 'new_1-1.gat';
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';
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 `homun_id` `homun_id` int(11) NOT NULL default '0';


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


# =====================================================
# Table : `friend`
# -----------------------------------------------------
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';


# =====================================================
# Table : `global_reg_value`
# -----------------------------------------------------
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';


# =====================================================
# Table : `guild`
# -----------------------------------------------------
ALTER TABLE `guild` CHANGE `guild_id` `guild_id` int(11) NOT NULL default '10000';
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 `exp` `exp` int(11) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `next_exp` `next_exp` int(11) 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_id` `emblem_id` int(11) NOT NULL default '0';
ALTER TABLE `guild` CHANGE `emblem_data` `emblem_data` blob NOT NULL;


# =====================================================
# Table : `guild_alliance`
# -----------------------------------------------------
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';


# =====================================================
# Table : `guild_castle`
# -----------------------------------------------------
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 `nextTime` `nextTime` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `payTime` `payTime` int(11) NOT NULL default '0';
ALTER TABLE `guild_castle` CHANGE `createTime` `createTime` 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';


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


# =====================================================
# Table : `guild_member`
# -----------------------------------------------------
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 `exp` `exp` bigint(20) NOT NULL default '0';
ALTER TABLE `guild_member` CHANGE `exp_payper` `exp_payper` int(11) NOT NULL default '0';


# =====================================================
# Table : `guild_skill`
# -----------------------------------------------------
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';


# =====================================================