This is an automated email from the ASF dual-hosted git repository. ningjiang pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/incubator-servicecomb-saga.git
commit f21fd3731e8807616a05ca916738a29107e9a6a5 Author: SingleX <single...@gmail.com> AuthorDate: Wed Jul 18 10:45:57 2018 +0800 SCB-741 change payloads database type from varbinary(10240) to blob --- alpha/alpha-server/src/main/resources/schema-mysql.sql | 4 ++-- alpha/alpha-server/src/test/resources/schema.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 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..b159857 100644 --- a/alpha/alpha-server/src/main/resources/schema-mysql.sql +++ b/alpha/alpha-server/src/main/resources/schema-mysql.sql @@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS TxEvent ( type varchar(50) NOT NULL, compensationMethod varchar(256) NOT NULL, expiryTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, - payloads varbinary(10240), + payloads blob, retries int(11) NOT NULL DEFAULT '0', retryMethod varchar(256) DEFAULT NULL, PRIMARY KEY (surrogateId), @@ -42,7 +42,7 @@ CREATE TABLE IF NOT EXISTS Command ( localTxId varchar(36) NOT NULL, parentTxId varchar(36) DEFAULT NULL, compensationMethod varchar(256) NOT NULL, - payloads varbinary(10240), + payloads blob, status varchar(12), lastModified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, version bigint NOT NULL, diff --git a/alpha/alpha-server/src/test/resources/schema.sql b/alpha/alpha-server/src/test/resources/schema.sql index 8d70899..0da2686 100644 --- a/alpha/alpha-server/src/test/resources/schema.sql +++ b/alpha/alpha-server/src/test/resources/schema.sql @@ -28,7 +28,7 @@ CREATE TABLE IF NOT EXISTS TxEvent ( expiryTime TIMESTAMP NOT NULL, retryMethod varchar(256) NOT NULL, retries int DEFAULT 0 NOT NULL, - payloads varbinary(10240) + payloads blob ); CREATE TABLE IF NOT EXISTS Command ( @@ -40,7 +40,7 @@ CREATE TABLE IF NOT EXISTS Command ( localTxId varchar(36) NOT NULL, parentTxId varchar(36) DEFAULT NULL, compensationMethod varchar(256) NOT NULL, - payloads varbinary(10240), + payloads blob, status varchar(12), lastModified TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, version bigint NOT NULL