call Session;

call log('FeatureMatrixOnt.sql', 'begin');

call drop_table('FeatureMatrixOnt');

create table FeatureMatrixOnt
(
  file_idx       smallint unsigned not null,
  sample_idx     integer  unsigned not null,
  feature_idx    smallint unsigned not null,
  count_matches  smallint unsigned not null
)
engine=myisam;

call log('FeatureMatrixOnt', 'begin');

call insert_FeatureMatrixOnt('dict') ;
call insert_FeatureMatrixOnt('ICD10%') ;
call insert_FeatureMatrixOnt('ICD9CM') ;
call insert_FeatureMatrixOnt('RXNORM') ;
call insert_FeatureMatrixOnt('HL7V3.0') ;
call insert_FeatureMatrixOnt('HL7V2.5') ;
call insert_FeatureMatrixOnt('COSTAR');
call insert_FeatureMatrixOnt('MSH');
call insert_FeatureMatrixOnt('LNC');
call insert_FeatureMatrixOnt('SNOMEDCT');

insert into FeatureMatrix select * from FeatureMatrixOnt;

call log('FeatureMatrixOnt', 'done');

call log('FeatureMatrixOnt.sql', 'done');
