diff options
author | AzerothCoreBot <azerothcorebot@gmail.com> | 2022-02-04 23:39:05 +0000 |
---|---|---|
committer | AzerothCoreBot <azerothcorebot@gmail.com> | 2022-02-04 23:39:05 +0000 |
commit | 7b041946e163224cb82ba85e734c9a757fa4209f (patch) | |
tree | 1b82141f9d35f4b38362701047e4734d686acbef | |
parent | de13bf426e162ee10cbd5470cec74122d1d4afa0 (diff) |
chore(DB): import pending files
Referenced commit(s): de13bf426e162ee10cbd5470cec74122d1d4afa0
-rw-r--r-- | acore.json | 2 | ||||
-rw-r--r-- | data/sql/updates/db_world/2022_02_04_13.sql | 31 | ||||
-rw-r--r-- | data/sql/updates/pending_db_world/rev_1643662892603722900.sql | 5 | ||||
-rw-r--r-- | doc/changelog/master.md | 123 | ||||
-rw-r--r-- | doc/changelog/pendings/changes_1643570355041139200.md | 118 |
5 files changed, 155 insertions, 124 deletions
diff --git a/acore.json b/acore.json index 53d890f32f..b1f8f06c21 100644 --- a/acore.json +++ b/acore.json @@ -1,5 +1,5 @@ { "name": "azerothcore-wotlk", - "version": "6.0.0-dev.0", + "version": "6.0.0-dev.1", "license": "AGPL3" } diff --git a/data/sql/updates/db_world/2022_02_04_13.sql b/data/sql/updates/db_world/2022_02_04_13.sql new file mode 100644 index 0000000000..89f0f90da6 --- /dev/null +++ b/data/sql/updates/db_world/2022_02_04_13.sql @@ -0,0 +1,31 @@ +-- DB update 2022_02_04_12 -> 2022_02_04_13 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT COUNT(*) INTO @COLEXISTS +FROM information_schema.COLUMNS +WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2022_02_04_12'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2022_02_04_12 2022_02_04_13 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1643662892603722900'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1643662892603722900'); + +UPDATE `creature_template` SET `RegenHealth` = 0 WHERE `RegenHealth` >= 2; +UPDATE `creature_onkill_reputation` SET `IsTeamAward1` = 0 WHERE `IsTeamAward1` >= 2; +UPDATE `creature_onkill_reputation` SET `IsTeamAward2` = 0 WHERE `IsTeamAward2` >= 2; + +-- +-- END UPDATING QUERIES +-- +UPDATE version_db_world SET date = '2022_02_04_13' WHERE sql_rev = '1643662892603722900'; +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1643662892603722900.sql b/data/sql/updates/pending_db_world/rev_1643662892603722900.sql deleted file mode 100644 index 5f530983db..0000000000 --- a/data/sql/updates/pending_db_world/rev_1643662892603722900.sql +++ /dev/null @@ -1,5 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1643662892603722900'); - -UPDATE `creature_template` SET `RegenHealth` = 0 WHERE `RegenHealth` >= 2; -UPDATE `creature_onkill_reputation` SET `IsTeamAward1` = 0 WHERE `IsTeamAward1` >= 2; -UPDATE `creature_onkill_reputation` SET `IsTeamAward2` = 0 WHERE `IsTeamAward2` >= 2; diff --git a/doc/changelog/master.md b/doc/changelog/master.md index 2cb63fffdb..d808c18f92 100644 --- a/doc/changelog/master.md +++ b/doc/changelog/master.md @@ -1,3 +1,126 @@ +## 6.0.0-dev.1 | Commit: [de13bf426e162ee10cbd5470cec74122d1d4afa0 +](https://github.com/azerothcore/azerothcore-wotlk/commit/de13bf426e162ee10cbd5470cec74122d1d4afa0 + + +## How to upgrade +- `PrepareStatment` + +```diff +- setNull(...) ++ SetData(...) +``` +```diff +- setBool(...) ++ SetData(...) +``` +```diff +- setUInt8(...) ++ SetData(...) +``` +```diff +- setInt8(...) ++ SetData(...) +``` +```diff +- setUInt16(...) ++ SetData(...) +``` +```diff +- setInt16(...) ++ SetData(...) +``` +```diff +- setUInt32(...) ++ SetData(...) +``` +```diff +- setUInt64(...) ++ SetData(...) +``` +```diff +- setInt64(...) ++ SetData(...) +``` +```diff +- setFloat(...) ++ SetData(...) +``` +```diff +- setDouble(...) ++ SetData(...) +``` +```diff +- setString(...) ++ SetData(...) +``` +```diff +- setStringView(...) ++ SetData(...) +``` +```diff +- setBinary(...) ++ SetData(...) +``` + +- `Fields` + +```diff +- GetBool() ++ Get<bool>() +``` +```diff +- GetUInt8() ++ Get<uint8>() +``` +```diff +- GetInt8() ++ Get<int8>() +``` +```diff +- GetUInt16() ++ Get<uint16>() +``` +```diff +- GetInt16() ++ Get<int16>() +``` +```diff +- GetUInt32() ++ Get<uint32>() +``` +```diff +- GetInt32() ++ Get<int32>() +``` +```diff +- GetUInt64() ++ Get<uint64>() +``` +```diff +- GetInt64() ++ Get<int64>() +``` +```diff +- GetFloat() ++ Get<float>() +``` +```diff +- GetDouble() ++ Get<double>() +``` +```diff +- GetString() ++ Get<std::string>() +``` +```diff +- GetStringView() ++ Get<std::string_view>() +``` +```diff +- GetBinary() ++ Get<Binary>() +``` + ## 5.0.0-dev.1 | Commit: [8b7df23f064f8c1c41aea222342b53f109c4e3b9 ](https://github.com/azerothcore/azerothcore-wotlk/commit/8b7df23f064f8c1c41aea222342b53f109c4e3b9 diff --git a/doc/changelog/pendings/changes_1643570355041139200.md b/doc/changelog/pendings/changes_1643570355041139200.md deleted file mode 100644 index 1e2f018488..0000000000 --- a/doc/changelog/pendings/changes_1643570355041139200.md +++ /dev/null @@ -1,118 +0,0 @@ -## How to upgrade -- `PrepareStatment` - -```diff -- setNull(...) -+ SetData(...) -``` -```diff -- setBool(...) -+ SetData(...) -``` -```diff -- setUInt8(...) -+ SetData(...) -``` -```diff -- setInt8(...) -+ SetData(...) -``` -```diff -- setUInt16(...) -+ SetData(...) -``` -```diff -- setInt16(...) -+ SetData(...) -``` -```diff -- setUInt32(...) -+ SetData(...) -``` -```diff -- setUInt64(...) -+ SetData(...) -``` -```diff -- setInt64(...) -+ SetData(...) -``` -```diff -- setFloat(...) -+ SetData(...) -``` -```diff -- setDouble(...) -+ SetData(...) -``` -```diff -- setString(...) -+ SetData(...) -``` -```diff -- setStringView(...) -+ SetData(...) -``` -```diff -- setBinary(...) -+ SetData(...) -``` - -- `Fields` - -```diff -- GetBool() -+ Get<bool>() -``` -```diff -- GetUInt8() -+ Get<uint8>() -``` -```diff -- GetInt8() -+ Get<int8>() -``` -```diff -- GetUInt16() -+ Get<uint16>() -``` -```diff -- GetInt16() -+ Get<int16>() -``` -```diff -- GetUInt32() -+ Get<uint32>() -``` -```diff -- GetInt32() -+ Get<int32>() -``` -```diff -- GetUInt64() -+ Get<uint64>() -``` -```diff -- GetInt64() -+ Get<int64>() -``` -```diff -- GetFloat() -+ Get<float>() -``` -```diff -- GetDouble() -+ Get<double>() -``` -```diff -- GetString() -+ Get<std::string>() -``` -```diff -- GetStringView() -+ Get<std::string_view>() -``` -```diff -- GetBinary() -+ Get<Binary>() -``` |