Project

General

Profile

metacat / src / upgrade-db-to-2.1.0-oracle.sql @ 8013

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