Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 `items` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
- USE `items` ;
- -- -----------------------------------------------------
- -- Table `items`.`price`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `items`.`price` (
- `idPrice` INT NOT NULL AUTO_INCREMENT ,
- `price` INT(6) NOT NULL ,
- `type` VARCHAR(16) NOT NULL ,
- `shop` VARCHAR(250) NULL ,
- PRIMARY KEY (`idPrice`) )
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `items`.`coords`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `items`.`coords` (
- `idCoords` INT NOT NULL AUTO_INCREMENT ,
- `s_coords` VARCHAR(7) NOT NULL ,
- `f_coords` VARCHAR(7) NOT NULL ,
- `se_coords` VARCHAR(7) NULL ,
- `fe_coords` VARCHAR(7) NULL ,
- `col_seq` VARCHAR(18) NOT NULL ,
- PRIMARY KEY (`idCoords`) )
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `items`.`items`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `items`.`items` (
- `idItems` INT NOT NULL AUTO_INCREMENT ,
- `name` VARCHAR(1000) NOT NULL ,
- `i_type` VARCHAR(11) NOT NULL ,
- `o_type` VARCHAR(250) NOT NULL ,
- `price_idPrice` INT NULL ,
- `coords_idCoords` INT NOT NULL ,
- PRIMARY KEY (`idItems`) ,
- INDEX `fk_items_price` (`price_idPrice` ASC) ,
- INDEX `fk_items_coords1` (`coords_idCoords` ASC) ,
- CONSTRAINT `fk_items_price`
- FOREIGN KEY (`price_idPrice` )
- REFERENCES `items`.`price` (`idPrice` )
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_items_coords1`
- FOREIGN KEY (`coords_idCoords` )
- REFERENCES `items`.`coords` (`idCoords` )
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement