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;