root/sql/tables/stratcon.event_criteria.sql

Revision 6154e3c58475b805c2251d767c44dbe6a6cb8acf, 1.3 kB (checked in by Robert Treat <robert@omniti.com>, 4 years ago)

checks didnt check out

  • Property mode set to 100644
Line 
1 --
2 -- PostgreSQL database dump
3 --
4
5 SET client_encoding = 'UTF8';
6 SET standard_conforming_strings = off;
7 SET check_function_bodies = false;
8 SET client_min_messages = warning;
9 SET escape_string_warning = off;
10
11 SET search_path = stratcon, pg_catalog;
12
13 SET default_tablespace = '';
14
15 SET default_with_oids = false;
16
17 --
18 -- Name: event_criteria; Type: TABLE; Schema: stratcon; Owner: reconnoiter;
19 --
20
21 CREATE SEQUENCE event_criteria_id_seq
22     INCREMENT BY 1
23     NO MAXVALUE
24     NO MINVALUE
25     CACHE 1;
26
27 GRANT SELECT,UPDATE ON SEQUENCE event_criteria_id_seq TO stratcon;
28
29 CREATE TABLE event_criteria_numeric (
30   check_id uuid not null,
31   metric_name text not null,
32   event_criteria_id integer not null primary key,
33   derive text check (derive in ('derive_5m','counter_5m',NULL))
34 );
35
36 CREATE INDEX event_criteria_numeric_check_id_idx
37     ON event_criteria_numeric (check_id);
38
39 CREATE TABLE event_criteria_text (
40   check_id uuid not null,
41   metric_name text not null,
42   event_criteria_id integer not null primary key
43 );
44
45 CREATE INDEX event_criteria_text_check_id_idx
46     ON event_criteria_text (check_id);
47
48 GRANT SELECT ON TABLE event_criteria_numeric TO prism;
49 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE event_criteria_numeric TO stratcon;
50
51 GRANT SELECT ON TABLE event_criteria_text TO prism;
52 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE event_criteria_text TO stratcon;
53
Note: See TracBrowser for help on using the browser.