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

4 Commits

Author SHA1 Message Date
Adrian Flores Cortes
d736622985 [TASK-2026-02-05-EJECUCION-REMEDIATION-ERP-CORE] fix: Complete recreate-database.sh with missing DDL files and schemas 
- Add 03b-core-companies.sql and 21b-inventory-extended.sql to DDL array
- Add 8 missing schemas to create_base_schemas(): operations, fiscal, payment_terminals, core_settings, reports, financial, hr, projects
- Update validate_database() schema lists to include all 24 schemas
- Verified: 208 tables across 24 schemas created successfully

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
 2026-02-05 22:07:39 -06:00
Adrian Flores Cortes
02ab2caf26 [TASK-2026-02-05-EJECUCION-REMEDIATION-ERP-CORE] feat: DDL fixes and new schemas 
- 00-auth-base.sql: Extracted auth.tenants+users from recreate-database.sh
- 03b-core-companies.sql: DDL for auth.companies entity
- 21b-inventory-extended.sql: 7 new tables for inventory entities without DDL
- 24-invoices.sql: billing→operations schema to resolve duplication
- 27/28/29-cfdi: Track existing CFDI DDL files
- recreate-database.sh: Updated ddl_files array (17→43 entries)

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
 2026-02-05 21:52:22 -06:00
rckrdmrd
5043a640e4 refactor: Restructure DDL with numbered schema files 
- Replace old DDL structure with new numbered files (01-24)
- Update migrations and seeds for new schema
- Clean up deprecated files

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-16 00:40:32 -06:00
rckrdmrd
e4cb9b6db6 Initial commit - erp-core-database 2026-01-04 06:40:22 -06:00