· 6 years ago · Oct 11, 2019, 04:54 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Oct 11, 2019 at 06:50 PM
7-- Server version: 10.1.40-MariaDB
8-- PHP Version: 7.3.5
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `code`
23--
24CREATE DATABASE IF NOT EXISTS `code` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `code`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `drzava`
31--
32
33DROP TABLE IF EXISTS `drzava`;
34CREATE TABLE `drzava` (
35 `id_drzave` int(11) NOT NULL,
36 `naziv_drzave` varchar(50) NOT NULL,
37 `glavni_grad` varchar(50) NOT NULL,
38 `broj_stanovnika` int(11) NOT NULL,
39 `povrsina` decimal(10,2) NOT NULL,
40 `zastava` varchar(255) NOT NULL
41) ENGINE=InnoDB DEFAULT CHARSET=latin1;
42
43--
44-- Dumping data for table `drzava`
45--
46
47INSERT INTO `drzava` (`id_drzave`, `naziv_drzave`, `glavni_grad`, `broj_stanovnika`, `povrsina`, `zastava`) VALUES
48(15, 'Srbija', 'Beograd', 68888, '74000.00', ''),
49(18, 'Rumunija', 'Bukurest', 20000, '350000.00', ''),
50(26, 'Australija', 'Kambera', 25000000, '3000000.00', ''),
51(42, 'Makedonija', 'Skoplje', 2000000, '21000.00', 'okokret.jpg'),
52(43, 'Slovenija', 'Ljubljana', 1024, '23000.00', 'zasekciju.PNG');
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `korisnici`
58--
59
60DROP TABLE IF EXISTS `korisnici`;
61CREATE TABLE `korisnici` (
62 `id` int(11) NOT NULL,
63 `ime` varchar(30) NOT NULL,
64 `prezime` varchar(30) NOT NULL,
65 `email` varchar(55) NOT NULL,
66 `dat_reg` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
67 `privilegija` varchar(30) NOT NULL,
68 `sifra` varchar(128) NOT NULL
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70
71--
72-- Dumping data for table `korisnici`
73--
74
75INSERT INTO `korisnici` (`id`, `ime`, `prezime`, `email`, `dat_reg`, `privilegija`, `sifra`) VALUES
76(4, 'Nemanja', 'Vidic', 'nemanja@vidic.rs', '2019-10-11 16:42:10', 'korisnik', 'nemanja1');
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `marka`
82--
83
84DROP TABLE IF EXISTS `marka`;
85CREATE TABLE `marka` (
86 `id_marke` int(11) NOT NULL,
87 `naziv_marke` varchar(40) NOT NULL,
88 `id_zemlje_porekla` int(11) NOT NULL
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90
91--
92-- Dumping data for table `marka`
93--
94
95INSERT INTO `marka` (`id_marke`, `naziv_marke`, `id_zemlje_porekla`) VALUES
96(1, 'MB', 18),
97(2, 'Nisan', 15);
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `model`
103--
104
105DROP TABLE IF EXISTS `model`;
106CREATE TABLE `model` (
107 `id_modela` int(11) NOT NULL,
108 `id_marke` int(11) NOT NULL,
109 `naziv_modela` varchar(50) NOT NULL,
110 `godiste` smallint(4) NOT NULL,
111 `snaga` int(11) NOT NULL,
112 `cena` decimal(10,2) NOT NULL
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114
115--
116-- Dumping data for table `model`
117--
118
119INSERT INTO `model` (`id_modela`, `id_marke`, `naziv_modela`, `godiste`, `snaga`, `cena`) VALUES
120(1, 1, 'cls', 2001, 136, '2000.00'),
121(2, 2, 'skyline', 2002, 100, '3600.00');
122
123--
124-- Indexes for dumped tables
125--
126
127--
128-- Indexes for table `drzava`
129--
130ALTER TABLE `drzava`
131 ADD PRIMARY KEY (`id_drzave`);
132
133--
134-- Indexes for table `korisnici`
135--
136ALTER TABLE `korisnici`
137 ADD PRIMARY KEY (`id`);
138
139--
140-- Indexes for table `marka`
141--
142ALTER TABLE `marka`
143 ADD PRIMARY KEY (`id_marke`),
144 ADD KEY `id_zemlje_porekla` (`id_zemlje_porekla`);
145
146--
147-- Indexes for table `model`
148--
149ALTER TABLE `model`
150 ADD PRIMARY KEY (`id_modela`),
151 ADD KEY `id_marke` (`id_marke`);
152
153--
154-- AUTO_INCREMENT for dumped tables
155--
156
157--
158-- AUTO_INCREMENT for table `drzava`
159--
160ALTER TABLE `drzava`
161 MODIFY `id_drzave` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
162
163--
164-- AUTO_INCREMENT for table `korisnici`
165--
166ALTER TABLE `korisnici`
167 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
168
169--
170-- AUTO_INCREMENT for table `marka`
171--
172ALTER TABLE `marka`
173 MODIFY `id_marke` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
174
175--
176-- AUTO_INCREMENT for table `model`
177--
178ALTER TABLE `model`
179 MODIFY `id_modela` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
180
181--
182-- Constraints for dumped tables
183--
184
185--
186-- Constraints for table `marka`
187--
188ALTER TABLE `marka`
189 ADD CONSTRAINT `marka_ibfk_1` FOREIGN KEY (`id_zemlje_porekla`) REFERENCES `drzava` (`id_drzave`);
190
191--
192-- Constraints for table `model`
193--
194ALTER TABLE `model`
195 ADD CONSTRAINT `model_ibfk_1` FOREIGN KEY (`id_marke`) REFERENCES `marka` (`id_marke`);
196COMMIT;
197
198/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
199/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
200/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;