v0.55-v0.55fix1.sql

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

# Jathena++ v0.55-v0.55fix1 upgrade sql-script

update `cart_inventory` set `broken`='0' where `broken`<0;
update `cart_inventory` set `lockid`='0';
update `cart_inventory` set `exp`='0';
update `cart_inventory` set `endurance`='0';
update `cart_inventory` set `max_endurance`='0';

update `guild_storage` set `broken`='0' where `broken`<0;
update `guild_storage` set `lockid`='0';
update `guild_storage` set `exp`='0';
update `guild_storage` set `endurance`='0';
update `guild_storage` set `max_endurance`='0';

update `inventory` set `broken`='0' where `broken`<0;
update `inventory` set `lockid`='0';
update `inventory` set `exp`='0';
update `inventory` set `endurance`='0';
update `inventory` set `max_endurance`='0';

update `storage` set `broken`='0' where `broken`<0;
update `storage` set `lockid`='0';
update `storage` set `exp`='0';
update `storage` set `endurance`='0';
update `storage` set `max_endurance`='0';