metacat/src/upgrade-db-to-2.3.0-postgres.sql @ 9448
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); |