source.dussan.org Git - sonarqube.git/blob

   1 CREATE TABLE "PROJECTS" (
   2   "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),
   3   "ORGANIZATION_UUID" VARCHAR(40) NOT NULL,
   4   "KEE" VARCHAR(400),
   5   "UUID" VARCHAR(50) NOT NULL,
   6   "UUID_PATH" VARCHAR(1500) NOT NULL,
   7   "ROOT_UUID" VARCHAR(50) NOT NULL,
   8   "PROJECT_UUID" VARCHAR(50) NOT NULL,
   9   "MODULE_UUID" VARCHAR(50),
  10   "MODULE_UUID_PATH" VARCHAR(1500),
  11   "MAIN_BRANCH_PROJECT_UUID" VARCHAR(50),
  12   "NAME" VARCHAR(2000),
  13   "DESCRIPTION" VARCHAR(2000),
  14   "PRIVATE" BOOLEAN NOT NULL,
  15   "TAGS" VARCHAR(500),
  16   "ENABLED" BOOLEAN NOT NULL DEFAULT TRUE,
  17   "SCOPE" VARCHAR(3),
  18   "QUALIFIER" VARCHAR(10),
  19   "DEPRECATED_KEE" VARCHAR(400),
  20   "PATH" VARCHAR(2000),
  21   "LANGUAGE" VARCHAR(20),
  22   "COPY_COMPONENT_UUID" VARCHAR(50),
  23   "LONG_NAME" VARCHAR(2000),
  24   "DEVELOPER_UUID" VARCHAR(50),
  25   "CREATED_AT" TIMESTAMP,
  26   "AUTHORIZATION_UPDATED_AT" BIGINT,
  27   "B_CHANGED" BOOLEAN,
  28   "B_COPY_COMPONENT_UUID" VARCHAR(50),
  29   "B_DESCRIPTION" VARCHAR(2000),
  30   "B_ENABLED" BOOLEAN,
  31   "B_UUID_PATH" VARCHAR(1500),
  32   "B_LANGUAGE" VARCHAR(20),
  33   "B_LONG_NAME" VARCHAR(500),
  34   "B_MODULE_UUID" VARCHAR(50),
  35   "B_MODULE_UUID_PATH" VARCHAR(1500),
  36   "B_NAME" VARCHAR(500),
  37   "B_PATH" VARCHAR(2000),
  38   "B_QUALIFIER" VARCHAR(10)
  39 );
  40 CREATE INDEX "PROJECTS_ORGANIZATION" ON "PROJECTS" ("ORGANIZATION_UUID");
  41 CREATE UNIQUE INDEX "PROJECTS_KEE" ON "PROJECTS" ("KEE");
  42 CREATE INDEX "PROJECTS_ROOT_UUID" ON "PROJECTS" ("ROOT_UUID");
  43 CREATE UNIQUE INDEX "PROJECTS_UUID" ON "PROJECTS" ("UUID");
  44 CREATE INDEX "PROJECTS_PROJECT_UUID" ON "PROJECTS" ("PROJECT_UUID");
  45 CREATE INDEX "PROJECTS_MODULE_UUID" ON "PROJECTS" ("MODULE_UUID");
  46 CREATE INDEX "PROJECTS_QUALIFIER" ON "PROJECTS" ("QUALIFIER");
  47
  48 CREATE TABLE "PROJECT_BRANCHES" (
  49   "UUID" VARCHAR(50) NOT NULL PRIMARY KEY,
  50   "PROJECT_UUID" VARCHAR(50) NOT NULL,
  51   "KEE" VARCHAR(255) NOT NULL,
  52   "BRANCH_TYPE" VARCHAR(5),
  53   "MERGE_BRANCH_UUID" VARCHAR(50),
  54   "CREATED_AT" BIGINT NOT NULL,
  55   "UPDATED_AT" BIGINT NOT NULL
  56 );
  57 CREATE UNIQUE INDEX "PK_PROJECT_BRANCHES" ON "PROJECT_BRANCHES" ("UUID");
  58 CREATE UNIQUE INDEX "PROJECT_BRANCHES_KEE" ON "PROJECT_BRANCHES" ("PROJECT_UUID", "KEE");