summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
diff options
context:
space:
mode:
authormarkzd <markzd@54d463be-8e91-2dee-dedb-b68131a5f0ec>2013-01-08 05:31:06 +0000
committermarkzd <markzd@54d463be-8e91-2dee-dedb-b68131a5f0ec>2013-01-08 05:31:06 +0000
commit5d1712c1483dd106d067256db5728c41e0676177 (patch)
treeaf54c995977893556d030f7ee75398a76d6bb895 /sql-files/upgrades
parenteaf2728d7f5b47e316b07608cb264bc8de2dd4cc (diff)
downloadhercules-5d1712c1483dd106d067256db5728c41e0676177.tar.gz
hercules-5d1712c1483dd106d067256db5728c41e0676177.tar.bz2
hercules-5d1712c1483dd106d067256db5728c41e0676177.tar.xz
hercules-5d1712c1483dd106d067256db5728c41e0676177.zip
* Renaming variable name from nsiuid to unique_id for better understanding of its meaning, as requested on tid:69380.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17086 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrades')
-rw-r--r--sql-files/upgrades/upgrade_svn17086.sql11
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..b61511b98
--- /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