-- insert proxy employee 1 insert into ch17_employee values (1, 'johndoe', 'Proxyfirstname','Proxylastname'); insert into ch17_employee values (2, UPPER('ch17saleman'), 'Cany','deVito'); insert into ch17_employee values (3, UPPER('ch17prodman'), 'Jack','McNeck'); insert into ch17_employee values (4, UPPER('ch17fineman'), 'Anne','Peggas'); insert into ch17_employee values (5, UPPER('ch17CEO'), 'Mili','Vanili'); -- insert customer insert into ch17_customer values (1,'Hydroplant', 'SI12332112', 'SI280019400644750000', 'MBSIKRXXX', 'A'); insert into ch17_customer values (2,'Termoplant', 'SI32112332', 'SI820091046033571230', 'MBSIYPXXX', 'B'); -- insert doc class insert into ch17_doc_class values (1, 'Tech/Manuf. specification', 'MANUFACTURING'); insert into ch17_doc_class values (2, 'Financial terms', 'FINANCIAL'); insert into ch17_doc_class values (3, 'Business terms', 'BUSINESS'); insert into ch17_doc_class values (4, 'Other supplementary documentation', 'OTHER'); -- insert inquiry insert into ch17_inquiry values (1,1,209800,5, SYSDATE+60, 'Heat exchanger', 2,SYSDATE, 'N.A.',null,null,1,SYSDATE,'N.A.',null,null,1,SYSDATE,'N.A.',null,null,null,1,SYSDATE); insert into ch17_inquiry values (2,2,800209,15,SYSDATE+120, 'Conveyor system', 2,SYSDATE, 'N.A.',null,null,1,SYSDATE,'N.A.',null,null,1,SYSDATE,'N.A.',null,null,null,1,SYSDATE); -- insert inquiry_doc insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (1,1,EMPTY_BLOB(), 'application/pdf','Customer_1_tech_spec.pdf', SYSDATE, 'fileshare/dir/cust/1/inq/1'); insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (2,1,EMPTY_BLOB(), 'application/pdf','Customer_2_tech_spec.pdf', SYSDATE, 'fileshare/dir/cust/2/inq/2'); insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (1,2,EMPTY_BLOB(), 'application/pdf','Customer_1_fin_spec.pdf', SYSDATE, 'fileshare/dir/cust/1/inq/1'); insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (2,2,EMPTY_BLOB(), 'application/pdf','Customer_2_fin_spec.pdf', SYSDATE, 'fileshare/dir/cust/2/inq/2'); insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (1,3,EMPTY_BLOB(), 'application/pdf', 'Customer_1_busines_spec.pdf',SYSDATE,'fileshare/dir/cust/1/inq/1'); insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (2,3,EMPTY_BLOB(), 'application/pdf', 'Customer_2_busines_spec.pdf', SYSDATE, 'fileshare/dir/cust/2/inq/2'); insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (1,4,EMPTY_BLOB(), 'application/pdf', 'Customer_1_supp_spec.pdf', SYSDATE, 'fileshare/dir/cust/1/inq/1'); insert into ch17_inquiry_doc (inquiry_id,doc_class_id,contblb,fmime, fname,fdcr, frefer) values (2,4,EMPTY_BLOB(), 'application/pdf', 'Customer_2_supp_spec.pdf', SYSDATE, 'fileshare/dir/cust/2/inq/2');