• Home
• com.swisscom.cloud.sb
• database
• 6.12.2
• source code
• V1_0_18__add_retry_backup_count.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.V1_0_18__add_retry_backup_count.sql Maven / Gradle / Ivy

DROP PROCEDURE IF EXISTS add_retry_backup_count_to_backup_table;
DELIMITER //

CREATE PROCEDURE add_retry_backup_count_to_backup_table()
  BEGIN

    SET @col_exists = 1;
    SELECT 0
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'backup'
          AND column_name = 'retry_backup_count'
          AND table_schema = database()
    INTO @col_exists;

    IF @col_exists = 1 THEN
      ALTER TABLE backup
        ADD COLUMN  retry_backup_count tinyint(1) default 0 not NULL;
    END IF;

  END//

DELIMITER ;
CALL add_retry_backup_count_to_backup_table();