metacat/src/upgrade-db-to-2.3.0-postgres.sql @ 8911
1 | 8319 | tao | /*
|
---|---|---|---|
2 | 8393 | leinfelder | * 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 | 8319 | tao | * update the database version
|
9 | */
|
||
10 | UPDATE db_version SET status=0; |
||
11 | |||
12 | INSERT INTO db_version (version, status, date_created) |
||
13 | 8339 | leinfelder | VALUES ('2.3.0', 1, CURRENT_DATE); |