summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAzerothCoreBot <azerothcorebot@gmail.com>2022-02-04 23:39:05 +0000
committerAzerothCoreBot <azerothcorebot@gmail.com>2022-02-04 23:39:05 +0000
commit7b041946e163224cb82ba85e734c9a757fa4209f (patch)
tree1b82141f9d35f4b38362701047e4734d686acbef
parentde13bf426e162ee10cbd5470cec74122d1d4afa0 (diff)
chore(DB): import pending files
Referenced commit(s): de13bf426e162ee10cbd5470cec74122d1d4afa0
-rw-r--r--acore.json2
-rw-r--r--data/sql/updates/db_world/2022_02_04_13.sql31
-rw-r--r--data/sql/updates/pending_db_world/rev_1643662892603722900.sql5
-rw-r--r--doc/changelog/master.md123
-rw-r--r--doc/changelog/pendings/changes_1643570355041139200.md118
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>()
-```