rckrdmrd/erp-construccion-database-v2
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
23 Commits 1 Branch 0 Tags 318 KiB
main
Commit Graph

4 Commits

Author SHA1 Message Date
Adrian Flores Cortes
5f009673aa [REMEDIATION] feat: Database schema updates and recreate script enhancement 
Major overhaul of drop-and-recreate-database.sh, DDL schema updates,
seed data cleanup. Add utility scripts for auth table fixes.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
 2026-02-05 23:18:19 -06:00
Adrian Flores Cortes
2cd5a1cce2 fix(seeds): Update load script with new seed files 
Add 02b-hr-employees.sql and 11-infonavit.sql to execution order.
Order respects FK dependencies:
- 02b after 04 (needs fraccionamientos)
- 08 after 02b (needs employees for EPP)
- 11 at end (needs lotes)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-02-03 11:35:44 -06:00
Adrian Flores Cortes
6cd5507fc2 feat(seeds): Add comprehensive seed validation and new data files 
- Add 02b-hr-employees.sql: 15 puestos, 15 employees for HSE EPP assignments
- Add 11-infonavit.sql: registro, ofertas, derechohabientes, asignaciones
- Add validate-seeds-comprehensive.sql: FK integrity, calculations, coverage
- Update 06-estimaciones.sql: Document formula in header
- Update 08-hse.sql: Fix hse.capacitacion → hse.capacitaciones, add 6 new tables
- Update validate-seeds.sql: Fix table name reference

New tables seeded: tipos_inspeccion, inspecciones, epp_matriz_puesto,
epp_asignaciones, cumplimiento_obra, dias_sin_accidente

Coverage increased: HSE 7%→17%, INFONAVIT 0%→50%

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-02-03 11:31:59 -06:00
Adrian Flores Cortes
8df74f73d2 [TASK-2026-02-03-SEEDS] feat: Add complete development seeds for demo 
Seeds include:
- 01-core-catalogs.sql: Units, currencies, taxes, banks, states (~100 records)
- 02-users-profiles.sql: 12 roles, 50+ permissions, 12 demo users
- 03-empresa-tenant.sql: Demo company with 2 branches, 4 warehouses
- 04-proyectos-obras.sql: 3 projects, stages, lots, apartments
- 05-presupuestos.sql: CMIC-based concepts, 5 budgets
- 06-estimaciones.sql: Contracts, estimates, advances
- 07-avances-calidad.sql: Progress, logbook, quality checklists
- 08-hse.sql: PPE catalog, training, incidents
- 09-finanzas.sql: Chart of accounts, CxP, CxC, balanced entries
- 10-activos-documentos.sql: Assets, maintenance, documents

Total: ~940 records for complete demo coverage

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-02-03 11:08:26 -06:00