[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 ('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 ('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)
#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 users
*/

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


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