· 6 years ago · Oct 22, 2019, 06:40 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 22, 2019 at 08:37 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: `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 `student`
31--
32
33DROP TABLE IF EXISTS `student`;
34CREATE TABLE `student` (
35 `broj_indexa` varchar(10) NOT NULL,
36 `ime` varchar(30) NOT NULL,
37 `prezime` varchar(30) NOT NULL,
38 `status` varchar(10) NOT NULL,
39 `sifra` varchar(10) NOT NULL,
40 `slika` varchar(255) NOT NULL
41) ENGINE=InnoDB DEFAULT CHARSET=latin1;
42
43--
44-- Dumping data for table `student`
45--
46
47INSERT INTO `student` (`broj_indexa`, `ime`, `prezime`, `status`, `sifra`, `slika`) VALUES
48('11', 'pera', 'Peric', 's', ' it19', 'zasekciju.PNG'),
49('12', 'Markovic', 'Marko', 's', 'IT19', ''),
50('13', 'Pera', 'Peric', 's', '', 'okokret.jpg'),
51('32', 'Danilo', 'Sakic', 'b', '', 'slike_cveca-ljiljani-ljiljani_slike-slike_ljiljana-cvece_slike7.jpg'),
52('IT190/2019', 'pera', 'Detlic', 's', 'IT19', ''),
53('IT191/2019', 'Donald', 'Duck', 'b', 'IT19', ''),
54('IT199/2019', 'PERA', 'Duck', 's', 'hsd', '');
55
56--
57-- Indexes for dumped tables
58--
59
60--
61-- Indexes for table `student`
62--
63ALTER TABLE `student`
64 ADD PRIMARY KEY (`broj_indexa`);
65COMMIT;
66
67/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
68/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
69/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;