github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/legacy/20200812124254_add_session_token.postgres.up.sql (about)

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