[Commits] 6a43a1f: More updates

7 Jan 2020

revision-id: 6a43a1f9975ba6851223db33b64959ad21f6cd6d ()
parent(s): 7f8b19cc3f261edb5beb446cef994cd65403a9bf
author: Sergei Petrunia
committer: Sergei Petrunia
timestamp: 2020-01-07 23:31:18 +0300
message:

More updates

---
 run-mysql-8.0.sh                |  1 +
 test-harness/schema-winkyao.sql | 42 ++++++++++++++++++++---------------------
 2 files changed, 22 insertions(+), 21 deletions(-)

diff --git a/run-mysql-8.0.sh b/run-mysql-8.0.sh
index b6a00a9..8f69cac 100644
--- a/run-mysql-8.0.sh
+++ b/run-mysql-8.0.sh
@@ -1,5 +1,6 @@
 bash setup-server/setup-mysql-8.0.sh
 bash test-harness/01-setup.sh
 bash test-harness/10-load-data.sh
+bash test-harness/mysql-50-eits-analyze.sh
 bash test-harness/20-generate-workload.sh
 bash test-harness/30-run-workload.sh
diff --git a/test-harness/schema-winkyao.sql b/test-harness/schema-winkyao.sql
index ad997ae..c47c543 100644
--- a/test-harness/schema-winkyao.sql
+++ b/test-harness/schema-winkyao.sql
@@ -14,7 +14,7 @@ CREATE TABLE aka_name (
     name_pcode_nf varchar(11),
     surname_pcode varchar(11),
     md5sum varchar(65)
-);
+) character set utf8 ;
 
 CREATE TABLE aka_title (
     id integer NOT NULL PRIMARY KEY,
@@ -29,7 +29,7 @@ CREATE TABLE aka_title (
     episode_nr integer,
     note varchar(72),
     md5sum varchar(32)
-);
+) character set utf8 ;
 
 -- psergey: changed "note text" to "note varchar(1000)" below:
 CREATE TABLE cast_info (
@@ -40,7 +40,7 @@ CREATE TABLE cast_info (
     note varchar(1000),
     nr_order integer,
     role_id integer NOT NULL
-);
+) character set utf8 ;
 
 CREATE TABLE char_name (
     id integer NOT NULL PRIMARY KEY,
@@ -50,12 +50,12 @@ CREATE TABLE char_name (
     name_pcode_nf varchar(5),
     surname_pcode varchar(5),
     md5sum varchar(32)
-);
+) character set utf8 ;
 
 CREATE TABLE comp_cast_type (
     id integer NOT NULL PRIMARY KEY,
     kind varchar(32) NOT NULL
-);
+) character set utf8 ;
 
 CREATE TABLE company_name (
     id integer NOT NULL PRIMARY KEY,
@@ -65,40 +65,40 @@ CREATE TABLE company_name (
     name_pcode_nf varchar(5),
     name_pcode_sf varchar(5),
     md5sum varchar(32)
-);
+) character set utf8 ;
 
 CREATE TABLE company_type (
     id integer NOT NULL PRIMARY KEY,
     kind varchar(32)
-);
+) character set utf8 ;
 
 CREATE TABLE complete_cast (
     id integer NOT NULL PRIMARY KEY,
     movie_id integer,
     subject_id integer NOT NULL,
     status_id integer NOT NULL
-);
+) character set utf8 ;
 
 CREATE TABLE info_type (
     id integer NOT NULL PRIMARY KEY,
     info varchar(32) NOT NULL
-);
+) character set utf8 ;
 
 CREATE TABLE keyword (
     id integer NOT NULL PRIMARY KEY,
     keyword varchar(512) NOT NULL,
     phonetic_code varchar(5)
-);
+) character set utf8 ;
 
 CREATE TABLE kind_type (
     id integer NOT NULL PRIMARY KEY,
     kind varchar(15)
-);
+) character set utf8 ;
 
 CREATE TABLE link_type (
     id integer NOT NULL PRIMARY KEY,
     link varchar(32) NOT NULL
-);
+) character set utf8 ;
 
 CREATE TABLE movie_companies (
     id integer NOT NULL PRIMARY KEY,
@@ -106,7 +106,7 @@ CREATE TABLE movie_companies (
     company_id integer NOT NULL,
     company_type_id integer NOT NULL,
     note text
-);
+) character set utf8 ;
 
 CREATE TABLE movie_info_idx (
     id integer NOT NULL PRIMARY KEY,
@@ -114,20 +114,20 @@ CREATE TABLE movie_info_idx (
     info_type_id integer NOT NULL,
     info text NOT NULL,
     note text
-);
+) character set utf8 ;
 
 CREATE TABLE movie_keyword (
     id integer NOT NULL PRIMARY KEY,
     movie_id integer NOT NULL,
     keyword_id integer NOT NULL
-);
+) character set utf8 ;
 
 CREATE TABLE movie_link (
     id integer NOT NULL PRIMARY KEY,
     movie_id integer NOT NULL,
     linked_movie_id integer NOT NULL,
     link_type_id integer NOT NULL
-);
+) character set utf8 ;
 
 CREATE TABLE name (
     id integer NOT NULL PRIMARY KEY,
@@ -139,12 +139,12 @@ CREATE TABLE name (
     name_pcode_nf varchar(5),
     surname_pcode varchar(5),
     md5sum varchar(32)
-);
+) character set utf8 ;
 
 CREATE TABLE role_type (
     id integer NOT NULL PRIMARY KEY,
     role varchar(32) NOT NULL
-);
+) character set utf8;
 
 CREATE TABLE title (
     id integer NOT NULL PRIMARY KEY,
@@ -159,7 +159,7 @@ CREATE TABLE title (
     episode_nr integer,
     series_years varchar(49),
     md5sum varchar(32)
-);
+) character set utf8;
 
 CREATE TABLE movie_info (
     id integer NOT NULL PRIMARY KEY,
@@ -167,7 +167,7 @@ CREATE TABLE movie_info (
     info_type_id integer NOT NULL,
     info text NOT NULL,
     note text
-);
+) character set utf8;
 
 CREATE TABLE person_info (
     id integer NOT NULL PRIMARY KEY,
@@ -175,4 +175,4 @@ CREATE TABLE person_info (
     info_type_id integer NOT NULL,
     info text NOT NULL,
     note text
-);
+) character set utf8;

    

psergey

tags

participants (1)