 
 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
-drop table IF EXISTS uniprot_id_mapping;
+--
+-- Database: `cgds`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `cancer_study`
+--
 drop table IF EXISTS cancer_study;
-drop table IF EXISTS users;
-drop table IF EXISTS authorities;
-drop table IF EXISTS type_of_cancer;
-drop table IF EXISTS mut_sig;
-drop table IF EXISTS _case;
-drop table IF EXISTS cancer_type;
-drop table IF EXISTS case_list;
-drop table IF EXISTS case_list_list;
-drop table IF EXISTS gene;
-drop table IF EXISTS gene_alias;
-drop table IF EXISTS gene_in_profile;
-drop table IF EXISTS genetic_alteration;
-drop table IF EXISTS genetic_profile_cases;
-drop table IF EXISTS genetic_profile;
-drop table IF EXISTS micro_rna;
-drop table IF EXISTS mutation;
-drop table IF EXISTS mutation_frequency;
-drop table IF EXISTS micro_rna_alteration;
-drop table IF EXISTS clinical;
-drop table IF EXISTS interaction;
-drop table if EXISTS sanger_cancer_census;
-drop table if EXISTS clinical_free_form;
-drop table if EXISTS text_cache;
-
-drop table IF EXISTS protein_array_info;
-drop table IF EXISTS protein_array_target;
-drop table IF EXISTS protein_array_data;
-drop table IF EXISTS protein_array_cancer_study;
-
-drop table IF EXISTS drug;
-drop table IF EXISTS drug_interaction;
-
---
--- Database: `cgds`
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table `cancer_study`
---
-
-CREATE TABLE IF NOT 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,

--
-- Table structure for table `genetic_profile_cases`
--

CREATE TABLE IF NOT EXISTS `genetic_profile_cases` (
  `GENETIC_PROFILE_ID` int(11) NOT NULL,
  `ORDERED_CASE_LIST` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `case_list`
--
drop table IF EXISTS case_list;
CREATE TABLE `case_list` (
  `LIST_ID` int(11) NOT NULL auto_increment,
  `STABLE_ID` varchar(50) NOT NULL,
  `CATEGORY` varchar(255) NOT NULL,
