-- phpMyAdmin SQL Dump -- version 2.6.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 22, 2006 at 04:31 PM -- Server version: 4.1.11 -- PHP Version: 5.0.4 -- -- Database: `phpPlant2` -- -- -------------------------------------------------------- -- -- Table structure for table `address` -- DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `id_address` int(10) unsigned NOT NULL auto_increment, `street` varchar(255) default NULL, `city` varchar(255) default NULL, `zip` int(10) unsigned default NULL, `mail` varchar(255) default NULL, `icq` int(10) unsigned default NULL, `mobil` varchar(30) default NULL, `id_user` int(11) NOT NULL default '0', PRIMARY KEY (`id_address`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `address` -- INSERT INTO `address` (`id_address`, `street`, `city`, `zip`, `mail`, `icq`, `mobil`, `id_user`) VALUES (1, 'Novodvorská 255', 'milovice', 28923, 'novak@email.cz', 321123, '666789321', 1); INSERT INTO `address` (`id_address`, `street`, `city`, `zip`, `mail`, `icq`, `mobil`, `id_user`) VALUES (8, '', '', 0, 'mail2@centrum.cz', 0, '', 9); -- -------------------------------------------------------- -- -- Table structure for table `application_file` -- DROP TABLE IF EXISTS `application_file`; CREATE TABLE `application_file` ( `id_application_file` int(10) unsigned NOT NULL auto_increment, `filename` varchar(255) NOT NULL default '', PRIMARY KEY (`id_application_file`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ; -- -- Dumping data for table `application_file` -- INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (1, 'first_page.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (2, 'logoff.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (3, 'index.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (35, 'about.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (33, 'user_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (39, 'user_add.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (7, 'article_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (40, 'article_add.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (9, 'article_category.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (34, 'publish_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (12, 'enquiry_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (13, 'enquiry_add.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (15, 'news_add.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (38, 'user_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (17, 'user_group.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (18, 'user_group_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (19, 'user_group_add.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (20, 'user_group_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (21, 'article_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (22, 'article_category_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (23, 'article_category_add.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (42, 'article_category_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (25, 'correct_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (41, 'correct_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (27, 'publish_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (28, 'news_list.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (30, 'news_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (31, 'enquiry_edit.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (32, 'user_access.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (36, 'group_user_access.php'); INSERT INTO `application_file` (`id_application_file`, `filename`) VALUES (37, 'user_group_access.php'); -- -------------------------------------------------------- -- -- Table structure for table `article` -- DROP TABLE IF EXISTS `article`; CREATE TABLE `article` ( `id_article` int(10) unsigned NOT NULL auto_increment, `id_article_category` int(10) unsigned NOT NULL default '0', `id_user` int(10) unsigned NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(255) NOT NULL default '', `anotation` text NOT NULL, `body` text NOT NULL, `correction` enum('Y','N') NOT NULL default 'N', `deleted` enum('Y','N') NOT NULL default 'N', `publish` enum('Y','N') NOT NULL default 'N', PRIMARY KEY (`id_article`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `article` -- INSERT INTO `article` (`id_article`, `id_article_category`, `id_user`, `date`, `title`, `anotation`, `body`, `correction`, `deleted`, `publish`) VALUES (1, 1, 7, '2006-01-14 15:44:00', 'ÄŒlánek o sirkach...', 'Sirky jsou vším, anotace na clanek sirek. Urcite jste zvedavy', 'Samotný Ä?lánek pojednává o sirkách', 'N', 'N', 'N'); INSERT INTO `article` (`id_article`, `id_article_category`, `id_user`, `date`, `title`, `anotation`, `body`, `correction`, `deleted`, `publish`) VALUES (2, 3, 7, '2006-01-14 15:46:35', 'Vedecka pr8ce dnes a zítra title', 'anotace k vedecke praci, snazcime se o publikace...ijiejwdjwe\r\newkjkje sdjfhdsjhf sjdfhj perex', 'text text text text\r\ntext text text text\r\ntext text text text\r\ntext text text text\r\ntext text text text\r\ntext text text text\r\ntext text text text', 'N', 'N', 'N'); INSERT INTO `article` (`id_article`, `id_article_category`, `id_user`, `date`, `title`, `anotation`, `body`, `correction`, `deleted`, `publish`) VALUES (4, 2, 1, '2006-01-14 15:57:44', 'Firefox', 'The award-winning Web browser is better than ever. Browse the Web with confidence - Firefox protects you from viruses, spyware and pop-ups. Enjoy improvements to performance, ease of use and privacy. Its easy to import your favorites and settings and get started. Download Firefox now and get the most out of the Web.', '
A Better Web Experience
Firefox 1.5 has an intuitive interface and blocks viruses, spyware, and popup ads. It delivers Web pages faster than ever. And it’s easy to install and import your favorites. Packed with useful features like tabbed browsing, Live Bookmarks, and an integrated Search bar, Firefox will change the way you experience the Web, for the better.
\r\n', 'Y', 'N', 'Y'); INSERT INTO `article` (`id_article`, `id_article_category`, `id_user`, `date`, `title`, `anotation`, `body`, `correction`, `deleted`, `publish`) VALUES (5, 8, 1, '2006-01-14 15:58:17', 'php|tek 2006 - Call for Papers', '[01-Dec-2005] php|architect \r\nmagazine is proud to announce php|tek 2006, an exclusive three-day conference (plus one day of exclusive in-depth seminars) dedicated to the world of PHP-driven software development. This years conference will take place from April 26-28, 2006, in Orlando, Florida, with April 25th set aside for a set of in-depth seminars.', '

Do you have unique insight into PHP? Have you written extensions, or contributed to the core? Have you deployed PHP in a tough environment, or scaled it to handle millions of hits per minute? Have you solved a unique problem, and want to share your discovery? Perhaps you\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''ve become an expert in a specific field? This year, our theme is "build->deploy->scale();", and if youre an expert on any of these, php|architect wants you to speak at php|tek.

\r\n

For more information, please visit the Call for Papers page, and submit your ideas. The deadline is December 21, 2005.

', 'Y', 'N', 'Y'); INSERT INTO `article` (`id_article`, `id_article_category`, `id_user`, `date`, `title`, `anotation`, `body`, `correction`, `deleted`, `publish`) VALUES (6, 2, 1, '2006-01-15 12:09:50', 'Thunderbird', 'Thunderbird delivers. Enjoy safe, fast, and easy email, with intelligent spam filters, quick message search, and customizable views. Brought to you by Mozilla, Thunderbird makes email better.', '
Full-Featured Email
Simple to use, powerful, and customizable, Thunderbird is a full-featured email application. Thunderbird supports IMAP and POP mail protocols, as well as HTML mail formatting. Easily import your existing email accounts and messages. Built-in RSS capabilities, powerful quick search, spell check as you type, global inbox, deleting attachments and advanced message filtering round out Thunderbird\\\\\\''s modern feature set.
Junk Mail Filters
Each email you receive passes through Thunderbird\\\\\\''s leading-edge junk mail filters. Each time you mark messages as spam, Thunderbird improves its filtering so you can spend more time reading the mail that matters. Thunderbird will also use your mail provider\\\\\\''s spam filters to keep junk mail out of your inbox.
Anti-Phishing Protection
Thunderbird protects you from increasingly common email scams—also known as “phishing”—which try to fool you into handing over your passwords and other personal information. Thunderbird will tell you when it thinks a message might be a scam.
', 'Y', 'N', 'Y'); INSERT INTO `article` (`id_article`, `id_article_category`, `id_user`, `date`, `title`, `anotation`, `body`, `correction`, `deleted`, `publish`) VALUES (7, 3, 1, '2006-01-22 16:11:40', 'Obhájené vÄ›decké práce', 'Katedra romanistiky má akreditované doktorské studium v rámci oborových komisí pro románské jazyky a pro francouzskou literaturu. Akreditované jsou i komise pro habilitaÄ?ní a profesorské řízení. Uvádíme zde struÄ?né anotace prací, které byly obhájeny v průbÄ›hu posledních deseti let. ', '"Chalupova chytrá monografie mÄ› oslovila a Ä?etl jsem ji s pozornÄ› a s velkou chutí. Je to aktuální text, který se vztahuje nejen k nedávné historii Pyrenejského polostrova, ale i k širším problémům promÄ›ny postkomunistických spoleÄ?enství ve Východní a StÅ™ední EvropÄ›. Chalupa se úspÄ›šnÄ› pokusil o analýzu tzv. španÄ›lského modelu transformace spoleÄ?nosti, procesu její promÄ›ny z autoritativního režimu ve standardní obÄ?anskou komunitu, založenou na principech politického pluralismu a tržního hospodáÅ™ství … Ve druhé Ä?ásti disertaÄ?ní práce autor prokázal nosnost mezioborového výzkumu, když kombinoval historickou metodu s metodou politologickou a sociologickou. Tento pÅ™ístup k nejnovÄ›jším dÄ›jinám je nutný a posouvá hranice poznání." (Prof. PhDr. Vladimír Nálevka, FF UK Praha, oponentský posudek)', 'N', 'N', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `article_category` -- DROP TABLE IF EXISTS `article_category`; CREATE TABLE `article_category` ( `id_article_category` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', PRIMARY KEY (`id_article_category`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `article_category` -- INSERT INTO `article_category` (`id_article_category`, `title`) VALUES (1, 'hardware'); INSERT INTO `article_category` (`id_article_category`, `title`) VALUES (2, 'software'); INSERT INTO `article_category` (`id_article_category`, `title`) VALUES (3, 'vedecke prace'); INSERT INTO `article_category` (`id_article_category`, `title`) VALUES (8, 'latin'); -- -------------------------------------------------------- -- -- Table structure for table `authorization` -- DROP TABLE IF EXISTS `authorization`; CREATE TABLE `authorization` ( `id_authorization` int(10) unsigned NOT NULL auto_increment, `id_user` int(10) unsigned NOT NULL default '0', `id_user_group` int(10) unsigned NOT NULL default '0', `id_application_file` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id_authorization`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ; -- -- Dumping data for table `authorization` -- INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (1, 0, 1, 40); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (2, 0, 1, 21); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (3, 0, 1, 35); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (4, 0, 10, 40); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (5, 0, 10, 21); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (6, 0, 10, 7); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (7, 0, 10, 35); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (8, 0, 11, 41); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (9, 0, 11, 25); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (10, 0, 11, 27); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (11, 0, 11, 34); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (12, 0, 11, 35); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (13, 0, 11, 14); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (14, 7, 0, 15); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (15, 7, 0, 30); INSERT INTO `authorization` (`id_authorization`, `id_user`, `id_user_group`, `id_application_file`) VALUES (16, 7, 0, 28); -- -------------------------------------------------------- -- -- Table structure for table `enquiry` -- DROP TABLE IF EXISTS `enquiry`; CREATE TABLE `enquiry` ( `id_enquiry` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `question` text NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', `active` enum('Y','N') NOT NULL default 'N', PRIMARY KEY (`id_enquiry`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `enquiry` -- INSERT INTO `enquiry` (`id_enquiry`, `title`, `question`, `date`, `active`) VALUES (7, 'moje anketa', 'tvoje anketa', '2006-01-14 16:20:23', 'Y'); INSERT INTO `enquiry` (`id_enquiry`, `title`, `question`, `date`, `active`) VALUES (8, 'máte domácího mazlíÄ?ka?', 'máte domácího mazlíÄ?ka?', '2006-01-14 16:20:51', 'N'); INSERT INTO `enquiry` (`id_enquiry`, `title`, `question`, `date`, `active`) VALUES (9, 'Co je to UHR', 'Co je to UHR', '2006-01-14 16:21:01', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `enquiry_answer` -- DROP TABLE IF EXISTS `enquiry_answer`; CREATE TABLE `enquiry_answer` ( `id_enquiry_answer` int(10) unsigned NOT NULL auto_increment, `id_enquiry` int(10) unsigned NOT NULL default '0', `answer` text NOT NULL, `votes` int(10) unsigned default '0', PRIMARY KEY (`id_enquiry_answer`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ; -- -- Dumping data for table `enquiry_answer` -- INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (6, 7, 'prvni otazka', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (5, 7, 'druha otazka', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (4, 7, 'treti otazka', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (10, 8, 'psa', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (11, 8, 'koÄ?ku', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (12, 9, 'opar', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (13, 8, 'morÄ?e', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (14, 8, 'polochcíplou rybku', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (15, 9, 'beÄ?ar', 0); INSERT INTO `enquiry_answer` (`id_enquiry_answer`, `id_enquiry`, `answer`, `votes`) VALUES (16, 9, 'ostravské klobásky', 0); -- -------------------------------------------------------- -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id_news` int(10) unsigned NOT NULL auto_increment, `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(255) NOT NULL default '', `body` text, PRIMARY KEY (`id_news`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `news` -- INSERT INTO `news` (`id_news`, `date`, `title`, `body`) VALUES (10, '2006-01-14 16:35:39', 'Novinka prvni', 'zkouÅ¡ka jestli to funguje'); INSERT INTO `news` (`id_news`, `date`, `title`, `body`) VALUES (9, '2006-01-14 16:35:17', 'PoÄ?así', 'Skoro jasno až jasno. Nejvyšší odpolední teploty -8 až -12°C, na severovýchodÄ› území kolem -14°C. Mírný severní vítr 2 až 6 m/s, na MoravÄ› a ve Slezsku zpoÄ?átku Ä?erstvý 4 až 8 m/s s nárazy a na horách kolem 15 m/s bude bÄ›hem dne slábnout. Na MoravÄ› a ve Slezsku se budou zpoÄ?átku místy tvoÅ™it snÄ›hové jazyky na horách i závÄ›je.'); -- -------------------------------------------------------- -- -- Table structure for table `user_group` -- DROP TABLE IF EXISTS `user_group`; CREATE TABLE `user_group` ( `id_user_group` int(10) unsigned NOT NULL auto_increment, `title` text NOT NULL, PRIMARY KEY (`id_user_group`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `user_group` -- INSERT INTO `user_group` (`id_user_group`, `title`) VALUES (1, 'root'); INSERT INTO `user_group` (`id_user_group`, `title`) VALUES (10, 'autor'); INSERT INTO `user_group` (`id_user_group`, `title`) VALUES (11, 'Korektor'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id_user` int(10) unsigned NOT NULL auto_increment, `id_user_group` int(10) unsigned NOT NULL default '0', `login` varchar(255) NOT NULL default '', `psw` varchar(255) NOT NULL default '', `lastname` varchar(255) NOT NULL default '', `firstname` varchar(255) NOT NULL default '', `lastdate` datetime NOT NULL default '0000-00-00 00:00:00', `user_key` varchar(255) default NULL, PRIMARY KEY (`id_user`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id_user`, `id_user_group`, `login`, `psw`, `lastname`, `firstname`, `lastdate`, `user_key`) VALUES (1, 1, 'test', 'test', 'Novák', 'Petr', '2006-01-22 16:30:24', 'ce0f394739115a7b7bda318330ae14ce'); INSERT INTO `users` (`id_user`, `id_user_group`, `login`, `psw`, `lastname`, `firstname`, `lastdate`, `user_key`) VALUES (9, 10, 'test2', 'test2', 'Uživatel', 'Testovací', '2006-01-22 16:20:56', '');