diff options
| author | Haru <haru@dotalux.com> | 2017-04-09 15:24:22 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-04-09 15:24:22 +0200 |
| commit | db5a1d0f714fa196e1c026ccb123ac7104af2f75 (patch) | |
| tree | e399edacc33de1a1954777d5ebfd9b1b6213367e /sql-files/upgrades/2017-03-05--08-09.sql | |
| parent | 083ed4ad7a30bdc3172b3ef2a66bb257c0c0e70f (diff) | |
| parent | 974222a8d3f189083205bf5d330de04a43226ad3 (diff) | |
| download | hercules-db5a1d0f714fa196e1c026ccb123ac7104af2f75.tar.gz hercules-db5a1d0f714fa196e1c026ccb123ac7104af2f75.tar.bz2 hercules-db5a1d0f714fa196e1c026ccb123ac7104af2f75.tar.xz hercules-db5a1d0f714fa196e1c026ccb123ac7104af2f75.zip | |
Merge pull request #1598 from Smokexyz/IRO
Implementation of Item Options System.
Diffstat (limited to 'sql-files/upgrades/2017-03-05--08-09.sql')
| -rw-r--r-- | sql-files/upgrades/2017-03-05--08-09.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql-files/upgrades/2017-03-05--08-09.sql b/sql-files/upgrades/2017-03-05--08-09.sql new file mode 100644 index 000000000..3b5ee1a23 --- /dev/null +++ b/sql-files/upgrades/2017-03-05--08-09.sql @@ -0,0 +1,15 @@ +#1488744559 + +ALTER TABLE `picklog` + ADD COLUMN `opt_idx0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `card3`, + ADD COLUMN `opt_val0` SMALLINT(5) NOT NULL DEFAULT '0' AFTER `opt_idx0`, + ADD COLUMN `opt_idx1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `opt_val0`, + ADD COLUMN `opt_val1` SMALLINT(5) NOT NULL DEFAULT '0' AFTER `opt_idx1`, + ADD COLUMN `opt_idx2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `opt_val1`, + ADD COLUMN `opt_val2` SMALLINT(5) NOT NULL DEFAULT '0' AFTER `opt_idx2`, + ADD COLUMN `opt_idx3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `opt_val2`, + ADD COLUMN `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0' AFTER `opt_idx3`, + ADD COLUMN `opt_idx4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `opt_val3`, + ADD COLUMN `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0' AFTER `opt_idx4`; + +INSERT INTO `sql_updates` (`timestamp`, `ignored`) VALUES (1488744559 , 'No'); |