· 8 years ago · Mar 06, 2018, 05:58 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Mar 06, 2018 at 11:25 AM
7-- Server version: 5.6.26
8-- PHP Version: 5.5.28
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: `hacking`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `products`
27--
28
29CREATE TABLE IF NOT EXISTS `products` (
30 `Id` int(100) NOT NULL,
31 `Product` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
32 `Picture` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
33 `Description` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
34 `Cost` int(100) NOT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `products`
39--
40
41INSERT INTO `products` (`Id`, `Product`, `Picture`, `Description`, `Cost`) VALUES
42(1, 'SanDisk 32Gb Pendrive', 'san32gb.jpg', '32 Gb SanDisk Pendrive.\r\n<br>Ultra-compact and portable <br>\r\nUSB flash drive<br>\r\nShare your photos, videos, songs and other files between computers with ease<br>\r\nProtect your private files with included SanDisk SecureAccess software<br>\r\nIncludes added protection of secure online backup (up to 2GB optionally available) offered by YuuWaa<br>\r\nPassword-protect your sensitive files<br>\r\nCapless design<br>\r\nShare your work files between computers with ease<br>', 600),
43(2, 'American Outlet Plug Adapter', 'adapter.jpg', 'Converts plugs from any country into a three prong, grounded American plug<br>\r\nOne multi-country three prong outlet plug adapter<br>\r\nLightweight and compact, perfect for travelers<br>', 200),
44(3, 'Hacker mask', 'hacker.jpg', 'Plastic<br>\r\nMade in the USA or Imported<br>\r\nPerfect mask for Halloween a parade or any party<br>\r\nInspired by the movie<br>\r\nMade of durable plastic<br>\r\nHas a band at the back for a strong grip<br>\r\nSize: about 8" L x 7" W<br>', 150),
45(4, 'Samsung OEM Adapter with USB', 'scharger.jpg', 'Material: Plastic, Metal<br>\r\nTravel Wall Adapter & Data Cable<br>\r\nAdaptive Fast Charging Charges Your Compatible Device From 0 to 50% in about 30 min.<br>\r\nSync Files & Charge Your Device From a Computer Using Just The Data Cable<br>\r\nCable Length: 1m/3.3FT<br>\r\nCompatible for All Micro USB Phones, <br>\r\nAdaptive Fast Charging is only compatible for Galaxy S7 / S7 Edge, <br>\r\nGalaxy S6 / S6 Edge/ Galaxy S6 Edge+ Plus / Galaxy Note 5', 800),
46(5, 'Wi-Fi USB Adapter', 'wdongle.jpg', 'Supports 150 Mbps 802.11n Wireless data rate - the latest wireless standard.<br>\r\n Permits users to have the farthest range with the widest coverage. <br>\r\n(Up to 6 times the speed and 3 times the coverage of 802.11b.).<br>\r\nPower Saving designed to support smart transmit power control and auto-idle state adjustment<br>\r\nSupports WMM (Wi-Fi Multimedia) Standard so that you can let different types of data have higher priority. <br>\r\nIt would allows better streaming of real-time data such as Video, Music, Skype etc<br>', 600);
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `users`
52--
53
54CREATE TABLE IF NOT EXISTS `users` (
55 `Id` int(100) NOT NULL,
56 `Name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
57 `Email` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
58 `Password` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
59 `Phone` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
60 `role` varchar(100) NOT NULL
61) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
62
63--
64-- Dumping data for table `users`
65--
66
67INSERT INTO `users` (`Id`, `Name`, `Email`, `Password`, `Phone`, `role`) VALUES
68(1, 'Demo User', 'demouser@gmail.com', 'e2aea7ce7eb227fed4f8e9b80959c327', '9160917765', 'user'),
69(2, 'admin', 'admin@gmail.com', 'e2aea7ce7eb227fed4f8e9b80959c327', '9999999999', 'admin');
70
71--
72-- Indexes for dumped tables
73--
74
75--
76-- Indexes for table `products`
77--
78ALTER TABLE `products`
79 ADD PRIMARY KEY (`Id`);
80
81--
82-- Indexes for table `users`
83--
84ALTER TABLE `users`
85 ADD PRIMARY KEY (`Id`);
86
87--
88-- AUTO_INCREMENT for dumped tables
89--
90
91--
92-- AUTO_INCREMENT for table `products`
93--
94ALTER TABLE `products`
95 MODIFY `Id` int(100) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
96--
97-- AUTO_INCREMENT for table `users`
98--
99ALTER TABLE `users`
100 MODIFY `Id` int(100) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
101/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
102/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
103/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;