 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);
 

DROP SEQUENCE itemsbydateaccessioned_seq;
DROP SEQUENCE itemsbysubject_seq;

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

DROP TABLE History CASCADE;
DROP TABLE HistoryState CASCADE;

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

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

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

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


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