mirror of
https://github.com/acaloiaro/garbagespeak.com
synced 2026-07-21 10:12:19 +00:00
9 lines
316 B
SQL
9 lines
316 B
SQL
CREATE TABLE IF NOT EXISTS uplevels(
|
|
id uuid PRIMARY KEY default uuid_generate_v4(),
|
|
garbage_id uuid NOT NULL,
|
|
user_id uuid NOT NULL,
|
|
created_at timestamp with time zone DEFAULT now()
|
|
);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS uplevel_user_id_garbage_id_idx ON public.uplevels USING btree (garbage_id, user_id);
|
|
|