Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.8.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost
- -- Generation Time: Feb 23, 2019 at 04:13 PM
- -- Server version: 10.1.37-MariaDB
- -- PHP Version: 7.3.1
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Database: `hell`
- --
- CREATE DATABASE IF NOT EXISTS `hell` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- USE `hell`;
- -- --------------------------------------------------------
- --
- -- Table structure for table `contacts`
- --
- CREATE TABLE `contacts` (
- `id` int(11) NOT NULL,
- `user_id` int(11) DEFAULT NULL,
- `fname` varchar(155) DEFAULT NULL,
- `lname` varchar(155) DEFAULT NULL,
- `email` varchar(155) DEFAULT NULL,
- `address` varchar(255) DEFAULT NULL,
- `address2` varchar(255) DEFAULT NULL,
- `city` varchar(100) DEFAULT NULL,
- `state` varchar(100) DEFAULT NULL,
- `zip` varchar(65) NOT NULL,
- `home_phone` varchar(55) NOT NULL,
- `cell_phone` int(55) NOT NULL,
- `work_phone` int(55) NOT NULL,
- `deleted` tinyint(1) DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `contacts`
- --
- INSERT INTO `contacts` (`id`, `user_id`, `fname`, `lname`, `email`, `address`, `address2`, `city`, `state`, `zip`, `home_phone`, `cell_phone`, `work_phone`, `deleted`) VALUES
- (18, 7, 'contact', 'anatoli', '', '', '', '', '', '', '', 0, 0, 1),
- (19, 4, 'Valentin', 'Grigorean', 'vly.2814@gmail.com', 'Address', 'Address2', 'City', 'State', '111111', '333333', 222222, 444444, 0),
- (20, 4, 'aaaaaaaa', 'Nigga', 'nigga@gmail.com', 'Address', 'Address2', 'City', 'State', '111111', '333333', 222222, 44444422, 1),
- (21, 4, 'a', 'a', '', '', '', '', '', '', '', 0, 0, 1),
- (22, 8, 'delete ', 'me', '', '', '', '', '', '', '', 0, 0, 1),
- (23, 8, 'a', 'a', '', '', '', '', '', '', '', 0, 0, 0),
- (24, 8, 'a', 'a', '', '', '', '', '', '', '', 0, 0, 1),
- (25, 4, 'ghita', 'te fute', '', '', '', '', '', '', '', 0, 0, 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `files`
- --
- CREATE TABLE `files` (
- `id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `name` varchar(150) NOT NULL,
- `deleted` tinyint(4) NOT NULL,
- `format` varchar(5) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `files`
- --
- INSERT INTO `files` (`id`, `user_id`, `name`, `deleted`, `format`) VALUES
- (14, 7, 'killer.jpg', 0, 'jpg'),
- (15, 7, 'desert.jpg', 1, 'jpg'),
- (20, 4, 'angelo.jpg', 0, 'jpg'),
- (21, 4, 'angelo.jpg', 0, 'jpg'),
- (22, 4, 'angelo.jpg', 0, 'jpg'),
- (23, 4, 'angelo.jpg', 0, 'jpg'),
- (24, 4, 'angelo.jpg', 0, 'jpg'),
- (25, 4, 'angelo.jpg', 0, 'jpg'),
- (26, 4, 'angelo.jpg', 0, 'jpg'),
- (27, 4, 'angelo.jpg', 0, 'jpg'),
- (28, 4, 'angelo.jpg', 0, 'jpg'),
- (29, 4, 'angelo.jpg', 0, 'jpg'),
- (30, 4, 'angelo.jpg', 0, 'jpg'),
- (31, 4, 'angelo.jpg', 0, 'jpg'),
- (32, 4, 'angelo.jpg', 0, 'jpg'),
- (33, 4, 'angelo.jpg', 0, 'jpg'),
- (34, 4, 'angelo.jpg', 0, 'jpg'),
- (35, 4, 'angelo.jpg', 0, 'jpg'),
- (36, 4, 'angelo.jpg', 0, 'jpg'),
- (37, 4, 'angelo.jpg', 0, 'jpg'),
- (38, 4, 'angelo.jpg', 0, 'jpg'),
- (39, 4, 'angelo.jpg', 0, 'jpg'),
- (40, 4, 'anatolii.png', 0, 'png'),
- (41, 4, 'anatoli.png', 0, 'png'),
- (42, 4, 'angelo.jpg', 0, 'jpg'),
- (43, 4, 'anatoli.png', 0, 'png'),
- (44, 4, 'angel.jpg', 0, 'jpg'),
- (45, 4, 'angel.jpg', 0, 'jpg'),
- (46, 4, 'please.jpg', 0, 'jpg'),
- (47, 4, 'ok.jpg', 0, 'jpg'),
- (48, 4, 'wall.jpg', 0, 'jpg');
- -- --------------------------------------------------------
- --
- -- Table structure for table `users`
- --
- CREATE TABLE `users` (
- `id` int(11) NOT NULL,
- `username` varchar(150) NOT NULL,
- `email` varchar(150) NOT NULL,
- `password` varchar(150) NOT NULL,
- `fname` varchar(150) NOT NULL,
- `lname` varchar(150) NOT NULL,
- `acl` text,
- `deleted` tinyint(4) DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `users`
- --
- INSERT INTO `users` (`id`, `username`, `email`, `password`, `fname`, `lname`, `acl`, `deleted`) VALUES
- (4, 'infernus', 'vly.2814@gmail.com', '$2y$10$9dxlN0prPofMs5hDtwxLC.l8Ld5Et1W0BFN2adfFdRLXD21AE1ILG', 'Valentin', 'Grigorean', NULL, 0),
- (7, 'anatoli', 'socketwisp@gmail.com', '$2y$10$tuJrjicXAI8/Vn/8m6cWjuMny/uOlaizQeFyVN01Le2TILfm9ni7C', 'Anatoli', 'Slavking', NULL, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `user_sessions`
- --
- CREATE TABLE `user_sessions` (
- `id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `session` varchar(255) NOT NULL,
- `user_agent` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `user_sessions`
- --
- INSERT INTO `user_sessions` (`id`, `user_id`, `session`, `user_agent`) VALUES
- (49, 4, '68d30a9594728bc39aa24be94b319d21', 'Mozilla (X11; Ubuntu; Linux x86_64; rv:65.0) Gecko Firefox'),
- (55, 4, 'f4b9ec30ad9f68f89b29639786cb62ef', 'Mozilla (X11; Linux x86_64) AppleWebKit (KHTML, like Gecko) Ubuntu Chromium Chrome Safari');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `contacts`
- --
- ALTER TABLE `contacts`
- ADD PRIMARY KEY (`id`),
- ADD KEY `user_id` (`user_id`),
- ADD KEY `deleted` (`deleted`);
- --
- -- Indexes for table `files`
- --
- ALTER TABLE `files`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `users`
- --
- ALTER TABLE `users`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `user_sessions`
- --
- ALTER TABLE `user_sessions`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `contacts`
- --
- ALTER TABLE `contacts`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
- --
- -- AUTO_INCREMENT for table `files`
- --
- ALTER TABLE `files`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;
- --
- -- AUTO_INCREMENT for table `users`
- --
- ALTER TABLE `users`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
- --
- -- AUTO_INCREMENT for table `user_sessions`
- --
- ALTER TABLE `user_sessions`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;
- COMMIT;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement