metacat/src/upgrade-db-to-2.1.0-oracle.sql @ 7977
1 | 7833 | leinfelder | /*
|
---|---|---|---|
2 | * the index_event table for solr-based indexing
|
||
3 | */
|
||
4 | CREATE TABLE index_event ( |
||
5 | guid VARCHAR2(2000), |
||
6 | event_action VARCHAR2(250), |
||
7 | description VARCHAR2(2000), |
||
8 | event_date DATE |
||
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); |