· 6 years ago · Oct 25, 2019, 09:46 AM
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 25, 2019 at 11:41 AM
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: `fakultetiv1`
23--
24CREATE DATABASE IF NOT EXISTS `fakultetiv1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `fakultetiv1`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `korisnik`
31--
32
33DROP TABLE IF EXISTS `korisnik`;
34CREATE TABLE `korisnik` (
35 `id` int(11) NOT NULL,
36 `ime` varchar(30) NOT NULL,
37 `sifra` varchar(128) NOT NULL,
38 `email` varchar(100) NOT NULL,
39 `privilegija` enum('admin','korisnik','moderator','drugo') NOT NULL DEFAULT 'korisnik',
40 `aktivan` tinyint(1) NOT NULL DEFAULT '0'
41) ENGINE=InnoDB DEFAULT CHARSET=latin1;
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `student`
47--
48
49DROP TABLE IF EXISTS `student`;
50CREATE TABLE `student` (
51 `index_studenta` varchar(10) NOT NULL,
52 `ime` varchar(30) NOT NULL,
53 `prezime` varchar(30) NOT NULL,
54 `status` varchar(1) NOT NULL,
55 `sifra` varchar(10) NOT NULL,
56 `slika` varchar(255) NOT NULL
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58
59--
60-- Dumping data for table `student`
61--
62
63INSERT INTO `student` (`index_studenta`, `ime`, `prezime`, `status`, `sifra`, `slika`) VALUES
64('1', 'Pera', 'Detlic', 'B', 'IT19', ''),
65('111a', 'weebly', 'bird', 'S', '19', ''),
66('115', 'Nikola', 'Boskovic', 'B', 'it19', 'okokret.jpg'),
67('12', 'Sara', 'Peric', 'B', '12', 'download.jpg'),
68('1222', 'Miki', 'Peric', 'B', '12', 'okokret.jpg'),
69('IT190/2019', 'Pera', 'Peric', 'B', 'IT19', ''),
70('IT191/2019', 'PERA', 'Detlic', 'B', 'IT19', '');
71
72--
73-- Indexes for dumped tables
74--
75
76--
77-- Indexes for table `korisnik`
78--
79ALTER TABLE `korisnik`
80 ADD PRIMARY KEY (`id`);
81
82--
83-- Indexes for table `student`
84--
85ALTER TABLE `student`
86 ADD PRIMARY KEY (`index_studenta`);
87
88--
89-- AUTO_INCREMENT for dumped tables
90--
91
92--
93-- AUTO_INCREMENT for table `korisnik`
94--
95ALTER TABLE `korisnik`
96 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
97COMMIT;
98
99/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
100/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
101/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;