-- http://www.phpmyadmin.net
--




--
-- Database: `automobili`
--

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

--
-- Table structure for table `autodelovi`
--

CREATE TABLE IF NOT EXISTS `autodelovi` (
  `idDeo` int(11) NOT NULL AUTO_INCREMENT,
  `naziv` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `proizvodjac` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `kategorija` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `brprimeraka` int(11) NOT NULL,
  `cena` double NOT NULL,
  `zemlja` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`idDeo`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `autodelovi`
--

INSERT INTO `autodelovi` (`idDeo`, `naziv`, `proizvodjac`, `kategorija`, `brprimeraka`, `cena`, `zemlja`) VALUES
(1, 'Brisaci (par)', 'Champion', 'opel', 12, 4200, 'Slovacka'),
(2, 'Akumulator', 'Varta', 'el.uredjaj', 15, 12450.5, 'Slovenija'),
(3, 'Auspuh', 'privatni', 'izduvne cevi', 4, 1130, 'Srbija'),
(4, 'Zimska guma (kom)', 'Wintera', 'auto gume', 16, 4667.88, 'Srbija'),
(5, 'Motor 1.2', 'Fiat automobili', 'motori', 1, 180350, 'Italija'),
(6, 'Motor 1.4', 'Fiat automobili', 'motori', 2, 220196.7, 'Italija');

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

--
-- Table structure for table `prodaja`
--

CREATE TABLE IF NOT EXISTS `prodaja` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idKorisnik` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `idDeo` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `prodaja`
--

INSERT INTO `prodaja` (`id`, `idKorisnik`, `idDeo`) VALUES
(1, 'drazen', 1),
(2, 'drazen', 2),
(3, 'igor', 3),
(4, 'igor', 5);

