ONE-SYSTEM M3.3B — MODULE INSTALLATION / LICENSE / ACTIVATION CONTRACT v0.1 ======================================================================= READ-ONLY / NO DATA OR SCHEMA MODIFICATION [0] DATABASE PASS — Expected database — amiga723_one_system_vnext_v02 [1] REQUIRED TABLES PASS — Table core_installations PASS — Table core_licenses PASS — Table core_license_modules PASS — Table core_license_activations PASS — Table core_license_events PASS — Table core_modules PASS — Table core_module_versions [2] LIVE COLUMN CONTRACTS --- core_installations --- 1 id char(26) NULL=NO KEY=PRI DEFAULT=NULL 2 installation_id char(64) NULL=NO KEY=UNI DEFAULT=NULL 3 tenant_id char(26) NULL=YES KEY=MUL DEFAULT=NULL 4 mode varchar(30) NULL=NO KEY= DEFAULT='ONESYSTEM' 5 domain varchar(255) NULL=YES KEY= DEFAULT=NULL 6 installed_at datetime NULL=NO KEY= DEFAULT=NULL 7 last_seen_at datetime NULL=YES KEY= DEFAULT=NULL 8 app_version varchar(40) NULL=YES KEY= DEFAULT=NULL 9 php_version varchar(20) NULL=YES KEY= DEFAULT=NULL 10 status varchar(20) NULL=NO KEY= DEFAULT='ACTIVE' --- core_licenses --- 1 id char(26) NULL=NO KEY=PRI DEFAULT=NULL 2 tenant_id char(26) NULL=YES KEY=MUL DEFAULT=NULL 3 license_uid char(26) NULL=NO KEY=UNI DEFAULT=NULL 4 license_key_hash char(64) NULL=NO KEY=UNI DEFAULT=NULL 5 plan_id char(26) NULL=NO KEY=MUL DEFAULT=NULL 6 issued_at datetime NULL=NO KEY= DEFAULT=NULL 7 starts_at datetime NULL=NO KEY= DEFAULT=NULL 8 expires_at datetime NULL=YES KEY= DEFAULT=NULL 9 status varchar(30) NULL=NO KEY= DEFAULT='ACTIVE' 10 max_activations int(11) NULL=YES KEY= DEFAULT=NULL 11 activation_count int(11) NULL=NO KEY= DEFAULT=0 12 revoked_at datetime NULL=YES KEY= DEFAULT=NULL 13 revocation_reason text NULL=YES KEY= DEFAULT=NULL 14 customer_name varchar(200) NULL=YES KEY= DEFAULT=NULL 15 customer_email varchar(255) NULL=YES KEY= DEFAULT=NULL 16 signature_algorithm varchar(40) NULL=NO KEY= DEFAULT='Ed25519' 17 license_payload_hash char(64) NULL=YES KEY= DEFAULT=NULL 18 signature text NULL=NO KEY= DEFAULT=NULL 19 created_at timestamp NULL=NO KEY= DEFAULT=current_timestamp() 20 updated_at timestamp NULL=NO KEY= DEFAULT=current_timestamp() --- core_license_modules --- 1 id char(26) NULL=NO KEY=PRI DEFAULT=NULL 2 license_id char(26) NULL=NO KEY=MUL DEFAULT=NULL 3 module_id char(26) NULL=NO KEY=MUL DEFAULT=NULL 4 module_version varchar(40) NULL=YES KEY= DEFAULT=NULL 5 starts_at datetime NULL=NO KEY= DEFAULT=NULL 6 expires_at datetime NULL=YES KEY= DEFAULT=NULL 7 status varchar(30) NULL=NO KEY= DEFAULT='ACTIVE' --- core_license_activations --- 1 id char(26) NULL=NO KEY=PRI DEFAULT=NULL 2 license_id char(26) NULL=NO KEY=MUL DEFAULT=NULL 3 activation_code_hash char(64) NULL=YES KEY= DEFAULT=NULL 4 installation_id char(64) NULL=NO KEY= DEFAULT=NULL 5 machine_fingerprint_hash char(64) NULL=YES KEY= DEFAULT=NULL 6 hostname varchar(255) NULL=YES KEY= DEFAULT=NULL 7 ip_address varchar(45) NULL=YES KEY= DEFAULT=NULL 8 activated_at datetime NULL=NO KEY= DEFAULT=NULL 9 last_seen_at datetime NULL=YES KEY= DEFAULT=NULL 10 deactivated_at datetime NULL=YES KEY= DEFAULT=NULL 11 status varchar(30) NULL=NO KEY= DEFAULT='ACTIVE' --- core_license_events --- 1 id char(26) NULL=NO KEY=PRI DEFAULT=NULL 2 license_id char(26) NULL=NO KEY=MUL DEFAULT=NULL 3 event_type varchar(50) NULL=NO KEY= DEFAULT=NULL 4 event_at datetime NULL=NO KEY= DEFAULT=NULL 5 actor_user_id char(26) NULL=YES KEY=MUL DEFAULT=NULL 6 installation_id char(64) NULL=YES KEY= DEFAULT=NULL 7 event_data longtext NULL=YES KEY= DEFAULT=NULL --- core_modules --- 1 id char(26) NULL=NO KEY=PRI DEFAULT=NULL 2 code varchar(80) NULL=NO KEY=UNI DEFAULT=NULL 3 name varchar(160) NULL=NO KEY= DEFAULT=NULL 4 description text NULL=YES KEY= DEFAULT=NULL 5 module_type varchar(30) NULL=NO KEY= DEFAULT='APPLICATION' 6 current_version varchar(40) NULL=YES KEY= DEFAULT=NULL 7 standalone_capable tinyint(1) NULL=NO KEY= DEFAULT=1 8 active tinyint(1) NULL=NO KEY= DEFAULT=1 9 created_at timestamp NULL=NO KEY= DEFAULT=current_timestamp() 10 updated_at timestamp NULL=NO KEY= DEFAULT=current_timestamp() --- core_module_versions --- 1 id char(26) NULL=NO KEY=PRI DEFAULT=NULL 2 module_id char(26) NULL=NO KEY=MUL DEFAULT=NULL 3 version varchar(40) NULL=NO KEY= DEFAULT=NULL 4 release_channel varchar(30) NULL=NO KEY= DEFAULT='stable' 5 package_hash char(64) NULL=YES KEY= DEFAULT=NULL 6 min_php_version varchar(20) NULL=YES KEY= DEFAULT=NULL 7 min_core_version varchar(40) NULL=YES KEY= DEFAULT=NULL 8 status varchar(20) NULL=NO KEY= DEFAULT='ACTIVE' 9 release_notes text NULL=YES KEY= DEFAULT=NULL 10 created_at timestamp NULL=NO KEY= DEFAULT=current_timestamp() [3] FOREIGN KEYS --- core_installations --- fk_core_installation_tenant: tenant_id -> core_tenants.id --- core_licenses --- fk_core_license_plan: plan_id -> core_license_plans.id fk_core_license_tenant: tenant_id -> core_tenants.id --- core_license_modules --- fk_core_license_module_license: license_id -> core_licenses.id fk_core_license_module_module: module_id -> core_modules.id --- core_license_activations --- fk_core_license_activation_license: license_id -> core_licenses.id --- core_license_events --- fk_core_license_event_actor: actor_user_id -> core_users.id fk_core_license_event_license: license_id -> core_licenses.id --- core_modules --- NONE --- core_module_versions --- fk_core_module_version_module: module_id -> core_modules.id [4] EXISTING DATA COUNTS core_installations = 0 core_licenses = 0 core_license_modules = 0 core_license_activations = 0 core_license_events = 0 core_modules = 0 core_module_versions = 0 [5] FINAL Status: PASS Schema discovery completed. READ-ONLY — NO DATA OR SCHEMA MODIFIED.