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  TABLE IF NOT EXISTS `rt`.`instrument` (

  `instrument_id` INT(11) NOT NULL ,

  `name` INT(11) NOT NULL ,

  PRIMARY KEY (`instrument_id`) )

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;



CREATE  TABLE IF NOT EXISTS `rt`.`lc_run` (

  `lc_run_id` INT(11) NOT NULL ,

  `l_project_id` INT(11) NOT NULL ,

  `l_instrument_id` INT(11) NOT NULL ,

  PRIMARY KEY (`lc_run_id`) ,

  INDEX `l_project_id_1` (`l_project_id` ASC) ,

  INDEX `l_instrument_id_1` (`l_instrument_id` ASC) ,


ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;



CREATE  TABLE IF NOT EXISTS `rt`.`modification_set_has_modification` (

  `l_modification_set_id` INT(10) UNSIGNED NOT NULL ,

  `l_modification_id` INT(10) UNSIGNED NOT NULL ,

  PRIMARY KEY (`l_modification_set_id`, `l_modification_id`) ,

  INDEX `l_modification_set_id_1` (`l_modification_set_id` ASC) ,

  INDEX `l_modification_id_2` (`l_modification_id` ASC) ,


ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;



CREATE  TABLE IF NOT EXISTS `rt`.`modification_set` (

  `modification_set_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,

  `tag` VARCHAR(5) NOT NULL ,

  PRIMARY KEY (`modification_set_id`) )

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;



CREATE  TABLE IF NOT EXISTS `rt`.`modification` (

  `modification_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,

  `tag` VARCHAR(45) NOT NULL ,

  `name` VARCHAR(45) NOT NULL ,

  PRIMARY KEY (`modification_id`) )

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;



CREATE  TABLE IF NOT EXISTS `rt`.`peptide_has_modification` (

  `peptide_has_modification_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,

  `l_lc_run_id` INT(11) NOT NULL ,

  `l_peptide_id` INT(11) NOT NULL ,

  `l_modification_id` INT(11) NOT NULL ,

  `retention_time` DECIMAL(8,4) NOT NULL ,

  `score` DECIMAL(3,1) NOT NULL ,

  `threshold` DECIMAL(3,1) NOT NULL ,

  `homology` DECIMAL(3,1) NOT NULL ,

  `positions` VARCHAR(30) NOT NULL ,

  PRIMARY KEY (`peptide_has_modification_id`) ,

  INDEX `l_peptide_id_` (`l_peptide_id` ASC) ,

  INDEX `l_modification_id_1` (`l_modification_id` ASC) ,

  INDEX `l_lc_run_id_1` (`l_lc_run_id` ASC) ,


ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;



CREATE  TABLE IF NOT EXISTS `rt`.`peptide` (

  `peptide_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,

  `sequence` VARCHAR(45) NOT NULL ,

  PRIMARY KEY (`peptide_id`) )

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;



CREATE  TABLE IF NOT EXISTS `rt`.`project` (

  `project_id` INT(11) NOT NULL ,

  `protocol` INT(11) NOT NULL ,

  PRIMARY KEY (`project_id`) )

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;





SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;