-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Počítač: s_mysql50
-- Vygenerováno: Pondělí 13. září 2010, 11:25
-- Verze MySQL: 5.0.45
-- Verze PHP: 5.2.8-pl1-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Databáze: `nexus_chatamedika`
--

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

--
-- Struktura tabulky `guestbook`
--

CREATE TABLE IF NOT EXISTS `guestbook` (
  `id` int(11) NOT NULL auto_increment,
  `date` datetime default NULL,
  `text` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=15 ;

--
-- Vypisuji data pro tabulku `guestbook`
--

INSERT INTO `guestbook` (`id`, `date`, `text`) VALUES
(1, '2020-08-20 10:00:00', 'erter tert er tert ert er ter tert \r\nert ert ert ert ert ert ert e\r\n ert ert ert ert ert ert \r\n ertert '),
(2, '0000-00-00 00:00:00', ''),
(3, '2010-08-04 21:52:39', 'Neco dalsiho co sem davam..\r\n\r\na s enterem'),
(9, '2005-08-20 10:00:00', 'kkkkkkkkkkkkkkkkk\r\n\r\n\r\nasdasdasdasdasdasd'),
(5, '2005-08-20 10:00:00', 'dsfsfsfsdfafasfadsf\r\n\r\nbbfbfbfbfbfbfbfbf'),
(7, '2005-08-20 10:00:00', 'bubububnubnubn\r\n\r\n\r\n\r\ndubudubu'),
(8, '2005-08-20 10:00:00', 'kkkkkkkkkkkkkkkkk\r\n\r\n\r\nasdadadasda'),
(10, '2005-08-20 10:00:00', 'werwe wer werwer ber ber ber'),
(11, '2005-08-20 10:00:00', 'ghjkghjfgjfgjhgjfghjetg a ghshtndsbvdsg  sdasddsa'),
(12, '2010-08-09 17:38:48', 'zutzutz'),
(13, '2010-08-11 10:26:57', 'Na Medice jsem byla velice spokojena, chata je položena v krásném prostředí a personál je velice vstřícný. Mohu doporučit všem:) '),
(14, '2010-08-13 10:36:08', 'wer');

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

--
-- Struktura tabulky `wolfsight_access_log`
--

CREATE TABLE IF NOT EXISTS `wolfsight_access_log` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(40) default '0',
  `login` varchar(60) default '0',
  `session_id` varchar(32) default NULL,
  `ip` varchar(20) default '0',
  `time` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=11 ;

--
-- Vypisuji data pro tabulku `wolfsight_access_log`
--

INSERT INTO `wolfsight_access_log` (`id`, `user`, `login`, `session_id`, `ip`, `time`) VALUES
(1, 3, 'vlk', 'e665c59d11d9ecc44ecbcc02a66a88ec', '84.42.182.192', '2010-08-05 12:49:59'),
(2, 3, 'vlk', 'd35d25c80805b12db052a4b724850b9f', '89.24.142.189', '2010-08-05 12:50:15'),
(3, 3, 'vlk', 'd35d25c80805b12db052a4b724850b9f', '89.24.142.189', '2010-08-05 12:50:57'),
(4, 3, 'vlk', 'e665c59d11d9ecc44ecbcc02a66a88ec', '84.42.182.192', '2010-08-05 12:52:56'),
(5, 3, 'vlk', 'b1ff28354a89865e585968f06505779e', '89.24.142.189', '2010-08-05 17:06:06'),
(6, 3, 'vlk', 'e665c59d11d9ecc44ecbcc02a66a88ec', '84.42.182.192', '2010-08-05 17:09:22'),
(7, 3, 'vlk', 'e665c59d11d9ecc44ecbcc02a66a88ec', '84.42.182.192', '2010-08-05 17:10:52'),
(8, 3, 'vlk', 'b1ff28354a89865e585968f06505779e', '89.24.142.189', '2010-08-05 17:16:09'),
(9, 3, 'vlk', 'e665c59d11d9ecc44ecbcc02a66a88ec', '84.42.182.192', '2010-08-07 09:48:59'),
(10, 3, 'vlk', '57d7629d4b8ed82fa1d2d32739f9a4ac', '84.42.182.192', '2010-08-09 09:02:16');

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

--
-- Struktura tabulky `wolfsight_audit`
--

CREATE TABLE IF NOT EXISTS `wolfsight_audit` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `occured` datetime NOT NULL,
  `component_id` int(11) NOT NULL,
  `event` int(11) NOT NULL,
  `data` varchar(250) NOT NULL,
  `related_id` varchar(250) NOT NULL,
  `session_id` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=23 ;

--
-- Vypisuji data pro tabulku `wolfsight_audit`
--

INSERT INTO `wolfsight_audit` (`id`, `user_id`, `occured`, `component_id`, `event`, `data`, `related_id`, `session_id`) VALUES
(1, 3, '2010-08-04 21:09:07', 4, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(2, 3, '2010-08-04 21:10:10', 3, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(3, 3, '2010-08-04 21:10:23', 17, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(4, 3, '2010-08-04 21:12:27', 10, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(5, 3, '2010-08-04 21:12:31', 3, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(6, 3, '2010-08-04 21:12:35', 17, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(7, 3, '2010-08-05 12:50:08', 17, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(8, 3, '2010-08-05 12:50:08', 3, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(9, 3, '2010-08-05 12:50:39', 3, 1, '', '', 'd35d25c80805b12db052a4b724850b9f'),
(10, 3, '2010-08-05 12:50:39', 17, 1, '', '', 'd35d25c80805b12db052a4b724850b9f'),
(11, 3, '2010-08-05 12:50:49', 9, 1, '', '', 'd35d25c80805b12db052a4b724850b9f'),
(12, 3, '2010-08-05 12:51:15', 17, 1, '', '', 'd35d25c80805b12db052a4b724850b9f'),
(13, 3, '2010-08-05 12:52:18', 4, 1, '', '', 'd35d25c80805b12db052a4b724850b9f'),
(14, 3, '2010-08-05 12:52:26', 13, 1, '', '', 'd35d25c80805b12db052a4b724850b9f'),
(15, 3, '2010-08-05 12:59:12', 17, 1, '', '', 'd35d25c80805b12db052a4b724850b9f'),
(16, 3, '2010-08-05 17:08:02', 17, 1, '', '', 'b1ff28354a89865e585968f06505779e'),
(17, 3, '2010-08-05 17:09:23', 1, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(18, 3, '2010-08-05 17:09:27', 4, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(19, 3, '2010-08-05 17:10:52', 17, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(20, 3, '2010-08-05 17:16:10', 17, 1, '', '', 'b1ff28354a89865e585968f06505779e'),
(21, 3, '2010-08-07 09:48:59', 17, 1, '', '', 'e665c59d11d9ecc44ecbcc02a66a88ec'),
(22, 3, '2010-08-09 09:02:16', 17, 1, '', '', '57d7629d4b8ed82fa1d2d32739f9a4ac');

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

--
-- Struktura tabulky `wolfsight_components`
--

CREATE TABLE IF NOT EXISTS `wolfsight_components` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `identifier` varchar(150) NOT NULL,
  `view_name` varchar(150) NOT NULL,
  `description` varchar(250) default NULL,
  `path` varchar(200) NOT NULL,
  `core` tinyint(4) NOT NULL default '0',
  `restricted` tinyint(3) unsigned NOT NULL default '1',
  `basic_class` varchar(80) default NULL,
  `rank` tinyint(4) NOT NULL,
  `topmenu` tinyint(3) unsigned default '1',
  `shadow` smallint(3) unsigned default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `identifier` (`identifier`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=18 ;

--
-- Vypisuji data pro tabulku `wolfsight_components`
--

INSERT INTO `wolfsight_components` (`id`, `name`, `identifier`, `view_name`, `description`, `path`, `core`, `restricted`, `basic_class`, `rank`, `topmenu`, `shadow`) VALUES
(1, 'WolfSight Authorization', 'wsa', 'Uživatelé', 'Nastavení uživatelských práv', 'WolfSightAuthorization/wsa_index.php', 1, 1, 'WolfSightAuthorization', 0, 1, 0),
(2, 'WolfSight Security Settings', 'wsss', 'Nastavení', 'Security Settings', 'WolfSightSecuritySettings/index.php', 1, 1, 'WolfSightSecuritySettings', 5, 1, 0),
(3, 'WolfSight Component Manager', 'ws_compman', 'WolfSight Component Manager', '', 'WolfSightComponentManager/index.php', 1, 1, NULL, 6, 1, 0),
(4, 'WolfSight User Options', 'wsopts', 'Možnosti', 'Uľivatelské nastavení', 'WolfSightUserOptions/index.php', 1, 0, 'WolfSightUserOptions', 8, 1, 0),
(5, 'WolfSight About', 'about', 'O programu', ' ', 'WolfSightAbout/index.php', 1, 0, NULL, 10, 1, 0),
(6, 'WolfSight Manual', 'manual', 'Manual', 'Manual', 'WolfSightManual/index.php', 1, 0, NULL, 11, 1, 0),
(9, 'WolfSight Gallery', 'wgall', 'Galerie', '', 'WolfSightGallery/gallery.php', 1, 1, 'WolfSightGallery', 100, 1, 0),
(10, 'WolfSight SqlErrors', 'sqlerr', 'Chybová konzola SQL', ' ', 'WolfSightSqlErrors/sqlerror.php', 1, 1, 'WolfSightSqlErrors', 100, 1, 0),
(11, 'WolfSight Access Log', 'wslog', 'Přístupový log', '', 'WolfSightAccessLog/accesslog.php', 1, 1, 'WolfSightAccessLog', 5, 1, 0),
(12, 'WolfSight Seo Settings', 'seo_settings', 'SEO', '', 'WolfSightSEO/index.php', 1, 1, 'WolfSightSeoSettings', 15, 1, 0),
(13, 'WolfSight Web Settings', 'web_settings', 'Web Settings', '', 'WolfSightWebSettings/index.php', 1, 1, 'WolfSightWebSettings', 20, 1, 0),
(16, 'WolfSight Specific Settings', 'spec_settings', 'Specifické nastavení', ' ', 'WolfSightSpecificSettings/index.php', 1, 1, 'WolfSighSpecificSettings', 100, 1, 0),
(17, 'GuestBook', 'guestbook', 'Nástěnka', NULL, 'GuestBook/guestbook.php', 0, 1, 'WGuestBook', 100, 1, 0);

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

--
-- Struktura tabulky `wolfsight_gallery`
--

CREATE TABLE IF NOT EXISTS `wolfsight_gallery` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `description` varchar(255) default NULL,
  `date` datetime default NULL,
  `rank` tinyint(4) default NULL,
  `flags` tinyint(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;

--
-- Vypisuji data pro tabulku `wolfsight_gallery`
--


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

--
-- Struktura tabulky `wolfsight_gallery_files`
--

CREATE TABLE IF NOT EXISTS `wolfsight_gallery_files` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `full` varchar(150) default NULL,
  `thumb` varchar(150) default NULL,
  `uploaded` datetime default NULL,
  `updated` datetime default NULL,
  `type` tinyint(3) unsigned default '0',
  `width` tinyint(3) unsigned default '0',
  `height` tinyint(3) unsigned default '0',
  `name` varchar(150) default '0',
  `description` varchar(255) default NULL,
  `gallery_id` int(11) unsigned default NULL,
  `rank` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;

--
-- Vypisuji data pro tabulku `wolfsight_gallery_files`
--


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

--
-- Struktura tabulky `wolfsight_languages`
--

CREATE TABLE IF NOT EXISTS `wolfsight_languages` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `abbrev` varchar(5) NOT NULL default '',
  `flag` varchar(30) NOT NULL default '',
  `rank` tinyint(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `wolfsight_languages`
--

INSERT INTO `wolfsight_languages` (`id`, `name`, `abbrev`, `flag`, `rank`) VALUES
(1, 'Česky', 'CZ', '', 1);

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

--
-- Struktura tabulky `wolfsight_privileges`
--

CREATE TABLE IF NOT EXISTS `wolfsight_privileges` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `component_id` varchar(50) NOT NULL,
  `bitmask` tinyint(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;

--
-- Vypisuji data pro tabulku `wolfsight_privileges`
--


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

--
-- Struktura tabulky `wolfsight_reports`
--

CREATE TABLE IF NOT EXISTS `wolfsight_reports` (
  `varid` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL,
  `value` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

--
-- Vypisuji data pro tabulku `wolfsight_reports`
--

INSERT INTO `wolfsight_reports` (`varid`, `description`, `value`) VALUES
('admin_notify', 'Date of admin notify about errors', '2010-03-03 18:13:54');

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

--
-- Struktura tabulky `wolfsight_security_settings`
--

CREATE TABLE IF NOT EXISTS `wolfsight_security_settings` (
  `request_captcha` tinyint(3) unsigned default '0',
  `expiration` tinyint(3) unsigned default '0',
  `shortest_pass` tinyint(3) unsigned default '0',
  `allow_ip` varchar(256) default '0',
  `deny_ip` varchar(256) default '0',
  `admin_email` varchar(100) NOT NULL,
  `sql_errors_send` tinyint(4) NOT NULL,
  `show_inaccessible_comps` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

--
-- Vypisuji data pro tabulku `wolfsight_security_settings`
--

INSERT INTO `wolfsight_security_settings` (`request_captcha`, `expiration`, `shortest_pass`, `allow_ip`, `deny_ip`, `admin_email`, `sql_errors_send`, `show_inaccessible_comps`) VALUES
(0, 200, 6, '', '', 'martin.grega@nexus.cz', 50, 0);

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

--
-- Struktura tabulky `wolfsight_seo_settings`
--

CREATE TABLE IF NOT EXISTS `wolfsight_seo_settings` (
  `page_title` varchar(255) NOT NULL,
  `page_keywords` varchar(255) NOT NULL,
  `page_description` varchar(255) NOT NULL,
  `google_analytics` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

--
-- Vypisuji data pro tabulku `wolfsight_seo_settings`
--

INSERT INTO `wolfsight_seo_settings` (`page_title`, `page_keywords`, `page_description`, `google_analytics`) VALUES
('WolfSight powered', 'admin, web, wolfsight', 'Administrační systém', '<script type="text/javascript">\r\nvar gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");\r\ndocument.write(unescape("%3Cscript src=''" + gaJsHost + "google-analytics.com/ga.js'' type=''text/javascript''%3E%3C/script%3E"));\r\n</script>\r\n<script type="text/javascript">\r\ntry {\r\nvar pageTracker = _gat._getTracker("UA-11970706-1");\r\npageTracker._trackPageview();\r\n} catch(err) {}</script>');

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

--
-- Struktura tabulky `wolfsight_sql_errors`
--

CREATE TABLE IF NOT EXISTS `wolfsight_sql_errors` (
  `id` int(11) NOT NULL auto_increment,
  `occured` datetime NOT NULL,
  `query` text NOT NULL,
  `error` text NOT NULL,
  `address` varchar(200) default NULL,
  `flags` tinyint(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=2 ;

--
-- Vypisuji data pro tabulku `wolfsight_sql_errors`
--


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

--
-- Struktura tabulky `wolfsight_users`
--

CREATE TABLE IF NOT EXISTS `wolfsight_users` (
  `id` smallint(6) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `login` varchar(32) NOT NULL,
  `pass` varchar(100) NOT NULL,
  `role` varchar(20) NOT NULL default '0',
  `last_logged` datetime NOT NULL default '0000-00-00 00:00:00',
  `logincount` int(11) NOT NULL,
  `ip_allowed` varchar(150) NOT NULL,
  `blocked` tinyint(4) NOT NULL,
  `can_change_pass` tinyint(4) default NULL,
  `must_change_pass` tinyint(3) unsigned default NULL,
  `current_session_id` varchar(40) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=4 ;

--
-- Vypisuji data pro tabulku `wolfsight_users`
--

INSERT INTO `wolfsight_users` (`id`, `name`, `login`, `pass`, `role`, `last_logged`, `logincount`, `ip_allowed`, `blocked`, `can_change_pass`, `must_change_pass`, `current_session_id`) VALUES
(3, 'Robin Ortega', 'vlk', '65383858b763d26238ae7e3e8ef72df8', 'Super Administrator', '2010-08-09 09:02:16', 72, '', 0, NULL, NULL, '');

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

--
-- Struktura tabulky `wolfsight_user_options`
--

CREATE TABLE IF NOT EXISTS `wolfsight_user_options` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `component_id` varchar(50) default '0',
  `setting_id` varchar(50) default '0',
  `value` varchar(100) default '0',
  `user_id` smallint(11) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=15 ;

--
-- Vypisuji data pro tabulku `wolfsight_user_options`
--

INSERT INTO `wolfsight_user_options` (`id`, `component_id`, `setting_id`, `value`, `user_id`) VALUES
(1, 'core', 'language', 'czech', 3),
(2, 'core', 'hp', '1|guestbook', 3),
(3, 'core', 'scrolling', '50', 3),
(4, 'core', 'html_editor', 'fck', 3),
(5, 'core', 'keep_search', '1', 3),
(6, 'core', 'stay_after_save', '0', 3),
(7, 'core', 'delete_option', '0', 3),
(8, 'core', 'language', 'czech', 0),
(9, 'core', 'hp', '0', 0),
(10, 'core', 'scrolling', '50', 0),
(11, 'core', 'html_editor', 'fck', 0),
(12, 'core', 'keep_search', '1', 0),
(13, 'core', 'stay_after_save', '0', 0),
(14, 'core', 'delete_option', '0', 0);

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

--
-- Struktura tabulky `wolfsight_web_settings`
--

CREATE TABLE IF NOT EXISTS `wolfsight_web_settings` (
  `component` varchar(50) NOT NULL,
  `param` varchar(50) NOT NULL,
  `value` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

--
-- Vypisuji data pro tabulku `wolfsight_web_settings`
--

INSERT INTO `wolfsight_web_settings` (`component`, `param`, `value`) VALUES
('core', 'web_online', '1'),
('core', 'debug_mode', '1'),
('wgall', 'save_directory', '1'),
('wgall', 'image_prefix', '2'),
('wgall', 'thumb_width', '3'),
('wgall', 'thumb_height', '4'),
('wgall', 'orig_width', '5'),
('wgall', 'orig_height', '6'),
('wgall', 'watermark', '7'),
('wgall', 'save_directory', '../upload/gallery'),
('wgall', 'image_prefix', 'i-miss_'),
('wgall', 'thumb_width', '200'),
('wgall', 'thumb_height', '-1'),
('wgall', 'orig_width', '745'),
('wgall', 'orig_height', '-1'),
('wgall', 'watermark', '');

/*!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 */;