:-:  架構圖 根據架構圖需要三個數據庫。 >[info] 每個業務數據庫都必須有一個回滾日志表`undo_log`，該表可以到官網 https://github.com/seata/seata/tree/1.0.0/script/client/at/db 上獲取。 >  下面是整理好本次示例所需要的所有數據庫環境腳本，運行它即可。 ```sql CREATE DATABASE seata_order; CREATE DATABASE seata_storage; CREATE DATABASE seata_account; CREATE TABLE seata_order.t_order( id BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, user_id BIGINT(11) DEFAULT NULL COMMENT '用戶id', product_id BIGINT(11) DEFAULT NULL COMMENT '產品id', count INT(11) DEFAULT NULL COMMENT '數量', money DECIMAL(11,0) DEFAULT NULL COMMENT '金額', status INT(1) DEFAULT NULL COMMENT '訂單狀態：0：創建中; 1：已完結' ) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; CREATE TABLE seata_storage.t_storage( id BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, product_id BIGINT(11) DEFAULT NULL COMMENT '產品id', total INT(11) DEFAULT NULL COMMENT '總庫存', used INT(11) DEFAULT NULL COMMENT '已用庫存', residue INT(11) DEFAULT NULL COMMENT '剩余庫存' ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; INSERT INTO seata_storage.t_storage(id,product_id,total,used,residue) VALUES(1,1,100,0,100); CREATE TABLE seata_account.t_account( id BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'id', user_id BIGINT(11) DEFAULT NULL COMMENT '用戶id', total DECIMAL(10,0) DEFAULT NULL COMMENT '總額度', used DECIMAL(10,0) DEFAULT NULL COMMENT '已用余額', residue DECIMAL(10,0) DEFAULT '0' COMMENT '剩余可用額度' ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; INSERT INTO seata_account.t_account(id,user_id,total,used,residue) VALUES(1,1,1000,0,1000); CREATE TABLE IF NOT EXISTS seata_order.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'; CREATE TABLE IF NOT EXISTS seata_storage.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'; CREATE TABLE IF NOT EXISTS seata_account.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'; ```