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';
- DROP SCHEMA IF EXISTS `mydb` ;
- CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
- USE `mydb` ;
- -- -----------------------------------------------------
- -- Table `mydb`.`product`
- -- -----------------------------------------------------
- DROP TABLE IF EXISTS `mydb`.`product` ;
- CREATE TABLE IF NOT EXISTS `mydb`.`product` (
- `id` INT NOT NULL ,
- `price` FLOAT NULL ,
- PRIMARY KEY (`id`) )
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`locale`
- -- -----------------------------------------------------
- DROP TABLE IF EXISTS `mydb`.`locale` ;
- CREATE TABLE IF NOT EXISTS `mydb`.`locale` (
- `id` INT NOT NULL ,
- `code` VARCHAR(5) NULL ,
- PRIMARY KEY (`id`) )
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`product_i18n`
- -- -----------------------------------------------------
- DROP TABLE IF EXISTS `mydb`.`product_i18n` ;
- CREATE TABLE IF NOT EXISTS `mydb`.`product_i18n` (
- `name` VARCHAR(45) NULL ,
- `description` TEXT NULL ,
- `product_id` INT NOT NULL ,
- `locale_id` INT NOT NULL ,
- PRIMARY KEY (`product_id`, `locale_id`) ,
- INDEX `fk_product_i18n_locale` (`locale_id` ASC) ,
- INDEX `fk_product_i18n_product` (`product_id` ASC) ,
- CONSTRAINT `fk_product_i18n_locale`
- FOREIGN KEY (`locale_id` )
- REFERENCES `mydb`.`locale` (`id` )
- ON DELETE CASCADE
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_product_i18n_product`
- FOREIGN KEY (`product_id` )
- REFERENCES `mydb`.`product` (`id` )
- ON DELETE CASCADE
- 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