J0mE97YG

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5 DROP SCHEMA IF EXISTS `testdb`;
6 CREATE SCHEMA IF NOT EXISTS `testdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
7 USE `testdb`;
8
9 DROP TABLE IF EXISTS `testdb`.`table1` ;
10
11 CREATE  TABLE IF NOT EXISTS `testdb`.`table1` (
12   `id` INT UNSIGNED NOT NULL ,
13   `field1` VARCHAR(50) NULL ,
14   PRIMARY KEY (`id`) )
15 ENGINE = InnoDB;
16
17
18
19 DROP TABLE IF EXISTS `testdb`.`table2` ;
20
21 CREATE  TABLE IF NOT EXISTS `testdb`.`table2` (
22   `id` INT NOT NULL AUTO_INCREMENT ,
23   `field1` VARCHAR(50) NULL ,
24   `date` DATE NULL ,
25   `cnt` INT NULL ,
26   PRIMARY KEY (`id`) ,
27   INDEX `FK_table2_table1` (`field1` ASC) ,
28   CONSTRAINT `FK_table2_table1`
29  FOREIGN KEY (`field1`)
30  REFERENCES `testdb`.`table1` (`field1` )
31  ON DELETE NO ACTION
32  ON UPDATE NO ACTION)
33 ENGINE = InnoDB;
34
35 SET SQL_MODE=@OLD_SQL_MODE;
36 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
37 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
38	
39CREATE  TABLE IF NOT EXISTS `testdb`.`table1` (
40   `id` INT UNSIGNED NOT NULL ,
41   `field1` VARCHAR(50) NULL ,
42   KEY ix_table1_field1 (field1),
43   PRIMARY KEY (`id`) )
44 ENGINE = InnoDB;