diff options
Diffstat (limited to 'sql-files/upgrade_svn13370_inventory.sql')
-rw-r--r-- | sql-files/upgrade_svn13370_inventory.sql | 6 |
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';
|