diff options
| author | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2007-03-02 00:11:54 +0000 |
|---|---|---|
| committer | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2007-03-02 00:11:54 +0000 |
| commit | 572e2c0dcc4e124136f9ad4bc493184e917e8f63 (patch) | |
| tree | f93861924f9b03e10feb005e21eb51672693e545 /sql-files/upgrade_svn1863.sql | |
| parent | f9b1682603fee23ba36ff04fbdc303dd0b7cf0ef (diff) | |
| download | hercules-572e2c0dcc4e124136f9ad4bc493184e917e8f63.tar.gz hercules-572e2c0dcc4e124136f9ad4bc493184e917e8f63.tar.bz2 hercules-572e2c0dcc4e124136f9ad4bc493184e917e8f63.tar.xz hercules-572e2c0dcc4e124136f9ad4bc493184e917e8f63.zip | |
EOL-styled some more files
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9947 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn1863.sql')
| -rw-r--r-- | sql-files/upgrade_svn1863.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/sql-files/upgrade_svn1863.sql b/sql-files/upgrade_svn1863.sql index 367dd44ea..f4b1b4910 100644 --- a/sql-files/upgrade_svn1863.sql +++ b/sql-files/upgrade_svn1863.sql @@ -1,7 +1,7 @@ -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;
+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; |