Project

General

Profile

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

1
/*
2
 * Alter the systemmetadata* table names for Oracle length restrictions
3
 * NOTE: we cannot actually perform this since the tables could 
4
 * never be created when 2.0.0 was first released. Oracle users of Metacat 1.x
5
 * will have run through an updated 2.0.0 script that creates the correct table names
6
 * for use in 2.0.5. So, we do nothing here for Oracle deployments.
7
 */
8

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

    
14
CREATE INDEX xml_access_idx6 on xml_access(guid);
15

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

    
21
CREATE INDEX xml_path_index_idx6 ON xml_path_index (docid);
22

    
23

    
24
/*
25
 * update the database version
26
 */
27
UPDATE db_version SET status=0;
28

    
29
INSERT INTO db_version (version, status, date_created) 
30
  VALUES ('2.0.5', 1, CURRENT_DATE);