3eELUgZm

1-- phpMyAdmin SQL Dump
2-- version 4.8.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Oct 29, 2019 at 12:47 PM
7-- Server version: 10.1.34-MariaDB
8-- PHP Version: 7.2.7
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: `fakultetiv5`
23--
24CREATE DATABASE IF NOT EXISTS `fakultetiv5` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `fakultetiv5`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `korisnici`
31--
32
33DROP TABLE IF EXISTS `korisnici`;
34CREATE TABLE `korisnici` (
35  `id` int(11) NOT NULL,
36  `ime` varchar(30) NOT NULL,
37  `prezime` varchar(30) NOT NULL,
38  `email` varchar(100) NOT NULL,
39  `psw` varchar(128) NOT NULL,
40  `aktivan` tinyint(1) NOT NULL DEFAULT '0',
41  `privilegija` enum('admin','korisnik','moderator','ostalo') NOT NULL DEFAULT 'korisnik'
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44--
45-- Dumping data for table `korisnici`
46--
47
48INSERT INTO `korisnici` (`id`, `ime`, `prezime`, `email`, `psw`, `aktivan`, `privilegija`) VALUES
49(1, 'Nikola', 'Jokic', 'jokic@jokic.com', '446497640d09bff03426aae4cacb9c09ebf44b64', 0, 'korisnik'),
50(2, 'Nemanja', 'Vidic', 'nemanja@vidic.com', '42c32c9a7104ca4ec49857dc3614b5bdda6aa7fc', 0, 'korisnik');
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `student`
56--
57
58DROP TABLE IF EXISTS `student`;
59CREATE TABLE `student` (
60  `broj_indexa` varchar(10) NOT NULL,
61  `ime` varchar(30) NOT NULL,
62  `prezime` varchar(30) NOT NULL,
63  `status` varchar(10) NOT NULL,
64  `sifra` varchar(10) NOT NULL,
65  `slika` varchar(255) NOT NULL
66) ENGINE=InnoDB DEFAULT CHARSET=latin1;
67
68--
69-- Dumping data for table `student`
70--
71
72INSERT INTO `student` (`broj_indexa`, `ime`, `prezime`, `status`, `sifra`, `slika`) VALUES
73('11', 'pera', 'Peric', 's', ' it19', 'zasekciju.PNG'),
74('12', 'Markovic', 'Marko', 's', 'IT19', ''),
75('13', 'Pera', 'Peric', 's', '', 'okokret.jpg'),
76('32', 'Danilo', 'Sakic', 'b', '', 'slike_cveca-ljiljani-ljiljani_slike-slike_ljiljana-cvece_slike7.jpg'),
77('IT190/2019', 'pera', 'Detlic', 's', 'IT19', ''),
78('IT191/2019', 'Donald', 'Duck', 'b', 'IT19', ''),
79('IT199/2019', 'PERA', 'Duck', 's', 'hsd', '');
80
81--
82-- Indexes for dumped tables
83--
84
85--
86-- Indexes for table `korisnici`
87--
88ALTER TABLE `korisnici`
89  ADD PRIMARY KEY (`id`),
90  ADD UNIQUE KEY `email` (`email`);
91
92--
93-- Indexes for table `student`
94--
95ALTER TABLE `student`
96  ADD PRIMARY KEY (`broj_indexa`);
97
98--
99-- AUTO_INCREMENT for dumped tables
100--
101
102--
103-- AUTO_INCREMENT for table `korisnici`
104--
105ALTER TABLE `korisnici`
106  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
107COMMIT;
108
109/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
110/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
111/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;