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