INSERT INTO AGE_UNIT_DICT (SERIAL_NO, UNIT_CODE, AGE_UNIT_NAME, IS_DEFAULT) VALUES (1, 'Y', 'Year', '1');
INSERT INTO AGE_UNIT_DICT (SERIAL_NO, UNIT_CODE, AGE_UNIT_NAME, IS_DEFAULT) VALUES (2, 'M', 'Month', '0');
INSERT INTO AGE_UNIT_DICT (SERIAL_NO, UNIT_CODE, AGE_UNIT_NAME, IS_DEFAULT) VALUES (3, 'W', 'Week', '0');
INSERT INTO AGE_UNIT_DICT (SERIAL_NO, UNIT_CODE, AGE_UNIT_NAME, IS_DEFAULT) VALUES (4, 'D', 'Day', '0');
INSERT INTO AGE_UNIT_DICT (SERIAL_NO, UNIT_CODE, AGE_UNIT_NAME, IS_DEFAULT) VALUES (5, 'H', 'Hour', '0');
--INSERT INTO AGE_UNIT_DICT (SERIAL_NO, UNIT_CODE, AGE_UNIT_NAME, IS_DEFAULT) VALUES (6, 'U', 'Unspecified', '0');

INSERT INTO BODY_HEIGHT_UNIT_DICT (SERIAL_NO, UNIT_CODE, BODY_HEIGHT_UNIT_NAME, IS_DEFAULT) VALUES (1, 'cm', 'cm', '1');
INSERT INTO BODY_HEIGHT_UNIT_DICT (SERIAL_NO, UNIT_CODE, BODY_HEIGHT_UNIT_NAME, IS_DEFAULT) VALUES (2, 'inch', 'inch', '0');
--INSERT INTO BODY_HEIGHT_UNIT_DICT (SERIAL_NO, UNIT_CODE, BODY_HEIGHT_UNIT_NAME, IS_DEFAULT) VALUES (3, 'uspe', 'unspecified', '0');

INSERT INTO BODY_WEIGHT_UNIT_DICT (SERIAL_NO, UNIT_CODE, BODY_WEIGHT_UNIT_NAME, IS_DEFAULT) VALUES (1, 'kg', 'kg', '1');
INSERT INTO BODY_WEIGHT_UNIT_DICT (SERIAL_NO, UNIT_CODE, BODY_WEIGHT_UNIT_NAME, IS_DEFAULT) VALUES (2, 'pound', 'lb.', '0');
--INSERT INTO BODY_WEIGHT_UNIT_DICT (SERIAL_NO, UNIT_CODE, BODY_WEIGHT_UNIT_NAME, IS_DEFAULT) VALUES (3, 'uspe', 'unspecified', '0');

INSERT INTO CALL_STATUS_DICT (SERIAL_NO, CALL_CODE, CALL_NAME) VALUES (1, 'WAITING', 'Waiting');
INSERT INTO CALL_STATUS_DICT (SERIAL_NO, CALL_CODE, CALL_NAME) VALUES (2, 'CALLED', 'Called');

INSERT INTO CONSULTATION_STATUS_DICT (SERIAL_NO, CONSULTATION_CODE, CONSULTATION_NAME) VALUES (1, 'NONCONSULT', 'NONCONSULT');
INSERT INTO CONSULTATION_STATUS_DICT (SERIAL_NO, CONSULTATION_CODE, CONSULTATION_NAME) VALUES (2, 'CONSULTING', 'CONSULTING');
INSERT INTO CONSULTATION_STATUS_DICT (SERIAL_NO, CONSULTATION_CODE, CONSULTATION_NAME) VALUES (3, 'CONSULTED', 'CONSULTED');

INSERT INTO UPLOAD_STATUS_DICT (SERIAL_NO, UPLOAD_CODE, UPLOAD_NAME) VALUES (1, 'UNUPLOADED', 'Nonupload');
INSERT INTO UPLOAD_STATUS_DICT (SERIAL_NO, UPLOAD_CODE, UPLOAD_NAME) VALUES (2, 'UPLOADED', 'Upload');

INSERT INTO EXPORT_STATUS_DICT (SERIAL_NO, EXPORT_CODE, EXPORT_NAME) VALUES (1, 'UNEXPORTED', 'Nonexport');
INSERT INTO EXPORT_STATUS_DICT (SERIAL_NO, EXPORT_CODE, EXPORT_NAME) VALUES (2, 'EXPORTED', 'Export');

INSERT INTO CHANGE_STATUS_DICT (SERIAL_NO, CHANGE_CODE, CHANGE_NAME) VALUES (1, 'UNCHANGED', 'UNCHANGED');
INSERT INTO CHANGE_STATUS_DICT (SERIAL_NO, CHANGE_CODE, CHANGE_NAME) VALUES (2, 'CHANGED', 'CHANGED');

INSERT INTO DIAGSYNC_STATUS_DICT (SERIAL_NO, DIAGSYNC_CODE, DIAGSYNC_NAME) VALUES (1, 'UNSYNCHRONIZED', 'UNSYNCHRONIZED');
INSERT INTO DIAGSYNC_STATUS_DICT (SERIAL_NO, DIAGSYNC_CODE, DIAGSYNC_NAME) VALUES (2, 'SYNCHRONIZED', 'SYNCHRONIZED');

INSERT INTO FILEDELIVERY_STATUS_DICT (SERIAL_NO, FILEDELIVERY_CODE, FILEDELIVERY_NAME) VALUES (1, 'UNDELIVERIED', 'UNDELIVERIED');
INSERT INTO FILEDELIVERY_STATUS_DICT (SERIAL_NO, FILEDELIVERY_CODE, FILEDELIVERY_NAME) VALUES (2, 'DELIVERIED', 'DELIVERIED');

INSERT INTO DEPT_OI_ATTR_DICT (OI_ATTR_CODE, OI_ATTR_NAME) VALUES ('1', 'Inpatient');
INSERT INTO DEPT_OI_ATTR_DICT (OI_ATTR_CODE, OI_ATTR_NAME) VALUES ('2', 'Outpatient');
INSERT INTO DEPT_OI_ATTR_DICT (OI_ATTR_CODE, OI_ATTR_NAME) VALUES ('3', 'Outpatient/Inpatient');
INSERT INTO DEPT_OI_ATTR_DICT (OI_ATTR_CODE, OI_ATTR_NAME) VALUES ('4', 'Others');

INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('0', 'Request');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('1', 'Completed Order');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('2', 'Completed');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('3', 'Confirmed');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('4', 'Disabled');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('5', 'Diagnosing');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('6', 'Diagnosed');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('7', 'Reviewed');
INSERT INTO EXAM_RESULT_STATUS_DICT (EXAM_RESULT_STATUS_CODE, EXAM_RESULT_STATUS_NAME) VALUES ('8', 'uploading');

INSERT INTO ITEM_STATUS_DICT (STATUS_CODE, STATUS_NAME) VALUES (0, 'Reserved');
INSERT INTO ITEM_STATUS_DICT (STATUS_CODE, STATUS_NAME) VALUES (1, 'Normal');

INSERT INTO MEDIA_DICT (ID, MEDIA_NAME, MEDIA_TYPE, HOST_NAME, PORT, USER_NAME, USER_PWD, CURRENT_MEDIA) VALUES (1, 'Server', 'FTP', '192.168.1.245', '21', 'ENSData', 'ENSData', '1');

INSERT INTO PACEMAKER_DICT (SERIAL_NO, PACEMAKER_CODE, PACEMAKER_NAME) VALUES (1, '0', 'Without Pacemaker');
INSERT INTO PACEMAKER_DICT (SERIAL_NO, PACEMAKER_CODE, PACEMAKER_NAME) VALUES (2, '1', 'With Pacemaker');
INSERT INTO PACEMAKER_DICT (SERIAL_NO, PACEMAKER_CODE, PACEMAKER_NAME) VALUES (3, '2', 'Unspecified');

INSERT INTO PATIENT_SOURCE_DICT (SERIAL_NO, PATIENT_SOURCE_CODE, PATIENT_SOURCE_NAME) VALUES (1, '2', 'Outpatient');
INSERT INTO PATIENT_SOURCE_DICT (SERIAL_NO, PATIENT_SOURCE_CODE, PATIENT_SOURCE_NAME) VALUES (2, '1', 'Inpatient');
INSERT INTO PATIENT_SOURCE_DICT (SERIAL_NO, PATIENT_SOURCE_CODE, PATIENT_SOURCE_NAME) VALUES (3, '3', 'Physical Exam');

INSERT INTO PRESSURE_UNIT_DICT (SERIAL_NO, UNIT_CODE, PRESSURE_UNIT_NAME, IS_DEFAULT) VALUES (1, 'mmHg', 'mmHg', '1');
INSERT INTO PRESSURE_UNIT_DICT (SERIAL_NO, UNIT_CODE, PRESSURE_UNIT_NAME, IS_DEFAULT) VALUES (2, 'pa', 'kPa', '0');
--INSERT INTO PRESSURE_UNIT_DICT (SERIAL_NO, UNIT_CODE, PRESSURE_UNIT_NAME, IS_DEFAULT) VALUES (3, 'uspe', 'Unspecified', '0');

INSERT INTO PRINT_STATUS_DICT (SERIAL_NO, PRINT_CODE, PRINT_NAME) VALUES (1, 'UNPRINTED', 'Unprinted');
INSERT INTO PRINT_STATUS_DICT (SERIAL_NO, PRINT_CODE, PRINT_NAME) VALUES (2, 'PRINTED', 'Printed');

INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (1, 'Unknown', 'UNKNOWN');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (2, 'Oriental', 'ORIENTAL');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (3, 'Caucasian', 'CAUCASIAN');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (4, 'Black', 'BLACK');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (5, 'Indian', 'INDIAN');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (6, 'Mongolian', 'MONGOLIAN');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (7, 'Hispanic', 'HISPANIC');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (8, 'Asian', 'ASIAN');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (9, 'Pacific', 'PACIFIC');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (10, 'Others', 'OTHER');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (11, 'Unspecified', 'UNSPECIFIED');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (12, 'Amerindian', 'AMERINDIAN');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (13, 'Eskimo', 'ESKIMO');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (14, 'Hawaiian', 'HAWAIIAN');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (15, 'Chinese', 'CHINESE');
INSERT INTO RACE_DICT (SERIAL_NO, RACE_NAME, RACE_FLAG) VALUES (16, 'Malay', 'MALAY');

INSERT INTO REPORTFORMAT_INFO (REPORTFORMAT) VALUES (0);

INSERT INTO EXAM_PRIORITY_DICT (SERIAL_NO, PRIORITY_CODE, PRIORITY_NAME) VALUES (1, 'R', 'Routine');
INSERT INTO EXAM_PRIORITY_DICT (SERIAL_NO, PRIORITY_CODE, PRIORITY_NAME) VALUES (2, 'E', 'Emergent');

INSERT INTO CURRENCY_UNIT_DICT (SERIAL_NO, UNIT_CODE, CURRENCY_UNIT_NAME, IS_DEFAULT) VALUES (1, 'RMB', 'RMB', '0');
INSERT INTO CURRENCY_UNIT_DICT (SERIAL_NO, UNIT_CODE, CURRENCY_UNIT_NAME, IS_DEFAULT) VALUES (2, 'USD', 'USD', '0');
INSERT INTO CURRENCY_UNIT_DICT (SERIAL_NO, UNIT_CODE, CURRENCY_UNIT_NAME, IS_DEFAULT) VALUES (3, 'HKD', 'HKD', '0');
INSERT INTO CURRENCY_UNIT_DICT (SERIAL_NO, UNIT_CODE, CURRENCY_UNIT_NAME, IS_DEFAULT) VALUES (4, 'EUR', 'EUR', '0');

INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (0, N'Requested');
INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (1, N'Ordered');
INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (2, N'Unconfirmed');
INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (3, N'Confirmed');
INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (6, N'Consultation');
INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (7, N'Other System Information');
INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (21, N'User Information');
INSERT INTO MESSAGE_TYPE_DICT (MESSAGE_TYPE_CODE, MESSAGE_TYPE_NAME) VALUES (22, N'Group Information');

INSERT INTO MATCH_STYLE_DICT(SERIAL_NO, MATCH_STYLE_CODE, MATCH_STYLE_NAME) VALUES (1, 'AUTO', 'AUTO');
INSERT INTO MATCH_STYLE_DICT(SERIAL_NO, MATCH_STYLE_CODE, MATCH_STYLE_NAME) VALUES (2, 'MANUAL', 'MANUAL');

INSERT INTO CUSTOM_TITLE(CUSTOM_TITLE_CODE, CUSTOM_TITLE_NAME) VALUES ('1', '');
INSERT INTO CUSTOM_TITLE(CUSTOM_TITLE_CODE, CUSTOM_TITLE_NAME) VALUES ('2', '');

INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (1, 1, 'Order Type', 1, 'Default');
INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (2, 2, 'Exam Type', 1, 'Default');
INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (3, 3, 'Diagnosis Type', 1, 'Default');
INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (4, 4, 'View Type', 1, 'Default');
INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (5, 5, 'Search Type', 1, 'Default');
INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (6, 6, 'System Setting Type', 1, 'Default');
INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (7, 7, 'Data Management Type', 1, 'Default');
INSERT INTO RIGHT_CLASS (SERIAL_NO, CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (8, 8, 'Cancellation Type', 1, 'Default');

INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (1, 1, 1, 'Order', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (2, 2, 1, 'Modify Order', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (3, 3, 1, 'Print Return Receipt', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (4, 4, 2, 'Examination', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (5, 5, 2, 'Upload To Server', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (6, 6, 2, 'Manual Matching', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (7, 19, 3, 'Primary Diagnosis', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (8, 7, 3, 'Medium Diagnosis', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (9, 20, 3, 'High Diagnosis', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (10, 8, 4, 'View', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (11, 9, 4, 'Print Report', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (12, 11, 5, 'Requested', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (13, 12, 5, 'Ordered', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (14, 13, 5, 'Examined', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (15, 14, 5, 'All Lists', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (16, 23, 5, 'Consultation List', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (17, 24, 6, 'System Setting', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (18, 25, 6, 'Examination Department and Device Management', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (19, 26, 6, 'Examination Type and Item Management', 1,'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (20, 27, 6, 'Integration Setting', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (21, 28, 6, 'Data Maintenance Setting', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (22, 29, 6, 'Product Information Management', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (23, 30, 6, 'Client Management', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (24, 16, 6, 'Role Management', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (25, 17, 6, 'User Management', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (26, 31, 7, 'Import', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (27, 10, 7, 'Export', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (28, 18, 7, 'Management Statistics', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (29, 32, 7, 'R&D Statistics', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (30, 34, 7, 'Monitoring', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (31, 33, 7, 'Educational Patient Records', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (32, 21, 8, 'Cancelled Order', 1, 'Default');
INSERT INTO RIGHT_DETAIL (SERIAL_NO, RIGHT_ID, CLASS_ID, RIGHT_NAME, IS_VALID, DESCRIPTION) VALUES (33, 22, 8, 'Cancelled Examination', 1, 'Default');

--添加了角色
INSERT INTO ROLE_CLASS (CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (1, 'Exam.', 1, '');
INSERT INTO ROLE_CLASS (CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (2, 'Diagnose', 1, '');
INSERT INTO ROLE_CLASS (CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (3, 'Print', 1, '');
INSERT INTO ROLE_CLASS (CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (4, 'System Setting', 1, '');
INSERT INTO ROLE_CLASS (CLASS_ID, CLASS_NAME, IS_VALID, DESCRIPTION) VALUES (5, 'Hospital Administrator', 1, '');



INSERT INTO SEVERITY_DICT (SERIAL_NO, SEVERITY_CODE, SEVERITY_NAME) VALUES (1, 'POSTIVECRITICAL', 'Positive Critical');
INSERT INTO SEVERITY_DICT (SERIAL_NO, SEVERITY_CODE, SEVERITY_NAME)  VALUES (2, 'POSTIVEDUBIOUS', 'Positive Dubious');
INSERT INTO SEVERITY_DICT (SERIAL_NO, SEVERITY_CODE, SEVERITY_NAME) VALUES (3, 'POSTIVE', 'POSTIVE');
INSERT INTO SEVERITY_DICT (SERIAL_NO, SEVERITY_CODE, SEVERITY_NAME) VALUES (4, 'NORMAL', 'NORMAL');
INSERT INTO SEVERITY_DICT (SERIAL_NO, SEVERITY_CODE, SEVERITY_NAME) VALUES (5, 'UNKNOWN', 'Indistinguishable');

INSERT INTO SEX_DICT (SERIAL_NO, SEX_NAME, SEX_FLAG) VALUES (1, 'Male', 'M');
INSERT INTO SEX_DICT (SERIAL_NO, SEX_NAME, SEX_FLAG) VALUES (2, 'Female', 'F');
INSERT INTO SEX_DICT (SERIAL_NO, SEX_NAME, SEX_FLAG) VALUES (3, 'Unknown', 'O');
--INSERT INTO SEX_DICT (SERIAL_NO, SEX_NAME, SEX_FLAG) VALUES (4, 'Unspecified', 'U');

INSERT INTO USERS (USER_ID, USER_PWD, USER_NAME, USER_DEPT, USER_STATUS, CREATE_DATE) VALUES ('ECG', '0CB215F8BCDEA3A2330EA2146EE3C9F9', '', '1', '0', now());

--修改了给默认用户添加角色
INSERT INTO ROLE_OF_USER (USER_ID, CLASS_ID) VALUES ('ECG', 1);
INSERT INTO ROLE_OF_USER (USER_ID, CLASS_ID) VALUES ('ECG', 2);
INSERT INTO ROLE_OF_USER (USER_ID, CLASS_ID) VALUES ('ECG', 3);
INSERT INTO ROLE_OF_USER (USER_ID, CLASS_ID) VALUES ('ECG', 4);
INSERT INTO ROLE_OF_USER (USER_ID, CLASS_ID) VALUES ('ECG', 5);


INSERT INTO VERSION_INFO (VERSION) VALUES ('1.2');

--INSERT INTO ADDED_RIGHT_OF_USER (USER_ID, RIGHT_ID, IS_ALLOW) VALUES ('admin', 16, 1);
--INSERT INTO ADDED_RIGHT_OF_USER (USER_ID, RIGHT_ID, IS_ALLOW) VALUES ('admin', 17, 1);

--Outpatient ECG Dept为系统默认值，不要针对此名称进行修改，否则会引起下发到心电图机时失去该名称的多语言机制，C#代码ENS.Core.Appoint.UEnsAppointAgent中有多语言转换
INSERT INTO DEPT_DICT (SERIAL_NO, DEPT_CODE, DEPT_NAME, OUTP_OR_INP, ITEM_STATUS, DEPT_LEVEL, IS_VALID) VALUES (1, '1', 'Outpatient ECG Dept.', '1', 1, 1, 1);

--检查医生权限点
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 1, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 8, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 2, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 5, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 6, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 12, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 14, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (1, 4, 1);
--诊断医生权限点
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (2, 7, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (2, 8, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (2, 2, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (2, 33, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (2, 14, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (2, 32, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (2, 18, 1);
--打印
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (3, 9, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (3, 14, 1);
--系统设置
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (4, 24, 1);
--管理员权限点
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (5, 12, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (5,14, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (5, 31, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (5, 10, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (5, 21, 1);
INSERT INTO RIGHT_OF_ROLE (ROLE_CLASS_ID, RIGHT_ID, DEPT_CODE) VALUES (5, 22, 1);



INSERT INTO EXAM_CLASS_DICT (SERIAL_NO, EXAM_CLASS_CODE, EXAM_CLASS_NAME, IS_VALID, ITEM_STATUS) VALUES (1, '1', 'Resting ECG', '1', 1);
INSERT INTO EXAM_CLASS_DICT (SERIAL_NO, EXAM_CLASS_CODE, EXAM_CLASS_NAME, IS_VALID, ITEM_STATUS) VALUES (2, '2', 'Exercise ECG', '1', 1);

INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (2, '1', '12-lead Resting ECG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (3, '2', '15-lead Resting ECG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (6, '3', 'Rhythm ECG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (7, '4', 'HRV', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (8, '5', 'VCG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (13, '6', 'Exercise ECG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (1, '8', '9-lead Resting ECG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (4, '9', '16-lead Resting ECG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (5, '11', '18-lead Resting ECG', '1', 1, 'USD');
INSERT INTO EXAM_ITEM_DICT (SERIAL_NO, EXAM_ITEM_CODE, EXAM_ITEM_NAME, IS_VALID, ITEM_STATUS, CURRENCY_UNIT) VALUES (9, '10', 'Pharmacological Study', '1', 1, 'USD');

INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '1');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '2');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '3');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '4');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '5');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '8');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '9');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '10');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('1', '11');
INSERT INTO EXAM_CLASS_ITEM_DICT (EXAM_CLASS_CODE, EXAM_ITEM_CODE) VALUES ('2', '6');

INSERT INTO ECG_DEVICES_DICT (DEVICE_ID, DEPT_CODE, DEVICE_NAME, DEVICE_MODLE, MEMO, ITEM_STATUS) VALUES ('1', '1', 'SE-1515', 'SE-1515', 'Default', 1);


INSERT INTO COLLECTION_TYPE_DICT(TYPE_NAME)VALUES ('Normal ECG');
INSERT INTO COLLECTION_TYPE_DICT(TYPE_NAME)VALUES ('Arrhythmia');
INSERT INTO COLLECTION_TYPE_DICT(TYPE_NAME)VALUES ('Conduction Block');
INSERT INTO COLLECTION_TYPE_DICT(TYPE_NAME)VALUES ('Myocardial Infarction');
INSERT INTO COLLECTION_TYPE_DICT(TYPE_NAME)VALUES ('Atrial  flutter/fibrillation');
INSERT INTO COLLECTION_TYPE_DICT(TYPE_NAME)VALUES ('Others');

--初始化DEMO病人信息和检查信息
INSERT INTO PATIENT_INFO(PATIENT_ID, PATIENT_NAME, SEX, DATE_OF_BIRTH, RACE, ITEM_STATUS)VALUES ('DEMOTest', 'DEMOTest', 'M', '2000-12-30', 'UNKNOWN', 1);

INSERT INTO EXAM_MASTER(EXAM_ID, PERFORMED_BY, EXAM_CLASS, EXAM_ITEM, PATIENT_ID, DEVICE_ID, RESULT_STATUS, RECORD_GUID)VALUES ('200012300001', '1', '1', '8', 'DEMOTest', '1', '2', 'bcef0b62-67f2-4574-bf36-fbf926fd9241');
INSERT INTO EXAM_MASTER(EXAM_ID, PERFORMED_BY, EXAM_CLASS, EXAM_ITEM, PATIENT_ID, DEVICE_ID, RESULT_STATUS, RECORD_GUID)VALUES ('200012300002', '1', '1', '1', 'DEMOTest', '1', '2', 'bcef0b62-67f2-4574-bf36-fbf926fd9242');
INSERT INTO EXAM_MASTER(EXAM_ID, PERFORMED_BY, EXAM_CLASS, EXAM_ITEM, PATIENT_ID, DEVICE_ID, RESULT_STATUS, RECORD_GUID)VALUES ('200012300003', '1', '1', '2', 'DEMOTest', '1', '2', 'bcef0b62-67f2-4574-bf36-fbf926fd9243');
INSERT INTO EXAM_MASTER(EXAM_ID, PERFORMED_BY, EXAM_CLASS, EXAM_ITEM, PATIENT_ID, DEVICE_ID, RESULT_STATUS, RECORD_GUID)VALUES ('200012300004', '1', '1', '9', 'DEMOTest', '1', '2', 'bcef0b62-67f2-4574-bf36-fbf926fd9244');
INSERT INTO EXAM_MASTER(EXAM_ID, PERFORMED_BY, EXAM_CLASS, EXAM_ITEM, PATIENT_ID, DEVICE_ID, RESULT_STATUS, RECORD_GUID)VALUES ('200012300005', '1', '2', '6', 'DEMOTest', '1', '2', 'bcef0b62-67f2-4574-bf36-fbf926fd9245');
INSERT INTO EXAM_MASTER(EXAM_ID, PERFORMED_BY, EXAM_CLASS, EXAM_ITEM, PATIENT_ID, DEVICE_ID, RESULT_STATUS, RECORD_GUID)VALUES ('200012300006', '1', '1', '3', 'DEMOTest', '1', '2', 'bcef0b62-67f2-4574-bf36-fbf926fd9246');

INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300001', 1, '/DemoData/20130926_095447_386_{ED8069C4-739B-4F3E-8634-C394CD5A192E}.dat', 'DAT', '11d5ff2b-a401-4088-9f97-dcdcadc30857');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300001', 1, '/DemoData/20130926_095447_386_{ED8069C4-739B-4F3E-8634-C394CD5A192E}.xml', 'XML', '11d5ff2b-a401-4088-9f97-dcdcadc30857');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300002', 1, '/DemoData/20130926_095116_028_{44E61B98-1075-49F8-86BA-3E019545B8B9}.dat', 'DAT', 'd136cda5-5e1d-4cb3-a96b-09cda981c8fb');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300002', 1, '/DemoData/20130926_095116_028_{44E61B98-1075-49F8-86BA-3E019545B8B9}.xml', 'XML', 'd136cda5-5e1d-4cb3-a96b-09cda981c8fb');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300003', 1, '/DemoData/20130926_095636_589_{3119B209-2E75-46D2-B194-83847ACE9726}.dat', 'DAT', '88249c25-a1f6-44cd-8016-f04372ad7e93');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300003', 1, '/DemoData/20130926_095636_589_{3119B209-2E75-46D2-B194-83847ACE9726}.xml', 'XML', '88249c25-a1f6-44cd-8016-f04372ad7e93');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300004', 1, '/DemoData/20130926_095749_432_{32CA4D83-EF82-40B9-B0CA-1B592879D4F8}.dat', 'DAT', 'ef95e5ad-0d85-4c57-a5ed-a9ca876c7b55');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300004', 1, '/DemoData/20130926_095749_432_{32CA4D83-EF82-40B9-B0CA-1B592879D4F8}.xml', 'XML', 'ef95e5ad-0d85-4c57-a5ed-a9ca876c7b55');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300005', 1, '/DemoData/20130926_175038_333_{07EDB545-CAC9-4992-A885-214C294BB8E5}.dat', 'DAT', 'd136cda5-5e1d-4cb3-a96b-09cda981c8ff');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300005', 1, '/DemoData/20130926_175038_333_{07EDB545-CAC9-4992-A885-214C294BB8E5}.xml', 'XML', 'd136cda5-5e1d-4cb3-a96b-09cda981c8ff');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300006', 1, '/DemoData/20130926_165652_745_{5509B1E7-4C76-4326-9075-460A907FCD6F}.dat', 'DAT', 'ef95e5ad-0d85-4c57-a5ed-a9ca876c7b56');
INSERT INTO EXAM_MASTER_ITEM_DATA(EXAM_ID, MEDIA, PATH, DATA_TYPE, GUID)VALUES('200012300006', 1, '/DemoData/20130926_165652_745_{5509B1E7-4C76-4326-9075-460A907FCD6F}.xml', 'XML', 'ef95e5ad-0d85-4c57-a5ed-a9ca876c7b56');
