 
 -- Configuration for appender - logger.
 INSERT INTO REFERENCES (LOGGER_ID, APPENDER_REF_ID)
-  VALUES (PREVIOUS VALUE FOR LOGGER_ID_SEQ, 1);
-
+  VALUES (0, 1);
+


-- Root logger.
INSERT INTO CONF_LOGGERS (LOGGER_ID, NAME, PARENT_ID, LEVEL_ID)
  VALUES (NEXT VALUE FOR LOGGER_ID_SEQ, 'ROOT', NULL, 3);

-- Root logger in effective, it cannot be deleted after.
INSERT INTO CONF_LOGGERS_EFFECTIVE (LOGGER_ID, LEVEL_ID, HIERARCHY)
  VALUES (PREVIOUS VALUE FOR LOGGER_ID_SEQ, 3,
  CHAR(PREVIOUS VALUE FOR LOGGER_ID_SEQ));

-- Basic appenders.
INSERT INTO APPENDERS (APPENDER_ID, NAME)

CREATE OR REPLACE PUBLIC ALIAS LOGS FOR TABLE LOGS;

COMMENT ON PUBLIC ALIAS LOGS IS 'log4db2 logs';

-- Global configuration.
-- checkHierarchy: Checks the logger hierarchy.
