summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn1863.sql
diff options
context:
space:
mode:
authorDracoRPG <DracoRPG@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-04-02 23:31:51 +0000
committerDracoRPG <DracoRPG@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-04-02 23:31:51 +0000
commit4b83ab5aa37c6c61ae7bfe1e92d20894d00844d4 (patch)
tree8bd834a15368ca23f3d380121ce2b4d69828b23c /sql-files/upgrade_svn1863.sql
parent05cb73e9caeddfb27729ad1d1652bb7bbfeba27e (diff)
downloadhercules-4b83ab5aa37c6c61ae7bfe1e92d20894d00844d4.tar.gz
hercules-4b83ab5aa37c6c61ae7bfe1e92d20894d00844d4.tar.bz2
hercules-4b83ab5aa37c6c61ae7bfe1e92d20894d00844d4.tar.xz
hercules-4b83ab5aa37c6c61ae7bfe1e92d20894d00844d4.zip
Spring cleaning in sql-files/
Officialized a very small bit of the wedding NPC git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10133 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn1863.sql')
-rw-r--r--sql-files/upgrade_svn1863.sql7
1 files changed, 0 insertions, 7 deletions
diff --git a/sql-files/upgrade_svn1863.sql b/sql-files/upgrade_svn1863.sql
deleted file mode 100644
index f4b1b4910..000000000
--- a/sql-files/upgrade_svn1863.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-ALTER TABLE item_db ADD `refineable` tinyint(1) default NULL AFTER `equip_level`;
-ALTER TABLE item_db2 ADD `refineable` tinyint(1) default NULL AFTER `equip_level`;
-UPDATE item_db SET refineable=1 where type=4 or type=5;
-UPDATE item_db2 SET refineable=1 where type=4 or type=5;
-UPDATE item_db SET refineable = 0 where id = 1243 OR id = 1530 OR id = 2110 OR id = 2112 OR id = 2250 OR id = 2253 OR id = 2264 OR id = 2271 OR id = 2279 OR id = 2282 OR id = 2289 OR id = 2290 OR id = 2293 OR id = 2298 OR id = 2352 OR id = 2410 OR id = 2413 OR id = 2414 OR id = 2509 OR id = 2510 OR id = 5008 OR id = 5015 OR id = 5037 OR id = 5039 OR id = 5046 OR id = 5049 OR id = 5050 OR id = 5053 OR id = 5055 OR id = 5058 OR id = 5098;
-UPDATE item_db SET refineable = 0 where equip_locations = 513 OR equip_locations = 512 OR equip_locations = 136 OR equip_locations = 1;
-UPDATE item_db2 SET refineable = 0 where equip_locations = 513 OR equip_locations = 512 OR equip_locations = 136 OR equip_locations = 1;