xa -- ja++0.70.sql

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

# Table : `guild_storage`
# -----------------------------------------------------
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 `card0` `card0` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `card1` `card1` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `card2` `card2` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `card3` `card3` int(11) NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `broken` `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 : `homunculus`
# -----------------------------------------------------
ALTER TABLE `homunculus` CHANGE `homun_id` `homun_id` int(11) NOT NULL auto_increment;
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 `base_exp` `base_exp` bigint(20) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `status_point` `status_point` int(11) NOT NULL default '0';
ALTER TABLE `homunculus` CHANGE `skill_point` `skill_point` 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 `incubate` `incubate` int(11) NOT NULL default '0';


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


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


# =====================================================
# Table : `inventory`
# -----------------------------------------------------
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 `card0` `card0` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `card1` `card1` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `card2` `card2` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `card3` `card3` int(11) NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `broken` `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 `level` `level` smallint(3) NOT NULL default '0';
ALTER TABLE `login` ADD `reg_date` datetime NOT NULL default '0000-00-00 00:00:00';
ALTER TABLE `login` ADD `ask` varchar(255) default NULL;
ALTER TABLE `login` ADD `answer` varchar(255) default NULL;


# =====================================================
# Table : `loginlog`
# -----------------------------------------------------
ALTER TABLE `loginlog` ADD `id` bigint(20) unsigned NOT NULL auto_increment PRIMARY KEY;
ALTER TABLE `loginlog` DROP `ip` , DROP `user` , DROP `rcode`;


# =====================================================
# Table : `memo`
# -----------------------------------------------------
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` 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 : `party`
# -----------------------------------------------------
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 `leader_id` `leader_id` int(11) NOT NULL default '0';


# =====================================================
# Table : `pet`
# -----------------------------------------------------
ALTER TABLE `pet` CHANGE `pet_id` `pet_id` int(11) NOT NULL auto_increment;
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 `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 `incubate` `incubate` int(11) NOT NULL default '0';


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


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


# =====================================================
# Table : `storage`
# -----------------------------------------------------
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 `card0` `card0` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `card1` `card1` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `card2` `card2` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `card3` `card3` int(11) NOT NULL default '0';
ALTER TABLE `storage` CHANGE `broken` `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;