16 lines
453 B
SQL
16 lines
453 B
SQL
CREATE TABLE IF NOT EXISTS public.discount_claims (
|
|
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
name text NOT NULL,
|
|
phone text NOT NULL,
|
|
created_at timestamptz NOT NULL DEFAULT now()
|
|
);
|
|
|
|
ALTER TABLE public.discount_claims ENABLE ROW LEVEL SECURITY;
|
|
|
|
CREATE POLICY discount_claims_insert ON public.discount_claims
|
|
FOR INSERT TO anon
|
|
WITH CHECK (true);
|
|
|
|
GRANT INSERT ON public.discount_claims TO anon;
|
|
GRANT USAGE ON SCHEMA public TO anon;
|