inducks_sqlite_schema.sql

gistfile1.sql

-- per gli .import:
-- tail -n +2 # rimuove l'header
-- sed 's/.$//' # rimuove l'ultimo separator
CREATE TABLE inducks_storyversion (
    storyversioncode varchar(19) PRIMARY KEY,
    storycode varchar(19),
    entirepages int(7),
    brokenpagenumerator int(7),
    brokenpagedenominator int(7),
    brokenpageunspecified CHAR(1) CHECK(brokenpageunspecified IN ('Y','N')),
    kind varchar(1),
    rowsperpage int(7),
    columnsperpage int(7),
    appisxapp CHAR(1) CHECK(appisxapp IN ('Y','N')),
    what varchar(1),
    appsummary text,
    plotsummary text,
    writsummary text,
    artsummary text,
    inksummary text,
    creatorrefsummary text,
    keywordsummary text,
    estimatedpanels int(7)
);
CREATE INDEX idx_storyversion_fk1 ON inducks_storyversion(storycode);

--LOAD DATA LOCAL INFILE "./isv/inducks_storyversion.isv" INTO TABLE inducks_storyversion_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
--ALTER TABLE inducks_storyversion_temp ADD FULLTEXT(appsummary,plotsummary,writsummary,artsummary,inksummary,creatorrefsummary,keywordsummary);

CREATE TABLE inducks_herocharacter (
    storycode varchar(18),
    charactercode varchar(54),
    number int(7),
    PRIMARY KEY (storycode, charactercode)
);
CREATE INDEX idx_herocharacter_fk0 ON inducks_herocharacter(charactercode);
--LOAD DATA LOCAL INFILE "./isv/inducks_herocharacter.isv" INTO TABLE inducks_herocharacter_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_appearance (
    storyversioncode varchar(19),
    charactercode varchar(62),
    number int(7),
    appearancecomment varchar(209),
    PRIMARY KEY (storyversioncode, charactercode)
);
CREATE INDEX idx_appearance_fk0 ON inducks_appearance(charactercode);
--LOAD DATA LOCAL INFILE "./isv/inducks_appearance.isv" INTO TABLE inducks_appearance_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_storyjob (
    storyversioncode varchar(19),
    personcode varchar(79),
    plotwritartink varchar(1),
    storyjobcomment varchar(141),
    indirect CHAR(1) CHECK(indirect IN ('Y','N')),
    PRIMARY KEY (storyversioncode, personcode, plotwritartink)
)
CREATE INDEX idx_storyjob_fk0 ON inducks_storyjob(personcode);
--LOAD DATA LOCAL INFILE "./isv/inducks_storyjob.isv" INTO TABLE inducks_storyjob_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_story (
    storycode varchar(19),
    originalstoryversioncode varchar(19),
    creationdate varchar(21),
    firstpublicationdate varchar(10),
    endpublicationdate varchar(10),
    title text,
    usedifferentcode varchar(19),
    storycomment varchar(664),
    error CHAR(1) CHECK(error IN ('Y','N')),
    repcountrysummary text,
    storyparts int(7),
    locked CHAR(1) cHECK(locked IN ('Y','N')),
    inputfilecode int(7),
    issuecodeofstoryitem varchar(14),
    PRIMARY KEY (storycode)
);
CREATE INDEX idx_story_fk0 ON inducks_story(originalstoryversioncode);
CREATE INDEX idx_story_fk1 ON inducks_story(firstpublicationdate);
--LOAD DATA LOCAL INFILE "./isv/inducks_story.isv" INTO TABLE inducks_story_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
--ALTER TABLE inducks_story_temp ADD FULLTEXT(title,repcountrysummary);

CREATE TABLE inducks_substory (
    storycode varchar(12),
    originalstoryversioncode varchar(12),
    superstorycode varchar(13),
    part varchar(3),
    firstpublicationdate varchar(10),
    title varchar(76),
    substorycomment varchar(349),
    error CHAR(1) CHECK(error IN ('Y','N')),
    locked CHAR(1) CHECK(locked IN ('Y','N')),
    inputfilecode int(7),
    PRIMARY KEY (storycode)
);
CREATE INDEX idx_substory_fk0 ON inducks_substory(firstpublicationdate);
--LOAD DATA LOCAL INFILE "./isv/inducks_substory.isv" INTO TABLE inducks_substory_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE induckspriv_story (
    storycode varchar(17),
    storycomment varchar(1275),
    PRIMARY KEY (storycode)
);
--LOAD DATA LOCAL INFILE "./isv/induckspriv_story.isv" INTO TABLE induckspriv_story_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_storysubseries (
    storycode varchar(16),
    subseriescode varchar(144),
    storysubseriescomment varchar(23),
    PRIMARY KEY (storycode, subseriescode),
);
CREATE INDEX idx_storysubseries_fk0 ON inducks_storysubseries(subseriescode);
--LOAD DATA LOCAL INFILE "./isv/inducks_storysubseries.isv" INTO TABLE inducks_storysubseries_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_storycodes (
    storycode varchar(19),
    alternativecode varchar(72),
    unpackedcode varchar(82),
    codecomment varchar(34),
    PRIMARY KEY (storycode, alternativecode)
);
CREATE INDEX idx_storycodes_fk0 ON inducks_storycodes(alternativecode);
--LOAD DATA LOCAL INFILE "./isv/inducks_storycodes.isv" INTO TABLE inducks_storycodes_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_storydescription (
    storyversioncode varchar(19),
    languagecode varchar(7),
    desctext varchar(2814),
    PRIMARY KEY (storyversioncode, languagecode)
);
CREATE INDEX idx_storydescription_fk0 ON inducks_storydescription(languagecode);
--LOAD DATA LOCAL INFILE "./isv/inducks_storydescription.isv" INTO TABLE inducks_storydescription_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_storyreference (
    fromstorycode varchar(23),
    tostorycode varchar(17),
    referencereasonid int(7),
    PRIMARY KEY pk0 (fromstorycode, tostorycode)
);
CREATE INDEX idx_storyreference_fk0 ON inducks_storyreference(tostorycode);
CREATE INDEX idx_storyreference_fk1 ON inducks_storyreference(referencereasonid);
--LOAD DATA LOCAL INFILE "./isv/inducks_storyreference.isv" INTO TABLE inducks_storyreference_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_movie (
    moviecode varchar(14),
    title varchar(62),
    moviecomment varchar(570),
    appsummary text,
    moviejobsummary text,
    locked CHAR(1) CHECK(locked IN ('Y','N')),
    inputfilecode int(7),
    aka varchar(81),
    creationdate varchar(10),
    moviedescription varchar(836),
    distributor varchar(50),
    genre varchar(3),
    orderer varchar(178),
    publicationdate varchar(10),
    source varchar(91),
    tim varchar(6),
    PRIMARY KEY (moviecode)
);
--LOAD DATA LOCAL INFILE "./isv/inducks_movie.isv" INTO TABLE inducks_movie_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
--ALTER TABLE inducks_movie_temp ADD FULLTEXT(appsummary,moviejobsummary);

CREATE TABLE inducks_moviejob (
    moviecode varchar(14),
    personcode varchar(39),
    role varchar(15),
    moviejobcomment varchar(82),
    indirect CHAR(1) CHECK(indirect IN ('Y','N')),
    PRIMARY KEY (moviecode, personcode, role)
);
CREATE INDEX idx_moviejob_fk0 ON inducks_moviejob(personcode);
--LOAD DATA LOCAL INFILE "./isv/inducks_moviejob.isv" INTO TABLE inducks_moviejob_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_moviereference (
    storycode varchar(17),
    moviecode varchar(14),
    referencereasonid int(7),
    frommovietostory CHAR(1) CHECK(frommovietostory IN ('Y','N')),
    PRIMARY KEY (storycode, moviecode)
);
CREATE INDEX idx_moviereference_fk0 ON inducks_moviereference(moviecode);
CREATE INDEX idx_moviereference_fk1 ON inducks_moviereference(referencereasonid);
--LOAD DATA LOCAL INFILE "./isv/inducks_moviereference.isv" INTO TABLE inducks_moviereference_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_moviecharacter (
    moviecode varchar(13),
    charactercode varchar(35),
    istitlecharacter CHAR(1) CHECK(istitlecharacter IN ('Y','N')),
    PRIMARY KEY (moviecode, charactercode)
);
CREATE INDEX idx_moviecharacter_fk0 ON inducks_moviecharacter(charactercode);
--LOAD DATA LOCAL INFILE "./isv/inducks_moviecharacter.isv" INTO TABLE inducks_moviecharacter_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_entry (
    entrycode varchar(22),
    issuecode varchar(17),
    storyversioncode varchar(19),
    languagecode varchar(7),
    includedinentrycode varchar(18),
    position varchar(10),
    printedcode varchar(88),
    guessedcode varchar(39),
    title varchar(235),
    reallytitle CHAR(1) CHECK(reallytitle IN ('Y','N')),
    printedhero varchar(96),
    changes varchar(596),
    cut varchar(100),
    minorchanges varchar(558),
    missingpanels varchar(2),
    mirrored CHAR(1) CHECK(mirrored IN ('Y','N')),
    sideways CHAR(1) CHECK(sideways IN ('Y','N')),
    startdate varchar(10),
    enddate varchar(10),
    identificationuncertain CHAR(1) CHECK(identificationuncertain IN ('Y','N')),
    alsoreprint varchar(66),
    part varchar(5),
    entrycomment varchar(3476),
    error CHAR(1) CHECK(error IN ('Y','N')),
    PRIMARY KEY (entrycode)
);
CREATE INDEX idx_entry_fk0 ON inducks_entry(issuecode);
CREATE INDEX idx_entry_fk1 ON inducks_entry(storyversioncode);
CREATE INDEX idx_entry_fk2 ON inducks_entry(languagecode);
CREATE INDEX idx_entry_fk3 ON inducks_entry(includedinentrycode);
CREATE INDEX idx_entry_fk4 ON inducks_entry(position);
--LOAD DATA LOCAL INFILE "./isv/inducks_entry.isv" INTO TABLE inducks_entry_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE induckspriv_entry (
    entrycode varchar(22),
    entrycomment varchar(1209),
    PRIMARY KEY (entrycode)
);
--LOAD DATA LOCAL INFILE "./isv/induckspriv_entry.isv" INTO TABLE induckspriv_entry_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_logocharacter (
    entrycode varchar(22),
    charactercode varchar(54),
    reallyintitle CHAR(1) CHECK(reallyintitle IN ('Y','N')),
    number int(7),
    logocharactercomment varchar(28),
    PRIMARY KEY (entrycode, charactercode)
);
CREATE INDEX idx_logocharacter_fk0 ON inducks_logocharacter(charactercode));
--LOAD DATA LOCAL INFILE "./isv/inducks_logocharacter.isv" INTO TABLE inducks_logocharacter_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_entrycharactername (
    entrycode varchar(22),
    charactercode varchar(55),
    charactername varchar(72),
    PRIMARY KEY (entrycode, charactercode)
);
CREATE INDEX idx_entrycharactername_fk0 ON inducks_entrycharactername(charactercode);
--LOAD DATA LOCAL INFILE "./isv/inducks_entrycharactername.isv" INTO TABLE inducks_entrycharactername_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_entryjob (
    entrycode varchar(18),
    personcode varchar(50),
    transletcol varchar(1),
    entryjobcomment varchar(51),
    PRIMARY KEY (entrycode, personcode, transletcol)
);
CREATE INDEX idx_entryjob_fk0 ON inducks_entryjob(personcode);
--LOAD DATA LOCAL INFILE "./isv/inducks_entryjob.isv" INTO TABLE inducks_entryjob_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;

CREATE TABLE inducks_language_temp (
    languagecode varchar(7),
    defaultlanguagecode varchar(5),
    languagename varchar(20),
    KEY pk0 (languagecode),
    KEY fk0 (defaultlanguagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_language.isv" INTO TABLE inducks_language_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_language LIKE inducks_language_temp;
# SQL for re-creating and filling table inducks_languagename
DROP TABLE IF EXISTS inducks_languagename_temp;
CREATE TABLE inducks_languagename_temp (
    desclanguagecode varchar(5),
    languagecode varchar(7),
    languagename varchar(57),
    KEY pk0 (desclanguagecode, languagecode),
    KEY fk0 (languagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_languagename.isv" INTO TABLE inducks_languagename_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_languagename LIKE inducks_languagename_temp;
# SQL for re-creating and filling table inducks_countryname
DROP TABLE IF EXISTS inducks_countryname_temp;
CREATE TABLE inducks_countryname_temp (
    countrycode varchar(2),
    languagecode varchar(5),
    countryname varchar(88),
    KEY pk0 (countrycode, languagecode),
    KEY fk0 (languagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_countryname.isv" INTO TABLE inducks_countryname_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_countryname LIKE inducks_countryname_temp;
# SQL for re-creating and filling table inducks_country
DROP TABLE IF EXISTS inducks_country_temp;
CREATE TABLE inducks_country_temp (
    countrycode varchar(2),
    countryname varchar(20),
    defaultlanguage varchar(7),
    KEY pk0 (countrycode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_country.isv" INTO TABLE inducks_country_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_country LIKE inducks_country_temp;
# SQL for re-creating and filling table inducks_inputfile
DROP TABLE IF EXISTS inducks_inputfile_temp;
CREATE TABLE inducks_inputfile_temp (
    inputfilecode int(7),
    path varchar(11),
    filename varchar(22),
    layout varchar(10),
    locked enum('Y','N'),
    countrycode varchar(2),
    languagecode varchar(7),
    producercode varchar(15),
    KEY pk0 (inputfilecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_inputfile.isv" INTO TABLE inducks_inputfile_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_inputfile LIKE inducks_inputfile_temp;
# SQL for re-creating and filling table inducks_log
DROP TABLE IF EXISTS inducks_log_temp;
CREATE TABLE inducks_log_temp (
    number int(7),
    logkey varchar(45),
    storycode varchar(39),
    logid varchar(4),
    logtype varchar(1),
    par1 varchar(2070),
    par2 varchar(1846),
    par3 varchar(364),
    marked enum('Y','N'),
    inputfilecode int(7),
    KEY pk0 (number)
);
LOAD DATA LOCAL INFILE "./isv/inducks_log.isv" INTO TABLE inducks_log_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_log LIKE inducks_log_temp;
# SQL for re-creating and filling table inducks_logincharge
DROP TABLE IF EXISTS inducks_logincharge_temp;
CREATE TABLE inducks_logincharge_temp (
    lognumber int(7),
    personcode varchar(3),
    KEY pk0 (lognumber, personcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_logincharge.isv" INTO TABLE inducks_logincharge_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_logincharge LIKE inducks_logincharge_temp;
# SQL for re-creating and filling table inducks_logdata
DROP TABLE IF EXISTS inducks_logdata_temp;
CREATE TABLE inducks_logdata_temp (
    logid varchar(4),
    category int(7),
    logtext varchar(108),
    KEY pk0 (logid)
);
LOAD DATA LOCAL INFILE "./isv/inducks_logdata.isv" INTO TABLE inducks_logdata_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_logdata LIKE inducks_logdata_temp;
# SQL for re-creating and filling table inducks_issue
DROP TABLE IF EXISTS inducks_issue_temp;
CREATE TABLE inducks_issue_temp (
    issuecode varchar(17),
    issuerangecode varchar(13),
    publicationcode varchar(12),
    issuenumber varchar(12),
    title varchar(158),
    size varchar(61),
    pages varchar(82),
    price varchar(91),
    printrun varchar(142),
    attached varchar(288),
    oldestdate varchar(10),
    fullyindexed enum('Y','N'),
    issuecomment varchar(1270),
    error enum('Y','N'),
    filledoldestdate varchar(10),
    locked enum('Y','N'),
    inxforbidden enum('Y','N'),
    inputfilecode int(7),
    KEY pk0 (issuecode),
    KEY fk0 (issuerangecode),
    KEY fk1 (publicationcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_issue.isv" INTO TABLE inducks_issue_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_issue LIKE inducks_issue_temp;
# SQL for re-creating and filling table inducks_issuejob
DROP TABLE IF EXISTS inducks_issuejob_temp;
CREATE TABLE inducks_issuejob_temp (
    issuecode varchar(17),
    personcode varchar(48),
    inxtransletcol varchar(1),
    issuejobcomment varchar(32),
    KEY pk0 (issuecode, personcode, inxtransletcol),
    KEY fk0 (personcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_issuejob.isv" INTO TABLE inducks_issuejob_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_issuejob LIKE inducks_issuejob_temp;
# SQL for re-creating and filling table inducks_issuedate
DROP TABLE IF EXISTS inducks_issuedate_temp;
CREATE TABLE inducks_issuedate_temp (
    issuecode varchar(17),
    date varchar(10),
    kindofdate varchar(76),
    KEY pk0 (issuecode, date)
);
LOAD DATA LOCAL INFILE "./isv/inducks_issuedate.isv" INTO TABLE inducks_issuedate_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_issuedate LIKE inducks_issuedate_temp;
# SQL for re-creating and filling table inducks_issuecollecting
DROP TABLE IF EXISTS inducks_issuecollecting_temp;
CREATE TABLE inducks_issuecollecting_temp (
    collectingissuecode varchar(17),
    collectedissuecode varchar(21),
    KEY pk0 (collectingissuecode, collectedissuecode),
    KEY fk0 (collectedissuecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_issuecollecting.isv" INTO TABLE inducks_issuecollecting_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_issuecollecting LIKE inducks_issuecollecting_temp;
# SQL for re-creating and filling table inducks_equiv
DROP TABLE IF EXISTS inducks_equiv_temp;
CREATE TABLE inducks_equiv_temp (
    issuecode varchar(76),
    equivid int(7),
    equivcomment varchar(2),
    KEY pk0 (issuecode, equivid),
    KEY fk0 (equivid)
);
LOAD DATA LOCAL INFILE "./isv/inducks_equiv.isv" INTO TABLE inducks_equiv_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_equiv LIKE inducks_equiv_temp;
# SQL for re-creating and filling table inducks_issuerange
DROP TABLE IF EXISTS inducks_issuerange_temp;
CREATE TABLE inducks_issuerange_temp (
    issuerangecode varchar(13),
    publicationcode varchar(9),
    title varchar(229),
    circulation varchar(6),
    issuerangecomment varchar(468),
    numbersarefake enum('Y','N'),
    error enum('Y','N'),
    KEY pk0 (issuerangecode),
    KEY fk0 (publicationcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_issuerange.isv" INTO TABLE inducks_issuerange_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_issuerange LIKE inducks_issuerange_temp;
# SQL for re-creating and filling table inducks_publication
DROP TABLE IF EXISTS inducks_publication_temp;
CREATE TABLE inducks_publication_temp (
    publicationcode varchar(12),
    countrycode varchar(2),
    languagecode varchar(7),
    title text,
    size varchar(61),
    publicationcomment varchar(1298),
    circulation varchar(4),
    numbersarefake enum('Y','N'),
    error enum('Y','N'),
    locked enum('Y','N'),
    inxforbidden enum('Y','N'),
    inputfilecode int(7),
    KEY pk0 (publicationcode),
    KEY fk0 (countrycode),
    KEY fk1 (languagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_publication.isv" INTO TABLE inducks_publication_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
ALTER TABLE inducks_publication_temp ADD FULLTEXT(title);
CREATE TABLE IF NOT EXISTS inducks_publication LIKE inducks_publication_temp;
# SQL for re-creating and filling table inducks_publicationjob
DROP TABLE IF EXISTS inducks_publicationjob_temp;
CREATE TABLE inducks_publicationjob_temp (
    publicationcode varchar(12),
    personcode varchar(3),
    incharge varchar(1),
    publicationjobcomment varchar(1),
    KEY pk0 (publicationcode, personcode, incharge),
    KEY fk0 (personcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_publicationjob.isv" INTO TABLE inducks_publicationjob_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_publicationjob LIKE inducks_publicationjob_temp;
# SQL for re-creating and filling table inducks_publicationcategory
DROP TABLE IF EXISTS inducks_publicationcategory_temp;
CREATE TABLE inducks_publicationcategory_temp (
    publicationcode varchar(12),
    category varchar(61),
    KEY pk0 (publicationcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_publicationcategory.isv" INTO TABLE inducks_publicationcategory_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_publicationcategory LIKE inducks_publicationcategory_temp;
# SQL for re-creating and filling table inducks_publicationname
DROP TABLE IF EXISTS inducks_publicationname_temp;
CREATE TABLE inducks_publicationname_temp (
    publicationcode varchar(9),
    publicationname varchar(62),
    KEY pk0 (publicationcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_publicationname.isv" INTO TABLE inducks_publicationname_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_publicationname LIKE inducks_publicationname_temp;
# SQL for re-creating and filling table inducks_publisher
DROP TABLE IF EXISTS inducks_publisher_temp;
CREATE TABLE inducks_publisher_temp (
    publisherid varchar(84),
    publishername text,
    KEY pk0 (publisherid)
);
LOAD DATA LOCAL INFILE "./isv/inducks_publisher.isv" INTO TABLE inducks_publisher_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
ALTER TABLE inducks_publisher_temp ADD FULLTEXT(publishername);
CREATE TABLE IF NOT EXISTS inducks_publisher LIKE inducks_publisher_temp;
# SQL for re-creating and filling table inducks_publishingjob
DROP TABLE IF EXISTS inducks_publishingjob_temp;
CREATE TABLE inducks_publishingjob_temp (
    publisherid varchar(84),
    issuecode varchar(17),
    publishingjobcomment varchar(36),
    KEY pk0 (publisherid, issuecode),
    KEY fk0 (issuecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_publishingjob.isv" INTO TABLE inducks_publishingjob_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_publishingjob LIKE inducks_publishingjob_temp;
# SQL for re-creating and filling table inducks_character
DROP TABLE IF EXISTS inducks_character_temp;
CREATE TABLE inducks_character_temp (
    charactercode varchar(69),
    charactername text,
    official enum('Y','N'),
    onetime enum('Y','N'),
    heroonly enum('Y','N'),
    charactercomment varchar(567),
    KEY pk0 (charactercode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_character.isv" INTO TABLE inducks_character_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
ALTER TABLE inducks_character_temp ADD FULLTEXT(charactername);
CREATE TABLE IF NOT EXISTS inducks_character LIKE inducks_character_temp;
# SQL for re-creating and filling table inducks_charactername
DROP TABLE IF EXISTS inducks_charactername_temp;
CREATE TABLE inducks_charactername_temp (
    charactercode varchar(38),
    languagecode varchar(7),
    charactername varchar(83),
    preferred enum('Y','N'),
    characternamecomment varchar(99),
    KEY pk0 (charactercode, languagecode, charactername),
    KEY fk0 (languagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_charactername.isv" INTO TABLE inducks_charactername_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_charactername LIKE inducks_charactername_temp;
# SQL for re-creating and filling table inducks_characteralias
DROP TABLE IF EXISTS inducks_characteralias_temp;
CREATE TABLE inducks_characteralias_temp (
    charactercode varchar(30),
    charactername varchar(58),
    KEY pk0 (charactername),
    KEY fk0 (charactercode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_characteralias.isv" INTO TABLE inducks_characteralias_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_characteralias LIKE inducks_characteralias_temp;
# SQL for re-creating and filling table inducks_characterreference
DROP TABLE IF EXISTS inducks_characterreference_temp;
CREATE TABLE inducks_characterreference_temp (
    fromcharactercode varchar(19),
    tocharactercode varchar(19),
    isgroupofcharacters enum('Y','N'),
    KEY pk0 (fromcharactercode, tocharactercode),
    KEY fk0 (tocharactercode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_characterreference.isv" INTO TABLE inducks_characterreference_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_characterreference LIKE inducks_characterreference_temp;
# SQL for re-creating and filling table inducks_characterdetail
DROP TABLE IF EXISTS inducks_characterdetail_temp;
CREATE TABLE inducks_characterdetail_temp (
    charactername varchar(7),
    charactercode varchar(6),
    number int(7),
    KEY pk0 (charactercode),
    KEY fk0 (charactername)
);
LOAD DATA LOCAL INFILE "./isv/inducks_characterdetail.isv" INTO TABLE inducks_characterdetail_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_characterdetail LIKE inducks_characterdetail_temp;
# SQL for re-creating and filling table inducks_subseries
DROP TABLE IF EXISTS inducks_subseries_temp;
CREATE TABLE inducks_subseries_temp (
    subseriescode varchar(95),
    subseriesname varchar(95),
    official enum('Y','N'),
    important enum('Y','N'),
    subseriescomment varchar(97),
    subseriescategory varchar(1),
    KEY pk0 (subseriescode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_subseries.isv" INTO TABLE inducks_subseries_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_subseries LIKE inducks_subseries_temp;
# SQL for re-creating and filling table inducks_subseriesname
DROP TABLE IF EXISTS inducks_subseriesname_temp;
CREATE TABLE inducks_subseriesname_temp (
    subseriescode varchar(42),
    languagecode varchar(7),
    subseriesname varchar(121),
    KEY pk0 (subseriescode, languagecode),
    KEY fk0 (languagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_subseriesname.isv" INTO TABLE inducks_subseriesname_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_subseriesname LIKE inducks_subseriesname_temp;
# SQL for re-creating and filling table inducks_referencereason
DROP TABLE IF EXISTS inducks_referencereason_temp;
CREATE TABLE inducks_referencereason_temp (
    referencereasonid int(7),
    referencereasontext varchar(87),
    KEY pk0 (referencereasonid)
);
LOAD DATA LOCAL INFILE "./isv/inducks_referencereason.isv" INTO TABLE inducks_referencereason_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_referencereason LIKE inducks_referencereason_temp;
# SQL for re-creating and filling table inducks_referencereasonname
DROP TABLE IF EXISTS inducks_referencereasonname_temp;
CREATE TABLE inducks_referencereasonname_temp (
    referencereasonid int(7),
    languagecode varchar(2),
    referencereasontranslation varchar(28),
    KEY pk0 (referencereasonid, languagecode),
    KEY fk0 (languagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_referencereasonname.isv" INTO TABLE inducks_referencereasonname_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_referencereasonname LIKE inducks_referencereasonname_temp;
# SQL for re-creating and filling table inducks_universe
DROP TABLE IF EXISTS inducks_universe_temp;
CREATE TABLE inducks_universe_temp (
    universecode varchar(28),
    universecomment varchar(1),
    KEY pk0 (universecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_universe.isv" INTO TABLE inducks_universe_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_universe LIKE inducks_universe_temp;
# SQL for re-creating and filling table inducks_ucrelation
DROP TABLE IF EXISTS inducks_ucrelation_temp;
CREATE TABLE inducks_ucrelation_temp (
    universecode varchar(28),
    charactercode varchar(38),
    KEY pk0 (universecode, charactercode),
    KEY fk0 (charactercode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_ucrelation.isv" INTO TABLE inducks_ucrelation_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_ucrelation LIKE inducks_ucrelation_temp;
# SQL for re-creating and filling table inducks_universename
DROP TABLE IF EXISTS inducks_universename_temp;
CREATE TABLE inducks_universename_temp (
    universecode varchar(28),
    languagecode varchar(5),
    universename varchar(76),
    KEY pk0 (universecode, languagecode),
    KEY fk0 (languagecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_universename.isv" INTO TABLE inducks_universename_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_universename LIKE inducks_universename_temp;
# SQL for re-creating and filling table inducks_person
DROP TABLE IF EXISTS inducks_person_temp;
CREATE TABLE inducks_person_temp (
    personcode varchar(79),
    nationalitycountrycode varchar(2),
    fullname text,
    official enum('Y','N'),
    personcomment varchar(221),
    unknownstudiomember enum('Y','N'),
    isfake enum('Y','N'),
    birthname text,
    borndate varchar(10),
    bornplace varchar(30),
    deceaseddate varchar(10),
    deceasedplace varchar(31),
    education varchar(189),
    moviestext varchar(879),
    comicstext varchar(1327),
    othertext varchar(307),
    photofilename varchar(32),
    photocomment varchar(68),
    photosource varchar(67),
    personrefs varchar(180),
    KEY pk0 (personcode),
    KEY fk0 (nationalitycountrycode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_person.isv" INTO TABLE inducks_person_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
ALTER TABLE inducks_person_temp ADD FULLTEXT(fullname,birthname);
CREATE TABLE IF NOT EXISTS inducks_person LIKE inducks_person_temp;
# SQL for re-creating and filling table inducks_personalias
DROP TABLE IF EXISTS inducks_personalias_temp;
CREATE TABLE inducks_personalias_temp (
    personcode varchar(31),
    surname varchar(48),
    givenname varchar(31),
    official enum('Y','N'),
    KEY fk0 (personcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_personalias.isv" INTO TABLE inducks_personalias_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_personalias LIKE inducks_personalias_temp;
# SQL for re-creating and filling table inducks_studio
DROP TABLE IF EXISTS inducks_studio_temp;
CREATE TABLE inducks_studio_temp (
    studiocode varchar(23),
    countrycode varchar(2),
    studioname varchar(24),
    city varchar(12),
    description varchar(415),
    othertext varchar(94),
    photofilename varchar(18),
    photocomment varchar(40),
    photosource varchar(42),
    studiorefs varchar(204),
    KEY pk0 (studiocode),
    KEY fk0 (countrycode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_studio.isv" INTO TABLE inducks_studio_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_studio LIKE inducks_studio_temp;
# SQL for re-creating and filling table inducks_studiowork
DROP TABLE IF EXISTS inducks_studiowork_temp;
CREATE TABLE inducks_studiowork_temp (
    studiocode varchar(23),
    personcode varchar(24),
    KEY pk0 (studiocode, personcode),
    KEY fk0 (personcode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_studiowork.isv" INTO TABLE inducks_studiowork_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_studiowork LIKE inducks_studiowork_temp;
# SQL for re-creating and filling table inducks_site
DROP TABLE IF EXISTS inducks_site_temp;
CREATE TABLE inducks_site_temp (
    sitecode varchar(16),
    urlbase varchar(51),
    images enum('Y','N'),
    sitename varchar(85),
    sitelogo varchar(85),
    properties varchar(1),
    KEY pk0 (sitecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_site.isv" INTO TABLE inducks_site_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_site LIKE inducks_site_temp;
# SQL for re-creating and filling table inducks_entryurl
DROP TABLE IF EXISTS inducks_entryurl_temp;
CREATE TABLE inducks_entryurl_temp (
    entrycode varchar(21),
    sitecode varchar(11),
    pagenumber int(7),
    url varchar(87),
    KEY fk0 (entrycode),
    KEY fk1 (sitecode),
    KEY fk2 (url)
);
LOAD DATA LOCAL INFILE "./isv/inducks_entryurl.isv" INTO TABLE inducks_entryurl_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_entryurl LIKE inducks_entryurl_temp;
# SQL for re-creating and filling table induckspriv_entryurl
DROP TABLE IF EXISTS induckspriv_entryurl_temp;
CREATE TABLE induckspriv_entryurl_temp (
    entrycode varchar(18),
    sitecode varchar(11),
    pagenumber int(7),
    url varchar(46),
    KEY fk0 (entrycode),
    KEY fk1 (sitecode),
    KEY fk2 (url)
);
LOAD DATA LOCAL INFILE "./isv/induckspriv_entryurl.isv" INTO TABLE induckspriv_entryurl_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS induckspriv_entryurl LIKE induckspriv_entryurl_temp;
# SQL for re-creating and filling table inducks_publicationurl
DROP TABLE IF EXISTS inducks_publicationurl_temp;
CREATE TABLE inducks_publicationurl_temp (
    publicationcode varchar(10),
    sitecode varchar(16),
    url varchar(236),
    KEY pk0 (publicationcode, sitecode),
    KEY fk0 (sitecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_publicationurl.isv" INTO TABLE inducks_publicationurl_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_publicationurl LIKE inducks_publicationurl_temp;
# SQL for re-creating and filling table inducks_issueurl
DROP TABLE IF EXISTS inducks_issueurl_temp;
CREATE TABLE inducks_issueurl_temp (
    issuecode varchar(14),
    sitecode varchar(12),
    url varchar(12),
    KEY pk0 (issuecode, sitecode),
    KEY fk0 (sitecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_issueurl.isv" INTO TABLE inducks_issueurl_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_issueurl LIKE inducks_issueurl_temp;
# SQL for re-creating and filling table inducks_personurl
DROP TABLE IF EXISTS inducks_personurl_temp;
CREATE TABLE inducks_personurl_temp (
    personcode varchar(24),
    sitecode varchar(15),
    url varchar(31),
    KEY pk0 (personcode, sitecode),
    KEY fk0 (sitecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_personurl.isv" INTO TABLE inducks_personurl_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_personurl LIKE inducks_personurl_temp;
# SQL for re-creating and filling table inducks_characterurl
DROP TABLE IF EXISTS inducks_characterurl_temp;
CREATE TABLE inducks_characterurl_temp (
    charactercode varchar(18),
    sitecode varchar(11),
    url varchar(13),
    KEY pk0 (charactercode, sitecode),
    KEY fk0 (sitecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_characterurl.isv" INTO TABLE inducks_characterurl_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_characterurl LIKE inducks_characterurl_temp;
# SQL for re-creating and filling table inducks_storyurl
DROP TABLE IF EXISTS inducks_storyurl_temp;
CREATE TABLE inducks_storyurl_temp (
    storycode varchar(13),
    sitecode varchar(15),
    url varchar(40),
    KEY pk0 (storycode, sitecode),
    KEY fk0 (sitecode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_storyurl.isv" INTO TABLE inducks_storyurl_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_storyurl LIKE inducks_storyurl_temp;
# SQL for re-creating and filling table inducks_storyheader
DROP TABLE IF EXISTS inducks_storyheader_temp;
CREATE TABLE inducks_storyheader_temp (
    storyheadercode varchar(9),
    level varchar(1),
    title varchar(217),
    storyheadercomment varchar(544),
    KEY pk0 (storyheadercode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_storyheader.isv" INTO TABLE inducks_storyheader_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_storyheader LIKE inducks_storyheader_temp;
# SQL for re-creating and filling table inducks_statpersonstory
DROP TABLE IF EXISTS inducks_statpersonstory_temp;
CREATE TABLE inducks_statpersonstory_temp (
    personcode varchar(79),
    productionletter varchar(1),
    total int(7),
    yearrange varchar(54),
    KEY pk0 (personcode, productionletter)
);
LOAD DATA LOCAL INFILE "./isv/inducks_statpersonstory.isv" INTO TABLE inducks_statpersonstory_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_statpersonstory LIKE inducks_statpersonstory_temp;
# SQL for re-creating and filling table inducks_statpersoncountry
DROP TABLE IF EXISTS inducks_statpersoncountry_temp;
CREATE TABLE inducks_statpersoncountry_temp (
    personcode varchar(79),
    countrycode varchar(2),
    total int(7),
    KEY pk0 (personcode, countrycode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_statpersoncountry.isv" INTO TABLE inducks_statpersoncountry_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_statpersoncountry LIKE inducks_statpersoncountry_temp;
# SQL for re-creating and filling table inducks_statpersonperson
DROP TABLE IF EXISTS inducks_statpersonperson_temp;
CREATE TABLE inducks_statpersonperson_temp (
    personcode varchar(79),
    copersoncode varchar(79),
    total int(7),
    yearrange varchar(59),
    KEY pk0 (personcode, total)
);
LOAD DATA LOCAL INFILE "./isv/inducks_statpersonperson.isv" INTO TABLE inducks_statpersonperson_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_statpersonperson LIKE inducks_statpersonperson_temp;
# SQL for re-creating and filling table inducks_statpersoncharacter
DROP TABLE IF EXISTS inducks_statpersoncharacter_temp;
CREATE TABLE inducks_statpersoncharacter_temp (
    personcode varchar(79),
    charactercode varchar(58),
    total int(7),
    yearrange varchar(101),
    KEY pk0 (personcode, total)
);
LOAD DATA LOCAL INFILE "./isv/inducks_statpersoncharacter.isv" INTO TABLE inducks_statpersoncharacter_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_statpersoncharacter LIKE inducks_statpersoncharacter_temp;
# SQL for re-creating and filling table inducks_statcharacterstory
DROP TABLE IF EXISTS inducks_statcharacterstory_temp;
CREATE TABLE inducks_statcharacterstory_temp (
    charactercode varchar(58),
    productionletter varchar(1),
    total int(7),
    yearrange varchar(92),
    KEY pk0 (charactercode, productionletter)
);
LOAD DATA LOCAL INFILE "./isv/inducks_statcharacterstory.isv" INTO TABLE inducks_statcharacterstory_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_statcharacterstory LIKE inducks_statcharacterstory_temp;
# SQL for re-creating and filling table inducks_statcharactercountry
DROP TABLE IF EXISTS inducks_statcharactercountry_temp;
CREATE TABLE inducks_statcharactercountry_temp (
    charactercode varchar(58),
    countrycode varchar(2),
    total int(7),
    KEY pk0 (charactercode, countrycode)
);
LOAD DATA LOCAL INFILE "./isv/inducks_statcharactercountry.isv" INTO TABLE inducks_statcharactercountry_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_statcharactercountry LIKE inducks_statcharactercountry_temp;
# SQL for re-creating and filling table inducks_statcharactercharacter
DROP TABLE IF EXISTS inducks_statcharactercharacter_temp;
CREATE TABLE inducks_statcharactercharacter_temp (
    charactercode varchar(58),
    cocharactercode varchar(58),
    total int(7),
    yearrange varchar(136),
    KEY pk0 (charactercode, total)
);
LOAD DATA LOCAL INFILE "./isv/inducks_statcharactercharacter.isv" INTO TABLE inducks_statcharactercharacter_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
CREATE TABLE IF NOT EXISTS inducks_statcharactercharacter LIKE inducks_statcharactercharacter_temp;