From c01626aa3a72f3a0603c0c9453c4bb4be7da1af7 Mon Sep 17 00:00:00 2001
From: Fuwn <contact@fuwn.net>
Date: Sun, 22 Feb 2026 08:55:31 -0800
Subject: chore(supabase): Move Supabase schema path

---
 supabase-schema.sql | 99 -----------------------------------------------------
 1 file changed, 99 deletions(-)
 delete mode 100644 supabase-schema.sql

(limited to 'supabase-schema.sql')

diff --git a/supabase-schema.sql b/supabase-schema.sql
deleted file mode 100644
index c8a5d584..00000000
--- a/supabase-schema.sql
+++ /dev/null
@@ -1,99 +0,0 @@
--- WARNING: This schema is for context only and is not meant to be run.
--- Table order and constraints may not be valid for execution.
-
-CREATE TABLE public.badges (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL,
-  created_at timestamp with time zone NOT NULL DEFAULT (now() AT TIME ZONE 'utc'::text),
-  updated_at timestamp with time zone,
-  image_url text NOT NULL,
-  image_artist text,
-  description text,
-  event bigint NOT NULL,
-  group bigint NOT NULL,
-  CONSTRAINT badges_pkey PRIMARY KEY (id),
-  CONSTRAINT badges_event_fkey FOREIGN KEY (event) REFERENCES public.events(id),
-  CONSTRAINT badges_group_fkey FOREIGN KEY (group) REFERENCES public.groups(id)
-);
-CREATE TABLE public.events (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL,
-  created_at timestamp with time zone NOT NULL DEFAULT (now() AT TIME ZONE 'utc'::text),
-  updated_at timestamp with time zone,
-  title text NOT NULL UNIQUE,
-  description text,
-  group text NOT NULL,
-  banner text NOT NULL,
-  anilist_url text NOT NULL,
-  alternative_banners ARRAY,
-  CONSTRAINT events_pkey PRIMARY KEY (id),
-  CONSTRAINT public_events_group_fkey FOREIGN KEY (group) REFERENCES public.groups(anilist_username)
-);
-CREATE TABLE public.groups (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL,
-  created_at timestamp with time zone NOT NULL DEFAULT (now() AT TIME ZONE 'utc'::text),
-  updated_at timestamp with time zone,
-  members ARRAY,
-  avatar text NOT NULL,
-  banner text NOT NULL,
-  description text,
-  name text NOT NULL UNIQUE,
-  anilist_id bigint NOT NULL UNIQUE,
-  anilist_username text NOT NULL DEFAULT ''::text UNIQUE,
-  badge text,
-  badge_description text,
-  CONSTRAINT groups_pkey PRIMARY KEY (id)
-);
-CREATE TABLE public.user_badges (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL,
-  user_id bigint NOT NULL,
-  post text NOT NULL,
-  image text NOT NULL,
-  description text,
-  time timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
-  category text,
-  hidden boolean NOT NULL DEFAULT false,
-  source text,
-  designer text,
-  shadow_hidden boolean NOT NULL DEFAULT false,
-  click_count bigint NOT NULL DEFAULT '0'::bigint,
-  CONSTRAINT user_badges_pkey PRIMARY KEY (id)
-);
-CREATE TABLE public.user_configuration (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL UNIQUE,
-  user_id bigint NOT NULL UNIQUE,
-  created_at timestamp without time zone NOT NULL DEFAULT now(),
-  updated_at timestamp without time zone,
-  configuration jsonb,
-  CONSTRAINT user_configuration_pkey PRIMARY KEY (id)
-);
-CREATE TABLE public.user_notifications (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL,
-  created_at timestamp with time zone NOT NULL DEFAULT (now() AT TIME ZONE 'utc'::text),
-  updated_at timestamp with time zone NOT NULL DEFAULT (now() AT TIME ZONE 'utc'::text),
-  user_id bigint NOT NULL UNIQUE,
-  subscription json NOT NULL,
-  fingerprint text NOT NULL,
-  CONSTRAINT user_notifications_pkey PRIMARY KEY (id)
-);
-CREATE TABLE public.user_preferences (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL,
-  created_at timestamp with time zone NOT NULL DEFAULT now(),
-  updated_at timestamp with time zone,
-  pinned_hololive_streams ARRAY NOT NULL DEFAULT '{}'::text[],
-  hide_missing_badges boolean NOT NULL DEFAULT false,
-  user_id bigint NOT NULL UNIQUE,
-  biography text,
-  badge_wall_css text NOT NULL DEFAULT ''::text,
-  hide_awc_badges boolean NOT NULL DEFAULT false,
-  pinned_badge_wall_categories ARRAY DEFAULT '{}'::text[],
-  CONSTRAINT user_preferences_pkey PRIMARY KEY (id)
-);
-CREATE TABLE public.user_tracker (
-  id bigint GENERATED ALWAYS AS IDENTITY NOT NULL,
-  user_id bigint NOT NULL,
-  created_at timestamp with time zone NOT NULL DEFAULT now(),
-  updated_at timestamp with time zone NOT NULL DEFAULT now(),
-  url text NOT NULL,
-  title text NOT NULL,
-  progress bigint NOT NULL DEFAULT '0'::bigint,
-  CONSTRAINT user_tracker_pkey PRIMARY KEY (id)
-);
-- 
cgit v1.2.3

