/*
 * 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);