New source files added
[public/netxms.git] / sql / setup.in
CommitLineData
6c9e7d36
VK
1/*
2** Default configuration parameters
b51c8c91
AK
3**
4** ex: syntax=sql
6c9e7d36 5*/
c1142e46 6
333ece94
VK
7INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
8 VALUES ('DBFormatVersion',DB_FORMAT_VERSION,0,1);
70573ffe
VK
9INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
10 VALUES ('DBSyntax',DB_SYNTAX,0,1);
b4895bbe
VK
11INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
12 VALUES ('DBLockStatus','UNLOCKED',0,1);
13INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
14 VALUES ('DBLockInfo','',0,0);
b1c6ea4a
VK
15INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
16 VALUES ('ServerID','',0,1);
9587eba3
VK
17INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
18 VALUES ('EnableZoning','0',1,1);
333ece94
VK
19INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
20 VALUES ('SyncInterval','60',1,1);
21INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
22 VALUES ('NewNodePollingInterval','60',1,1);
23INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
24 VALUES ('DiscoveryPollingInterval','900',1,1);
25INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56d41577 26 VALUES ('StatusPollingInterval','60',1,1);
333ece94
VK
27INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
28 VALUES ('ConfigurationPollingInterval','3600',1,1);
66485623
VK
29INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
30 VALUES ('RoutingTableUpdateInterval','300',1,1);
333ece94 31INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
9587eba3 32 VALUES ('ResolveNodeNames','1',1,0);
333ece94
VK
33INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
34 VALUES ('NumberOfEventProcessors','1',1,1);
35INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
36 VALUES ('ClientListenerPort','4701',1,1);
37INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
38 VALUES ('NumberOfDataCollectors','10',1,1);
d39ca961
IK
39INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
40 VALUES ('NumberOfStatusPollers','10',1,1);
41INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
42 VALUES ('NumberOfConfigurationPollers','4',1,1);
bb0a5754
VK
43INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
44 VALUES ('NumberOfDiscoveryPollers','1',1,1);
66485623
VK
45INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
46 VALUES ('NumberOfRoutingTablePollers','5',1,1);
333ece94 47INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
cb7ec554 48#ifdef DB_MYSQL
963c030d 49 VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%ld (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null) TYPE=InnoDB',0,1);
cb7ec554 50#else
963c030d 51 VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%ld (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null)',0,1);
cb7ec554 52#endif
f2692e04 53INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
c13cb4a5 54 VALUES ('IDataIndexCreationCommand_0','CREATE INDEX idx_idata_%ld_item_id ON idata_%ld(item_id)',0,1);
dfd24edd 55#ifndef DB_MYSQL
52fe5aa2 56INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
c13cb4a5 57 VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%ld_timestamp ON idata_%ld(idata_timestamp)',0,1);
dfd24edd 58#endif
333ece94
VK
59INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
60 VALUES ('RunNetworkDiscovery','0',1,1);
61INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
62 VALUES ('EnableAdminInterface','1',1,1);
63INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
64 VALUES ('EnableAccessControl','1',1,0);
65INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
66 VALUES ('EnableEventsAccessControl','0',1,0);
67INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
b7be6692 68 VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds
333ece94
VK
69INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
70 VALUES ('HouseKeepingInterval','3600',1,1);
71INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
dfd24edd 72 VALUES ('DeleteEmptySubnets','0',1,1);
333ece94
VK
73INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
74 VALUES ('EnableSNMPTraps','1',1,1);
7cbe553e
VK
75INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
76 VALUES ('SMSDriver','<none>',1,1);
aa975b7e
VK
77INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
78 VALUES ('SMSDrvConfig','',1,1);
083abe62
VK
79INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
80 VALUES ('SMTPServer','localhost',1,0);
81INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
82 VALUES ('SMTPFromAddr','netxms@localhost',1,0);
751f4600
VK
83INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
84 VALUES ('AgentUpgradeWaitTime','600',1,0);
a9052846
VK
85INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
86 VALUES ('NumberOfUpgradeThreads','10',1,0);
dfd24edd
VK
87INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
88 VALUES ('KeepAliveInterval','60',1,1);
305800bf
VK
89INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
90 VALUES ('DefaultEncryptionPolicy','1',1,1);
91INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
92 VALUES ('AllowedCiphers','15',1,1);
dc17b82b
VK
93INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
94 VALUES ('EnableMultipleDBConnections','1',1,1);
95INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
96 VALUES ('NumberOfDatabaseWriters','1',1,1);
91693a61
VK
97INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
98 VALUES ('StatusCalculationAlgorithm','0',1,1);
7e7357e8
VK
99INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
100 VALUES ('IcmpPingSize','46',1,1);
77edf0b5 101INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
de6e949b 102 VALUES ('EnableSyslogDaemon','0',1,1);
77edf0b5
VK
103INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
104 VALUES ('SyslogListenPort','514',1,1);
cb53cb15
VK
105INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
106 VALUES ('SyslogRetentionTime','5184000',1,0);
9b057805
VK
107
108
6c9e7d36
VK
109/*
110** Default users
111*/
9b057805 112
fa3f5211 113INSERT INTO users (id,name,password,system_access,flags,full_name,description)
057f9dfb
VK
114 VALUES (0,'admin',
115 '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
00c79c7b 116 65535,8,'','Built-in system administrator account'
057f9dfb 117 );
fa3f5211 118INSERT INTO users (id,name,password,system_access,flags,full_name,description)
057f9dfb 119 VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty
00c79c7b 120 0,0,'','Default guest user'
057f9dfb
VK
121 );
122
123
124/*
125** Special "Everyone" user group
126*/
127
fa3f5211 128INSERT INTO user_groups (id,name,system_access,flags,description)
00c79c7b 129 VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group');
b6a77d6d
VK
130
131
3c468b80
VK
132/*
133** Default event groups
134*/
135
c6576857
VK
136#define ID_GROUP_1 -2147483647
137#define ID_GROUP_2 -2147483646
3c468b80 138
feea53fd 139INSERT INTO event_groups (id,name,description)
3c468b80 140 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
feea53fd 141INSERT INTO event_groups (id,name,description)
3c468b80
VK
142 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
143
c19b2871
VK
144INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
145INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
146INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
147INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
148INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
149INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
150INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
151
152INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
153INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
154INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
ef44d5ea
VK
155
156
157/*
158** Default container categories
159*/
160
161INSERT INTO container_categories (category,name,image_id,description)
162 VALUES (1,'Group',0,'Generic object group');
163INSERT INTO container_categories (category,name,image_id,description)
164 VALUES (2,'Location',0,'Geografic location');
165INSERT INTO container_categories (category,name,image_id,description)
166 VALUES (3,'Service',0,'Logical service');
5e918a37
VK
167
168
169/*
170** SNMP OID to node type mappings
171*/
172
173INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
174 VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0);