Minor changes
[public/netxms.git] / sql / setup.in
1 /*
2 ** Default configuration parameters
3 */
4
5 INSERT INTO config (name,value) VALUES ('SyncInterval','60');
6 INSERT INTO config (name,value) VALUES ('NewNodePollingInterval','60');
7 INSERT INTO config (name,value) VALUES ('DiscoveryPollingInterval','900');
8 INSERT INTO config (name,value) VALUES ('StatusPollingInterval','30');
9 INSERT INTO config (name,value) VALUES ('ConfigurationPollingInterval','3600');
10 INSERT INTO config (name,value) VALUES ('ResolveNodeNames','0');
11 INSERT INTO config (name,value) VALUES ('NumberOfEventProcessors','1');
12 INSERT INTO config (name,value) VALUES ('ClientListenerPort','4701');
13 INSERT INTO config (name,value) VALUES ('NumberOfDataCollectors','10');
14 INSERT INTO config (name,value) VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,timestamp integer,value varchar(255))');
15 INSERT INTO config (name,value) VALUES ('RunNetworkDiscovery','1');
16 INSERT INTO config (name,value) VALUES ('EnableAdminInterface','1');
17 INSERT INTO config (name,value) VALUES ('EnableAccessControl','1');
18 INSERT INTO config (name,value) VALUES ('EnableEventsAccessControl','0');
19 INSERT INTO config (name,value) VALUES ('EventLogRetentionTime','5184000'); // Default retention time is 60 days == 5184000 seconds
20 INSERT INTO config (name,value) VALUES ('HouseKeepingInterval','3600');
21
22
23 /*
24 ** Default users
25 */
26
27 INSERT INTO users (id,name,password)
28 VALUES (0,'admin','3A445C0072CD69D9030CC6644020E5C4576051B1'); // Default password: netxms
29 INSERT INTO users (id,name,password)
30 VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709'); // Default password is empty
31
32
33 /*
34 ** Component lock table
35 */
36
37 INSERT INTO locks (component_id,component_name,lock_status,owner_info)
38 VALUES (CID_NETXMS_INSTANCE,'NetXMS Server Instance',-1,'');
39 INSERT INTO locks (component_id,component_name,lock_status,owner_info)
40 VALUES (CID_EPP,'Event Processing Policy',-1,'');
41 INSERT INTO locks (component_id,component_name,lock_status,owner_info)
42 VALUES (CID_USER_MGMT,'User Management',-1,'');
43 INSERT INTO locks (component_id,component_name,lock_status,owner_info)
44 VALUES (CID_EVENT_DB,'Event Configuration Database',-1,'');
45
46
47 /*
48 ** Default event groups
49 */
50
51 #define ID_GROUP_1 -2147483647
52 #define ID_GROUP_2 -2147483646
53
54 INSERT INTO EventGroups (id,name,description)
55 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
56 INSERT INTO EventGroups (id,name,description)
57 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
58
59 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
60 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
61 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
62 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
63 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
64 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
65 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
66
67 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
68 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
69 INSERT INTO EventGroupMembers (group_id,event_id) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);