gistfile1.txt

insert into bill_summary(uuid, recipient_id, bill_summary_import_id, utility_code, utility_bill_id, amount_due, binned_amount_due, statement_date, due_date, bill_amount, binned_bill_amount, start_date, end_date, autopay, first_name, last_name, business_name, email_address, active_ebill, created_at) values( uuid_to_bin('e2b40422-b900-11e5-0000-cafecafecafe'), NULL, 584, 'PGE', '0634001159511', 198.41, 10, '2015-12-10', '2016-01-03', 38.41, NULL, NULL, NULL, NULL, 'Ivan Sobolev', NULL, 'IVAN SOBOLEV', 'ivan.sobolev@opower.com', 1, now());

insert into bill_summary(uuid, recipient_id, bill_summary_import_id, utility_code, utility_bill_id, amount_due, binned_amount_due, statement_date, due_date, bill_amount, binned_bill_amount, start_date, end_date, autopay, first_name, last_name, business_name, email_address, active_ebill, created_at) values( uuid_to_bin('c939e7be-b917-11e5-0001-cafecafecafe'), NULL, 584, 'PGE', '0634001159512', 198.41, 10, '2015-12-10', '2016-01-03', 38.41, NULL, NULL, NULL, NULL, 'Ivan Sobolev', NULL, 'IVAN SOBOLEV', 'ivan.sobolev@opower.com', 1, now());

insert into customer_bill(bill_summary_id, utility_code, customer_uuid, utility_account_uuid, start_date, end_date) select id, 'PGE', uuid_to_bin('e2b40422-b900-11e5-9de9-820643f777d3'), uuid_to_bin('4ec1084e-6eab-11e4-9b4f-0025b500028f'), '2015-02-07', '2015-03-07' from  bill_summary where uuid=uuid_to_bin('e2b40422-b900-11e5-0000-cafecafecafe');

insert into customer_bill(bill_summary_id, utility_code, customer_uuid, utility_account_uuid, start_date, end_date) select id, 'PGE', uuid_to_bin('c939e7be-b917-11e5-9de9-820643f777d3'), uuid_to_bin('4ec1084e-6eab-11e4-9b4f-0025b500028f'), '2015-02-07', '2015-03-07' from  bill_summary where uuid=uuid_to_bin('c939e7be-b917-11e5-0001-cafecafecafe');