ktxHp3qK

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `shop` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
6USE `shop` ;
7
8-- -----------------------------------------------------
9-- Table `shop`.`musteri`
10-- -----------------------------------------------------
11DROP TABLE IF EXISTS `shop`.`musteri` ;
12
13CREATE  TABLE IF NOT EXISTS `shop`.`musteri` (
14  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
15  `isim` VARCHAR(45) NOT NULL ,
16  PRIMARY KEY (`id`) )
17ENGINE = InnoDB;
18
19
20-- -----------------------------------------------------
21-- Table `shop`.`urun`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `shop`.`urun` ;
24
25CREATE  TABLE IF NOT EXISTS `shop`.`urun` (
26  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
27  `baslik` VARCHAR(255) NULL ,
28  `fiyat` FLOAT UNSIGNED NOT NULL ,
29  PRIMARY KEY (`id`) )
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `shop`.`adres`
35-- -----------------------------------------------------
36DROP TABLE IF EXISTS `shop`.`adres` ;
37
38CREATE  TABLE IF NOT EXISTS `shop`.`adres` (
39  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
40  `musteri_id` INT UNSIGNED NOT NULL ,
41  `adres` VARCHAR(255) NULL ,
42  INDEX `fk_musteri_adres_musteri_id` (`musteri_id` ASC) ,
43  PRIMARY KEY (`id`) ,
44  CONSTRAINT `fk_musteri_adres_musteri_id`
45    FOREIGN KEY (`musteri_id` )
46    REFERENCES `shop`.`musteri` (`id` )
47    ON DELETE CASCADE
48    ON UPDATE NO ACTION)
49ENGINE = InnoDB;
50
51
52-- -----------------------------------------------------
53-- Table `shop`.`siparis`
54-- -----------------------------------------------------
55DROP TABLE IF EXISTS `shop`.`siparis` ;
56
57CREATE  TABLE IF NOT EXISTS `shop`.`siparis` (
58  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
59  `musteri_id` INT UNSIGNED NOT NULL ,
60  `urun_id` INT UNSIGNED NOT NULL ,
61  `address_id` INT UNSIGNED NOT NULL ,
62  INDEX `fk_musteri_siparis_musteri_id` (`musteri_id` ASC) ,
63  INDEX `fk_urun_siparis_urun_id` (`urun_id` ASC) ,
64  INDEX `fk_adres_siparis_adres_id` (`address_id` ASC) ,
65  PRIMARY KEY (`id`) ,
66  CONSTRAINT `fk_musteri_siparis_musteri_id`
67    FOREIGN KEY (`musteri_id` )
68    REFERENCES `shop`.`musteri` (`id` )
69    ON DELETE CASCADE
70    ON UPDATE NO ACTION,
71  CONSTRAINT `fk_urun_siparis_urun_id`
72    FOREIGN KEY (`urun_id` )
73    REFERENCES `shop`.`urun` (`id` )
74    ON DELETE CASCADE
75    ON UPDATE NO ACTION,
76  CONSTRAINT `fk_adres_siparis_adres_id`
77    FOREIGN KEY (`address_id` )
78    REFERENCES `shop`.`adres` (`id` )
79    ON DELETE CASCADE
80    ON UPDATE NO ACTION)
81ENGINE = InnoDB;
82
83
84
85SET SQL_MODE=@OLD_SQL_MODE;
86SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
87SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;