MwvXW8d9

1-- -----------------------------------------------------
2-- Table `kdict2`.`word_lang`
3-- -----------------------------------------------------
4CREATE  TABLE IF NOT EXISTS `kdict2`.`word_lang` (
5  `word_id` INT UNSIGNED NOT NULL ,
6  `word` TINYTEXT NOT NULL ,
7  `lang_code` VARCHAR(2) NOT NULL ,
8  `word_type_id` INT UNSIGNED NOT NULL ,
9  `pronunciation` TINYTEXT NULL ,
10  `slug_url` TINYTEXT NULL ,
11  `slug_url_crc` INT(10) UNSIGNED NULL ,
12  PRIMARY KEY (`word_id`) ,
13  INDEX `fk_word_lang_word1` (`word_id` ASC) ,
14  INDEX `fk_word_lang_word_type1` (`word_type_id` ASC) ,
15  CONSTRAINT `fk_word_lang_word1`
16    FOREIGN KEY (`word_id` )
17    REFERENCES `kdict2`.`word` (`id` )
18    ON DELETE NO ACTION
19    ON UPDATE NO ACTION,
20  CONSTRAINT `fk_word_lang_word_type1`
21    FOREIGN KEY (`word_type_id` )
22    REFERENCES `kdict2`.`word_type` (`id` )
23    ON DELETE NO ACTION
24    ON UPDATE NO ACTION)
25ENGINE = InnoDB;