New parameter added
[public/netxms.git] / doc / db_format_change.txt
1 *************
2 * 35 ==> 36 *
3 *************
4
5 - Added new column proxy_node to "nodes" table:
6 ALTER TABLE nodes ADD proxy_node integer not null;
7 UPDATE nodes SET proxy_node=0;
8 - Added new column matching_oid to "object_tools" table:
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);
14
15
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
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);
56 - Added configuration variable SMSDrvConfig
57 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
58 VALUES ('SMSDrvConfig','',1,1);
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)
74 VALUES ('EnableSyslogDaemon','0',1,1);
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);
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;
87
88
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:
105 INSERT 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');
107 INSERT 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);
109 INSERT 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
112 INSERT 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');
114 INSERT 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
117 INSERT 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');
119 INSERT 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);
121 INSERT 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);
123 INSERT 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);
125 INSERT 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
128 INSERT 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');
130 INSERT 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
133 INSERT 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');
135 INSERT 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
138 INSERT 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');
140 INSERT 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);
142 INSERT 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);
144 INSERT 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
147 INSERT 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');
149 INSERT 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);
151 INSERT 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);
153 INSERT 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);
155 INSERT 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
158 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (5,-2147483648);
159 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (6,-2147483648);
160 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (7,-2147483648);
161 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (8,-2147483648);
162 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (9,-2147483648);
163 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (10,-2147483648);
164 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (11,-2147483648);
165 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (12,-2147483648);
166
167
168 *************
169 * 31 ==> 32 *
170 *************
171
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;
190 - Predefined tools added:
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);
203
204
205 *************
206 * 30 ==> 31 *
207 *************
208
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;
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>');