-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathk-tech.sql
321 lines (267 loc) · 15.3 KB
/
k-tech.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 05, 2022 at 06:49 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `k-tech`
--
-- --------------------------------------------------------
--
-- Table structure for table `brand`
--
CREATE TABLE `brand` (
`id` int(10) UNSIGNED NOT NULL,
`title` text NOT NULL,
`image_name` text NOT NULL,
`featured` text NOT NULL,
`active` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `brand`
--
INSERT INTO `brand` (`id`, `title`, `image_name`, `featured`, `active`) VALUES
(16, 'Dell', 'brand_244.png', 'Yes', 'Yes'),
(17, 'Asus', 'brand_362.png', 'Yes', 'Yes'),
(18, 'MSI', 'brand_397.jpeg', 'Yes', 'Yes'),
(19, 'Hp', 'brand_582.png', 'No', 'Yes'),
(21, 'Apple', 'brand_822.jpg', 'Yes', 'Yes'),
(22, 'Lenovo', 'brand_158.jpg', 'Yes', 'Yes');
-- --------------------------------------------------------
--
-- Table structure for table `cart`
--
CREATE TABLE `cart` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) NOT NULL,
`productid` int(11) NOT NULL,
`qty` int(11) NOT NULL,
`subtotal` decimal(20,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
CREATE TABLE `category` (
`id` int(11) NOT NULL,
`title` text NOT NULL,
`featured` text NOT NULL,
`active` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `category`
--
INSERT INTO `category` (`id`, `title`, `featured`, `active`) VALUES
(1, 'Laptop', 'Yes', 'Yes'),
(2, 'Monitor', 'Yes', 'Yes'),
(10, 'Keyboad', 'Yes', 'Yes'),
(11, 'Desktop', 'Yes', 'Yes');
-- --------------------------------------------------------
--
-- Table structure for table `order1`
--
CREATE TABLE `order1` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) NOT NULL,
`productid` int(11) NOT NULL,
`qty` int(11) NOT NULL,
`date` date NOT NULL,
`subtotal` decimal(20,2) NOT NULL,
`status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `order1`
--
INSERT INTO `order1` (`id`, `userid`, `productid`, `qty`, `date`, `subtotal`, `status`) VALUES
(257, 42, 108, 1, '2022-10-22', '333.00', 'Delivered'),
(258, 42, 108, 27, '2022-10-22', '8991.00', 'Delivered'),
(259, 42, 114, 47, '2022-10-22', '15651.00', 'Cancelled'),
(260, 43, 121, 1, '2022-10-23', '199500.00', 'Ordered'),
(261, 43, 121, 6, '2022-10-24', '1197000.00', 'Ordered');
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE `product` (
`id` int(10) UNSIGNED NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
`warranty` text NOT NULL,
`brand` text NOT NULL,
`category` text NOT NULL,
`price` decimal(20,2) NOT NULL,
`stock` int(11) NOT NULL,
`sale` int(11) NOT NULL,
`image_name1` text NOT NULL,
`image_name2` text NOT NULL,
`image_name3` text NOT NULL,
`image_name4` text NOT NULL,
`image_name5` text NOT NULL,
`image_name6` text NOT NULL,
`image_name7` text NOT NULL,
`desname1` text NOT NULL,
`des1` text NOT NULL,
`desname2` text NOT NULL,
`des2` text NOT NULL,
`desname3` text NOT NULL,
`des3` text NOT NULL,
`desname4` text NOT NULL,
`des4` text NOT NULL,
`desname5` text NOT NULL,
`des5` text NOT NULL,
`desname6` text NOT NULL,
`des6` text NOT NULL,
`desname7` text NOT NULL,
`des7` text NOT NULL,
`desname8` text NOT NULL,
`des8` text NOT NULL,
`desname9` text NOT NULL,
`des9` text NOT NULL,
`desname10` text NOT NULL,
`des10` text NOT NULL,
`featured` text NOT NULL,
`active` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `product`
--
INSERT INTO `product` (`id`, `title`, `description`, `warranty`, `brand`, `category`, `price`, `stock`, `sale`, `image_name1`, `image_name2`, `image_name3`, `image_name4`, `image_name5`, `image_name6`, `image_name7`, `desname1`, `des1`, `desname2`, `des2`, `desname3`, `des3`, `desname4`, `des4`, `desname5`, `des5`, `desname6`, `des6`, `desname7`, `des7`, `desname8`, `des8`, `desname9`, `des9`, `desname10`, `des10`, `featured`, `active`) VALUES
(121, 'Asus M515DA – EJ1039T (R3)', '– AMD Ryzen 3 3250 Processor<br>\r\n– 8GB DDR4 RAM<br>\r\n– 128GB SSD NVMe + 1TB SATA Hard Drive<br>\r\n– AMD Radeon Graphics<br>\r\n– 15.6″ FHD Display<br>\r\n– Windows 10<br>', 'No Warranty', '17', '121', '199500.00', 0, 7, 'product_Name_7330.jpg', 'product_Name_6291.png', 'product_Name_8767.png', 'product_Name_9336.png', 'product_Name_956.jpg', 'product_Name_929.webp', 'product_Name_5523.jpg', 'Color', 'Slate Grey<br>\r\nTransparent Silver', 'Operating System', 'Windows 10 Home', 'Processor', 'AMD Ryzen™ 3 3250U Mobile Processor (2C/4T, 5MB Cache, 3.5 GHz Max Boost)', 'Graphics', 'AMD Radeon™ Graphics', 'Display', '15.6-inch, FHD (1920 x 1080) 16:9 aspect ratio, 200nits, NTSC color gamut for non-OLED, Anti-glare display', 'Memory', '4GB DDR4 onboard, Memory Max Up to:16GB', 'Storage', '1TB SATA 5400RPM 2.5″ HDD', 'Battery', '37WHrs, 2S1P, 2-cell Li-ion', 'Power Supply', 'ø4.0, 45W AC Adapter, Output: 19V DC, 2.37A, 45W, Input: 100~240V AC 50/60Hz universal', 'Weight', '1.80 kg (3.97 lbs)', 'Yes', 'Yes'),
(122, 'Asus Vivobook X513EA BQ1631W – i3', '– Intel Core i3-1115G4 Processor<br>\r\n– 4GB DDR4 RAM<br>\r\n– 512GB NVMe M.2 SSD<br>\r\n– Intel UHD Graphics<br>\r\n– 15.6″, FHD Display<br>\r\n– 42WHrs, 3S1P, 3-cell Li-ion Battery<br>\r\n– Bespoke Black Color<br>\r\n– Windows 11 Home<br>', 'No Warranty', '17', '122', '215000.00', 10, 0, 'product_Name_786.jpg', 'product_Name_9705.jpg', 'product_Name_3009.jpg', 'product_Name_1935.jpg', 'product_Name_8667.jpg', 'product_Name_3557.jpg', 'product_Name_2937.jpg', 'Processor', 'Intel Core i3-1115G4 Processor 3.0 GHz (6M Cache, up to 4.1 GHz, 2 cores)\r\n\r\n', 'Graphics', 'Intel UHD Graphics', 'Display', '15.6-inch, FHD (1920 x 1080) 16:9 aspect ratio, LED Backlit, 200nits, 45% NTSC color gamut for non-OLED, Anti-glare display, Screen-to-body ratio: 85 ％', 'Memory', '4GB DDR4 on board, Total system memory upgradeable to:12GB', 'Storage', '512GB M.2 NVMe PCIe 3.0 SSD', 'Expansion Slots (includes used)', '1x DDR4 SO-DIMM slot,\r\n1x M.2 2280 PCIe 3.0×2,\r\n1x STD 2.5” SATA HDD,', 'Keyboard & Touchpad', 'Backlit Chiclet Keyboard with Num-key, 1.4mm Key-travel, Touchpad', 'Camera', '720p HD camera', 'Battery', '42WHrs, 3S1P, 3-cell Li-ion', 'Operating System', 'Windows 11 Home', 'Yes', 'Yes'),
(124, 'Asus TUF Gaming F15 FX506HCB – HN169W', '– Intel Core i7 – 11800H Procesor<br>\r\n– 8GB DDR4 RAM<br>\r\n– 512GB M.2 NVMe SSD<br>\r\n– 15.6″ FHD, 144Hz Display<br>\r\n– Nvidia GeForce RTX 3050 Graphics<br>\r\n– Windows 11 Home', '2-Year.jpg', '17', '1', '524000.00', 17, 0, 'product_Name_3166.jpg', 'product_Name_5366.jpg', 'product_Name_2990.jpg', 'product_Name_1673.jpg', 'product_Name_6452.jpg', 'product_Name_280.jpg', 'product_Name_3193.jpg', 'Model', 'Asus TUF Gaming F15 FX506HCB – HN169W', 'Processor', 'Intel Core i7-11800H Processor 2.3 GHz (24M Cache, up to 4.6 GHz, 8 Cores)', 'RAM', '8GB DDR4-3200 SO-DIMM x 2,Max', 'Hard Drive', '512GB M.2 NVMe PCIe 3.0 SSD', 'Graphics', 'NVIDIA GeForce RTX 3050 Laptop GPU, Up to 1600MHz at 60W (75W with Dynamic Boost), 4GB GDDR6', 'Display', '15.6-inch, FHD (1920 x 1080) 16:9, anti-glare display, sRGB:62.5%, Adobe:47.34%, Refresh Rate:144Hz, Value IPS-level, Adaptive-Sync, Optimus', 'Camera', '720P HD camera', 'Battery', '48WHrs, 3S1P, 3-cell Li-ion', 'Operating System', 'Windows 11 Home', 'Weight', '2.30 Kg (5.07 lbs)', 'Yes', 'Yes'),
(125, 'Asus X515E', '– Intel Core i3-1115G4 Processor<br>\r\n– 256GB SSD Drive<br>\r\n– 4GB DDR4 Ram<br>\r\n– 15.6″ HD (1366×767) Display<br>\r\n– WebCam & Bluetooth<br>\r\n– Windows 10 Home<br>\r\n– Baklit Keyboard<br>\r\n– Silver Color<br>', '1-Year.jpg', '17', '1', '139000.00', 5, 0, 'product_Name_3902.jpg', 'product_Name_6030.jpg', 'product_Name_4533.jpg', 'product_Name_5257.jpg', 'product_Name_5180.png', 'product_Name_4871.webp', '', 'Color', 'Slate Grey', 'Operating System', 'Windows 10 Home', 'Processor', 'Intel Core™ i3-1115G4 Processor 3.0 GHz (6M Cache, up to 4.1 GHz, 2 cores)', 'Graphics', 'Intel UHD Graphics', 'Display', '15.6-inch,FHD (1920 x 1080) 16:9,Anti-glare display,LED Backlit,200nits,NTSC: 45%,Screen-to-body ratio: 83 ％', 'Memory', '4GB DDR4 on board,4GB DDR4 SO-DIMM,Memory Max Up to:16GB', 'Storage', '256GB M.2 NVMe™ PCIe® 3.0 SSD', 'Camera', 'VGA camera', 'Weight', '1.80 kg (3.97 lbs)', '', '', 'No', 'Yes'),
(126, 'MSI PRO DP130 Desktop', '– MSI Desktop Brand<br>\r\n– Intel IGD Graphics<br>\r\n– Intel H510 Chipset<br>\r\n– 8GB DDR4 2666MHz Memory<br>\r\n– 256GB M.2 SSD<br>\r\n– DOS<br>', 'No Warranty', '18', '11', '115000.00', 7, 0, 'product_Name_2583.jpg', 'product_Name_5803.jpg', 'product_Name_8085.jpg', 'product_Name_9220.jpg', 'product_Name_4882.png', 'product_Name_3531.png', 'product_Name_1382.png', 'Model', 'MSI PRO DP130 Desktop', 'CPU', 'Intel Pentium G6405', 'CHIPSET', 'Intel H510', 'GRAPHICS', 'Intel IGD', 'SYSTEM MEMORY', '8GB DDR4 2666MHz (2x DDR4 2666/ 3200MHz U-DIMMs, up to 64GB)', 'STORAGE', '256GB M.2 SSD', 'OPERATING SYSTEM', 'DOS', 'WEIGHT (N.W./ G.W.)', '5.43 kg ( 11.97 lbs ) / 7.42 ( 16.36 lbs )', '', '', '', '', 'Yes', 'Yes'),
(127, 'MSI Bravo 15 – B5DD Ryzen 5', '– AMD Ryzen 5 5600H Processor<br>\r\n– 512GB NVMe PCIe Gen3x4 SSD<br>\r\n– 8GB DDR4 (3200MHz) RAM<br>\r\n– 15.6″, FHD, 144Hz Display<br>\r\n– 4GB AMD Radeon RX 5500M Graphics<br>\r\n– 3 cell, 52Whr Battery Type<br>\r\n– Windows 10 Home<br>', '3-Year.jpg', '18', '1', '325000.00', 6, 0, 'product_Name_9783.jpg', 'product_Name_8707.jpg', 'product_Name_5383.jpg', 'product_Name_7117.jpg', 'product_Name_3976.jpg', 'product_Name_5277.jpg', 'product_Name_91.jpg', 'Model', 'MSI Bravo 15 B5DD', 'Processor', 'AMD (Cezanne H, Zen 3) Ryzen 5 5600H (4.40 GHz)', 'Graphic', 'AMD Radeon RX 5500M', 'Graphic Memory', 'GDDR6 4GB', 'Keyboard', 'Single backlight KB(Red)', 'Operating System', 'Windows 10 Home', 'Weight', '2.35kg', '', '', '', '', '', '', 'Yes', 'Yes'),
(128, 'MSI Pulse GL66 – 12UEK', '– Intel Core i7-12700H 11th Gen Processor<br>\r\n– 16GB DDR4 RAM<br>\r\n– 1TB NVMe SSD<br>\r\n– RTX 3060 6GB NVIDIA GeForce<br>\r\n– 15.6″ QHD, 165Hz, IPS-Level Display<br>\r\n– RGB Backlight Keyboard<br>\r\n– Windows 11 Home<br>', '2-Year.jpg', '18', '1', '735000.00', 12, 0, 'product_Name_1810.jpg', 'product_Name_8208.jpg', 'product_Name_3518.jpg', 'product_Name_2995.jpg', 'product_Name_4686.jpg', 'product_Name_5358.jpg', 'product_Name_4426.jpg', 'Model', 'MSI Pulse GL66 12UEK Gaming Laptop', 'Processor', 'Intel Core i7-12700H 11th Gen Processor', 'RAM', '16GB DDR4, 3200 MHz', 'Memory', '1TB M.2 SSD slot (NVMe PCIe Gen3)', 'Graphics', 'NVIDIA GeForce RTX 3060 Laptop GPU, 6GB GDDR6', 'Display', '15.6″ QHD (2560×1440), 165Hz, IPS-Level', 'Webcam', 'HD type (30fps@720p)', 'Weight (W/ BATTERY)', '2.3 kg', 'Operating system', 'Windows 11 Home', '', '', 'Yes', 'Yes'),
(129, 'MSI Katana GF66 – 12UC (i7)', '– Intel Core i7-12700H Processor<br>\r\n– 8GB DDR4 RAM<br>\r\n– 512GB NVMe SSD Memory<br>\r\n– RTX 3050 4GB NVIDIA GeForce<br>\r\n– 15.6″ FHD, 144Hz, IPS-Level Display<br>\r\n– Windows 11 Home<br>', 'No Warranty', '18', '1', '579000.00', 1, 0, 'product_Name_5625.jpg', 'product_Name_6894.jpg', 'product_Name_3593.jpg', 'product_Name_4417.jpg', 'product_Name_6955.jpg', 'product_Name_8420.jpg', '', 'Model', 'MSI KATANA GF66 12UC', 'Processor', 'Intel Core i7-12700H', 'RAM', '8GB DDR4, 3200 MHz', 'Memory', '512GB NVMe SSD', 'Graphics', 'NVIDIA GeForce RTX 3050 4GB', 'Display', '15.6″ FHD (1920×1080), 144Hz, IPS-Level', 'Webcam', 'HD type (30fps@720p)', 'Battery', '3-Cell,\r\n53.5 Battery (Whr)', 'Weight (W/ BATTERY)', '2.25 kg', 'Operating system', 'Windows 11 Home', 'Yes', 'Yes');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_admin`
--
CREATE TABLE `tbl_admin` (
`id` int(11) NOT NULL,
`full_name` text NOT NULL,
`username` text NOT NULL,
`password` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tbl_admin`
--
INSERT INTO `tbl_admin` (`id`, `full_name`, `username`, `password`) VALUES
(3, 'Krishantha', 'Krishantha', 'ec6a6536ca304edf844d1d248a4f08dc'),
(4, 'Krishantha', 'Krishantha', '69c2762642283930977950bfc5eab724');
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE `user` (
`id` int(10) UNSIGNED NOT NULL,
`first_name` text NOT NULL,
`last_name` text NOT NULL,
`username` text NOT NULL,
`image_name` text NOT NULL,
`password` text NOT NULL,
`company_name` text NOT NULL,
`country` text NOT NULL,
`house_number` text NOT NULL,
`apartment` text NOT NULL,
`twon` text NOT NULL,
`postcode` text NOT NULL,
`phone` text NOT NULL,
`email` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `user`
--
INSERT INTO `user` (`id`, `first_name`, `last_name`, `username`, `image_name`, `password`, `company_name`, `country`, `house_number`, `apartment`, `twon`, `postcode`, `phone`, `email`) VALUES
(48, '', '', 'Krishantha', '', 'b59c67bf196a4758191e42f76670ceba', '', '', '', '', '', '', '', '[email protected]');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `brand`
--
ALTER TABLE `brand`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `category`
--
ALTER TABLE `category`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `order1`
--
ALTER TABLE `order1`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `product`
--
ALTER TABLE `product`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user`
--
ALTER TABLE `user`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `brand`
--
ALTER TABLE `brand`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=260;
--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `order1`
--
ALTER TABLE `order1`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=262;
--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;
--
-- AUTO_INCREMENT for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;
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 */;