-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Gép: localhost
-- Létrehozás ideje: 2025. Máj 20. 10:23
-- Kiszolgáló verziója: 10.11.11-MariaDB-0+deb12u1
-- PHP verzió: 8.2.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Adatbázis: `KV_2018`
--

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

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

CREATE TABLE `opey_oecms_categories` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `parentid` bigint(20) NOT NULL DEFAULT 0,
  `modcat` tinyint(4) NOT NULL,
  `modname` varchar(255) DEFAULT NULL,
  `modid` int(11) NOT NULL,
  `dir` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `opey_oecms_categories` (`id`, `name`, `parentid`, `modcat`, `modname`, `modid`, `dir`) VALUES
(1, 'Arculat', 0, 0, NULL, 0, '/Arculat'),
(5, 'Képek', 0, 0, NULL, 0, '/Kpek'),
(169, 'jul_aug', 166, 0, NULL, 0, '/Hireink/2018/jul_aug'),
(170, 'oktdec', 166, 0, NULL, 0, '/Hireink/2018/oktdec'),
(171, '2019', 119, 0, NULL, 0, '/Hireink/2019'),
(172, '2020', 119, 0, NULL, 0, '/Hireink/2020'),
(173, '2021', 119, 0, NULL, 0, '/Hireink/2021'),
(174, '2022', 119, 0, NULL, 0, '/Hireink/2022'),
(175, '2023', 119, 0, NULL, 0, '/Hireink/2023'),
(30, 'Design 2010', 0, 0, NULL, 0, '/Design2010'),
(31, 'HUN', 30, 0, NULL, 0, '/Design2010/HUN'),
(33, 'Bal', 31, 0, NULL, 0, '/Design2010/HUN/Bal'),
(41, 'modules', 0, 0, NULL, 0, '/modules'),
(42, 'Blog', 41, 0, NULL, 0, '/modules/Blog'),
(43, '1', 42, 0, NULL, 0, '/modules/Blog/1'),
(44, '20101208', 43, 0, NULL, 0, '/modules/Blog/1/20101208'),
(45, '2', 42, 0, NULL, 0, '/modules/Blog/2'),
(46, 'blog_kepek', 43, 0, NULL, 0, '/modules/Blog/1/blog_kepek'),
(47, 'Blog', 30, 0, NULL, 0, '/Design2010/Blog'),
(49, '4', 42, 0, NULL, 0, '/modules/Blog/4'),
(51, '20110124', 49, 0, NULL, 0, '/modules/Blog/4/20110124'),
(52, '5', 42, 0, NULL, 0, '/modules/Blog/5'),
(53, '20110128', 52, 0, NULL, 0, '/modules/Blog/5/20110128'),
(54, '3', 42, 0, NULL, 0, '/modules/Blog/3'),
(55, '20110223', 52, 0, NULL, 0, '/modules/Blog/5/20110223'),
(57, '20110321', 49, 0, NULL, 0, '/modules/Blog/4/20110321'),
(58, '20110329', 52, 0, NULL, 0, '/modules/Blog/5/20110329'),
(59, '20110520', 52, 0, NULL, 0, '/modules/Blog/5/20110520'),
(60, '20110601', 49, 0, NULL, 0, '/modules/Blog/4/20110601'),
(61, '20110607', 52, 0, NULL, 0, '/modules/Blog/5/20110607'),
(62, '20110611', 54, 0, NULL, 0, '/modules/Blog/3/20110611'),
(63, '20110701', 52, 0, NULL, 0, '/modules/Blog/5/20110701'),
(64, '20110816', 52, 0, NULL, 0, '/modules/Blog/5/20110816'),
(65, '20111001', 52, 0, NULL, 0, '/modules/Blog/5/20111001'),
(66, '20111129', 54, 0, NULL, 0, '/modules/Blog/3/20111129'),
(67, '20111130', 49, 0, NULL, 0, '/modules/Blog/4/20111130'),
(68, '20111130', 54, 0, NULL, 0, '/modules/Blog/3/20111130'),
(69, '20111210', 52, 0, NULL, 0, '/modules/Blog/5/20111210'),
(70, '20111224', 49, 0, NULL, 0, '/modules/Blog/4/20111224'),
(71, '20120104', 49, 0, NULL, 0, '/modules/Blog/4/20120104'),
(72, '6', 42, 0, NULL, 0, '/modules/Blog/6'),
(73, '7', 42, 0, NULL, 0, '/modules/Blog/7'),
(74, '8', 42, 0, NULL, 0, '/modules/Blog/8'),
(75, '20120205', 74, 0, NULL, 0, '/modules/Blog/8/20120205'),
(77, '20120407', 73, 0, NULL, 0, '/modules/Blog/7/20120407'),
(78, '20120410', 49, 0, NULL, 0, '/modules/Blog/4/20120410'),
(79, '20120421', 72, 0, NULL, 0, '/modules/Blog/6/20120421'),
(168, 'junius', 166, 0, NULL, 0, '/Hireink/2018/junius'),
(82, '20120612', 72, 0, NULL, 0, '/modules/Blog/6/20120612'),
(83, '20120615', 72, 0, NULL, 0, '/modules/Blog/6/20120615'),
(87, '20120711', 73, 0, NULL, 0, '/modules/Blog/7/20120711'),
(88, '20120716', 49, 0, NULL, 0, '/modules/Blog/4/20120716'),
(91, '20121027', 73, 0, NULL, 0, '/modules/Blog/7/20121027'),
(105, 'coverslider', 107, 0, NULL, 0, '/2014/coverslider'),
(106, 'design', 107, 0, NULL, 0, '/2014/design'),
(107, '2014', 0, 0, NULL, 0, '/2014'),
(108, 'headerslider', 107, 0, NULL, 0, '/2014/headerslider'),
(109, 'allasajanlat', 108, 0, NULL, 0, '/2014/headerslider/allasajanlat'),
(110, 'elerhetosegek', 108, 0, NULL, 0, '/2014/headerslider/elerhetosegek'),
(111, 'raktarozas', 108, 0, NULL, 0, '/2014/headerslider/raktarozas'),
(112, 'referenciak', 108, 0, NULL, 0, '/2014/headerslider/referenciak'),
(113, 'szallitmanyozas', 108, 0, NULL, 0, '/2014/headerslider/szallitmanyozas'),
(114, 'szerviz', 108, 0, NULL, 0, '/2014/headerslider/szerviz'),
(115, 'benzinkut', 108, 0, NULL, 0, '/2014/headerslider/benzinkut'),
(116, '2013', 108, 0, NULL, 0, '/2014/headerslider/2013'),
(119, 'Hireink', 0, 0, NULL, 0, '/Hireink'),
(120, 'alapkepek', 119, 0, NULL, 0, '/Hireink/alapkepek'),
(131, 'Hirlevel_2015', 0, 0, NULL, 0, '/Hirlevel_2015'),
(136, 'design', 131, 0, NULL, 0, '/Hirlevel_2015/design'),
(141, 'december', 131, 0, NULL, 0, '/Hirlevel_2015/december'),
(142, 'Hirlevel_2016', 0, 0, NULL, 0, '/Hirlevel_2016'),
(143, 'febr', 142, 0, NULL, 0, '/Hirlevel_2016/febr'),
(145, 'design', 142, 0, NULL, 0, '/Hirlevel_2016/design'),
(146, 'apr', 142, 0, NULL, 0, '/Hirlevel_2016/apr'),
(147, 'jun', 142, 0, NULL, 0, '/Hirlevel_2016/jun'),
(149, 'okt', 142, 0, NULL, 0, '/Hirlevel_2016/okt'),
(150, 'dec', 142, 0, NULL, 0, '/Hirlevel_2016/dec'),
(153, 'Hirlevel2017', 0, 0, NULL, 0, '/Hirlevel2017'),
(154, 'febr', 153, 0, NULL, 0, '/Hirlevel2017/febr'),
(155, 'maj', 153, 0, NULL, 0, '/Hirlevel2017/maj'),
(157, 'jun', 153, 0, NULL, 0, '/Hirlevel2017/jun'),
(158, 'aug', 153, 0, NULL, 0, '/Hirlevel2017/aug'),
(159, 'okt', 153, 0, NULL, 0, '/Hirlevel2017/okt'),
(160, 'dec', 153, 0, NULL, 0, '/Hirlevel2017/dec'),
(161, 'dec', 153, 0, NULL, 0, '/Hirlevel2017/dec'),
(162, 'Hirlevel_2018', 0, 0, NULL, 0, '/Hirlevel_2018'),
(163, 'februar', 162, 0, NULL, 0, '/Hirlevel_2018/februar'),
(164, '2018', 0, 0, NULL, 0, '/2018'),
(165, 'Fotok', 164, 0, NULL, 0, '/2018/Fotok'),
(166, '2018', 119, 0, NULL, 0, '/Hireink/2018'),
(167, 'május', 162, 0, NULL, 0, '/Hirlevel_2018/mjus'),
(176, '2024', 119, 0, NULL, 0, '/Hireink/2024'),
(177, '2025', 119, 0, NULL, 0, '/Hireink/2025');

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

--
-- A tábla indexei `opey_oecms_categories`
--
ALTER TABLE `opey_oecms_categories`
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `parentid` (`parentid`),
  ADD KEY `name` (`name`),
  ADD KEY `modcat` (`modcat`,`modname`);

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

--
-- AUTO_INCREMENT a táblához `opey_oecms_categories`
--
ALTER TABLE `opey_oecms_categories`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=178;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
