metacat/src/upgrade-db-to-2.1.0-postgres.sql @ 7950
| 1 | 7833 | leinfelder | /*
|
|---|---|---|---|
| 2 | * the index_event table for solr-based indexing
|
||
| 3 | */
|
||
| 4 | CREATE TABLE index_event ( |
||
| 5 | guid text, |
||
| 6 | event_action VARCHAR(250), |
||
| 7 | description text, |
||
| 8 | event_date TIMESTAMP |
||
| 9 | );
|
||
| 10 | |||
| 11 | /*
|
||
| 12 | * update the database version
|
||
| 13 | */
|
||
| 14 | UPDATE db_version SET status=0; |
||
| 15 | |||
| 16 | INSERT INTO db_version (version, status, date_created) |
||
| 17 | VALUES ('2.1.0', 1, CURRENT_DATE); |