MySQL · 466 bytes Raw Blame History
1 -- +goose Up
2 -- +goose StatementBegin
3 ALTER TABLE push_events DROP CONSTRAINT push_events_protocol;
4 ALTER TABLE push_events
5 ADD CONSTRAINT push_events_protocol
6 CHECK (protocol IN ('http', 'ssh', 'web'));
7 -- +goose StatementEnd
8
9 -- +goose Down
10 -- +goose StatementBegin
11 ALTER TABLE push_events DROP CONSTRAINT push_events_protocol;
12 ALTER TABLE push_events
13 ADD CONSTRAINT push_events_protocol
14 CHECK (protocol IN ('http', 'ssh'));
15 -- +goose StatementEnd
16