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

   1 CREATE TABLE "COMPONENTS"(
   2     "UUID" CHARACTER VARYING(50) NOT NULL,
   3     "KEE" CHARACTER VARYING(1000),
   4     "DEPRECATED_KEE" CHARACTER VARYING(400),
   5     "NAME" CHARACTER VARYING(2000),
   6     "LONG_NAME" CHARACTER VARYING(2000),
   7     "DESCRIPTION" CHARACTER VARYING(2000),
   8     "ENABLED" BOOLEAN DEFAULT TRUE NOT NULL,
   9     "SCOPE" CHARACTER VARYING(3),
  10     "QUALIFIER" CHARACTER VARYING(10),
  11     "PRIVATE" BOOLEAN NOT NULL,
  12     "ROOT_UUID" CHARACTER VARYING(50) NOT NULL,
  13     "LANGUAGE" CHARACTER VARYING(20),
  14     "COPY_COMPONENT_UUID" CHARACTER VARYING(50),
  15     "PATH" CHARACTER VARYING(2000),
  16     "UUID_PATH" CHARACTER VARYING(1500) NOT NULL,
  17     "PROJECT_UUID" CHARACTER VARYING(50) NOT NULL,
  18     "MODULE_UUID" CHARACTER VARYING(50),
  19     "MODULE_UUID_PATH" CHARACTER VARYING(1500),
  20     "MAIN_BRANCH_PROJECT_UUID" CHARACTER VARYING(50),
  21     "B_CHANGED" BOOLEAN,
  22     "B_NAME" CHARACTER VARYING(500),
  23     "B_LONG_NAME" CHARACTER VARYING(500),
  24     "B_DESCRIPTION" CHARACTER VARYING(2000),
  25     "B_ENABLED" BOOLEAN,
  26     "B_QUALIFIER" CHARACTER VARYING(10),
  27     "B_LANGUAGE" CHARACTER VARYING(20),
  28     "B_COPY_COMPONENT_UUID" CHARACTER VARYING(50),
  29     "B_PATH" CHARACTER VARYING(2000),
  30     "B_UUID_PATH" CHARACTER VARYING(1500),
  31     "B_MODULE_UUID" CHARACTER VARYING(50),
  32     "B_MODULE_UUID_PATH" CHARACTER VARYING(1500),
  33     "CREATED_AT" TIMESTAMP
  34 );
  35 CREATE UNIQUE INDEX "PROJECTS_KEE" ON "COMPONENTS"("KEE" NULLS FIRST);
  36 CREATE INDEX "PROJECTS_MODULE_UUID" ON "COMPONENTS"("MODULE_UUID" NULLS FIRST);
  37 CREATE INDEX "PROJECTS_PROJECT_UUID" ON "COMPONENTS"("PROJECT_UUID" NULLS FIRST);
  38 CREATE INDEX "PROJECTS_QUALIFIER" ON "COMPONENTS"("QUALIFIER" NULLS FIRST);
  39 CREATE INDEX "PROJECTS_ROOT_UUID" ON "COMPONENTS"("ROOT_UUID" NULLS FIRST);
  40 CREATE INDEX "IDX_MAIN_BRANCH_PRJ_UUID" ON "COMPONENTS"("MAIN_BRANCH_PROJECT_UUID" NULLS FIRST);