s4UpSMjY

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Mar 10, 2015 at 08:42 PM
7-- Server version: 5.6.21
8-- PHP Version: 5.5.19
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `hci_2123_2297`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `kupci`
27--
28
29CREATE TABLE IF NOT EXISTS `kupci` (
30`KupacID` int(11) NOT NULL,
31  `Ime` varchar(50) NOT NULL,
32  `Prezime` varchar(50) NOT NULL,
33  `Email` varchar(150) NOT NULL,
34  `RegistracijaID` int(11) NOT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37-- --------------------------------------------------------
38
39--
40-- Table structure for table `ocjenaproizvoda`
41--
42
43CREATE TABLE IF NOT EXISTS `ocjenaproizvoda` (
44`OcjenaProizvodaID` int(11) NOT NULL,
45  `Ocjena` int(11) NOT NULL,
46  `ProizvodID` int(11) NOT NULL,
47  `KupacID` int(11) NOT NULL
48) ENGINE=InnoDB DEFAULT CHARSET=utf8;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `proizvodi`
54--
55
56CREATE TABLE IF NOT EXISTS `proizvodi` (
57`ProizvodID` int(11) NOT NULL,
58  `Naziv` varchar(50) NOT NULL,
59  `Cijena` decimal(5,2) NOT NULL,
60  `Opis` varchar(150) NOT NULL,
61  `VrstaProizvodaID` int(11) NOT NULL,
62  `KupacID` int(11) NOT NULL
63) ENGINE=InnoDB DEFAULT CHARSET=utf8;
64
65-- --------------------------------------------------------
66
67--
68-- Table structure for table `registracija`
69--
70
71CREATE TABLE IF NOT EXISTS `registracija` (
72`RegistracijaID` int(11) NOT NULL,
73  `Username` varchar(50) NOT NULL,
74  `Password` varchar(50) NOT NULL
75) ENGINE=InnoDB DEFAULT CHARSET=utf8;
76
77-- --------------------------------------------------------
78
79--
80-- Table structure for table `vrsteproizvoda`
81--
82
83CREATE TABLE IF NOT EXISTS `vrsteproizvoda` (
84`VrstaProizvodaID` int(11) NOT NULL,
85  `Naziv` varchar(100) NOT NULL
86) ENGINE=InnoDB DEFAULT CHARSET=utf8;
87
88--
89-- Indexes for dumped tables
90--
91
92--
93-- Indexes for table `kupci`
94--
95ALTER TABLE `kupci`
96 ADD PRIMARY KEY (`KupacID`);
97
98--
99-- Indexes for table `ocjenaproizvoda`
100--
101ALTER TABLE `ocjenaproizvoda`
102 ADD PRIMARY KEY (`OcjenaProizvodaID`);
103
104--
105-- Indexes for table `proizvodi`
106--
107ALTER TABLE `proizvodi`
108 ADD PRIMARY KEY (`ProizvodID`);
109
110--
111-- Indexes for table `registracija`
112--
113ALTER TABLE `registracija`
114 ADD PRIMARY KEY (`RegistracijaID`);
115
116--
117-- Indexes for table `vrsteproizvoda`
118--
119ALTER TABLE `vrsteproizvoda`
120 ADD PRIMARY KEY (`VrstaProizvodaID`);
121
122--
123-- AUTO_INCREMENT for dumped tables
124--
125
126--
127-- AUTO_INCREMENT for table `kupci`
128--
129ALTER TABLE `kupci`
130MODIFY `KupacID` int(11) NOT NULL AUTO_INCREMENT;
131--
132-- AUTO_INCREMENT for table `ocjenaproizvoda`
133--
134ALTER TABLE `ocjenaproizvoda`
135MODIFY `OcjenaProizvodaID` int(11) NOT NULL AUTO_INCREMENT;
136--
137-- AUTO_INCREMENT for table `proizvodi`
138--
139ALTER TABLE `proizvodi`
140MODIFY `ProizvodID` int(11) NOT NULL AUTO_INCREMENT;
141--
142-- AUTO_INCREMENT for table `registracija`
143--
144ALTER TABLE `registracija`
145MODIFY `RegistracijaID` int(11) NOT NULL AUTO_INCREMENT;
146--
147-- AUTO_INCREMENT for table `vrsteproizvoda`
148--
149ALTER TABLE `vrsteproizvoda`
150MODIFY `VrstaProizvodaID` int(11) NOT NULL AUTO_INCREMENT;
151/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
152/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
153/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;