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,ALLOW_INVALID_DATES';

DROP SCHEMA IF EXISTS `stc_lab_inventory` ;
CREATE SCHEMA IF NOT EXISTS `stc_lab_inventory` DEFAULT CHARACTER SET utf8 ;
USE `stc_lab_inventory` ;

-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`changes_record`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`changes_record` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`changes_record` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `contents` VARCHAR(255) NOT NULL ,
  `modification_date` DATETIME NULL ,
  `structure` VARCHAR(255) NULL ,
  `author` VARCHAR(50) NOT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`configuration_item`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`configuration_item` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`configuration_item` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `Configuration Item Type` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`document_type`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`document_type` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`document_type` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `type` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`manufacturer`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`manufacturer` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`manufacturer` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `manufacturer` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`related_hw_equipment`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`related_hw_equipment` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`related_hw_equipment` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `equipment_type` VARCHAR(50) NULL DEFAULT NULL ,
  `short_name` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`media_format_doc`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`media_format_doc` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`media_format_doc` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `format` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`supplier`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`supplier` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`supplier` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `supplier` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`system`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`system` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`system` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `system` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`status_doc`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`status_doc` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`status_doc` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `status` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`purchased`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`purchased` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`purchased` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `purchased` VARCHAR(50) NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`documents`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`documents` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`documents` (
  `Inv_doc_number` INT(11) NOT NULL AUTO_INCREMENT ,
  `label_doc` VARCHAR(50) NULL ,
  `name` VARCHAR(200) NOT NULL ,
  `document_type_ID` INT(11) NOT NULL ,
  `part_number` VARCHAR(50) NULL ,
  `Serial_number` VARCHAR(50) NULL DEFAULT NULL ,
  `status_doc_ID` INT(11) NOT NULL ,
  `manufacturer_ID` INT(11) NOT NULL ,
  `supplier_ID` INT(11) NOT NULL ,
  `system_ID` INT(11) NOT NULL ,
  `related_hw_equipment_ID` INT(11) NOT NULL ,
  `arrival_date` DATE NULL ,
  `value` DOUBLE NULL DEFAULT NULL ,
  `comment` VARCHAR(250) NULL DEFAULT NULL ,
  `version` DATETIME NULL DEFAULT NULL ,
  `location` VARCHAR(50) NULL DEFAULT NULL ,
  `media_format_doc_ID` INT(11) NOT NULL ,
  `purchased_ID` INT(11) NOT NULL ,
  PRIMARY KEY (`Inv_doc_number`) ,
  INDEX `fk_documents_manufacturer1_idx` (`manufacturer_ID` ASC) ,
  INDEX `fk_documents_related_hw_equipment1_idx` (`related_hw_equipment_ID` ASC) ,
  INDEX `fk_documents_media_format_doc1_idx` (`media_format_doc_ID` ASC) ,
  INDEX `fk_documents_document_type1_idx` (`document_type_ID` ASC) ,
  INDEX `fk_documents_supplier1_idx` (`supplier_ID` ASC) ,
  INDEX `fk_documents_system1_idx` (`system_ID` ASC) ,
  INDEX `fk_documents_status_doc1_idx` (`status_doc_ID` ASC) ,
  INDEX `fk_documents_purchased1_idx` (`purchased_ID` ASC) ,
  CONSTRAINT `fk_documents_manufacturer1`
    FOREIGN KEY (`manufacturer_ID` )
    REFERENCES `stc_lab_inventory`.`manufacturer` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_documents_related_hw_equipment1`
    FOREIGN KEY (`related_hw_equipment_ID` )
    REFERENCES `stc_lab_inventory`.`related_hw_equipment` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_documents_media_format_doc1`
    FOREIGN KEY (`media_format_doc_ID` )
    REFERENCES `stc_lab_inventory`.`media_format_doc` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_documents_document_type1`
    FOREIGN KEY (`document_type_ID` )
    REFERENCES `stc_lab_inventory`.`document_type` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_documents_supplier1`
    FOREIGN KEY (`supplier_ID` )
    REFERENCES `stc_lab_inventory`.`supplier` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_documents_system1`
    FOREIGN KEY (`system_ID` )
    REFERENCES `stc_lab_inventory`.`system` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_documents_status_doc1`
    FOREIGN KEY (`status_doc_ID` )
    REFERENCES `stc_lab_inventory`.`status_doc` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_documents_purchased1`
    FOREIGN KEY (`purchased_ID` )
    REFERENCES `stc_lab_inventory`.`purchased` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`status_hw`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`status_hw` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`status_hw` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `status` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`calibration_required`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`calibration_required` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`calibration_required` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `yesno` VARCHAR(50) NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`hardware`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`hardware` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`hardware` (
  `Inv_HW_number` INT(11) NOT NULL AUTO_INCREMENT ,
  `label` VARCHAR(50) NOT NULL DEFAULT 'Unknown' ,
  `name` VARCHAR(150) NOT NULL ,
  `part_number` VARCHAR(50) NOT NULL DEFAULT 'Unknown' ,
  `Serial Number` VARCHAR(50) NOT NULL ,
  `status_hw_ID` INT(11) NOT NULL ,
  `manufacturer_ID` INT(11) NOT NULL ,
  `supplier_ID` INT(11) NOT NULL ,
  `system_ID` INT(11) NOT NULL ,
  `related_hw_equipment_ID` INT(11) NULL DEFAULT NULL ,
  `arrival_date` DATETIME NULL ,
  `value_euro` INT(11) NULL DEFAULT NULL ,
  `calibration_required_ID` INT(11) NOT NULL ,
  `calibration_frequency (months)` INT(11) NULL DEFAULT NULL ,
  `calibration_last_date` DATETIME NULL DEFAULT NULL ,
  `calibration_due_date` DATETIME NULL DEFAULT NULL ,
  `comments` VARCHAR(250) NULL ,
  `location` VARCHAR(50) NULL DEFAULT NULL ,
  `ges_label` VARCHAR(50) NULL DEFAULT NULL ,
  `invoice_date` DATETIME NULL DEFAULT NULL ,
  `Budget_Article` VARCHAR(50) NULL DEFAULT NULL ,
  `purchased_ID` INT(11) NOT NULL ,
  PRIMARY KEY (`Inv_HW_number`) ,
  INDEX `fk_hardware_manufacturer1_idx` (`manufacturer_ID` ASC) ,
  INDEX `fk_hardware_related_hw_equipment1_idx` (`related_hw_equipment_ID` ASC) ,
  INDEX `fk_hardware_supplier1_idx` (`supplier_ID` ASC) ,
  INDEX `fk_hardware_system1_idx` (`system_ID` ASC) ,
  INDEX `fk_hardware_status_hw1_idx` (`status_hw_ID` ASC) ,
  INDEX `fk_hardware_purchased1_idx` (`purchased_ID` ASC) ,
  INDEX `fk_hardware_calibration_required1_idx` (`calibration_required_ID` ASC) ,
  CONSTRAINT `fk_hardware_manufacturer1`
    FOREIGN KEY (`manufacturer_ID` )
    REFERENCES `stc_lab_inventory`.`manufacturer` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_hardware_related_hw_equipment1`
    FOREIGN KEY (`related_hw_equipment_ID` )
    REFERENCES `stc_lab_inventory`.`related_hw_equipment` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_hardware_supplier1`
    FOREIGN KEY (`supplier_ID` )
    REFERENCES `stc_lab_inventory`.`supplier` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_hardware_system1`
    FOREIGN KEY (`system_ID` )
    REFERENCES `stc_lab_inventory`.`system` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_hardware_status_hw1`
    FOREIGN KEY (`status_hw_ID` )
    REFERENCES `stc_lab_inventory`.`status_hw` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_hardware_purchased1`
    FOREIGN KEY (`purchased_ID` )
    REFERENCES `stc_lab_inventory`.`purchased` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_hardware_calibration_required1`
    FOREIGN KEY (`calibration_required_ID` )
    REFERENCES `stc_lab_inventory`.`calibration_required` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`list_of_authors`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`list_of_authors` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`list_of_authors` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(50) NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`paste_errors`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`paste_errors` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`paste_errors` (
  `Label_Doc` INT(11) NULL DEFAULT NULL ,
  `Name` VARCHAR(255) NULL DEFAULT NULL ,
  `Status` VARCHAR(255) NULL DEFAULT NULL ,
  `System_Name` VARCHAR(255) NULL DEFAULT NULL ,
  `Related_HW_Equipment` VARCHAR(255) NULL DEFAULT NULL )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`media_format_sw`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`media_format_sw` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`media_format_sw` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `format` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`status_sw`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`status_sw` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`status_sw` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `status` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`software`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`software` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`software` (
  `Inv_SW_number` INT(11) NOT NULL AUTO_INCREMENT ,
  `label` VARCHAR(50) NOT NULL ,
  `name` VARCHAR(150) NOT NULL ,
  `version` VARCHAR(45) NOT NULL ,
  `part_number` VARCHAR(50) NULL ,
  `serial number` VARCHAR(50) NULL ,
  `status_sw_ID` INT(11) NOT NULL ,
  `manufacturer_ID` INT(11) NOT NULL ,
  `supplier_ID` INT(11) NULL ,
  `system_ID` INT(11) NOT NULL ,
  `related_hw_equipment_ID` INT(11) NOT NULL ,
  `arrival_date` DATE NULL ,
  `value_euros` INT(11) NULL ,
  `location` VARCHAR(50) NOT NULL ,
  `Comments` MEDIUMTEXT NULL ,
  `invoice_date` DATETIME NULL DEFAULT NULL ,
  `budget_article` VARCHAR(50) NULL DEFAULT NULL ,
  `media_format_sw_ID` INT(11) NOT NULL ,
  `purchased_ID` INT(11) NOT NULL ,
  PRIMARY KEY (`Inv_SW_number`) ,
  INDEX `fk_software_manufacturer_idx` (`manufacturer_ID` ASC) ,
  INDEX `fk_software_related_hw_equipment1_idx` (`related_hw_equipment_ID` ASC) ,
  INDEX `fk_software_media_format_sw1_idx` (`media_format_sw_ID` ASC) ,
  INDEX `fk_software_supplier1_idx` (`supplier_ID` ASC) ,
  INDEX `fk_software_system1_idx` (`system_ID` ASC) ,
  INDEX `fk_software_status_sw1_idx` (`status_sw_ID` ASC) ,
  INDEX `fk_software_purchased1_idx` (`purchased_ID` ASC) ,
  CONSTRAINT `fk_software_manufacturer`
    FOREIGN KEY (`manufacturer_ID` )
    REFERENCES `stc_lab_inventory`.`manufacturer` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_software_related_hw_equipment1`
    FOREIGN KEY (`related_hw_equipment_ID` )
    REFERENCES `stc_lab_inventory`.`related_hw_equipment` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_software_media_format_sw1`
    FOREIGN KEY (`media_format_sw_ID` )
    REFERENCES `stc_lab_inventory`.`media_format_sw` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_software_supplier1`
    FOREIGN KEY (`supplier_ID` )
    REFERENCES `stc_lab_inventory`.`supplier` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_software_system1`
    FOREIGN KEY (`system_ID` )
    REFERENCES `stc_lab_inventory`.`system` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_software_status_sw1`
    FOREIGN KEY (`status_sw_ID` )
    REFERENCES `stc_lab_inventory`.`status_sw` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_software_purchased1`
    FOREIGN KEY (`purchased_ID` )
    REFERENCES `stc_lab_inventory`.`purchased` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`software_version`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`software_version` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`software_version` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `SW ID` INT(11) NULL DEFAULT NULL ,
  `Version` VARCHAR(50) NULL DEFAULT NULL ,
  `Date` DATETIME NULL DEFAULT NULL ,
  `Comments` VARCHAR(250) NULL DEFAULT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`loaned_items`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`loaned_items` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`loaned_items` (
  `Loan ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `Name` VARCHAR(200) NULL DEFAULT NULL ,
  `Inventory number` INT(11) NULL DEFAULT NULL ,
  `Type` VARCHAR(50) NULL DEFAULT NULL ,
  PRIMARY KEY (`Loan ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`borrower`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`borrower` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`borrower` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `borrower` VARCHAR(50) NOT NULL ,
  `company` VARCHAR(50) NOT NULL ,
  `department` VARCHAR(50) NULL ,
  `division` VARCHAR(50) NULL DEFAULT NULL ,
  `phone` VARCHAR(50) NULL DEFAULT NULL ,
  `email` VARCHAR(50) NOT NULL ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`loan_record_sw`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`loan_record_sw` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`loan_record_sw` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `borrower_ID` INT(11) NOT NULL ,
  `software_Inv_SW_number` INT(11) NOT NULL ,
  `location` MEDIUMTEXT NOT NULL ,
  `loan_date` DATE NOT NULL ,
  `due_date` DATE NOT NULL ,
  `returned_date` DATE NULL ,
  `reason` VARCHAR(50) NOT NULL ,
  PRIMARY KEY (`ID`) ,
  INDEX `fk_loan_record_borrower1_idx` (`borrower_ID` ASC) ,
  INDEX `fk_loan_record_sw_software1_idx` (`software_Inv_SW_number` ASC) ,
  CONSTRAINT `fk_loan_record_borrower1`
    FOREIGN KEY (`borrower_ID` )
    REFERENCES `stc_lab_inventory`.`borrower` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_loan_record_sw_software1`
    FOREIGN KEY (`software_Inv_SW_number` )
    REFERENCES `stc_lab_inventory`.`software` (`Inv_SW_number` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`loan_record_hw`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`loan_record_hw` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`loan_record_hw` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `borrower_ID` INT(11) NOT NULL ,
  `hardware_Inv_HW_number` INT(11) NOT NULL ,
  `location` MEDIUMTEXT NOT NULL ,
  `loan_date` DATE NOT NULL ,
  `due_date` DATE NOT NULL ,
  `returned_date` DATE NULL ,
  `reason` VARCHAR(50) NOT NULL ,
  PRIMARY KEY (`ID`) ,
  INDEX `fk_loan_record_borrower1_idx` (`borrower_ID` ASC) ,
  INDEX `fk_loan_record_hw_hardware1_idx` (`hardware_Inv_HW_number` ASC) ,
  CONSTRAINT `fk_loan_record_borrower10`
    FOREIGN KEY (`borrower_ID` )
    REFERENCES `stc_lab_inventory`.`borrower` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_loan_record_hw_hardware1`
    FOREIGN KEY (`hardware_Inv_HW_number` )
    REFERENCES `stc_lab_inventory`.`hardware` (`Inv_HW_number` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stc_lab_inventory`.`loan_record_doc`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `stc_lab_inventory`.`loan_record_doc` ;

CREATE  TABLE IF NOT EXISTS `stc_lab_inventory`.`loan_record_doc` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
  `documents_Inv_Doc_number` INT(11) NOT NULL ,
  `borrower_ID` INT(11) NOT NULL ,
  `location` MEDIUMTEXT NOT NULL ,
  `loan_date` DATE NOT NULL ,
  `due_date` DATE NOT NULL ,
  `returned_date` DATE NULL ,
  `reason` VARCHAR(50) NOT NULL ,
  PRIMARY KEY (`ID`) ,
  INDEX `fk_loan_record_borrower1_idx` (`borrower_ID` ASC) ,
  INDEX `fk_loan_record_doc_documents1_idx` (`documents_Inv_Doc_number` ASC) ,
  CONSTRAINT `fk_loan_record_borrower100`
    FOREIGN KEY (`borrower_ID` )
    REFERENCES `stc_lab_inventory`.`borrower` (`ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_loan_record_doc_documents1`
    FOREIGN KEY (`documents_Inv_Doc_number` )
    REFERENCES `stc_lab_inventory`.`documents` (`Inv_doc_number` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;



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