summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYehonal <yehonal.azeroth@gmail.com>2016-08-26 16:25:13 +0200
committerYehonal <yehonal.azeroth@gmail.com>2016-08-26 16:25:13 +0200
commita6db058f9006c09d56ce51daab439ca1f539635f (patch)
treef0915422d3e7fb4ed3645478d5f9c586b3440755
parent0b34a24cf91040646741428ce86af6700d721df0 (diff)
removed templates for pending, we will find a more cleaner way for devs
-rw-r--r--data/sql/updates/README.md1
-rw-r--r--data/sql/updates/pending_db_auth/template_for_auth_updates.txt38
-rw-r--r--data/sql/updates/pending_db_characters/template_for_characters_updates.txt38
-rw-r--r--data/sql/updates/pending_db_world/template_for_world_updates.txt38
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`;
-