ALTER SESSION SET CURRENT_SCHEMA = "&1";

DELETE FROM SOLACE_TOPIC;

INSERT INTO SOLACE_TOPIC ST
  (ST.SOLACE_TOPIC_IN,
   ST.PRIORITY,
   ST.PROCESSING_NUMBER,
   ST.SOLACE_TOPIC_OUT)
VALUES
  ('stg/operations/account/assigned',
   1,
   1,
   'stg/operations/account/created/v1');
INSERT INTO SOLACE_TOPIC ST
  (ST.SOLACE_TOPIC_IN,
   ST.PRIORITY,
   ST.PROCESSING_NUMBER,
   ST.SOLACE_TOPIC_OUT)
VALUES
  ('stg/data/account/goldened',
   3, 
   2, 
   null);
INSERT INTO SOLACE_TOPIC ST
  (ST.SOLACE_TOPIC_IN,
   ST.PRIORITY,
   ST.PROCESSING_NUMBER,
   ST.SOLACE_TOPIC_OUT)
VALUES
  ('stg/operations/account/merging/notified', 
  2, 
  3, 
  'stg/operations/account/merging/ack/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 6, 6, 'stg/traceability/cage/scan/packed/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 7, 7, 'stg/traceability/cage/scan/returned/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 8, 8, 'stg/traceability/cage/management/created/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 9, 9, 'stg/traceability/cage/management/updated/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values ('stg/data/cage/goldened', 4, 4, null);
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values ('stg/data/cage/moved', 5, 5, null);
COMMIT;
/
exit;
