nidus-sync/db/migrations/00061_oauth_token_created.sql

7 lines
244 B
MySQL
Raw Permalink Normal View History

-- +goose Up
ALTER TABLE oauth_token ADD COLUMN created TIMESTAMP WITHOUT TIME ZONE;
UPDATE oauth_token SET created = now();
ALTER TABLE oauth_token ALTER COLUMN created SET NOT NULL;
-- +goose Down
ALTER TABLE oauth_token DROP COLUMN created;