User database functions added

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

/*
** Default configuration parameters
*/

INSERT INTO config (name,value) VALUES ('SyncInterval','60');
INSERT INTO config (name,value) VALUES ('NewNodePollingInterval','60');
INSERT INTO config (name,value) VALUES ('DiscoveryPollingInterval','900');
INSERT INTO config (name,value) VALUES ('StatusPollingInterval','30');
INSERT INTO config (name,value) VALUES ('ConfigurationPollingInterval','3600');
INSERT INTO config (name,value) VALUES ('ResolveNodeNames','0');
INSERT INTO config (name,value) VALUES ('NumberOfEventProcessors','1');
INSERT INTO config (name,value) VALUES ('ClientListenerPort','4701');
INSERT INTO config (name,value) VALUES ('NumberOfDataCollectors','10');
INSERT INTO config (name,value) VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,timestamp integer,value varchar(255))');
INSERT INTO config (name,value) VALUES ('RunNetworkDiscovery','1');
INSERT INTO config (name,value) VALUES ('EnableAdminInterface','1');
INSERT INTO config (name,value) VALUES ('EnableAccessControl','1');
INSERT INTO config (name,value) VALUES ('EnableEventsAccessControl','0');
INSERT INTO config (name,value) VALUES ('EventLogRetentionTime','5184000'); // Default retention time is 60 days == 5184000 seconds
INSERT INTO config (name,value) VALUES ('HouseKeepingInterval','3600');
INSERT INTO config (name,value) VALUES ('DeleteEmptySubnets','1');
INSERT INTO config (name,value) VALUES ('EnableSNMPTraps','1');


/*
** Default users
*/

INSERT INTO users (id,name,password)
   VALUES (0,'admin','3A445C0072CD69D9030CC6644020E5C4576051B1');  // Default password: netxms
INSERT INTO users (id,name,password)
   VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709');  // Default password is empty


/*
** Component lock table
*/

INSERT INTO locks (component_id,component_name,lock_status,owner_info)
   VALUES (CID_NETXMS_INSTANCE,'NetXMS Server Instance',-1,'');
INSERT INTO locks (component_id,component_name,lock_status,owner_info)
   VALUES (CID_EPP,'Event Processing Policy',-1,'');
INSERT INTO locks (component_id,component_name,lock_status,owner_info)
   VALUES (CID_USER_MGMT,'User Management',-1,'');
INSERT INTO locks (component_id,component_name,lock_status,owner_info)
   VALUES (CID_EVENT_DB,'Event Configuration Database',-1,'');


/*
** 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_id) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);

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