ja -- ja++0.57.sql

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

# Jathena -----> Jathena++ v0.57


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


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


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


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


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


# =====================================================
# Table : `login`
# -----------------------------------------------------
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 : `sstatus`
# -----------------------------------------------------
ALTER TABLE `sstatus` ADD PRIMARY KEY(`index`);


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