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, 'Controle Financeiro Simples', false, '[]')
ON CONFLICT (id) DO NOTHING;

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

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
);