ooni-probe-cli/internal/database/migrations/3_results_is_uploaded.sql
DecFox 6b01264373
refactor(ooniprobe): migrate database to internal (#979)
See https://github.com/ooni/probe/issues/2352

Co-authored-by: decfox <decfox@github.com>
Co-authored-by: Simone Basso <bassosimone@gmail.com>
2022-11-15 10:35:30 +01:00

15 lines
277 B
SQL

-- +migrate Down
-- +migrate StatementBegin
ALTER TABLE `results`
DROP COLUMN result_is_uploaded;
-- +migrate StatementEnd
-- +migrate Up
-- +migrate StatementBegin
ALTER TABLE `results`
ADD COLUMN result_is_uploaded TINYINT(1) DEFAULT 1 NOT NULL;
-- +migrate StatementEnd