]> source.dussan.org Git - sonarqube.git/blob
52373a8009a14e308ddf2eb269d51ae22bda6b08
[sonarqube.git] /
1 CREATE TABLE "ORG_QPROFILES"(
2     "UUID" VARCHAR(255) NOT NULL,
3     "ORGANIZATION_UUID" VARCHAR(40) NOT NULL,
4     "RULES_PROFILE_UUID" VARCHAR(255) NOT NULL,
5     "PARENT_UUID" VARCHAR(255),
6     "LAST_USED" BIGINT,
7     "USER_UPDATED_AT" BIGINT,
8     "CREATED_AT" BIGINT NOT NULL,
9     "UPDATED_AT" BIGINT NOT NULL
10 );
11 ALTER TABLE "ORG_QPROFILES" ADD CONSTRAINT "PK_ORG_QPROFILES" PRIMARY KEY("UUID");
12 CREATE INDEX "QPROFILES_ORG_UUID" ON "ORG_QPROFILES"("ORGANIZATION_UUID");
13 CREATE INDEX "QPROFILES_RP_UUID" ON "ORG_QPROFILES"("RULES_PROFILE_UUID");
14 CREATE INDEX "ORG_QPROFILES_PARENT_UUID" ON "ORG_QPROFILES"("PARENT_UUID");