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
  16
  17 --
  18 -- Default users
  19 --
  20
  21 INSERT INTO users (id,name,password) VALUES (0,'admin','');
  22 INSERT INTO users (id,name,password) VALUES (1,'guest','');