diff options
| author | Julien Lancelot <julien.lancelot@sonarsource.com> | 2019-01-30 13:54:26 +0100 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2019-02-11 09:11:41 +0100 |
| commit | 308d6a85e6489a3ed739e205f9de6bc5050b09f5 (patch) | |
| tree | 3b8b25aac91472a222ff7bba5f38016b09b44bf2 /server/sonar-db-core | |
| parent | 5e68732f4883ffb937f42245072e83265cd09cce (diff) | |
| download | sonarqube-308d6a85e6489a3ed739e205f9de6bc5050b09f5.tar.gz sonarqube-308d6a85e6489a3ed739e205f9de6bc5050b09f5.zip | |
Merge pull request #1178 from SonarSource/feature/jl/add_dates_to_users_and_user_tokens
Add dates to users and user tokens
Diffstat (limited to 'server/sonar-db-core')
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 2 |
1 files changed, 2 insertions, 0 deletions
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 f5907822075..dae2190297c 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 @@ -523,6 +523,7 @@ CREATE TABLE "USERS" ( "HOMEPAGE_TYPE" VARCHAR(40), "HOMEPAGE_PARAMETER" VARCHAR(40), "ORGANIZATION_UUID" VARCHAR(40), + "LAST_CONNECTION_DATE" BIGINT, "CREATED_AT" BIGINT, "UPDATED_AT" BIGINT ); @@ -785,6 +786,7 @@ CREATE TABLE "USER_TOKENS" ( "USER_UUID" VARCHAR(255) NOT NULL, "NAME" VARCHAR(100) NOT NULL, "TOKEN_HASH" VARCHAR(255) NOT NULL, + "LAST_CONNECTION_DATE" BIGINT, "CREATED_AT" BIGINT NOT NULL ); CREATE UNIQUE INDEX "USER_TOKENS_TOKEN_HASH" ON "USER_TOKENS" ("TOKEN_HASH"); |