[41/50] [abbrv] ignite git commit: IGNITE-10432: Fixed data types in world.sql.
IGNITE-10432: Fixed data types in world.sql. Project: http://git-wip-us.apache.org/repos/asf/ignite/repo Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/d21f86f9 Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/d21f86f9 Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/d21f86f9 Branch: refs/heads/ignite-10044 Commit: d21f86f9e7817481acbb9438a9e07ca605246807 Parents: 3606b21 Author: devozerov Authored: Wed Nov 28 11:11:20 2018 +0300 Committer: devozerov Committed: Wed Nov 28 11:11:20 2018 +0300 -- examples/sql/world.sql | 28 ++-- 1 file changed, 14 insertions(+), 14 deletions(-) -- http://git-wip-us.apache.org/repos/asf/ignite/blob/d21f86f9/examples/sql/world.sql -- diff --git a/examples/sql/world.sql b/examples/sql/world.sql index a34ee71..829fba1 100644 --- a/examples/sql/world.sql +++ b/examples/sql/world.sql @@ -2,30 +2,30 @@ DROP TABLE IF EXISTS Country; CREATE TABLE Country ( Code CHAR(3) PRIMARY KEY, - Name CHAR(52), - Continent CHAR(50), - Region CHAR(26), + Name VARCHAR, + Continent VARCHAR, + Region VARCHAR, SurfaceArea DECIMAL(10,2), - IndepYear SMALLINT(6), - Population INT(11), + IndepYear SMALLINT, + Population INT, LifeExpectancy DECIMAL(3,1), GNP DECIMAL(10,2), GNPOld DECIMAL(10,2), - LocalName CHAR(45), - GovernmentForm CHAR(45), - HeadOfState CHAR(60), - Capital INT(11), + LocalName VARCHAR, + GovernmentForm VARCHAR, + HeadOfState VARCHAR, + Capital INT, Code2 CHAR(2) ) WITH "template=partitioned, backups=1, CACHE_NAME=Country, VALUE_TYPE=demo.model.Country"; DROP TABLE IF EXISTS City; CREATE TABLE City ( - ID INT(11), - Name CHAR(35), + ID INT, + Name VARCHAR, CountryCode CHAR(3), - District CHAR(20), - Population INT(11), + District VARCHAR, + Population INT, PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City"; @@ -35,7 +35,7 @@ DROP TABLE IF EXISTS CountryLanguage; CREATE TABLE CountryLanguage ( CountryCode CHAR(3), - Language CHAR(30), + Language VARCHAR, IsOfficial CHAR(2), Percentage DECIMAL(4,1), PRIMARY KEY (CountryCode, Language)
[47/50] [abbrv] ignite git commit: IGNITE-10432: Fixed data types in world.sql.
IGNITE-10432: Fixed data types in world.sql. Project: http://git-wip-us.apache.org/repos/asf/ignite/repo Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/d21f86f9 Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/d21f86f9 Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/d21f86f9 Branch: refs/heads/ignite-9720 Commit: d21f86f9e7817481acbb9438a9e07ca605246807 Parents: 3606b21 Author: devozerov Authored: Wed Nov 28 11:11:20 2018 +0300 Committer: devozerov Committed: Wed Nov 28 11:11:20 2018 +0300 -- examples/sql/world.sql | 28 ++-- 1 file changed, 14 insertions(+), 14 deletions(-) -- http://git-wip-us.apache.org/repos/asf/ignite/blob/d21f86f9/examples/sql/world.sql -- diff --git a/examples/sql/world.sql b/examples/sql/world.sql index a34ee71..829fba1 100644 --- a/examples/sql/world.sql +++ b/examples/sql/world.sql @@ -2,30 +2,30 @@ DROP TABLE IF EXISTS Country; CREATE TABLE Country ( Code CHAR(3) PRIMARY KEY, - Name CHAR(52), - Continent CHAR(50), - Region CHAR(26), + Name VARCHAR, + Continent VARCHAR, + Region VARCHAR, SurfaceArea DECIMAL(10,2), - IndepYear SMALLINT(6), - Population INT(11), + IndepYear SMALLINT, + Population INT, LifeExpectancy DECIMAL(3,1), GNP DECIMAL(10,2), GNPOld DECIMAL(10,2), - LocalName CHAR(45), - GovernmentForm CHAR(45), - HeadOfState CHAR(60), - Capital INT(11), + LocalName VARCHAR, + GovernmentForm VARCHAR, + HeadOfState VARCHAR, + Capital INT, Code2 CHAR(2) ) WITH "template=partitioned, backups=1, CACHE_NAME=Country, VALUE_TYPE=demo.model.Country"; DROP TABLE IF EXISTS City; CREATE TABLE City ( - ID INT(11), - Name CHAR(35), + ID INT, + Name VARCHAR, CountryCode CHAR(3), - District CHAR(20), - Population INT(11), + District VARCHAR, + Population INT, PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City"; @@ -35,7 +35,7 @@ DROP TABLE IF EXISTS CountryLanguage; CREATE TABLE CountryLanguage ( CountryCode CHAR(3), - Language CHAR(30), + Language VARCHAR, IsOfficial CHAR(2), Percentage DECIMAL(4,1), PRIMARY KEY (CountryCode, Language)
ignite git commit: IGNITE-10432: Fixed data types in world.sql.
Repository: ignite Updated Branches: refs/heads/ignite-2.7 038bb75d4 -> c87e67069 IGNITE-10432: Fixed data types in world.sql. Project: http://git-wip-us.apache.org/repos/asf/ignite/repo Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/c87e6706 Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/c87e6706 Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/c87e6706 Branch: refs/heads/ignite-2.7 Commit: c87e67069ac692084054dd9c1c283e142abc5f57 Parents: 038bb75 Author: devozerov Authored: Wed Nov 28 11:11:20 2018 +0300 Committer: devozerov Committed: Wed Nov 28 11:14:21 2018 +0300 -- examples/sql/world.sql | 28 ++-- 1 file changed, 14 insertions(+), 14 deletions(-) -- http://git-wip-us.apache.org/repos/asf/ignite/blob/c87e6706/examples/sql/world.sql -- diff --git a/examples/sql/world.sql b/examples/sql/world.sql index a34ee71..829fba1 100644 --- a/examples/sql/world.sql +++ b/examples/sql/world.sql @@ -2,30 +2,30 @@ DROP TABLE IF EXISTS Country; CREATE TABLE Country ( Code CHAR(3) PRIMARY KEY, - Name CHAR(52), - Continent CHAR(50), - Region CHAR(26), + Name VARCHAR, + Continent VARCHAR, + Region VARCHAR, SurfaceArea DECIMAL(10,2), - IndepYear SMALLINT(6), - Population INT(11), + IndepYear SMALLINT, + Population INT, LifeExpectancy DECIMAL(3,1), GNP DECIMAL(10,2), GNPOld DECIMAL(10,2), - LocalName CHAR(45), - GovernmentForm CHAR(45), - HeadOfState CHAR(60), - Capital INT(11), + LocalName VARCHAR, + GovernmentForm VARCHAR, + HeadOfState VARCHAR, + Capital INT, Code2 CHAR(2) ) WITH "template=partitioned, backups=1, CACHE_NAME=Country, VALUE_TYPE=demo.model.Country"; DROP TABLE IF EXISTS City; CREATE TABLE City ( - ID INT(11), - Name CHAR(35), + ID INT, + Name VARCHAR, CountryCode CHAR(3), - District CHAR(20), - Population INT(11), + District VARCHAR, + Population INT, PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City"; @@ -35,7 +35,7 @@ DROP TABLE IF EXISTS CountryLanguage; CREATE TABLE CountryLanguage ( CountryCode CHAR(3), - Language CHAR(30), + Language VARCHAR, IsOfficial CHAR(2), Percentage DECIMAL(4,1), PRIMARY KEY (CountryCode, Language)
ignite git commit: IGNITE-10432: Fixed data types in world.sql.
Repository: ignite Updated Branches: refs/heads/master 3606b21bf -> d21f86f9e IGNITE-10432: Fixed data types in world.sql. Project: http://git-wip-us.apache.org/repos/asf/ignite/repo Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/d21f86f9 Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/d21f86f9 Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/d21f86f9 Branch: refs/heads/master Commit: d21f86f9e7817481acbb9438a9e07ca605246807 Parents: 3606b21 Author: devozerov Authored: Wed Nov 28 11:11:20 2018 +0300 Committer: devozerov Committed: Wed Nov 28 11:11:20 2018 +0300 -- examples/sql/world.sql | 28 ++-- 1 file changed, 14 insertions(+), 14 deletions(-) -- http://git-wip-us.apache.org/repos/asf/ignite/blob/d21f86f9/examples/sql/world.sql -- diff --git a/examples/sql/world.sql b/examples/sql/world.sql index a34ee71..829fba1 100644 --- a/examples/sql/world.sql +++ b/examples/sql/world.sql @@ -2,30 +2,30 @@ DROP TABLE IF EXISTS Country; CREATE TABLE Country ( Code CHAR(3) PRIMARY KEY, - Name CHAR(52), - Continent CHAR(50), - Region CHAR(26), + Name VARCHAR, + Continent VARCHAR, + Region VARCHAR, SurfaceArea DECIMAL(10,2), - IndepYear SMALLINT(6), - Population INT(11), + IndepYear SMALLINT, + Population INT, LifeExpectancy DECIMAL(3,1), GNP DECIMAL(10,2), GNPOld DECIMAL(10,2), - LocalName CHAR(45), - GovernmentForm CHAR(45), - HeadOfState CHAR(60), - Capital INT(11), + LocalName VARCHAR, + GovernmentForm VARCHAR, + HeadOfState VARCHAR, + Capital INT, Code2 CHAR(2) ) WITH "template=partitioned, backups=1, CACHE_NAME=Country, VALUE_TYPE=demo.model.Country"; DROP TABLE IF EXISTS City; CREATE TABLE City ( - ID INT(11), - Name CHAR(35), + ID INT, + Name VARCHAR, CountryCode CHAR(3), - District CHAR(20), - Population INT(11), + District VARCHAR, + Population INT, PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City"; @@ -35,7 +35,7 @@ DROP TABLE IF EXISTS CountryLanguage; CREATE TABLE CountryLanguage ( CountryCode CHAR(3), - Language CHAR(30), + Language VARCHAR, IsOfficial CHAR(2), Percentage DECIMAL(4,1), PRIMARY KEY (CountryCode, Language)