spawn ssh -o StrictHostKeyChecking=no opsuser@8.147.119.215 sudo -S -i bash -lc 'obclient -h127.0.0.1 -P2883 -uzhct_user@sys#city_subcenter_ob -p<redacted> -D zhct_csfzx -N -e "SHOW CREATE TABLE ydy_identity_type\G; SELECT * FROM ydy_identity_type; INSERT INTO ydy_identity_type(identity_type,remark,create_by,create_time,update_time,is_delete) SELECT \"内部员工\",\"城市副中心测试人员导入默认身份类别\",\"codex-test\",NOW(),NOW(),0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM ydy_identity_type WHERE identity_type=\"内部员工\" AND is_delete=0); SELECT * FROM ydy_identity_type;"'

opsuser@8.147.119.215's password:
[sudo] password for opsuser: <redacted>
*************************** 1. row ***************************
ydy_identity_type
CREATE TABLE `ydy_identity_type` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `identity_type` varchar(64) NOT NULL DEFAULT '' COMMENT '身份类型',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `store_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商城ID',
  `create_by` varchar(64) NOT NULL DEFAULT '' COMMENT '创建人',
  `update_by` varchar(64) NOT NULL DEFAULT '' COMMENT '更新人',
  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：1=是；0=否',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_identity_type` (`identity_type`) BLOCK_SIZE 16384 LOCAL
) ORGANIZATION INDEX AUTO_INCREMENT = 1 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 COMMENT = '身份管理'
1	内部员工	城市副中心测试人员导入默认身份类别	0	codex-test		0	2026-06-22 15:08:01	2026-06-22 15:08:01