<commit_before>-- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 25, 2010 at 11:45 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.11

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

USE CGDS;

drop table IF EXISTS encrypted_keys;
drop table IF EXISTS cancer_study;
drop table IF EXISTS access_rights;
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_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 protein_array_info;
drop table IF EXISTS protein_array_target;
drop table IF EXISTS protein_array_data;

--
-- Database: `cgds`
--

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

--
-- Table structure for table `encrypted_keys`
--

CREATE TABLE IF NOT EXISTS `encrypted_keys` (
  `ENCRYPTED_KEY` varchar(100) NOT NULL,
  PRIMARY KEY  (`ENCRYPTED_KEY`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `cancer_study`
--

CREATE TABLE IF NOT EXISTS `cancer_study` (
  `CANCER_STUDY_ID` int(11) NOT NULL auto_increment,
  `CANCER_STUDY_IDENTIFIER` varchar(25),
  `TYPE_OF_CANCER_ID` varchar(25) NOT NULL,
  `NAME` varchar(255) NOT NULL,
  `DESCRIPTION` varchar(1024) NOT NULL,
  `PUBLIC` BOOLEAN NOT NULL,
  PRIMARY KEY  (`CANCER_STUDY_ID`),
  UNIQUE (`CANCER_STUDY_IDENTIFIER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `EMAIL` varchar(128) NOT NULL,
  `NAME` varchar(255),
  `ENABLED` BOOLEAN NOT NULL,
  `CONSUMER_SECRET` varchar(100) NOT NULL,
  PRIMARY KEY  (`EMAIL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `access_rights`
--

CREATE TABLE IF NOT EXISTS `authorities` (
  `EMAIL` varchar(128) NOT NULL,
  `AUTHORITY` varchar(50) NOT NULL
  --FOREIGN KEY (EMAIL) REFERENCES users (EMAIL),
  --UNIQUE index authorities_idx_1 (EMAIL, AUTHORITY)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `access_rights`
--

CREATE TABLE IF NOT EXISTS `access_rights` (
  `EMAIL` varchar(128) NOT NULL,
  `CANCER_STUDY_ID` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `type_of_cancer`
--
<commit_msg>Removed dashes that were causing SQL error<commit_after>-- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 25, 2010 at 11:45 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.11

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

USE CGDS;

drop table IF EXISTS encrypted_keys;
drop table IF EXISTS cancer_study;
drop table IF EXISTS access_rights;
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_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 protein_array_info;
drop table IF EXISTS protein_array_target;
drop table IF EXISTS protein_array_data;

--
-- Database: `cgds`
--

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

--
-- Table structure for table `encrypted_keys`
--

CREATE TABLE IF NOT EXISTS `encrypted_keys` (
  `ENCRYPTED_KEY` varchar(100) NOT NULL,
  PRIMARY KEY  (`ENCRYPTED_KEY`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `cancer_study`
--

CREATE TABLE IF NOT EXISTS `cancer_study` (
  `CANCER_STUDY_ID` int(11) NOT NULL auto_increment,
  `CANCER_STUDY_IDENTIFIER` varchar(25),
  `TYPE_OF_CANCER_ID` varchar(25) NOT NULL,
  `NAME` varchar(255) NOT NULL,
  `DESCRIPTION` varchar(1024) NOT NULL,
  `PUBLIC` BOOLEAN NOT NULL,
  PRIMARY KEY  (`CANCER_STUDY_ID`),
  UNIQUE (`CANCER_STUDY_IDENTIFIER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `EMAIL` varchar(128) NOT NULL,
  `NAME` varchar(255),
  `ENABLED` BOOLEAN NOT NULL,
  `CONSUMER_SECRET` varchar(100) NOT NULL,
  PRIMARY KEY  (`EMAIL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `access_rights`
--

CREATE TABLE IF NOT EXISTS `authorities` (
  `EMAIL` varchar(128) NOT NULL,
  `AUTHORITY` varchar(50) NOT NULL,
  FOREIGN KEY (EMAIL) REFERENCES users (EMAIL),
  UNIQUE index authorities_idx_1 (EMAIL, AUTHORITY)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `access_rights`
--

CREATE TABLE IF NOT EXISTS `access_rights` (
  `EMAIL` varchar(128) NOT NULL,
  `CANCER_STUDY_ID` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `type_of_cancer`
--

{'fraction_non_alphanumeric': 0.1814130075932651, 'fraction_numerical': 0.02344007923407065, 'mean_word_length': 2.832384566729918, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 4, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6674325', 'n_tokens_mistral': 2199, 'n_tokens_neox': 1967, 'n_words': 624}