448 lines
14 KiB
SQL
448 lines
14 KiB
SQL
create table "public"."code" (
|
|
"id" uuid not null default gen_random_uuid(),
|
|
"code" text not null
|
|
);
|
|
|
|
|
|
create table "public"."equipe-joueur" (
|
|
"id_equipe" uuid not null default gen_random_uuid(),
|
|
"id_joueur" uuid not null default gen_random_uuid()
|
|
);
|
|
|
|
|
|
create table "public"."flag" (
|
|
"id_flag" uuid not null default gen_random_uuid(),
|
|
"valeur_flag" text not null,
|
|
"point" bigint not null,
|
|
"predecesseur" text,
|
|
"successeur" text
|
|
);
|
|
|
|
|
|
create table "public"."flag-trouve" (
|
|
"id_flag" uuid not null default gen_random_uuid(),
|
|
"id_equipe" uuid not null default gen_random_uuid()
|
|
);
|
|
|
|
|
|
create table "public"."indice" (
|
|
"id_indice" uuid not null default gen_random_uuid(),
|
|
"penalite" bigint not null,
|
|
"text_indice" text not null
|
|
);
|
|
|
|
|
|
create table "public"."indice-equipe" (
|
|
"id_equipe" uuid not null default gen_random_uuid(),
|
|
"id_indice" uuid not null default gen_random_uuid()
|
|
);
|
|
|
|
|
|
create table "public"."joueur" (
|
|
"uuid" uuid not null default auth.uid(),
|
|
"created_at" timestamp with time zone not null default now(),
|
|
"prenom" text not null,
|
|
"pseudo" text not null
|
|
);
|
|
|
|
|
|
create table "public"."équipe" (
|
|
"id_equipe" uuid not null default gen_random_uuid(),
|
|
"created_at" timestamp with time zone not null default now(),
|
|
"nom_equipe" text not null
|
|
);
|
|
|
|
|
|
CREATE UNIQUE INDEX code_pkey ON public.code USING btree (id);
|
|
|
|
CREATE UNIQUE INDEX "equipe-joueur_pkey" ON public."equipe-joueur" USING btree (id_equipe, id_joueur);
|
|
|
|
CREATE UNIQUE INDEX "flag-trouve_pkey" ON public."flag-trouve" USING btree (id_flag, id_equipe);
|
|
|
|
CREATE UNIQUE INDEX flag_pkey ON public.flag USING btree (id_flag);
|
|
|
|
CREATE UNIQUE INDEX "indice-equipe_pkey" ON public."indice-equipe" USING btree (id_equipe, id_indice);
|
|
|
|
CREATE UNIQUE INDEX indice_pkey ON public.indice USING btree (id_indice);
|
|
|
|
CREATE UNIQUE INDEX joueur_pkey ON public.joueur USING btree (uuid);
|
|
|
|
CREATE UNIQUE INDEX "équipe_pkey" ON public."équipe" USING btree (id_equipe);
|
|
|
|
alter table "public"."code" add constraint "code_pkey" PRIMARY KEY using index "code_pkey";
|
|
|
|
alter table "public"."equipe-joueur" add constraint "equipe-joueur_pkey" PRIMARY KEY using index "equipe-joueur_pkey";
|
|
|
|
alter table "public"."flag" add constraint "flag_pkey" PRIMARY KEY using index "flag_pkey";
|
|
|
|
alter table "public"."flag-trouve" add constraint "flag-trouve_pkey" PRIMARY KEY using index "flag-trouve_pkey";
|
|
|
|
alter table "public"."indice" add constraint "indice_pkey" PRIMARY KEY using index "indice_pkey";
|
|
|
|
alter table "public"."indice-equipe" add constraint "indice-equipe_pkey" PRIMARY KEY using index "indice-equipe_pkey";
|
|
|
|
alter table "public"."joueur" add constraint "joueur_pkey" PRIMARY KEY using index "joueur_pkey";
|
|
|
|
alter table "public"."équipe" add constraint "équipe_pkey" PRIMARY KEY using index "équipe_pkey";
|
|
|
|
alter table "public"."equipe-joueur" add constraint "equipe-joueur_id_equipe_fkey" FOREIGN KEY (id_equipe) REFERENCES "équipe"(id_equipe) not valid;
|
|
|
|
alter table "public"."equipe-joueur" validate constraint "equipe-joueur_id_equipe_fkey";
|
|
|
|
alter table "public"."equipe-joueur" add constraint "equipe-joueur_id_joueur_fkey" FOREIGN KEY (id_joueur) REFERENCES joueur(uuid) not valid;
|
|
|
|
alter table "public"."equipe-joueur" validate constraint "equipe-joueur_id_joueur_fkey";
|
|
|
|
alter table "public"."flag-trouve" add constraint "flag-trouve_id_equipe_fkey" FOREIGN KEY (id_equipe) REFERENCES "équipe"(id_equipe) not valid;
|
|
|
|
alter table "public"."flag-trouve" validate constraint "flag-trouve_id_equipe_fkey";
|
|
|
|
alter table "public"."flag-trouve" add constraint "flag-trouve_id_flag_fkey" FOREIGN KEY (id_flag) REFERENCES flag(id_flag) not valid;
|
|
|
|
alter table "public"."flag-trouve" validate constraint "flag-trouve_id_flag_fkey";
|
|
|
|
alter table "public"."indice-equipe" add constraint "indice-equipe_id_equipe_fkey" FOREIGN KEY (id_equipe) REFERENCES "équipe"(id_equipe) not valid;
|
|
|
|
alter table "public"."indice-equipe" validate constraint "indice-equipe_id_equipe_fkey";
|
|
|
|
alter table "public"."indice-equipe" add constraint "indice-equipe_id_indice_fkey" FOREIGN KEY (id_indice) REFERENCES indice(id_indice) not valid;
|
|
|
|
alter table "public"."indice-equipe" validate constraint "indice-equipe_id_indice_fkey";
|
|
|
|
grant delete on table "public"."code" to "anon";
|
|
|
|
grant insert on table "public"."code" to "anon";
|
|
|
|
grant references on table "public"."code" to "anon";
|
|
|
|
grant select on table "public"."code" to "anon";
|
|
|
|
grant trigger on table "public"."code" to "anon";
|
|
|
|
grant truncate on table "public"."code" to "anon";
|
|
|
|
grant update on table "public"."code" to "anon";
|
|
|
|
grant delete on table "public"."code" to "authenticated";
|
|
|
|
grant insert on table "public"."code" to "authenticated";
|
|
|
|
grant references on table "public"."code" to "authenticated";
|
|
|
|
grant select on table "public"."code" to "authenticated";
|
|
|
|
grant trigger on table "public"."code" to "authenticated";
|
|
|
|
grant truncate on table "public"."code" to "authenticated";
|
|
|
|
grant update on table "public"."code" to "authenticated";
|
|
|
|
grant delete on table "public"."code" to "service_role";
|
|
|
|
grant insert on table "public"."code" to "service_role";
|
|
|
|
grant references on table "public"."code" to "service_role";
|
|
|
|
grant select on table "public"."code" to "service_role";
|
|
|
|
grant trigger on table "public"."code" to "service_role";
|
|
|
|
grant truncate on table "public"."code" to "service_role";
|
|
|
|
grant update on table "public"."code" to "service_role";
|
|
|
|
grant delete on table "public"."equipe-joueur" to "anon";
|
|
|
|
grant insert on table "public"."equipe-joueur" to "anon";
|
|
|
|
grant references on table "public"."equipe-joueur" to "anon";
|
|
|
|
grant select on table "public"."equipe-joueur" to "anon";
|
|
|
|
grant trigger on table "public"."equipe-joueur" to "anon";
|
|
|
|
grant truncate on table "public"."equipe-joueur" to "anon";
|
|
|
|
grant update on table "public"."equipe-joueur" to "anon";
|
|
|
|
grant delete on table "public"."equipe-joueur" to "authenticated";
|
|
|
|
grant insert on table "public"."equipe-joueur" to "authenticated";
|
|
|
|
grant references on table "public"."equipe-joueur" to "authenticated";
|
|
|
|
grant select on table "public"."equipe-joueur" to "authenticated";
|
|
|
|
grant trigger on table "public"."equipe-joueur" to "authenticated";
|
|
|
|
grant truncate on table "public"."equipe-joueur" to "authenticated";
|
|
|
|
grant update on table "public"."equipe-joueur" to "authenticated";
|
|
|
|
grant delete on table "public"."equipe-joueur" to "service_role";
|
|
|
|
grant insert on table "public"."equipe-joueur" to "service_role";
|
|
|
|
grant references on table "public"."equipe-joueur" to "service_role";
|
|
|
|
grant select on table "public"."equipe-joueur" to "service_role";
|
|
|
|
grant trigger on table "public"."equipe-joueur" to "service_role";
|
|
|
|
grant truncate on table "public"."equipe-joueur" to "service_role";
|
|
|
|
grant update on table "public"."equipe-joueur" to "service_role";
|
|
|
|
grant delete on table "public"."flag" to "anon";
|
|
|
|
grant insert on table "public"."flag" to "anon";
|
|
|
|
grant references on table "public"."flag" to "anon";
|
|
|
|
grant select on table "public"."flag" to "anon";
|
|
|
|
grant trigger on table "public"."flag" to "anon";
|
|
|
|
grant truncate on table "public"."flag" to "anon";
|
|
|
|
grant update on table "public"."flag" to "anon";
|
|
|
|
grant delete on table "public"."flag" to "authenticated";
|
|
|
|
grant insert on table "public"."flag" to "authenticated";
|
|
|
|
grant references on table "public"."flag" to "authenticated";
|
|
|
|
grant select on table "public"."flag" to "authenticated";
|
|
|
|
grant trigger on table "public"."flag" to "authenticated";
|
|
|
|
grant truncate on table "public"."flag" to "authenticated";
|
|
|
|
grant update on table "public"."flag" to "authenticated";
|
|
|
|
grant delete on table "public"."flag" to "service_role";
|
|
|
|
grant insert on table "public"."flag" to "service_role";
|
|
|
|
grant references on table "public"."flag" to "service_role";
|
|
|
|
grant select on table "public"."flag" to "service_role";
|
|
|
|
grant trigger on table "public"."flag" to "service_role";
|
|
|
|
grant truncate on table "public"."flag" to "service_role";
|
|
|
|
grant update on table "public"."flag" to "service_role";
|
|
|
|
grant delete on table "public"."flag-trouve" to "anon";
|
|
|
|
grant insert on table "public"."flag-trouve" to "anon";
|
|
|
|
grant references on table "public"."flag-trouve" to "anon";
|
|
|
|
grant select on table "public"."flag-trouve" to "anon";
|
|
|
|
grant trigger on table "public"."flag-trouve" to "anon";
|
|
|
|
grant truncate on table "public"."flag-trouve" to "anon";
|
|
|
|
grant update on table "public"."flag-trouve" to "anon";
|
|
|
|
grant delete on table "public"."flag-trouve" to "authenticated";
|
|
|
|
grant insert on table "public"."flag-trouve" to "authenticated";
|
|
|
|
grant references on table "public"."flag-trouve" to "authenticated";
|
|
|
|
grant select on table "public"."flag-trouve" to "authenticated";
|
|
|
|
grant trigger on table "public"."flag-trouve" to "authenticated";
|
|
|
|
grant truncate on table "public"."flag-trouve" to "authenticated";
|
|
|
|
grant update on table "public"."flag-trouve" to "authenticated";
|
|
|
|
grant delete on table "public"."flag-trouve" to "service_role";
|
|
|
|
grant insert on table "public"."flag-trouve" to "service_role";
|
|
|
|
grant references on table "public"."flag-trouve" to "service_role";
|
|
|
|
grant select on table "public"."flag-trouve" to "service_role";
|
|
|
|
grant trigger on table "public"."flag-trouve" to "service_role";
|
|
|
|
grant truncate on table "public"."flag-trouve" to "service_role";
|
|
|
|
grant update on table "public"."flag-trouve" to "service_role";
|
|
|
|
grant delete on table "public"."indice" to "anon";
|
|
|
|
grant insert on table "public"."indice" to "anon";
|
|
|
|
grant references on table "public"."indice" to "anon";
|
|
|
|
grant select on table "public"."indice" to "anon";
|
|
|
|
grant trigger on table "public"."indice" to "anon";
|
|
|
|
grant truncate on table "public"."indice" to "anon";
|
|
|
|
grant update on table "public"."indice" to "anon";
|
|
|
|
grant delete on table "public"."indice" to "authenticated";
|
|
|
|
grant insert on table "public"."indice" to "authenticated";
|
|
|
|
grant references on table "public"."indice" to "authenticated";
|
|
|
|
grant select on table "public"."indice" to "authenticated";
|
|
|
|
grant trigger on table "public"."indice" to "authenticated";
|
|
|
|
grant truncate on table "public"."indice" to "authenticated";
|
|
|
|
grant update on table "public"."indice" to "authenticated";
|
|
|
|
grant delete on table "public"."indice" to "service_role";
|
|
|
|
grant insert on table "public"."indice" to "service_role";
|
|
|
|
grant references on table "public"."indice" to "service_role";
|
|
|
|
grant select on table "public"."indice" to "service_role";
|
|
|
|
grant trigger on table "public"."indice" to "service_role";
|
|
|
|
grant truncate on table "public"."indice" to "service_role";
|
|
|
|
grant update on table "public"."indice" to "service_role";
|
|
|
|
grant delete on table "public"."indice-equipe" to "anon";
|
|
|
|
grant insert on table "public"."indice-equipe" to "anon";
|
|
|
|
grant references on table "public"."indice-equipe" to "anon";
|
|
|
|
grant select on table "public"."indice-equipe" to "anon";
|
|
|
|
grant trigger on table "public"."indice-equipe" to "anon";
|
|
|
|
grant truncate on table "public"."indice-equipe" to "anon";
|
|
|
|
grant update on table "public"."indice-equipe" to "anon";
|
|
|
|
grant delete on table "public"."indice-equipe" to "authenticated";
|
|
|
|
grant insert on table "public"."indice-equipe" to "authenticated";
|
|
|
|
grant references on table "public"."indice-equipe" to "authenticated";
|
|
|
|
grant select on table "public"."indice-equipe" to "authenticated";
|
|
|
|
grant trigger on table "public"."indice-equipe" to "authenticated";
|
|
|
|
grant truncate on table "public"."indice-equipe" to "authenticated";
|
|
|
|
grant update on table "public"."indice-equipe" to "authenticated";
|
|
|
|
grant delete on table "public"."indice-equipe" to "service_role";
|
|
|
|
grant insert on table "public"."indice-equipe" to "service_role";
|
|
|
|
grant references on table "public"."indice-equipe" to "service_role";
|
|
|
|
grant select on table "public"."indice-equipe" to "service_role";
|
|
|
|
grant trigger on table "public"."indice-equipe" to "service_role";
|
|
|
|
grant truncate on table "public"."indice-equipe" to "service_role";
|
|
|
|
grant update on table "public"."indice-equipe" to "service_role";
|
|
|
|
grant delete on table "public"."joueur" to "anon";
|
|
|
|
grant insert on table "public"."joueur" to "anon";
|
|
|
|
grant references on table "public"."joueur" to "anon";
|
|
|
|
grant select on table "public"."joueur" to "anon";
|
|
|
|
grant trigger on table "public"."joueur" to "anon";
|
|
|
|
grant truncate on table "public"."joueur" to "anon";
|
|
|
|
grant update on table "public"."joueur" to "anon";
|
|
|
|
grant delete on table "public"."joueur" to "authenticated";
|
|
|
|
grant insert on table "public"."joueur" to "authenticated";
|
|
|
|
grant references on table "public"."joueur" to "authenticated";
|
|
|
|
grant select on table "public"."joueur" to "authenticated";
|
|
|
|
grant trigger on table "public"."joueur" to "authenticated";
|
|
|
|
grant truncate on table "public"."joueur" to "authenticated";
|
|
|
|
grant update on table "public"."joueur" to "authenticated";
|
|
|
|
grant delete on table "public"."joueur" to "service_role";
|
|
|
|
grant insert on table "public"."joueur" to "service_role";
|
|
|
|
grant references on table "public"."joueur" to "service_role";
|
|
|
|
grant select on table "public"."joueur" to "service_role";
|
|
|
|
grant trigger on table "public"."joueur" to "service_role";
|
|
|
|
grant truncate on table "public"."joueur" to "service_role";
|
|
|
|
grant update on table "public"."joueur" to "service_role";
|
|
|
|
grant delete on table "public"."équipe" to "anon";
|
|
|
|
grant insert on table "public"."équipe" to "anon";
|
|
|
|
grant references on table "public"."équipe" to "anon";
|
|
|
|
grant select on table "public"."équipe" to "anon";
|
|
|
|
grant trigger on table "public"."équipe" to "anon";
|
|
|
|
grant truncate on table "public"."équipe" to "anon";
|
|
|
|
grant update on table "public"."équipe" to "anon";
|
|
|
|
grant delete on table "public"."équipe" to "authenticated";
|
|
|
|
grant insert on table "public"."équipe" to "authenticated";
|
|
|
|
grant references on table "public"."équipe" to "authenticated";
|
|
|
|
grant select on table "public"."équipe" to "authenticated";
|
|
|
|
grant trigger on table "public"."équipe" to "authenticated";
|
|
|
|
grant truncate on table "public"."équipe" to "authenticated";
|
|
|
|
grant update on table "public"."équipe" to "authenticated";
|
|
|
|
grant delete on table "public"."équipe" to "service_role";
|
|
|
|
grant insert on table "public"."équipe" to "service_role";
|
|
|
|
grant references on table "public"."équipe" to "service_role";
|
|
|
|
grant select on table "public"."équipe" to "service_role";
|
|
|
|
grant trigger on table "public"."équipe" to "service_role";
|
|
|
|
grant truncate on table "public"."équipe" to "service_role";
|
|
|
|
grant update on table "public"."équipe" to "service_role";
|
|
|
|
|