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表';