 --
 -- Table structure for table `interaction`
 --
-
+drop table IF EXISTS interaction;
 CREATE TABLE `interaction` (
   `GENE_A` bigint(20) NOT NULL,
   `GENE_B` bigint(20) NOT NULL,

--
-- Table structure for table `mutation`
--

CREATE TABLE IF NOT EXISTS `mutation` (
  `GENETIC_PROFILE_ID` int(11) NOT NULL,
  `CASE_ID` varchar(255) NOT NULL,
  `ENTREZ_GENE_ID` int(255) NOT NULL,


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `cgds`
--

-- --------------------------------------------------------

--
-- Table structure for table `cancer_study`
--
drop table IF EXISTS cancer_study;
CREATE TABLE `cancer_study` (
  `CANCER_STUDY_ID` int(11) NOT NULL auto_increment,
  `CANCER_STUDY_IDENTIFIER` varchar(25),
  `TYPE_OF_CANCER_ID` varchar(25) NOT NULL,
