Project

General

Profile

metacat / src / upgrade-db-to-2.0.5-postgres.sql @ 8504

1
/*
2
 * Alter the systemmetadata* table names for Oracle length restrictions
3
 */
4
ALTER TABLE systemMetadataReplicationPolicy RENAME TO smReplicationPolicy;
5
ALTER TABLE systemMetadataReplicationStatus RENAME TO smReplicationStatus;
6

    
7
/*
8
 * Add some additional indexes for search
9
 */
10
CREATE INDEX xml_documents_idx5 ON xml_documents (docid, rev);
11

    
12
CREATE INDEX xml_access_idx6 on xml_access(guid);
13

    
14
CREATE INDEX identifier_guid on identifier(guid);
15
CREATE INDEX identifier_docid on identifier(docid);
16
CREATE INDEX identifier_rev on identifier(rev);
17
CREATE INDEX identifier_docid_rev on identifier(docid, rev);
18

    
19
CREATE INDEX xml_path_index_idx6 ON xml_path_index (docid);
20

    
21
/*
22
 * update the database version
23
 */
24
UPDATE db_version SET status=0;
25

    
26
INSERT INTO db_version (version, status, date_created) 
27
  VALUES ('2.0.5', 1, CURRENT_DATE);