mirror of
https://github.com/CompassConnections/Compass.git
synced 2025-12-30 01:18:56 -05:00
19 lines
481 B
SQL
19 lines
481 B
SQL
CREATE TABLE IF NOT EXISTS causes
|
|
(
|
|
id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
|
creator_id text REFERENCES users (id) ON DELETE set null,
|
|
name TEXT NOT NULL,
|
|
CONSTRAINT causes_name_unique UNIQUE (name)
|
|
);
|
|
|
|
-- Row Level Security
|
|
ALTER TABLE causes
|
|
ENABLE ROW LEVEL SECURITY;
|
|
|
|
DROP POLICY IF EXISTS "public read" ON causes;
|
|
CREATE POLICY "public read" ON causes
|
|
FOR SELECT USING (true);
|
|
|
|
CREATE UNIQUE INDEX idx_causes_name_ci
|
|
ON causes (name);
|