diff options
| author | Trojal <trojal@gmail.com> | 2013-01-10 20:09:39 -0800 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-01-12 05:56:35 -0200 |
| commit | c55855fcf627478f864c0f82a1a2f201fd407a38 (patch) | |
| tree | b7f6d11b2058248d026f2d9944e8f4b6ac288d50 /sql-files/upgrades/upgrade_svn17086.sql | |
| parent | 51bfeb38eb139e97e0e1c096c85c15fba234f35b (diff) | |
| parent | 38e583df21eccd9e4f31d38acaae32579c6f0d27 (diff) | |
| download | hercules-c55855fcf627478f864c0f82a1a2f201fd407a38.tar.gz hercules-c55855fcf627478f864c0f82a1a2f201fd407a38.tar.bz2 hercules-c55855fcf627478f864c0f82a1a2f201fd407a38.tar.xz hercules-c55855fcf627478f864c0f82a1a2f201fd407a38.zip | |
Test1, testing for the commit widget, need to edit something.
Test2, testing for the commit widget, need to edit something.
Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files/upgrades/upgrade_svn17086.sql')
| -rw-r--r-- | sql-files/upgrades/upgrade_svn17086.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql-files/upgrades/upgrade_svn17086.sql b/sql-files/upgrades/upgrade_svn17086.sql new file mode 100644 index 000000000..3ba53e9ba --- /dev/null +++ b/sql-files/upgrades/upgrade_svn17086.sql @@ -0,0 +1,11 @@ +UPDATE `interreg` SET `varname` = 'unique_id' WHERE `interreg`.`varname` = 'nsiuid'; + + +ALTER TABLE `auction` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; +ALTER TABLE `cart_inventory` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; +ALTER TABLE `guild_storage` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; +ALTER TABLE `inventory` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; +ALTER TABLE `mail` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; +ALTER TABLE `storage` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; + +ALTER TABLE `picklog` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0';
\ No newline at end of file |