Text file src/github.com/ory/x/popx/stub/migrations/legacy/20200812124254_add_session_token.mysql.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` MODIFY `token` VARCHAR (32);
     4CREATE UNIQUE INDEX `sessions_token_uq_idx` ON `sessions` (`token`);
     5CREATE INDEX `sessions_token_idx` ON `sessions` (`token`);

View as plain text