Matthew Welch
308b1e1791
The project structure has been changed to make it more manageable and modular. A search feature has been added to the comics page.
35 lines
1.5 KiB
SQL
35 lines
1.5 KiB
SQL
.mode csv
|
|
.import {0}title_akas.csv title_akas
|
|
.print "title_akas finished importing"
|
|
.import {0}title_basics.csv title_basics
|
|
.print "title_basics finished importing"
|
|
.import {0}title_episode.csv title_episode
|
|
.print "title_episode finished importing"
|
|
.print ""
|
|
.print "start nullify title_akas"
|
|
UPDATE title_akas SET title=NULL WHERE title='\\N';
|
|
UPDATE title_akas SET region=NULL WHERE region='\\N';
|
|
UPDATE title_akas SET language=NULL WHERE language='\\N';
|
|
UPDATE title_akas SET types=NULL WHERE types='\\N';
|
|
UPDATE title_akas SET attributes=NULL WHERE attributes='\\N';
|
|
UPDATE title_akas SET isOriginalTitle=NULL WHERE isOriginalTitle='\\N';
|
|
.print "end nullify title_akas"
|
|
.print ""
|
|
.print "start nullify title_basics"
|
|
UPDATE title_basics SET titleType=NULL WHERE titleType='\\N';
|
|
UPDATE title_basics SET primaryTitle=NULL WHERE primaryTitle='\\N';
|
|
UPDATE title_basics SET originalTitle=NULL WHERE originalTitle='\\N';
|
|
UPDATE title_basics SET isAdult=NULL WHERE isAdult='\\N';
|
|
UPDATE title_basics SET startYear=NULL WHERE startYear='\\N';
|
|
UPDATE title_basics SET endYear=NULL WHERE endYear='\\N';
|
|
UPDATE title_basics SET runtimeMinutes=NULL WHERE runtimeMinutes='\\N';
|
|
UPDATE title_basics SET genres=NULL WHERE genres='\\N';
|
|
.print "end nullify title_basics"
|
|
.print ""
|
|
.print "start nullify title_episode"
|
|
UPDATE title_episode SET parentTconst=NULL WHERE parentTconst='\\N';
|
|
UPDATE title_episode SET seasonNumber=NULL WHERE seasonNumber='\\N';
|
|
UPDATE title_episode SET episodeNumber=NULL WHERE episodeNumber='\\N';
|
|
.print "end nullify title_episode"
|
|
.print ""
|