"Last Values" view added

[public/netxms.git] / sql / setup.in

/*
** Default configuration parameters
**
** ex: syntax=sql
*/

INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DBFormatVersion',DB_FORMAT_VERSION,0,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DBSyntax',DB_SYNTAX,0,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DBLockStatus','UNLOCKED',0,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DBLockInfo','',0,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('SyncInterval','60',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NewNodePollingInterval','60',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DiscoveryPollingInterval','900',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusPollingInterval','30',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('ConfigurationPollingInterval','3600',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('ResolveNodeNames','0',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfEventProcessors','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('ClientListenerPort','4701',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfDataCollectors','10',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
#ifdef DB_MYSQL
	VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer,idata_value varchar(255)) TYPE=InnoDB',0,1);
#else
	VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer,idata_value varchar(255))',0,1);
#endif
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('RunNetworkDiscovery','0',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EnableAdminInterface','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EnableAccessControl','1',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EnableEventsAccessControl','0',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('HouseKeepingInterval','3600',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DeleteEmptySubnets','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EnableSNMPTraps','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('SMSDriver','<none>',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('SMTPServer','localhost',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('SMTPFromAddr','netxms@localhost',1,0);


/*
** Default users
*/

INSERT INTO users (id,name,password,access,flags,full_name,description)
   VALUES (0,'admin',
           '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
           65535,8,'','Built-in system administrator account'
          );
INSERT INTO users (id,name,password,access,flags,full_name,description)
   VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty
           0,0,'','Default guest user'
          );


/*
** Special "Everyone" user group
*/

INSERT INTO user_groups (id,name,access,flags,description)
   VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group');


/*
** Default event groups
*/

#define ID_GROUP_1 -2147483647
#define ID_GROUP_2 -2147483646

INSERT INTO event_groups (id,name,description) 
   VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
INSERT INTO event_groups (id,name,description) 
   VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');

INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);

INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);


/*
** Default container categories
*/

INSERT INTO container_categories (category,name,image_id,description)
   VALUES (1,'Group',0,'Generic object group');
INSERT INTO container_categories (category,name,image_id,description)
   VALUES (2,'Location',0,'Geografic location');
INSERT INTO container_categories (category,name,image_id,description)
   VALUES (3,'Service',0,'Logical service');


/*
** SNMP OID to node type mappings
*/

INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
   VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0);