/**
 * Organization bounded context, first slice: companies (legal entities
 * that issue contracts/documents) — Master Prompt §6.1. Shape ported
 * faithfully from the legacy (eden.md §1.4), since this is validated,
 * production-tested data. Warehouses/branches/cost centers land in a
 * later migration once Inventory/Finance need them — Master Prompt §6.1
 * explicitly warns against leaving `companies` isolated forever, but
 * that linkage is real work for those later phases, not invented now.
 */

exports.shorthands = undefined;

exports.up = (pgm) => {
  pgm.sql(`
    CREATE TABLE companies (
      id                      UUID PRIMARY KEY DEFAULT gen_random_uuid(),
      created_at              TIMESTAMPTZ NOT NULL DEFAULT now(),
      updated_at              TIMESTAMPTZ NOT NULL DEFAULT now(),
      created_by              UUID REFERENCES users(id),
      company_name            TEXT NOT NULL,
      trade_name              TEXT,
      cnpj                    TEXT,
      state_registration      TEXT,
      municipal_registration  TEXT,
      address_zip             TEXT,
      address_street          TEXT,
      address_number          TEXT,
      address_complement      TEXT,
      address_neighborhood    TEXT,
      address_city            TEXT,
      address_state           TEXT,
      address_country         TEXT NOT NULL DEFAULT 'Brasil',
      phone                   TEXT,
      email                   TEXT,
      website                 TEXT,
      legal_rep_name          TEXT,
      legal_rep_cpf           TEXT,
      legal_rep_role          TEXT,
      legal_rep_email         TEXT,
      is_active               BOOLEAN NOT NULL DEFAULT true
    );
    COMMENT ON TABLE companies IS
      'Empresa(s) emissora(s) de contrato/documento — eden.md §1.4. Leitura aberta a qualquer autenticado (não sensível), escrita restrita à permissão companies:manage.';

    CREATE TRIGGER trg_companies_updated_at BEFORE UPDATE ON companies
      FOR EACH ROW EXECUTE FUNCTION set_updated_at();

    CREATE INDEX idx_companies_active ON companies(is_active);
  `);
};

exports.down = (pgm) => {
  pgm.sql(`DROP TABLE IF EXISTS companies;`);
};