diff options
| author | Yehonal <yehonal.azeroth@gmail.com> | 2016-08-26 16:25:13 +0200 |
|---|---|---|
| committer | Yehonal <yehonal.azeroth@gmail.com> | 2016-08-26 16:25:13 +0200 |
| commit | a6db058f9006c09d56ce51daab439ca1f539635f (patch) | |
| tree | f0915422d3e7fb4ed3645478d5f9c586b3440755 | |
| parent | 0b34a24cf91040646741428ce86af6700d721df0 (diff) | |
removed templates for pending, we will find a more cleaner way for devs
4 files changed, 0 insertions, 115 deletions
diff --git a/data/sql/updates/README.md b/data/sql/updates/README.md index cf6ca24033..104608c572 100644 --- a/data/sql/updates/README.md +++ b/data/sql/updates/README.md @@ -1,3 +1,2 @@ Please read [this](https://github.com/azerothcore/azerothcore-wotlk/wiki/Dealing-with-SQL-files) before adding new SQL-update files. -Use template sql files present in this folder to build your update file diff --git a/data/sql/updates/pending_db_auth/template_for_auth_updates.txt b/data/sql/updates/pending_db_auth/template_for_auth_updates.txt deleted file mode 100644 index cea4ff0fe6..0000000000 --- a/data/sql/updates/pending_db_auth/template_for_auth_updates.txt +++ /dev/null @@ -1,38 +0,0 @@ -DROP PROCEDURE IF EXISTS `updateDb`; -DELIMITER // -CREATE PROCEDURE updateDb () -proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT "FALSE"; - --- ############################### --- CHANGE FOLLOWING VARIABLES --- ############################### - --- fill new_version with result of this bash command: date +%s%N --- you must run it for each sql updates -SET @new_version=""; --- set previous required version, or do not touch it if you are not sure -SET @req_version=NULL; - --- ############################### --- DO NOT CHANGE IT --- ############################### -SELECT sql_rev INTO OK FROM version_db_auth WHERE sql_rev = @new_version; IF OK <> "FALSE" THEN LEAVE proc; END IF; START TRANSACTION; INSERT INTO version_db_auth VALUES(@new_version,@req_version,NULL); - --- ############################### --- INSERT YOUR SQL QUERIES HERE --- ############################### - - - - --- ############################### --- TERMINATE YOUR SQL QUERIES HERE --- ############################### - -COMMIT; -END; -// -DELIMITER ; -CALL updateDb(); -DROP PROCEDURE IF EXISTS `updateDb`; - diff --git a/data/sql/updates/pending_db_characters/template_for_characters_updates.txt b/data/sql/updates/pending_db_characters/template_for_characters_updates.txt deleted file mode 100644 index a73dc8a588..0000000000 --- a/data/sql/updates/pending_db_characters/template_for_characters_updates.txt +++ /dev/null @@ -1,38 +0,0 @@ -DROP PROCEDURE IF EXISTS `updateDb`; -DELIMITER // -CREATE PROCEDURE updateDb () -proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT "FALSE"; - --- ############################### --- CHANGE FOLLOWING VARIABLES --- ############################### - --- fill new_version with result of this bash command: date +%s%N --- you must run it for each sql updates -SET @new_version=""; --- set previous required version, or do not touch it if you are not sure -SET @req_version=NULL; - --- ############################### --- DO NOT CHANGE IT --- ############################### -SELECT sql_rev INTO OK FROM version_db_characters WHERE sql_rev = @new_version; IF OK <> "FALSE" THEN LEAVE proc; END IF; START TRANSACTION; INSERT INTO version_db_characters VALUES(@new_version,@req_version,NULL); - --- ############################### --- INSERT YOUR SQL QUERIES HERE --- ############################### - - - - --- ############################### --- TERMINATE YOUR SQL QUERIES HERE --- ############################### - -COMMIT; -END; -// -DELIMITER ; -CALL updateDb(); -DROP PROCEDURE IF EXISTS `updateDb`; - diff --git a/data/sql/updates/pending_db_world/template_for_world_updates.txt b/data/sql/updates/pending_db_world/template_for_world_updates.txt deleted file mode 100644 index 5872681ff5..0000000000 --- a/data/sql/updates/pending_db_world/template_for_world_updates.txt +++ /dev/null @@ -1,38 +0,0 @@ -DROP PROCEDURE IF EXISTS `updateDb`; -DELIMITER // -CREATE PROCEDURE updateDb () -proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT "FALSE"; - --- ############################### --- CHANGE FOLLOWING VARIABLES --- ############################### - --- fill new_version with result of this bash command: date +%s%N --- you must run it for each sql updates -SET @new_version=""; --- set previous required version, or do not touch it if you are not sure -SET @req_version=NULL; - --- ############################### --- DO NOT CHANGE IT --- ############################### -SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = @new_version; IF OK <> "FALSE" THEN LEAVE proc; END IF; START TRANSACTION; INSERT INTO version_db_world VALUES(@new_version,@req_version,NULL); - --- ############################### --- INSERT YOUR SQL QUERIES HERE --- ############################### - - - - --- ############################### --- TERMINATE YOUR SQL QUERIES HERE --- ############################### - -COMMIT; -END; -// -DELIMITER ; -CALL updateDb(); -DROP PROCEDURE IF EXISTS `updateDb`; - |
