drop table iwwdividx;

create table iwwdividx (
ftext_code VARCHAR(250),
auth_code VARCHAR(250),
edition_code VARCHAR(250),
ftext_other_editions VARCHAR(250),
ftext_resource_codes VARCHAR(250),
ftext_critical_codes VARCHAR(250),
ftext_shortcite VARCHAR(250),
ftext_display_title VARCHAR(250),
ftext_sort_title VARCHAR(250),
ftext_alternate_titles VARCHAR(250),
ftext_date SMALLINT(4),
ftext_dialect VARCHAR(250),
ftext_prizes VARCHAR(250),
ftext_genre VARCHAR(250),
ftext_composition VARCHAR(250),
ftext_pagination VARCHAR(250),
auth_authorname VARCHAR(250),
auth_alternames VARCHAR(250),
auth_allnames VARCHAR(250),
auth_dates_display VARCHAR(250),
auth_titleofrespect VARCHAR(250),
auth_century VARCHAR(250),
auth_birthyear SMALLINT(4),
auth_deathyear SMALLINT(4),
auth_birthplace VARCHAR(250),
auth_deathplace VARCHAR(250),
auth_region VARCHAR(250),
auth_class VARCHAR(250),
auth_maritalstatus VARCHAR(250),
auth_maternalstatus VARCHAR(250),
auth_religion VARCHAR(250),
auth_education VARCHAR(250),
auth_occupation VARCHAR(250),
edition_auth_names VARCHAR(250),
edition_title VARCHAR(250),
edition_sort_title VARCHAR(250),
edition_alternate_titles VARCHAR(250),
edition_editor VARCHAR(250),
edition_translator VARCHAR(250),
edition_edition VARCHAR(250),
edition_pub_location VARCHAR(250),
edition_publisher VARCHAR(250),
edition_year SMALLINT(4),
edition_series VARCHAR(250),
edition_journal VARCHAR(250),
edition_collection VARCHAR(250),
ftext_display_date VARCHAR(250),
ftext_location VARCHAR(250),
ftext_rights VARCHAR(250),
edition_display_year VARCHAR(250),
ftext_commentary VARCHAR(250),
ftext_empty1 VARCHAR(250),
ftext_empty2 VARCHAR(250),
philodocid SMALLINT(4),
div_level SMALLINT(4),
div_name VARCHAR(250),
div_type VARCHAR(250),
div_year SMALLINT(4),
div_recipient VARCHAR(250),
philodivid SMALLINT(4),
div_setting VARCHAR(250),
div_poemtype VARCHAR(250),
div_author VARCHAR(250),
div_empty1 VARCHAR(250),
div_empty2 VARCHAR(250)
);

load data infile "/projects/artflb/databases/efts/IWW/dividx/dividx.toload" into table iwwdividx
fields terminated by "\t"
lines terminated by "\n";

