-- phpMyAdmin SQL Dump
-- version 2.8.2
-- http://www.phpmyadmin.net
-- 
-- Hostiteľ: localhost
-- Vygenerované:: 10.Máj, 2009 - 17:30
-- Verzia serveru: 5.0.45
-- Verzia PHP: 5.2.3
-- 
-- Databáza: `reklama`
-- 

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

-- 
-- Štruktúra tabuľky pre tabuľku `clanky`
-- 

DROP TABLE IF EXISTS `clanky`;
CREATE TABLE IF NOT EXISTS `clanky` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nazov_sk` varchar(255) NOT NULL,
  `nazov_hu` varchar(255) NOT NULL,
  `text_sk` text NOT NULL,
  `text_hu` text NOT NULL,
  `nazov_en` varchar(255) NOT NULL,
  `text_en` text NOT NULL,
  `identificator` varchar(64) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

-- 
-- Sťahujem dáta pre tabuľku `clanky`
-- 

INSERT INTO `clanky` (`id`, `nazov_sk`, `nazov_hu`, `text_sk`, `text_hu`, `nazov_en`, `text_en`, `identificator`) VALUES (2, 'Vitajte', 'Welcome', 'Vitajte<br><br>\nTest!', 'Welcome', 'Welcome', 'Welcome', 'welcome'),
(3, 'Vazeny zakaznik', 'Dear customer', 'blablabla', 'blablabla', 'Dear customer', 'blablabla', 'customer'),
(4, 'Vazeny manazer', 'Dear manager', 'blablabla', 'blablabla', 'Dear manager', 'blablabla', 'enterprise'),
(5, 'Kontakt', 'Contact', 'blablabla', 'blablabla', 'Contact', 'blablabla', 'contact'),
(6, 'Novinky', '', '', '', '', '', 'news'),
(7, 'Služby', '', '', '', '', '', 'services'),
(8, 'Členský certifikát', '', '', '', '', '', 'certificate'),
(9, 'Ako vyplnit zmluvu na kúpu karty', '', '', '', '', '', 'about_cart'),
(10, 'Ako vyplnit zmluvu pre firmy propagované zdarma', '', '', '', '', '', 'about_firms'),
(11, 'Ako vyplnit zmluvu clenskeho certifikatu', '', '', '', '', '', 'about_certificate'),
(12, 'Ako tlacit objstranne dokumenty', '', '', '', '', '', 'about_printing');

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

-- 
-- Štruktúra tabuľky pre tabuľku `firmy`
-- 

DROP TABLE IF EXISTS `firmy`;
CREATE TABLE IF NOT EXISTS `firmy` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nazov` varchar(255) NOT NULL,
  `kategoria_id` int(10) unsigned NOT NULL,
  `obrazok` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `datum` int(10) unsigned NOT NULL,
  `adresa` tinytext NOT NULL,
  `popis` text NOT NULL,
  `zlava` text NOT NULL,
  `kluce` text NOT NULL,
  `web_cenniky` varchar(255) NOT NULL,
  `web_akcie` varchar(255) NOT NULL,
  `clenska` tinyint(1) NOT NULL,
  `cislo` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

-- 
-- Sťahujem dáta pre tabuľku `firmy`
-- 

INSERT INTO `firmy` (`id`, `nazov`, `kategoria_id`, `obrazok`, `logo`, `link`, `datum`, `adresa`, `popis`, `zlava`, `kluce`, `web_cenniky`, `web_akcie`, `clenska`, `cislo`) VALUES (1, 'Pokus a.s.', 2, 'startrek.jpg', 'test.jpg', 'http://reklama.localhost.sk', 1208247672, '', '', '', '', '', '', 0, 0),
(2, 'Rybár s.r.o.', 2, 'test.jpg', 'test.jpg', '', 1207393732, '', '', '', '', '', '', 0, 0),
(3, 'Pokus1', 3, 'test.jpg', 'test.jpg', '', 1207393733, '', '', '', '', '', '', 0, 0),
(4, 'pokus3', 2, 'test.jpg', 'test.jpg', '', 1207393734, '', '', '', '', '', '', 0, 0),
(5, 'pokus2', 1, 'test.jpg', 'test.jpg', '', 1207000000, '', '', '', '', '', '', 0, 0),
(6, 'Test', 1, 'test.jpg', 'test.jpg', '', 1208015190, '', '', '', '', '', '', 0, 0),
(13, 'bla bla bla', 2, 'startrek.jpg', 'test.jpg', 'http://reklama.localhost.sk', 1220272385, 'Bla bla bla\nbla bla bla', 'Bla bla bla\nbla bla bla', 'Bla bla bla\nbla bla bla', 'bla bla bla bla', 'http://reklama.localhost.sk', 'http://reklama.localhost.sk', 1, 0),
(14, 'Šamorín', 2, 'startrek.jpg', 'test.jpg', '', 1220348735, '', '', '', '', '', '', 1, 25);

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

-- 
-- Štruktúra tabuľky pre tabuľku `kategorie`
-- 

DROP TABLE IF EXISTS `kategorie`;
CREATE TABLE IF NOT EXISTS `kategorie` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nazov_sk` varchar(255) NOT NULL,
  `nazov_hu` varchar(255) NOT NULL,
  `nazov_en` varchar(255) NOT NULL,
  `skryta` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Sťahujem dáta pre tabuľku `kategorie`
-- 

INSERT INTO `kategorie` (`id`, `nazov_sk`, `nazov_hu`, `nazov_en`, `skryta`) VALUES (1, 'Stavebnictvo', 'Building', 'Building', 0),
(2, 'Namornictvo', 'Navy', 'Navy', 0),
(3, 'Strojarstvo', 'Mechanik', 'Mechanik', 0),
(4, 'Test', 'Test', 'Test', 0);

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

-- 
-- Štruktúra tabuľky pre tabuľku `nastavenia`
-- 

DROP TABLE IF EXISTS `nastavenia`;
CREATE TABLE IF NOT EXISTS `nastavenia` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nazov` varchar(255) NOT NULL,
  `hodnota` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 AUTO_INCREMENT=76 ;

-- 
-- Sťahujem dáta pre tabuľku `nastavenia`
-- 

INSERT INTO `nastavenia` (`id`, `nazov`, `hodnota`) VALUES (71, 'hlavny_jazyk', 'sk'),
(72, 'firiem_na_stranku', '50'),
(73, 'strankovanie_pocet_listov', '5'),
(74, 'meno_admina', 'admin'),
(75, 'heslo_admina', '6e017b5464f820a6c1bb5e9f6d711a667a80d8ea');

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

-- 
-- Štruktúra tabuľky pre tabuľku `sessions`
-- 

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE IF NOT EXISTS `sessions` (
  `session_id` varchar(40) NOT NULL,
  `ip_address` varchar(16) NOT NULL,
  `user_agent` varchar(50) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Sťahujem dáta pre tabuľku `sessions`
-- 

INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('6436f8c0a9106bebd633d32c48218c64', '127.0.0.1', 'Opera/9.64 (Windows NT 5.1; U; cs) Presto/2.1.1', 1241969096);
