[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 ('DBLockPID','0',0,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('ServerID','',0,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EnableZoning','0',1,1);
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 ('DiscoveryPollingInterval','900',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusPollingInterval','60',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 ('RoutingTableUpdateInterval','300',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('ConditionPollingInterval','60',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('ResolveNodeNames','1',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)
	VALUES ('NumberOfStatusPollers','10',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfConfigurationPollers','4',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfDiscoveryPollers','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfRoutingTablePollers','5',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfConditionPollers','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 not null,idata_value varchar(255) not null) TYPE=InnoDB',0,1);
#else
	VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null)',0,1);
#endif
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('IDataIndexCreationCommand_0','CREATE INDEX idx_idata_%d_item_id ON idata_%d(item_id)',0,1);
#ifndef DB_MYSQL
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%d_timestamp ON idata_%d(idata_timestamp)',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','0',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 ('SMSDrvConfig','',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);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('AgentUpgradeWaitTime','600',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfUpgradeThreads','10',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('KeepAliveInterval','60',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DefaultEncryptionPolicy','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('AllowedCiphers','15',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EnableMultipleDBConnections','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('NumberOfDatabaseWriters','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('IcmpPingSize','46',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('EnableSyslogDaemon','0',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('SyslogListenPort','514',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('SyslogRetentionTime','5184000',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusCalculationAlgorithm','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusPropagationAlgorithm','1',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('FixedStatusValue','0',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusShift','0',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusTranslation','01020304',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusSingleThreshold','75',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('StatusThresholds','503C2814',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('CapabilityExpirationTime','604800',1,0);  // In seconds
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DefaultCommunityString','public',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DiscoveryFilter','none',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('LogAllSNMPTraps','0',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('DisableVacuum','0',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('LockTimeout','60000',1,1);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('RADIUSServer','localhost',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('RADIUSSecret','netxms',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('RADIUSPort','1645',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('RADIUSNumRetries','5',1,0);
INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	VALUES ('RADIUSTimeout','3',1,0);


/*
** Default admin user
*/

INSERT INTO users (id,name,password,system_access,flags,full_name,
                   description,grace_logins,auth_method,guid)
   VALUES (0,'admin',
           '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
           65535,8,'','Built-in system administrator account',5,0,
           '00000000-0000-0000-0000-000000000000'
          );


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

INSERT INTO user_groups (id,name,system_access,flags,description,guid)
   VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group',
           '00000000-0000-0000-0000-000000000000'
          );


/*
** 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);
INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
   VALUES (1,'.1.3.6.1.4.1.3224.1.*',NODE_TYPE_NETSCREEN,0);
Commit	Line	Data
6c9e7d36 VK	1	/*
6c9e7d36 VK	2	** Default configuration parameters
b51c8c91 AK	3	**
b51c8c91 AK	4	** ex: syntax=sql
6c9e7d36	5	*/
c1142e46	6
333ece94 VK	7	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
333ece94 VK	8	VALUES ('DBFormatVersion',DB_FORMAT_VERSION,0,1);
70573ffe VK	9	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
70573ffe VK	10	VALUES ('DBSyntax',DB_SYNTAX,0,1);
b4895bbe VK	11	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	12	VALUES ('DBLockStatus','UNLOCKED',0,1);
	13	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	14	VALUES ('DBLockInfo','',0,0);
48ad2f8d VK	15	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
48ad2f8d VK	16	VALUES ('DBLockPID','0',0,0);
b1c6ea4a VK	17	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
b1c6ea4a VK	18	VALUES ('ServerID','',0,1);
9587eba3 VK	19	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
9587eba3 VK	20	VALUES ('EnableZoning','0',1,1);
333ece94 VK	21	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
333ece94 VK	22	VALUES ('SyncInterval','60',1,1);
333ece94 VK	23	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	24	VALUES ('DiscoveryPollingInterval','900',1,1);
	25	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56d41577	26	VALUES ('StatusPollingInterval','60',1,1);
333ece94 VK	27	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
333ece94 VK	28	VALUES ('ConfigurationPollingInterval','3600',1,1);
66485623 VK	29	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
66485623 VK	30	VALUES ('RoutingTableUpdateInterval','300',1,1);
a717e56a VK	31	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
a717e56a VK	32	VALUES ('ConditionPollingInterval','60',1,1);
333ece94	33	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
9587eba3	34	VALUES ('ResolveNodeNames','1',1,0);
333ece94 VK	35	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	36	VALUES ('NumberOfEventProcessors','1',1,1);
	37	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	38	VALUES ('ClientListenerPort','4701',1,1);
	39	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	40	VALUES ('NumberOfDataCollectors','10',1,1);
d39ca961 IK	41	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	42	VALUES ('NumberOfStatusPollers','10',1,1);
	43	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	44	VALUES ('NumberOfConfigurationPollers','4',1,1);
bb0a5754 VK	45	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
bb0a5754 VK	46	VALUES ('NumberOfDiscoveryPollers','1',1,1);
66485623 VK	47	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
66485623 VK	48	VALUES ('NumberOfRoutingTablePollers','5',1,1);
a717e56a VK	49	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
a717e56a VK	50	VALUES ('NumberOfConditionPollers','10',1,1);
333ece94	51	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
cb7ec554	52	#ifdef DB_MYSQL
0212dc5a	53	VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null) TYPE=InnoDB',0,1);
cb7ec554	54	#else
0212dc5a	55	VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null)',0,1);
cb7ec554	56	#endif
f2692e04	57	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
0212dc5a	58	VALUES ('IDataIndexCreationCommand_0','CREATE INDEX idx_idata_%d_item_id ON idata_%d(item_id)',0,1);
dfd24edd	59	#ifndef DB_MYSQL
52fe5aa2	60	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
0212dc5a	61	VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%d_timestamp ON idata_%d(idata_timestamp)',0,1);
dfd24edd	62	#endif
333ece94 VK	63	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	64	VALUES ('RunNetworkDiscovery','0',1,1);
	65	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	66	VALUES ('EnableAdminInterface','1',1,1);
	67	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	68	VALUES ('EnableAccessControl','1',1,0);
	69	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	70	VALUES ('EnableEventsAccessControl','0',1,0);
	71	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
b7be6692	72	VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds
333ece94 VK	73	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	74	VALUES ('HouseKeepingInterval','3600',1,1);
	75	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
dfd24edd	76	VALUES ('DeleteEmptySubnets','0',1,1);
333ece94 VK	77	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
333ece94 VK	78	VALUES ('EnableSNMPTraps','1',1,1);
7cbe553e VK	79	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
7cbe553e VK	80	VALUES ('SMSDriver','<none>',1,1);
aa975b7e VK	81	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
aa975b7e VK	82	VALUES ('SMSDrvConfig','',1,1);
083abe62 VK	83	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	84	VALUES ('SMTPServer','localhost',1,0);
	85	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	86	VALUES ('SMTPFromAddr','netxms@localhost',1,0);
751f4600 VK	87	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
751f4600 VK	88	VALUES ('AgentUpgradeWaitTime','600',1,0);
a9052846 VK	89	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
a9052846 VK	90	VALUES ('NumberOfUpgradeThreads','10',1,0);
dfd24edd VK	91	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
dfd24edd VK	92	VALUES ('KeepAliveInterval','60',1,1);
305800bf VK	93	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	94	VALUES ('DefaultEncryptionPolicy','1',1,1);
	95	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	96	VALUES ('AllowedCiphers','15',1,1);
dc17b82b VK	97	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	98	VALUES ('EnableMultipleDBConnections','1',1,1);
	99	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	100	VALUES ('NumberOfDatabaseWriters','1',1,1);
7e7357e8 VK	101	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
7e7357e8 VK	102	VALUES ('IcmpPingSize','46',1,1);
77edf0b5	103	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
de6e949b	104	VALUES ('EnableSyslogDaemon','0',1,1);
77edf0b5 VK	105	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
77edf0b5 VK	106	VALUES ('SyslogListenPort','514',1,1);
cb53cb15 VK	107	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
cb53cb15 VK	108	VALUES ('SyslogRetentionTime','5184000',1,0);
b6ce3970 VK	109	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	110	VALUES ('StatusCalculationAlgorithm','1',1,1);
	111	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	112	VALUES ('StatusPropagationAlgorithm','1',1,1);
	113	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	114	VALUES ('FixedStatusValue','0',1,1);
	115	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	116	VALUES ('StatusShift','0',1,1);
	117	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	118	VALUES ('StatusTranslation','01020304',1,1);
	119	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	120	VALUES ('StatusSingleThreshold','75',1,1);
	121	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	122	VALUES ('StatusThresholds','503C2814',1,1);
8d8cd3f8 VK	123	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
8d8cd3f8 VK	124	VALUES ('CapabilityExpirationTime','604800',1,0); // In seconds
269e3aca VK	125	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	126	VALUES ('DefaultCommunityString','public',1,0);
	127	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	128	VALUES ('DiscoveryFilter','none',1,0);
56b32598 VK	129	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56b32598 VK	130	VALUES ('LogAllSNMPTraps','0',1,1);
5d8a7f11 VK	131	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
5d8a7f11 VK	132	VALUES ('DisableVacuum','0',1,0);
7db87985 VK	133	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
7db87985 VK	134	VALUES ('LockTimeout','60000',1,1);
f3d12ff6 VK	135	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	136	VALUES ('RADIUSServer','localhost',1,0);
	137	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	138	VALUES ('RADIUSSecret','netxms',1,0);
	139	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	140	VALUES ('RADIUSPort','1645',1,0);
	141	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	142	VALUES ('RADIUSNumRetries','5',1,0);
	143	INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
	144	VALUES ('RADIUSTimeout','3',1,0);
9b057805 VK	145
9b057805 VK	146
6c9e7d36	147	/*
383b42a1	148	** Default admin user
6c9e7d36	149	*/
9b057805	150
383b42a1 VK	151	INSERT INTO users (id,name,password,system_access,flags,full_name,
383b42a1 VK	152	description,grace_logins,auth_method,guid)
057f9dfb VK	153	VALUES (0,'admin',
057f9dfb VK	154	'3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
383b42a1 VK	155	65535,8,'','Built-in system administrator account',5,0,
383b42a1 VK	156	'00000000-0000-0000-0000-000000000000'
057f9dfb VK	157	);
	158
	159
	160	/*
	161	** Special "Everyone" user group
	162	*/
	163
95b6a1b6	164	INSERT INTO user_groups (id,name,system_access,flags,description,guid)
383b42a1 VK	165	VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group',
	166	'00000000-0000-0000-0000-000000000000'
	167	);
b6a77d6d VK	168
b6a77d6d VK	169
3c468b80 VK	170	/*
	171	** Default event groups
	172	*/
	173
c6576857 VK	174	#define ID_GROUP_1 -2147483647
c6576857 VK	175	#define ID_GROUP_2 -2147483646
3c468b80	176
feea53fd	177	INSERT INTO event_groups (id,name,description)
3c468b80	178	VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
feea53fd	179	INSERT INTO event_groups (id,name,description)
3c468b80 VK	180	VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
3c468b80 VK	181
c19b2871 VK	182	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
	183	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
	184	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
	185	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
	186	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
	187	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
	188	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
	189
	190	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
	191	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
	192	INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
ef44d5ea VK	193
	194
	195	/*
	196	** Default container categories
	197	*/
	198
	199	INSERT INTO container_categories (category,name,image_id,description)
	200	VALUES (1,'Group',0,'Generic object group');
	201	INSERT INTO container_categories (category,name,image_id,description)
	202	VALUES (2,'Location',0,'Geografic location');
	203	INSERT INTO container_categories (category,name,image_id,description)
	204	VALUES (3,'Service',0,'Logical service');
5e918a37 VK	205
	206
	207	/*
	208	** SNMP OID to node type mappings
	209	*/
	210
	211	INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
	212	VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0);
8cbff47b VK	213	INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
8cbff47b VK	214	VALUES (1,'.1.3.6.1.4.1.3224.1.*',NODE_TYPE_NETSCREEN,0);