lbj812 opened a new issue, #6588:
URL: https://github.com/apache/incubator-seata/issues/6588
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));
无法回滚
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
