summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn13370_inventory.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/upgrade_svn13370_inventory.sql')
-rw-r--r--sql-files/upgrade_svn13370_inventory.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn13370_inventory.sql b/sql-files/upgrade_svn13370_inventory.sql
new file mode 100644
index 000000000..dc4d5ff8a
--- /dev/null
+++ b/sql-files/upgrade_svn13370_inventory.sql
@@ -0,0 +1,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';