KamoCRM

**************** — every charter owner table carries every CharterItem column and its owner, from the docs/sql files in order and a dated legacy baseline (KamoCollab CP03 T7)

TestSecurityService
Shipped
October 5, 2026 at 9:02 PM UTC
Author
Kamo
Commit
ebae37e

The program's one cross-table charter DDL guard (master R1-12). It reads every docs/sql/*.sql in filename order and collects what the six owner tables (dept_requirements, org_job_title_requirements, org_role_charter_items, member_charter_items, team_charter_items, org_charter_items) get from CREATE TABLE IF NOT EXISTS (a no-op for an existing table) and ALTER TABLE ... ADD COLUMN IF NOT EXISTS, and asserts each carries every column its shared-lib entity maps: CharterItem's (the legacy text override applied) plus its owner column. LEGACY_BASELINE holds the department and job-title columns Hibernate created before any file, read from production information_schema on 2026-10-05 (read-only). A failure names the table and the column. The shared-lib change moves two catalog pins: maxItemsPerOwner is 500 (D4) and the catalog lists the sixteen sections.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing