CREATE INDEX authorship_author ON authorships USING btree (author);
CREATE INDEX authorships_affiliation_idx ON authorships USING btree (affiliation);
CREATE INDEX authorships_author_idx ON authorships USING btree (author);
CREATE INDEX authorships_result_idx ON authorships USING btree (result);
CREATE INDEX datasources_typology_idx ON datasources USING btree (typology);
CREATE INDEX datasourcesorganizations_datasource_idx ON datasources_organizations USING btree (datasource);
CREATE INDEX datasourcesorganizations_organization_idx ON datasources_organizations USING btree (organization);
CREATE INDEX instances_datasource_idx ON instances USING btree (datasource);
CREATE INDEX instances_resource_idx ON instances USING btree (resource);
CREATE INDEX organizations_country_of_origin_idx ON organizations USING btree (country_of_origin);
CREATE INDEX participants_organization_idx ON participants USING btree (organization);
CREATE INDEX participants_person_idx ON participants USING btree (person);
CREATE INDEX participants_project_idx ON participants USING btree (project);
CREATE INDEX persons_nationality_idx ON persons USING btree (nationality);
CREATE INDEX projects_fundedby_idx ON projects USING btree (fundedby);
CREATE INDEX projectscontracttypes_contracttype_idx ON projects_contracttypes USING btree (contracttype);
CREATE INDEX projectscontracttypes_project_idx ON projects_contracttypes USING btree (project);
CREATE INDEX projectsprojectsubjects_project_idx ON projects_projectsubjects USING btree (project);
CREATE INDEX projectsprojectsubjects_projectsubject_idx ON projects_projectsubjects USING btree (project_subject);
CREATE INDEX results_access_mode_idx ON results USING btree (access_mode);
CREATE INDEX results_createdfrom_idx ON results USING btree (createdfrom);
CREATE INDEX results_haskind_idx ON results USING btree (haskind);
CREATE INDEX results_hastype_idx ON results USING btree (hastype);
CREATE INDEX results_language_idx ON results USING btree (language);
CREATE INDEX resultsprojects_project_idx ON results_projects USING btree (project);
CREATE INDEX resultsprojects_result_idx ON results_projects USING btree (result);
CREATE INDEX resulttypes_ofkind_idx ON resulttypes USING btree (ofkind);
CREATE INDEX specificprogrammes_hasfundingprogramme_idx ON specificprogrammes USING btree (hasfundingprogramme);
CREATE INDEX subdivisions_hasspecificprogramme_idx ON subdivisions USING btree (hasspecificprogramme);
CREATE INDEX test1 ON results_projects USING btree (project, result);
CREATE INDEX test2 ON results_projects USING btree (project);
CREATE INDEX test3 ON results_projects USING btree (result);
CREATE INDEX test4 ON projects USING btree (fundedby);
CREATE INDEX usersroles_role_idx ON users_roles USING btree (role);
CREATE INDEX usersroles_useremail_idx ON users_roles USING btree (user_email);
CREATE INDEX webresourcesinstances_instanceid_idx ON webresources_instances USING btree (instanceid);
CREATE INDEX webresourcesinstances_webresourceid_idx ON webresources_instances USING btree (webresourceid);
CREATE INDEX wsi_instanceid ON webresources_instances USING btree (instanceid);
CREATE INDEX wsi_webresourceid ON webresources_instances USING btree (webresourceid);

