/*
 * 
INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('7', 'OML^O33^OML_O33','1.3.6.1.4.12559.11.1.1.136',1,3);
INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('8', 'ORL^O34^ORL_O34','1.3.6.1.4.12559.11.1.1.134',2,3);

INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('9', 'ACK^ALL^ACK','1.3.6.1.4.12559.11.1.1.22',1,1);

*/

DELETE FROM app_configuration WHERE variable = 'lip_specimen_oid';
ALTER table gs_contextual_information drop path;
ALTER table specimen drop specimen_id;

TRUNCATE TABLE lip_patient CASCADE;
TRUNCATE TABLE obr CASCADE;
TRUNCATE TABLE orc CASCADE;
TRUNCATE TABLE specimen CASCADE;
TRUNCATE TABLE lip_patient_identifier CASCADE;

INSERT INTO "app_configuration" (id, variable, value) VALUES ('94', 'lip_specimen_placer_oid', '1.3.6.1.4.1.12559.11.1.2.2.6.1.5');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('95', 'lip_specimen_filler_oid', '1.3.6.1.4.1.12559.11.1.2.2.6.1.6');

INSERT INTO "tf_transaction" (id, name, keyword) VALUES ('3', 'Labels and Containers Delivered', 'LAB-63');

INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('7', 'OML^O33^OML_O33','1.3.6.1.4.12559.11.1.1.171',1,3);
INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('8', 'ORL^O34^ORL_O34','1.3.6.1.4.12559.11.1.1.172',2,3);



/*SELECT CONCAT((SELECT CAST(id AS CHAR) FROM specimen),"&LBL LIP Simulator&1.3.6.1.4.1.12559.11.1.2.2.6.1.5&ISO");
*/
