Metacat

/*

 * the index_event table for solr-based indexing

 */

CREATE TABLE index_event (

	guid text,

	event_action VARCHAR(250),

	description text, 

	event_date TIMESTAMP

);

/*

 * update the database version

 */

UPDATE db_version SET status=0;

INSERT INTO db_version (version, status, date_created) 

  VALUES ('2.1.0', 1, CURRENT_DATE);

/*

 * the index_event table for solr-based indexing

 */

CREATE TABLE index_event (

	guid VARCHAR2(2000),

	event_action VARCHAR2(250),

	description VARCHAR2(2000), 

	event_date DATE

);

/*

 * update the database version

 */

UPDATE db_version SET status=0;

INSERT INTO db_version (version, status, date_created) 

  VALUES ('2.1.0', 1, CURRENT_DATE);