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

   1 CREATE TABLE "LIVE_MEASURES"(
   2     "UUID" VARCHAR(40) NOT NULL,
   3     "PROJECT_UUID" VARCHAR(50) NOT NULL,
   4     "COMPONENT_UUID" VARCHAR(50) NOT NULL,
   5     "METRIC_ID" INTEGER NOT NULL,
   6     "METRIC_UUID" VARCHAR NOT NULL,
   7     "VALUE" DOUBLE,
   8     "TEXT_VALUE" VARCHAR(4000),
   9     "VARIATION" DOUBLE,
  10     "MEASURE_DATA" BLOB,
  11     "UPDATE_MARKER" VARCHAR(40),
  12     "CREATED_AT" BIGINT NOT NULL,
  13     "UPDATED_AT" BIGINT NOT NULL
  14 );
  15 ALTER TABLE "LIVE_MEASURES" ADD CONSTRAINT "PK_LIVE_MEASURES" PRIMARY KEY("UUID");
  16 CREATE INDEX "LIVE_MEASURES_PROJECT" ON "LIVE_MEASURES"("PROJECT_UUID");
  17 CREATE UNIQUE INDEX "LIVE_MEASURES_COMPONENT" ON "LIVE_MEASURES"("COMPONENT_UUID", "METRIC_UUID");