 CREATE INDEX g2g_parent_fk_idx ON Group2Group(parent_id);
 CREATE INDEX g2g_child_fk_idx ON Group2Group(child_id);
 
-CREATE INDEX g2gc_parent_fk_idx ON Group2Group(parent_id);
-CREATE INDEX g2gc_child_fk_idx ON Group2Group(child_id);
+-- CREATE INDEX g2gc_parent_fk_idx ON Group2Group(parent_id);
+-- CREATE INDEX g2gc_child_fk_idx ON Group2Group(child_id);
 
 CREATE INDEX item_submitter_fk_idx ON Item(submitter_id);
 

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

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

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

-------------------------------------------------------------------------------
-- Necessary for Configurable Submission functionality:

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_coll_fk_idx ON WorkflowItem(collection_id);
CREATE INDEX workflow_owner_fk_idx ON WorkflowItem(owner);

