Mondo Diaz 9296f7eb54 Add schema enhancements for uploads, artifacts, and audit tracking ...

- Add format and platform fields to packages table
- Add checksum_md5 and metadata JSONB to artifacts with CHECK constraints
- Add updated_at and composite index to tags table
- Add tag_name, user_agent, duration_ms, deduplicated, checksum_verified to uploads
- Add change_type field to tag_history table
- Add composite indexes and GIN index to audit_logs
- Add partial index for public projects
- Add triggers for ref_count accuracy and updated_at timestamps
- Create migration script (002) for existing databases

2025-12-12 15:14:44 -06:00

9.1 KiB

Raw Permalink Blame History

View Raw