INSERT INTO `Doctor` (`DoctorId`, `ProfileId`, `AccountId`, `Qualifications`, `ServiceStatus`, `ServiceDescription`, `CreatedUser`, `CreatedDate`, `UpdatedUser`, `UpdatedDate`, `Active`, `PracticeId`, `DoctorPracticeId`, `EmailVisibility`)
VALUES
	(49, 336, 300, 'OD', NULL, NULL, 1, '2017-04-13 19:19:27', 1, '2017-04-13 19:19:27', 'Y', 1072, 48, 'N');

INSERT INTO `Colleague` (`collegueId`, `primaryDoctorId`, `ColleagueDocId`, `Operation`, `createdUser`, `createdDate`, `updatedUser`, `updatedDate`, `Active`, `operationPerformedBy`)
VALUES
	(3, 49, 50, 'ACCEPT', 1, '2017-04-18 14:14:13', '1', '2017-04-18 14:14:13', 'Y', 49),
	(10, 49, 57, 'ACCEPT', 1, '2017-08-15 18:41:46', '1', '2017-08-15 18:41:46', 'Y', 49);

INSERT INTO `Colleague` (`collegueId`, `primaryDoctorId`, `ColleagueDocId`, `Operation`, `createdUser`, `createdDate`, `updatedUser`, `updatedDate`, `Active`, `operationPerformedBy`)
VALUES
	(2, 46, 49, 'ACCEPT', 1, '2017-09-14 09:33:19', '1', '2017-09-14 09:33:19', 'Y', 46);

INSERT INTO `Clinics` (`ClinicId`, `clinicName`, `addressId`, `createdUser`, `createdDate`, `updatedUser`, `updatedDate`, `Active`, `ClinicType`, `OfficePhone`, `EmergencyPhone`, `AccountId`)
VALUES
	(29, 'Crossroads', 29, 1, '2017-04-13 19:15:34', 1, '2017-04-13 19:15:34', 'Y', 'Optometry', 9192338500, 9192338500, 299);


INSERT INTO `StaffDetails` (`StaffDetailsId`, `ProfileId`, `AccountId`, `Comments`, `Active`, `createdUser`, `createdDate`, `updatedUser`, `updatedDate`, `ClinicId`)
VALUES
	(6, 335, 299, NULL, 'Y', 1, '2017-04-13 19:15:34', NULL, NULL, 29),
	(7, 336, 300, NULL, 'Y', 1, '2017-04-13 19:16:50', NULL, NULL, 29),
	(8, 337, 301, NULL, 'Y', 1, '2017-04-13 19:19:09', NULL, NULL, 29),
	(9, 335, 302, NULL, 'Y', 1, '2017-04-13 19:19:57', 1, '2017-04-13 19:19:57', 29);


INSERT INTO `Patient` (`PatientId`, `ProfileId`, `AccountId`, `MrnNumber`, `MedicalDescription`, `CreatedUser`, `CreatedDate`, `UpdatedUser`, `UpdatedDate`, `Active`, `ClinicId`)
VALUES
	(120, 347, 317, '1234567', '', 1, '2017-04-19 14:12:56', 1, '2017-04-19 14:12:56', 'Y', 29);


INSERT INTO `DoctorPractice` (`DoctorPracticeId`, `createdUser`, `createdDate`, `updatedUser`, `updatedDate`, `DoctorId`, `ClinicId`, `Active`)
VALUES
	(48, 1, '2017-04-13 19:16:50', NULL, NULL, 49, 29, 'Y'),
	(49, 1, '2017-04-13 19:19:09', NULL, NULL, 50, 29, 'Y');

INSERT INTO `DoctorPracticePatientDetails` (`DocPracticePatientDetailsId`, `DocPracticeId`, `PatientId`, `CreatedUser`, `CreatedDate`, `UpdatedUser`, `UpdatedDate`, `Active`)
VALUES
	(9, 49, 120, 1, '2017-04-19 14:12:58', 1, '2017-04-19 14:12:58', 'Y');

INSERT INTO `PatientImageMap` (`PatientImageMapId`, `PatientId`, `DoctorPracticeId`, `ClinicId`, `Active`, `createdDate`, `createdUser`, `updatedDate`, `updatedUser`)
VALUES
	(44, 120, 49, 29, 'Y', '2017-04-19 14:13:19', 1, NULL, NULL);

INSERT INTO `PatientImage` (`PatientImageId`, `PatientImageMapId`, `Name`, `ImageName`, `Description`, `Location`, `CreatedDate`, `CreatedUser`, `UpdatedUser`, `UpdatedDate`, `Active`)
VALUES
	(214, 44, '1492629198cx.jpeg', 'images', '3+  PCO OS', '/data/BackendImages/29/120/1492629198cx.jpeg', '2017-04-19 14:13:19', 1, 1, '2017-08-24 13:10:56', 'Y');

INSERT INTO `ImageUploads` (`Id`, `DoctorPracticeId`, `ClinicId`, `Count`, `CreateDate`, `IsBilled`)
VALUES
	(14, 49, 29, 1, '2017-04-19 14:13:19', 'N');