 -- --------------------------------------------------------
 
 --
+-- Table structure for table `uniprot_id_mapping`
+--
+
+CREATE TABLE IF NOT EXISTS `uniprot_id_mapping` (
+  `ENTREZ_GENE_ID` int(255) NOT NULL,
+  `UNIPROT_ID` varchar(255) NOT NULL,
+  PRIMARY KEY  (`ENTREZ_GENE_ID`, `UNIPROT_ID`),
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `genetic_alteration`
 --
 

  `PROTEIN_ARRAY_ID` varchar(50) NOT NULL,
  `CANCER_STUDY_ID` int(11) NOT NULL,
  PRIMARY KEY (`PROTEIN_ARRAY_ID`,`CANCER_STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

drop table IF EXISTS uniprot_id_mapping;
drop table IF EXISTS cancer_study;
drop table IF EXISTS users;
drop table IF EXISTS authorities;
