11 lines
453 B
SQL
11 lines
453 B
SQL
-- Add workspace_protection_rule table for fine-grained access control
|
|
CREATE TABLE workspace_protection_rule (
|
|
workspace_id VARCHAR(50) NOT NULL REFERENCES workspace(id) ON DELETE CASCADE,
|
|
name VARCHAR(255) NOT NULL,
|
|
rules INTEGER NOT NULL,
|
|
bypass_groups TEXT[] NOT NULL DEFAULT '{}',
|
|
bypass_users TEXT[] NOT NULL DEFAULT '{}',
|
|
created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
|
|
PRIMARY KEY (workspace_id, name)
|
|
);
|