 
 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),

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

UNION ALL

VALUES
	('Emergency use of U07.1 | COVID-19, virus identified','Condition','ICD10CN','ICD10 code','U07.1',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('Emergency use of U07.2 | COVID-19, virus not identified','Condition','ICD10CN','ICD10 code','U07.2',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('COVID-19, excluding pneumonia','Condition','ICD10CN','ICD10 code','U07.100x002',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('COVID-19','Condition','ICD10CN','ICD10 code','U07.100',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('Suspected case of COVID-19 pneumonia','Condition','ICD10CN','ICD10 code','Z03.800x001',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('COVID-19 pneumonia','Condition','ICD10CN','ICD10 code','U07.100x001',TO_DATE('19700101','yyyymmdd'),TO_DATE('20991231','yyyymmdd')),
	('COVID-19 pneumonia','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
