AppFlowy-Cloud/migrations/20230926145155_blob_storage.sql
Nathan.fooo 9dc7bbeee0
feat: Collab access control (#120)
* chore: check collab message with access permission

* chore: imple collab permission service

* refactor: migrations

* chore: collab member ops

* chore: collab permission

* chore: update can edit workspace collab

* chore: fix test

* feat: fetch collab members

* chore: fix test

* chore: fix client api

* chore: check permission for collab storage proxy
2023-10-17 14:00:04 +08:00

8 lines
342 B
SQL

CREATE TABLE IF NOT EXISTS af_blob_metadata (
workspace_id UUID REFERENCES af_workspace(workspace_id) ON DELETE CASCADE NOT NULL,
file_id VARCHAR NOT NULL,
file_type VARCHAR NOT NULL,
file_size BIGINT NOT NULL,
modified_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL,
UNIQUE (workspace_id, file_id)
);