20 lines
613 B
SQL
20 lines
613 B
SQL
-- Add up migration script here
|
|
ALTER TABLE app_version
|
|
RENAME COLUMN flow_id TO app_id;
|
|
|
|
CREATE TABLE folder (
|
|
name VARCHAR(255),
|
|
workspace_id VARCHAR(50) NOT NULL,
|
|
display_name VARCHAR(100) NOT NULL,
|
|
owners VARCHAR(255)[] NOT NULL,
|
|
extra_perms JSONB NOT NULL DEFAULT '{}',
|
|
FOREIGN KEY (workspace_id) REFERENCES workspace(id) ON DELETE CASCADE,
|
|
PRIMARY KEY (workspace_id, name)
|
|
);
|
|
|
|
CREATE INDEX folder_extra_perms ON folder USING GIN (extra_perms);
|
|
CREATE INDEX folder_owners ON folder USING GIN (owners);
|
|
|
|
GRANT ALL ON folder TO windmill_user;
|
|
GRANT ALL ON folder TO windmill_admin;
|