mirror of
https://github.com/CompassConnections/Compass.git
synced 2025-12-24 06:27:52 -05:00
17 lines
506 B
SQL
17 lines
506 B
SQL
CREATE TABLE IF NOT EXISTS user_waitlist (
|
|
id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
|
created_time TIMESTAMPTZ DEFAULT now() NOT NULL,
|
|
email TEXT NOT NULL
|
|
);
|
|
|
|
-- Row Level Security
|
|
ALTER TABLE user_waitlist ENABLE ROW LEVEL SECURITY;
|
|
|
|
-- Policies
|
|
DROP POLICY IF EXISTS "anon insert" ON user_waitlist;
|
|
CREATE POLICY "anon insert" ON user_waitlist
|
|
FOR INSERT WITH CHECK (true);
|
|
|
|
-- Indexes
|
|
-- Primary key automatically creates a unique index on id, so no additional index is needed.
|