Database SQL Guidelines
=======================

This folder contains SQL assets for the TAF ERP project.

Files:
- `TAFDB.sql` (at repo root) holds **only** table definitions. Do not include data
  inserts here.
- `sql/defaults.sql` stores default production data such as statutory rates,
  system settings and the initial super admin account.
- `demoData/combined.sql` holds demo or sample data used for testing. No table
  definitions should appear there.

When adding or modifying tables:
- Ensure every table has an `id` INT AUTO_INCREMENT primary key.
- Include an `UpdatedAt` TIMESTAMP DEFAULT CURRENT_TIMESTAMP column.
- Include an `isDeleted` TINYINT DEFAULT 0 column for soft deletes.
- Do **not** create foreign key constraints. Add indexes as needed.

Any schema changes must be reflected in `TAFDB.sql` and follow the above
conventions.
