初始化C-C-B-F

DELETE FROM tb_authorization;
DELETE FROM tb_ccrt_introduce_menu;
DELETE FROM tb_check_task;
DELETE FROM tb_check_task_item_patient;
DELETE FROM tb_client;
DELETE FROM tb_diagnosis_gauge_task;
DELETE FROM tb_diagnosis_gauge_task_answer_patient;
DELETE FROM tb_doctor where Mobile<>'13700137000';
DELETE FROM tb_doctor_patient;
DELETE FROM tb_doctor_advice;
DELETE FROM tb_evaluation_answer;
DELETE FROM tb_evaluation_background_picture;
DELETE FROM tb_evaluation_item_doctor_level;
DELETE FROM tb_evaluation_item_locale_task;
DELETE FROM tb_evaluation_item_scheme;
DELETE FROM tb_evaluation_item_task;
DELETE FROM tb_evaluation_item_task_item_patient;
DELETE FROM tb_evaluation_question;
DELETE FROM tb_evaluation_task;
DELETE FROM tb_evaluation_task_item;
DELETE FROM tb_training1_task;
DELETE FROM tb_training1_task_item_patient;
DELETE FROM tb_feedback;
DELETE FROM tb_moca_task;
DELETE FROM tb_moca_task_item;
DELETE FROM tb_gauge_wab;
DELETE FROM tb_gauge_task;
DELETE FROM tb_gauge_task_answer_patient;
DELETE FROM tb_gauge_task_gauge;
DELETE FROM tb_gauge_type WHERE IsDeleted=1;
DELETE FROM tb_gauge WHERE GaugeTypeGuid in(SELECT GaugeTypeGuid FROM tb_gauge_type WHERE IsDeleted=1);
DELETE FROM tb_gauge_wab;
DELETE FROM tb_keyvalue;
DELETE FROM tb_keyvalue_max;
DELETE FROM tb_loginaccount WHERE LoginAccountType >1 and LoginAccountName <>'admin' and LoginAccountName <>'hospital' and LoginAccountName<>'13700137000';
DELETE FROM tb_order;
DELETE FROM tb_order_patient_daily;
DELETE FROM tb_order_pay;
DELETE FROM tb_order_price_item;
DELETE FROM tb_patient;
DELETE FROM tb_training1_doctor_level;
DELETE FROM tb_training1_scheme;
DELETE FROM tb_upgrade_version;
DELETE FROM tb_upgrade_record;
DELETE FROM tb_client;
DELETE FROM tb_backup;
DELETE FROM tb_face_entity_db;
DELETE FROM tb_face_entity;
DELETE FROM tb_face_data;
DELETE FROM tb_common_test_task;
DELETE FROM tb_common_test_task_item; 
DELETE FROM tb_lalia_training_task;
DELETE FROM tb_lalia_training_task_item; 

/*显示其它测评，隐藏测查（其它测评包含测查内容）*/
update tb_menu set IsShow=1 where MenuPath in('doctorCommonTest','hospitalCommonTest','hospitalCommonTest');
update tb_menu set IsShow=0 where MenuPath in('doctorCheck','hospitalCheck');