1#@!#!123s

: / opt / psa / admin / plib / modules / git / library / Migrations /

Filename : 202308041501_AddRepositoryDeploymentInfo.sql

back

-- Copyright 1999-2023. Plesk International GmbH. All rights reserved.

CREATE TABLE IF NOT EXISTS `RepositoryDeploymentInfo` (
    `repoUuid` VARCHAR(36) NOT NULL PRIMARY KEY,
    `lastCommitHash` VARCHAR(40) DEFAULT NULL,
    `deployedCommitHash` VARCHAR(40) DEFAULT NULL,
    `deployedCommitAuthor` TEXT DEFAULT NULL,
    `deployedCommitDate` TIMESTAMP DEFAULT NULL,
    `deployedCommitMessage` TEXT DEFAULT NULL,
    CONSTRAINT `fk_repository_uuid`
        FOREIGN KEY (`repoUuid`)
        REFERENCES `Repositories` (uuid)
        ON DELETE CASCADE
        NOT DEFERRABLE INITIALLY IMMEDIATE
);