1#@!#!123s

: / opt / psa / admin / plib / modules / laravel / resources / db / Migrations /
Filename : init_schema.sql
back
-- Copyright 1999-2024. WebPros International GmbH. All rights reserved.
CREATE TABLE IF NOT EXISTS `version` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `dbVersion` TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS `applications` (
     `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
     `domainId` INTEGER NOT NULL,
     `name` TEXT NOT NULL,
     `repoName` TEXT,
     `deploymentPath` TEXT NOT NULL DEFAULT '',
     `scheduleTaskId` TEXT DEFAULT NULL,
     `repositoryType` char(10) NOT NULL DEFAULT '',
     `scan` INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS `ApplicationNodeConfigurations` (
    `applicationId` INTEGER NOT NULL PRIMARY KEY,
    `nodeVersion` TEXT NOT NULL,
    `packageManager` TEXT NOT NULL,
    FOREIGN KEY (applicationId) REFERENCES applications(id) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS `DeploymentStepConfigurations` (
    `applicationId` INTEGER NOT NULL REFERENCES applications(id) ON DELETE CASCADE,
    `stepId` VARCHAR(50) NOT NULL,
    `isEnabled` INTEGER NOT NULL,
    PRIMARY KEY (`applicationId`, `stepId`)
);

INSERT INTO `version` (`dbVersion`) VALUES ('202208170950');