· 6 years ago · Mar 25, 2019, 04:52 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Mar 25, 2019 at 04:49 PM
7-- Server version: 5.7.23
8-- PHP Version: 7.2.10
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: `ij18_19_2`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `uploads`
29--
30
31DROP TABLE IF EXISTS `uploads`;
32CREATE TABLE IF NOT EXISTS `uploads` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `name` varchar(300) NOT NULL,
35 `file_path` varchar(1000) NOT NULL,
36 `alt` varchar(100) NOT NULL,
37 `user_id` int(11) NOT NULL,
38 PRIMARY KEY (`id`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
40
41-- --------------------------------------------------------
42
43--
44-- Table structure for table `users`
45--
46
47DROP TABLE IF EXISTS `users`;
48CREATE TABLE IF NOT EXISTS `users` (
49 `id` int(11) NOT NULL AUTO_INCREMENT,
50 `first_name` varchar(200) NOT NULL,
51 `last_name` varchar(200) NOT NULL,
52 `email` varchar(200) NOT NULL,
53 `username` varchar(200) NOT NULL,
54 `password` varchar(200) NOT NULL,
55 `role` enum('1','2','3') NOT NULL,
56 PRIMARY KEY (`id`)
57) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
58
59--
60-- Dumping data for table `users`
61--
62
63INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `username`, `password`, `role`) VALUES
64(1, 'dsadsad', 'RETYUIOP', 'igorjanosevic@gmail.com', 'oifhoidh', '123', '1'),
65(2, 'Mihajlo', 'Tomic', 'mihajlotomic@gmail.com', 'mihajlo', '123', '1'),
66(3, 'Isidora', 'Nikolic', 'isidoranikolic@gmail.com', 'isidora', '123', '1'),
67(4, 'Mikelnadjelo', 'uuuu', 'neko@gmail.com', 'xxx', '123', ''),
68(5, 'Bil', 'Gejts', 'bill@microsoft.com', 'sta_je_hteo', 'admin123', '1'),
69(7, 'Majkl', 'Dzrodan', 'majkl@gmail.com', 'majkl', '123', '');
70COMMIT;
71
72/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
73/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
74/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;