SHARE
TWEET

Untitled

a guest Jan 19th, 2020 80 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- -----------------------------------------------------
  2. -- Table `se77uhiSyu`.`Wizyta`
  3. -- -----------------------------------------------------
  4. CREATE TABLE IF NOT EXISTS `Wizyta` (
  5.   `id` INT NOT NULL AUTO_INCREMENT,
  6.   `Czas wejścia` DATE NULL,
  7.   `Czas wyjścia` DATE NULL,
  8.   PRIMARY KEY (`id`))
  9. ENGINE = InnoDB;
  10.  
  11.  
  12. -- -----------------------------------------------------
  13. -- Table `se77uhiSyu`.`Wybieg`
  14. -- -----------------------------------------------------
  15. CREATE TABLE IF NOT EXISTS `Wybieg` (
  16.   `id` INT NOT NULL AUTO_INCREMENT,
  17.   `Lokalizacja` VARCHAR(45) NULL,
  18.   `Dostępność` TINYINT NULL,
  19.   PRIMARY KEY (`id`))
  20. ENGINE = InnoDB;
  21.  
  22.  
  23. -- -----------------------------------------------------
  24. -- Table `se77uhiSyu`.`Zwierzę`
  25. -- -----------------------------------------------------
  26. CREATE TABLE IF NOT EXISTS `Zwierzę` (
  27.   `id` INT NOT NULL AUTO_INCREMENT,
  28.   `Nazwa` VARCHAR(45) NULL,
  29.   `Gatunek` VARCHAR(45) NULL,
  30.   `Wiek` VARCHAR(45) NULL,
  31.   `Miejsce` VARCHAR(45) NULL,
  32.   `Dostępność` TINYINT NULL,
  33.   `Wybieg_id` INT NOT NULL,
  34.   PRIMARY KEY (`id`),
  35.   INDEX `fk_Zwierzę_Wybieg1_idx` (`Wybieg_id`)
  36. )
  37. ENGINE = InnoDB;
  38.  
  39.  
  40. -- -----------------------------------------------------
  41. -- Table `se77uhiSyu`.`Bilet`
  42. -- -----------------------------------------------------
  43. CREATE TABLE IF NOT EXISTS `Bilet` (
  44.   `id` INT NOT NULL AUTO_INCREMENT,
  45.   `Data` DATETIME NULL,
  46.   `Cena` DOUBLE NULL,
  47.   `Zniżka` TINYINT NULL,
  48.   `Wizyta_id` INT NOT NULL,
  49.   PRIMARY KEY (`id`),
  50.   INDEX `fk_Bilet_Wizyta1_idx` (`Wizyta_id`)
  51. )
  52. ENGINE = InnoDB;
  53.  
  54.  
  55. -- -----------------------------------------------------
  56. -- Table `se77uhiSyu`.`Klient`
  57. -- -----------------------------------------------------
  58. CREATE TABLE IF NOT EXISTS `Klient` (
  59.   `id` INT NOT NULL AUTO_INCREMENT,
  60.   `Imię` VARCHAR(45) NULL,
  61.   `Nazwisko` VARCHAR(45) NULL,
  62.   `E-mail` VARCHAR(45) NULL,
  63.   `Telefon` VARCHAR(45) NULL,
  64.   `Wizyta_id` INT NOT NULL,
  65.   PRIMARY KEY (`id`),
  66.   INDEX `fk_Klient_Wizyta1_idx` (`Wizyta_id`)
  67. )
  68. ENGINE = InnoDB;
  69.  
  70.  
  71. -- -----------------------------------------------------
  72. -- Table `se77uhiSyu`.`Atrakcje`
  73. -- -----------------------------------------------------
  74. CREATE TABLE IF NOT EXISTS `Atrakcje` (
  75.   `id` INT NOT NULL AUTO_INCREMENT,
  76.   `Nazwa` VARCHAR(45) NULL,
  77.   `Lokalizacja` VARCHAR(45) NULL,
  78.   `Dostępność` TINYINT NULL,
  79.   `Wizyta_id` INT NOT NULL,
  80.   `Wybieg_id` INT NOT NULL,
  81.   PRIMARY KEY (`id`),
  82.   INDEX `fk_Atrakcje_Wizyta_idx` (`Wizyta_id`),
  83.   INDEX `fk_Atrakcje_Wybieg1_idx` (`Wybieg_id`)
  84. )
  85. ENGINE = InnoDB;
  86.  
  87.  
  88. -- -----------------------------------------------------
  89. -- Table `se77uhiSyu`.`Klient_Typ`
  90. -- -----------------------------------------------------
  91. CREATE TABLE IF NOT EXISTS `Klient_Typ` (
  92.   `idKlient_Typ` INT NOT NULL,
  93.   `Klient_id` INT NOT NULL,
  94.   PRIMARY KEY (`idKlient_Typ`),
  95.   INDEX `fk_Klient_Typ_Klient1_idx` (`Klient_id`)
  96. )
  97. ENGINE = InnoDB;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top