ca2.0.2 -- ja++0.57.sql

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

# cAthena v2.0.2 -----> Jathena++ v0.57


# =====================================================
# Table : `cart_inventory`
# -----------------------------------------------------
ALTER TABLE `cart_inventory` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;
ALTER TABLE `cart_inventory` DROP `durable` , DROP `max_durable` , DROP `lockid`;
ALTER TABLE `cart_inventory` CHANGE `index` `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';


# =====================================================
# Table : `char`
# -----------------------------------------------------
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 `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 `str` `str` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `agi` `agi` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `vit` `vit` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `int` `int` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `dex` `dex` int(11) unsigned NOT NULL default '0';
ALTER TABLE `char` CHANGE `luk` `luk` int(11) 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 `last_x` `last_x` int(11) NOT NULL default '53';
ALTER TABLE `char` CHANGE `save_map` `save_map` varchar(20) NOT NULL default 'new_1-1.gat';
ALTER TABLE `char` DROP `viplevel`;
ALTER TABLE `char` ADD `homun_id` int(11) NOT NULL default '0';
ALTER TABLE `char` ADD INDEX (`account_id`);
ALTER TABLE `char` ADD INDEX (`name`);


# =====================================================
# Table : `charlog`
# -----------------------------------------------------
ALTER TABLE `charlog` CHANGE `id` `id` bigint(20) unsigned NOT NULL;
ALTER TABLE `charlog` DROP PRIMARY KEY;
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 `name` `name` varchar(24) NOT NULL default '';


# =====================================================
# Table : `global_reg_value`
# -----------------------------------------------------
ALTER TABLE `global_reg_value` CHANGE `value` `value` varchar(255) NOT NULL default '0';


# =====================================================
# Table : `guild`
# -----------------------------------------------------
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 `mes1` `mes1` varchar(60) NOT NULL default '';
ALTER TABLE `guild` CHANGE `mes2` `mes2` varchar(120) NOT NULL default '';


# =====================================================
# Table : `guild_alliance`
# -----------------------------------------------------
ALTER TABLE `guild_alliance` CHANGE `name` `name` varchar(24) NOT NULL default '';


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


# =====================================================
# Table : `guild_member`
# -----------------------------------------------------
ALTER TABLE `guild_member` CHANGE `name` `name` varchar(24) NOT NULL default '';


# =====================================================
# Table : `guild_position`
# -----------------------------------------------------
ALTER TABLE `guild_position` CHANGE `name` `name` varchar(24) NOT NULL default '';


# =====================================================
# Table : `guild_storage`
# -----------------------------------------------------
ALTER TABLE `guild_storage` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;
ALTER TABLE `guild_storage` DROP `durable` , DROP `max_durable` , DROP `lockid`;
ALTER TABLE `guild_storage` CHANGE `index` `broken` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `guild_storage` ADD `lockid` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_storage` ADD `exp` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` ADD `endurance` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_storage` ADD `max_endurance` int(11) unsigned NOT NULL default '0';


# ========================================================
# Create Table : `homunculus`
# --------------------------------------------------------
CREATE TABLE `homunculus` (
  `homun_id` int(11) NOT NULL auto_increment,
  `class` mediumint(9) NOT NULL default '0',
  `name` varchar(24) NOT NULL default '',
  `account_id` int(11) NOT NULL default '0',
  `char_id` int(11) NOT NULL default '0',
  `base_level` tinyint(4) NOT NULL default '0',
  `base_exp` bigint(20) NOT NULL default '0',
  `max_hp` int(11) NOT NULL default '0',
  `hp` int(11) NOT NULL default '0',
  `max_sp` int(11) NOT NULL default '0',
  `sp` int(11) NOT NULL default '0',
  `str` int(11) unsigned NOT NULL default '0',
  `agi` int(11) unsigned NOT NULL default '0',
  `vit` int(11) unsigned NOT NULL default '0',
  `int` int(11) unsigned NOT NULL default '0',
  `dex` int(11) unsigned NOT NULL default '0',
  `luk` int(11) unsigned NOT NULL default '0',
  `status_point` int(11) NOT NULL default '0',
  `skill_point` int(11) NOT NULL default '0',
  `equip` mediumint(8) unsigned NOT NULL default '0',
  `intimate` mediumint(9) NOT NULL default '0',
  `hungry` mediumint(9) NOT NULL default '0',
  `rename_flag` tinyint(4) NOT NULL default '0',
  `incubate` int(11) NOT NULL default '0',
  PRIMARY KEY  (`homun_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `homunculus_skill`
# --------------------------------------------------------
CREATE TABLE `homunculus_skill` (
  `homun_id` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL default '0',
  `lv` int(11) NOT NULL default '0',
  KEY `homun_id` (`homun_id`)
) TYPE=MyISAM;


# =====================================================
# Table : `interlog`
# -----------------------------------------------------
ALTER TABLE `interlog` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;


# =====================================================
# Table : `inventory`
# -----------------------------------------------------
ALTER TABLE `inventory` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;
ALTER TABLE `inventory` DROP `durable` , DROP `max_durable` , DROP `lockid`;
ALTER TABLE `inventory` CHANGE `index` `broken` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `inventory` ADD `lockid` int(11) unsigned NOT NULL default '0';
ALTER TABLE `inventory` ADD `exp` int(11) NOT NULL default '0';
ALTER TABLE `inventory` ADD `endurance` int(11) unsigned NOT NULL default '0';
ALTER TABLE `inventory` ADD `max_endurance` int(11) unsigned NOT NULL default '0';


# =====================================================
# Table : `login`
# -----------------------------------------------------
ALTER TABLE `login` CHANGE `account_id` `account_id` int(11) NOT NULL auto_increment;
ALTER TABLE `login` CHANGE `userid` `userid` varchar(255) NOT NULL default '';
ALTER TABLE `login` DROP `paytime` , DROP `paypoint` , DROP `online`;
ALTER TABLE `login` CHANGE `email` `email` varchar(60) NOT NULL default '';
ALTER TABLE `login` CHANGE `level` `level` smallint(3) NOT NULL default '0';
ALTER TABLE `login` CHANGE `last_ip` `last_ip` varchar(100) NOT NULL default '';
ALTER TABLE `login` CHANGE `regdate` `reg_date` datetime NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `login` ADD PRIMARY KEY(`account_id`);


# =====================================================
# Table : `loginlog`
# -----------------------------------------------------
ALTER TABLE `loginlog` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;
ALTER TABLE `loginlog` CHANGE `log` `log` varchar(255) NOT NULL default '';


# =====================================================
# Table : `pet`
# -----------------------------------------------------
ALTER TABLE `pet` CHANGE `incuvate` `incubate` int(11) NOT NULL default '0';


# =====================================================
# Table : `ragsrvinfo`
# -----------------------------------------------------
ALTER TABLE `ragsrvinfo` CHANGE `text1` `motd` varchar(255) NOT NULL default '';
ALTER TABLE `ragsrvinfo` DROP `type` , DROP `text2` , DROP `text3` , DROP `text4`;


# =====================================================
# Table : `storage`
# -----------------------------------------------------
ALTER TABLE `storage` CHANGE `id` `id` bigint(20) unsigned NOT NULL auto_increment;
ALTER TABLE `storage` DROP `durable` , DROP `max_durable` , DROP `lockid`;
ALTER TABLE `storage` CHANGE `index` `broken` bigint(20) unsigned NOT NULL default '0';
ALTER TABLE `storage` ADD `lockid` int(11) unsigned NOT NULL default '0';
ALTER TABLE `storage` ADD `exp` int(11) NOT NULL default '0';
ALTER TABLE `storage` ADD `endurance` int(11) unsigned NOT NULL default '0';
ALTER TABLE `storage` ADD `max_endurance` int(11) unsigned NOT NULL default '0';