This is an automated email from the ASF dual-hosted git repository. ningjiang pushed a commit to branch SCB-555 in repository https://gitbox.apache.org/repos/asf/incubator-servicecomb-saga.git
commit 0a2b578cb4b0bf83c05780b4e808f42d0342ae13 Author: wuzunqian <wuzunq...@msn.com> AuthorDate: Sun May 13 15:19:34 2018 +0800 revert first --- alpha/alpha-server/src/main/resources/schema-mysql.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/alpha/alpha-server/src/main/resources/schema-mysql.sql b/alpha/alpha-server/src/main/resources/schema-mysql.sql index ecb934e..e2e5d81 100644 --- a/alpha/alpha-server/src/main/resources/schema-mysql.sql +++ b/alpha/alpha-server/src/main/resources/schema-mysql.sql @@ -27,12 +27,11 @@ CREATE TABLE IF NOT EXISTS TxEvent ( compensationMethod varchar(256) NOT NULL, expiryTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, payloads varbinary(10240), - retries int(11) NOT NULL DEFAULT '0', - retryMethod varchar(256) DEFAULT NULL, PRIMARY KEY (surrogateId), INDEX saga_events_index (surrogateId, globalTxId, localTxId, type, expiryTime) ) DEFAULT CHARSET=utf8; + CREATE TABLE IF NOT EXISTS Command ( surrogateId bigint NOT NULL AUTO_INCREMENT, eventId bigint NOT NULL UNIQUE, @@ -42,6 +41,8 @@ CREATE TABLE IF NOT EXISTS Command ( localTxId varchar(36) NOT NULL, parentTxId varchar(36) DEFAULT NULL, compensationMethod varchar(256) NOT NULL, + retryMethod varchar(256) NOT NULL, + retries int NOT NULL DEFAULT 0, payloads varbinary(10240), status varchar(12), lastModified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, @@ -50,6 +51,7 @@ CREATE TABLE IF NOT EXISTS Command ( INDEX saga_commands_index (surrogateId, eventId, globalTxId, localTxId, status) ) DEFAULT CHARSET=utf8; + CREATE TABLE IF NOT EXISTS TxTimeout ( surrogateId bigint NOT NULL AUTO_INCREMENT, eventId bigint NOT NULL UNIQUE, -- To stop receiving notification emails like this one, please contact ningji...@apache.org.