You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
1.0 KiB
22 lines
1.0 KiB
1 week ago
|
SET NAMES utf8mb4;
|
||
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Seata AT模式本地事务补偿表。请在所有数据库中创建该表。
|
||
|
|
-- ----------------------------
|
||
|
|
CREATE TABLE IF NOT EXISTS `undo_log` (
|
||
|
|
`id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'increment id',
|
||
|
|
`branch_id` BIGINT(20) NOT NULL COMMENT 'branch transaction id',
|
||
|
|
`xid` VARCHAR(100) NOT NULL COMMENT 'global transaction id',
|
||
|
|
`context` VARCHAR(128) NOT NULL COMMENT 'undo_log context,such as serialization',
|
||
|
|
`rollback_info` LONGBLOB NOT NULL COMMENT 'rollback info',
|
||
|
|
`log_status` INT(11) NOT NULL COMMENT '0:normal status,1:defense status',
|
||
|
|
`log_created` DATETIME NOT NULL COMMENT 'create datetime',
|
||
|
|
`log_modified` DATETIME NOT NULL COMMENT 'modify datetime',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `ux_undo_log` (`xid`, `branch_id`)
|
||
|
|
) ENGINE = InnoDB
|
||
|
|
AUTO_INCREMENT = 1
|
||
|
|
DEFAULT CHARSET = utf8 COMMENT ='AT transaction mode undo table';
|
||
|
|
SET FOREIGN_KEY_CHECKS = 1;
|