
create table dccreator (value varchar(255), uri varchar(255));
create table dcdate (value varchar(255), uri varchar(255));
create table dcdescription (value varchar(255), uri varchar(255));
create table dcformat (value varchar(255), uri varchar(255));
create table dcidentifier (value varchar(255), uri varchar(255));
create table dclanguage (value varchar(255), uri varchar(255));
create table dcpublisher (value varchar(255), uri varchar(255));
create table dcqRelationType (value varchar(255), uri varchar(255));
create table dcrelation (value varchar(255), uri varchar(255));
create table dcrights (value varchar(255), uri varchar(255));
create table dcsource (value varchar(255), uri varchar(255));
create table dcsubject (value varchar(255), uri varchar(255));
create table dctitle (value varchar(255), uri varchar(255));
create table hthResourceFormat (value varchar(255), uri varchar(255));
create table hthcontact (value varchar(255), uri varchar(255));
create table hthfirstVersion (value varchar(255), uri varchar(255));
create table hthinstitution (value varchar(255), uri varchar(255));
create table hthmodified (value varchar(255), uri varchar(255));

create index dccreator_index on dccreator (value);
create index dcdate_index on dcdate (value);
create index dcdescription_index on dcdescription (value);
create index dcformat_index on dcformat (value);
create index dcidentifier_index on dcidentifier (value);
create index dclanguage_index on dclanguage (value);
create index dcpublisher_index on dcpublisher (value);
create index dcqRelationType_index on dcqRelationType (value);
create index dcrelation_index on dcrelation (value);
create index dcrights_index on dcrights (value);
create index dcsource_index on dcsource (value);
create index dcsubject_index on dcsubject (value);
create index dctitle_index on dctitle (value);
create index hthResourceFormat_index on hthResourceFormat (value);
create index hthcontact_index on hthcontact (value);
create index hthfirstVersion_index on hthfirstVersion (value);
create index hthinstitution_index on hthinstitution (value);
create index hthmodified_index on hthmodified (value);

create index dccreator_rev_index on dccreator (uri);
create index dcdate_rev_index on dcdate (uri);
create index dcdescription_rev_index on dcdescription (uri);
create index dcformat_rev_index on dcformat (uri);
create index dcidentifier_rev_index on dcidentifier (uri);
create index dclanguage_rev_index on dclanguage (uri);
create index dcpublisher_rev_index on dcpublisher (uri);
create index dcqRelationType_rev_index on dcqRelationType (uri);
create index dcrelation_rev_index on dcrelation (uri);
create index dcrights_rev_index on dcrights (uri);
create index dcsource_rev_index on dcsource (uri);
create index dcsubject_rev_index on dcsubject (uri);
create index dctitle_rev_index on dctitle (uri);
create index hthResourceFormat_rev_index on hthResourceFormat (uri);
create index hthcontact_rev_index on hthcontact (uri);
create index hthfirstVersion_rev_index on hthfirstVersion (uri);
create index hthinstitution_rev_index on hthinstitution (uri);
create index hthmodified_rev_index on hthmodified (uri);

