ALTER TABLE expenses
  ADD COLUMN receipt_file VARCHAR(500) DEFAULT NULL;

CREATE TABLE IF NOT EXISTS workshop_settings (
  id TINYINT UNSIGNED NOT NULL,
  business_name VARCHAR(120) NOT NULL DEFAULT 'FIAC',
  phone VARCHAR(20) DEFAULT NULL,
  gstin VARCHAR(20) DEFAULT NULL,
  address VARCHAR(255) DEFAULT NULL,
  invoice_header VARCHAR(255) DEFAULT NULL,
  invoice_footer VARCHAR(500) DEFAULT NULL,
  tax_one_name VARCHAR(40) DEFAULT NULL,
  tax_two_name VARCHAR(40) DEFAULT NULL,
  financial_year VARCHAR(9) DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO workshop_settings (id, business_name, invoice_header, invoice_footer, financial_year)
SELECT 1, 'FIAC', 'Tax Invoice', 'Thank you for choosing FIAC.', '2026-27'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM workshop_settings WHERE id = 1);

CREATE TABLE IF NOT EXISTS booking_requests (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  customer_name VARCHAR(80) NOT NULL,
  phone VARCHAR(20) NOT NULL,
  vehicle_number VARCHAR(20) NOT NULL,
  note VARCHAR(255) DEFAULT NULL,
  preferred_date DATE DEFAULT NULL,
  status ENUM('pending', 'completed') NOT NULL DEFAULT 'pending',
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  KEY idx_booking_requests_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;