fescar分布式事务

最新推荐文章于 2020-06-10 15:46:05 发布

weixin_33963189

最新推荐文章于 2020-06-10 15:46:05 发布

阅读量94

点赞数

文章标签： python

原文链接：https://my.oschina.net/u/2983845/blog/3019071

版权

2019独角兽企业重金招聘Python工程师标准>>>

https://www.oschina.net/p/fescar

表：

CREATE TABLE `undo_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`branch_id` bigint(20) NOT NULL COMMENT 'branch_id',
`xid` varchar(100) NOT NULL COMMENT 'xid',
`rollback_info` longblob NOT NULL COMMENT 'aaa',
`log_status` int(11) NOT NULL COMMENT 'aaa',
`log_created` datetime NOT NULL COMMENT 'aaa',
`log_modified` datetime NOT NULL COMMENT 'aaa',
`ext` varchar(100) DEFAULT NULL COMMENT 'aaa',
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='undo_log表';

CREATE TABLE `storage_tbl` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`commodity_code` varchar(255) DEFAULT NULL COMMENT 'aaa',
`count` int(11) DEFAULT 0 COMMENT 'aaa',
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='storage_tbl表';

CREATE TABLE `order_tbl` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`user_id` varchar(255) DEFAULT NULL COMMENT 'aaa',
`commodity_code` varchar(255) DEFAULT NULL COMMENT 'aaa',
`count` int(11) DEFAULT 0 COMMENT 'aaa',
`money` int(11) DEFAULT 0 COMMENT 'aaa',
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',

PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='order_tbl表';

CREATE TABLE `account_tbl` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`user_id` varchar(255) DEFAULT NULL COMMENT 'aaa',
`money` int(11) DEFAULT 0 COMMENT 'aaa',
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='account_tbl表';

转载于:https://my.oschina.net/u/2983845/blog/3019071