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