v0.45-v0.46.sql

来自「JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-」· SQL 代码 · 共 38 行

# Jathena++ v0.45-v0.46 upgrade sql-script


# =====================================================
# Table : `cart_inventory`
# -----------------------------------------------------
ALTER TABLE `cart_inventory` CHANGE `card0` `card0` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `card1` `card1` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `card2` `card2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `cart_inventory` CHANGE `card3` `card3` int(11) unsigned NOT NULL default '0';


# =====================================================
# Table : `guild_storage`
# -----------------------------------------------------
ALTER TABLE `guild_storage` CHANGE `card0` `card0` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `card1` `card1` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `card2` `card2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `guild_storage` CHANGE `card3` `card3` int(11) unsigned NOT NULL default '0';


# =====================================================
# Table : `inventory`
# -----------------------------------------------------
ALTER TABLE `inventory` CHANGE `card0` `card0` int(11) unsigned NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `card1` `card1` int(11) unsigned NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `card2` `card2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `inventory` CHANGE `card3` `card3` int(11) unsigned NOT NULL default '0';


# =====================================================
# Table : `storage`
# -----------------------------------------------------
ALTER TABLE `storage` CHANGE `card0` `card0` int(11) unsigned NOT NULL default '0';
ALTER TABLE `storage` CHANGE `card1` `card1` int(11) unsigned NOT NULL default '0';
ALTER TABLE `storage` CHANGE `card2` `card2` int(11) unsigned NOT NULL default '0';
ALTER TABLE `storage` CHANGE `card3` `card3` int(11) unsigned NOT NULL default '0';