ca2.0.6 -- ja++0.70.sql

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

# cAthena v2.0.4~2.0.6 -----> Jathena++ v0.70


# =====================================================
# 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';
ALTER TABLE `cart_inventory` ADD `sp_lv` int(11) 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`;


# =====================================================
# 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';
ALTER TABLE `guild_storage` ADD `sp_lv` int(11) NOT NULL default '0';


# =====================================================
# 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';
ALTER TABLE `inventory` ADD `sp_lv` int(11) 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 : `memo`
# -----------------------------------------------------
ALTER TABLE `memo` ADD `type` char(1) NOT NULL DEFAULT '' AFTER `char_id` ;
ALTER TABLE `memo` CHANGE `x` `x` mediumint(9) NOT NULL default '-1' ;
ALTER TABLE `memo` CHANGE `y` `y` mediumint(9) NOT NULL default '-1' ;


# =====================================================
# 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';
ALTER TABLE `storage` ADD `sp_lv` int(11) NOT NULL default '0';

# =====================================================
# Table : `status_change`
# -----------------------------------------------------
CREATE TABLE `status_change` (
  `char_id` int(11) NOT NULL default '0',
  `account_id` int(11) NOT NULL default '0',
  `type` mediumint(9) NOT NULL default '0',
  `val1` int(11) NOT NULL default '0',
  `val2` int(11) NOT NULL default '0',
  `val3` int(11) NOT NULL default '0',
  `val4` int(11) NOT NULL default '0',
  `tick` int(11) NOT NULL default '0',
  KEY `char_id` (`char_id`)
) TYPE=MyISAM;