"Fossies" - the Fresh Open Source Software Archive

Member "monasca-api-3.1.0/devstack/files/vertica/mon_alarms.sql" (27 Sep 2019, 457 Bytes) of package /linux/misc/openstack/monasca-api-3.1.0.tar.gz:

As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 CREATE SCHEMA MonAlarms;
    3 CREATE TABLE MonAlarms.StateHistory(
    4     id AUTO_INCREMENT,
    5     tenant_id VARCHAR,
    6     alarm_id VARCHAR,
    7     metrics VARCHAR (65000),
    8     old_state VARCHAR,
    9     new_state VARCHAR,
   10     sub_alarms VARCHAR (65000),
   11     reason VARCHAR(65000),
   12     reason_data VARCHAR(65000),
   13     time_stamp TIMESTAMP NOT NULL
   14 ) PARTITION BY EXTRACT('year' FROM time_stamp)*10000 + EXTRACT('month' FROM time_stamp)*100 + EXTRACT('day' FROM time_stamp);