diff options
Diffstat (limited to 'mysql-test/include/world_schema.inc')
| -rw-r--r-- | mysql-test/include/world_schema.inc | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/include/world_schema.inc b/mysql-test/include/world_schema.inc index c683faf0114..bd7b768e83b 100644 --- a/mysql-test/include/world_schema.inc +++ b/mysql-test/include/world_schema.inc @@ -6,7 +6,7 @@ CREATE TABLE Country ( Capital int(11) default NULL, PRIMARY KEY (Code), UNIQUE INDEX (Name) -); +) COLLATE latin1_bin; CREATE TABLE City ( ID int(11) NOT NULL auto_increment, Name char(35) NOT NULL default '', @@ -15,11 +15,11 @@ CREATE TABLE City ( PRIMARY KEY (ID), INDEX (Population), INDEX (Country) -); +) COLLATE latin1_bin; CREATE TABLE CountryLanguage ( Country char(3) NOT NULL default '', Language char(30) NOT NULL default '', Percentage float(3,1) NOT NULL default '0.0', PRIMARY KEY (Country, Language), INDEX (Percentage) -); +) COLLATE latin1_bin; |