Initial support for object deletion by operator
[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
31115ff9
VK
7INSERT INTO config (var_name,var_value) VALUES ('DBFormatVersion',DB_FORMAT_VERSION);
8INSERT INTO config (var_name,var_value) VALUES ('SyncInterval','60');
9INSERT INTO config (var_name,var_value) VALUES ('NewNodePollingInterval','60');
10INSERT INTO config (var_name,var_value) VALUES ('DiscoveryPollingInterval','900');
11INSERT INTO config (var_name,var_value) VALUES ('StatusPollingInterval','30');
12INSERT INTO config (var_name,var_value) VALUES ('ConfigurationPollingInterval','3600');
13INSERT INTO config (var_name,var_value) VALUES ('ResolveNodeNames','0');
14INSERT INTO config (var_name,var_value) VALUES ('NumberOfEventProcessors','1');
15INSERT INTO config (var_name,var_value) VALUES ('ClientListenerPort','4701');
16INSERT INTO config (var_name,var_value) VALUES ('NumberOfDataCollectors','10');
17INSERT INTO config (var_name,var_value) VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer,idata_value varchar(255))');
18INSERT INTO config (var_name,var_value) VALUES ('RunNetworkDiscovery','1');
19INSERT INTO config (var_name,var_value) VALUES ('EnableAdminInterface','1');
20INSERT INTO config (var_name,var_value) VALUES ('EnableAccessControl','1');
21INSERT INTO config (var_name,var_value) VALUES ('EnableEventsAccessControl','0');
22INSERT INTO config (var_name,var_value) VALUES ('EventLogRetentionTime','5184000'); // Default retention time is 60 days == 5184000 seconds
23INSERT INTO config (var_name,var_value) VALUES ('HouseKeepingInterval','3600');
24INSERT INTO config (var_name,var_value) VALUES ('DeleteEmptySubnets','1');
25INSERT INTO config (var_name,var_value) VALUES ('EnableSNMPTraps','1');
9b057805
VK
26
27
6c9e7d36
VK
28/*
29** Default users
30*/
9b057805 31
00c79c7b 32INSERT INTO users (id,name,password,access,flags,full_name,description)
057f9dfb
VK
33 VALUES (0,'admin',
34 '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
00c79c7b 35 65535,8,'','Built-in system administrator account'
057f9dfb 36 );
00c79c7b 37INSERT INTO users (id,name,password,access,flags,full_name,description)
057f9dfb 38 VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty
00c79c7b 39 0,0,'','Default guest user'
057f9dfb
VK
40 );
41
42
43/*
44** Special "Everyone" user group
45*/
46
00c79c7b
VK
47INSERT INTO user_groups (id,name,access,flags,description)
48 VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group');
b6a77d6d
VK
49
50
51/*
52** Component lock table
53*/
54
55INSERT INTO locks (component_id,component_name,lock_status,owner_info)
3c468b80 56 VALUES (CID_NETXMS_INSTANCE,'NetXMS Server Instance',-1,'');
b6a77d6d 57INSERT INTO locks (component_id,component_name,lock_status,owner_info)
3c468b80 58 VALUES (CID_EPP,'Event Processing Policy',-1,'');
b6a77d6d 59INSERT INTO locks (component_id,component_name,lock_status,owner_info)
1b3e2cfe 60 VALUES (CID_USER_DB,'User Database',-1,'');
3c468b80 61INSERT INTO locks (component_id,component_name,lock_status,owner_info)
9fd5ec9e 62 VALUES (CID_EVENT_DB,'Event Configuration Database',-1,'');
c9363772
VK
63INSERT INTO locks (component_id,component_name,lock_status,owner_info)
64 VALUES (CID_ACTION_DB,'Action Configuration Database',-1,'');
3c468b80
VK
65
66
67/*
68** Default event groups
69*/
70
c6576857
VK
71#define ID_GROUP_1 -2147483647
72#define ID_GROUP_2 -2147483646
3c468b80 73
feea53fd 74INSERT INTO event_groups (id,name,description)
3c468b80 75 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
feea53fd 76INSERT INTO event_groups (id,name,description)
3c468b80
VK
77 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
78
feea53fd
VK
79INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
80INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
81INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
82INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
83INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
84INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
85INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
3c468b80 86
feea53fd
VK
87INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
88INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
89INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
ef44d5ea
VK
90
91
92/*
93** Default container categories
94*/
95
96INSERT INTO container_categories (category,name,image_id,description)
97 VALUES (1,'Group',0,'Generic object group');
98INSERT INTO container_categories (category,name,image_id,description)
99 VALUES (2,'Location',0,'Geografic location');
100INSERT INTO container_categories (category,name,image_id,description)
101 VALUES (3,'Service',0,'Logical service');