Revize c05b3ed9

refs #6953: Odstranena zavislost na nazvu databaze.

db/v01__base_schema.sql

@@ -8 +8 @@
 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
 
 -- -----------------------------------------------------
--- Schema prujezd_vozidel
+-- Table `mesto`
 -- -----------------------------------------------------
-DROP SCHEMA IF EXISTS `prujezd_vozidel` ;
+DROP TABLE IF EXISTS `mesto` ;
 
--- -----------------------------------------------------
--- Schema prujezd_vozidel
--- -----------------------------------------------------
-CREATE SCHEMA IF NOT EXISTS `prujezd_vozidel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
-USE `prujezd_vozidel` ;
-
--- -----------------------------------------------------
--- Table `prujezd_vozidel`.`mesto`
--- -----------------------------------------------------
-DROP TABLE IF EXISTS `prujezd_vozidel`.`mesto` ;
-
-CREATE TABLE IF NOT EXISTS `prujezd_vozidel`.`mesto` (
+CREATE TABLE IF NOT EXISTS `mesto` (
   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
   `nazev` VARCHAR(100) NOT NULL,
   PRIMARY KEY (`id`))
@@ -31 +20 @@
 
 
 -- -----------------------------------------------------
--- Table `prujezd_vozidel`.`ulice`
+-- Table `ulice`
 -- -----------------------------------------------------
-DROP TABLE IF EXISTS `prujezd_vozidel`.`ulice` ;
+DROP TABLE IF EXISTS `ulice` ;
 
-CREATE TABLE IF NOT EXISTS `prujezd_vozidel`.`ulice` (
+CREATE TABLE IF NOT EXISTS `ulice` (
   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
   `nazev` VARCHAR(255) NOT NULL,
   `mesto_id` BIGINT(20) NOT NULL,
@@ -43 +32 @@
   INDEX `fk_ulice_mesto_idx` (`mesto_id` ASC),
   CONSTRAINT `fk_ulice_mesto`
     FOREIGN KEY (`mesto_id`)
-    REFERENCES `prujezd_vozidel`.`mesto` (`id`)
+    REFERENCES `mesto` (`id`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION)
 ENGINE = InnoDB;
 
 
 -- -----------------------------------------------------
--- Table `prujezd_vozidel`.`zarizeni`
+-- Table `zarizeni`
 -- -----------------------------------------------------
-DROP TABLE IF EXISTS `prujezd_vozidel`.`zarizeni` ;
+DROP TABLE IF EXISTS `zarizeni` ;
 
-CREATE TABLE IF NOT EXISTS `prujezd_vozidel`.`zarizeni` (
+CREATE TABLE IF NOT EXISTS `zarizeni` (
   `id` VARCHAR(20) NOT NULL COMMENT 'Odpovídá idDevice v location.csv.',
   `smer_popis` VARCHAR(255) NOT NULL COMMENT 'Odpovídá Name v locations.csv.',
   `stav` INT NOT NULL,
@@ -63 +52 @@
   INDEX `fk_zarizeni_ulice1_idx` (`ulice_id` ASC),
   CONSTRAINT `fk_zarizeni_ulice1`
     FOREIGN KEY (`ulice_id`)
-    REFERENCES `prujezd_vozidel`.`ulice` (`id`)
+    REFERENCES `ulice` (`id`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION)
 ENGINE = InnoDB;
 
 
 -- -----------------------------------------------------
--- Table `prujezd_vozidel`.`zaznam_cas`
+-- Table `zaznam_cas`
 -- -----------------------------------------------------
-DROP TABLE IF EXISTS `prujezd_vozidel`.`zaznam_cas` ;
+DROP TABLE IF EXISTS `zaznam_cas` ;
 
-CREATE TABLE IF NOT EXISTS `prujezd_vozidel`.`zaznam_cas` (
+CREATE TABLE IF NOT EXISTS `zaznam_cas` (
   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
   `datetime_od` DATETIME NOT NULL,
   `datetime_do` DATETIME NOT NULL,
@@ -84 +73 @@
   INDEX `fk_zaznam_cas_zarizeni1_idx` (`zarizeni_id` ASC),
   CONSTRAINT `fk_zaznam_cas_zarizeni1`
     FOREIGN KEY (`zarizeni_id`)
-    REFERENCES `prujezd_vozidel`.`zarizeni` (`id`)
+    REFERENCES `zarizeni` (`id`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION)
 ENGINE = InnoDB;
 
 
 -- -----------------------------------------------------
--- Table `prujezd_vozidel`.`vozidla`
+-- Table `vozidla`
 -- -----------------------------------------------------
-DROP TABLE IF EXISTS `prujezd_vozidel`.`vozidla` ;
+DROP TABLE IF EXISTS `vozidla` ;
 
-CREATE TABLE IF NOT EXISTS `prujezd_vozidel`.`vozidla` (
+CREATE TABLE IF NOT EXISTS `vozidla` (
   `id` BIGINT(20) NOT NULL COMMENT 'Odpovídá číslu skupiny vozidla (TypVozidla10 v csv souboru s daty). Hodnoty 0-10.',
   `nazev` VARCHAR(45) NOT NULL,
   PRIMARY KEY (`id`))
@@ -103 +92 @@
 
 
 -- -----------------------------------------------------
--- Table `prujezd_vozidel`.`zaznam`
+-- Table `zaznam`
 -- -----------------------------------------------------
-DROP TABLE IF EXISTS `prujezd_vozidel`.`zaznam` ;
+DROP TABLE IF EXISTS `zaznam` ;
 
-CREATE TABLE IF NOT EXISTS `prujezd_vozidel`.`zaznam` (
+CREATE TABLE IF NOT EXISTS `zaznam` (
   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
   `vozidla_pocet` INT NOT NULL,
   `rychlost_prumer` DOUBLE NOT NULL,
@@ -118 +107 @@
   INDEX `fk_zaznam_zaznam_cas1_idx` (`zaznam_cas_id` ASC),
   CONSTRAINT `fk_zaznam_vozidla1`
     FOREIGN KEY (`vozidla_id`)
-    REFERENCES `prujezd_vozidel`.`vozidla` (`id`)
+    REFERENCES `vozidla` (`id`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION,
   CONSTRAINT `fk_zaznam_zaznam_cas1`
     FOREIGN KEY (`zaznam_cas_id`)
-    REFERENCES `prujezd_vozidel`.`zaznam_cas` (`id`)
+    REFERENCES `zaznam_cas` (`id`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION)
 ENGINE = InnoDB;

db/v02__data_10_04_2018.sql

@@ -16 +16 @@
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 /*!40101 SET NAMES utf8 */;
 
---
--- Databáze: `prujezd_vozidel`
---
-
--- --------------------------------------------------------
-
 
 --
 -- Vypisuji data pro tabulku `mesto`

db/v03__vozidlo_rename.sql

@@ -1 +1 @@
 -- prejmenovani tabulky vozidla
-rename table `prujezd_vozidel`.`vozidla` to `prujezd_vozidel`.`vozidlo`;
+rename table `vozidla` to `vozidlo`;
 
 -- update ciziho klice
-alter table `prujezd_vozidel`.`zaznam` change column `vozidla_id` `vozidlo_id` bigint(20);
+alter table `zaznam` change column `vozidla_id` `vozidlo_id` bigint(20);