*Popular dados criará as categorias padrão e lançamentos simulados no Supabase.

Antes de conectar, crie as tabelas necessárias no painel do Supabase executando o script abaixo no seu **SQL Editor**:

CREATE TABLE accounts (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  initial_balance NUMERIC(12, 2) NOT NULL DEFAULT 0.00,
  color TEXT NOT NULL,
  icon TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) NOT NULL
);

CREATE TABLE categories (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  type TEXT NOT NULL,
  color TEXT NOT NULL,
  icon TEXT NOT NULL
);

CREATE TABLE transactions (
  id TEXT PRIMARY KEY DEFAULT gen_random_uuid(),
  description TEXT NOT NULL,
  amount NUMERIC(12, 2) NOT NULL,
  type TEXT NOT NULL,
  category TEXT REFERENCES categories(id) ON DELETE SET NULL,
  account_id TEXT REFERENCES accounts(id) ON DELETE SET NULL,
  date DATE NOT NULL,
  status TEXT NOT NULL,
  recurrence TEXT NOT NULL DEFAULT 'none'
);

CREATE TABLE IF NOT EXISTS fee_clients (
  id          UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  name        TEXT NOT NULL,
  description TEXT,
  amount      NUMERIC(12,2) NOT NULL,
  due_day     INTEGER NOT NULL DEFAULT 5,
  category_id TEXT,
  account_id  TEXT,
  active      BOOLEAN DEFAULT true,
  created_at  TIMESTAMPTZ DEFAULT now()
);

ALTER TABLE fee_clients DISABLE ROW LEVEL SECURITY;

CREATE TABLE IF NOT EXISTS op_cost_categories (
  id TEXT PRIMARY KEY,
  name TEXT UNIQUE NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) NOT NULL
);

ALTER TABLE op_cost_categories DISABLE ROW LEVEL SECURITY;