-- http://www.phpmyadmin.net
--
-- Czas wygenerowania: 25 Maj 2009, 10:57
-- Wersja serwera: 5.0.67
-- Wersja PHP: 5.2.9




--
-- Baza danych: `golden_skoda1`
--

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

--
-- Struktura tabeli dla  `autokomis_attributes`
--

CREATE TABLE IF NOT EXISTS `autokomis_attributes` (
  `id_autokomis_attributes` int(10) unsigned NOT NULL auto_increment,
  `id_autokomis_cars` int(10) unsigned NOT NULL,
  `free_accident` tinyint(1) unsigned NOT NULL default '0',
  `for_disabled` tinyint(1) unsigned NOT NULL default '0',
  `garaged` tinyint(1) unsigned NOT NULL default '0',
  `approval_for_trucks` tinyint(1) unsigned NOT NULL default '0',
  `bought_in_polish_salon` tinyint(1) unsigned NOT NULL default '0',
  `new` tinyint(1) unsigned NOT NULL default '0',
  `first_owner` tinyint(1) unsigned NOT NULL default '0',
  `serviced_in_aso` tinyint(1) unsigned NOT NULL default '0',
  `imported` tinyint(1) unsigned NOT NULL default '0',
  `tuning` tinyint(1) unsigned NOT NULL default '0',
  `antique` tinyint(1) unsigned NOT NULL default '0',
  `registered_in_poland` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_autokomis_attributes`),
  KEY `id_autokomis_cars` (`id_autokomis_cars`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Zrzut danych tabeli `autokomis_attributes`
--


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

--
-- Struktura tabeli dla  `autokomis_cars`
--

CREATE TABLE IF NOT EXISTS `autokomis_cars` (
  `id_autokomis_cars` int(10) unsigned NOT NULL auto_increment,
  `created` date NOT NULL,
  `modified` date NOT NULL,
  `visible` enum('Y','N') NOT NULL default 'N',
  `name_autokomis_cars` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  `model_description` text,
  `type` varchar(255) default NULL,
  `price` float(10,2) unsigned NOT NULL default '0.00',
  `year` int(4) unsigned NOT NULL default '0',
  `motor` varchar(100) default NULL,
  `power` int(10) unsigned NOT NULL default '0',
  `capacity` int(10) unsigned NOT NULL,
  `milage` int(10) unsigned NOT NULL default '0',
  `fuel` varchar(100) default NULL,
  `gear_box` varchar(100) default NULL,
  `car_body_color` char(20) default NULL,
  `car_body_metalic` tinyint(1) unsigned NOT NULL default '0',
  `num_car_doors` tinyint(1) unsigned NOT NULL default '0',
  `description` text,
  `id_admin` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_autokomis_cars`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Zrzut danych tabeli `autokomis_cars`
--


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

--
-- Struktura tabeli dla  `autokomis_equipment`
--

CREATE TABLE IF NOT EXISTS `autokomis_equipment` (
  `id_autokomis_equipment` int(10) unsigned NOT NULL auto_increment,
  `id_autokomis_cars` int(10) unsigned NOT NULL,
  `abs` tinyint(1) unsigned NOT NULL default '0',
  `asr` tinyint(1) unsigned NOT NULL default '0',
  `eds` tinyint(1) unsigned NOT NULL default '0',
  `esp` tinyint(1) unsigned NOT NULL default '0',
  `alufelgi` tinyint(1) unsigned NOT NULL default '0',
  `autoalarm` tinyint(1) unsigned NOT NULL default '0',
  `luggage_rack` tinyint(1) unsigned NOT NULL default '0',
  `differential_lock` tinyint(1) unsigned NOT NULL default '0',
  `gear_lock` tinyint(1) unsigned NOT NULL default '0',
  `central_locking_system` tinyint(1) unsigned NOT NULL default '0',
  `rain_sensor` tinyint(1) unsigned NOT NULL default '0',
  `parking_sensor` tinyint(1) unsigned NOT NULL default '0',
  `electric_mirrors` tinyint(1) unsigned NOT NULL default '0',
  `electric_windows` tinyint(1) unsigned NOT NULL default '0',
  `hook` tinyint(1) unsigned NOT NULL default '0',
  `immobiliser` tinyint(1) unsigned NOT NULL default '0',
  `gas_fittings` tinyint(1) unsigned NOT NULL default '0',
  `multifunctions_steering_wheel` tinyint(1) unsigned NOT NULL default '0',
  `cage` tinyint(1) unsigned NOT NULL default '0',
  `air_conditioning` tinyint(1) unsigned NOT NULL default '0',
  `computer` tinyint(1) unsigned NOT NULL default '0',
  `halogens_xenon` tinyint(1) unsigned NOT NULL default '0',
  `independend_heating` tinyint(1) unsigned NOT NULL default '0',
  `heated_windshield` tinyint(1) unsigned NOT NULL default '0',
  `heated_seats` tinyint(1) unsigned NOT NULL default '0',
  `airbag` tinyint(1) unsigned NOT NULL default '0',
  `dark_glass` tinyint(1) unsigned NOT NULL default '0',
  `radio` tinyint(1) unsigned NOT NULL default '0',
  `height_adjustment_chassis` tinyint(1) unsigned NOT NULL default '0',
  `full_leather` tinyint(1) unsigned NOT NULL default '0',
  `navigation` tinyint(1) unsigned NOT NULL default '0',
  `sun_roof` tinyint(1) unsigned NOT NULL default '0',
  `rear_fog_lights` tinyint(1) unsigned NOT NULL default '0',
  `cruise_control` tinyint(1) unsigned NOT NULL default '0',
  `welur_upholstery` tinyint(1) unsigned NOT NULL default '0',
  `power_steering` tinyint(1) unsigned NOT NULL default '0',
  `4x4` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_autokomis_equipment`),
  KEY `id_autokomis_cars` (`id_autokomis_cars`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Zrzut danych tabeli `autokomis_equipment`
--


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

--
-- Struktura tabeli dla  `autokomis_files`
--

CREATE TABLE IF NOT EXISTS `autokomis_files` (
  `id_autokomis_files` int(10) unsigned NOT NULL auto_increment,
  `name_autokomis_files` varchar(255) default NULL,
  `name` varchar(50) NOT NULL,
  `extension` char(4) NOT NULL,
  `size` int(10) unsigned NOT NULL default '0',
  `path` varchar(255) NOT NULL,
  `visible` enum('Y','N') NOT NULL default 'Y',
  `id_autokomis_cars` int(10) unsigned NOT NULL,
  `order` int(11) NOT NULL default '50',
  PRIMARY KEY  (`id_autokomis_files`),
  KEY `id_autokomis_cars` (`id_autokomis_cars`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Zrzut danych tabeli `autokomis_files`
--


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

--
-- Struktura tabeli dla  `autokomis_owners`
--

CREATE TABLE IF NOT EXISTS `autokomis_owners` (
  `id_autokomis_owners` int(10) unsigned NOT NULL auto_increment,
  `id_autokomis_cars` int(10) unsigned NOT NULL,
  `autokomis_owner_name` varchar(255) default NULL,
  `phone` char(20) default NULL,
  `email` char(50) default NULL,
  PRIMARY KEY  (`id_autokomis_owners`),
  KEY `id_autokomis_cars` (`id_autokomis_cars`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Zrzut danych tabeli `autokomis_owners`
--


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

--
-- Struktura tabeli dla  `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id_category` int(11) NOT NULL auto_increment,
  `name_category` varchar(255) default NULL,
  `url` varchar(255) NOT NULL,
  `id_author` int(11) NOT NULL,
  `visible` enum('N','Y') NOT NULL default 'N',
  `lang` varchar(2) NOT NULL default 'pl',
  `deleteable` enum('Y','N') NOT NULL default 'Y',
  PRIMARY KEY  (`id_category`),
  KEY `deleteable` (`deleteable`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Zrzut danych tabeli `category`
--

INSERT INTO `category` (`id_category`, `name_category`, `url`, `id_author`, `visible`, `lang`, `deleteable`) VALUES
(1, 'Aktualności', 'aktualnosci', 0, 'Y', 'pl', 'N'),
(2, 'Promocje', 'promocje', 0, 'Y', 'pl', 'N'),
(12, 'Zbieraninki', 'zbieraninki', 2, 'Y', 'pl', 'Y');

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

--
-- Struktura tabeli dla  `categoryitem`
--

CREATE TABLE IF NOT EXISTS `categoryitem` (
  `id_categoryitem` int(11) unsigned NOT NULL auto_increment,
  `id_category` int(11) NOT NULL default '1',
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(11) unsigned NOT NULL,
  `added` timestamp NOT NULL default '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `name_categoryitem` varchar(255) NOT NULL,
  `url` varchar(100) NOT NULL,
  `intro` text NOT NULL,
  `description` longtext NOT NULL,
  `picture_file` varchar(255) NOT NULL,
  `banner_file` varchar(255) NOT NULL,
  `visible` enum('N','Y') NOT NULL default 'Y',
  PRIMARY KEY  (`id_categoryitem`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Aktualnosci' AUTO_INCREMENT=11 ;

--
-- Zrzut danych tabeli `categoryitem`
--

INSERT INTO `categoryitem` (`id_categoryitem`, `id_category`, `lang`, `id_author`, `added`, `modified`, `name_categoryitem`, `url`, `intro`, `description`, `picture_file`, `banner_file`, `visible`) VALUES
(9, 1, 'pl', 10, '2008-09-01 00:00:00', '2008-09-01 13:00:40', 'DEALER Škoda ponownie najlepsza w Wielkim Teście Salonów', 'dealer-skoda-ponownie-najlepsza-w-wielkim-tescie-salonow', 'To już piąty Wielki Test Salon&oacute;w przygotowany przez największy w Polsce tygodnik motoryzacyjny. Podczas wcześniejszych edycji cztery razy sieć dealerska Skoda Auto w Polsce zwyciężyła, a raz nieznacznie otarła się o zwycięstwo.<br />', '<p style="text-align: justify;">&Scaron;koda Auto Polska ma najlepszą w naszym kraju sieć dealerską, natomiast krakowski punkt dealerski Skody - Emida to najlepszy salon samochodowy w Polsce. Tak wynika z najnowszego Wielkiego Testu Salon&oacute;w przeprowadzonego dla "Auto Świat".<br /><br /><br /><img title="skoda aktualnosc" src="upload/img/120142002_570.jpg" alt="skoda aktualnosc" width="580" height="364" /></p>', '9_picture.jpg', '', 'Y'),
(10, 2, 'pl', 10, '2008-09-01 00:00:00', '2008-09-01 13:27:18', 'DEALER Polska: Nowa Škoda od 40 600 zł', 'dealer-polska-nowa-skoda-od-40-600-zl', '&Scaron;koda Auto Polska wprowadziła do sprzedaży nowy model. Jest nim Fabia Van Plus &ndash; czyli Fabia Kombi z homologacją kategorii N1 z możliwością pełnego odliczenia podatku VAT.<br />', '<p style="text-align: justify;">Tym samym gama Fabii Van została poszerzona o nową wersję nadwoziową. Model drugiej generacji z homologacją ciężarową był dotychczas sprzedawany tylko jako hatchback. Fabia Van Plus jest następcą odnoszącej duże sukcesy handlowe Fabii pierwszej generacji występującej na rynku pod nazwą Premia. Nowa oferta skierowana jest do przedsiębiorc&oacute;w, dla kt&oacute;rych możliwość odliczenia pełnego podatku VAT od koszt&oacute;w zakupu i eksploatacji (w tym paliwa) ma kluczowe znaczenie.</p>', '10_picture.jpg', '', 'Y'),
(4, 1, 'pl', 7, '0000-00-00 00:00:00', '2008-09-01 12:54:08', 'test', 'test', 'test', '<p>test</p>', '', '', 'N'),
(5, 1, 'pl', 7, '0000-00-00 00:00:00', '2008-09-01 12:54:56', 'test', 'test', 'test', '<p>test</p>', '', '', 'N'),
(6, 1, 'pl', 7, '0000-00-00 00:00:00', '2008-09-01 12:55:35', 'test test test', 'test-test-test', 'test', '<p>test</p>\n<p>test</p>\n<p>test</p>', '', '', 'Y'),
(8, 1, 'pl', 7, '0000-00-00 00:00:00', '2008-09-01 12:58:42', 'test', 'test', 'test<br />test<br />test', '<p>test</p>\n<p>test</p>\n<p>test</p>', '', '', 'Y');

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

--
-- Struktura tabeli dla  `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `description` longtext collate utf8_polish_ci NOT NULL,
  `address` varchar(255) collate utf8_polish_ci default NULL,
  `lat` varchar(255) collate utf8_polish_ci default NULL,
  `lon` varchar(255) collate utf8_polish_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

--
-- Zrzut danych tabeli `contact`
--

INSERT INTO `contact` (`description`, `address`, `lat`, `lon`) VALUES
('<div><strong><img style="margin-right: 5px; margin-bottom: 5px; float: left;" title="siedlce" src="upload/img/foty_salony_1_01.jpg" alt="siedlce" width="227" height="111" /><br />Carsed Sp.j. - Siedlce</strong><br /> Adres:     ul. Jagiełły 4/6   <br />08-110 Siedlce<br /> Telefon:     (025) 644 35 05,   (025) 633 06 03<br /> Fax:     (025) 644 28 19<br /> <br /></div>', 'Siedlce, Jagiełły 4', '', '');

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

--
-- Struktura tabeli dla  `dealer_shops`
--

CREATE TABLE IF NOT EXISTS `dealer_shops` (
  `id_dealer_shops` int(11) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(11) unsigned NOT NULL default '0',
  `name_dealer_shops` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `picture_file` varchar(255) NOT NULL,
  `order` smallint(2) unsigned NOT NULL default '50',
  `visible` enum('N','Y') NOT NULL default 'Y',
  `address` varchar(255) NOT NULL,
  `lat` varchar(255) NOT NULL,
  `lon` varchar(255) NOT NULL,
  PRIMARY KEY  (`id_dealer_shops`),
  KEY `lang` (`lang`,`visible`),
  KEY `order` (`order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Zrzut danych tabeli `dealer_shops`
--

INSERT INTO `dealer_shops` (`id_dealer_shops`, `lang`, `id_author`, `name_dealer_shops`, `description`, `picture_file`, `order`, `visible`, `address`, `lat`, `lon`) VALUES
(2, 'pl', 7, 'Siedlce', '<p><span style="color: #000000;">Adres:         ul. Jagiełły 4/6  <br /><br /> 08-110 Siedlce<br /><br />Telefon:      (025) 644 35 05, (025) 633 06 03<br /><br />Fax:            (025) 644 28 19</span><br /><br /><br /><a href="pl/firma/o-nas.html"><span style="color: #000000;">Salon</span></a><br /><br /><a href="pl/punkty-dealerskie-i-serwis/serwis/oferta-serwisu.html"><span style="color: #000000;">Serwis</span></a><br /><br /><a href="pl/punkty-dealerskie-i-serwis/serwis/czesci.html"><span style="color: #000000;">Części</span></a></p>\n<p> </p>', '2_picture.jpg', 10, 'Y', 'Siedlce, Jagiełły 4', '', ''),
(4, 'pl', 10, 'Biała Podlaska', '<p><span style="color: #000000;">Adres:              ul. Janowska 71  <br /><br /> 21-500 Biała Podlaska<br /><br />Telefon/fax:     (083) 342 58 80, (083) 342 30 92</span><br /><br /><br /><a href="pl/firma/o-nas.html"><span style="color: #000000;">Salon</span></a><br /><br /><a href="pl/punkty-dealerskie-i-serwis/serwis/oferta-serwisu.html"><span style="color: #000000;">Serwis</span></a><br /><br /><a href="pl/punkty-dealerskie-i-serwis/serwis/czesci.html"><span style="color: #000000;">Części</span></a></p>', '4_picture.jpg', 30, 'Y', 'Biała Podlaska, Janowska 71', '', ''),
(3, 'pl', 10, 'Mińsk Mazowiecki - Stojadła', '<p><span style="color: #000000;">Adres:              ul. Warszawska 84 <br /><br /> 05-300 Mińsk Mazowiecki-Stojadła<br /><br />Telefon/fax:     (025) 758 03 31, (025) 758 30 53</span><br /><br /><br /><a href="pl/firma/o-nas.html"><span style="color: #000000;">Salon</span></a><br /><br /><a href="pl/punkty-dealerskie-i-serwis/serwis/oferta-serwisu.html"><span style="color: #000000;">Serwis</span></a><br /><br /><a href="pl/oferta/uslugi-dodatkowe/blacharnia-lakiernia.html"><span style="color: #000000;">Blacharnia - Lakiernia</span></a><br /><br /><a href="pl/punkty-dealerskie-i-serwis/serwis/czesci.html"><span style="color: #000000;">Części</span></a></p>', '3_picture.jpg', 20, 'Y', 'Mińsk Mazowiecki, Warszawska 84', '', '');

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

--
-- Struktura tabeli dla  `file`
--

CREATE TABLE IF NOT EXISTS `file` (
  `id_file` int(11) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `name_file` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id_file`),
  KEY `modified` (`modified`,`visible`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Kategorie plikow' AUTO_INCREMENT=15 ;

--
-- Zrzut danych tabeli `file`
--


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

--
-- Struktura tabeli dla  `file_files`
--

CREATE TABLE IF NOT EXISTS `file_files` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `id_category` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` int(11) default NULL,
  `file_ext` varchar(10) default NULL,
  `order` smallint(2) unsigned NOT NULL default '50',
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `modified` (`modified`,`id_category`,`visible`),
  KEY `lang` (`lang`),
  KEY `order` (`order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Poszczególne pliki' AUTO_INCREMENT=117 ;

--
-- Zrzut danych tabeli `file_files`
--


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

--
-- Struktura tabeli dla  `flashimages`
--

CREATE TABLE IF NOT EXISTS `flashimages` (
  `id_flashimages` int(11) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `name_flashimages` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id_flashimages`),
  KEY `modified` (`modified`,`visible`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Animacje flash' AUTO_INCREMENT=5 ;

--
-- Zrzut danych tabeli `flashimages`
--

INSERT INTO `flashimages` (`id_flashimages`, `lang`, `id_author`, `modified`, `name_flashimages`, `description`, `visible`) VALUES
(1, 'pl', 7, '2008-06-18 11:53:50', 'Duży - góra', '', 'Y'),
(2, 'pl', 7, '2008-06-18 13:10:01', 'Mały - lewy', '', 'Y'),
(3, 'pl', 7, '2008-06-18 13:10:10', 'Mały - środkowy', '', 'Y'),
(4, 'pl', 7, '2008-06-18 13:10:19', 'Mały - prawy', '', 'Y');

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

--
-- Struktura tabeli dla  `flashimages_files`
--

CREATE TABLE IF NOT EXISTS `flashimages_files` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `id_category` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` int(11) default NULL,
  `file_ext` varchar(10) default NULL,
  `link` varchar(150) NOT NULL,
  `target` tinyint(4) NOT NULL default '0',
  `rotation_time` int(11) NOT NULL default '7000',
  `order` smallint(2) unsigned NOT NULL default '50',
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `modified` (`modified`,`id_category`,`visible`),
  KEY `lang` (`lang`),
  KEY `order` (`order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Obrazki we flashach' AUTO_INCREMENT=38 ;

--
-- Zrzut danych tabeli `flashimages_files`
--

INSERT INTO `flashimages_files` (`id`, `lang`, `id_author`, `modified`, `id_category`, `name`, `file_name`, `file_size`, `file_ext`, `link`, `target`, `rotation_time`, `order`, `visible`) VALUES
(21, 'pl', 11, '2008-06-26 15:17:46', 4, '0', '2e1ef689eed2b3040c0dbfa54e9978e8.jpg', 50237, '.jpg', '/pl/oferta/instalacje-lpg.html', 0, 7000, 50, 'N'),
(18, 'pl', 11, '2008-06-26 15:13:04', 6, '0', '8928ce7cc9cb8f00cffca7681e424d27.jpg', 41367, '.jpg', 'http://www.fabiamonnari.pl/', 1, 7000, 50, 'N'),
(10, 'pl', 11, '2008-06-20 09:51:54', 1, '1', '28e20c5675697932c724851427e8712a.jpg', 236231, '.jpg', 'http://testconecto.s3.beyond.pl/k/pl/modele/nowy-superb.html', 0, 7000, 50, 'N'),
(11, 'pl', 11, '2008-06-20 09:52:05', 1, '2', '8deed26edcda9a53daa0d1b3e6f72d33.jpg', 236732, '.jpg', 'http://testconecto.s3.beyond.pl/k/pl/modele/nowa-fabia.html', 0, 7000, 50, 'N'),
(12, 'pl', 11, '2008-06-20 09:52:47', 3, '0', '38f183e679552982a5845d96f43d5d6a.jpg', 29089, '.jpg', '', 0, 7000, 50, 'N'),
(13, 'pl', 11, '2008-06-20 09:52:58', 3, '1', 'f4b87e880cdd92bdd4ac2632f09ff08a.jpg', 29771, '.jpg', '', 0, 7000, 50, 'Y'),
(20, 'pl', 11, '2008-06-26 15:17:13', 4, '1', '68b3dd4e34dfedd8eaae97784f874b04.jpg', 47792, '.jpg', '/pl/oferta/instalacje-lpg.html', 0, 7000, 50, 'N'),
(16, 'pl', 11, '2008-06-20 09:54:37', 5, '0', 'ad177ffc17045309c890661da8a79ac6.jpg', 30179, '.jpg', '', 0, 7000, 50, 'Y'),
(24, 'pl', 11, '2008-06-30 12:54:52', 8, '0', 'e4f30a91ccf09acdb8085a37b3a3275f.jpg', 59444, '.jpg', 'http://skoda-przyjazneauto.pl/', 1, 7000, 50, 'Y'),
(19, 'pl', 11, '2008-06-26 15:13:21', 6, '1', 'f35903743b6e91ea41281033ff5f3418.jpg', 41480, '.jpg', 'http://www.fabiamonnari.pl/', 1, 7000, 50, 'N'),
(22, 'pl', 11, '2008-06-29 23:03:38', 7, '0', '4c3486338236bb914c600824b652cd53.jpg', 35747, '.jpg', 'http://testconecto.s3.beyond.pl/k/pl/oferta/sprawdzone-auto.html', 0, 7000, 50, 'Y'),
(23, 'pl', 11, '2008-06-29 23:04:12', 7, '1', '83d82b05cdb38411bcfebffce6cdf47f.jpg', 34766, '.jpg', 'http://testconecto.s3.beyond.pl/k/pl/oferta/sprawdzone-auto.html', 0, 7000, 50, 'Y'),
(25, 'pl', 11, '2008-06-30 12:55:05', 8, '1', '608b56ffeeff92aecb2cfcc865f1c849.jpg', 57722, '.jpg', 'http://skoda-przyjazneauto.pl/', 1, 7000, 50, 'Y'),
(27, 'pl', 11, '2008-07-07 13:49:55', 9, '1', '976ec4554feb3c10e05d61f92e4bca31.jpg', 47794, '.jpg', 'http://www.skoda-auto.pl/pl/oferta/promocje.html', 0, 7000, 50, 'N'),
(30, 'pl', 11, '2008-08-01 14:20:22', 1, 'superb', '2094b0f944e81e4fe49365771aa46a26.jpg', 236439, '.jpg', 'http://testconecto.s3.beyond.pl/k/pl/modele/nowy-superb.html', 0, 7000, 50, 'N'),
(29, 'pl', 11, '2008-07-13 20:03:49', 1, 'fabia', 'ad82fedc72f6a48d11211a6fa9ce8339.jpg', 237686, '.jpg', 'http://testconecto.s3.beyond.pl/k/pl/modele/nowa-fabia.html', 0, 7000, 50, 'N'),
(31, 'pl', 10, '2008-09-01 16:19:10', 6, '3', '5c112c1492f64c58f8065ddea3208fb2.jpg', 12883, '.jpg', '/pl/punkty-dealerskie-i-serwis/punkty-dealerskie.html', 0, 7000, 50, 'Y'),
(32, 'pl', 10, '2008-09-01 16:21:08', 4, '3', '29141c206eadbec875d27e85ccdea41c.jpg', 12294, '.jpg', '/pl/punkty-dealerskie-i-serwis/serwis.html', 0, 7000, 50, 'Y'),
(33, 'pl', 10, '2008-09-01 16:22:08', 9, '2', 'b9053e1bd34daac92fed02941e88bbfa.jpg', 11821, '.jpg', '', 0, 7000, 50, 'N'),
(34, 'pl', 10, '2008-09-01 16:24:01', 13, 'fabia', '8701e2cf19a0bdc334e06ab31c25e095.jpg', 61959, '.jpg', '/pl/modele/nowa-fabia.html', 0, 7000, 50, 'N'),
(35, 'pl', 10, '2008-09-01 16:24:25', 13, 'superb', 'edd7779b41a112aa6362676b41a1d058.jpg', 58431, '.jpg', '/pl/modele/nowy-superb.html', 0, 7000, 50, 'N'),
(36, 'pl', 10, '2008-09-02 09:34:10', 9, '3', '54f5b27d1954545db917f45c0c53f995.jpg', 11821, '.jpg', 'http://www.carsed.pl/moduly/jazda_probna/index.php', 1, 7000, 50, 'Y'),
(37, 'pl', 11, '2008-09-04 16:25:56', 13, 'punkty dealerskie', 'ea586cb1464bf3327b1547a604cf5635.jpg', 99347, '.jpg', '/pl/punkty-dealerskie-i-serwis.html', 0, 7000, 50, 'Y');

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

--
-- Struktura tabeli dla  `flashimages_sets`
--

CREATE TABLE IF NOT EXISTS `flashimages_sets` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `id_category` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `order` smallint(2) unsigned NOT NULL default '50',
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `modified` (`modified`,`id_category`,`visible`),
  KEY `lang` (`lang`),
  KEY `order` (`order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Obrazki we flashach' AUTO_INCREMENT=14 ;

--
-- Zrzut danych tabeli `flashimages_sets`
--

INSERT INTO `flashimages_sets` (`id`, `lang`, `id_author`, `modified`, `id_category`, `name`, `order`, `visible`) VALUES
(6, 'pl', 11, '2008-06-26 15:11:05', 2, '1', 50, 'Y'),
(4, 'pl', 11, '2008-06-20 09:53:30', 4, 'Zestaw 1', 50, 'Y'),
(12, 'pl', 11, '2008-06-30 13:00:04', 9, 'Zestaw 1', 50, 'N'),
(9, 'pl', 11, '2008-06-30 12:55:28', 3, '2', 50, 'Y'),
(11, 'pl', 11, '2008-06-30 12:59:28', 9, 'Zestaw 2', 50, 'N'),
(13, 'pl', 10, '2008-09-01 16:22:26', 1, '2', 50, 'Y');

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

--
-- Struktura tabeli dla  `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id_gallery` int(11) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `name_gallery` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id_gallery`),
  KEY `modified` (`modified`,`visible`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Galerie zdjec' AUTO_INCREMENT=19 ;

--
-- Zrzut danych tabeli `gallery`
--


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

--
-- Struktura tabeli dla  `gallery_pictures`
--

CREATE TABLE IF NOT EXISTS `gallery_pictures` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `id_category` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `url` varchar(255) default NULL,
  `file_thumb` varchar(255) NOT NULL,
  `file_800x600` varchar(255) NOT NULL,
  `file_1024x768` varchar(255) NOT NULL,
  `file_1280x800` varchar(255) NOT NULL,
  `file_1280x1024` varchar(255) NOT NULL,
  `order` smallint(2) unsigned NOT NULL default '50',
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `modified` (`modified`,`id_category`,`visible`),
  KEY `lang` (`lang`),
  KEY `order` (`order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=157 ;

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

--
-- Struktura tabeli dla  `links`
--

CREATE TABLE IF NOT EXISTS `links` (
  `id_links` int(11) unsigned NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `id_author` int(10) unsigned NOT NULL default '0',
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `name_links` varchar(255) NOT NULL,
  `visible` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id_links`),
  KEY `modified` (`modified`,`visible`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Kategorie linków' AUTO_INCREMENT=17 ;

--
-- Zrzut danych tabeli `links`
--

INSERT INTO `links` (`id_links`, `lang`, `id_author`, `modified`, `name_links`, `visible`) VALUES
(3, 'pl', 2, '2008-04-23 11:08:01', 'Główna', 'Y'),
(5, 'pl', 2, '2008-04-24 14:08:55', 'Fabia', 'Y'),
(6, 'pl', 2, '2008-05-15 01:16:07', 'Nowa Fabia', 'Y'),
(7, 'pl', 2, '2008-05-15 01:17:44', 'Roomster', 'Y'),
(8, 'pl', 2, '2008-05-15 01:20:29', 'Octavia', 'Y'),
(9, 'pl', 11, '2008-07-07 12:52:07', 'Nowy Superb', 'Y'),
(10, 'pl', 11, '2008-07-07 12:53:37', 'Superb', 'Y'),
(11, 'pl', 11, '2008-07-07 12:54:16', 'Nowa Fabia Combi', 'Y'),
(12, 'pl', 11, '2008-07-07 12:54:57', 'Octavia Tour', 'Y'),
(13, 'pl', 11, '2008-07-07 12:55:49', 'Octavia Combi', 'Y'),
(14, 'pl', 11, '2008-07-07 12:56:57', 'Konfigurator', 'Y'),
(15, 'pl', 11, '2008-07-07 16:05:33', 'Praktik', 'Y');

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

--
-- Struktura tabeli dla  `links_link`
--

CREATE TABLE IF NOT EXISTS `links_link` (
  `id_link` int(11) NOT NULL auto_increment,
  `lang` varchar(3) collate utf8_polish_ci NOT NULL default 'pl',
  `id_link_category` int(11) NOT NULL,
  `name` varchar(255) collate utf8_polish_ci NOT NULL,
  `url` varchar(255) collate utf8_polish_ci NOT NULL,
  `target` varchar(255) collate utf8_polish_ci NOT NULL,
  `id_author` int(11) NOT NULL,
  PRIMARY KEY  (`id_link`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci COMMENT='Poszczególne linki' AUTO_INCREMENT=35 ;

--
-- Zrzut danych tabeli `links_link`
--

INSERT INTO `links_link` (`id_link`, `lang`, `id_link_category`, `name`, `url`, `target`, `id_author`) VALUES
(13, 'pl', 3, 'Sprawdzone auto', 'http://www.sprawdzone-auto.pl/', '_blank', 2),
(17, 'pl', 8, 'Konfigurator', 'http://cc.skoda.pl/?model=5', '_blank', 2),
(11, 'pl', 3, 'Konfigurator', 'http://www.cc.skoda.pl/', '_blank', 2),
(14, 'pl', 5, 'Konfigurator', 'http://cc.skoda.pl/', '_blank', 2),
(16, 'pl', 6, 'Konfigurator', 'http://cc.skoda.pl/?model=24', '_blank', 2),
(19, 'pl', 7, 'Konfigurator', 'http://www.cc.skoda.pl/', '_blank', 11),
(20, 'pl', 7, 'Mikrostrona', 'http://www.roomster.pl', '_blank', 11),
(21, 'pl', 9, 'Konfigurator1', 'http://cc.skoda.pl', '_blank', 11),
(22, 'pl', 9, 'Mikrostrona', 'http://www.skoda-superb.pl', '_blank', 11),
(23, 'pl', 10, 'Konfigurator', 'http://cc.skoda.pl', '_blank', 11),
(24, 'pl', 11, 'Konfigurator', 'http://cc.skoda.pl', '_blank', 11),
(25, 'pl', 12, 'Konfigurator', 'http://cc.skoda.pl', '_blank', 11),
(26, 'pl', 13, 'Konfigurator', 'http://cc.skoda.pl', '_blank', 11),
(27, 'pl', 14, 'Konfigurator', 'http://cc.skoda.pl', '_blank', 11),
(28, 'pl', 15, 'Konfigurator', 'http://www.cc.skoda.pl/', '_blank', 11),
(29, 'pl', 6, 'Mikrostrona', 'http://www.nowafabia.pl/index2.html', '_blank', 11),
(30, 'pl', 6, 'Fabia Monnari', 'http://fabiamonnari.pl/', '_self', 11),
(32, 'pl', 3, 'Przyjazne auto', 'http://www.skoda-przyjazneauto.pl/', '_blank', 11);

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

--
-- Struktura tabeli dla  `main`
--

CREATE TABLE IF NOT EXISTS `main` (
  `id_links` int(11) default NULL,
  `picture` varchar(255) collate utf8_polish_ci default NULL,
  `picture_link` varchar(255) collate utf8_polish_ci NOT NULL,
  `title` varchar(255) collate utf8_polish_ci default NULL,
  `intro` longtext collate utf8_polish_ci,
  `id_files` int(11) default NULL,
  `stats_html_code` text collate utf8_polish_ci NOT NULL,
  `dealer_name` varchar(100) collate utf8_polish_ci NOT NULL,
  `dealer_title` varchar(150) collate utf8_polish_ci NOT NULL,
  `dealer_description` longtext collate utf8_polish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

--
-- Zrzut danych tabeli `main`
--

INSERT INTO `main` (`id_links`, `picture`, `picture_link`, `title`, `intro`, `id_files`, `stats_html_code`, `dealer_name`, `dealer_title`, `dealer_description`) VALUES
(3, '2eb2e690a51dbe4411de2abb84ab0c57.jpg', 'http://www.szkola-auto.pl/', '', '', 0, '', 'CARSED', 'Carsed Sp.j.', '<p style="text-align: justify;"><img style="float: left; margin-right: 5px; margin-bottom: 5px;" title="Carsed" src="upload/img/dealer_maska.jpg" alt="Carsed" width="200" height="150" />Celem firmy CARSED Sp.j. jest działanie na korzyść Klienta, kt&oacute;ry jest dla nas priorytetem oraz motywacją. Rozw&oacute;j motoryzacji skłania nas do doskonalenia umiejętności wszystkich pracownik&oacute;w poprzez szkolenia. Mamy do zaoferowania usługi w dziedzinie: sprzedaży samochod&oacute;w nowych i używanych, kompleksowej obsługi serwisowej od poniedziałku do piątku przez 24h, ubezpieczeń samochodowych oraz napraw blacharsko-lakierniczych z Assistanse 24h z autami zastępczymi na czas naprawy.<br /><br /><br /><br />Dogodna lokalizacja obiektu oraz funkcjonalne wnętrza zapewniają komfort Klientom. Serwujemy r&oacute;wnież kawkę z uśmiechem. Mamy do zaoferowania szeroką gamę modeli a czas realizacji zam&oacute;wienia od 1 dnia do 6 tygodni. Owocem naszego dążenia do ideału jest przyznany naszej firmie certyfikat ISO 9001:2000. Wieloletnie starania oraz rzetelna wsp&oacute;łpraca z Klientem podniosła standard wykonywanych usług i doprowadziła do uzyskania zaszczytnego tytułu Dealer Roku 2006. Zapraszamy.<br /><br />SAMOCHODY DEMONSTRACYJNE- JAZDY PR&Oacute;BNE<br /><br />Aby ułatwić Państwu decyzję, co do wyboru najodpowiedniejszego dla Państwa samochodu i to zar&oacute;wno, jeśli chodzi o wyposażenie jak i wersję silnikową, proponujemy skorzystanie z JAZD PR&Oacute;BNYCH. Dzięki możliwości wypr&oacute;bowania auta w terenie, macie Państwo niepowtarzalną możliwość sprawdzenia samochodu w wybranych przez siebie warunkach, a przez to dokonanie wyboru, kt&oacute;ry w pełni zrealizuje Państwa oczekiwania.</p>');

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

--
-- Struktura tabeli dla  `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id_menu` int(11) NOT NULL auto_increment,
  `lang` varchar(3) collate utf8_polish_ci NOT NULL default 'pl',
  `id_parent` int(11) NOT NULL,
  `child_count` smallint(3) unsigned NOT NULL default '0',
  `name` varchar(255) collate utf8_polish_ci NOT NULL,
  `url` varchar(50) collate utf8_polish_ci NOT NULL,
  `banner_file_name` varchar(255) collate utf8_polish_ci NOT NULL,
  `rightside_file_name` varchar(255) collate utf8_polish_ci default NULL,
  `rightside_link` varchar(255) collate utf8_polish_ci default NULL,
  `stats_html_code` text collate utf8_polish_ci NOT NULL,
  `user_link` varchar(255) collate utf8_polish_ci NOT NULL,
  `descr` text collate utf8_polish_ci NOT NULL,
  `module_type` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `order` smallint(3) unsigned NOT NULL default '50',
  `visible` enum('Y','N') collate utf8_polish_ci NOT NULL default 'N',
  `showinmenu` enum('N','Y') collate utf8_polish_ci NOT NULL default 'N',
  `id_author` int(11) NOT NULL,
  `modified` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id_menu`),
  KEY `lang` (`lang`),
  KEY `child_count` (`child_count`),
  KEY `order` (`order`),
  KEY `showinmenu` (`showinmenu`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci COMMENT='elementy menu' AUTO_INCREMENT=243 ;

--
-- Zrzut danych tabeli `menu`
--

INSERT INTO `menu` (`id_menu`, `lang`, `id_parent`, `child_count`, `name`, `url`, `banner_file_name`, `rightside_file_name`, `rightside_link`, `stats_html_code`, `user_link`, `descr`, `module_type`, `module_id`, `order`, `visible`, `showinmenu`, `id_author`, `modified`) VALUES
(9, 'pl', 0, 10, 'Modele osobowe', 'modele-osobowe', '9.jpg', NULL, NULL, '', '', '<p>Modele samochodów.</p>', 10, 0, 10, 'Y', 'Y', 7, '2009-05-25 09:52:11'),
(24, 'pl', 0, 0, 'Wyszukiwarka', 'wyszukiwarka', '24.jpg', NULL, NULL, '', '', '<p>Wyszukiwarka</p>', 21, 0, 50, 'Y', 'N', 7, '2008-08-12 09:43:35'),
(18, 'pl', 0, 0, 'Dane techniczne', 'dane-techniczne', '', NULL, NULL, '', '', '<p>Dane techniczne</p>', 9, 0, 50, 'N', 'N', 7, '2008-09-24 15:01:13'),
(21, 'pl', 0, 0, 'Cenniki', 'cenniki', '21.jpg', NULL, '', '', '', '<p>Cenniki</p>', 18, 0, 50, 'Y', 'N', 2, '2008-09-24 14:53:08'),
(32, 'pl', 0, 0, 'Aktualności', 'aktualnosci', '32.jpg', NULL, NULL, '', '', '<p>Aktualności</p>', 26, 1, 50, 'Y', 'Y', 7, '2008-09-04 16:43:17'),
(35, 'pl', 0, 6, 'Firma', 'firma', '35.jpg', NULL, NULL, '', '', '<p>O firmie.</p>', 9, 105, 30, 'Y', 'Y', 2, '2008-09-24 15:00:41'),
(240, 'pl', 0, 0, 'Akcesoria', 'akcesoria', '240.jpg', NULL, '', '', '', '<p>Akcesoria</p>', 14, 0, 50, 'Y', 'N', 7, '2008-09-24 15:04:27'),
(38, 'pl', 0, 0, 'Kontakt', 'kontakt', '38.jpg', NULL, NULL, '', '', '<p>Kontakt</p>', 29, 0, 65, 'Y', 'N', 2, '2008-10-10 18:43:16'),
(39, 'pl', 0, 0, 'Promocje', 'promocje', '39.jpg', '', '', '', '', '<p>Promocje</p>', 26, 2, 50, 'Y', 'N', 2, '2008-09-24 15:00:04'),
(41, 'pl', 0, 0, 'Mapa strony', 'mapa-strony', '41.jpg', NULL, NULL, '', '', '<p>Mapa strony</p>', 24, 0, 50, 'Y', 'N', 7, '2008-08-12 09:43:35'),
(50, 'pl', 0, 0, 'Newsletter', 'newsletter', '50.jpg', NULL, NULL, '', '', '<p>Newsletter</p>', 25, 0, 50, 'Y', 'N', 2, '2008-08-12 09:43:35'),
(53, 'pl', 0, 4, 'Menu dolne', 'menu-dolne', '', NULL, NULL, '', '', '<p>Lewe menu w stopce.</p>', 1, 0, 150, 'Y', 'N', 2, '2008-08-12 09:43:35'),
(54, 'pl', 53, 0, 'Akcesoria', 'akcesoria', '', NULL, NULL, '', '', '<p>Link do akcesoriów w menu dolnym</p>', 14, 0, 30, 'Y', 'Y', 2, '2008-07-04 16:18:49'),
(55, 'pl', 53, 0, 'Cenniki', 'cenniki', '', NULL, NULL, '', 'http://www.skoda-auto.pl/pl/oferta/cenniki', '<p>Link do cenników w menu dolnym</p>', 0, 0, 10, 'Y', 'Y', 2, '2008-08-29 14:30:29'),
(56, 'pl', 53, 0, 'Promocje', 'promocje', '', NULL, NULL, '', '', '<p>Link do promocji w menu dolnym</p>', 26, 2, 20, 'Y', 'Y', 2, '2008-07-04 16:18:49'),
(57, 'pl', 53, 0, 'Flota', 'flota', '', NULL, NULL, '', '', '<p>Link do strony Flota w menu dolnym.</p>', 9, 11, 50, 'N', 'Y', 2, '2008-05-13 12:58:22'),
(72, 'pl', 0, 9, 'Oferta', 'oferta', '72.jpg', '', '', '', '', '<p>Oferta</p>', 26, 2, 20, 'Y', 'Y', 2, '2008-09-24 16:01:07'),
(73, 'pl', 72, 0, 'Cenniki', 'cenniki', '73.jpg', NULL, NULL, '', '', '<p>Cenniki</p>', 18, 0, 30, 'Y', 'Y', 2, '2008-09-03 08:32:00'),
(74, 'pl', 72, 0, 'Promocje', 'promocje', '', NULL, '', '', '', '<p>Promocje</p>', 26, 2, 10, 'Y', 'Y', 2, '2008-10-14 14:51:12'),
(75, 'pl', 72, 0, 'Konfigurator', 'konfigurator', '', NULL, NULL, '', 'http://www.cc.skoda.pl', '<p>Konfigurator</p>', 0, 0, 20, 'Y', 'Y', 2, '2008-07-11 15:26:16'),
(76, 'pl', 72, 0, 'Akcesoria', 'akcesoria', '76.jpg', NULL, NULL, '', '', '<p>Akcesoria</p>', 14, 0, 40, 'Y', 'Y', 2, '2008-07-11 15:26:39'),
(77, 'pl', 72, 2, 'Flota', 'flota', '77.jpg', NULL, NULL, '', '', '<p>Flota</p>', 9, 89, 50, 'Y', 'Y', 2, '2008-09-02 11:48:24'),
(148, 'pl', 0, 0, 'Informacje Prawne', 'informacje-prawne', '148.jpg', NULL, NULL, '', '', '<p>Informacje prawne</p>', 9, 67, 50, 'Y', 'N', 2, '2008-08-12 09:43:35'),
(198, 'pl', 0, 2, 'Punkty dealerskie i serwis', 'punkty-dealerskie-i-serwis', '198.jpg', NULL, NULL, '', '', '<p>Punkty dealerskie i serwis</p>', 30, 0, 35, 'Y', 'Y', 7, '2008-09-02 11:41:54'),
(199, 'pl', 35, 0, 'Historia marki', 'historia-marki', '199.jpg', NULL, NULL, '', '', '<p>Carsed - Historia</p>', 9, 18, 20, 'Y', 'Y', 10, '2008-09-02 12:02:35'),
(217, 'pl', 35, 0, 'O nas', 'o-nas', '217.jpg', NULL, NULL, '', '', '<p>O nas</p>', 9, 105, 10, 'Y', 'Y', 10, '2008-09-02 12:02:05'),
(210, 'pl', 72, 2, 'Auta ', 'auta', '210.jpg', NULL, NULL, '', '', '<p>Auta "od ręki"</p>', 9, 112, 15, 'Y', 'Y', 10, '2008-10-14 14:51:12'),
(211, 'pl', 210, 0, 'Nowe', 'nowe', '211.jpg', NULL, NULL, '', '', '<p>Nowe</p>', 9, 112, 50, 'Y', 'Y', 10, '2008-09-02 12:00:20'),
(212, 'pl', 210, 0, 'Używane', 'uzywane', '212.jpg', NULL, NULL, '', '', '<p>Używane</p>', 9, 113, 50, 'Y', 'Y', 10, '2008-09-02 12:00:33'),
(213, 'pl', 72, 0, 'Ubezpieczenia i finanse', 'ubezpieczenia-i-finanse', '213.jpg', NULL, NULL, '', '', '<p>Ubezpieczenia i finanse</p>', 9, 101, 35, 'Y', 'Y', 10, '2008-09-02 11:44:31'),
(215, 'pl', 72, 0, 'Dla firm', 'dla-firm', '215.jpg', NULL, NULL, '', '', '<p>Dla firm</p>', 9, 103, 60, 'Y', 'Y', 10, '2008-09-02 11:51:22'),
(216, 'pl', 72, 3, 'Usługi dodatkowe', 'uslugi-dodatkowe', '216.jpg', NULL, NULL, '', '', '<p>Usługi dodatkowe</p>', 9, 88, 70, 'Y', 'Y', 10, '2008-09-02 11:31:34'),
(218, 'pl', 35, 0, 'Sponsoring', 'sponsoring', '218.jpg', NULL, NULL, '', '', '<p>Carsed - Sponsoring</p>', 9, 22, 30, 'Y', 'Y', 10, '2008-09-02 12:02:47'),
(219, 'pl', 35, 0, 'Praca', 'praca', '', NULL, NULL, '', '', '<p>Carsed - Praca</p>', 9, 107, 40, 'Y', 'N', 10, '2008-09-02 12:03:05'),
(220, 'pl', 35, 0, 'Kontakt ', 'kontakt', '220.jpg', NULL, NULL, '', '', '<p>Kontakt</p>', 29, 0, 50, 'Y', 'Y', 10, '2008-09-03 00:18:35'),
(221, 'pl', 198, 0, 'Punkty dealerskie', 'punkty-dealerskie', '221.jpg', NULL, NULL, '', '', '<p>Punkty dealerskie</p>', 30, 0, 10, 'Y', 'Y', 10, '2008-09-02 12:10:22'),
(222, 'pl', 198, 6, 'Serwis', 'serwis', '222.jpg', '222_right.jpg', 'http://www.skoda-auto.pl/pl/dealerzy-i-serwis.html', '', '', '<p>Serwis</p>', 9, 55, 20, 'Y', 'Y', 10, '2008-09-24 15:07:36'),
(223, 'pl', 222, 0, 'Gwarancja', 'gwarancja', '223.jpg', NULL, NULL, '', '', '<p>Gwarancja</p>', 9, 55, 1, 'Y', 'Y', 10, '2008-09-02 12:05:50'),
(224, 'pl', 222, 0, 'Assistance', 'assistance', '224.jpg', NULL, NULL, '', '', '<p>Assistance</p>', 9, 56, 2, 'Y', 'Y', 10, '2008-09-02 12:05:58'),
(225, 'pl', 222, 0, 'Części', 'czesci', '225.jpg', NULL, NULL, '', '', '<p>Części</p>', 9, 54, 3, 'Y', 'Y', 10, '2008-09-02 12:06:06'),
(226, 'pl', 222, 0, 'Oferta serwisu', 'oferta-serwisu', '226.jpg', NULL, NULL, '', '', '<p>Oferta serwisu</p>', 9, 108, 4, 'Y', 'Y', 10, '2008-09-02 12:06:15'),
(227, 'pl', 222, 0, 'Stacja kontroli pojazdów', 'stacja-kontroli-pojazdow', '', NULL, NULL, '', '', '<p>Stacja kontroli pojazdów</p>', 9, 109, 5, 'Y', 'N', 10, '2008-09-02 11:12:29'),
(228, 'pl', 222, 0, 'Cennik usług', 'cennik-uslug', '228.jpg', NULL, NULL, '', '', '<p>Cennik usług</p>', 9, 110, 50, 'Y', 'Y', 10, '2008-09-02 12:06:31'),
(234, 'pl', 216, 0, 'Blacharnia - Lakiernia', 'blacharnia-lakiernia', '234.jpg', NULL, NULL, '', '', '<p>Blacharnia - Lakiernia</p>', 9, 88, 50, 'Y', 'Y', 10, '2008-09-02 12:00:54'),
(235, 'pl', 216, 0, 'Likwidacja szkód', 'likwidacja-szkod', '235.jpg', NULL, NULL, '', '', '<p>Likwidacja szkód</p>', 9, 114, 50, 'Y', 'Y', 10, '2008-09-04 22:15:49'),
(236, 'pl', 216, 0, 'Stacja kontroli pojazdów', 'stacja-kontroli-pojazdow', '236.jpg', NULL, NULL, '', '', '<p>Stacja kontroli pojazdów</p>', 9, 109, 50, 'Y', 'Y', 10, '2008-09-02 12:01:44'),
(237, 'pl', 77, 0, 'Flota Carsed', 'flota-carsed', '237.jpg', NULL, NULL, '', '', '<p>Flota Carsed</p>', 9, 89, 50, 'Y', 'Y', 10, '2008-09-02 11:49:05'),
(238, 'pl', 77, 0, 'Flota Škoda ', 'flota-skoda', '238.jpg', NULL, NULL, '', '', '<p>Flota Škoda</p>', 27, 4, 50, 'Y', 'Y', 10, '2008-09-02 11:49:32'),
(239, 'pl', 35, 0, 'Historia Carsed', 'historia-carsed', '239.jpg', NULL, NULL, '', '', '<p>Historia Carsed</p>', 9, 85, 12, 'Y', 'Y', 10, '2008-09-02 12:26:08'),
(8, 'pl', 0, 0, 'Modele użytkowe', 'modele-uzytkowe', '180.swf', '', '', '', '', 'Modele użytkowe', 31, 0, 11, 'Y', 'Y', 10, '2009-05-25 10:05:35'),
(242, 'pl', 0, 0, 'Komis', 'komis', '', '', '', '', '', 'Komis', 32, 0, 50, 'Y', 'Y', 10, '2009-05-25 10:05:39');

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

--
-- Struktura tabeli dla  `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `id_module` int(11) NOT NULL auto_increment,
  `lang` varchar(3) NOT NULL default 'pl',
  `modulename` varchar(255) NOT NULL default '',
  `friendlyname` varchar(255) NOT NULL,
  `tablename` varchar(100) NOT NULL,
  `primarykeyname` varchar(50) NOT NULL,
  `search_fields` text NOT NULL,
  `active` enum('Y','N') NOT NULL default 'Y',
  `deleteable` enum('Y','N') NOT NULL default 'Y',
  `website` enum('Y','N') NOT NULL default 'N',
  `showinmenu` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`id_module`),
  KEY `showinmenu` (`showinmenu`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='moduły CMS' AUTO_INCREMENT=33 ;

--
-- Zrzut danych tabeli `modules`
--

INSERT INTO `modules` (`id_module`, `lang`, `modulename`, `friendlyname`, `tablename`, `primarykeyname`, `search_fields`, `active`, `deleteable`, `website`, `showinmenu`) VALUES
(1, 'pl', 'mainpage', 'Strona główna', '', '', '', 'Y', 'N', 'Y', 'Y'),
(10, 'pl', 'model', 'Modele osobowe', 'model', 'id_model', 'name_model,intro,description', 'Y', 'N', 'N', 'N'),
(9, 'pl', 'text', 'Strony tekstowe', 'text', 'id_text', 'name_text,intro,src', 'Y', 'Y', 'Y', 'Y'),
(11, 'pl', 'menu', 'Menu', 'menu', '', '', 'Y', 'N', 'N', 'Y'),
(12, 'pl', 'gallery', 'Galerie', 'gallery_pictures', 'id', '', 'Y', 'Y', 'Y', 'Y'),
(13, 'pl', 'file', 'Pliki', 'file_files', 'id', '', 'Y', 'Y', 'N', 'Y'),
(14, 'pl', 'accessories', 'Akcesoria', 'accessories_items', 'id', '', 'Y', 'N', 'N', 'N'),
(16, 'pl', 'links', 'Szybkie linki', 'links_link', 'id_link', '', 'Y', 'Y', 'N', 'Y'),
(18, 'pl', 'price', 'Cennik', '', '', '', 'Y', 'Y', 'Y', 'N'),
(19, 'pl', 'engines', 'Silniki', 'model_engines', '', '', 'Y', 'Y', 'N', 'N'),
(20, 'pl', 'versions', 'Wersje wyposażenia', 'model_versions', '', '', 'Y', 'Y', 'N', 'N'),
(21, 'pl', 'search', 'Wyszukiwarka', '', '', '', 'Y', 'Y', 'Y', 'N'),
(26, 'pl', 'category', 'Agregatory', 'categoryitem', 'id_categoryitem', 'name_categoryitem,intro,description', 'Y', 'N', 'Y', 'Y'),
(23, 'pl', 'contact', 'Kontakt', '', '', '', 'Y', 'Y', 'N', 'N'),
(24, 'pl', 'sitemap', 'Mapa strony', '', '', '', 'Y', 'Y', 'Y', 'N'),
(25, 'pl', 'newsletter', 'Newsletter', '', '', '', 'Y', 'Y', 'Y', 'N'),
(27, 'pl', 'flashpage', 'Strona flashowa', '', '', '', 'Y', 'Y', 'Y', 'Y'),
(28, 'pl', 'flashimages', 'Strona główna - zestawy obrazków', '', '', '', 'Y', 'Y', 'Y', 'Y'),
(29, 'pl', 'contactmap', 'Kontakt z mapą Google', '', '', '', 'Y', 'Y', 'Y', 'Y'),
(30, 'pl', 'dealer_shops', 'Punkty dealerskie', 'dealer_shops', 'id_dealer_shops', 'name_dealer_shops,description', 'Y', 'Y', 'Y', 'Y'),
(31, 'pl', 'van', 'Modele użytkowe', 'van', 'id_van', 'name_van,intro,description', 'Y', 'N', 'N', 'N'),
(32, 'pl', 'autokomis', 'Autokomis', '', '', '', 'Y', 'Y', 'Y', 'Y');

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

--
-- Struktura tabeli dla  `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `user` int(11) unsigned NOT NULL,
  `module` int(11) unsigned NOT NULL default '0',
  `permission` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user`,`module`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Zrzut danych tabeli `permissions`
--

INSERT INTO `permissions` (`user`, `module`, `permission`) VALUES
(7, 1, 3),
(7, 9, 3),
(7, 10, 3),
(7, 11, 3),
(7, 12, 3),
(7, 13, 3),
(7, 14, 3),
(7, 16, 3),
(7, 18, 3),
(7, 19, 3),
(7, 20, 3),
(7, 21, 3),
(7, 23, 3),
(7, 24, 3),
(7, 25, 3),
(7, 26, 3),
(7, 27, 3),
(7, 28, 3),
(7, 29, 3),
(7, 30, 3),
(10, 1, 3),
(10, 9, 3),
(10, 10, 3),
(10, 11, 3),
(10, 12, 3),
(10, 13, 3),
(10, 14, 3),
(10, 16, 3),
(10, 18, 3),
(10, 19, 3),
(10, 20, 3),
(10, 21, 0),
(10, 23, 0),
(10, 24, 0),
(10, 25, 3),
(10, 26, 3),
(10, 27, 3),
(10, 28, 3),
(10, 29, 3),
(10, 30, 3),
(10, 31, 0),
(10, 32, 3),
(11, 1, 3),
(11, 9, 3),
(11, 10, 3),
(11, 11, 3),
(11, 12, 3),
(11, 13, 3),
(11, 14, 3),
(11, 16, 3),
(11, 18, 3),
(11, 19, 3),
(11, 20, 3),
(11, 21, 3),
(11, 23, 3),
(11, 24, 3),
(11, 25, 3),
(11, 26, 3),
(11, 27, 3),
(11, 28, 3),
(11, 29, 3),
(11, 30, 3),
(12, 1, 3),
(12, 9, 3),
(12, 10, 3),
(12, 11, 3),
(12, 12, 3),
(12, 13, 3),
(12, 14, 3),
(12, 16, 3),
(12, 18, 3),
(12, 19, 3),
(12, 20, 3),
(12, 21, 3),
(12, 23, 3),
(12, 24, 3),
(12, 25, 3),
(12, 26, 3),
(12, 27, 3),
(12, 28, 3),
(12, 29, 3),
(12, 30, 3),
(13, 1, 0),
(13, 9, 0),
(13, 10, 0),
(13, 11, 0),
(13, 12, 0),
(13, 13, 0),
(13, 14, 0),
(13, 16, 0),
(13, 18, 0),
(13, 19, 0),
(13, 20, 0),
(13, 21, 0),
(13, 23, 0),
(13, 24, 0),
(13, 25, 0),
(13, 26, 0),
(13, 27, 0),
(13, 28, 0),
(13, 29, 0),
(13, 30, 0),
(13, 31, 0),
(13, 32, 3);

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

--
-- Struktura tabeli dla  `usage`
--

CREATE TABLE IF NOT EXISTS `usage` (
  `id_usage` int(11) NOT NULL auto_increment,
  `object_type` enum('file','link') NOT NULL,
  `object_id` int(11) NOT NULL,
  `module_type` enum('model','mainpage','text') NOT NULL,
  `module_id` int(11) NOT NULL,
  PRIMARY KEY  (`id_usage`),
  KEY `object_type` (`object_type`,`module_type`,`module_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=743 ;

--
-- Zrzut danych tabeli `usage`
--

INSERT INTO `usage` (`id_usage`, `object_type`, `object_id`, `module_type`, `module_id`) VALUES
(742, 'link', 3, 'mainpage', 0),
(113, 'link', 5, 'model', 13),
(546, 'file', 4, 'model', 12),
(518, 'file', 5, 'model', 14),
(510, 'file', 7, 'model', 1),
(137, 'file', 9, 'model', 11),
(534, 'file', 8, 'model', 16),
(502, 'file', 10, 'model', 9),
(139, 'file', 6, 'model', 5),
(530, 'file', 11, 'model', 8),
(545, 'link', 6, 'model', 12),
(517, 'link', 11, 'model', 14),
(606, 'file', 4, 'text', 12),
(686, 'file', 13, 'model', 15),
(706, 'file', 5, 'text', 28),
(712, 'file', 4, 'text', 40),
(720, 'file', 8, 'text', 46),
(716, 'file', 7, 'text', 42),
(726, 'file', 11, 'text', 49),
(728, 'file', 10, 'text', 52),
(724, 'file', 9, 'text', 50),
(710, 'file', 13, 'text', 53),
(114, 'file', 14, 'model', 13),
(685, 'link', 9, 'model', 15),
(533, 'link', 8, 'model', 16),
(136, 'link', 12, 'model', 11),
(138, 'link', 10, 'model', 5),
(501, 'link', 12, 'model', 9),
(529, 'link', 7, 'model', 8),
(509, 'link', 8, 'model', 1),
(699, 'link', 9, 'text', 75),
(700, 'file', 13, 'text', 75),
(727, 'link', 15, 'text', 52),
(673, 'link', 9, 'text', 74),
(693, 'link', 12, 'text', 79),
(694, 'file', 9, 'text', 79),
(723, 'link', 12, 'text', 50),
(613, 'link', 13, 'text', 44),
(614, 'file', 8, 'text', 44),
(461, 'link', 13, 'text', 45),
(462, 'file', 8, 'text', 45),
(719, 'link', 13, 'text', 46),
(709, 'link', 9, 'text', 53),
(725, 'link', 7, 'text', 49),
(621, 'link', 7, 'text', 47),
(622, 'file', 11, 'text', 47),
(473, 'link', 7, 'text', 48),
(474, 'file', 11, 'text', 48),
(715, 'link', 8, 'text', 42),
(619, 'link', 8, 'text', 41),
(620, 'file', 7, 'text', 41),
(469, 'link', 8, 'text', 43),
(470, 'file', 7, 'text', 43),
(705, 'link', 11, 'text', 28),
(605, 'link', 6, 'text', 12),
(451, 'link', 11, 'text', 27),
(452, 'file', 5, 'text', 27),
(607, 'link', 6, 'text', 38),
(608, 'file', 4, 'text', 38),
(609, 'link', 6, 'text', 39),
(610, 'file', 4, 'text', 39),
(711, 'link', 6, 'text', 40),
(674, 'file', 13, 'text', 74);

--
-- Ograniczenia dla zrzutów tabel
--

--
-- Ograniczenia dla tabeli `autokomis_attributes`
--
ALTER TABLE `autokomis_attributes`
  ADD CONSTRAINT `FK_autokomis_attributes_1` FOREIGN KEY (`id_autokomis_cars`) REFERENCES `autokomis_cars` (`id_autokomis_cars`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ograniczenia dla tabeli `autokomis_equipment`
--
ALTER TABLE `autokomis_equipment`
  ADD CONSTRAINT `FK_autokomis_equipment_1` FOREIGN KEY (`id_autokomis_cars`) REFERENCES `autokomis_cars` (`id_autokomis_cars`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ograniczenia dla tabeli `autokomis_files`
--
ALTER TABLE `autokomis_files`
  ADD CONSTRAINT `FK_autokomis_files_1` FOREIGN KEY (`id_autokomis_cars`) REFERENCES `autokomis_cars` (`id_autokomis_cars`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ograniczenia dla tabeli `autokomis_owners`
--
ALTER TABLE `autokomis_owners`
  ADD CONSTRAINT `FK_autokomis_owner_1` FOREIGN KEY (`id_autokomis_cars`) REFERENCES `autokomis_cars` (`id_autokomis_cars`) ON DELETE CASCADE ON UPDATE CASCADE;
