1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
|
--
-- ZABBIX
-- Copyright (C) 2000-2005 SIA Zabbix
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 2 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
--
--
-- Table structure for table 'config'
--
CREATE TABLE config (
alert_history number(10) DEFAULT '0' NOT NULL,
alarm_history number(10) DEFAULT '0' NOT NULL,
refresh_unsupported number(10) DEFAULT '0' NOT NULL,
work_period varchar2(100) DEFAULT '1-5,00:00-24:00' NOT NULL
);
--
-- Table structure for table 'history'
--
CREATE TABLE history (
itemid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
value number(16,4) DEFAULT '0.0000' NOT NULL
);
CREATE INDEX history_itemidclock on history (itemid, clock);
--
-- Table structure for table 'services'
--
CREATE TABLE services (
serviceid number(10) NOT NULL,
name varchar2(128) DEFAULT NULL,
status number(3) DEFAULT '0' NOT NULL,
algorithm number(3) DEFAULT '0' NOT NULL,
triggerid number(10),
showsla number(3) DEFAULT '0' NOT NULL,
goodsla number(5,2) DEFAULT '99.9' NOT NULL,
sortorder number(10) DEFAULT '0' NOT NULL,
CONSTRAINT services_pk PRIMARY KEY (serviceid)
);
create sequence services_serviceid
start with 20000
increment by 1
nomaxvalue;
create trigger services_trigger
before insert on services
for each row
begin
if (:new.serviceid is null or :new.serviceid = 0) then
select services_serviceid.nextval into :new.serviceid from dual;
end if;
end;
/
--
-- Table structure for table 'services_links'
--
CREATE TABLE services_links (
linkid number(10) NOT NULL,
serviceupid number(10) DEFAULT '0' NOT NULL,
servicedownid number(10) DEFAULT '0' NOT NULL,
soft number(3) DEFAULT '0' NOT NULL,
CONSTRAINT services_links_pk PRIMARY KEY (linkid)
);
CREATE INDEX services_links_servicedownid on services_links (servicedownid);
CREATE UNIQUE INDEX services_links_serviceupdownid on services_links (serviceupid,servicedownid);
create sequence services_links_linkid
start with 20000
increment by 1
nomaxvalue;
create trigger services_links_trigger
before insert on services_links
for each row
begin
if (:new.linkid is null or :new.linkid = 0) then
select services_links_linkid.nextval into :new.linkid from dual;
end if;
end;
/
--
-- Table structure for table 'graphs_items'
--
CREATE TABLE graphs_items (
gitemid number(10) NOT NULL,
graphid number(10) DEFAULT '0' NOT NULL,
itemid number(10) DEFAULT '0' NOT NULL,
drawtype number(10) DEFAULT '0' NOT NULL,
sortorder number(10) DEFAULT '0' NOT NULL,
color varchar2(32) DEFAULT 'Dark Green' NOT NULL,
yaxisside number(3) DEFAULT '1' NOT NULL,
CONSTRAINT graphs_items_pk PRIMARY KEY (gitemid)
);
create sequence graphs_items_gitemid
start with 20000
increment by 1
nomaxvalue;
create trigger graphs_items_trigger
before insert on graphs_items
for each row
begin
if (:new.gitemid is null or :new.gitemid = 0) then
select graphs_items_gitemid.nextval into :new.gitemid from dual;
end if;
end;
/
--
-- Table structure for table 'graphs'
--
CREATE TABLE graphs (
graphid number(10) NOT NULL,
name varchar2(128) DEFAULT NULL,
width number(10) DEFAULT '0' NOT NULL,
height number(10) DEFAULT '0' NOT NULL,
yaxistype number(3) DEFAULT '0' NOT NULL,
yaxismin number(16,4) DEFAULT '0' NOT NULL,
yaxismax number(16,4) DEFAULT '0' NOT NULL,
templateid number(10) DEFAULT '0' NOT NULL,
show_work_period number(3) DEFAULT '1' NOT NULL,
show_triggers number(3) DEFAULT '1' NOT NULL,
CONSTRAINT graphs_pk PRIMARY KEY (graphid)
);
CREATE INDEX graphs_name on graphs (name);
create sequence graphs_graphid
start with 20000
increment by 1
nomaxvalue;
create trigger graphs_trigger
before insert on graphs
for each row
begin
if (:new.graphid is null or :new.graphid = 0) then
select graphs_graphid.nextval into :new.graphid from dual;
end if;
end;
/
--
-- Table structure for table 'sysmaps_links'
--
CREATE TABLE sysmaps_links (
linkid number(10) NOT NULL,
sysmapid number(10) DEFAULT '0' NOT NULL,
selementid1 number(10) DEFAULT '0' NOT NULL,
selementid2 number(10) DEFAULT '0' NOT NULL,
-- may be NULL
triggerid number(10),
drawtype_off number(10) DEFAULT '0' NOT NULL,
color_off varchar2(32) DEFAULT 'Black' NOT NULL,
drawtype_on number(10) DEFAULT '0' NOT NULL,
color_on varchar2(32) DEFAULT 'Red' NOT NULL,
CONSTRAINT sysmaps_links_pk PRIMARY KEY (linkid)
);
create sequence sysmaps_links_linkid
start with 20000
increment by 1
nomaxvalue;
create trigger sysmaps_links_trigger
before insert on sysmaps_links
for each row
begin
if (:new.linkid is null or :new.linkid = 0) then
select sysmaps_links_linkid.nextval into :new.linkid from dual;
end if;
end;
/
--
-- Table structure for table 'sysmaps_elements'
--
CREATE TABLE sysmaps_elements (
selementid number(10) NOT NULL,
sysmapid number(10) DEFAULT '0' NOT NULL,
elementid number(10) DEFAULT '0' NOT NULL,
elementtype number(10) DEFAULT '0' NOT NULL,
icon varchar2(32) DEFAULT 'Server' NOT NULL,
icon_on varchar2(32) DEFAULT 'Server' NOT NULL,
label varchar2(128) DEFAULT NULL,
label_location number(3) DEFAULT NULL,
x number(10) DEFAULT '0' NOT NULL,
y number(10) DEFAULT '0' NOT NULL,
url varchar2(255) DEFAULT NULL,
CONSTRAINT sysmaps_elements_pk PRIMARY KEY (selementid)
);
create sequence sysmaps_elements_selementid
start with 20000
increment by 1
nomaxvalue;
create trigger sysmaps_elements_trigger
before insert on sysmaps_elements
for each row
begin
if (:new.selementid is null or :new.selementid = 0) then
select sysmaps_elements_selementid.nextval into :new.selementid from dual;
end if;
end;
/
--
-- Table structure for table 'sysmaps'
--
CREATE TABLE sysmaps (
sysmapid number(10) NOT NULL,
name varchar2(128) DEFAULT NULL,
width number(10) DEFAULT '0' NOT NULL,
height number(10) DEFAULT '0' NOT NULL,
background varchar2(64) DEFAULT NULL,
label_type number(10) DEFAULT '0' NOT NULL,
label_location number(3) DEFAULT '0' NOT NULL,
CONSTRAINT sysmaps_pk PRIMARY KEY (sysmapid)
);
CREATE UNIQUE INDEX sysmaps_name on sysmaps (name);
create sequence sysmaps_sysmapid
start with 20000
increment by 1
nomaxvalue;
create trigger sysmaps_trigger
before insert on sysmaps
for each row
begin
if (:new.sysmapid is null or :new.sysmapid = 0) then
select sysmaps_sysmapid.nextval into :new.sysmapid from dual;
end if;
end;
/
--
-- Table structure for table 'groups'
--
CREATE TABLE groups (
groupid number(10) NOT NULL,
name varchar2(64) DEFAULT NULL,
CONSTRAINT groups_pk PRIMARY KEY (groupid)
);
CREATE UNIQUE INDEX groups_name on groups (name);
create sequence groups_groupid
start with 20000
increment by 1
nomaxvalue;
create trigger groups_trigger
before insert on groups
for each row
begin
if (:new.groupid is null or :new.groupid = 0) then
select groups_groupid.nextval into :new.groupid from dual;
end if;
end;
/
--
-- Table structure for table 'hosts_groups'
--
CREATE TABLE hosts_groups (
hostid number(10) DEFAULT '0' NOT NULL,
groupid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT hosts_groups_pk PRIMARY KEY (hostid, groupid)
);
--
-- Table structure for table 'alerts'
--
CREATE TABLE alerts (
alertid number(10) NOT NULL,
actionid number(10) DEFAULT '0' NOT NULL,
triggerid number(10) DEFAULT '0' NOT NULL,
userid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
mediatypeid number(10) DEFAULT '0' NOT NULL,
sendto varchar2(100) DEFAULT NULL,
subject varchar2(255) DEFAULT NULL,
message varchar2(2048) DEFAULT NULL,
status number(10) DEFAULT '0' NOT NULL,
retries number(10) DEFAULT '0' NOT NULL,
error varchar2(128) DEFAULT NULL,
repeats number(10) DEFAULT '0' NOT NULL,
maxrepeats number(10) DEFAULT '0' NOT NULL,
nextcheck number(10) DEFAULT '0' NOT NULL,
delay number(10) DEFAULT '0' NOT NULL,
CONSTRAINT alerts_pk PRIMARY KEY (alertid)
);
CREATE INDEX alerts_actionid on alerts (actionid);
CREATE INDEX alerts_clock on alerts (clock);
CREATE INDEX alerts_triggerid on alerts (triggerid);
CREATE INDEX alerts_statusretries on alerts (status, retries);
CREATE INDEX alerts_mediatypeid on alerts (mediatypeid);
CREATE INDEX alerts_userid on alerts (userid);
create sequence alerts_alertid
start with 20000
increment by 1
nomaxvalue;
create trigger alerts_trigger
before insert on alerts
for each row
begin
if (:new.alertid is null or :new.alertid = 0) then
select alerts_alertid.nextval into :new.alertid from dual;
end if;
end;
/
--
-- Table structure for table 'actions'
--
CREATE TABLE actions (
actionid number(10),
userid number(10) DEFAULT '0' NOT NULL,
delay number(10) DEFAULT '0' NOT NULL,
subject varchar2(255) DEFAULT NULL,
message varchar2(2048) DEFAULT NULL,
nextcheck number(10) DEFAULT '0' NOT NULL,
recipient number(3) DEFAULT '0' NOT NULL,
maxrepeats number(10) DEFAULT '0' NOT NULL,
repeatdelay number(10) DEFAULT '600' NOT NULL,
source number(3) DEFAULT '0' NOT NULL,
actiontype number(3) DEFAULT '0' NOT NULL,
status number(3) DEFAULT '0' NOT NULL,
scripts varchar(2048) DEFAULT NULL,
CONSTRAINT actions_pk PRIMARY KEY (actionid)
);
create sequence actions_actionid
start with 20000
increment by 1
nomaxvalue;
create trigger actions_trigger
before insert on actions
for each row
begin
if (:new.actionid is null or :new.actionid = 0) then
select actions_actionid.nextval into :new.actionid from dual;
end if;
end;
/
--
-- Table structure for table 'conditions'
--
CREATE TABLE conditions (
conditionid number(10) NOT NULL,
actionid number(10) DEFAULT '0' NOT NULL,
conditiontype number(10) DEFAULT '0' NOT NULL,
operator number(3) DEFAULT '0' NOT NULL,
value varchar2(255) DEFAULT NULL,
CONSTRAINT conditions_pk PRIMARY KEY (conditionid)
);
CREATE INDEX conditions_actionid on conditions (actionid);
create sequence conditions_conditionid
start with 20000
increment by 1
nomaxvalue;
create trigger conditions_trigger
before insert on conditions
for each row
begin
if (:new.conditionid is null or :new.conditionid = 0) then
select conditions_conditionid.nextval into :new.conditionid from dual;
end if;
end;
/
--
--
-- Table structure for table 'alarms'
--
CREATE TABLE alarms (
alarmid number(10) NOT NULL,
triggerid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
value number(10) DEFAULT '0' NOT NULL,
acknowledged number(3) DEFAULT '0' NOT NULL,
CONSTRAINT alarms_pk PRIMARY KEY (alarmid)
);
CREATE INDEX alarms_triggeridclock on alarms (triggerid, clock);
CREATE INDEX alarms_clock on alarms (clock);
create sequence alarms_alarmid
start with 20000
increment by 1
nomaxvalue;
create trigger alarms_trigger
before insert on alarms
for each row
begin
if (:new.alarmid is null or :new.alarmid = 0) then
select alarms_alarmid.nextval into :new.alarmid from dual;
end if;
end;
/
--
-- Table structure for table 'functions'
--
CREATE TABLE functions (
functionid number(10) NOT NULL,
itemid number(10) DEFAULT '0' NOT NULL,
triggerid number(10) DEFAULT '0' NOT NULL,
lastvalue varchar2(255),
function varchar2(12) DEFAULT NULL,
parameter varchar2(255) DEFAULT '0' NOT NULL,
CONSTRAINT functions_pk PRIMARY KEY (functionid)
);
CREATE INDEX functions_triggerid on functions (triggerid);
CREATE INDEX functions_itemidfunctionparam on functions (itemid,function,parameter);
create sequence functions_functionid
start with 20000
increment by 1
nomaxvalue;
create trigger functions_trigger
before insert on functions
for each row
begin
if (:new.functionid is null or :new.functionid = 0) then
select functions_functionid.nextval into :new.functionid from dual;
end if;
end;
/
--
-- Table structure for table 'history_uint'
--
CREATE TABLE history_uint (
itemid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
value number(20) DEFAULT '0' NOT NULL
);
CREATE INDEX history_uint_itemidclock on history_uint (itemid, clock);
--
-- Table structure for table 'history_str'
--
CREATE TABLE history_str (
itemid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
value varchar2(255) DEFAULT NULL
);
CREATE INDEX history_str_itemidclock on history_str (itemid, clock);
--
-- Table structure for table 'hosts'
--
CREATE TABLE hosts (
hostid number(10) NOT NULL,
host varchar2(64) DEFAULT NULL,
useip number(3) DEFAULT '1' NOT NULL,
ip varchar2(15) DEFAULT NULL,
port number(10) DEFAULT '0' NOT NULL,
status number(10) DEFAULT '0' NOT NULL,
-- If status=UNREACHABLE, host will not be checked until this time
disable_until number(10) DEFAULT '0' NOT NULL,
error varchar2(128) DEFAULT NULL,
available number(10) DEFAULT '0' NOT NULL,
errors_from number(10) DEFAULT '0' NOT NULL,
templateid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT hosts_pk PRIMARY KEY (hostid)
);
CREATE UNIQUE INDEX hosts_host on hosts (host);
CREATE INDEX hosts_status on hosts (status);
create sequence hosts_hostid
start with 20000
increment by 1
nomaxvalue;
create trigger hosts_trigger
before insert on hosts
for each row
begin
if (:new.hostid is null or :new.hostid = 0) then
select hosts_hostid.nextval into :new.hostid from dual;
end if;
end;
/
--
-- Table structure for table 'items'
--
CREATE TABLE items (
itemid number(10) NOT NULL,
type number(10) DEFAULT '0' NOT NULL,
snmp_community varchar2(64) DEFAULT NULL,
snmp_oid varchar2(255) DEFAULT NULL,
snmp_port number(10) DEFAULT '161' NOT NULL,
hostid number(10) NOT NULL,
description varchar2(255) DEFAULT NULL,
key_ varchar2(64) DEFAULT NULL,
delay number(10) DEFAULT '0' NOT NULL,
history number(10) DEFAULT '90' NOT NULL,
trends number(10) DEFAULT '365' NOT NULL,
-- lastdelete is not longer required
-- lastdelete number(10) DEFAULT '0' NOT NULL,
nextcheck number(10) DEFAULT '0' NOT NULL,
lastvalue varchar2(255) DEFAULT NULL,
lastclock number(10) DEFAULT NULL,
prevvalue varchar2(255) DEFAULT NULL,
status number(10) DEFAULT '0' NOT NULL,
value_type number(10) DEFAULT '0' NOT NULL,
trapper_hosts varchar2(255) DEFAULT NULL,
units varchar2(10) DEFAULT NULL,
multiplier number(10) DEFAULT '0' NOT NULL,
delta number(3) DEFAULT '0' NOT NULL,
prevorgvalue number(16,4) DEFAULT NULL,
snmpv3_securityname varchar2(64) DEFAULT NULL,
snmpv3_securitylevel number(3) DEFAULT '0' NOT NULL,
snmpv3_authpassphrase varchar2(64) DEFAULT NULL,
snmpv3_privpassphrase varchar2(64) DEFAULT NULL,
formula varchar2(255) DEFAULT '0' NOT NULL,
error varchar2(128) DEFAULT NULL,
lastlogsize number(10) DEFAULT '0' NOT NULL,
logtimefmt varchar2(64) DEFAULT NULL,
templateid number(10) DEFAULT '0' NOT NULL,
valuemapid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT items_pk PRIMARY KEY (itemid)
);
CREATE UNIQUE INDEX items_hostidkey on items (hostid, key_);
CREATE INDEX items_nextcheck on items (nextcheck);
CREATE INDEX items_status on items (status);
create sequence items_itemid
start with 20000
increment by 1
nomaxvalue;
create trigger items_trigger
before insert on items
for each row
begin
if (:new.itemid is null or :new.itemid = 0) then
select items_itemid.nextval into :new.itemid from dual;
end if;
end;
/
--
-- Table structure for table 'media'
--
CREATE TABLE media (
mediaid number(10) NOT NULL,
userid number(10) DEFAULT '0' NOT NULL,
mediatypeid number(10) DEFAULT '0' NOT NULL,
sendto varchar2(100) DEFAULT NULL,
active number(10) DEFAULT '0' NOT NULL,
severity number(10) DEFAULT '63' NOT NULL,
period varchar2(100) DEFAULT '1-7,00:00-23:59' NOT NULL,
CONSTRAINT media_pk PRIMARY KEY (mediaid)
);
CREATE INDEX media_userid on media (userid);
CREATE INDEX media_mediatypeid on media (mediatypeid);
create sequence media_mediaid
start with 20000
increment by 1
nomaxvalue;
create trigger media_trigger
before insert on media
for each row
begin
if (:new.mediaid is null or :new.mediaid = 0) then
select media_mediaid.nextval into :new.mediaid from dual;
end if;
end;
/
--
-- Table structure for table 'media'
--
CREATE TABLE media_type (
mediatypeid number(10) NOT NULL,
type number(10) DEFAULT '0' NOT NULL,
description varchar2(100) DEFAULT NULL,
smtp_server varchar2(255) DEFAULT NULL,
smtp_helo varchar2(255) DEFAULT NULL,
smtp_email varchar2(255) DEFAULT NULL,
exec_path varchar2(255) DEFAULT NULL,
CONSTRAINT media_type_pk PRIMARY KEY (mediatypeid)
);
create sequence media_type_mediatypeid
start with 20000
increment by 1
nomaxvalue;
create trigger media_type_trigger
before insert on media_type
for each row
begin
if (:new.mediatypeid is null or :new.mediatypeid = 0) then
select media_type_mediatypeid.nextval into :new.mediatypeid from dual;
end if;
end;
/
--
-- Table structure for table 'triggers'
--
CREATE TABLE triggers (
triggerid number(10) NOT NULL,
expression varchar2(255) DEFAULT NULL,
description varchar2(255) DEFAULT NULL,
url varchar2(255) DEFAULT NULL,
status number(10) DEFAULT '0' NOT NULL,
value number(10) DEFAULT '0' NOT NULL,
priority number(4) DEFAULT '0' NOT NULL,
lastchange number(10) DEFAULT '0' NOT NULL,
dep_level number(4) DEFAULT '0' NOT NULL,
comments varchar2(2048),
error varchar2(128) DEFAULT NULL,
templateid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT triggers_pk PRIMARY KEY (triggerid)
);
CREATE INDEX triggers_status on triggers (status);
CREATE INDEX triggers_value on triggers (value);
create sequence triggers_triggerid
start with 20000
increment by 1
nomaxvalue;
create trigger triggers_trigger
before insert on triggers
for each row
begin
if (:new.triggerid is null or :new.triggerid = 0) then
select triggers_triggerid.nextval into :new.triggerid from dual;
end if;
end;
/
--
-- Table structure for table 'trigger_depends'
--
CREATE TABLE trigger_depends (
triggerid_down number(10) DEFAULT '0' NOT NULL,
triggerid_up number(10) DEFAULT '0' NOT NULL,
CONSTRAINT triggers_depends_pk PRIMARY KEY (triggerid_down, triggerid_up)
);
CREATE INDEX triggers_depends_triggerid_up on trigger_depends (triggerid_up);
--
-- Table structure for table 'users'
--
CREATE TABLE users (
userid number(10) NOT NULL,
alias varchar2(100) DEFAULT NULL,
name varchar2(100) DEFAULT NULL,
surname varchar2(100) DEFAULT NULL,
passwd varchar2(32) DEFAULT NULL,
url varchar2(255) DEFAULT NULL,
autologout number(10) DEFAULT '900' NOT NULL,
lang varchar2(5) DEFAULT 'en_gb' NOT NULL,
refresh number(10) DEFAULT '30' NOT NULL,
CONSTRAINT users_pk PRIMARY KEY (userid)
);
CREATE UNIQUE INDEX users_alias on users (alias);
create sequence users_userid
start with 20000
increment by 1
nomaxvalue;
create trigger users_trigger
before insert on users
for each row
begin
if (:new.userid is null or :new.userid = 0) then
select users_userid.nextval into :new.userid from dual;
end if;
end;
/
--
-- Table structure for table 'audit'
--
CREATE TABLE auditlog (
auditid number(10),
userid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
action number(10) DEFAULT '0' NOT NULL,
resourcetype number(10) DEFAULT '0' NOT NULL,
details varchar2(128) DEFAULT '0' NOT NULL,
CONSTRAINT auditlog_pk PRIMARY KEY (auditid)
);
CREATE INDEX auditlog_useridclock on auditlog (userid,clock);
CREATE INDEX auditlog_clock on auditlog (clock);
create sequence auditlog_auditid
start with 20000
increment by 1
nomaxvalue;
create trigger auditlog_trigger
before insert on auditlog
for each row
begin
if (:new.auditid is null or :new.auditid = 0) then
select auditlog_auditid.nextval into :new.auditid from dual;
end if;
end;
/
--
-- Table structure for table 'sessions'
--
CREATE TABLE sessions (
sessionid varchar2(32) DEFAULT NULL,
userid number(10) DEFAULT '0' NOT NULL,
lastaccess number(10) DEFAULT '0' NOT NULL,
CONSTRAINT sessions_pk PRIMARY KEY (sessionid)
);
--
-- Table structure for table 'rights'
--
CREATE TABLE rights (
rightid number(10) NOT NULL,
userid number(10) DEFAULT '0' NOT NULL,
name varchar2(255) DEFAULT NULL,
permission varchar2(1) DEFAULT NULL,
id number(10),
CONSTRAINT rights_pk PRIMARY KEY (rightid)
);
CREATE INDEX rights_userid on rights (userid);
create sequence rights_rightid
start with 20000
increment by 1
nomaxvalue;
create trigger rights_trigger
before insert on rights
for each row
begin
if (:new.rightid is null or :new.rightid = 0) then
select rights_rightid.nextval into :new.rightid from dual;
end if;
end;
/
--
-- Table structure for table 'service_alarms'
--
CREATE TABLE service_alarms (
servicealarmid number(10) NOT NULL,
serviceid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
value number(10) DEFAULT '0' NOT NULL,
CONSTRAINT service_alarms_pk PRIMARY KEY (servicealarmid)
);
CREATE INDEX service_alarms_serviceidclock on service_alarms (serviceid,clock);
CREATE INDEX service_alarms_clock on service_alarms (clock);
create sequence service_alarms_servicealarmid
start with 20000
increment by 1
nomaxvalue;
create trigger service_alarms_trigger
before insert on service_alarms
for each row
begin
if (:new.servicealarmid is null or :new.servicealarmid = 0) then
select service_alarms_servicealarmid.nextval into :new.servicealarmid from dual;
end if;
end;
/
--
-- Table structure for table 'profiles'
--
CREATE TABLE profiles (
profileid number(10) NOT NULL,
userid number(10) DEFAULT '0' NOT NULL,
idx varchar2(64) DEFAULT NULL,
value varchar2(255) DEFAULT NULL,
valuetype number(10) DEFAULT 0 NOT NULL,
CONSTRAINT profiles_pk PRIMARY KEY (profileid)
);
CREATE UNIQUE INDEX profiles_userididx on profiles (userid, idx);
create sequence profiles_profileid
start with 20000
increment by 1
nomaxvalue;
create trigger profiles_trigger
before insert on profiles
for each row
begin
if (:new.profileid is null or :new.profileid = 0) then
select profiles_profileid.nextval into :new.profileid from dual;
end if;
end;
/
--
-- Table structure for table 'screens'
--
CREATE TABLE screens (
screenid number(10) NOT NULL,
name varchar2(255) DEFAULT 'Screen' NOT NULL,
hsize number(10) DEFAULT '1' NOT NULL,
vsize number(10) DEFAULT '1' NOT NULL,
CONSTRAINT screens_pk PRIMARY KEY (screenid)
);
create sequence screens_screenid
start with 20000
increment by 1
nomaxvalue;
create trigger screens_trigger
before insert on screens
for each row
begin
if (:new.screenid is null or :new.screenid = 0) then
select screens_screenid.nextval into :new.screenid from dual;
end if;
end;
/
--
-- Table structure for table 'screens_items'
--
CREATE TABLE screens_items (
screenitemid number(10) NOT NULL,
screenid number(10) DEFAULT '0' NOT NULL,
resourcetype number(10) DEFAULT '0' NOT NULL,
resourceid number(10) DEFAULT '0' NOT NULL,
width number(10) DEFAULT '320' NOT NULL,
height number(10) DEFAULT '200' NOT NULL,
x number(10) DEFAULT '0' NOT NULL,
y number(10) DEFAULT '0' NOT NULL,
colspan number(10) DEFAULT '0' NOT NULL,
rowspan number(10) DEFAULT '0' NOT NULL,
elements number(10) DEFAULT '25' NOT NULL,
valign number(3) DEFAULT '0' NOT NULL,
halign number(3) DEFAULT '0' NOT NULL,
style number(10) DEFAULT '0' NOT NULL,
url varchar2(255) DEFAULT NULL,
CONSTRAINT screens_items_pk PRIMARY KEY (screenitemid)
);
create sequence screens_items_screenid
start with 20000
increment by 1
nomaxvalue;
create trigger screens_items_trigger
before insert on screens_items
for each row
begin
if (:new.screenitemid is null or :new.screenitemid = 0) then
select screens_items_screenid.nextval into :new.screenitemid from dual;
end if;
end;
/
--
-- Table structure for table 'usrgrp'
--
CREATE TABLE usrgrp (
usrgrpid number(10) NOT NULL,
name varchar2(64) DEFAULT NULL,
CONSTRAINT usrgrp_pk PRIMARY KEY (usrgrpid)
);
CREATE UNIQUE INDEX usrgrp_name on usrgrp (name);
create sequence usrgrp_usrgrpid
start with 20000
increment by 1
nomaxvalue;
create trigger usrgrp_trigger
before insert on usrgrp
for each row
begin
if (:new.usrgrpid is null or :new.usrgrpid = 0) then
select usrgrp_usrgrpid.nextval into :new.usrgrpid from dual;
end if;
end;
/
--
-- Table structure for table 'users_groups'
--
CREATE TABLE users_groups (
usrgrpid number(10) DEFAULT '0' NOT NULL,
userid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT users_groups_pk PRIMARY KEY (usrgrpid,userid)
);
--
-- Table structure for table 'trends'
--
CREATE TABLE trends (
itemid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
num number(5) DEFAULT '0' NOT NULL,
value_min number(16,4) DEFAULT '0.0000' NOT NULL,
value_avg number(16,4) DEFAULT '0.0000' NOT NULL,
value_max number(16,4) DEFAULT '0.0000' NOT NULL,
CONSTRAINT trends_pk PRIMARY KEY (itemid, clock)
);
--
-- Table structure for table 'images'
--
CREATE TABLE images (
imageid number(10) NOT NULL,
imagetype number(10) DEFAULT '0' NOT NULL,
name varchar2(64) DEFAULT '0' NOT NULL,
image BLOB,
CONSTRAINT images PRIMARY KEY (imageid)
);
CREATE UNIQUE INDEX images_imagetypename on images (imagetype, name);
create sequence images_imageid
start with 20000
increment by 1
nomaxvalue;
create trigger images_trigger
before insert on images
for each row
begin
if (:new.imageid is null or :new.imageid = 0) then
select images_imageid.nextval into :new.imageid from dual;
end if;
end;
/
--
-- Table structure for table 'hosts_templates'
--
CREATE TABLE hosts_templates (
hosttemplateid number(10) NOT NULL,
hostid number(10) DEFAULT '0' NOT NULL,
templateid number(10) DEFAULT '0' NOT NULL,
items number(3) DEFAULT '0' NOT NULL,
triggers number(3) DEFAULT '0' NOT NULL,
graphs number(3) DEFAULT '0' NOT NULL,
CONSTRAINT hosts_templates_pk PRIMARY KEY (hosttemplateid)
);
CREATE UNIQUE INDEX hosts_templates_id on hosts_templates (hostid, templateid);
create sequence hosts_templates_hosttemplateid
start with 20000
increment by 1
nomaxvalue;
create trigger hosts_templates_trigger
before insert on hosts_templates
for each row
begin
if (:new.hosttemplateid is null or :new.hosttemplateid = 0) then
select hosts_templates_hosttemplateid.nextval into :new.hosttemplateid from dual;
end if;
end;
/
--
-- Table structure for table 'history_log'
--
CREATE TABLE history_log (
id number(10) NOT NULL,
itemid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
timestamp number(10) DEFAULT '0' NOT NULL,
source varchar2(64) DEFAULT NULL,
severity number(10) DEFAULT '0' NOT NULL,
value varchar2(2048) DEFAULT NULL,
CONSTRAINT history_log_pk PRIMARY KEY (id)
);
CREATE INDEX history_log_itemidclock on history_log (itemid,clock);
create sequence history_log_id
start with 20000
increment by 1
nomaxvalue;
create trigger history_log_trigger
before insert on history_log
for each row
begin
if (:new.id is null or :new.id = 0) then
select history_log_id.nextval into :new.id from dual;
end if;
end;
/
--
-- Table structure for table 'hosts_profiles'
--
CREATE TABLE hosts_profiles (
hostid number(10) DEFAULT '0' NOT NULL,
devicetype varchar2(64) DEFAULT NULL,
name varchar2(64) DEFAULT NULL,
os varchar2(64) DEFAULT NULL,
serialno varchar2(64) DEFAULT NULL,
tag varchar2(64) DEFAULT NULL,
macaddress varchar2(64) DEFAULT NULL,
hardware varchar2(2048) DEFAULT NULL,
software varchar2(2048) DEFAULT NULL,
contact varchar2(2048) DEFAULT NULL,
location varchar2(2048) DEFAULT NULL,
notes varchar2(2048) DEFAULT NULL,
CONSTRAINT hosts_profiles_pk PRIMARY KEY (hostid)
);
--
-- Table structure for table 'autoreg'
--
CREATE TABLE autoreg (
id number(10) NOT NULL,
priority number(10) DEFAULT '0' NOT NULL,
pattern varchar2(255) DEFAULT NULL,
hostid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT autoreg_pk PRIMARY KEY (id)
);
create sequence autoreg_id
start with 20000
increment by 1
nomaxvalue;
create trigger autoreg_trigger
before insert on autoreg
for each row
begin
if (:new.id is null or :new.id = 0) then
select autoreg_id.nextval into :new.id from dual;
end if;
end;
/
--
-- Table structure for table 'valuemaps'
--
CREATE TABLE valuemaps (
valuemapid number(10) NOT NULL,
name varchar2(64) DEFAULT NULL,
CONSTRAINT valuemaps_pk PRIMARY KEY (valuemapid)
);
CREATE UNIQUE INDEX valuemaps_name on valuemaps (name);
create sequence valuemaps_valuemapid
start with 20000
increment by 1
nomaxvalue;
create trigger valuemaps_trigger
before insert on valuemaps
for each row
begin
if (:new.valuemapid is null or :new.valuemapid = 0) then
select valuemaps_valuemapid.nextval into :new.valuemapid from dual;
end if;
end;
/
--
-- Table structure for table 'mapping'
--
CREATE TABLE mappings (
mappingid number(10) NOT NULL,
valuemapid number(10) DEFAULT '0' NOT NULL,
value varchar2(64) DEFAULT NULL,
newvalue varchar2(64) DEFAULT NULL,
CONSTRAINT mappings_pk PRIMARY KEY (mappingid)
);
CREATE INDEX mappings_valuemapid on mappings (valuemapid);
create sequence mappings_mappingid
start with 20000
increment by 1
nomaxvalue;
create trigger mappings_trigger
before insert on mappings
for each row
begin
if (:new.mappingid is null or :new.mappingid = 0) then
select mappings_mappingid.nextval into :new.mappingid from dual;
end if;
end;
/
--
-- Table structure for table 'housekeeper'
--
CREATE TABLE housekeeper (
housekeeperid number(10) NOT NULL,
tablename varchar2(64) DEFAULT NULL,
field varchar2(64) DEFAULT NULL,
value number(10) DEFAULT '0' NOT NULL,
CONSTRAINT housekeeper_pk PRIMARY KEY (housekeeperid)
);
create sequence housekeeper_housekeeperid
start with 20000
increment by 1
nomaxvalue;
create trigger housekeeper_trigger
before insert on housekeeper
for each row
begin
if (:new.housekeeperid is null or :new.housekeeperid = 0) then
select housekeeper_housekeeperid.nextval into :new.housekeeperid from dual;
end if;
end;
/
--
-- Table structure for table 'acknowledges'
--
CREATE TABLE acknowledges (
acknowledgeid number(10) NOT NULL,
userid number(10) DEFAULT '0' NOT NULL,
alarmid number(10) DEFAULT '0' NOT NULL,
clock number(10) DEFAULT '0' NOT NULL,
message varchar2(255) DEFAULT NULL,
CONSTRAINT acknowledges_pk PRIMARY KEY (acknowledgeid)
);
CREATE INDEX acknowledges_userid on acknowledges (userid);
CREATE INDEX acknowledges_alarmid on acknowledges (alarmid);
CREATE INDEX acknowledges_clock on acknowledges (clock);
create sequence acknowledges_acknowledgeid
start with 20000
increment by 1
nomaxvalue;
create trigger acknowledges_trigger
before insert on acknowledges
for each row
begin
if (:new.acknowledgeid is null or :new.acknowledgeid = 0) then
select acknowledges_acknowledgeid.nextval into :new.acknowledgeid from dual;
end if;
end;
/
--
-- Table structure for table 'acknowledges'
--
-- Table structure for table 'applications'
--
CREATE TABLE applications (
applicationid number(10) NOT NULL,
hostid number(10) DEFAULT '0' NOT NULL,
name varchar2(255) DEFAULT NULL,
templateid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT applications_pk PRIMARY KEY (applicationid)
);
CREATE INDEX applications_hostid on applications (hostid);
CREATE INDEX applications_templateid on applications (templateid);
CREATE UNIQUE INDEX applications_hostidname on applications (hostid,name);
create sequence applications_applicationid
start with 20000
increment by 1
nomaxvalue;
create trigger applications_trigger
before insert on applications
for each row
begin
if (:new.applicationid is null or :new.applicationid = 0) then
select applications_applicationid.nextval into :new.applicationid from dual;
end if;
end;
/
--
-- Table structure for table 'items_applications'
--
CREATE TABLE items_applications (
applicationid number(10) DEFAULT '0' NOT NULL,
itemid number(10) DEFAULT '0' NOT NULL,
CONSTRAINT items_applications_pk PRIMARY KEY (applicationid,itemid)
);
--
-- Table structure for table 'help_items'
--
CREATE TABLE help_items (
itemtype number(10) DEFAULT '0' NOT NULL,
key_ varchar2(64) DEFAULT NULL,
description varchar2(255) DEFAULT NULL,
PRIMARY KEY (itemtype, key_)
);
|