- Ya
- 9 Agosti 2026, 04:41 UTC
- Mwandishi
- Kamo
- Ahadi ya
- 5b68459
Mirrors OrgStorageSnapshot as explicit DDL, per the house style — ddl-auto creates the table first, so the CREATE is a fallback and the SET DEFAULTs are what actually make it usable from plain SQL (Hibernate emits no column defaults for values the entity fills in Java). Also indexes imgs on (ORG_ID, DATE_CREATED) and (ORG_ID, DATE_TRASHED). Storage aggregation reads both on every summary request and the existing indexes are all assoc- and folder-shaped. Run against production 2026-08-08; org_storage_snapshots verified with all 16 columns and its uniqueness constraint before the shared-lib entity was pushed.