9LW0EkjR

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema bsp_int
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema bsp_int
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `bsp_int` DEFAULT CHARACTER SET utf8 ;
18USE `bsp_int` ;
19
20-- -----------------------------------------------------
21-- Table `bsp_int`.`cmentarze`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `bsp_int`.`cmentarze` (
24  `ID_CMENTARZA` INT(11) NOT NULL,
25  `LICZBA_MIEJSC` INT(11) NULL DEFAULT NULL,
26  `PRZYCHOD_ROCZNY` DECIMAL(8,2) NULL DEFAULT NULL,
27  `KOSZT_ROCZNY_UTRZYMANIA` DECIMAL(8,2) NULL DEFAULT NULL,
28  `ADR_MIEJSCOWOSC` VARCHAR(50) NULL DEFAULT NULL,
29  `ADR_ULICA` VARCHAR(50) NULL DEFAULT NULL,
30  `ADR_NUMER_BUDYNKU` INT(11) NULL DEFAULT NULL,
31  `ADR_NUMER_MIESZKANIA` INT(11) NULL DEFAULT NULL,
32  `ADR_KOD_POCZTOWY` VARCHAR(6) NULL DEFAULT NULL,
33  PRIMARY KEY (`ID_CMENTARZA`))
34ENGINE = InnoDB
35DEFAULT CHARACTER SET = utf8;
36
37
38-- -----------------------------------------------------
39-- Table `bsp_int`.`metadata`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `bsp_int`.`metadata` (
42  `ID_MD` INT(11) NOT NULL,
43  `ZRODLO` VARCHAR(50) NULL DEFAULT NULL,
44  `TB_KNC` VARCHAR(50) NULL DEFAULT NULL,
45  `CZAS` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
46  `ATR_K` VARCHAR(50) NULL DEFAULT NULL,
47  `ATR_P` VARCHAR(50) NULL DEFAULT NULL,
48  PRIMARY KEY (`ID_MD`))
49ENGINE = InnoDB
50DEFAULT CHARACTER SET = utf8;
51
52
53-- -----------------------------------------------------
54-- Table `bsp_int`.`osoby duchowne`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `bsp_int`.`osoby duchowne` (
57  `ID_OSOBY_DUCHOWWNEJ` INT(11) NOT NULL,
58  `IMIE` VARCHAR(50) NULL DEFAULT NULL,
59  `NAZWISKO` VARCHAR(50) NULL DEFAULT NULL,
60  `WIEK` DECIMAL(3,0) NULL DEFAULT NULL,
61  `DATA_SWIECEN` DATE NULL DEFAULT NULL,
62  `ROLA` VARCHAR(20) NULL DEFAULT NULL,
63  `PESEL` CHAR(11) NULL DEFAULT NULL,
64  PRIMARY KEY (`ID_OSOBY_DUCHOWWNEJ`))
65ENGINE = InnoDB
66DEFAULT CHARACTER SET = utf8;
67
68
69-- -----------------------------------------------------
70-- Table `bsp_int`.`parafie`
71-- -----------------------------------------------------
72CREATE TABLE IF NOT EXISTS `bsp_int`.`parafie` (
73  `ID_PARAFI` INT(11) NOT NULL,
74  `NAZWA` VARCHAR(50) NULL DEFAULT NULL,
75  `MIEJSCOWOSC` VARCHAR(50) NOT NULL,
76  PRIMARY KEY (`ID_PARAFI`))
77ENGINE = InnoDB
78DEFAULT CHARACTER SET = utf8;
79
80
81-- -----------------------------------------------------
82-- Table `bsp_int`.`swiatynie`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `bsp_int`.`swiatynie` (
85  `ID_SWIATYNI` INT(11) NOT NULL,
86  `NAZWA` VARCHAR(50) NULL DEFAULT NULL,
87  `KOSZT_OGRZEWANIA` DECIMAL(8,2) NULL DEFAULT NULL,
88  `POJEMNOSC` INT(11) NULL DEFAULT NULL,
89  `ADR_MIEJSCOWOSC` VARCHAR(50) NULL DEFAULT NULL,
90  `ADR_ULICA` VARCHAR(50) NULL DEFAULT NULL,
91  `ADR_NUMER_BUDYNKU` INT(11) NULL DEFAULT NULL,
92  `ADR_NUMER_MIESZKANIA` INT(11) NULL DEFAULT NULL,
93  `ADR_KOD_POCZTOWY` VARCHAR(6) NULL DEFAULT NULL,
94  PRIMARY KEY (`ID_SWIATYNI`))
95ENGINE = InnoDB
96DEFAULT CHARACTER SET = utf8;
97
98
99SET SQL_MODE=@OLD_SQL_MODE;
100SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
101SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;