VgP4t3HQ

1insert into title
2select tconst from title_basics;
3
4alter table title_basics
5	alter column genres type text[] 
6		using string_to_array(genres,',');
7
8alter table title_basics
9	add constraint title_basics_pk
10		primary key (tconst);
11
12alter table name_basics
13	add constraint name_basics_pk
14		primary key (nconst);		
15
16create index title_principals_tconst_index
17  on title_principals (tconst);
18
19create index title_principals_nconst_index
20  on title_principals (nconst);
21  
22create index title_ratings_tconst_index
23  on title_ratings (tconst);
24
25create index title_ratings_num_votes_average_rating_tconst_index
26  on title_ratings (num_votes desc, average_rating desc, tconst asc);
27
28alter table title_ratings
29	add constraint title_ratings_title_basics_tconst_fk
30		foreign key (tconst) references title_basics;
31
32create index name_basics_primary_name_index
33  on name_basics (primary_name);
34
35CREATE EXTENSION IF NOT EXISTS pg_trgm;
36
37create index trgm_primary_name_idx ON name_basics USING GIN (primary_name gin_trgm_ops);
38
39create index trgm_primary_title_idx ON title_basics USING GIN (primary_title gin_trgm_ops);
40
41create index trgm_genre_index on title_basics using gin(genres);