-- ABS-62188/ ABS-64373

-- SERVERCONFIGPARAMETERS TABLE --
CREATE TABLE SERVERCONFIGPARAMETERS
(
  ONLINELICENSE        VARCHAR2(1) DEFAULT 'N' NOT NULL
                       CONSTRAINT YN_VALIDATIONFIELD412 CHECK (ONLINELICENSE IN ('Y', 'N')),
  LICENSECHECKINTERVAL NUMBER DEFAULT 60 NOT NULL,
  SYSTEMUSER_ID        NUMBER NOT NULL,
  TIMESTAMP            DATE NOT NULL
)
;

COMMENT ON COLUMN SERVERCONFIGPARAMETERS.ONLINELICENSE
  IS 'For use the license from database or from file.';
COMMENT ON COLUMN SERVERCONFIGPARAMETERS.LICENSECHECKINTERVAL
  IS 'Number of seconds after the other application servers are syncronized on activation new license and clients receive notifcation. Only used with Online license.';
