Project

General

Profile

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

1
/*
2
 * Add indices for log access 
3
 */
4
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev));
5
CREATE INDEX access_log_docid ON access_log(docid);
6

    
7
/*
8
 * update the database version
9
 */
10
UPDATE db_version SET status=0;
11

    
12
INSERT INTO db_version (version, status, date_created) 
13
  VALUES ('2.3.0', 1, CURRENT_DATE);