Revision 8393
Added by ben leinfelder about 11 years ago
| upgrade-db-to-2.3.0-oracle.sql | ||
|---|---|---|
| 1 | 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 |
/* |
|
| 2 | 8 |
* update the database version |
| 3 | 9 |
*/ |
| 4 | 10 |
UPDATE db_version SET status=0; |
Also available in: Unified diff
add indices for access log performance during upgrade to 2.3.0.