zCwFEkKa

1#adoTorony
2DROP TABLE IF EXISTS `adoHibaKod`;
3DROP TABLE IF EXISTS `toronyEszkozok`;
4DROP TABLE IF EXISTS `toronyhibaJegy`;
5DROP TABLE IF EXISTS `adoTorony`;
6CREATE TABLE 
7`adoTorony` (
8	`id` MEDIUMINT(8) unsigned NOT NULL AUTO_INCREMENT,
9	`nev` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_hungarian_ci DEFAULT '',
10	`cim` VARCHAR(30) DEFAULT '',
11	`toronygazda` MEDIUMINT(8) unsigned,
12	PRIMARY KEY (`id`),
13	KEY `toronygazda` (`toronygazda`),
14	CONSTRAINT `adoTorony_ibfk_1` FOREIGN KEY (`toronygazda`) REFERENCES `partnertorzs` (`id`)
15)  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
16
17#ToronyEszkozok
18DROP TABLE IF EXISTS `toronyEszkozok`;
19CREATE TABLE
20 `toronyEszkozok` (
21
22	`id` MEDIUMINT(8) unsigned NOT NULL AUTO_INCREMENT,
23	`nev` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_hungarian_ci DEFAULT '',
24	`gyarto` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_hungarian_ci DEFAULT '',
25	`tipus` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_hungarian_ci DEFAULT '',
26	`freq` TINYINT(3),
27	`toronyId` MEDIUMINT(8) unsigned,
28	PRIMARY KEY (`id`),
29	KEY `toronyId` (`toronyId`),
30	CONSTRAINT `toronyEszkozok_ibfk_1` FOREIGN KEY (`toronyId`) REFERENCES `adoTorony` (`id`)
31)  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
32
33#adoHibaKod
34DROP TABLE IF EXISTS `adoHibaKod`;
35CREATE TABLE `adoHibaKod` (
36  `id` MEDIUMINT(8) unsigned NOT NULL AUTO_INCREMENT,
37  `nev` varchar(255) COLLATE utf8_hungarian_ci DEFAULT NULL,
38  PRIMARY KEY (`id`),
39  UNIQUE KEY `nev` (`nev`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
41INSERT INTO `adoHibaKod` (nev) VALUES('Hiba');
42INSERT INTO `adoHibaKod` (nev) VALUES('Fejlesztés');
43
44#toronyHibaJegy
45DROP TABLE IF EXISTS `toronyhibaJegy`;
46CREATE TABLE `toronyhibaJegy` (
47  `id` MEDIUMINT(8) unsigned NOT NULL AUTO_INCREMENT,
48  `nyitoDatum` datetime NOT NULL,
49  `lezarasDatum` datetime DEFAULT NULL,
50  `bejelentettHiba` mediumtext COLLATE utf8_hungarian_ci,
51  `elvegzettMunka` mediumtext COLLATE utf8_hungarian_ci,
52  `adoTorony` MEDIUMINT(8) unsigned DEFAULT NULL,
53  `torlendo` tinyint(1) DEFAULT '0',
54  `adoHibaKod` MEDIUMINT(8) unsigned DEFAULT NULL,
55  `hibaJavitasDatuma` datetime DEFAULT NULL,
56  `rendszerhiba` tinyint(1) DEFAULT '0',
57  `szerelo` smallint(5) unsigned DEFAULT NULL,
58  `statusz` tinyint(1) DEFAULT '1',
59  `tenylegesHiba` mediumtext COLLATE utf8_hungarian_ci,
60  `munkaKoteg` tinyint(3) unsigned DEFAULT NULL,
61  `rendszam` varchar(255) COLLATE utf8_hungarian_ci DEFAULT 'NULL',
62  `visszahivni` tinyint(1) unsigned DEFAULT '0',
63  PRIMARY KEY (`id`),
64  KEY `adoTorony` (`adoTorony`),
65  KEY `adoHibaKod` (`adoHibaKod`),
66  KEY `szerelo` (`szerelo`),
67  CONSTRAINT `toronyHibaJegy_ibfk_1` FOREIGN KEY (`adoTorony`) REFERENCES `adoTorony` (`id`) ON DELETE CASCADE,
68  CONSTRAINT `toronyHibaJegy_ibfk_2` FOREIGN KEY (`adoHibaKod`) REFERENCES `adoHibaKod` (`id`),
69  CONSTRAINT `toronyHibaJegy_ibfk_3` FOREIGN KEY (`szerelo`) REFERENCES `szerelok` (`id`)
70) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;