INSERT INTO `district` (`id`, `district`, `created_by`) VALUES('1', 'NY',1);

INSERT INTO `region` (`id`, `district_id`, `region`, `created_by`) VALUES('1', '1', 'Island',1);

INSERT INTO `address` (`id`,`address_line_1`, `city`, `state`, `district_id`, `country`, `created_by`) VALUES('1', '1 Wall Street', 'New York', 'NY', '1', 'USA',1);
INSERT INTO `address` (`id`,`address_line_1`, `city`, `state`, `district_id`, `country`, `created_by`) VALUES('2','45 Main Street', 'Long Island', 'NY', '1', 'USA',1);

INSERT INTO `company_type` (`id`, `type`, `created_by`) VALUES('1', 'Private Ltd',1);
INSERT INTO `company_type` (`id`, `type`, `created_by`) VALUES('2', 'Public Ltd',1);
INSERT INTO `company_type` (`id`, `type`, `created_by`) VALUES('3', 'Government',1);
INSERT INTO `company_type` (`id`, `type`, `created_by`) VALUES('4', 'Non Profit',1);
INSERT INTO `company_type` (`id`, `type`, `created_by`) VALUES('5', 'Sole Trader',1);

INSERT INTO `payment_method` (`id`, `payment_method`, `created_by`) VALUES('1', 'Visa',1);
INSERT INTO `payment_method` (`id`, `payment_method`, `created_by`) VALUES('2', 'Mastercard',1);
INSERT INTO `payment_method` (`id`, `payment_method`, `created_by`) VALUES('3', 'Paypal',1);
INSERT INTO `payment_method` (`id`, `payment_method`, `created_by`) VALUES('4', 'Cash',1);

INSERT INTO `make` (`id`, `name`, `created_by`) VALUES('1', 'Honda',1);
INSERT INTO `make` (`id`, `name`, `created_by`) VALUES('2', 'Toyota',1);
INSERT INTO `make` (`id`, `name`, `created_by`) VALUES('3', 'BMW',1);

INSERT INTO `model` (`id`, `name`, `make_id`, `created_by`) VALUES('1', 'Camry', '1',1);
INSERT INTO `model` (`id`, `name`, `make_id`, `created_by`) VALUES('2', 'CRV', '2',1);
INSERT INTO `model` (`id`, `name`, `make_id`, `created_by`) VALUES('3', '3 Series', '3',1);

INSERT INTO `document_type` (`id`, `type`, `created_by`) VALUES('1', 'Customer Identity',1);
INSERT INTO `document_type` (`id`, `type`, `created_by`) VALUES('2', 'Approval Document',1);

INSERT INTO `frequency_type` (`id`, `frequency`, `created_by`) VALUES('1', 'Monthly',1);
INSERT INTO `frequency_type` (`id`, `frequency`, `created_by`) VALUES('2', 'Quarterly',1);
INSERT INTO `frequency_type` (`id`, `frequency`, `created_by`) VALUES('3', 'Yearly',1);

INSERT INTO `classification_type` (`id`, `classification`, `created_by`) VALUES('1', 'Private',1);
INSERT INTO `classification_type` (`id`, `classification`, `created_by`) VALUES('2', 'Public',1);
INSERT INTO `classification_type` (`id`, `classification`, `created_by`) VALUES('3', 'Government',1);

INSERT INTO `service` (`id`, `name`, `description`, `created_by`) VALUES('1', 'Title Registration', '',1);
INSERT INTO `service` (`id`, `name`, `created_by`) VALUES('2', 'Tax',1);
INSERT INTO `service` (`id`, `name`, `created_by`) VALUES('3', 'Title Transfer',1);

INSERT INTO `vehicle_color` (`id`, `color`, `created_by`) VALUES('1', 'RED',1);
INSERT INTO `vehicle_color` (`id`, `color`, `created_by`) VALUES('2', 'GREEN',1);

INSERT INTO `fuel_type` (`id`, `fuel_type`, `created_by`) VALUES('1', 'PETROL',1);
INSERT INTO `fuel_type` (`id`, `fuel_type`, `created_by`) VALUES('2', 'DIESEL',1);

INSERT INTO `vehicle_type` (`id`, `vehicle_type`, `created_by`) VALUES('1', 'SEDAN',1);
INSERT INTO `vehicle_type` (`id`, `vehicle_type`, `created_by`) VALUES('2', 'TRUCK',1);


INSERT INTO `sub_category` (`id`, `sub_category`, `created_by`) VALUES('1', 'HP1',1);
INSERT INTO `sub_category` (`id`, `sub_category`, `created_by`) VALUES('2', 'HP2',1);
INSERT INTO `sub_category` (`id`, `sub_category`, `created_by`) VALUES('3', 'HP3',1);

INSERT INTO `workflow` (`name`, `container_id`, `definition_id`, `version`, `created_by`) VALUES('Registration Workflow', 'Vehicle', 'Registration', '1.0',1);
INSERT INTO `workflow` (`name`, `container_id`, `definition_id`, `version`, `created_by`) VALUES('Tax Workflow', 'Vehicle', 'Tax', '1.0',1);
INSERT INTO `workflow` (`name`, `container_id`, `definition_id`, `version`, `created_by`) VALUES('Ownership Transfer Workflow', 'Vehicle', 'Transfer', '1.0',1);

INSERT INTO `service_workflow` (`workflow_id`, `service_id`, `created_by`) VALUES('1', '1',1);
INSERT INTO `service_workflow` (`workflow_id`, `service_id`, `created_by`) VALUES('2', '2',1);
INSERT INTO `service_workflow` (`workflow_id`, `service_id`, `created_by`) VALUES('3', '3',1);

INSERT INTO `party` (`id`,`party_type`, `email`, `phone_number_1`, `address_id`, `created_by`) VALUES('1', 'company', 'contact@abc.com', '123456789', '1',1);
INSERT INTO `party` (`id`,`party_type`, `email`, `phone_number_1`, `address_id`, `created_by`) VALUES('2', 'person', 'mike@person.com', '987654321', '2',1);

INSERT INTO `person` (`first_name`, `second_name`, `third_name`, `date_of_birth`, `gender`, `occupation`, `place_of_birth`, `height`, `weight`, `eye_color`, `hair_color`, `mother_first_name`, `mother_second_name`, `father_first_name`, `father_second_name`, `party_id`, `created_by`) VALUES('Sam', 'Browns', 'Jr', '1977-10-11', 'Male', 'Director', 'Mombasso', '173', '68', 'Black', 'Black', 'Mary', 'Swanson', 'Jacob', 'Maxwell', '1',1);

INSERT INTO `person` (`first_name`, `second_name`, `third_name`, `date_of_birth`, `gender`, `occupation`, `place_of_birth`, `height`, `weight`, `eye_color`, `hair_color`, `mother_first_name`, `mother_second_name`, `father_first_name`, `father_second_name`, `party_id`, `created_by`) VALUES('Robert', 'Frank', 'Sr', '1988-10-11', 'Male', 'Driver', 'LA', '180', '77', 'Blue', 'Black', 'Dorothy', 'Flank', 'Peter', 'Wasten', '2',1);

INSERT INTO `company` (`id`, `company_name`, `contact_party_id`, `company_type_id`, `registration_date`, `party_id`, `created_by`) VALUES('1', 'ABC Pty Ltd ', '1', '1', '2020-1-12', '1',1);

INSERT INTO `vehicle` (`id`, `odometer`, `vin`, `year`, `sub_category_id`, `smart_tag`, `vehicle_color_id`, `fuel_type_id`, `vehicle_type_id`, `model_id`, `created_by`) VALUES(1, '90000', 'JK18822', '2010', '1', 'xvg67', '1', '1', '1', '1',1);
INSERT INTO `vehicle` (`id`, `odometer`, `vin`, `year`, `sub_category_id`, `smart_tag`, `vehicle_color_id`, `fuel_type_id`, `vehicle_type_id`, `model_id`, `created_by`) VALUES(2, '9982', 'I1k908', '2019', '2', 'ui453', '2', '2', '2', '2',1);

INSERT INTO `party_vehicle` (`id`, `party_id`, `vehicle_id`, `purpose_type_id`, `created_by`) VALUES('1', '1', '1', '1',1);
INSERT INTO `party_vehicle` (`id`, `party_id`, `vehicle_id`, `purpose_type_id`, `created_by`) VALUES('2', '2', '2', '2',1);

INSERT INTO `party_vehicle_purchase` (`id`, `purchase_date`, `purchase_price`, `buyer_party_id`, `vehicle_id`, `created_by`) VALUES('1', '2020-10-10', '4000', '1', '1',1);
INSERT INTO `party_vehicle_purchase` (`id`, `purchase_date`, `sale_date`, `purchase_price`, `sale_price`, `buyer_party_id`, `vehicle_id`, `seller_party_id`, `created_by`) VALUES('2', '2021-1-1', '2021-2-1', '2000', '2500', '2', '1', '1',1);








