WillemJiang closed pull request #184: SCB-545 (#182 )update the length of field serviceName from varchar(16) to varchar(36) URL: https://github.com/apache/incubator-servicecomb-saga/pull/184
This is a PR merged from a forked repository. As GitHub hides the original diff on merge, it is displayed below for the sake of provenance: As this is a foreign pull request (from a fork), the diff is supplied below (as it won't show otherwise due to GitHub magic): diff --git a/alpha/alpha-server/src/main/resources/schema-mysql.sql b/alpha/alpha-server/src/main/resources/schema-mysql.sql index 3806f6d1..f0560cf2 100644 --- a/alpha/alpha-server/src/main/resources/schema-mysql.sql +++ b/alpha/alpha-server/src/main/resources/schema-mysql.sql @@ -17,7 +17,7 @@ CREATE TABLE IF NOT EXISTS TxEvent ( surrogateId bigint NOT NULL AUTO_INCREMENT, - serviceName varchar(16) NOT NULL, + serviceName varchar(36) NOT NULL, instanceId varchar(36) NOT NULL, creationTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, globalTxId varchar(36) NOT NULL, @@ -35,7 +35,7 @@ CREATE TABLE IF NOT EXISTS TxEvent ( CREATE TABLE IF NOT EXISTS Command ( surrogateId bigint NOT NULL AUTO_INCREMENT, eventId bigint NOT NULL UNIQUE, - serviceName varchar(16) NOT NULL, + serviceName varchar(36) NOT NULL, instanceId varchar(36) NOT NULL, globalTxId varchar(36) NOT NULL, localTxId varchar(36) NOT NULL, @@ -55,7 +55,7 @@ CREATE TABLE IF NOT EXISTS Command ( CREATE TABLE IF NOT EXISTS TxTimeout ( surrogateId bigint NOT NULL AUTO_INCREMENT, eventId bigint NOT NULL UNIQUE, - serviceName varchar(16) NOT NULL, + serviceName varchar(36) NOT NULL, instanceId varchar(36) NOT NULL, globalTxId varchar(36) NOT NULL, localTxId varchar(36) NOT NULL, diff --git a/alpha/alpha-server/src/main/resources/schema-postgresql.sql b/alpha/alpha-server/src/main/resources/schema-postgresql.sql index 4ecb1b48..b3f77023 100644 --- a/alpha/alpha-server/src/main/resources/schema-postgresql.sql +++ b/alpha/alpha-server/src/main/resources/schema-postgresql.sql @@ -17,7 +17,7 @@ CREATE TABLE IF NOT EXISTS TxEvent ( surrogateId BIGSERIAL PRIMARY KEY, - serviceName varchar(16) NOT NULL, + serviceName varchar(36) NOT NULL, instanceId varchar(36) NOT NULL, creationTime timestamp(6) NOT NULL DEFAULT CURRENT_DATE, globalTxId varchar(36) NOT NULL, @@ -37,7 +37,7 @@ CREATE INDEX IF NOT EXISTS saga_events_index ON TxEvent (surrogateId, globalTxId CREATE TABLE IF NOT EXISTS Command ( surrogateId BIGSERIAL PRIMARY KEY, eventId bigint NOT NULL UNIQUE, - serviceName varchar(16) NOT NULL, + serviceName varchar(36) NOT NULL, instanceId varchar(36) NOT NULL, globalTxId varchar(36) NOT NULL, localTxId varchar(36) NOT NULL, @@ -55,7 +55,7 @@ CREATE INDEX IF NOT EXISTS saga_commands_index ON Command (surrogateId, eventId, CREATE TABLE IF NOT EXISTS TxTimeout ( surrogateId BIGSERIAL PRIMARY KEY, eventId bigint NOT NULL UNIQUE, - serviceName varchar(16) NOT NULL, + serviceName varchar(36) NOT NULL, instanceId varchar(36) NOT NULL, globalTxId varchar(36) NOT NULL, localTxId varchar(36) NOT NULL, ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services