 CREATE INDEX workspace_item_fk_idx ON WorkspaceItem(item_id);
 CREATE INDEX workspace_coll_fk_idx ON WorkspaceItem(collection_id);
 
-CREATE INDEX workflow_item_fk_idx ON WorkflowItem(item_id);
+-- CREATE INDEX workflow_item_fk_idx ON WorkflowItem(item_id);
 CREATE INDEX workflow_coll_fk_idx ON WorkflowItem(collection_id);
 CREATE INDEX workflow_owner_fk_idx ON WorkflowItem(owner);
 

-- New Column language language in EPerson
------------------------------------------------------

alter table eperson add column language VARCHAR(64);
update eperson set language = 'en';

alter table bundle drop column mets_bitstream_id; -- totally unused column


-------------------------------------------------------------------------------

DROP SEQUENCE itemsbydateaccessioned_seq;
DROP SEQUENCE itemsbysubject_seq;

DROP TABLE ItemsByAuthor CASCADE CONSTRAINTS;
DROP TABLE ItemsByTitle CASCADE CONSTRAINTS;
DROP TABLE ItemsByDate CASCADE CONSTRAINTS;
DROP TABLE ItemsByDateAccessioned CASCADE CONSTRAINTS;
DROP TABLE ItemsBySubject CASCADE CONSTRAINTS;

DROP TABLE History CASCADE CONSTRAINTS;
DROP TABLE HistoryState CASCADE CONSTRAINTS;

----------------------------------------------------------------
-- Add indexes for foreign key columns
