1861267969
a:14:{s:2:"id";a:6:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";N;s:6:"length";i:11;s:8:"unsigned";b:0;s:3:"key";s:7:"primary";}s:8:"store_id";a:6:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:11;s:8:"unsigned";b:0;s:3:"key";s:5:"index";}s:8:"local_id";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:11;s:8:"unsigned";b:0;}s:12:"reference_id";a:8:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:100;s:3:"key";s:5:"index";s:7:"collate";s:18:"utf8mb4_general_ci";s:7:"comment";s:41:"Bill reference_id for bill-related errors";s:7:"charset";s:7:"utf8mb4";}s:10:"table_name";a:7:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";N;s:6:"length";i:100;s:7:"collate";s:18:"utf8mb4_general_ci";s:7:"comment";s:29:"Source table that failed sync";s:7:"charset";s:7:"utf8mb4";}s:9:"record_id";a:6:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:11;s:8:"unsigned";b:0;s:7:"comment";s:37:"ID of the specific record that failed";}s:13:"error_message";a:7:{s:4:"type";s:4:"text";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:7:"collate";s:18:"utf8mb4_general_ci";s:7:"comment";s:32:"SQL or application error message";s:7:"charset";s:7:"utf8mb4";}s:11:"record_data";a:7:{s:4:"type";s:4:"text";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:7:"collate";s:18:"utf8mb4_general_ci";s:7:"comment";s:39:"JSON snapshot of the record that failed";s:7:"charset";s:7:"utf8mb4";}s:9:"direction";a:8:{s:4:"type";s:19:"enum('push','pull')";s:4:"null";b:1;s:7:"default";s:4:"push";s:6:"length";i:4;s:3:"key";s:5:"index";s:7:"collate";s:18:"utf8mb4_general_ci";s:7:"comment";s:34:"Sync direction when error occurred";s:7:"charset";s:7:"utf8mb4";}s:8:"attempts";a:6:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"1";s:6:"length";i:11;s:8:"unsigned";b:0;s:7:"comment";s:23:"Number of sync attempts";}s:8:"resolved";a:7:{s:4:"type";s:11:"tinyinteger";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";i:4;s:8:"unsigned";b:0;s:3:"key";s:5:"index";s:7:"comment";s:50:"1 = manually resolved or auto-retried successfully";}s:4:"sync";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";s:1:"0";s:6:"length";i:11;s:8:"unsigned";b:0;}s:7:"created";a:4:{s:4:"type";s:8:"datetime";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:8:"modified";a:4:{s:4:"type";s:8:"datetime";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}}
