CHAT_OUTPUT_BEGIN
COMMAND_ID=SUPPORT-260918-GRAM-XF-CODEVIPE-POST-513R3R4-RECONCILIATION-513R3R5
STATUS=OK
RC=0
HOST=pve01
MODE=read-only
COMPONENT=gram-support-codevipe-post-513r3r4-reconciliation
REFERENCE_REGISTER_CHECK=OK
REFERENCE_SHA256=5a3d8e5154c41cb582a4e0aca68090be1f0138918bf82131a948df326f9d8d66
ERROR_REGISTER_CHECK=OK
ERROR_REGISTER_SHA256=3b09a553ec0f527ed3afeed4753f52a74ee3036045bbfb3c685e9f8af4ba7ba0
COMMAND_SHA256=6065eb014a49cdccb8fc5102cc290b3e1dbdf69fd2321accc87290e0cc4178e8
DUPLICATE_FAILED_COMMAND_BLOCKED=false
EXECUTION_STARTED=true
CHANGE_DECLARED=false
RESULT_CONTRACT_VALID=true
RESULT_CONTRACT_STATUS=NOT_APPLICABLE
RESULT_CONTRACT_ERROR=NONE
COMMAND_RC=0
CHANGES_MADE=false
ROLLBACK_STARTED=false
ROLLBACK_RESTORED=null
MUTATION_OUTCOME=NO_MUTATION
SANITIZED=yes
SECRETS_INCLUDED=no
PRIVATE_ADDRESSES_INCLUDED=no
RAW_EVIDENCE_SHA256=c3a55276a873b54f04e42c52897076b0a2e8329dc394bfacb2c775ce613611bd
SANITIZED_OUTPUT_SHA256=c3a55276a873b54f04e42c52897076b0a2e8329dc394bfacb2c775ce613611bd
OUTPUT_BEGIN
GRAM513R3R5_WRAPPER_BEGIN=true
ERROR_REGISTER_CHECK=OK
REFERENCE_CHECK=OK
AUTHORITY_CHECK_SCOPE=READABILITY_ONLY_INCIDENTS_NOT_CLOSED
GRAM513R3R5_SAFE_REPORT={"artifact_sha256":"2e31f89d3626a83c1211910aa6fd279cc04689b75ba822899952865085cf551e","codevipe":{"ok":true,"state":{"addon":null,"counts":{"xf_content_type_field":0,"xf_code_event_listener":0,"xf_option":0,"xf_option_group":0,"xf_permission":0,"xf_permission_interface_group":0,"xf_phrase":0,"xf_route":0,"xf_template":0,"xf_template_modification":0},"support_tables":{"xf_gram_support_attachment_meta":{"rows":0,"ddl_sha256":"3c3d2ce4c5dae793687243dca37f60cd781895818b546a68e227aef9bfc9b6b2","ddl":"CREATE TABLE `xf_gram_support_attachment_meta` (\n  `attachment_id` int(10) unsigned NOT NULL,\n  `ticket_id` int(10) unsigned NOT NULL,\n  `message_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `is_internal` tinyint(3) unsigned NOT NULL DEFAULT 0,\n  `created_date` int(10) unsigned NOT NULL DEFAULT 0,\n  PRIMARY KEY (`attachment_id`),\n  KEY `ticket_internal` (`ticket_id`,`is_internal`),\n  KEY `message_id` (`message_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_delivery":{"rows":0,"ddl_sha256":"91f068994bdbe4b168ab1c82fa669180f13825e6d1a7f5b9e956ccc872d0410d","ddl":"CREATE TABLE `xf_gram_support_delivery` (\n  `delivery_key` char(64) NOT NULL,\n  `event_id` int(10) unsigned NOT NULL,\n  `consumer` varchar(32) NOT NULL,\n  `recipient_key` varchar(96) NOT NULL,\n  `state` varchar(16) NOT NULL DEFAULT 'pending',\n  `lease_expires` int(10) unsigned NOT NULL DEFAULT 0,\n  `attempt_count` int(10) unsigned NOT NULL DEFAULT 0,\n  `last_failure_class` varchar(191) NOT NULL DEFAULT '',\n  `created_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `updated_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `sent_date` int(10) unsigned NOT NULL DEFAULT 0,\n  PRIMARY KEY (`delivery_key`),\n  KEY `event_consumer` (`event_id`,`consumer`),\n  KEY `state_lease` (`state`,`lease_expires`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_event":{"rows":0,"ddl_sha256":"81b6328dbbcf3f6405891897ba185e29890c675f21d7a2f9caf827c0eddb42da","ddl":"CREATE TABLE `xf_gram_support_event` (\n  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `ticket_id` int(10) unsigned NOT NULL,\n  `site_id` varchar(32) NOT NULL,\n  `actor_user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `event_type` varchar(64) NOT NULL,\n  `event_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `safe_payload_json` mediumtext NOT NULL,\n  PRIMARY KEY (`event_id`),\n  KEY `ticket_date` (`ticket_id`,`event_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_event__conflict":{"rows":0,"ddl_sha256":"3ec4d00d4e0a209d8ca439e47639ec9462e4ed6ae4a3abfab564ba53a5f8aaca","ddl":"CREATE TABLE `xf_gram_support_event__conflict` (\n  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `ticket_id` int(10) unsigned NOT NULL,\n  `site_id` varchar(32) NOT NULL,\n  `actor_user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `event_type` varchar(64) NOT NULL,\n  `event_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `safe_payload_json` mediumtext NOT NULL,\n  PRIMARY KEY (`event_id`),\n  KEY `ticket_date` (`ticket_id`,`event_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_message":{"rows":0,"ddl_sha256":"a00e534c642179db3018c74060d1aa6cef4dc445dcb801eb847c04d770f8f884","ddl":"CREATE TABLE `xf_gram_support_message` (\n  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `ticket_id` int(10) unsigned NOT NULL,\n  `user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `is_staff` tinyint(3) unsigned NOT NULL DEFAULT 0,\n  `is_internal` tinyint(3) unsigned NOT NULL DEFAULT 0,\n  `message` mediumtext NOT NULL,\n  `message_date` int(10) unsigned NOT NULL DEFAULT 0,\n  PRIMARY KEY (`message_id`),\n  KEY `ticket_date` (`ticket_id`,`message_date`),\n  KEY `ticket_public_date` (`ticket_id`,`is_internal`,`message_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_message__conflict":{"rows":0,"ddl_sha256":"49d3e846099ebd4b869957e558afe1ff4a5cb0e1449623462b78c55bd68b6808","ddl":"CREATE TABLE `xf_gram_support_message__conflict` (\n  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `ticket_id` int(10) unsigned NOT NULL,\n  `user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `is_staff` tinyint(3) unsigned NOT NULL DEFAULT 0,\n  `is_internal` tinyint(3) unsigned NOT NULL DEFAULT 0,\n  `message` mediumtext NOT NULL,\n  `message_date` int(10) unsigned NOT NULL DEFAULT 0,\n  PRIMARY KEY (`message_id`),\n  KEY `ticket_date` (`ticket_id`,`message_date`),\n  KEY `ticket_public_date` (`ticket_id`,`is_internal`,`message_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_rate_limit":{"rows":0,"ddl_sha256":"f2271e20d520a8ba413b2094a4f8f6640395065c7d9c2e4f5b0a74b790d3dd8e","ddl":"CREATE TABLE `xf_gram_support_rate_limit` (\n  `rate_key` char(64) NOT NULL,\n  `window_start` int(10) unsigned NOT NULL,\n  `hit_count` int(10) unsigned NOT NULL DEFAULT 0,\n  `updated_date` int(10) unsigned NOT NULL DEFAULT 0,\n  PRIMARY KEY (`rate_key`),\n  KEY `updated_date` (`updated_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_ticket":{"rows":0,"ddl_sha256":"3558077fc70b4453960d1d782998ad498b2d3b12ba587488e8b23785979f7ba8","ddl":"CREATE TABLE `xf_gram_support_ticket` (\n  `ticket_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `public_ref` varchar(64) NOT NULL,\n  `site_id` varchar(32) NOT NULL,\n  `user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `guest_email` varchar(255) NOT NULL DEFAULT '',\n  `guest_access_token_hash` char(64) NOT NULL DEFAULT '',\n  `guest_access_expires` int(10) unsigned NOT NULL DEFAULT 0,\n  `node_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `thread_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `post_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `category` varchar(64) NOT NULL DEFAULT '',\n  `subject` varchar(255) NOT NULL DEFAULT '',\n  `status` varchar(32) NOT NULL DEFAULT 'NEW',\n  `assigned_user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `created_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `updated_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `resolved_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `context_json` mediumtext NOT NULL,\n  `last_message_id` int(10) unsigned NOT NULL DEFAULT 0,\n  PRIMARY KEY (`ticket_id`),\n  UNIQUE KEY `public_ref` (`public_ref`),\n  KEY `guest_token_hash` (`guest_access_token_hash`),\n  KEY `site_user_updated` (`site_id`,`user_id`,`updated_date`),\n  KEY `site_status_updated` (`site_id`,`status`,`updated_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"},"xf_gram_support_ticket__conflict":{"rows":0,"ddl_sha256":"5c952146662e5d701a49c2fa206b8f8ce1811e7f4e06dca7698d9c8dd4c0de1a","ddl":"CREATE TABLE `xf_gram_support_ticket__conflict` (\n  `ticket_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `public_ref` varchar(64) NOT NULL,\n  `site_id` varchar(32) NOT NULL,\n  `user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `guest_email` varchar(255) NOT NULL DEFAULT '',\n  `guest_access_token_hash` char(64) NOT NULL DEFAULT '',\n  `guest_access_expires` int(10) unsigned NOT NULL DEFAULT 0,\n  `node_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `thread_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `post_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `category` varchar(64) NOT NULL DEFAULT '',\n  `subject` varchar(255) NOT NULL DEFAULT '',\n  `status` varchar(32) NOT NULL DEFAULT 'NEW',\n  `assigned_user_id` int(10) unsigned NOT NULL DEFAULT 0,\n  `created_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `updated_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `resolved_date` int(10) unsigned NOT NULL DEFAULT 0,\n  `context_json` mediumtext NOT NULL,\n  `last_message_id` int(10) unsigned NOT NULL DEFAULT 0,\n  PRIMARY KEY (`ticket_id`),\n  UNIQUE KEY `public_ref` (`public_ref`),\n  KEY `guest_token_hash` (`guest_access_token_hash`),\n  KEY `site_user_updated` (`site_id`,`user_id`,`updated_date`),\n  KEY `site_status_updated` (`site_id`,`status`,`updated_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"}},"routes":[],"options":[],"permission_entries":[],"jobs":[{"job_id":4,"execute_class":"XF\\Job\\Cron","manual_execute":0},{"job_id":50,"execute_class":"XF\\Job\\UpgradeCheck","manual_execute":0}],"errors":[],"footer_template":null,"board_active":"1","board_url":"https://codevipe.ru","xf":{"version_id":2031170,"version_string":"2.3.11"},"php":"8.3.32"},"manifest":{"file_count":59,"combined_sha256":"c8c3fbe24b22c47338dc06b49eeee10f56038804812c715f53e2607d88502f29","paths":["js/gram/support/access.js","js/gram/support/access.min.js","js/gram/support/pwa/icon-192.png","js/gram/support/pwa/icon-512.png","js/gram/support/pwa/manifest.webmanifest","js/gram/support/pwa/offline.html","js/gram/support/staff-pwa.js","js/gram/support/staff-pwa.min.js","src/addons/Gram/Support/Attachment/TicketHandler.php","src/addons/Gram/Support/Entity/AttachmentMeta.php","src/addons/Gram/Support/Entity/Delivery.php","src/addons/Gram/Support/Entity/Message.php","src/addons/Gram/Support/Entity/RateLimit.php","src/addons/Gram/Support/Entity/SupportEvent.php","src/addons/Gram/Support/Entity/Ticket.php","src/addons/Gram/Support/Listener/SourcePageContext.php","src/addons/Gram/Support/Notification/AlertConsumer.php","src/addons/Gram/Support/Notification/DeliveryGate.php","src/addons/Gram/Support/Notification/Dispatcher.php","src/addons/Gram/Support/Notification/EmailConsumer.php","src/addons/Gram/Support/Notification/EntityDeliveryGate.php","src/addons/Gram/Support/Notification/EventDispatcher.php","src/addons/Gram/Support/Notification/Policy.php","src/addons/Gram/Support/Notification/RecipientKey.php","src/addons/Gram/Support/Pub/Controller/AccountSupport.php","src/addons/Gram/Support/Pub/Controller/Pwa.php","src/addons/Gram/Support/Pub/Controller/StaffSupport.php","src/addons/Gram/Support/Pub/Controller/Support.php","src/addons/Gram/Support/Pub/View/PwaServiceWorker.php","src/addons/Gram/Support/Repository/Message.php","src/addons/Gram/Support/Repository/Ticket.php","src/addons/Gram/Support/Security/GuestTicketSession.php","src/addons/Gram/Support/Security/TicketAccess.php","src/addons/Gram/Support/Service/GuestScreenshotService.php","src/addons/Gram/Support/Service/GuestTicketCreateAttachmentFlow.php","src/addons/Gram/Support/Service/RateLimiter.php","src/addons/Gram/Support/Service/SourceContextResolver.php","src/addons/Gram/Support/Service/Ticket/Creator.php","src/addons/Gram/Support/Service/Ticket/Reply.php","src/addons/Gram/Support/Service/Ticket/StaffUpdate.php","src/addons/Gram/Support/Setup.php","src/addons/Gram/Support/Util/GuestToken.php","src/addons/Gram/Support/Util/PublicRef.php","src/addons/Gram/Support/Util/RateKey.php","src/addons/Gram/Support/Util/SafeContext.php","src/addons/Gram/Support/Util/SiteConfig.php","src/addons/Gram/Support/Util/StatusPolicy.php","src/addons/Gram/Support/_data/code_event_listeners.xml","src/addons/Gram/Support/_data/content_type_fields.xml","src/addons/Gram/Support/_data/option_groups.xml","src/addons/Gram/Support/_data/options.xml","src/addons/Gram/Support/_data/permission_interface_groups.xml","src/addons/Gram/Support/_data/permissions.xml","src/addons/Gram/Support/_data/phrases.xml","src/addons/Gram/Support/_data/routes.xml","src/addons/Gram/Support/_data/template_modifications.xml","src/addons/Gram/Support/_data/templates.xml","src/addons/Gram/Support/addon.json","src/addons/Gram/Support/hashes.json"]}},"classification":{"canonical_six_present":true,"support_tables_all_empty":true,"conflict_tables":["xf_gram_support_event__conflict","xf_gram_support_message__conflict","xf_gram_support_ticket__conflict"],"conflict_count":3,"expected_schema_conflict_errors":[],"expected_schema_conflict_error_count":0,"other_recent_errors":[],"addon_present":false,"routes_count":0,"permissions_count":0,"footer_v7":false,"footer_shift":false}}
GRAM513R3R5_DECISION=PASS_POST_513R3R4_RECONCILIATION
GRAM513R3R5_NEXT_GATE=READY_FOR_PRESERVE_LEGACY_TABLES_FINAL_CODEVIPE_CANARY_513R3R6
HOMELAB_RESULT_CONTRACT={"version":1,"command_id":"SUPPORT-260918-GRAM-XF-CODEVIPE-POST-513R3R4-RECONCILIATION-513R3R5","status":"OK","changes_made":false,"rollback_started":false,"rollback_restored":null}

OUTPUT_END
CHAT_OUTPUT_END
