Closed lbj812 closed 3 months ago
CREATE TABLE sto_kucun_move_detail_title ( id bigint(20) NOT NULL AUTO_INCREMENT, mtanr_vouch_no varchar(60) NOT NULL COMMENT '商品凭证编号', order_date datetime NOT NULL COMMENT '单据日期(业务日期,凭证日期)', posting_date datetime DEFAULT NULL COMMENT '过账日期', create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期', cankao_vouch_text varchar(60) DEFAULT NULL COMMENT '参考凭证文本', vouch_title_text varchar(60) DEFAULT NULL COMMENT '凭证抬头文本', note_order_no varchar(300) DEFAULT NULL COMMENT '备注单号', vouch_type varchar(2) DEFAULT NULL COMMENT 'C1出库 R1入库 A1移库', td_order varchar(20) DEFAULT NULL COMMENT '天端参考单号', order_type varchar(10) DEFAULT NULL COMMENT '单据类型', order_type_name varchar(50) DEFAULT NULL COMMENT '天端订单类型描述', sapcankao_order varchar(20) DEFAULT NULL COMMENT 'sap参考编号', congxiao_vouch_no varchar(30) DEFAULT NULL COMMENT '冲销凭证的凭证号', imei_update_result int(1) NOT NULL DEFAULT '0' COMMENT '串码更新结果 1完成', imei_update_flag int(1) NOT NULL DEFAULT '0' COMMENT '串码更新标识 0否,1是', update_time datetime DEFAULT NULL COMMENT '更新时间', create_user varchar(30) DEFAULT NULL COMMENT '创建者用户名', create_name varchar(50) DEFAULT NULL COMMENT '创建者姓名', congxiao_flag varchar(1) DEFAULT NULL COMMENT '冲销标识:1冲销2被冲销', business_type varchar(5) DEFAULT NULL COMMENT '业务类型', version int(10) DEFAULT NULL, churuku_status int(1) DEFAULT NULL COMMENT '出入库标识 1出库 2入库', manual_status varchar(2) DEFAULT '0' COMMENT '是否手工更新(0为否,1为是)', PRIMARY KEY (id, create_time), UNIQUE KEY sto_goods_vouch (mtanr_vouch_no) GLOBAL, UNIQUE KEY id (id) GLOBAL, KEY order_date (order_date) GLOBAL, KEY order_type (order_type) GLOBAL, KEY sapcankao_order (sapcankao_order) GLOBAL, KEY td_order (td_order) GLOBAL ) DEFAULT CHARSET = utf8mb4 COMMENT = '物料凭证抬头表' partition by list(year(create_time)) (partition p2020 values in (2020), partition p2021 values in (2021), partition p2022 values in (2022), partition p2023 values in (2023), partition p2024 values in (2024), partition p2025 values in (2025)); 无法回滚
sto_kucun_move_detail_title
id
mtanr_vouch_no
order_date
posting_date
create_time
cankao_vouch_text
vouch_title_text
note_order_no
vouch_type
td_order
order_type
order_type_name
sapcankao_order
congxiao_vouch_no
imei_update_result
imei_update_flag
update_time
create_user
create_name
congxiao_flag
business_type
version
churuku_status
manual_status
sto_goods_vouch
什么版本?
seata是 1.7.0 数据库是 OceanBase mysql模式 3.2.3版本
异常信息发出来呀
CREATE TABLE
sto_kucun_move_detail_title
(id
bigint(20) NOT NULL AUTO_INCREMENT,mtanr_vouch_no
varchar(60) NOT NULL COMMENT '商品凭证编号',order_date
datetime NOT NULL COMMENT '单据日期(业务日期,凭证日期)',posting_date
datetime DEFAULT NULL COMMENT '过账日期',create_time
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',cankao_vouch_text
varchar(60) DEFAULT NULL COMMENT '参考凭证文本',vouch_title_text
varchar(60) DEFAULT NULL COMMENT '凭证抬头文本',note_order_no
varchar(300) DEFAULT NULL COMMENT '备注单号',vouch_type
varchar(2) DEFAULT NULL COMMENT 'C1出库 R1入库 A1移库',td_order
varchar(20) DEFAULT NULL COMMENT '天端参考单号',order_type
varchar(10) DEFAULT NULL COMMENT '单据类型',order_type_name
varchar(50) DEFAULT NULL COMMENT '天端订单类型描述',sapcankao_order
varchar(20) DEFAULT NULL COMMENT 'sap参考编号',congxiao_vouch_no
varchar(30) DEFAULT NULL COMMENT '冲销凭证的凭证号',imei_update_result
int(1) NOT NULL DEFAULT '0' COMMENT '串码更新结果 1完成',imei_update_flag
int(1) NOT NULL DEFAULT '0' COMMENT '串码更新标识 0否,1是',update_time
datetime DEFAULT NULL COMMENT '更新时间',create_user
varchar(30) DEFAULT NULL COMMENT '创建者用户名',create_name
varchar(50) DEFAULT NULL COMMENT '创建者姓名',congxiao_flag
varchar(1) DEFAULT NULL COMMENT '冲销标识:1冲销2被冲销',business_type
varchar(5) DEFAULT NULL COMMENT '业务类型',version
int(10) DEFAULT NULL,churuku_status
int(1) DEFAULT NULL COMMENT '出入库标识 1出库 2入库',manual_status
varchar(2) DEFAULT '0' COMMENT '是否手工更新(0为否,1为是)', PRIMARY KEY (id
,create_time
), UNIQUE KEYsto_goods_vouch
(mtanr_vouch_no
) GLOBAL, UNIQUE KEYid
(id
) GLOBAL, KEYorder_date
(order_date
) GLOBAL, KEYorder_type
(order_type
) GLOBAL, KEYsapcankao_order
(sapcankao_order
) GLOBAL, KEYtd_order
(td_order
) GLOBAL ) DEFAULT CHARSET = utf8mb4 COMMENT = '物料凭证抬头表' partition by list(year(create_time)) (partition p2020 values in (2020), partition p2021 values in (2021), partition p2022 values in (2022), partition p2023 values in (2023), partition p2024 values in (2024), partition p2025 values in (2025)); 无法回滚