--select * from test_master

SET search_path TO  transactional;
INSERT INTO transactional.test_master (client_id,function_id,test_name,test_type,test_description,created_by,create_timestamp) VALUES 
(20,1,'Field Performance','Field','Field Performance Test', current_user,now())
,(20,1,'Drawbar Performance','Drawbar','Drawbar Performance Test', current_user,now())
,(20,1,'PTO Performance','PTO','PTO Performance Test', current_user,now())
,(20,1,'In House Performance','In House','In House Performance Test', current_user , now())
,(20,1,'Budni Performance','Budni','Budni Performance Test', current_user,now())
;

--select * from test_lab_location_master tllm

INSERT INTO transactional.test_lab_location_master (client_id,function_id,location_name,soil_type,created_by,create_timestamp) VALUES 
(20,1,'Jetsar',NULL,current_user,now())
,(20,1,'Shivpuri',NULL,current_user,now())
,(20,1,'Akola',NULL,current_user,now())
,(20,1,'Sindhnoor',NULL,current_user,now())
,(20,1,'Tindivanam',NULL,current_user,now())
,(20,1,'Kumbakonam',NULL,current_user,now())
,(20,1,'Tadepalligudem',NULL,current_user,now())
,(20,1,'Punjab',NULL,current_user,now())
,(20,1,'Other',NULL,current_user,now())
,(20,1,'Suratgarh (Jetsar)',NULL,current_user,now())
;
INSERT INTO transactional.test_lab_location_master (client_id,function_id,location_name,soil_type,created_by,create_timestamp) VALUES 
(20,1,'Sardargarh (Jetsar)',NULL,current_user,now())
,(20,1,'Budni',NULL,current_user,now())
,(20,1,'MRV Test Track',NULL,current_user,now())
;