· 6 years ago · Oct 21, 2019, 02:20 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 21, 2019 at 04:15 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(5, 'user', 'user1', 'user@mail.com', '2019-10-11 17:14:19', 'korisnik', 'b95b9809110b1af5b987a0ed702b0b54b9c930c9'),
78(6, 'predrag', 'mijatovic', 'pedja@ptt.yu', '2019-10-11 17:29:30', 'korisnik', '547d28992fb22121a664318564b701b96d022d13'),
79(7, 'ljubinko', 'drulovic', 'ljube@ptt.rs', '2019-10-14 15:44:43', 'korisnik', 'd3d3820571f1dc6d14d682ad7648b7f5b4f7110d'),
80(8, 'admin', 'admin', 'admin@admin.admin', '2019-10-14 16:31:27', 'admin', 'e6dc425c27e80ce347e8e8ab73a43b3f22e1cddf'),
81(9, 'fsadf', 'fasdf', 'fdsafa@efdas', '2019-10-15 16:25:29', 'korisnik', 'a2ac11ec472d1741141a8eb62a1857479e2c0e77'),
82(10, 'fsadf', 'fasdf', 'fdsafa@efdas', '2019-10-15 16:26:21', 'korisnik', '84e3242a83a068166958faff4c9cbc6f936fefcb');
83
84-- --------------------------------------------------------
85
86--
87-- Table structure for table `marka`
88--
89
90DROP TABLE IF EXISTS `marka`;
91CREATE TABLE `marka` (
92 `id_marke` int(11) NOT NULL,
93 `naziv_marke` varchar(40) NOT NULL,
94 `id_zemlje_porekla` int(11) NOT NULL
95) ENGINE=InnoDB DEFAULT CHARSET=latin1;
96
97--
98-- Dumping data for table `marka`
99--
100
101INSERT INTO `marka` (`id_marke`, `naziv_marke`, `id_zemlje_porekla`) VALUES
102(1, 'MB', 18),
103(2, 'Nisan', 15);
104
105-- --------------------------------------------------------
106
107--
108-- Table structure for table `model`
109--
110
111DROP TABLE IF EXISTS `model`;
112CREATE TABLE `model` (
113 `id_modela` int(11) NOT NULL,
114 `id_marke` int(11) NOT NULL,
115 `naziv_modela` varchar(50) NOT NULL,
116 `godiste` smallint(4) NOT NULL,
117 `snaga` int(11) NOT NULL,
118 `cena` decimal(10,2) NOT NULL
119) ENGINE=InnoDB DEFAULT CHARSET=latin1;
120
121--
122-- Dumping data for table `model`
123--
124
125INSERT INTO `model` (`id_modela`, `id_marke`, `naziv_modela`, `godiste`, `snaga`, `cena`) VALUES
126(1, 1, 'cls', 2001, 136, '2000.00'),
127(2, 2, 'skyline', 2002, 100, '3600.00');
128
129--
130-- Indexes for dumped tables
131--
132
133--
134-- Indexes for table `drzava`
135--
136ALTER TABLE `drzava`
137 ADD PRIMARY KEY (`id_drzave`);
138
139--
140-- Indexes for table `korisnici`
141--
142ALTER TABLE `korisnici`
143 ADD PRIMARY KEY (`id`);
144
145--
146-- Indexes for table `marka`
147--
148ALTER TABLE `marka`
149 ADD PRIMARY KEY (`id_marke`),
150 ADD KEY `id_zemlje_porekla` (`id_zemlje_porekla`);
151
152--
153-- Indexes for table `model`
154--
155ALTER TABLE `model`
156 ADD PRIMARY KEY (`id_modela`),
157 ADD KEY `id_marke` (`id_marke`);
158
159--
160-- AUTO_INCREMENT for dumped tables
161--
162
163--
164-- AUTO_INCREMENT for table `drzava`
165--
166ALTER TABLE `drzava`
167 MODIFY `id_drzave` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
168
169--
170-- AUTO_INCREMENT for table `korisnici`
171--
172ALTER TABLE `korisnici`
173 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
174
175--
176-- AUTO_INCREMENT for table `marka`
177--
178ALTER TABLE `marka`
179 MODIFY `id_marke` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
180
181--
182-- AUTO_INCREMENT for table `model`
183--
184ALTER TABLE `model`
185 MODIFY `id_modela` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
186
187--
188-- Constraints for dumped tables
189--
190
191--
192-- Constraints for table `marka`
193--
194ALTER TABLE `marka`
195 ADD CONSTRAINT `marka_ibfk_1` FOREIGN KEY (`id_zemlje_porekla`) REFERENCES `drzava` (`id_drzave`);
196
197--
198-- Constraints for table `model`
199--
200ALTER TABLE `model`
201 ADD CONSTRAINT `model_ibfk_1` FOREIGN KEY (`id_marke`) REFERENCES `marka` (`id_marke`);
202COMMIT;
203
204/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
205/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
206/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;