diff options
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index fa3ca75b1e9..27ecbc766e6 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -800,7 +800,8 @@ CREATE TABLE "PROJECTS"( "NCLOC" BIGINT, "CREATION_METHOD" CHARACTER VARYING(50) NOT NULL, "CONTAINS_AI_CODE" BOOLEAN DEFAULT FALSE NOT NULL, - "AI_CODE_FIX_ENABLED" BOOLEAN DEFAULT FALSE NOT NULL + "AI_CODE_FIX_ENABLED" BOOLEAN DEFAULT FALSE NOT NULL, + "DETECTED_AI_CODE" BOOLEAN DEFAULT FALSE NOT NULL ); ALTER TABLE "PROJECTS" ADD CONSTRAINT "PK_NEW_PROJECTS" PRIMARY KEY("UUID"); CREATE UNIQUE NULLS NOT DISTINCT INDEX "UNIQ_PROJECTS_KEE" ON "PROJECTS"("KEE" NULLS FIRST); @@ -1108,6 +1109,14 @@ CREATE TABLE "TELEMETRY_METRICS_SENT"( ); ALTER TABLE "TELEMETRY_METRICS_SENT" ADD CONSTRAINT "PK_TELEMETRY_METRICS_SENT" PRIMARY KEY("METRIC_KEY", "DIMENSION"); +CREATE TABLE "USER_AI_TOOL_USAGES"( + "UUID" CHARACTER VARYING(40) NOT NULL, + "USER_UUID" CHARACTER VARYING(40) NOT NULL, + "ACTIVATED_AT" BIGINT NOT NULL, + "LAST_ACTIVITY_AT" BIGINT +); +ALTER TABLE "USER_AI_TOOL_USAGES" ADD CONSTRAINT "PK_USER_AI_TOOL_USAGES" PRIMARY KEY("UUID"); + CREATE TABLE "USER_DISMISSED_MESSAGES"( "UUID" CHARACTER VARYING(40) NOT NULL, "USER_UUID" CHARACTER VARYING(255) NOT NULL, |