 --
 -- Table structure for table `genetic_profile`
 --
-
-CREATE TABLE IF NOT EXISTS `genetic_profile` (
+drop table IF EXISTS genetic_profile;
+CREATE TABLE `genetic_profile` (
   `GENETIC_PROFILE_ID` int(11) NOT NULL auto_increment,
   `STABLE_ID` varchar(50) NOT NULL,
   `CANCER_STUDY_ID` int(11) NOT NULL,

--
-- Table structure for table `drug`
--

CREATE TABLE IF NOT EXISTS `drug` (
  `DRUG_ID` char(30) NOT NULL,
  `DRUG_RESOURCE` varchar(30) NOT NULL,
  `DRUG_NAME` varchar(255) NOT NULL,

  KEY `QUICK_LOOK_UP2` (`ENTREZ_GENE_ID`,`GENETIC_PROFILE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

drop table IF EXISTS micro_rna_alteration;
CREATE TABLE `micro_rna_alteration` (
  `GENETIC_PROFILE_ID` int(11) NOT NULL,
  `MICRO_RNA_ID` varchar(50) NOT NULL,
  `VALUES` longtext NOT NULL,
