...

Text file src/github.com/ory/x/popx/stub/migrations/legacy/20200812124254_add_session_token.postgres.up.sql

Documentation: github.com/ory/x/popx/stub/migrations/legacy

     1DELETE FROM sessions;
     2ALTER TABLE "sessions" ADD COLUMN "token" VARCHAR (32);
     3ALTER TABLE "sessions" ALTER COLUMN "token" TYPE VARCHAR (32), ALTER COLUMN "token" DROP NOT NULL;
     4CREATE UNIQUE INDEX "sessions_token_uq_idx" ON "sessions" (token);
     5CREATE INDEX "sessions_token_idx" ON "sessions" (token);

View as plain text