· 8 years ago · Dec 08, 2017, 02:56 PM
1-- phpMyAdmin SQL Dump
2-- version 4.6.5.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 08, 2017 at 03:44 PM
7-- Server version: 10.1.21-MariaDB
8-- PHP Version: 5.6.30
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `interview`
21--
22CREATE DATABASE IF NOT EXISTS `interview` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
23USE `interview`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `countries`
29--
30
31CREATE TABLE `countries` (
32 `id` int(11) NOT NULL,
33 `country` varchar(255) NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
35
36--
37-- Dumping data for table `countries`
38--
39
40INSERT INTO `countries` (`id`, `country`) VALUES
41(1, 'Bulgaria'),
42(2, 'England'),
43(3, 'South Africa'),
44(4, 'Brazil');
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `roles`
50--
51
52CREATE TABLE `roles` (
53 `id` int(11) NOT NULL,
54 `role` varchar(32) NOT NULL
55) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
56
57--
58-- Dumping data for table `roles`
59--
60
61INSERT INTO `roles` (`id`, `role`) VALUES
62(1, 'admin'),
63(2, 'moderator'),
64(3, 'client');
65
66-- --------------------------------------------------------
67
68--
69-- Table structure for table `users`
70--
71
72CREATE TABLE `users` (
73 `id` int(11) NOT NULL,
74 `email` varchar(255) NOT NULL,
75 `country` int(11) NOT NULL
76) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
77
78--
79-- Dumping data for table `users`
80--
81
82INSERT INTO `users` (`id`, `email`, `country`) VALUES
83(1, '1_admin@test.com', 1),
84(2, '2_moderator@test.com', 2),
85(3, '3_client@test.com', 1),
86(4, '4_moderator@test.com', 3),
87(5, '5_client@test.com', 1);
88
89--
90-- Indexes for dumped tables
91--
92
93--
94-- Indexes for table `countries`
95--
96ALTER TABLE `countries`
97 ADD PRIMARY KEY (`id`);
98
99--
100-- Indexes for table `roles`
101--
102ALTER TABLE `roles`
103 ADD PRIMARY KEY (`id`);
104
105--
106-- Indexes for table `users`
107--
108ALTER TABLE `users`
109 ADD PRIMARY KEY (`id`);
110
111--
112-- AUTO_INCREMENT for dumped tables
113--
114
115--
116-- AUTO_INCREMENT for table `countries`
117--
118ALTER TABLE `countries`
119 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
120--
121-- AUTO_INCREMENT for table `roles`
122--
123ALTER TABLE `roles`
124 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
125--
126-- AUTO_INCREMENT for table `users`
127--
128ALTER TABLE `users`
129 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
130/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
131/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
132/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;