-- phpMyAdmin SQL Dump
-- version 2.6.0-beta2
-- http://www.phpmyadmin.net
-- 
-- Hostiteľ: localhost
-- Vygenerované:: 01.Feb, 2009 - 23:47
-- Verzia serveru: 4.0.20
-- Verzia PHP: 5.0.0
-- 
-- Databáza: `e_learning`
-- 
CREATE DATABASE `e_learning`;
USE e_learning;

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

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

CREATE TABLE `articles` (
  `id` int(11) NOT NULL auto_increment,
  `id_category` int(11) NOT NULL default '0',
  `id_branch` int(11) NOT NULL default '0',
  `add_by` int(11) NOT NULL default '0',
  `nadpis` varchar(255) NOT NULL default '',
  `popis` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `show_web` int(11) NOT NULL default '0',
  `rate` int(11) NOT NULL default '0',
  `rated` int(11) NOT NULL default '0',
  `utime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

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

INSERT INTO `articles` VALUES (1, 4, 6, 1, 'Prednaska 01', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam scelerisque libero et tellus. Curabitur congue convallis augue. In eu orci et massa congue accumsan. Praesent blandit nunc quis eros. Fusce egestas porta ipsum. Nam sed orci. Nulla facilisi. Nunc est. Nulla facilisi. Nam tincidunt dui at diam porta auctor. ', '0000-00-00 00:00:00', 1, 0, 0, 0);
INSERT INTO `articles` VALUES (2, 4, 6, 1, 'Prednaska 02', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam scelerisque libero et tellus. Curabitur congue convallis augue. In eu orci et massa congue accumsan. Praesent blandit nunc quis eros. Fusce egestas porta ipsum. Nam sed orci. Nulla facilisi. Nunc est. Nulla facilisi. Nam tincidunt dui at diam porta auctor. ', '0000-00-00 00:00:00', 1, 0, 0, 0);
INSERT INTO `articles` VALUES (3, 5, 6, 1, 'Prednaska 01', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam scelerisque libero et tellus. Curabitur congue convallis augue. In eu orci et massa congue accumsan. Praesent blandit nunc quis eros. Fusce egestas porta ipsum. Nam sed orci. Nulla facilisi. Nunc est. Nulla facilisi. Nam tincidunt dui at diam porta auctor. ', '0000-00-00 00:00:00', 1, 0, 0, 0);
INSERT INTO `articles` VALUES (4, 4, 6, 1, 'aaa', '<h2><font face="trebuchet ms">Nadpis</font></h2><font face="trebuchet ms"><i>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus\r\nsapien. Cum sociis natoque penatibus et magnis dis parturient montes,\r\nnascetur ridiculus mus. Curabitur augue pede, consequat sit amet,\r\nfringilla eu, pellentesque et, nulla. </i><br /><br />Ut ligula augue, accumsan et,\r\nviverra eget, dignissim ut, lectus. Fusce sollicitudin, sapien ut\r\nimperdiet commodo, sem arcu mollis massa, id dapibus purus mauris sit\r\namet nisi. Ut vitae felis nec nisl fringilla porta. Nullam nec nibh at\r\nest semper mattis. Sed non nisl. Aliquam luctus sodales odio. Nunc\r\nultrices, orci pharetra pharetra consequat, turpis odio vulputate erat,\r\nquis convallis enim sem eu elit. Donec convallis porta lectus. In hac\r\nhabitasse platea dictumst. Morbi vehicula quam et sem. Sed aliquet nunc\r\nin mi. Proin ac nulla in ante sagittis suscipit. Sed euismod augue.\r\n</font>\r\n<p><font face="trebuchet ms">Cras ultrices, nibh sed dictum vestibulum, ligula enim imperdiet\r\ntellus, et pharetra urna elit eget leo. In felis felis, rhoncus\r\nfaucibus, rhoncus eget, tincidunt et, eros. Nullam consectetur congue\r\ntortor. Quisque dolor metus, imperdiet nec, tempus in, porta non, nibh.\r\nAenean ut nunc ac sapien dictum scelerisque. Donec blandit accumsan\r\nligula. Suspendisse vel lacus. Pellentesque habitant morbi tristique\r\nsenectus et netus et malesuada fames ac turpis egestas. Class aptent\r\ntaciti sociosqu ad litora torquent per conubia nostra, per inceptos\r\nhimenaeos. <br /></font></p>\r\n<p><b><font face="trebuchet ms">Cras feugiat tempus lacus. Quisque a quam sed dui sodales\r\ntincidunt. Praesent orci ipsum, pharetra et, dignissim sed, egestas ut,\r\npurus. Sed nisi.\r\n</font></b></p>\r\n<font face="trebuchet ms"><br /></font>', '2009-01-31 20:25:01', 1, 0, 0, 1233429901);
INSERT INTO `articles` VALUES (5, 4, 6, 1, 'Heading', '<p><font face="trebuchet ms">\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque\r\ncursus iaculis mi. Nulla facilisi. Aliquam accumsan venenatis dui. Nunc\r\neuismod. Pellentesque dolor sapien, imperdiet a, porttitor ut, molestie\r\nid, enim. Fusce sed mauris. Nam pretium, nisl at tempor tristique,\r\nlectus ipsum hendrerit enim, et condimentum urna arcu vel lorem.\r\nPhasellus dictum, turpis lacinia egestas mattis, ligula neque dictum\r\nvelit, vitae pharetra risus dolor vel orci. Duis laoreet urna eget\r\nquam. Duis sapien.\r\n</font></p>\r\n<p><font face="trebuchet ms">Etiam vestibulum tortor nec est. Quisque nec leo. Nunc porttitor\r\nnunc nec lacus. Vivamus placerat luctus elit. Duis ut est luctus nibh\r\ntempor imperdiet. Sed eu nisi eu magna tempor tincidunt. Donec in urna.\r\nProin vehicula, dui a semper ultricies, eros nunc accumsan ipsum, ut\r\nvehicula lorem turpis id dui. Suspendisse potenti. Nulla facilisi.\r\nPraesent quis orci.\r\n</font></p>\r\n<p><font face="trebuchet ms">Vestibulum porta nibh et pede. Nullam vel lectus. Sed fermentum.\r\nAenean ac metus. Nam tempus erat vitae metus. Quisque lacinia laoreet\r\nmassa. Nullam vel metus. Nam at nunc. Nullam sollicitudin rutrum mi.\r\nMaecenas non dui at quam lobortis imperdiet. Cras et odio et risus\r\nadipiscing posuere. Suspendisse mattis sollicitudin diam.\r\n</font></p>', '2009-01-31 20:48:49', 1, 0, 0, 1233431329);
INSERT INTO `articles` VALUES (6, 4, 6, 1, 'nadpis s obrazok', '<p><font face="trebuchet ms">\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur\r\nrutrum tortor et augue. Etiam sit amet nisi sed ipsum consectetur\r\ntempor. Pellentesque tempus, nulla ut iaculis gravida, nulla pede\r\npulvinar orci, vel consectetur lacus neque vel eros. Mauris neque\r\ndolor, egestas eu, varius et, imperdiet non, massa. Vivamus eu nisi.\r\nSed ac quam ut massa aliquet scelerisque. Nullam lacus eros, egestas\r\nid, aliquet in, malesuada ac, ante. Cras nulla mi, vestibulum sed,\r\npulvinar id, malesuada sed, tellus. Quisque fermentum scelerisque orci.\r\nSed et dolor eleifend justo facilisis iaculis. <br /></font></p>\r\n<p><img src="images/uploaded/100004.jpg" alt="description" title="description" border="0" /></p>\r\n<p><font face="trebuchet ms">Nullam ipsum. Aenean ultrices diam nec enim gravida egestas. Cras\r\ntempus tempor dui. Lorem ipsum dolor sit amet, consectetur adipiscing\r\nelit. Ut libero nibh, suscipit non, semper vitae, porta condimentum,\r\npede. In arcu tellus, dignissim ac, vehicula at, malesuada ut, enim.\r\nFusce sagittis commodo libero. Cras tempus, odio ac faucibus rhoncus,\r\nlorem lorem vehicula eros, et euismod odio dolor sed velit. Proin est\r\ntellus, tincidunt sed, commodo a, ultricies tempor, libero. Suspendisse\r\nfacilisis ligula laoreet lorem. Pellentesque placerat metus. Quisque\r\nnon nulla. Donec leo neque, iaculis ut, bibendum nec, tincidunt luctus,\r\nquam. Duis at nisi. Sed sodales. Nulla tincidunt, enim ullamcorper\r\ncommodo ultrices, felis metus ullamcorper felis, vitae faucibus nisl\r\nleo sit amet felis. Pellentesque felis.\r\n</font></p>', '2009-01-31 21:16:14', 1, 0, 0, 1233432974);
INSERT INTO `articles` VALUES (7, 4, 6, 1, 'head', '<h3 style="text-align: center; color: rgb(255, 0, 0);">Pozor pokial chcete<img src="images/uploaded/100016.jpg" border="0" /> pridat obrazok musite ho uploadovat pred pridanim clanku</h3>\r\n		\r\n<h4>Adresa vami uploadnutych obrazkov:<img src="images/uploaded/100017.jpg" border="0" /></h4>', '2009-01-31 21:29:01', 1, 0, 0, 1233433741);
INSERT INTO `articles` VALUES (8, 5, 6, 1, 'Táto sekcia je venovaná poznámkam rôznych predmetov.', '<p><font face="trebuchet ms">\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean tempor,\r\naugue nec pulvinar dictum, mi arcu aliquet massa, a auctor elit nisi eu\r\nligula. Cras eget quam nec tortor vehicula luctus. Cum sociis natoque\r\npenatibus et magnis dis parturient montes, nascetur ridiculus mus.\r\nFusce consectetur dolor sit amet sapien. Vestibulum id sapien. Nullam\r\ntellus. Phasellus laoreet erat fringilla turpis. In hac habitasse\r\nplatea dictumst. Sed vitae urna. Nulla blandit leo in justo. Duis\r\nmollis semper risus. Donec eros enim, suscipit vitae, vestibulum nec,\r\nvehicula sit amet, justo. Nunc tincidunt pharetra elit. Etiam faucibus,\r\nodio vel pretium posuere, elit mi molestie velit, sed condimentum magna\r\nsem in metus. Vestibulum tincidunt nisi vitae ligula vestibulum\r\naliquet. Maecenas ornare iaculis nulla. Nullam consectetur purus varius\r\nnisl. Donec a neque quis nisi cursus tempus. Cras venenatis. Sed non\r\nlectus. <br />\r\n</font></p>\r\n<p><img src="images/uploaded/100019.jpg" border="0" /></p>\r\n\r\n\r\n<p><font face="trebuchet ms">Vivamus quis nulla sed mauris tempor dignissim. Aliquam mollis sem\r\nid metus. Cras in turpis. Sed metus purus, facilisis id, pellentesque\r\nnon, tristique malesuada, turpis. Praesent pharetra, lorem id ornare\r\nhendrerit, justo nisi mollis libero, eu commodo ligula erat non ante.\r\nPhasellus in elit nec erat viverra aliquet. Suspendisse eget augue. Nam\r\nlobortis, lorem eu vestibulum laoreet, velit nisl tincidunt lectus, sed\r\nsagittis odio dui a quam. Nunc quis libero. Vestibulum ante ipsum\r\nprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Sed\r\nsapien. Phasellus viverra, ligula at mollis lacinia, metus mauris\r\nposuere libero, et facilisis massa magna at diam. Etiam eget neque eget\r\nmetus auctor ultricies. Vestibulum vulputate, libero eget dictum\r\ntincidunt, nulla ligula congue elit, a ullamcorper nunc diam vel urna.\r\nEtiam pharetra libero sed nibh. Donec elementum. In hac habitasse\r\nplatea dictumst. <br />\r\n</font></p>\r\n<p><img src="images/uploaded/100020.jpg" border="0" /></p>\r\n\r\n\r\n<p><font face="trebuchet ms">Phasellus nec neque. Maecenas diam mi, molestie quis, lacinia quis,\r\ntempus nec, odio. Sed lacus leo, volutpat vitae, scelerisque ut,\r\nvestibulum id, quam. Integer eget leo id ligula laoreet condimentum. In\r\neros elit, sagittis at, adipiscing et, porttitor eget, ipsum. Nam\r\ntincidunt malesuada quam. Sed sit amet velit. Curabitur sollicitudin\r\ntristique ipsum. Vestibulum eget nulla. Praesent viverra justo nec\r\nlectus. Vivamus elementum. In consectetur quam id elit. Curabitur\r\nfermentum laoreet dui. Proin lectus lacus, lobortis at, feugiat a,\r\nvenenatis et, sapien.\r\n</font></p>', '2009-01-31 21:31:46', 1, 0, 0, 1233433906);
INSERT INTO `articles` VALUES (9, 5, 6, 1, 'aaa', 'aaa', '2009-01-31 23:08:23', 1, 0, 0, 1233439703);
INSERT INTO `articles` VALUES (10, 10, 8, 1, 'nadpis nieco', 'popis nieco', '0000-00-00 00:00:00', 1, 0, 0, 0);
INSERT INTO `articles` VALUES (11, 5, 7, 1, 'nadpis nieco 5,7', 'popis', '0000-00-00 00:00:00', 1, 0, 0, 0);
INSERT INTO `articles` VALUES (13, 11, 8, 1, 'aaa', 'eee', '2009-02-01 17:44:44', 1, 0, 0, 1233506684);
INSERT INTO `articles` VALUES (14, 10, 8, 1, 'aaa', 'aaa', '2009-02-01 17:53:17', 1, 0, 0, 1233507197);

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

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

CREATE TABLE `categories` (
  `id_category` int(11) NOT NULL auto_increment,
  `id_parent` int(11) NOT NULL default '0',
  `category` varchar(255) NOT NULL default '',
  `category_alt` varchar(255) NOT NULL default '',
  `include` varchar(255) NOT NULL default '',
  `show_web` int(11) NOT NULL default '0',
  `rank` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_category`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

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

INSERT INTO `categories` VALUES (1, 0, 'Poznámky', 'Poznámky', 'pages/poznamky.php', 1, 1);
INSERT INTO `categories` VALUES (2, 0, 'Písomky-skúšky', 'Písomky-skúšky', 'pages/poznamky.php', 1, 2);
INSERT INTO `categories` VALUES (3, 0, 'Registrácia', 'Registrácia', 'pages/registration.php', 1, 10);
INSERT INTO `categories` VALUES (4, 6, 'Mat', 'Matematika', '', 1, 3);
INSERT INTO `categories` VALUES (5, 6, 'DMat', 'Diskrétna matematika', '', 1, 4);
INSERT INTO `categories` VALUES (6, 1, 'AIN', 'Aplikovaná informatika', '', 1, 1);
INSERT INTO `categories` VALUES (7, 1, 'INF', 'Informatika', '', 1, 2);
INSERT INTO `categories` VALUES (8, 2, 'AIN', 'Aplikovaná informatika', '', 1, 1);
INSERT INTO `categories` VALUES (9, 2, 'INF', 'Informatika', '', 1, 2);
INSERT INTO `categories` VALUES (10, 8, 'Mat', 'Matematika', '', 1, 3);
INSERT INTO `categories` VALUES (11, 8, 'DMat', 'Diskrétna matematika', '', 1, 4);
INSERT INTO `categories` VALUES (12, 0, 'Fórum', 'Fórum', 'pages/forum.php', 1, 3);

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

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

CREATE TABLE `forum` (
  `id` int(11) NOT NULL auto_increment,
  `id_parent` int(11) NOT NULL default '0',
  `id_tema` int(11) NOT NULL default '0',
  `add_by` int(11) NOT NULL default '0',
  `text` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `utime` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

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

INSERT INTO `forum` VALUES (1, 0, 1, 0, 'text id 1', '0000-00-00 00:00:00', 22);
INSERT INTO `forum` VALUES (2, 0, 1, 0, 'text id 2', '0000-00-00 00:00:00', 22);
INSERT INTO `forum` VALUES (3, 2, 1, 0, 'text id 3', '0000-00-00 00:00:00', 22);
INSERT INTO `forum` VALUES (4, 2, 1, 0, 'text id 4', '0000-00-00 00:00:00', 22);
INSERT INTO `forum` VALUES (5, 4, 1, 0, 'text id 5', '0000-00-00 00:00:00', 22);
INSERT INTO `forum` VALUES (6, 3, 1, 0, 'text id 6', '0000-00-00 00:00:00', 22);
INSERT INTO `forum` VALUES (7, 0, 1, 0, 'text id 7', '0000-00-00 00:00:00', 22);
INSERT INTO `forum` VALUES (10, 6, 1, 1, 'aaa', '2009-02-01 23:16:52', 1233526612);
INSERT INTO `forum` VALUES (11, 0, 1, 1, 'prispevok', '2009-02-01 23:35:16', 1233527716);

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

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

CREATE TABLE `forum_temy` (
  `id` int(11) NOT NULL auto_increment,
  `nazov` varchar(255) NOT NULL default '',
  `prispevkov` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

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

INSERT INTO `forum_temy` VALUES (1, 'tema_1', 0);
INSERT INTO `forum_temy` VALUES (2, 'tema_2', 0);

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

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

CREATE TABLE `foto_inc` (
  `kolko` int(11) NOT NULL default '0'
) TYPE=MyISAM;

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

INSERT INTO `foto_inc` VALUES (50);
