· 7 years ago · Feb 23, 2019, 03:18 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Generation Time: Feb 23, 2019 at 04:13 PM
7-- Server version: 10.1.37-MariaDB
8-- PHP Version: 7.3.1
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: `hell`
23--
24CREATE DATABASE IF NOT EXISTS `hell` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `hell`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `contacts`
31--
32
33CREATE TABLE `contacts` (
34 `id` int(11) NOT NULL,
35 `user_id` int(11) DEFAULT NULL,
36 `fname` varchar(155) DEFAULT NULL,
37 `lname` varchar(155) DEFAULT NULL,
38 `email` varchar(155) DEFAULT NULL,
39 `address` varchar(255) DEFAULT NULL,
40 `address2` varchar(255) DEFAULT NULL,
41 `city` varchar(100) DEFAULT NULL,
42 `state` varchar(100) DEFAULT NULL,
43 `zip` varchar(65) NOT NULL,
44 `home_phone` varchar(55) NOT NULL,
45 `cell_phone` int(55) NOT NULL,
46 `work_phone` int(55) NOT NULL,
47 `deleted` tinyint(1) DEFAULT '0'
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49
50--
51-- Dumping data for table `contacts`
52--
53
54INSERT INTO `contacts` (`id`, `user_id`, `fname`, `lname`, `email`, `address`, `address2`, `city`, `state`, `zip`, `home_phone`, `cell_phone`, `work_phone`, `deleted`) VALUES
55(18, 7, 'contact', 'anatoli', '', '', '', '', '', '', '', 0, 0, 1),
56(19, 4, 'Valentin', 'Grigorean', 'vly.2814@gmail.com', 'Address', 'Address2', 'City', 'State', '111111', '333333', 222222, 444444, 0),
57(20, 4, 'aaaaaaaa', 'Nigga', 'nigga@gmail.com', 'Address', 'Address2', 'City', 'State', '111111', '333333', 222222, 44444422, 1),
58(21, 4, 'a', 'a', '', '', '', '', '', '', '', 0, 0, 1),
59(22, 8, 'delete ', 'me', '', '', '', '', '', '', '', 0, 0, 1),
60(23, 8, 'a', 'a', '', '', '', '', '', '', '', 0, 0, 0),
61(24, 8, 'a', 'a', '', '', '', '', '', '', '', 0, 0, 1),
62(25, 4, 'ghita', 'te fute', '', '', '', '', '', '', '', 0, 0, 1);
63
64-- --------------------------------------------------------
65
66--
67-- Table structure for table `files`
68--
69
70CREATE TABLE `files` (
71 `id` int(11) NOT NULL,
72 `user_id` int(11) NOT NULL,
73 `name` varchar(150) NOT NULL,
74 `deleted` tinyint(4) NOT NULL,
75 `format` varchar(5) NOT NULL
76) ENGINE=InnoDB DEFAULT CHARSET=latin1;
77
78--
79-- Dumping data for table `files`
80--
81
82INSERT INTO `files` (`id`, `user_id`, `name`, `deleted`, `format`) VALUES
83(14, 7, 'killer.jpg', 0, 'jpg'),
84(15, 7, 'desert.jpg', 1, 'jpg'),
85(20, 4, 'angelo.jpg', 0, 'jpg'),
86(21, 4, 'angelo.jpg', 0, 'jpg'),
87(22, 4, 'angelo.jpg', 0, 'jpg'),
88(23, 4, 'angelo.jpg', 0, 'jpg'),
89(24, 4, 'angelo.jpg', 0, 'jpg'),
90(25, 4, 'angelo.jpg', 0, 'jpg'),
91(26, 4, 'angelo.jpg', 0, 'jpg'),
92(27, 4, 'angelo.jpg', 0, 'jpg'),
93(28, 4, 'angelo.jpg', 0, 'jpg'),
94(29, 4, 'angelo.jpg', 0, 'jpg'),
95(30, 4, 'angelo.jpg', 0, 'jpg'),
96(31, 4, 'angelo.jpg', 0, 'jpg'),
97(32, 4, 'angelo.jpg', 0, 'jpg'),
98(33, 4, 'angelo.jpg', 0, 'jpg'),
99(34, 4, 'angelo.jpg', 0, 'jpg'),
100(35, 4, 'angelo.jpg', 0, 'jpg'),
101(36, 4, 'angelo.jpg', 0, 'jpg'),
102(37, 4, 'angelo.jpg', 0, 'jpg'),
103(38, 4, 'angelo.jpg', 0, 'jpg'),
104(39, 4, 'angelo.jpg', 0, 'jpg'),
105(40, 4, 'anatolii.png', 0, 'png'),
106(41, 4, 'anatoli.png', 0, 'png'),
107(42, 4, 'angelo.jpg', 0, 'jpg'),
108(43, 4, 'anatoli.png', 0, 'png'),
109(44, 4, 'angel.jpg', 0, 'jpg'),
110(45, 4, 'angel.jpg', 0, 'jpg'),
111(46, 4, 'please.jpg', 0, 'jpg'),
112(47, 4, 'ok.jpg', 0, 'jpg'),
113(48, 4, 'wall.jpg', 0, 'jpg');
114
115-- --------------------------------------------------------
116
117--
118-- Table structure for table `users`
119--
120
121CREATE TABLE `users` (
122 `id` int(11) NOT NULL,
123 `username` varchar(150) NOT NULL,
124 `email` varchar(150) NOT NULL,
125 `password` varchar(150) NOT NULL,
126 `fname` varchar(150) NOT NULL,
127 `lname` varchar(150) NOT NULL,
128 `acl` text,
129 `deleted` tinyint(4) DEFAULT '0'
130) ENGINE=InnoDB DEFAULT CHARSET=latin1;
131
132--
133-- Dumping data for table `users`
134--
135
136INSERT INTO `users` (`id`, `username`, `email`, `password`, `fname`, `lname`, `acl`, `deleted`) VALUES
137(4, 'infernus', 'vly.2814@gmail.com', '$2y$10$9dxlN0prPofMs5hDtwxLC.l8Ld5Et1W0BFN2adfFdRLXD21AE1ILG', 'Valentin', 'Grigorean', NULL, 0),
138(7, 'anatoli', 'socketwisp@gmail.com', '$2y$10$tuJrjicXAI8/Vn/8m6cWjuMny/uOlaizQeFyVN01Le2TILfm9ni7C', 'Anatoli', 'Slavking', NULL, 0);
139
140-- --------------------------------------------------------
141
142--
143-- Table structure for table `user_sessions`
144--
145
146CREATE TABLE `user_sessions` (
147 `id` int(11) NOT NULL,
148 `user_id` int(11) NOT NULL,
149 `session` varchar(255) NOT NULL,
150 `user_agent` varchar(255) NOT NULL
151) ENGINE=InnoDB DEFAULT CHARSET=latin1;
152
153--
154-- Dumping data for table `user_sessions`
155--
156
157INSERT INTO `user_sessions` (`id`, `user_id`, `session`, `user_agent`) VALUES
158(49, 4, '68d30a9594728bc39aa24be94b319d21', 'Mozilla (X11; Ubuntu; Linux x86_64; rv:65.0) Gecko Firefox'),
159(55, 4, 'f4b9ec30ad9f68f89b29639786cb62ef', 'Mozilla (X11; Linux x86_64) AppleWebKit (KHTML, like Gecko) Ubuntu Chromium Chrome Safari');
160
161--
162-- Indexes for dumped tables
163--
164
165--
166-- Indexes for table `contacts`
167--
168ALTER TABLE `contacts`
169 ADD PRIMARY KEY (`id`),
170 ADD KEY `user_id` (`user_id`),
171 ADD KEY `deleted` (`deleted`);
172
173--
174-- Indexes for table `files`
175--
176ALTER TABLE `files`
177 ADD PRIMARY KEY (`id`);
178
179--
180-- Indexes for table `users`
181--
182ALTER TABLE `users`
183 ADD PRIMARY KEY (`id`);
184
185--
186-- Indexes for table `user_sessions`
187--
188ALTER TABLE `user_sessions`
189 ADD PRIMARY KEY (`id`);
190
191--
192-- AUTO_INCREMENT for dumped tables
193--
194
195--
196-- AUTO_INCREMENT for table `contacts`
197--
198ALTER TABLE `contacts`
199 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
200
201--
202-- AUTO_INCREMENT for table `files`
203--
204ALTER TABLE `files`
205 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;
206
207--
208-- AUTO_INCREMENT for table `users`
209--
210ALTER TABLE `users`
211 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
212
213--
214-- AUTO_INCREMENT for table `user_sessions`
215--
216ALTER TABLE `user_sessions`
217 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;
218COMMIT;
219
220/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
221/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
222/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;