--------------------------------------------------
-- PRM report
-- Created 20110712
--------------------------------------------------

INSERT INTO cehior_auth_reports 
  VALUES ('6', 'PRM', NULL, '1', 'SELECT * FROM prd_trace_view WHERE concat(system, '' / '', client) in ($System$) AND (date between date(''$Begin$'') and date(''$End$''))', NULL, NULL, '1');

INSERT INTO cehior_auth_reports_selections
  VALUES ('6', '1', 'System', NULL, 'select', 'yes', 'select concat(system, " / ", client) `option` from cehior_auth_system_descr order by gruppe, nummer');

INSERT INTO cehior_auth_reports_selections
  VALUES ('6', '2', 'Begin', NULL, 'date', NULL, NULL);

INSERT INTO cehior_auth_reports_selections
  VALUES ('6', '3', 'End', NULL, 'date', NULL, NULL);


