-- http://www.phpmyadmin.net
--
-- Gép: 127.0.0.1
-- Létrehozás ideje: 2016. Aug 30. 16:17
-- Kiszolgáló verziója: 10.1.10-MariaDB
-- PHP verzió: 5.6.19




--
-- Adatbázis: `solidus`
--

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `lakas`
--

CREATE TABLE `lakas` (
  `id` int(3) NOT NULL,
  `epulet` varchar(3) COLLATE utf8_hungarian_ci NOT NULL,
  `tipus` varchar(10) COLLATE utf8_hungarian_ci NOT NULL,
  `lakasszam` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
  `emelet` varchar(10) COLLATE utf8_hungarian_ci NOT NULL,
  `szobaszam` int(3) NOT NULL,
  `teljes_alapterulet` decimal(10,2) NOT NULL,
  `vetelar` int(20) NOT NULL,
  `kep` text COLLATE utf8_hungarian_ci NOT NULL,
  `leiras` text COLLATE utf8_hungarian_ci NOT NULL,
  `elkelt` tinyint(4) NOT NULL,
  `nappali` decimal(10,2) NOT NULL,
  `szoba1` decimal(10,2) NOT NULL,
  `szoba2` decimal(10,2) NOT NULL,
  `szoba3` decimal(10,2) NOT NULL,
  `konyha` decimal(10,2) NOT NULL,
  `kozlekedo` decimal(10,2) NOT NULL,
  `wc` decimal(10,2) NOT NULL,
  `furdo` decimal(10,2) NOT NULL,
  `gardrob` decimal(10,2) NOT NULL,
  `terasz` decimal(10,2) NOT NULL,
  `kamra` decimal(10,2) NOT NULL,
  `nappali_etkezo` decimal(10,2) NOT NULL,
  `konyha_etkezo` decimal(10,2) NOT NULL,
  `etkezo` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `lakas`
--

INSERT INTO `lakas` (`id`, `epulet`, `tipus`, `lakasszam`, `emelet`, `szobaszam`, `teljes_alapterulet`, `vetelar`, `kep`, `leiras`, `elkelt`, `nappali`, `szoba1`, `szoba2`, `szoba3`, `konyha`, `kozlekedo`, `wc`, `furdo`, `gardrob`, `terasz`, `kamra`, `nappali_etkezo`, `konyha_etkezo`, `etkezo`) VALUES
(36, 'A', 'Lakas', 'L1', '1', 3, '75.22', 23036800, 'A.1.L1.jpg', '', 0, '21.06', '12.07', '12.07', '0.00', '6.80', '2.15', '5.88', '4.87', '0.00', '0.00', '0.00', '3.84', '0.00'),
(37, 'A', 'Lakas', 'L2', '1', 3, '71.00', 22035200, 'A.1.L2.jpg', '', 0, '18.81', '12.01', '9.29', '0.00', '0.00', '1.92', '4.37', '3.33', '0.00', '0.00', '0.00', '8.14', '0.00'),
(39, 'A', 'Lakas', 'L3', '2', 3, '75.00', 23036800, 'A.2.L3.jpg', '', 0, '21.06', '12.07', '12.10', '0.00', '0.00', '2.15', '5.88', '4.87', '0.00', '0.00', '0.00', '3.84', '0.00'),
(40, 'A', 'Lakas', 'L4', '2', 3, '71.00', 22035200, 'A.2.L4.jpg', '', 0, '18.81', '12.01', '9.29', '0.00', '0.00', '1.92', '4.37', '3.33', '0.00', '0.00', '0.00', '8.14', '0.00'),
(41, 'A', 'Lakas', 'L5', 'TT', 2, '76.00', 20912000, 'A.TT.L5.jpg', '', 0, '0.00', '21.11', '0.00', '6.96', '0.00', '0.00', '7.38', '0.00', '0.00', '0.00', '28.08', '0.00', '0.00'),
(42, 'A', 'Lakas', 'L6', 'TT', 2, '70.00', 18400000, 'A.TT.L6.jpg', '', 0, '0.00', '17.73', '0.00', '6.62', '0.00', '0.00', '5.26', '0.00', '0.00', '0.00', '27.91', '0.00', '0.00'),
(43, 'B', 'Lakas', 'L1', 'Fsz', 1, '41.00', 12160000, 'B.Fsz.L1.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(44, 'B', 'Lakas', 'L2', 'Fsz', 2, '60.00', 16560000, 'B.Fsz.L2.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(45, 'B', 'Lakas', 'L3', 'Fsz', 2, '60.00', 16560000, 'B.Fsz.L3.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(46, 'B', 'Lakas', 'L4', 'Fsz', 2, '50.00', 14924800, 'B.Fsz.L4.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(47, 'B', 'Lakas', 'L5', '1', 2, '52.00', 15315200, 'B.1.L5.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(48, 'B', 'Lakas', 'L6', '1', 2, '53.00', 15414400, 'B.1.L6.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(49, 'B', 'Lakas', 'L7', '1', 2, '53.00', 15414400, 'B.1.L7.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(50, 'B', 'Lakas', 'L8', '1', 2, '50.00', 14969600, 'B.1.L8.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(51, 'B', 'Lakas', 'L9', '2', 2, '52.00', 15315200, 'B.2.L9.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(52, 'B', 'Lakas', 'L10', '2', 2, '53.00', 15414400, 'B.2.L10.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(53, 'B', 'Lakas', 'L11', '2', 2, '53.00', 15414400, 'B.2.L11.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(54, 'B', 'Lakas', 'L12', '2', 2, '50.00', 14969600, 'B.2.L12.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(55, 'B', 'Lakas', 'L13', 'TT', 4, '101.00', 27334400, 'B.TT.L13.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(56, 'B', 'Lakas', 'L14', 'TT', 4, '114.00', 29939200, 'B.TT.L14.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(57, 'C', 'Lakas', 'L1', 'Fsz', 1, '41.00', 12160000, 'C.Fsz.L1.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(58, 'C', 'Lakas', 'L2', 'Fsz', 2, '60.00', 16560000, 'C.Fsz.L2.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(59, 'C', 'Lakas', 'L3', 'Fsz', 2, '60.00', 16560000, 'C.Fsz.L3.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(60, 'C', 'Lakas', 'L4', 'Fsz', 2, '50.00', 14924800, 'C.Fsz.L4.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(61, 'C', 'Lakas', 'L5', '1', 2, '52.00', 15315200, 'C.1.L5.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(62, 'C', 'Lakas', 'L6', '1', 2, '53.00', 15414400, 'C.1.L6.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(63, 'C', 'Lakas', 'L7', '1', 2, '53.00', 15414400, 'C.1.L7.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(64, 'C', 'Lakas', 'L8', '1', 2, '50.00', 14969600, 'C.1.L8.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(65, 'C', 'Lakas', 'L9', '2', 2, '52.00', 15315200, 'C.2.L9.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(66, 'C', 'Lakas', 'L10', '2', 2, '53.00', 15414400, 'C.2.L10.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(67, 'C', 'Lakas', 'L11', '2', 2, '53.00', 15414400, 'C.2.L11.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(68, 'C', 'Lakas', 'L12', '2', 2, '50.00', 14969600, 'C.2.L12.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(69, 'C', 'Lakas', 'L13', 'TT', 4, '101.00', 27334400, 'C.TT.L13.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(70, 'C', 'Lakas', 'L14', 'TT', 4, '114.00', 29939200, 'C.TT.L14.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(71, 'D', 'Lakas', 'L1', 'Fsz', 2, '58.00', 17334000, 'D.Fsz.L1.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(72, 'D', 'Lakas', 'L2', 'Fsz', 3, '104.00', 27747200, 'D.Fsz.L2.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(73, 'D', 'Lakas', 'L3', 'Fsz', 2, '61.00', 17827200, 'D.Fsz.L3.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(74, 'D', 'Lakas', 'L4', '1', 2, '58.00', 17344000, 'D.1.L4.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(75, 'D', 'Lakas', 'L5', '1', 3, '88.00', 25228800, 'D.1.L5.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(76, 'D', 'Lakas', 'L6', '1', 2, '58.00', 17344000, 'D.1.L6.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(77, 'D', 'Lakas', 'L7', '2', 2, '58.00', 17398200, 'D.2.L7.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(78, 'D', 'Lakas', 'L8', '2', 3, '88.00', 25438000, 'D.2.L8.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(79, 'D', 'Lakas', 'L9', '2', 2, '58.00', 17506600, 'D.2.L9.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(80, 'D', 'Lakas', 'L10', 'TT', 2, '55.00', 15273360, 'D.TT.L10.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(81, 'D', 'Lakas', 'L11', 'TT', 3, '97.00', 26126750, 'D.TT.L11.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(82, 'D', 'Lakas', 'L12', 'TT', 2, '55.00', 15367640, 'D.TT.L12.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(83, 'E', 'Lakas', 'L1', 'Fsz', 2, '58.67', 17344000, 'E_Fsz_L1.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(84, 'E', 'Lakas', 'L2', 'Fsz', 3, '104.00', 27747200, 'E_Fsz_L2.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(85, 'E', 'Lakas', 'L3', 'Fsz', 2, '61.69', 17827200, 'E_Fsz_L3.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(87, 'E', 'Lakas', 'L5', '1', 3, '88.27', 25228800, 'E_1_L5.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(88, 'E', 'Lakas', 'L6', '1', 2, '58.67', 17344000, 'E_1_L6.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(89, 'E', 'Lakas', 'L7', '2', 2, '58.67', 17344000, 'E_2_L7.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(90, 'E', 'Lakas', 'L8', '2', 3, '88.43', 25280000, 'E_2_L8.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(91, 'E', 'Lakas', 'L9', '2', 2, '58.67', 17344000, 'E_2_L9.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(92, 'E', 'Lakas', 'L10', 'TT', 2, '55.01', 15084800, 'E_TT_L10.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(93, 'E', 'Lakas', 'L11', 'TT', 3, '97.05', 24844800, 'E_TT_L11.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(94, 'E', 'Lakas', 'L12', 'TT', 2, '55.01', 1504800, 'E_TT_L12.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(95, 'F', 'Lakas', 'L1', 'Fsz', 3, '63.40', 19404800, 'F_Fsz_L1.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(96, 'F', 'Lakas', 'L2', 'Fsz', 3, '63.40', 19404800, 'F_Fsz_L2.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(97, 'F', 'Lakas', 'L3', '1', 3, '63.40', 19404800, 'F_1_L3.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(98, 'F', 'Lakas', 'L4', '1', 3, '63.40', 19404800, 'F_1_L4.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(99, 'F', 'Lakas', 'L5', '2', 3, '63.40', 19404800, 'F_2_L5.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
(100, 'F', 'Lakas', 'L6', '2', 3, '63.40', 19404800, 'F_2_L6.jpg', '', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00');

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `lakasadatok`
--

CREATE TABLE `lakasadatok` (
  `id` int(11) NOT NULL,
  `lakas_id` int(11) NOT NULL,
  `nappali` decimal(10,2) NOT NULL,
  `szoba1` decimal(10,2) NOT NULL,
  `szoba2` decimal(10,2) NOT NULL,
  `szoba3` decimal(10,2) NOT NULL,
  `konyha` decimal(10,2) NOT NULL,
  `kozlekedo` decimal(10,2) NOT NULL,
  `wc` decimal(10,2) NOT NULL,
  `furdo` decimal(10,2) NOT NULL,
  `gardrob` decimal(10,2) NOT NULL,
  `terasz` decimal(10,2) NOT NULL,
  `kamra` decimal(10,2) NOT NULL,
  `nappali+etkezo` decimal(10,2) NOT NULL,
  `konyha+etkezo` decimal(10,2) NOT NULL,
  `etkezo` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `szintek`
--

CREATE TABLE `szintek` (
  `id` int(11) NOT NULL,
  `epulet` varchar(2) COLLATE utf8_hungarian_ci NOT NULL,
  `emelet` varchar(10) COLLATE utf8_hungarian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- Indexek a kiírt táblákhoz
--

--
-- A tábla indexei `lakas`
--
ALTER TABLE `lakas`
  ADD PRIMARY KEY (`id`);

--
-- A tábla indexei `lakasadatok`
--
ALTER TABLE `lakasadatok`
  ADD PRIMARY KEY (`id`);

--
-- A tábla indexei `szintek`
--
ALTER TABLE `szintek`
  ADD PRIMARY KEY (`id`);

--
-- A kiírt táblák AUTO_INCREMENT értéke
--

--
-- AUTO_INCREMENT a táblához `lakas`
--
ALTER TABLE `lakas`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;
--
-- AUTO_INCREMENT a táblához `lakasadatok`
--
ALTER TABLE `lakasadatok`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT a táblához `szintek`
--
ALTER TABLE `szintek`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
