diff options
| author | Julien Lancelot <julien.lancelot@sonarsource.com> | 2018-12-12 10:16:11 +0100 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2018-12-20 11:41:52 +0100 |
| commit | 347f6c674430812b544478140297d80027dd6d85 (patch) | |
| tree | ec2671ab068f81429c4e5661476d9a720200dcd8 /server/sonar-db-core | |
| parent | 0b64e0734312efd38de8393f9a482d380634fd85 (diff) | |
| download | sonarqube-347f6c674430812b544478140297d80027dd6d85.tar.gz sonarqube-347f6c674430812b544478140297d80027dd6d85.zip | |
SONAR-11579 Create WS to store/load user settings
Diffstat (limited to 'server/sonar-db-core')
| -rw-r--r-- | server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java | 1 | ||||
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 12 |
2 files changed, 13 insertions, 0 deletions
diff --git a/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java b/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java index 1135f040301..48708e80f74 100644 --- a/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java +++ b/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java @@ -108,6 +108,7 @@ public final class SqTables { "schema_migrations", "snapshots", "users", + "user_properties", "user_roles", "user_tokens", "webhooks", diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl index e40e736765d..6790a438c54 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -936,3 +936,15 @@ CREATE TABLE "ORGANIZATION_ALM_BINDINGS" ( ); CREATE UNIQUE INDEX "ORG_ALM_BINDINGS_ORG" ON "ORGANIZATION_ALM_BINDINGS" ("ORGANIZATION_UUID"); CREATE UNIQUE INDEX "ORG_ALM_BINDINGS_INSTALL" ON "ORGANIZATION_ALM_BINDINGS" ("ALM_APP_INSTALL_UUID"); + +CREATE TABLE "USER_PROPERTIES" ( + "UUID" VARCHAR(40) NOT NULL, + "USER_UUID" VARCHAR(255) NOT NULL, + "KEE" VARCHAR(100) NOT NULL, + "TEXT_VALUE" VARCHAR(4000) NOT NULL, + "CREATED_AT" BIGINT NOT NULL, + "UPDATED_AT" BIGINT NOT NULL, + + CONSTRAINT "PK_USER_PROPERTIES" PRIMARY KEY ("UUID") +); +CREATE UNIQUE INDEX "USER_PROPERTIES_USER_UUID_KEE" ON "USER_PROPERTIES" ("USER_UUID", "KEE"); |