diff options
| author | shennetsind <ind@henn.et> | 2013-02-14 17:04:42 -0200 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-02-14 17:15:36 -0200 |
| commit | 810ba40b78087cc6aa7eb9ad3a3e46534393b9e8 (patch) | |
| tree | e205d88bc02194101fc2a7aa2d80e5d884fe8a9c /sql-files/upgrades/upgrade_svn17080.sql | |
| parent | 20abc4a94a4bd3a7428c042cc6d1c313272fbc28 (diff) | |
| download | hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.tar.gz hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.tar.bz2 hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.tar.xz hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.zip | |
Introducing MySQL DB Update Checker
First version.
Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files/upgrades/upgrade_svn17080.sql')
| -rw-r--r-- | sql-files/upgrades/upgrade_svn17080.sql | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/sql-files/upgrades/upgrade_svn17080.sql b/sql-files/upgrades/upgrade_svn17080.sql deleted file mode 100644 index cfbe5dfe0..000000000 --- a/sql-files/upgrades/upgrade_svn17080.sql +++ /dev/null @@ -1,16 +0,0 @@ -CREATE TABLE IF NOT EXISTS `interreg` ( - `varname` varchar(11) NOT NULL, - `value` varchar(20) NOT NULL, - PRIMARY KEY (`varname`) -) ENGINE=InnoDB; -INSERT INTO `interreg` (`varname`, `value`) VALUES -('nsiuid', '0'); - -ALTER TABLE `auction` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0'; -ALTER TABLE `cart_inventory` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0'; -ALTER TABLE `guild_storage` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0'; -ALTER TABLE `inventory` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0'; -ALTER TABLE `mail` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0'; -ALTER TABLE `storage` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0'; - -ALTER TABLE `picklog` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0' AFTER `card3`; |