summaryrefslogblamecommitdiff
path: root/sql-files/upgrade_svn13370_inventory.sql
blob: dc4d5ff8a805b3f13e374c0ca73dffb5db008b66 (plain) (tree)
1
2
3
4
5
6





                                                                                             
-- Creates expire_time column on Inventory

ALTER TABLE `inventory` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cart_inventory` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `storage` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `guild_storage` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';