USE ecofina_billing;

INSERT INTO settings (
  business_name, address, phone, email, gstin, state_name, state_code, logo_path,
  cgst_percent, sgst_percent, igst_percent, default_hsn, invoice_prefix,
  invoice_financial_year, invoice_padding, next_invoice_number, declaration_text, terms_text
)
SELECT
  'ECO FINA',
  'Building No. 9/190 A, Feroke College Road, Melekalathodi, Ramanattukara, Feroke, Kozhikode, Kerala - 673631',
  '+91 8129806530',
  '',
  '32BSOPB0944D1Z8',
  'Kerala',
  '32',
  '/public/uploads/logo.png',
  2.50,
  2.50,
  5.00,
  '4803',
  'EF',
  '2026-27',
  4,
  1,
  'We declare that this invoice shows the actual price of the goods described and that all particulars are true and correct.',
  'Goods once sold will not be taken back.'
WHERE NOT EXISTS (SELECT 1 FROM settings);
