gistfile1.h

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb`;

-- -----------------------------------------------------
-- Table `mydb`.`pubmed`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`pubmed` ;

CREATE  TABLE IF NOT EXISTS `mydb`.`pubmed` (
  `idpubmed` INT NOT NULL ,
  `PubMed_First` VARCHAR(45) NULL ,
  `PubMed _other` VARCHAR(45) NULL ,
  `Author` VARCHAR(45) NULL ,
  `Year` VARCHAR(45) NULL ,
  `Title` VARCHAR(45) NULL ,
  `Summary` VARCHAR(45) NULL ,
  PRIMARY KEY (`idpubmed`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Study`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`Study` ;

CREATE  TABLE IF NOT EXISTS `mydb`.`Study` (
  `idStudy` INT NOT NULL ,
  `idpubmed` INT NOT NULL ,
  `summary` TINYTEXT NULL ,
  `virus` VARCHAR(45) NULL ,
  `gene` VARCHAR(45) NULL ,
  PRIMARY KEY (`idStudy`) ,
  CONSTRAINT `idpubmed`
    FOREIGN KEY
    REFERENCES `mydb`.`pubmed`
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Patient`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`Patient` ;

CREATE  TABLE IF NOT EXISTS `mydb`.`Patient` (
  `idPatient` INT NOT NULL ,
  `idpubmed` INT NOT NULL ,
  `PubPatientID` VARCHAR(45) NULL ,
  `Accession` VARCHAR(45) NULL ,
  `Race` VARCHAR(45) NULL ,
  `Gender` VARCHAR(45) NULL ,
  PRIMARY KEY (`idPatient`) ,
  INDEX `idpubmed` () ,
  CONSTRAINT `idpubmed`
    FOREIGN KEY
    REFERENCES `mydb`.`pubmed`
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Study_Patient`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`Study_Patient` ;

CREATE  TABLE IF NOT EXISTS `mydb`.`Study_Patient` (
  `idStudy_Patient` INT NOT NULL ,
  `idStudy` INT NOT NULL ,
  `idPatient` INT NOT NULL ,
  `File_ID` VARCHAR(45) NULL ,
  `Dir` VARCHAR(45) NULL ,
  `Filename` VARCHAR(45) NULL ,
  `seqLen` INT NULL ,
  `vStart` INT NULL ,
  `vEnd` INT NULL ,
  `gStart` INT NULL ,
  `gEnd` INT NULL ,
  PRIMARY KEY (`idStudy_Patient`) ,
  INDEX `idStudy` () ,
  INDEX `idPatient` () ,
  CONSTRAINT `idStudy`
    FOREIGN KEY ()
    REFERENCES `mydb`.`Study` ()
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `idPatient`
    FOREIGN KEY
    REFERENCES `mydb`.`Patient`
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Patient_Samples`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`Patient_Samples` ;

CREATE  TABLE IF NOT EXISTS `mydb`.`Patient_Samples` (
  `idPatient_Samples` INT NOT NULL ,
  `idStudy_Patient` INT NOT NULL ,
  `Time` INT NULL ,
  `seqCount` INT NULL ,
  `idTherapy` INT NULL ,
  `Viral Load copies per ml` INT(11) NULL ,
  `Viral Load log` INT(11) NULL ,
  `T Cell Counts` INT(11) NULL ,
  PRIMARY KEY (`idPatient_Samples`) ,
  INDEX `idStudy_Patient` () ,
  CONSTRAINT `idStudy_Patient`
    FOREIGN KEY
    REFERENCES `mydb`.`Study_Patient`
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;



SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;



-------------
-- Error
----------------
near 'REFERENCES `mydb`.`pubmed`
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE =' at line 10