Changeset 263 for trunk/sql

Timestamp:

Jul 25, 2009, 9:48:05 PM (15 years ago)

Author:

maron

Message:

Adresování změny struktury dbc podle buildnumber, oprava záměny verze 3.0.9 a 3.1.3

Location:

trunk/sql/updates

Files:

• 262.sql (modified) (1 diff)
• 263.sql (added)

trunk/sql/updates/262.sql

@@ -195 +195 @@
 UPDATE `wowpreklad`.`wow_client_version` SET `DBCColumns_Achievement` = 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu',
 `DBCColumns_Achievement_Category` = 'uusuuuuuuuuuuuuuuuuu',
-`DBCColumns_Achievement_Criteria` = 'uuuuuuuuusuuuuuuuuuuuuuuuuuu',
+`DBCColumns_Achievement_Criteria` = 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu',
 `Achievement_Name` = '4',
 `Achievement_Description` = '21',
 `Achievement_Reward` = '43',
 `Achievement_Category_Name` = '2',
-`Achievement_Criteria_Text` = '9' WHERE `wow_client_version`.`Id` =1 LIMIT 1 ;
+`Achievement_Criteria_Text` = '9' WHERE `wow_client_version`.`BuildNumber` =9947 LIMIT 1 ;