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