sql/setup.sql

   1 --
   2 -- Default configuration parameters
   3 --
   4
   5 INSERT INTO config (name,value) VALUES ('SyncInterval','60');
   6 INSERT INTO config (name,value) VALUES ('NewNodePollingInterval','60');
   7 INSERT INTO config (name,value) VALUES ('DiscoveryPollingInterval','900');
   8 INSERT INTO config (name,value) VALUES ('StatusPollingInterval','30');
   9 INSERT INTO config (name,value) VALUES ('ConfigurationPollingInterval','3600');
  10 INSERT INTO config (name,value) VALUES ('ResolveNodeNames','0');
  11 INSERT INTO config (name,value) VALUES ('NumberOfEventProcessors','1');
  12 INSERT INTO config (name,value) VALUES ('ClientListenerPort','4701');
  13 INSERT INTO config (name,value) VALUES ('NumberOfDataCollectors','10');
  14 INSERT INTO config (name,value) VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,timestamp integer,value varchar(255))');
  15 INSERT INTO config (name,value) VALUES ('RunNetworkDiscovery','1');
  16 INSERT INTO config (name,value) VALUES ('EnableAdminInterface','1');
  17 INSERT INTO config (name,value) VALUES ('EnableAccessControl','1');
  18 INSERT INTO config (name,value) VALUES ('EnableEventsAccessControl','0');
  19
  20
  21 --
  22 -- Default users
  23 --
  24
  25 INSERT INTO users (id,name,password) VALUES (0,'admin','');
  26 INSERT INTO users (id,name,password) VALUES (1,'guest','');