-- Rode uma vez no Supabase (SQL Editor).
CREATE TABLE IF NOT EXISTS public.setup(
  id serial PRIMARY KEY,
  app_name_or_logo text NOT NULL,
  is_logo boolean NOT NULL DEFAULT false,
  highlighted_categories jsonb DEFAULT '[]'
);
INSERT INTO public.setup (id, app_name_or_logo, is_logo, highlighted_categories)
VALUES (1,'Track Finanças',false,'[]')
ON CONFLICT (id) DO NOTHING;

CREATE TABLE IF NOT EXISTS public.categories(
  id serial PRIMARY KEY,
  categoria text NOT NULL UNIQUE,
  icon text
);
ALTER TABLE public.categories
ADD COLUMN IF NOT EXISTS icon text;

CREATE TABLE IF NOT EXISTS public.entries(
  id serial PRIMARY KEY,
  tipo text NOT NULL,
  data date NOT NULL,
  descricao text NOT NULL,
  valor numeric(12,2) NOT NULL,
  categoria_id integer REFERENCES public.categories(id) ON DELETE SET NULL
);