· 6 years ago · Apr 29, 2019, 08:46 AM
1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 28, 2019 at 05:52 PM
7-- Server version: 10.1.35-MariaDB
8-- PHP Version: 7.2.9
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: `ecom`
23--
24CREATE DATABASE IF NOT EXISTS `ecom` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
25USE `ecom`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `category`
31--
32
33CREATE TABLE `category` (
34 `category_id` int(11) NOT NULL,
35 `category_name` varchar(150) COLLATE utf8_bin DEFAULT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
37
38--
39-- Dumping data for table `category`
40--
41
42INSERT INTO `category` (`category_id`, `category_name`) VALUES
43(12, 'Electronics'),
44(14, 'Fashion'),
45(16, 'Movies'),
46(18, 'Parts'),
47(20, 'Sports');
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `delivery`
53--
54
55CREATE TABLE `delivery` (
56 `delivery_id` int(50) NOT NULL,
57 `delivery_address` varchar(100) COLLATE utf8_bin NOT NULL,
58 `delivery_city` varchar(50) COLLATE utf8_bin NOT NULL,
59 `delivery_state` varchar(50) COLLATE utf8_bin NOT NULL,
60 `delivery_zipcode` int(50) NOT NULL,
61 `delivery_phone` varchar(100) COLLATE utf8_bin NOT NULL,
62 `user_id` int(50) NOT NULL
63) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
64
65--
66-- Dumping data for table `delivery`
67--
68
69INSERT INTO `delivery` (`delivery_id`, `delivery_address`, `delivery_city`, `delivery_state`, `delivery_zipcode`, `delivery_phone`, `user_id`) VALUES
70(36, 'Patel Street Near jain Temple', 'Jambusar', 'Gujarat', 392150, '9033664581', 5899),
71(37, 'Kalupur relvay Station', 'Ahmedabad', 'Gujarat', 392260, '9409540077', 1077),
72(38, 'Nuclear Park Society', 'Vadodara', 'Gujarat', 390021, '9409540074', 1078),
73(39, 'Rajkot railway Station', 'Rajkot', 'Gujarat', 393360, '9429350095', 4581),
74(40, 'Mahadev Nagar Society', 'Jambusar', 'Gujarat', 392150, '849080010', 8490);
75
76-- --------------------------------------------------------
77
78--
79-- Table structure for table `price`
80--
81
82CREATE TABLE `price` (
83 `price_id` int(50) NOT NULL,
84 `price_unit` varchar(100) COLLATE utf8_bin DEFAULT NULL,
85 `product_id` int(50) DEFAULT NULL
86) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
87
88--
89-- Dumping data for table `price`
90--
91
92INSERT INTO `price` (`price_id`, `price_unit`, `product_id`) VALUES
93(1, '26,198', 1),
94(2, '19,529', 2),
95(3, '29,990', 3),
96(4, '4,999', 4),
97(5, '18,425', 5),
98(6, '17,750', 6),
99(8, '14,251', 8),
100(9, '17,736', 9),
101(10, '9490', 10),
102(11, '900 ', 11),
103(12, '2100', 12),
104(13, '2559', 13),
105(14, '699', 14),
106(15, '299', 15),
107(16, '399', 16),
108(17, '999', 17),
109(18, '599', 18),
110(19, '2550', 19),
111(20, '1500', 20);
112
113-- --------------------------------------------------------
114
115--
116-- Table structure for table `product`
117--
118
119CREATE TABLE `product` (
120 `product_id` int(50) NOT NULL,
121 `product_name` varchar(150) COLLATE utf8_bin DEFAULT NULL,
122 `product_description` text COLLATE utf8_bin,
123 `category_id` int(50) DEFAULT NULL,
124 `subcategory_id` int(50) DEFAULT NULL
125) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
126
127--
128-- Dumping data for table `product`
129--
130
131INSERT INTO `product` (`product_id`, `product_name`, `product_description`, `category_id`, `subcategory_id`) VALUES
132(1, 'LENOVO LEGION', 'Hernà notebook Lenovo Legion Y720-15IKB / A stav / ÄtyÅ™jádrový Intel Core i5-7300HQ @ 2,5 GHz, Broadwell, PassMark - 6802 / 8 GB RAM DDR4 / 256 GB SSD M.2 + 1000 GB HDD / Windows 10 Home CZ / HDMI / mini DiplayPort / USB 3.0 / 15.6\" LED 1920 x 1080 / NVID', 12, 24),
133(2, 'Huawei MateBook', 'Compact 15.6 \"notebook with a representative design. Intel Core i5-8250U 4-core processor (1.6GHz, TB 3.4GHz, HyperThreading); 8GB memory; 15.6\" IPS display (1920x1080 pixels); graphics NVIDIA GeForce MX150 2GB GDDR5; 128GB SSD and 1TB HDD; without mechanics; Wi-Fi ac, Bluetooth 4.1, USB, camera; Windows 10 Home operating system.\r\n\r\n', 12, 24),
134(3, 'Microsoft Surface', 'Notebook - Intel Core i5 8250U Kaby Lake Refresh, 13.5 \"2256x1504, Intel UHD Graphics 620, RAM 8GB, 128GB SSD, WiFi, Bluetooth, TPM, Windows Hello, USB 3.0, Micro SD Card Reader, Windows 10 Home', 12, 24),
135(4, 'ASUS Transformer', 'Notebook - Quad-Core Intel Atom Z3740 Processor (2M Cache, 1.33 GHz, Turbo Mode to 1.86GHz), 2GB DDR3 Memory, 10.1 \"IPS Multi-Touch Display (1366 x 768 Dots), 32GB Internal Memory, Card Reader, WiFi, Bluetooth microHDMI, microUSB, USB 3.0 port, SonicMaster audio, 1.2 Mpix camera, OS Widnows 10', 12, 24),
136(5, 'HERNà NOTEBOOK LENOVO', 'Hernà notebook Lenovo IdeaPad Y700-15ISK / stav A / ÄtyÅ™jádrový Intel Core i7-6700HQ @ 2,6 GHz, Broadwell, PassMark - 8134 / 12 GB RAM DDR4 / 128 GB SSD M.2 +1000 GB HDD / Windows 10 Home CZ / HDMI / USB 3.0 / 15.6\" LED 1920 x 1080 / NVIDIA GeForce GTX 96\r\n', 12, 24),
137(6, 'SAMSUNG Galaxy S10', 'EU Distribution / Display 6.1 \"3040 x 1440 / Internal Memory 128GB / 16 + 12 + 12MP Camera / Bluetooth Function, Wi-Fi / Battery Capacity 3400 mAh / Android Operating System / Black', 12, 26),
138(7, 'Apple iPhone XR', '6.1 \"Liquid Retina Smartphone • 1792 × 828 px • Apple A12 6-core Bionic Processor • 64GB Internal Memory • 12Mpx Rear Camera • 7Mpx Front Camera • GPS / GLONASS / Galileo / QZSS • Wi-Fi ac • 4G LTE • Bluetooth 5.0 • NFC • Increased resistance to dust and water IP67 • Face Detection Face ID • iOS Operating System', 12, 26),
139(8, 'ONEPLUS 6T', '6.4 \"Display 2340x1080 / 8-Core Processor 2.8GHz / 8GB RAM / 128B / 16MPx Internal Memory / Camera / Bluetooth, WiFi, Bluetooth, NFC EDGE, LTE / 3700mAh Battery / Android / Black', 12, 26),
140(9, 'GOOGLE Pixel 3', 'EU Distribution / Display 5.5 \"/ 8-Core Processor 2.5GHz / 4GB RAM / 64GB / 12MP Internal Memory / Camera, Bluetooth, GPS, Wi-Fi / 2915 mAh Battery / Android / Black', 12, 26),
141(10, 'LG G7 ThinQ', '6.1 \"/ 2 × 16 Mpix foto; Qualcomm Snapdragon 845; AI CAM, Super Bright Camera; 4GB RAM / 64GB Memory', 12, 26),
142(11, 'RAP HOODIE', 'RAP Hoodie Black / White\r\nComposition: 80% cotton 20% polyester', 14, 27),
143(12, 'TEE LOGO FLAG - Pajama Top', 'MATERIAL AND MAINTENANCE\r\n\r\nUpper fabric : 100% cotton\r\n\r\nMaterial Design : Jersey\r\n\r\nCare instructions : Machine wash at 40 ° C, Machine wash for fine cycle', 14, 27),
144(13, 'Cotton Dresses', 'Round Neck Knee-Length Chiffon Cocktail Dress With Ruffle', 14, 44),
145(14, 'Lace dress', 'available in multipal colours', 14, 44),
146(15, 'Modern Times', 'This comedic masterpiece finds the iconic Little Tramp (Charlie Chaplin) employed at a state-of-the-art factory where the inescapable machinery completely overwhelms him, and where various mishaps keep getting him sent to prison.', 16, 28),
147(16, 'The Gold Rush', 'In this classic silent comedy, the Little Tramp (Charles Chaplin) heads north to join in the Klondike gold rush.', 16, 28),
148(17, 'Avengers: Endgame', 'Adrift in space with no food or water, Tony Stark sends a message to Pepper Potts as his oxygen supply starts to dwindle.', 16, 34),
149(18, 'Missing Link', 'Tired of living a solitary life in the Pacific Northwest, Mr Link, who is 8 feet tall and covered in fur,', 16, 34),
150(19, 'Side Glass', 'Side glass for Skoda Octavia', 18, 52),
151(20, 'Side Light', 'Side light for Ford Figo', 18, 52);
152
153-- --------------------------------------------------------
154
155--
156-- Table structure for table `subcategory`
157--
158
159CREATE TABLE `subcategory` (
160 `sub_cat_id` int(50) NOT NULL,
161 `sub_cat_name` varchar(50) COLLATE utf8_bin DEFAULT NULL
162) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
163
164--
165-- Dumping data for table `subcategory`
166--
167
168INSERT INTO `subcategory` (`sub_cat_id`, `sub_cat_name`) VALUES
169(24, 'Laptops'),
170(26, 'Mobiles'),
171(27, 'Men Fashion'),
172(28, 'old movies'),
173(34, 'new movies'),
174(44, 'Women Fashion'),
175(52, 'car parts'),
176(54, 'bike parts'),
177(56, 'indoor'),
178(58, 'outdoor');
179
180-- --------------------------------------------------------
181
182--
183-- Table structure for table `user`
184--
185
186CREATE TABLE `user` (
187 `user_id` int(50) NOT NULL,
188 `user_name` varchar(50) COLLATE utf8_bin DEFAULT NULL,
189 `user_email` varchar(100) COLLATE utf8_bin DEFAULT NULL,
190 `user_phone` varchar(100) COLLATE utf8_bin DEFAULT NULL
191) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
192
193--
194-- Dumping data for table `user`
195--
196
197INSERT INTO `user` (`user_id`, `user_name`, `user_email`, `user_phone`) VALUES
198(1077, 'mihir', 'smartm13@mihir.com', '9409540077'),
199(1078, 'parth', 'parth@parth.com', '9409540074'),
200(4581, 'mehul', 'mehul@mehul.com', '9429350095'),
201(5899, 'gaurang', 'gaurang@gaurang.com', '9033664581'),
202(8490, 'sagar', 'sagar@sagar.com', '8490806010');
203
204--
205-- Indexes for dumped tables
206--
207
208--
209-- Indexes for table `category`
210--
211ALTER TABLE `category`
212 ADD PRIMARY KEY (`category_id`);
213
214--
215-- Indexes for table `delivery`
216--
217ALTER TABLE `delivery`
218 ADD PRIMARY KEY (`delivery_id`);
219
220--
221-- Indexes for table `price`
222--
223ALTER TABLE `price`
224 ADD PRIMARY KEY (`price_id`);
225
226--
227-- Indexes for table `product`
228--
229ALTER TABLE `product`
230 ADD PRIMARY KEY (`product_id`);
231
232--
233-- Indexes for table `subcategory`
234--
235ALTER TABLE `subcategory`
236 ADD PRIMARY KEY (`sub_cat_id`);
237
238--
239-- Indexes for table `user`
240--
241ALTER TABLE `user`
242 ADD PRIMARY KEY (`user_id`);
243COMMIT;
244
245/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
246/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
247/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;