root
10 lines
302 B
SQL
10 lines
302 B
SQL
ALTER TABLE "sessions" ADD COLUMN "token_version" INTEGER NOT NULL DEFAULT 0;
|
|
|
|
UPDATE "sessions" AS s
|
|
SET "token_version" = a."token_version"
|
|
FROM "accounts" AS a
|
|
WHERE s."account_id" = a."id";
|
|
|
|
ALTER TABLE "sessions" ADD CONSTRAINT "sessions_token_version_nonnegative"
|
|
CHECK ("token_version" >= 0);
|