From 308d6a85e6489a3ed739e205f9de6bc5050b09f5 Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Wed, 30 Jan 2019 13:54:26 +0100 Subject: Merge pull request #1178 from SonarSource/feature/jl/add_dates_to_users_and_user_tokens Add dates to users and user tokens --- .../sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 2 ++ 1 file changed, 2 insertions(+) (limited to 'server/sonar-db-core/src') 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"); -- cgit v1.2.3