1#@!#!123s

: / opt / psa / admin / plib / modules / git / library / Migrations /
Filename : init_schema.sql
back
--  Copyright 1999-2023. Plesk International GmbH. All rights reserved.
CREATE TABLE IF NOT EXISTS `version` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `dbVersion` TEXT NOT NULL
);
INSERT INTO `version` (`dbVersion`) VALUES ('202308041501');

CREATE TABLE IF NOT EXISTS `Repositories` (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `domainId` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'none',
  `deploymentMode` varchar(20) NOT NULL DEFAULT 'none',
  `branch` varchar(255) DEFAULT NULL,
  `deploymentPath` varchar(255) DEFAULT NULL,
  `fetchUrl` varchar(255) DEFAULT NULL,
  `uuid` varchar(36) NOT NULL,
  `skipSslVerification` int(1) NOT NULL DEFAULT '0',
  `postDeploymentActionsEnabled` int(1) NOT NULL DEFAULT '0',
  `postDeploymentActions` TEXT DEFAULT NULL,
  `httpUser` varchar(255) DEFAULT NULL,
  `httpPassword` varchar(255) DEFAULT NULL,
  `deploymentsCounter` integer DEFAULT 0,
  `deployKeyUuid` varchar(36) DEFAULT NULL,
  `smbUserIds` TEXT DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS `DeployKeys` (
    `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `uuid` varchar(36) NOT NULL,
    `domainUuid` varchar(36) NOT NULL,
    `name` varchar(255) NOT NULL,
    `isDefault` int(1) NOT NULL DEFAULT '0'
);

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
);