VYmncSLt

1-- --------------------------------------------------------
2-- Host:                         localhost
3-- Wersja serwera:               5.5.39 - MySQL Community Server (GPL)
4-- Serwer OS:                    Win32
5-- HeidiSQL Wersja:              9.2.0.4967
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Zrzut struktury tabela bill_db_sys.akcja
14CREATE TABLE IF NOT EXISTS `akcja` (
15  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
16  `typ` int(10) unsigned NOT NULL,
17  `klient_id` int(10) unsigned DEFAULT NULL,
18  `umowa_id` int(10) unsigned DEFAULT NULL,
19  `nieruchomosc_id` int(11) unsigned DEFAULT NULL,
20  `pracownik_id` int(10) unsigned DEFAULT NULL,
21  `poprzednio` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
22  `teraz` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
23  `dodano` datetime NOT NULL,
24  PRIMARY KEY (`id`),
25  KEY `FK_akcja_akcja_typ` (`typ`),
26  KEY `FK_akcja_klient` (`klient_id`),
27  KEY `FK_akcja_umowa` (`umowa_id`),
28  KEY `FK_akcja_nieruchomosc` (`nieruchomosc_id`),
29  KEY `FK_akcja_pracownicy` (`pracownik_id`),
30  CONSTRAINT `FK_akcja_akcja_typ` FOREIGN KEY (`typ`) REFERENCES `akcja_typ` (`id`) ON UPDATE CASCADE,
31  CONSTRAINT `FK_akcja_klient` FOREIGN KEY (`klient_id`) REFERENCES `klient` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
32  CONSTRAINT `FK_akcja_nieruchomosc` FOREIGN KEY (`nieruchomosc_id`) REFERENCES `nieruchomosc` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
33  CONSTRAINT `FK_akcja_pracownicy` FOREIGN KEY (`pracownik_id`) REFERENCES `pracownicy` (`id`) ON UPDATE CASCADE,
34  CONSTRAINT `FK_akcja_umowa` FOREIGN KEY (`umowa_id`) REFERENCES `umowa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
36
37-- Data exporting was unselected.
38/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
39/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
40/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;