10 lines
380 B
SQL
10 lines
380 B
SQL
-- A built-in mapping ships with the instance and is readable by every org, so
|
|
-- any org can bind to it. Writes stay confined to the owning org.
|
|
|
|
-- +goose Up
|
|
ALTER TABLE mappings ADD COLUMN built_in boolean NOT NULL DEFAULT false;
|
|
UPDATE mappings SET built_in = true WHERE id = 'schedule-fired' AND org_id = 'org-sys';
|
|
|
|
-- +goose Down
|
|
ALTER TABLE mappings DROP COLUMN built_in;
|