Navigation

zkousky

HostGator is one of the fastest growing web hosting companies in the United States. For just $10 per month, you can host unlimited domains.

To view the whole dump, (approx. 1000+ rows) you will need to upgrade your account

CREATE TABLE `join_uzivatel_predmet` (
`fk_uzivatel_id` bigint(20) NOT NULL default '0',
`fk_predmet_id` bigint(20) NOT NULL default '0',
KEY `FKAF0D82FDE7E1EF51` (`fk_predmet_id`),
KEY `FKAF0D82FD9269B9A3` (`fk_uzivatel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `join_uzivatel_predmet` VALUES (1,1);
INSERT INTO `join_uzivatel_predmet` VALUES (1,3);
INSERT INTO `join_uzivatel_predmet` VALUES (2,2);
INSERT INTO `join_uzivatel_predmet` VALUES (3,1);
INSERT INTO `join_uzivatel_predmet` VALUES (3,2);
INSERT INTO `join_uzivatel_predmet` VALUES (4,2);
INSERT INTO `join_uzivatel_predmet` VALUES (4,3);
INSERT INTO `join_uzivatel_predmet` VALUES (5,3);
INSERT INTO `join_uzivatel_predmet` VALUES (6,3);
INSERT INTO `join_uzivatel_predmet` VALUES (6,1);
INSERT INTO `join_uzivatel_predmet` VALUES (7,1);
INSERT INTO `join_uzivatel_predmet` VALUES (7,2);
CREATE TABLE `join_uzivatel_termin` (
`fk_uzivatel_id` bigint(20) NOT NULL default '0',
`fk_termin_id` bigint(20) NOT NULL default '0',
KEY `FK385C36F9269B9A3` (`fk_uzivatel_id`),
KEY `FK385C36F52F699C3` (`fk_termin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `join_uzivatel_termin` VALUES (3,1);
CREATE TABLE `predmet` (
`id` bigint(20) NOT NULL auto_increment,
`nazev` varchar(50) NOT NULL default '',
`kod` varchar(10) NOT NULL default '',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `predmet` VALUES (1,'Tvorba informacnich systemu','TIS');
INSERT INTO `predmet` VALUES (2,'Zaklady pocitacove grafiky','ZPG');
INSERT INTO `predmet` VALUES (3,'Pocitacove site','POS');
CREATE TABLE `termin` (
`id` bigint(20) NOT NULL auto_increment,
`datum` date NOT NULL default '0000-00-00',
`kapacita` int(11) NOT NULL default '0',
`mistnost` varchar(10) default NULL,
`uzavreni` date NOT NULL default '0000-00-00',
`zacatek` time NOT NULL default '00:00:00',
`predmet_id` bigint(20) default NULL,
`vlastnik` bigint(20) NOT NULL default '0',
PRIMARY KEY  (`id`),
KEY `FKCBB6E691E705C813` (`vlastnik`),
KEY `FKCBB6E691678EE397` (`predmet_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `termin` VALUES (1,'2008-12-22',60,'C3','2008-12-20','09:30:00',1,1);
INSERT INTO `termin` VALUES (2,'2008-01-09',25,'B5','2008-01-04','10:00:00',2,2);
INSERT INTO `termin` VALUES (3,'2008-05-15',30,'B5','2008-05-14','11:00:00',1,1);
INSERT INTO `termin` VALUES (4,'2008-05-09',30,'B5','2008-05-06','11:00:00',1,1);
INSERT INTO `termin` VALUES (5,'2008-05-31',90,'C3','2008-05-02','10:30:00',3,1);
INSERT INTO `termin` VALUES (6,'2008-05-30',20,'J401','2008-05-20','09:00:00',2,2);
CREATE TABLE `uzivatel` (
`id` bigint(20) NOT NULL auto_increment,
`login` varchar(10) NOT NULL default '',
`heslo` varchar(32) NOT NULL default '',
`role` bigint(20) NOT NULL default '0',
`jmeno` varchar(20) NOT NULL default '',
`prijmeni` varchar(20) NOT NULL default '',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `uzivatel` VALUES (1,'nov004','tomas',1,'Tomas','Novak');
INSERT INTO `uzivatel` VALUES (2,'svo004','lukas',1,'Lukas','Svoboda');
INSERT INTO `uzivatel` VALUES (3,'jec008','martin',2,'Martin','Jecminek');
INSERT INTO `uzivatel` VALUES (4,'vec004','daniel',2,'Daniel','Vecerek');
INSERT INTO `uzivatel` VALUES (5,'mac084','franta',2,'Frantisek','Machacek');
INSERT INTO `uzivatel` VALUES (6,'ulm061','petr',2,'Petr','Ulma');
INSERT INTO `uzivatel` VALUES (7,'tom122','pavel',2,'Pavel','Tomasek');
CREATE TABLE `vysledek` (
`id` bigint(20) NOT NULL auto_increment,
`body` int(11) NOT NULL default '0',
`termin_id` bigint(20) NOT NULL default '0',
`uzivatel_id` bigint(20) NOT NULL default '0',
PRIMARY KEY  (`id`),
KEY `FKACFB57E15F5704BD` (`termin_id`),
KEY `FKACFB57E185B4E1D` (`uzivatel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `vysledek` VALUES (2,100,1,3);

This work is licensed under a
Creative Commons Attribution 2.5 License.

Comments on this database

There are no comments for this database

zkousky

Comments on this database

Post a comment on this database