New parameter added
[public/netxms.git] / doc / db_format_change.txt
CommitLineData
c8686da4
VK
1*************
2* 35 ==> 36 *
3*************
4
5- Added new column proxy_node to "nodes" table:
8d8cd3f8
VK
6 ALTER TABLE nodes ADD proxy_node integer not null;
7 UPDATE nodes SET proxy_node=0;
1b282e44 8- Added new column matching_oid to "object_tools" table:
8d8cd3f8
VK
9 ALTER TABLE object_tools ADD matching_oid varchar(255) not null;
10 UPDATE object_tools SET matching_oid='#00';
11- New configuration parameters added:
12 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
13 VALUES ('CapabilityExpirationTime','604800',1,0);
c8686da4
VK
14
15
b6ce3970
VK
16*************
17* 34 ==> 35 *
18*************
19
20- Table object_properties modified:
21 Column status_alg deleted
22 New columns added:
23 status_calc_alg integer not null,
24 status_prop_alg integer not null,
25 status_prop_alg integer not null,
26 status_fixed_val integer not null,
27 status_shift integer not null,
28 status_translation varchar(8) not null,
29 status_single_threshold integer not null,
30 status_thresholds varchar(8) not null
31- Configuration parameter should be re-created:
32 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
33 VALUES ('StatusCalculationAlgorithm','1',1,1);
34- New configuration parameters added:
35 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
36 VALUES ('StatusPropagationAlgorithm','1',1,1);
37 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
38 VALUES ('FixedStatusValue','0',1,1);
39 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
40 VALUES ('StatusShift','0',1,1);
41 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
42 VALUES ('StatusTranslation','01020304',1,1);
43 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
44 VALUES ('StatusSingleThreshold','75',1,1);
45 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
46 VALUES ('StatusThresholds','503C2814',1,1);
47
48
7e7357e8
VK
49*************
50* 33 ==> 34 *
51*************
52
53- Added configuration variable IcmpPingSize
54 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
55 VALUES ('IcmpPingSize','46',1,1);
aa975b7e
VK
56- Added configuration variable SMSDrvConfig
57 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
58 VALUES ('SMSDrvConfig','',1,1);
cb53cb15
VK
59- Added table for storing syslog messages
60 CREATE TABLE syslog
61 (
62 msg_id SQL_BIGINT not null,
63 msg_timestamp integer not null,
64 facility integer not null,
65 severity integer not null,
66 source_object_id integer not null,
67 hostname varchar(127) not null,
68 msg_tag varchar(32) not null,
69 msg_text SQL_TEXT not null,
70 PRIMARY KEY(msg_id)
71 ) TABLE_TYPE;
72- New syslog-related parameters added:
73 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
e08c79a8 74 VALUES ('EnableSyslogDaemon','0',1,1);
cb53cb15
VK
75 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
76 VALUES ('SyslogListenPort','514',1,1);
77 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
78 VALUES ('SyslogRetentionTime','5184000',1,0);
b9ce1c9d
VK
79- New field adv_schedule of type integer added to table items. Existing items
80 should have this field set to 0.
81- New table for advanced DCI schedules
82 CREATE TABLE dci_schedules
83 (
84 item_id integer not null,
85 schedule varchar(255) not null
86 ) TABLE_TYPE;
7e7357e8
VK
87
88
526e6c8a
VK
89*************
90* 32 ==> 33 *
91*************
92
93- Added table object_tools_table_columns
94 CREATE TABLE object_tools_table_columns
95 (
96 tool_id integer not null,
97 col_number integer not null,
98 col_name varchar(255),
99 col_oid varchar(255),
100 col_format integer,
101 col_substr integer,
102 PRIMARY KEY(tool_id,col_number)
103 ) TABLE_TYPE;
104- Predefined tools added:
36e1ba03
VK
105INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
106 VALUES (5,'&Info->&Switch forwarding database (FDB)',TOOL_TYPE_TABLE_SNMP,'Forwarding database',0,'Show switch forwarding database');
107INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
108 VALUES (5,0,'MAC Address','.1.3.6.1.2.1.17.4.3.1.1',CFMT_MAC_ADDR,0);
109INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
110 VALUES (5,1,'Port','.1.3.6.1.2.1.17.4.3.1.2',CFMT_INTEGER,0);
111
112INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
113 VALUES (6,'&Connect->Open &web browser',TOOL_TYPE_URL,'http://%OBJECT_IP_ADDR%',0,'Open embedded web browser to node');
114INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
115 VALUES (7,'&Connect->Open &web browser (HTTPS)',TOOL_TYPE_URL,'https://%OBJECT_IP_ADDR%',0,'Open embedded web browser to node using HTTPS');
116
117INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
118 VALUES (8,'&Info->&Agent->&Subagent list',TOOL_TYPE_TABLE_AGENT,'Subagent List#7FAgent.SubAgentList#7F^(.*) (.*) (.*) (.*)',0,'Show list of loaded subagents');
119INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
120 VALUES (8,0,'Name','',CFMT_STRING,1);
121INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
122 VALUES (8,1,'Version','',CFMT_STRING,2);
123INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
124 VALUES (8,2,'File','',CFMT_STRING,4);
125INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
126 VALUES (8,3,'Module handle','',CFMT_STRING,3);
127
128INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
129 VALUES (9,'&Info->&Agent->Supported &parameters',TOOL_TYPE_TABLE_AGENT,'Supported parameters#7FAgent.SupportedParameters#7F^(.*)',0,'Show list of parameters supported by agent');
130INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
131 VALUES (9,0,'Parameter','',CFMT_STRING,1);
132
133INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
134 VALUES (10,'&Info->&Agent->Supported &enums',TOOL_TYPE_TABLE_AGENT,'Supported enums#7FAgent.SupportedEnums#7F^(.*)',0,'Show list of enums supported by agent');
135INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
136 VALUES (10,0,'Parameter','',CFMT_STRING,1);
137
138INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
139 VALUES (11,'&Info->&Agent->Supported &actions',TOOL_TYPE_TABLE_AGENT,'Supported actions#7FAgent.ActionList#7F^(.*) (.*) "(.*)".*',0,'Show list of actions supported by agent');
140INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
141 VALUES (11,0,'Name','',CFMT_STRING,1);
142INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
143 VALUES (11,1,'Type','',CFMT_STRING,2);
144INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
145 VALUES (11,2,'Data','',CFMT_STRING,3);
146
147INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
148 VALUES (12,'&Info->&Agent->Configured &ICMP targets',TOOL_TYPE_TABLE_AGENT,'Configured ICMP targets#7FICMP.TargetList#7F^(.*) (.*) (.*) (.*)',0,'Show list of actions supported by agent');
149INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
150 VALUES (12,0,'IP Address','',CFMT_STRING,1);
151INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
152 VALUES (12,1,'Name','',CFMT_STRING,4);
153INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
154 VALUES (12,2,'Last RTT','',CFMT_STRING,2);
155INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
156 VALUES (12,4,'Average RTT','',CFMT_STRING,3);
157
158INSERT INTO object_tools_acl (tool_id,user_id) VALUES (5,-2147483648);
159INSERT INTO object_tools_acl (tool_id,user_id) VALUES (6,-2147483648);
160INSERT INTO object_tools_acl (tool_id,user_id) VALUES (7,-2147483648);
161INSERT INTO object_tools_acl (tool_id,user_id) VALUES (8,-2147483648);
162INSERT INTO object_tools_acl (tool_id,user_id) VALUES (9,-2147483648);
163INSERT INTO object_tools_acl (tool_id,user_id) VALUES (10,-2147483648);
164INSERT INTO object_tools_acl (tool_id,user_id) VALUES (11,-2147483648);
165INSERT INTO object_tools_acl (tool_id,user_id) VALUES (12,-2147483648);
526e6c8a
VK
166
167
168*************
169* 31 ==> 32 *
170*************
50972227 171
38416c70
VK
172- Added table object_tools:
173 CREATE TABLE object_tools
174 (
175 tool_id integer not null,
176 tool_name varchar(255) not null,
177 tool_type integer not null,
178 tool_data SQL_TEXT,
179 description varchar(255),
180 flags integer not null,
181 PRIMARY KEY(tool_id)
182 ) TABLE_TYPE;
183- Added table object_tools_acl:
184 CREATE TABLE object_tools_acl
185 (
186 tool_id integer not null,
187 user_id integer not null,
188 PRIMARY KEY(tool_id,user_id)
189 ) TABLE_TYPE;
50972227 190- Predefined tools added:
38416c70
VK
191 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
192 VALUES (1,'&Shutdown system',TOOL_TYPE_ACTION,'System.Shutdown',0,'Shutdown target node via NetXMS agent');
193 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
194 VALUES (2,'&Restart system',TOOL_TYPE_ACTION,'System.Restart',0,'Restart target node via NetXMS agent');
195 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
196 VALUES (3,'&Wakeup node',TOOL_TYPE_INTERNAL,'wakeup',0,'Wakeup node using Wake-On-LAN magic packet');
197 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
198 VALUES (4,'Restart &agent',TOOL_TYPE_ACTION,'Agent.Restart',0,'Restart NetXMS agent on target node');
199 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (1,-2147483648);
200 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (2,-2147483648);
201 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (3,-2147483648);
202 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (4,-2147483648);
50972227
VK
203
204
526e6c8a
VK
205*************
206* 30 ==> 31 *
207*************
1a7c67a9 208
1a7c67a9
VK
209- Added configuration parameter NumberOfRoutingTablePollers
210- Added configuration parameter RoutingTableUpdateInterval
211- Added table vpn_connectors:
212 CREATE TABLE vpn_connectors
213 (
214 id integer not null,
215 node_id integer not null,
216 peer_gateway integer not null,
217 PRIMARY KEY(id)
218 ) TABLE_TYPE;
219- Added table vpn_connector_networks:
220 CREATE TABLE vpn_connector_networks
221 (
222 vpn_id integer not null,
223 network_type integer not null, // 0 == local, 1 == remote
224 ip_addr varchar(15),
225 ip_netmask varchar(15),
226 PRIMARY KEY(vpn_id,ip_addr)
227 ) TABLE_TYPE;
d0c8be78
VK
228- New images added:
229 INSERT INTO default_images (object_class,image_id)
230 VALUES (12, IMG_VPN_CONNECTOR);
231 INSERT INTO images (image_id,name,file_name_png,file_hash_png,file_name_ico,file_hash_ico)
232 VALUES (IMG_VPN_CONNECTOR,'Obj.VPNConnector','vpnc.png','<invalid_hash>',
233 'vpnc.ico','<invalid_hash>');