 
 UNION ALL
 
-VALUES ('新型冠状病毒肺炎疑似病例','Z03.800x001','ICD10CN',4182948),
+VALUES
+	('新型冠状病毒肺炎疑似病例','Z03.800x001','ICD10CN',4182948),
 	('Emergency use of U07.1 | COVID-19','U07.1','ICD10CN',4180186),
 	('新型冠状病毒肺炎临床诊断病例','U07.100x003','ICD10CN',4182948),
 	('新型冠状病毒肺炎','U07.100x001','ICD10CN',4182948),


UNION ALL

VALUES ('Emergency use of U07.1 | Disease caused by severe acute respiratory syndrome coronavirus 2','Condition','ICD10CN','ICD10 code','U07.1',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('Confirmed COVID-19, excluding pneumonia (machine translation)','Condition','ICD10CN','ICD10 code','U07.100x002',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('COVID-19 (machine translation)','Condition','ICD10CN','ICD10 code','U07.100',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('Suspected case of COVID-19 (machine translation)','Condition','ICD10CN','ICD10 code','Z03.800x001',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('COVID-19 pneumonia (machine translation)','Condition','ICD10CN','ICD10 code','U07.100x001',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('COVID-19 pneumonia (machine translation)','Condition','ICD10CN','ICD10 code','U07.100x003',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd'));

--6.1. Replace names with manually corrected English components wherever possible
WITH new_names

DROP INDEX trgm_idx;
DROP TABLE icd10cn_chapters, name_source, intervals;

-- At the end, the three tables concept_stage, concept_relationship_stage AND concept_synonym_stage should be ready to be fed into the generic_update.sql script
