Update_Script_28To29.txt

ALTER TABLE securityquestions RENAME COLUMN question TO title;
--------------------------
CREATE INDEX idx_aggregatefunctions_id ON aggregatefunctions USING btree (id);
CREATE INDEX idx_aggregatefunctions_name ON aggregatefunctions USING btree (name);
CREATE INDEX idx_authenticators_authenticatortype ON authenticators USING btree (authenticatortype);
CREATE INDEX idx_authenticators_id ON authenticators USING btree (id);
CREATE INDEX idx_authenticators_name ON authenticators USING btree (name);
CREATE INDEX idx_clissifiers_id ON classifiers USING btree (id);
CREATE INDEX idx_clissifiers_name ON classifiers USING btree (name);
CREATE INDEX idx_constraints_id ON constraints USING btree (id);
CREATE INDEX idx_contentdescriptors_id ON contentdescriptors USING btree (id, name);
CREATE INDEX idx_contentdescriptors_lastcheckiotimestamp ON datasets USING btree (lastcheckiotimestamp);
CREATE INDEX idx_contentdescriptors_status ON datasets USING btree (status);
CREATE INDEX idx_conversionmethods_id ON conversionmethods USING btree (id);
CREATE INDEX idx_datacontainers_id ON datacontainers USING btree (id);
CREATE INDEX idx_datacontainers_name ON datacontainers USING btree (name);
CREATE INDEX idx_datacontainers_scope ON datacontainers USING btree (scope);
CREATE INDEX idx_datacontainers_shortname ON datacontainers USING btree (shortname);
CREATE INDEX idx_datasets_id ON datasets USING btree (id);
CREATE INDEX idx_datasetversions_id ON datasetversions USING btree (id);
CREATE INDEX idx_datasetversions_status ON datasetversions USING btree (status);
CREATE INDEX idx_datasetversions_timestamp ON datasetversions USING btree ("timestamp");
CREATE INDEX idx_datastructures_id ON datastructures USING btree (id);
CREATE INDEX idx_datastructures_name ON datastructures USING btree (name);
CREATE INDEX idx_datatuples_id ON datatuples USING btree (id);
CREATE INDEX idx_datatuples_timestamp ON datatuples USING btree ("timestamp");
CREATE INDEX idx_datatupleversions_id ON datatupleversions USING btree (id);
CREATE INDEX idx_datatupleversions_timestamp ON datatupleversions USING btree ("timestamp");
CREATE INDEX idx_datatypes_id ON datatypes USING btree (id);
CREATE INDEX idx_datatypes_name ON datatypes USING btree (name);
CREATE INDEX idx_datatypes_systemtype ON datatypes USING btree (systemtype);
CREATE INDEX idx_dataviews_id ON dataviews USING btree (id);
CREATE INDEX idx_dataviews_name ON dataviews USING btree (name);
CREATE INDEX idx_dimensions_id ON dimensions USING btree (id);
CREATE INDEX idx_dimensions_name ON dimensions USING btree (name);
CREATE INDEX idx_entities_id ON entities USING btree (id);
CREATE INDEX idx_entities_name ON entities USING btree (name);
CREATE INDEX idx_extendedproperties_id ON extendedproperties USING btree (id);
CREATE INDEX idx_extendedproperties_name ON extendedproperties USING btree (name);
CREATE INDEX idx_features_id ON features USING btree (id);
CREATE INDEX idx_features_name ON features USING btree (name);
CREATE INDEX idx_globalizations_cultureid ON globalizationinfos USING btree (cultureid);
CREATE INDEX idx_globalizations_displayname ON globalizationinfos USING btree (displayname);
CREATE INDEX idx_globalizations_id ON globalizationinfos USING btree (id);
CREATE INDEX idx_metadataattributeusages_id ON metadataattributeusages USING btree (id);
CREATE INDEX idx_metadataattributeusages_label ON metadataattributeusages USING btree (label);
CREATE INDEX idx_metadatanestedattributeusages_id ON metadatanestedattributeusages USING btree (id);
CREATE INDEX idx_metadatanestedattributeusages_label ON metadatanestedattributeusages USING btree (label);
CREATE INDEX idx_metadatapackages_id ON metadatapackages USING btree (id);
CREATE INDEX idx_metadatapackages_name ON metadatapackages USING btree (name);
CREATE INDEX idx_metadatapackageusages_id ON metadatapackageusages USING btree (id);
CREATE INDEX idx_metadatapackageusages_label ON metadatapackageusages USING btree (label);
CREATE INDEX idx_metadatastructures_id ON metadatastructures USING btree (id);
CREATE INDEX idx_metadatastructures_name ON metadatastructures USING btree (name);
CREATE INDEX idx_methodologies_id ON methodologies USING btree (id);
CREATE INDEX idx_parameters_id ON parameters USING btree (id);
CREATE INDEX idx_parameters_label ON parameters USING btree (label);
CREATE INDEX idx_permissions_id ON permissions USING btree (id);
CREATE INDEX idx_researchplans_id ON researchplans USING btree (id);
CREATE INDEX idx_researchplans_title ON researchplans USING btree (title);
CREATE INDEX idx_securityquestions_id ON securityquestions USING btree (id);
CREATE INDEX idx_securityquestions_title ON securityquestions USING btree (title);
CREATE INDEX idx_sujects_id ON subjects USING btree (id);
CREATE INDEX idx_sujects_name ON subjects USING btree (name);
CREATE INDEX idx_tasks_id ON tasks USING btree (id);
CREATE INDEX idx_units_abbreviation ON units USING btree (abbreviation);
CREATE INDEX idx_units_id ON units USING btree (id);
CREATE INDEX idx_units_measurementsystem ON units USING btree (measurementsystem);
CREATE INDEX idx_units_name ON units USING btree (name);
CREATE INDEX idx_users_email ON users USING btree (email);
CREATE INDEX idx_users_isapproved ON users USING btree (isapproved);
CREATE INDEX idx_users_isblocked ON users USING btree (isblocked);
CREATE INDEX idx_users_islockedout ON users USING btree (islockedout);
CREATE INDEX idx_variables_id ON variables USING btree (id);
CREATE INDEX idx_variables_label ON variables USING btree (label);