mirror of
https://github.com/aykhans/slash-e.git
synced 2025-04-19 21:46:19 +00:00
12 lines
451 B
SQL
12 lines
451 B
SQL
ALTER TABLE shortcut DROP CONSTRAINT IF EXISTS shortcut_visibility_check;
|
|
|
|
ALTER TABLE shortcut ALTER COLUMN visibility SET DEFAULT 'WORKSPACE';
|
|
|
|
UPDATE shortcut SET visibility = 'WORKSPACE' WHERE visibility = 'PRIVATE';
|
|
|
|
ALTER TABLE collection DROP CONSTRAINT IF EXISTS collection_visibility_check;
|
|
|
|
ALTER TABLE collection ALTER COLUMN visibility SET DEFAULT 'WORKSPACE';
|
|
|
|
UPDATE collection SET visibility = 'WORKSPACE' WHERE visibility = 'PRIVATE';
|