[ sasa-c @ 20.05.2011. 08:06 ] @
-- phpMyAdmin SQL Dump -- version 2.6.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 19, 2011 at 01:08 AM -- Server version: 4.1.9 -- PHP Version: 4.3.10 -- -- Database: `student` -- -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `member_id` int(11) unsigned NOT NULL auto_increment, `firstname` varchar(100) default NULL, `lastname` varchar(100) default NULL, `login` varchar(100) NOT NULL default '', `passwd` varchar(32) NOT NULL default '', `priority` varchar(200) NOT NULL default '', PRIMARY KEY (`member_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `members` -- INSERT INTO `members` VALUES (1, 'igi', 'milj', 'admin', 'admin', 'admin'); INSERT INTO `members` VALUES (2, 'sekretar', 'skole', 'sekretar', 'sekretar', 'sekretar'); INSERT INTO `members` VALUES (4, 'igor', 'milj', 'igor', 'igor', 'student'); -- -------------------------------------------------------- -- -- Table structure for table `predmet` -- CREATE TABLE `predmet` ( `id` tinyint(5) NOT NULL auto_increment, `pred_id` tinyint(4) NOT NULL default '0', `kolokvijum` tinyint(4) NOT NULL default '0', `kolokvijum2` tinyint(5) NOT NULL default '0', `ispit` tinyint(2) NOT NULL default '0', `seminarski` text NOT NULL, `seminarski_file` varchar(200) NOT NULL default '', `polozio` tinyint(4) NOT NULL default '0', `ocjena` tinyint(5) NOT NULL default '0', `student_id` tinyint(4) NOT NULL default '0', `prijavio` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `predmet` -- INSERT INTO `predmet` VALUES (1, 1, 15, 15, 33, 'Tema: Test', 'sasas.doc', 1, 6, 1, 1); INSERT INTO `predmet` VALUES (2, 2, 33, 33, 33, 'Tema: Test', 'saasa.doc', 1, 10, 1, 1); INSERT INTO `predmet` VALUES (3, 3, 22, 1, 22, 'Tema: Test', 'tutor_login_icon.png', 1, 6, 2, 1); INSERT INTO `predmet` VALUES (4, 4, 0, 0, 0, '', 'tutor_login_icon.png', 0, 0, 2, 1); INSERT INTO `predmet` VALUES (7, 4, 11, 22, 33, 'asdasda', 'Iva.docx', 1, 10, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `predmet_info` -- CREATE TABLE `predmet_info` ( `predmet_id` tinyint(5) NOT NULL auto_increment, `smjer_id` tinyint(5) default NULL, `predmet_ime` varchar(200) default NULL, `godina_p` tinyint(5) NOT NULL default '0', `profesor` varchar(200) default NULL, PRIMARY KEY (`predmet_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `predmet_info` -- INSERT INTO `predmet_info` VALUES (1, 1, 'predmet1', 1, 'profesor1'); INSERT INTO `predmet_info` VALUES (2, 2, 'predmet2', 1, 'profesor2'); INSERT INTO `predmet_info` VALUES (3, 2, 'predmet3', 2, 'profesor3'); INSERT INTO `predmet_info` VALUES (4, 2, 'predmet4', 3, 'profesor4'); INSERT INTO `predmet_info` VALUES (5, 2, 'predmet5', 2, 'profesor5'); -- -------------------------------------------------------- -- -- Table structure for table `student_info` -- CREATE TABLE `student_info` ( `id` int(15) NOT NULL auto_increment, `ime` varchar(100) NOT NULL default '0', `prezime` varchar(100) NOT NULL default '0', `ind` tinyint(5) NOT NULL default '0', `tel` int(52) NOT NULL default '0', `login` varchar(100) NOT NULL default '', `passwd` varchar(100) NOT NULL default '', `placeno` tinyint(3) NOT NULL default '0', `smjer_id` tinyint(5) NOT NULL default '0', `godina` tinyint(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=48 ; -- -- Dumping data for table `student_info` -- INSERT INTO `student_info` VALUES (1, 'marko s', 'markovic11', 55, 2234234, 'sasa', 'sasa', 1, 2, 3); INSERT INTO `student_info` VALUES (2, 'marko111', 'markovic 2', 56, 22342344, 'sasa1', 'sasa1', 0, 1, 1); |