The MedDRA documentation is good enough to create the table structure and import the supplied ASCII files. Given below is the example how I tested the import of MedDRA 9.0 into MySQL. "LOAD DATA LOCAL INFILE" command was used to import the ASCII files :
TABLE low_level_term CREATE TABLE 1_low_level_term ( llt_code bigint not null, llt_name varchar(100) not null, pt_code bigint, llt_whoart_code varchar(7), llt_harts_code bigint, llt_costart_sym varchar(21), llt_icd9_code varchar(8), llt_icd9cm_code varchar(8), llt_icd10_code varchar(8), llt_currency varchar(1), llt_jart_code varchar(6), CREATE UNIQUE INDEX ix1_pt_llt01 ON 1_low_level_term (llt_code); CREATE UNIQUE INDEX ix1_pt_llt02 ON 1_low_level_term (llt_name); CREATE UNIQUE INDEX ix1_pt_llt03 ON 1_low_level_term (pt_code); ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ; ----------------------------------------------------------------------------------------- TABLE pref_term CREATE TABLE 1_pref_term ( pt_code bigint not null, pt_name varchar(100) not null, null_field char(1), pt_soc_code bigint, pt_whoart_code varchar(7), pt_harts_code bigint, pt_costart_sym varchar(21), pt_icd9_code varchar(8), pt_icd9cm_code varchar(8), pt_icd10_code varchar(8), pt_jart_code varchar(6) CREATE UNIQUE INDEX ix1_pt01 ON 1_pref_term (pt_code); CREATE UNIQUE INDEX ix1_pt02 ON 1_pref_term (pt_name); CREATE UNIQUE INDEX ix1_pt03 ON 1_pref_term (pt_soc_code); ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ; |