github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/imdb

exec
CREATE TABLE aka_name (
    id integer NOT NULL PRIMARY KEY,
    person_id integer NOT NULL,
    name text NOT NULL,
    imdb_index character varying(12),
    name_pcode_cf character varying(5),
    name_pcode_nf character varying(5),
    surname_pcode character varying(5),
    md5sum character varying(32)
);
----

exec
CREATE TABLE aka_title (
    id integer NOT NULL PRIMARY KEY,
    movie_id integer NOT NULL,
    title text NOT NULL,
    imdb_index character varying(12),
    kind_id integer NOT NULL,
    production_year integer,
    phonetic_code character varying(5),
    episode_of_id integer,
    season_nr integer,
    episode_nr integer,
    note text,
    md5sum character varying(32)
);
----

exec
CREATE TABLE cast_info (
    id integer NOT NULL PRIMARY KEY,
    person_id integer NOT NULL,
    movie_id integer NOT NULL,
    person_role_id integer,
    note text,
    nr_order integer,
    role_id integer NOT NULL
);
----

exec
CREATE TABLE char_name (
    id integer NOT NULL PRIMARY KEY,
    name text NOT NULL,
    imdb_index character varying(12),
    imdb_id integer,
    name_pcode_nf character varying(5),
    surname_pcode character varying(5),
    md5sum character varying(32)
);
----

exec
CREATE TABLE comp_cast_type (
    id integer NOT NULL PRIMARY KEY,
    kind character varying(32) NOT NULL
);
----

exec
CREATE TABLE company_name (
    id integer NOT NULL PRIMARY KEY,
    name text NOT NULL,
    country_code character varying(255),
    imdb_id integer,
    name_pcode_nf character varying(5),
    name_pcode_sf character varying(5),
    md5sum character varying(32)
);
----

exec
CREATE TABLE company_type (
    id integer NOT NULL PRIMARY KEY,
    kind character varying(32) NOT NULL
);
----

exec
CREATE TABLE complete_cast (
    id integer NOT NULL PRIMARY KEY,
    movie_id integer,
    subject_id integer NOT NULL,
    status_id integer NOT NULL
);
----

exec
CREATE TABLE info_type (
    id integer NOT NULL PRIMARY KEY,
    info character varying(32) NOT NULL
);
----

exec
CREATE TABLE keyword (
    id integer NOT NULL PRIMARY KEY,
    keyword text NOT NULL,
    phonetic_code character varying(5)
);
----

exec
CREATE TABLE kind_type (
    id integer NOT NULL PRIMARY KEY,
    kind character varying(15) NOT NULL
);
----

exec
CREATE TABLE link_type (
    id integer NOT NULL PRIMARY KEY,
    link character varying(32) NOT NULL
);
----

exec
CREATE TABLE movie_companies (
    id integer NOT NULL PRIMARY KEY,
    movie_id integer NOT NULL,
    company_id integer NOT NULL,
    company_type_id integer NOT NULL,
    note text
);
----

exec
CREATE TABLE movie_info (
    id integer NOT NULL PRIMARY KEY,
    movie_id integer NOT NULL,
    info_type_id integer NOT NULL,
    info text NOT NULL,
    note text
);
----

exec
CREATE TABLE movie_info_idx (
    id integer NOT NULL PRIMARY KEY,
    movie_id integer NOT NULL,
    info_type_id integer NOT NULL,
    info text NOT NULL,
    note text
);
----

exec
CREATE TABLE movie_keyword (
    id integer NOT NULL PRIMARY KEY,
    movie_id integer NOT NULL,
    keyword_id integer NOT NULL
);
----

exec
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
);
----

exec
CREATE TABLE name (
    id integer NOT NULL PRIMARY KEY,
    name text NOT NULL,
    imdb_index character varying(12),
    imdb_id integer,
    gender character varying(1),
    name_pcode_cf character varying(5),
    name_pcode_nf character varying(5),
    surname_pcode character varying(5),
    md5sum character varying(32)
);
----

exec
CREATE TABLE person_info (
    id integer NOT NULL PRIMARY KEY,
    person_id integer NOT NULL,
    info_type_id integer NOT NULL,
    info text NOT NULL,
    note text
);
----

exec
CREATE TABLE role_type (
    id integer NOT NULL PRIMARY KEY,
    role character varying(32) NOT NULL
);
----

exec
CREATE TABLE title (
    id integer NOT NULL PRIMARY KEY,
    title text NOT NULL,
    imdb_index character varying(12),
    kind_id integer NOT NULL,
    production_year integer,
    imdb_id integer,
    phonetic_code character varying(5),
    episode_of_id integer,
    season_nr integer,
    episode_nr integer,
    series_years character varying(49),
    md5sum character varying(32)
);
----

exec
create index company_id_movie_companies on movie_companies(company_id);
----

exec
create index company_type_id_movie_companies on movie_companies(company_type_id);
----

exec
create index info_type_id_movie_info_idx on movie_info_idx(info_type_id);
----

exec
create index info_type_id_movie_info on movie_info(info_type_id);
----

exec
create index info_type_id_person_info on person_info(info_type_id);
----

exec
create index keyword_id_movie_keyword on movie_keyword(keyword_id);
----

exec
create index kind_id_aka_title on aka_title(kind_id);
----

exec
create index kind_id_title on title(kind_id);
----

exec
create index linked_movie_id_movie_link on movie_link(linked_movie_id);
----

exec
create index link_type_id_movie_link on movie_link(link_type_id);
----

exec
create index movie_id_aka_title on aka_title(movie_id);
----

exec
create index movie_id_cast_info on cast_info(movie_id);
----

exec
create index movie_id_complete_cast on complete_cast(movie_id);
----

exec
create index movie_id_movie_companies on movie_companies(movie_id);
----

exec
create index movie_id_movie_info_idx on movie_info_idx(movie_id);
----

exec
create index movie_id_movie_keyword on movie_keyword(movie_id);
----

exec
create index movie_id_movie_link on movie_link(movie_id);
----

exec
create index movie_id_movie_info on movie_info(movie_id);
----

exec
create index person_id_aka_name on aka_name(person_id);
----

exec
create index person_id_cast_info on cast_info(person_id);
----

exec
create index person_id_person_info on person_info(person_id);
----

exec
create index person_role_id_cast_info on cast_info(person_role_id);
----

exec
create index role_id_cast_info on cast_info(role_id);
----

exec
analyze table aka_name update histogram on id using data '{"row_count": 900662}';
----
exec
analyze table aka_title update histogram on id using data '{"row_count": 361376}';
----
exec
analyze table cast_info update histogram on id using data '{"row_count": 36124530}';
----
exec
analyze table char_name update histogram on id using data '{"row_count": 3136382}';
----
exec
analyze table company_name update histogram on id using data '{"row_count": 234825}';
----
exec
analyze table company_type update histogram on id using data '{"row_count": 4}';
----
exec
analyze table complete_cast update histogram on id using data '{"row_count": 135086}';
----
exec
analyze table comp_cast_type update histogram on id using data '{"row_count": 4}';
----
exec
analyze table info_type update histogram on id using data '{"row_count": 113}';
----
exec
analyze table keyword update histogram on id using data '{"row_count": 134110}';
----
exec
analyze table kind_type update histogram on id using data '{"row_count": 7}';
----
exec
analyze table link_type update histogram on id using data '{"row_count": 18}';
----
exec
analyze table movie_companies update histogram on id using data '{"row_count": 2604067}';
----
exec
analyze table movie_info update histogram on id using data '{"row_count": 14355706}';
----
exec
analyze table movie_info_idx update histogram on id using data '{"row_count": 1380035}';
----
exec
analyze table movie_keyword update histogram on id using data '{"row_count": 4523930}';
----
exec
analyze table movie_link update histogram on id using data '{"row_count": 29997}';
----
exec
analyze table name update histogram on id using data '{"row_count": 4167453}';
----
exec
analyze table person_info update histogram on id using data '{"row_count": 2024951}';
----
exec
analyze table row_type update histogram on id using data '{"row_count": 12}';
----
analyze table title update histogram on id using data '{"row_count": 2527799}';
----