diff options
| author | brianluau <brianluau@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2013-01-08 09:31:58 +0000 |
|---|---|---|
| committer | brianluau <brianluau@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2013-01-08 09:31:58 +0000 |
| commit | 8b05b9b81972cb95bf3cc8bb0e1f5dc9d2368756 (patch) | |
| tree | c77c12bb4cc93044286268b400bf8ca8917234f7 /sql-files/upgrades/upgrade_svn17086.sql | |
| parent | 5d1712c1483dd106d067256db5728c41e0676177 (diff) | |
| download | hercules-8b05b9b81972cb95bf3cc8bb0e1f5dc9d2368756.tar.gz hercules-8b05b9b81972cb95bf3cc8bb0e1f5dc9d2368756.tar.bz2 hercules-8b05b9b81972cb95bf3cc8bb0e1f5dc9d2368756.tar.xz hercules-8b05b9b81972cb95bf3cc8bb0e1f5dc9d2368756.zip | |
- Added svn:eol-style=native property.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17087 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrades/upgrade_svn17086.sql')
| -rw-r--r-- | sql-files/upgrades/upgrade_svn17086.sql | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/sql-files/upgrades/upgrade_svn17086.sql b/sql-files/upgrades/upgrade_svn17086.sql index b61511b98..3ba53e9ba 100644 --- a/sql-files/upgrades/upgrade_svn17086.sql +++ b/sql-files/upgrades/upgrade_svn17086.sql @@ -1,11 +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';
-
+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 |