vigiboard / bdd_vigiboard_schema.sql @ 2ba99120
History | View | Annotate | Download (21.6 KB)
1 |
--
|
---|---|
2 |
-- PostgreSQL database dump
|
3 |
--
|
4 |
|
5 |
SET client_encoding = 'SQL_ASCII'; |
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 = public, pg_catalog;
|
12 |
|
13 |
SET default_tablespace = ''; |
14 |
|
15 |
SET default_with_oids = false; |
16 |
|
17 |
--
|
18 |
-- Name: event_history; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
19 |
--
|
20 |
|
21 |
CREATE TABLE event_history ( |
22 |
idhistory integer NOT NULL, |
23 |
type_action character varying(27) NOT NULL, |
24 |
idevent integer NOT NULL, |
25 |
value character varying(255),
|
26 |
text text, |
27 |
"timestamp" timestamp without time zone, |
28 |
username character varying(255)
|
29 |
); |
30 |
|
31 |
|
32 |
ALTER TABLE public.event_history OWNER TO vigiboard; |
33 |
|
34 |
--
|
35 |
-- Name: event_history_idhistory_seq; Type: SEQUENCE; Schema: public; Owner: vigiboard
|
36 |
--
|
37 |
|
38 |
CREATE SEQUENCE event_history_idhistory_seq
|
39 |
INCREMENT BY 1 |
40 |
NO MAXVALUE |
41 |
NO MINVALUE |
42 |
CACHE 1;
|
43 |
|
44 |
|
45 |
ALTER TABLE public.event_history_idhistory_seq OWNER TO vigiboard; |
46 |
|
47 |
--
|
48 |
-- Name: event_history_idhistory_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vigiboard
|
49 |
--
|
50 |
|
51 |
ALTER SEQUENCE event_history_idhistory_seq OWNED BY event_history.idhistory; |
52 |
|
53 |
|
54 |
--
|
55 |
-- Name: events; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
56 |
--
|
57 |
|
58 |
CREATE TABLE events ( |
59 |
idevent integer NOT NULL, |
60 |
hostname character varying(100) NOT NULL, |
61 |
servicename character varying(100),
|
62 |
server_source character varying(100),
|
63 |
severity integer NOT NULL, |
64 |
status character varying(12) DEFAULT 'None'::character varying NOT NULL, |
65 |
active boolean,
|
66 |
"timestamp" timestamp without time zone, |
67 |
output text NOT NULL, |
68 |
event_timestamp timestamp without time zone, |
69 |
last_check timestamp without time zone, |
70 |
recover_output text,
|
71 |
timestamp_active timestamp without time zone, |
72 |
timestamp_cleared timestamp without time zone, |
73 |
trouble_ticket character varying(20),
|
74 |
occurence integer,
|
75 |
impact integer,
|
76 |
rawstate character varying |
77 |
); |
78 |
|
79 |
|
80 |
ALTER TABLE public.events OWNER TO vigiboard; |
81 |
|
82 |
--
|
83 |
-- Name: events_idevent_seq; Type: SEQUENCE; Schema: public; Owner: vigiboard
|
84 |
--
|
85 |
|
86 |
CREATE SEQUENCE events_idevent_seq
|
87 |
INCREMENT BY 1 |
88 |
NO MAXVALUE |
89 |
NO MINVALUE |
90 |
CACHE 1;
|
91 |
|
92 |
|
93 |
ALTER TABLE public.events_idevent_seq OWNER TO vigiboard; |
94 |
|
95 |
--
|
96 |
-- Name: events_idevent_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vigiboard
|
97 |
--
|
98 |
|
99 |
ALTER SEQUENCE events_idevent_seq OWNED BY events.idevent; |
100 |
|
101 |
|
102 |
--
|
103 |
-- Name: graph; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
104 |
--
|
105 |
|
106 |
CREATE TABLE graph ( |
107 |
name character varying(100) NOT NULL, |
108 |
template character varying(2500) NOT NULL, |
109 |
vlabel character varying(2500) NOT NULL |
110 |
); |
111 |
|
112 |
|
113 |
ALTER TABLE public.graph OWNER TO vigiboard; |
114 |
|
115 |
--
|
116 |
-- Name: graphgroups; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
117 |
--
|
118 |
|
119 |
CREATE TABLE graphgroups ( |
120 |
name character varying(100) NOT NULL, |
121 |
parent integer
|
122 |
); |
123 |
|
124 |
|
125 |
ALTER TABLE public.graphgroups OWNER TO vigiboard; |
126 |
|
127 |
--
|
128 |
-- Name: graphtogroups; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
129 |
--
|
130 |
|
131 |
CREATE TABLE graphtogroups ( |
132 |
graphname character varying(100) NOT NULL, |
133 |
groupname character varying(100) NOT NULL |
134 |
); |
135 |
|
136 |
|
137 |
ALTER TABLE public.graphtogroups OWNER TO vigiboard; |
138 |
|
139 |
--
|
140 |
-- Name: grouppermissions; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
141 |
--
|
142 |
|
143 |
CREATE TABLE grouppermissions ( |
144 |
groupname character varying(100) NOT NULL, |
145 |
idpermission integer NOT NULL |
146 |
); |
147 |
|
148 |
|
149 |
ALTER TABLE public.grouppermissions OWNER TO vigiboard; |
150 |
|
151 |
--
|
152 |
-- Name: groups; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
153 |
--
|
154 |
|
155 |
CREATE TABLE groups ( |
156 |
name character varying(100) NOT NULL, |
157 |
parent character varying(100)
|
158 |
); |
159 |
|
160 |
|
161 |
ALTER TABLE public.groups OWNER TO vigiboard; |
162 |
|
163 |
--
|
164 |
-- Name: host; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
165 |
--
|
166 |
|
167 |
CREATE TABLE host ( |
168 |
name character varying(255) NOT NULL, |
169 |
checkhostcmd character varying(255) NOT NULL, |
170 |
community character varying(255) NOT NULL, |
171 |
fqhn character varying(255) NOT NULL, |
172 |
hosttpl character varying(255) NOT NULL, |
173 |
mainip character varying(255) NOT NULL, |
174 |
port integer NOT NULL, |
175 |
snmpoidsperpdu integer,
|
176 |
snmpversion character varying(255)
|
177 |
); |
178 |
|
179 |
|
180 |
ALTER TABLE public.host OWNER TO vigiboard; |
181 |
|
182 |
--
|
183 |
-- Name: hostgroups; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
184 |
--
|
185 |
|
186 |
CREATE TABLE hostgroups ( |
187 |
hostname character varying(100) NOT NULL, |
188 |
groupname character varying(100) NOT NULL |
189 |
); |
190 |
|
191 |
|
192 |
ALTER TABLE public.hostgroups OWNER TO vigiboard; |
193 |
|
194 |
--
|
195 |
-- Name: perfdatasource; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
196 |
--
|
197 |
|
198 |
CREATE TABLE perfdatasource ( |
199 |
hostname character varying(100) NOT NULL, |
200 |
servicename character varying(100) NOT NULL, |
201 |
graphname character varying(100) NOT NULL, |
202 |
type character varying(100) NOT NULL, |
203 |
label character varying(255),
|
204 |
factor double precision NOT NULL |
205 |
); |
206 |
|
207 |
|
208 |
ALTER TABLE public.perfdatasource OWNER TO vigiboard; |
209 |
|
210 |
--
|
211 |
-- Name: service; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
212 |
--
|
213 |
|
214 |
CREATE TABLE service ( |
215 |
name character varying(255) NOT NULL, |
216 |
type character varying(255) NOT NULL, |
217 |
command character varying(255) NOT NULL |
218 |
); |
219 |
|
220 |
|
221 |
ALTER TABLE public.service OWNER TO vigiboard; |
222 |
|
223 |
--
|
224 |
-- Name: servicegroups; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
225 |
--
|
226 |
|
227 |
CREATE TABLE servicegroups ( |
228 |
servicename character varying(100) NOT NULL, |
229 |
groupname character varying(100) NOT NULL |
230 |
); |
231 |
|
232 |
|
233 |
ALTER TABLE public.servicegroups OWNER TO vigiboard; |
234 |
|
235 |
--
|
236 |
-- Name: servicehautniveau; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
237 |
--
|
238 |
|
239 |
CREATE TABLE servicehautniveau ( |
240 |
servicename character varying(100) NOT NULL, |
241 |
servicename_dep character varying(100) NOT NULL |
242 |
); |
243 |
|
244 |
|
245 |
ALTER TABLE public.servicehautniveau OWNER TO vigiboard; |
246 |
|
247 |
--
|
248 |
-- Name: servicetopo; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
249 |
--
|
250 |
|
251 |
CREATE TABLE servicetopo ( |
252 |
servicename character varying(100) NOT NULL, |
253 |
function character varying(50) NOT NULL |
254 |
); |
255 |
|
256 |
|
257 |
ALTER TABLE public.servicetopo OWNER TO vigiboard; |
258 |
|
259 |
--
|
260 |
-- Name: state; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
261 |
--
|
262 |
|
263 |
CREATE TABLE state ( |
264 |
idstat integer NOT NULL, |
265 |
hostname character varying(100) NOT NULL, |
266 |
servicename character varying(100),
|
267 |
ip character varying(40),
|
268 |
"timestamp" timestamp without time zone, |
269 |
statename character varying(8) DEFAULT 'OK'::character varying NOT NULL, |
270 |
type character varying(4) DEFAULT 'SOFT'::character varying NOT NULL, |
271 |
attempt integer NOT NULL, |
272 |
message text
|
273 |
); |
274 |
|
275 |
|
276 |
ALTER TABLE public.state OWNER TO vigiboard; |
277 |
|
278 |
--
|
279 |
-- Name: state_idstat_seq; Type: SEQUENCE; Schema: public; Owner: vigiboard
|
280 |
--
|
281 |
|
282 |
CREATE SEQUENCE state_idstat_seq
|
283 |
INCREMENT BY 1 |
284 |
NO MAXVALUE |
285 |
NO MINVALUE |
286 |
CACHE 1;
|
287 |
|
288 |
|
289 |
ALTER TABLE public.state_idstat_seq OWNER TO vigiboard; |
290 |
|
291 |
--
|
292 |
-- Name: state_idstat_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vigiboard
|
293 |
--
|
294 |
|
295 |
ALTER SEQUENCE state_idstat_seq OWNED BY state.idstat; |
296 |
|
297 |
|
298 |
--
|
299 |
-- Name: tg_group; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
300 |
--
|
301 |
|
302 |
CREATE TABLE tg_group ( |
303 |
group_id integer NOT NULL, |
304 |
group_name character varying(16) NOT NULL, |
305 |
display_name character varying(255),
|
306 |
created timestamp without time zone |
307 |
); |
308 |
|
309 |
|
310 |
ALTER TABLE public.tg_group OWNER TO vigiboard; |
311 |
|
312 |
--
|
313 |
-- Name: tg_group_group_id_seq; Type: SEQUENCE; Schema: public; Owner: vigiboard
|
314 |
--
|
315 |
|
316 |
CREATE SEQUENCE tg_group_group_id_seq
|
317 |
INCREMENT BY 1 |
318 |
NO MAXVALUE |
319 |
NO MINVALUE |
320 |
CACHE 1;
|
321 |
|
322 |
|
323 |
ALTER TABLE public.tg_group_group_id_seq OWNER TO vigiboard; |
324 |
|
325 |
--
|
326 |
-- Name: tg_group_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vigiboard
|
327 |
--
|
328 |
|
329 |
ALTER SEQUENCE tg_group_group_id_seq OWNED BY tg_group.group_id; |
330 |
|
331 |
|
332 |
--
|
333 |
-- Name: tg_group_permission; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
334 |
--
|
335 |
|
336 |
CREATE TABLE tg_group_permission ( |
337 |
group_id integer,
|
338 |
permission_id integer
|
339 |
); |
340 |
|
341 |
|
342 |
ALTER TABLE public.tg_group_permission OWNER TO vigiboard; |
343 |
|
344 |
--
|
345 |
-- Name: tg_permission; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
346 |
--
|
347 |
|
348 |
CREATE TABLE tg_permission ( |
349 |
permission_id integer NOT NULL, |
350 |
permission_name character varying(16) NOT NULL, |
351 |
description character varying(255)
|
352 |
); |
353 |
|
354 |
|
355 |
ALTER TABLE public.tg_permission OWNER TO vigiboard; |
356 |
|
357 |
--
|
358 |
-- Name: tg_permission_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: vigiboard
|
359 |
--
|
360 |
|
361 |
CREATE SEQUENCE tg_permission_permission_id_seq
|
362 |
INCREMENT BY 1 |
363 |
NO MAXVALUE |
364 |
NO MINVALUE |
365 |
CACHE 1;
|
366 |
|
367 |
|
368 |
ALTER TABLE public.tg_permission_permission_id_seq OWNER TO vigiboard; |
369 |
|
370 |
--
|
371 |
-- Name: tg_permission_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vigiboard
|
372 |
--
|
373 |
|
374 |
ALTER SEQUENCE tg_permission_permission_id_seq OWNED BY tg_permission.permission_id; |
375 |
|
376 |
|
377 |
--
|
378 |
-- Name: tg_user; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
379 |
--
|
380 |
|
381 |
CREATE TABLE tg_user ( |
382 |
user_id integer NOT NULL, |
383 |
user_name character varying(16) NOT NULL, |
384 |
email_address character varying(255) NOT NULL, |
385 |
display_name character varying(255),
|
386 |
password character varying(80),
|
387 |
created timestamp without time zone |
388 |
); |
389 |
|
390 |
|
391 |
ALTER TABLE public.tg_user OWNER TO vigiboard; |
392 |
|
393 |
--
|
394 |
-- Name: tg_user_group; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
395 |
--
|
396 |
|
397 |
CREATE TABLE tg_user_group ( |
398 |
user_id integer,
|
399 |
group_id integer
|
400 |
); |
401 |
|
402 |
|
403 |
ALTER TABLE public.tg_user_group OWNER TO vigiboard; |
404 |
|
405 |
--
|
406 |
-- Name: tg_user_user_id_seq; Type: SEQUENCE; Schema: public; Owner: vigiboard
|
407 |
--
|
408 |
|
409 |
CREATE SEQUENCE tg_user_user_id_seq
|
410 |
INCREMENT BY 1 |
411 |
NO MAXVALUE |
412 |
NO MINVALUE |
413 |
CACHE 1;
|
414 |
|
415 |
|
416 |
ALTER TABLE public.tg_user_user_id_seq OWNER TO vigiboard; |
417 |
|
418 |
--
|
419 |
-- Name: tg_user_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vigiboard
|
420 |
--
|
421 |
|
422 |
ALTER SEQUENCE tg_user_user_id_seq OWNED BY tg_user.user_id; |
423 |
|
424 |
|
425 |
--
|
426 |
-- Name: version; Type: TABLE; Schema: public; Owner: vigiboard; Tablespace:
|
427 |
--
|
428 |
|
429 |
CREATE TABLE version ( |
430 |
name character varying(255) NOT NULL, |
431 |
version character varying(255) NOT NULL |
432 |
); |
433 |
|
434 |
|
435 |
ALTER TABLE public.version OWNER TO vigiboard; |
436 |
|
437 |
--
|
438 |
-- Name: idhistory; Type: DEFAULT; Schema: public; Owner: vigiboard
|
439 |
--
|
440 |
|
441 |
ALTER TABLE event_history ALTER COLUMN idhistory SET DEFAULT nextval('event_history_idhistory_seq'::regclass); |
442 |
|
443 |
|
444 |
--
|
445 |
-- Name: idevent; Type: DEFAULT; Schema: public; Owner: vigiboard
|
446 |
--
|
447 |
|
448 |
ALTER TABLE events ALTER COLUMN idevent SET DEFAULT nextval('events_idevent_seq'::regclass); |
449 |
|
450 |
|
451 |
--
|
452 |
-- Name: group_id; Type: DEFAULT; Schema: public; Owner: vigiboard
|
453 |
--
|
454 |
|
455 |
ALTER TABLE tg_group ALTER COLUMN group_id SET DEFAULT nextval('tg_group_group_id_seq'::regclass); |
456 |
|
457 |
|
458 |
--
|
459 |
-- Name: permission_id; Type: DEFAULT; Schema: public; Owner: vigiboard
|
460 |
--
|
461 |
|
462 |
ALTER TABLE tg_permission ALTER COLUMN permission_id SET DEFAULT nextval('tg_permission_permission_id_seq'::regclass); |
463 |
|
464 |
|
465 |
--
|
466 |
-- Name: user_id; Type: DEFAULT; Schema: public; Owner: vigiboard
|
467 |
--
|
468 |
|
469 |
ALTER TABLE tg_user ALTER COLUMN user_id SET DEFAULT nextval('tg_user_user_id_seq'::regclass); |
470 |
|
471 |
|
472 |
--
|
473 |
-- Name: event_history_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
474 |
--
|
475 |
|
476 |
ALTER TABLE ONLY event_history |
477 |
ADD CONSTRAINT event_history_pkey PRIMARY KEY (idhistory); |
478 |
|
479 |
|
480 |
--
|
481 |
-- Name: events_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
482 |
--
|
483 |
|
484 |
ALTER TABLE ONLY events |
485 |
ADD CONSTRAINT events_pkey PRIMARY KEY (idevent); |
486 |
|
487 |
|
488 |
--
|
489 |
-- Name: graph_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
490 |
--
|
491 |
|
492 |
ALTER TABLE ONLY graph |
493 |
ADD CONSTRAINT graph_pkey PRIMARY KEY (name); |
494 |
|
495 |
|
496 |
--
|
497 |
-- Name: graphgroups_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
498 |
--
|
499 |
|
500 |
ALTER TABLE ONLY graphgroups |
501 |
ADD CONSTRAINT graphgroups_pkey PRIMARY KEY (name); |
502 |
|
503 |
|
504 |
--
|
505 |
-- Name: graphtogroups_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
506 |
--
|
507 |
|
508 |
ALTER TABLE ONLY graphtogroups |
509 |
ADD CONSTRAINT graphtogroups_pkey PRIMARY KEY (graphname, groupname); |
510 |
|
511 |
|
512 |
--
|
513 |
-- Name: grouppermissions_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
514 |
--
|
515 |
|
516 |
ALTER TABLE ONLY grouppermissions |
517 |
ADD CONSTRAINT grouppermissions_pkey PRIMARY KEY (groupname, idpermission); |
518 |
|
519 |
|
520 |
--
|
521 |
-- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
522 |
--
|
523 |
|
524 |
ALTER TABLE ONLY groups |
525 |
ADD CONSTRAINT groups_pkey PRIMARY KEY (name); |
526 |
|
527 |
|
528 |
--
|
529 |
-- Name: host_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
530 |
--
|
531 |
|
532 |
ALTER TABLE ONLY host |
533 |
ADD CONSTRAINT host_pkey PRIMARY KEY (name); |
534 |
|
535 |
|
536 |
--
|
537 |
-- Name: hostgroups_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
538 |
--
|
539 |
|
540 |
ALTER TABLE ONLY hostgroups |
541 |
ADD CONSTRAINT hostgroups_pkey PRIMARY KEY (hostname, groupname); |
542 |
|
543 |
|
544 |
--
|
545 |
-- Name: perfdatasource_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
546 |
--
|
547 |
|
548 |
ALTER TABLE ONLY perfdatasource |
549 |
ADD CONSTRAINT perfdatasource_pkey PRIMARY KEY (hostname, servicename); |
550 |
|
551 |
|
552 |
--
|
553 |
-- Name: service_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
554 |
--
|
555 |
|
556 |
ALTER TABLE ONLY service |
557 |
ADD CONSTRAINT service_pkey PRIMARY KEY (name); |
558 |
|
559 |
|
560 |
--
|
561 |
-- Name: servicegroups_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
562 |
--
|
563 |
|
564 |
ALTER TABLE ONLY servicegroups |
565 |
ADD CONSTRAINT servicegroups_pkey PRIMARY KEY (servicename, groupname); |
566 |
|
567 |
|
568 |
--
|
569 |
-- Name: servicehautniveau_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
570 |
--
|
571 |
|
572 |
ALTER TABLE ONLY servicehautniveau |
573 |
ADD CONSTRAINT servicehautniveau_pkey PRIMARY KEY (servicename, servicename_dep); |
574 |
|
575 |
|
576 |
--
|
577 |
-- Name: servicetopo_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
578 |
--
|
579 |
|
580 |
ALTER TABLE ONLY servicetopo |
581 |
ADD CONSTRAINT servicetopo_pkey PRIMARY KEY (servicename); |
582 |
|
583 |
|
584 |
--
|
585 |
-- Name: tg_group_group_name_key; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
586 |
--
|
587 |
|
588 |
ALTER TABLE ONLY tg_group |
589 |
ADD CONSTRAINT tg_group_group_name_key UNIQUE (group_name); |
590 |
|
591 |
|
592 |
--
|
593 |
-- Name: tg_group_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
594 |
--
|
595 |
|
596 |
ALTER TABLE ONLY tg_group |
597 |
ADD CONSTRAINT tg_group_pkey PRIMARY KEY (group_id); |
598 |
|
599 |
|
600 |
--
|
601 |
-- Name: tg_permission_permission_name_key; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
602 |
--
|
603 |
|
604 |
ALTER TABLE ONLY tg_permission |
605 |
ADD CONSTRAINT tg_permission_permission_name_key UNIQUE (permission_name); |
606 |
|
607 |
|
608 |
--
|
609 |
-- Name: tg_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
610 |
--
|
611 |
|
612 |
ALTER TABLE ONLY tg_permission |
613 |
ADD CONSTRAINT tg_permission_pkey PRIMARY KEY (permission_id); |
614 |
|
615 |
|
616 |
--
|
617 |
-- Name: tg_user_email_address_key; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
618 |
--
|
619 |
|
620 |
ALTER TABLE ONLY tg_user |
621 |
ADD CONSTRAINT tg_user_email_address_key UNIQUE (email_address); |
622 |
|
623 |
|
624 |
--
|
625 |
-- Name: tg_user_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
626 |
--
|
627 |
|
628 |
ALTER TABLE ONLY tg_user |
629 |
ADD CONSTRAINT tg_user_pkey PRIMARY KEY (user_id); |
630 |
|
631 |
|
632 |
--
|
633 |
-- Name: tg_user_user_name_key; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace:
|
634 |
--
|
635 |
|
636 |
ALTER TABLE ONLY tg_user |
637 |
ADD CONSTRAINT tg_user_user_name_key UNIQUE (user_name); |
638 |
|
639 |
|
640 |
--
|
641 |
-- Name: ix_event_history_idevent; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
642 |
--
|
643 |
|
644 |
CREATE INDEX ix_event_history_idevent ON event_history USING btree (idevent); |
645 |
|
646 |
|
647 |
--
|
648 |
-- Name: ix_events_hostname; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
649 |
--
|
650 |
|
651 |
CREATE INDEX ix_events_hostname ON events USING btree (hostname); |
652 |
|
653 |
|
654 |
--
|
655 |
-- Name: ix_events_servicename; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
656 |
--
|
657 |
|
658 |
CREATE INDEX ix_events_servicename ON events USING btree (servicename); |
659 |
|
660 |
|
661 |
--
|
662 |
-- Name: ix_groups_parent; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
663 |
--
|
664 |
|
665 |
CREATE INDEX ix_groups_parent ON groups USING btree (parent); |
666 |
|
667 |
|
668 |
--
|
669 |
-- Name: ix_host_name; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
670 |
--
|
671 |
|
672 |
CREATE INDEX ix_host_name ON host USING btree (name); |
673 |
|
674 |
|
675 |
--
|
676 |
-- Name: ix_hostgroups_groupname; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
677 |
--
|
678 |
|
679 |
CREATE INDEX ix_hostgroups_groupname ON hostgroups USING btree (groupname); |
680 |
|
681 |
|
682 |
--
|
683 |
-- Name: ix_perfdatasource_graphname; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
684 |
--
|
685 |
|
686 |
CREATE INDEX ix_perfdatasource_graphname ON perfdatasource USING btree (graphname); |
687 |
|
688 |
|
689 |
--
|
690 |
-- Name: ix_perfdatasource_servicename; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
691 |
--
|
692 |
|
693 |
CREATE INDEX ix_perfdatasource_servicename ON perfdatasource USING btree (servicename); |
694 |
|
695 |
|
696 |
--
|
697 |
-- Name: ix_service_name; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
698 |
--
|
699 |
|
700 |
CREATE INDEX ix_service_name ON service USING btree (name); |
701 |
|
702 |
|
703 |
--
|
704 |
-- Name: ix_servicegroups_groupname; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
705 |
--
|
706 |
|
707 |
CREATE INDEX ix_servicegroups_groupname ON servicegroups USING btree (groupname); |
708 |
|
709 |
|
710 |
--
|
711 |
-- Name: ix_servicehautniveau_servicename_dep; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace:
|
712 |
--
|
713 |
|
714 |
CREATE INDEX ix_servicehautniveau_servicename_dep ON servicehautniveau USING btree (servicename_dep); |
715 |
|
716 |
|
717 |
--
|
718 |
-- Name: event_history_idevent_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
719 |
--
|
720 |
|
721 |
ALTER TABLE ONLY event_history |
722 |
ADD CONSTRAINT event_history_idevent_fkey FOREIGN KEY (idevent) REFERENCES events(idevent); |
723 |
|
724 |
|
725 |
--
|
726 |
-- Name: events_hostname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
727 |
--
|
728 |
|
729 |
ALTER TABLE ONLY events |
730 |
ADD CONSTRAINT events_hostname_fkey FOREIGN KEY (hostname) REFERENCES host(name); |
731 |
|
732 |
|
733 |
--
|
734 |
-- Name: events_servicename_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
735 |
--
|
736 |
|
737 |
ALTER TABLE ONLY events |
738 |
ADD CONSTRAINT events_servicename_fkey FOREIGN KEY (servicename) REFERENCES service(name); |
739 |
|
740 |
|
741 |
--
|
742 |
-- Name: graphtogroups_graphname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
743 |
--
|
744 |
|
745 |
ALTER TABLE ONLY graphtogroups |
746 |
ADD CONSTRAINT graphtogroups_graphname_fkey FOREIGN KEY (graphname) REFERENCES graph(name); |
747 |
|
748 |
|
749 |
--
|
750 |
-- Name: graphtogroups_groupname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
751 |
--
|
752 |
|
753 |
ALTER TABLE ONLY graphtogroups |
754 |
ADD CONSTRAINT graphtogroups_groupname_fkey FOREIGN KEY (groupname) REFERENCES graphgroups(name); |
755 |
|
756 |
|
757 |
--
|
758 |
-- Name: grouppermissions_groupname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
759 |
--
|
760 |
|
761 |
ALTER TABLE ONLY grouppermissions |
762 |
ADD CONSTRAINT grouppermissions_groupname_fkey FOREIGN KEY (groupname) REFERENCES groups(name); |
763 |
|
764 |
|
765 |
--
|
766 |
-- Name: hostgroups_groupname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
767 |
--
|
768 |
|
769 |
ALTER TABLE ONLY hostgroups |
770 |
ADD CONSTRAINT hostgroups_groupname_fkey FOREIGN KEY (groupname) REFERENCES groups(name); |
771 |
|
772 |
|
773 |
--
|
774 |
-- Name: hostgroups_hostname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
775 |
--
|
776 |
|
777 |
ALTER TABLE ONLY hostgroups |
778 |
ADD CONSTRAINT hostgroups_hostname_fkey FOREIGN KEY (hostname) REFERENCES host(name); |
779 |
|
780 |
|
781 |
--
|
782 |
-- Name: perfdatasource_graphname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
783 |
--
|
784 |
|
785 |
ALTER TABLE ONLY perfdatasource |
786 |
ADD CONSTRAINT perfdatasource_graphname_fkey FOREIGN KEY (graphname) REFERENCES graph(name); |
787 |
|
788 |
|
789 |
--
|
790 |
-- Name: perfdatasource_hostname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
791 |
--
|
792 |
|
793 |
ALTER TABLE ONLY perfdatasource |
794 |
ADD CONSTRAINT perfdatasource_hostname_fkey FOREIGN KEY (hostname) REFERENCES host(name); |
795 |
|
796 |
|
797 |
--
|
798 |
-- Name: perfdatasource_servicename_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
799 |
--
|
800 |
|
801 |
ALTER TABLE ONLY perfdatasource |
802 |
ADD CONSTRAINT perfdatasource_servicename_fkey FOREIGN KEY (servicename) REFERENCES service(name); |
803 |
|
804 |
|
805 |
--
|
806 |
-- Name: servicegroups_groupname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
807 |
--
|
808 |
|
809 |
ALTER TABLE ONLY servicegroups |
810 |
ADD CONSTRAINT servicegroups_groupname_fkey FOREIGN KEY (groupname) REFERENCES groups(name); |
811 |
|
812 |
|
813 |
--
|
814 |
-- Name: servicegroups_servicename_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
815 |
--
|
816 |
|
817 |
ALTER TABLE ONLY servicegroups |
818 |
ADD CONSTRAINT servicegroups_servicename_fkey FOREIGN KEY (servicename) REFERENCES service(name); |
819 |
|
820 |
|
821 |
--
|
822 |
-- Name: servicehautniveau_servicename_dep_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
823 |
--
|
824 |
|
825 |
ALTER TABLE ONLY servicehautniveau |
826 |
ADD CONSTRAINT servicehautniveau_servicename_dep_fkey FOREIGN KEY (servicename_dep) REFERENCES service(name); |
827 |
|
828 |
|
829 |
--
|
830 |
-- Name: servicehautniveau_servicename_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
831 |
--
|
832 |
|
833 |
ALTER TABLE ONLY servicehautniveau |
834 |
ADD CONSTRAINT servicehautniveau_servicename_fkey FOREIGN KEY (servicename) REFERENCES service(name); |
835 |
|
836 |
|
837 |
--
|
838 |
-- Name: servicetopo_servicename_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
839 |
--
|
840 |
|
841 |
ALTER TABLE ONLY servicetopo |
842 |
ADD CONSTRAINT servicetopo_servicename_fkey FOREIGN KEY (servicename) REFERENCES service(name); |
843 |
|
844 |
|
845 |
--
|
846 |
-- Name: tg_group_permission_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
847 |
--
|
848 |
|
849 |
ALTER TABLE ONLY tg_group_permission |
850 |
ADD CONSTRAINT tg_group_permission_group_id_fkey FOREIGN KEY (group_id) REFERENCES tg_group(group_id) ON UPDATE CASCADE ON DELETE CASCADE; |
851 |
|
852 |
|
853 |
--
|
854 |
-- Name: tg_group_permission_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
855 |
--
|
856 |
|
857 |
ALTER TABLE ONLY tg_group_permission |
858 |
ADD CONSTRAINT tg_group_permission_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES tg_permission(permission_id) ON UPDATE CASCADE ON DELETE CASCADE; |
859 |
|
860 |
|
861 |
--
|
862 |
-- Name: tg_user_group_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
863 |
--
|
864 |
|
865 |
ALTER TABLE ONLY tg_user_group |
866 |
ADD CONSTRAINT tg_user_group_group_id_fkey FOREIGN KEY (group_id) REFERENCES tg_group(group_id) ON UPDATE CASCADE ON DELETE CASCADE; |
867 |
|
868 |
|
869 |
--
|
870 |
-- Name: tg_user_group_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard
|
871 |
--
|
872 |
|
873 |
ALTER TABLE ONLY tg_user_group |
874 |
ADD CONSTRAINT tg_user_group_user_id_fkey FOREIGN KEY (user_id) REFERENCES tg_user(user_id) ON UPDATE CASCADE ON DELETE CASCADE; |
875 |
|
876 |
|
877 |
--
|
878 |
-- Name: public; Type: ACL; Schema: -; Owner: postgres
|
879 |
--
|
880 |
|
881 |
REVOKE ALL ON SCHEMA public FROM PUBLIC; |
882 |
REVOKE ALL ON SCHEMA public FROM postgres; |
883 |
GRANT ALL ON SCHEMA public TO postgres; |
884 |
GRANT ALL ON SCHEMA public TO PUBLIC; |
885 |
|
886 |
|
887 |
--
|
888 |
-- PostgreSQL database dump complete
|
889 |
--
|
890 |
|