diff options
6 files changed, 87 insertions, 12 deletions
diff --git a/data/sql/updates/db_auth/2021_05_30_00.sql b/data/sql/updates/db_auth/2021_05_30_00.sql new file mode 100644 index 0000000000..181e0e172b --- /dev/null +++ b/data/sql/updates/db_auth/2021_05_30_00.sql @@ -0,0 +1,29 @@ +-- DB update 2021_05_26_00 -> 2021_05_30_00 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT date INTO @COLEXISTS +FROM version_db_auth +ORDER BY date DESC LIMIT 1; +IF @COLEXISTS <> '2021_05_26_00' THEN LEAVE proc; END IF; +START TRANSACTION; +SELECT sql_rev INTO OK FROM version_db_auth WHERE sql_rev = '1621715473238990700'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_auth` (`sql_rev`) VALUES ('1621715473238990700'); + +ALTER TABLE `version_db_auth` + ADD COLUMN `date` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci' AFTER `required_rev`; + +-- +-- END UPDATING QUERIES +-- +UPDATE version_db_auth SET date = '2021_05_30_00' WHERE sql_rev = '1621715473238990700'; +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_characters/2021_05_30_00.sql b/data/sql/updates/db_characters/2021_05_30_00.sql new file mode 100644 index 0000000000..0ac235b6d2 --- /dev/null +++ b/data/sql/updates/db_characters/2021_05_30_00.sql @@ -0,0 +1,29 @@ +-- DB update 2021_05_28_00 -> 2021_05_30_00 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT date INTO @COLEXISTS +FROM version_db_characters +ORDER BY date DESC LIMIT 1; +IF @COLEXISTS <> '2021_05_28_00' THEN LEAVE proc; END IF; +START TRANSACTION; +SELECT sql_rev INTO OK FROM version_db_characters WHERE sql_rev = '1621715444570678000'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_characters` (`sql_rev`) VALUES ('1621715444570678000'); + +ALTER TABLE `version_db_characters` + ADD COLUMN `date` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci' AFTER `required_rev`; + +-- +-- END UPDATING QUERIES +-- +UPDATE version_db_characters SET date = '2021_05_30_00' WHERE sql_rev = '1621715444570678000'; +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/db_world/2021_05_30_01.sql b/data/sql/updates/db_world/2021_05_30_01.sql new file mode 100644 index 0000000000..432e2b3aab --- /dev/null +++ b/data/sql/updates/db_world/2021_05_30_01.sql @@ -0,0 +1,29 @@ +-- DB update 2021_05_30_00 -> 2021_05_30_01 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT date INTO @COLEXISTS +FROM version_db_world +ORDER BY date DESC LIMIT 1; +IF @COLEXISTS <> '2021_05_30_00' THEN LEAVE proc; END IF; +START TRANSACTION; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1621709841145351300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1621709841145351300'); + +ALTER TABLE `version_db_world` + ADD COLUMN `date` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci' AFTER `required_rev`; + +-- +-- END UPDATING QUERIES +-- +UPDATE version_db_world SET date = '2021_05_30_01' WHERE sql_rev = '1621709841145351300'; +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_auth/rev_1621715473238990700.sql b/data/sql/updates/pending_db_auth/rev_1621715473238990700.sql deleted file mode 100644 index ea657bd1a3..0000000000 --- a/data/sql/updates/pending_db_auth/rev_1621715473238990700.sql +++ /dev/null @@ -1,4 +0,0 @@ -INSERT INTO `version_db_auth` (`sql_rev`) VALUES ('1621715473238990700'); - -ALTER TABLE `version_db_auth` - ADD COLUMN `date` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci' AFTER `required_rev`; diff --git a/data/sql/updates/pending_db_characters/rev_1621715444570678000.sql b/data/sql/updates/pending_db_characters/rev_1621715444570678000.sql deleted file mode 100644 index 69d9493402..0000000000 --- a/data/sql/updates/pending_db_characters/rev_1621715444570678000.sql +++ /dev/null @@ -1,4 +0,0 @@ -INSERT INTO `version_db_characters` (`sql_rev`) VALUES ('1621715444570678000'); - -ALTER TABLE `version_db_characters` - ADD COLUMN `date` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci' AFTER `required_rev`; diff --git a/data/sql/updates/pending_db_world/rev_1621709841145351300.sql b/data/sql/updates/pending_db_world/rev_1621709841145351300.sql deleted file mode 100644 index c31c764812..0000000000 --- a/data/sql/updates/pending_db_world/rev_1621709841145351300.sql +++ /dev/null @@ -1,4 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1621709841145351300'); - -ALTER TABLE `version_db_world` - ADD COLUMN `date` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci' AFTER `required_rev`; |