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
  ('operations/account/assigned',
   1,
   1,
   'operations/account/created/v1');
INSERT INTO SOLACE_TOPIC ST
  (ST.SOLACE_TOPIC_IN,
   ST.PRIORITY,
   ST.PROCESSING_NUMBER,
   ST.SOLACE_TOPIC_OUT)
VALUES
  ('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
  ('operations/account/merging/notified', 
  2, 
  3, 
  'operations/account/merging/ack/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 6, 6, 'operations/traceability/cage/scan/packed/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 7, 7, 'operations/traceability/cage/scan/returned/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 8, 8, 'operations/traceability/cage/management/created/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 9, 9, 'operations/traceability/cage/management/updated/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values ('operations/data/cage/goldened', 4, 4, null);
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values ('operations/data/cage/moved', 5, 5, null);
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 1, 10, 'traceability/tag/scan/created/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 1, 11, 'traceability/tag/scan/updated/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 1, 12, 'traceability/tag/scan/packed/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 1, 13, 'traceability/tag/scan/returned/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 1, 14, 'traceability/tag/scan/inventoried/v1');
insert into SOLACE_TOPIC (solace_topic_in, priority, processing_number, solace_topic_out)
values (null, 1, 15, 'traceability/tag/scan/discarded/v1');
COMMIT;
/
exit;
