/*
 | Job Scheduler Reporting Inteface sample mapping data for PostgreSQL
 | SOS GmbH, 2015-01-19, andreas.pueschel@sos-berlin.com
*/

/* Report Mappings */
DELETE FROM REPORTING_MAP_CAUSES;
/* standard causes created by executions */
INSERT INTO REPORTING_MAP_CAUSES ("ID", "CAUSE", "MAPPED_CAUSE", "CREATED", "MODIFIED") VALUES (NEXTVAL('REPORTING_SEQ_RMC'), 'order',             'order',             CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO REPORTING_MAP_CAUSES ("ID", "CAUSE", "MAPPED_CAUSE", "CREATED", "MODIFIED") VALUES (NEXTVAL('REPORTING_SEQ_RMC'), 'min_tasks',         'min_tasks',         CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO REPORTING_MAP_CAUSES ("ID", "CAUSE", "MAPPED_CAUSE", "CREATED", "MODIFIED") VALUES (NEXTVAL('REPORTING_SEQ_RMC'), 'delay_after_error', 'delay_after_error', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO REPORTING_MAP_CAUSES ("ID", "CAUSE", "MAPPED_CAUSE", "CREATED", "MODIFIED") VALUES (NEXTVAL('REPORTING_SEQ_RMC'), 'period_repeat',     'start_repeat',      CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO REPORTING_MAP_CAUSES ("ID", "CAUSE", "MAPPED_CAUSE", "CREATED", "MODIFIED") VALUES (NEXTVAL('REPORTING_SEQ_RMC'), 'period_single',     'start_single',      CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO REPORTING_MAP_CAUSES ("ID", "CAUSE", "MAPPED_CAUSE", "CREATED", "MODIFIED") VALUES (NEXTVAL('REPORTING_SEQ_RMC'), 'queue_at',          'start_manual',      CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
/* standard causes created by inventory */
INSERT INTO REPORTING_MAP_CAUSES ("ID", "CAUSE", "MAPPED_CAUSE", "CREATED", "MODIFIED") VALUES (NEXTVAL('REPORTING_SEQ_RMC'), 'file_trigger',      'file_trigger',      CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

COMMIT;
