github.com/masterhung0112/hk_server/v5@v5.0.0-20220302090640-ec71aef15e1c/db/migrations/mysql/000002_create_team_members.down.sql (about)

     1  SET @preparedStatement = (SELECT IF(
     2      (
     3          SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
     4          WHERE table_name = 'TeamMembers'
     5          AND table_schema = DATABASE()
     6          AND column_name = 'SchemeUser'
     7      ) > 0,
     8      'ALTER TABLE TeamMembers DROP COLUMN SchemeUser;',
     9      'SELECT 1'
    10  ));
    11  
    12  PREPARE alterIfExists FROM @preparedStatement;
    13  EXECUTE alterIfExists;
    14  DEALLOCATE PREPARE alterIfExists;
    15  
    16  SET @preparedStatement = (SELECT IF(
    17      (
    18          SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
    19          WHERE table_name = 'TeamMembers'
    20          AND table_schema = DATABASE()
    21          AND column_name = 'SchemeAdmin'
    22      ) > 0,
    23      'ALTER TABLE TeamMembers DROP COLUMN SchemeAdmin;',
    24      'SELECT 1'
    25  ));
    26  
    27  PREPARE alterIfExists FROM @preparedStatement;
    28  EXECUTE alterIfExists;
    29  DEALLOCATE PREPARE alterIfExists;
    30  
    31  SET @preparedStatement = (SELECT IF(
    32      (
    33          SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
    34          WHERE table_name = 'TeamMembers'
    35          AND table_schema = DATABASE()
    36          AND column_name = 'SchemeGuest'
    37      ) > 0,
    38      'ALTER TABLE TeamMembers DROP COLUMN SchemeGuest;',
    39      'SELECT 1'
    40  ));
    41  
    42  PREPARE alterIfExists FROM @preparedStatement;
    43  EXECUTE alterIfExists;
    44  DEALLOCATE PREPARE alterIfExists;
    45  
    46  SET @preparedStatement = (SELECT IF(
    47      (
    48          SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
    49          WHERE table_name = 'TeamMembers'
    50          AND table_schema = DATABASE()
    51          AND column_name = 'DeleteAt'
    52      ) > 0,
    53      'ALTER TABLE TeamMembers DROP COLUMN DeleteAt;',
    54      'SELECT 1'
    55  ));
    56  
    57  PREPARE alterIfExists FROM @preparedStatement;
    58  EXECUTE alterIfExists;
    59  DEALLOCATE PREPARE alterIfExists;
    60  
    61  DROP TABLE IF EXISTS TeamMembers;