mirror of
https://github.com/AppFlowy-IO/AppFlowy-Cloud.git
synced 2025-04-19 03:24:42 -04:00
6 lines
452 B
SQL
6 lines
452 B
SQL
ALTER TABLE af_published_collab ADD COLUMN view_id UUID NOT NULL DEFAULT gen_random_uuid();
|
|
ALTER TABLE af_published_collab DROP CONSTRAINT af_published_collab_pkey;
|
|
ALTER TABLE af_published_collab ADD PRIMARY KEY (workspace_id, view_id);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_workspace_id_on_af_published_collab ON af_published_collab (workspace_id);
|
|
CREATE INDEX IF NOT EXISTS idx_published_by_on_af_published_collab ON af_published_collab (published_by);
|