· 6 years ago · Nov 27, 2019, 04:42 AM
1-- phpMyAdmin SQL Dump
2-- version 4.9.1
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Nov 27, 2019 at 04:36 AM
7-- Server version: 10.3.16-MariaDB
8-- PHP Version: 7.3.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15--
16-- Database: `id10787229_lpa_ecomms`
17--
18CREATE DATABASE IF NOT EXISTS `id10787229_lpa_ecomms` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
19USE `id10787229_lpa_ecomms`;
20
21-- --------------------------------------------------------
22
23--
24-- Table structure for table `lpa_clients`
25--
26
27CREATE TABLE `lpa_clients` (
28 `lpa_client_ID` int(10) NOT NULL,
29 `lpa_client_firstname` varchar(50) NOT NULL,
30 `lpa_client_lastname` varchar(50) NOT NULL,
31 `lpa_client_address` varchar(250) NOT NULL,
32 `lpa_client_phone` varchar(30) NOT NULL,
33 `lpa_client_status` char(1) NOT NULL,
34 `lpa_client_Username` varchar(500) NOT NULL,
35 `lpa_client_Password` varchar(500) NOT NULL,
36 `lpa_client_email` varchar(500) NOT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39--
40-- Dumping data for table `lpa_clients`
41--
42
43INSERT INTO `lpa_clients` (`lpa_client_ID`, `lpa_client_firstname`, `lpa_client_lastname`, `lpa_client_address`, `lpa_client_phone`, `lpa_client_status`, `lpa_client_Username`, `lpa_client_Password`, `lpa_client_email`) VALUES
44(1, 'Juan Fernando', 'Osorio Salazar', '135 Bage Street', '0467345283', 'E', '', '', ''),
45(2, 'Carlos', 'Velasquez', 'Surfers Paradise', '0423457892', 'D', '', '', ''),
46(9, 'Ejan', 'Rajbhandari', 'zillmere', '543442404', 'a', 'Ejan123', 'Ejan123', ''),
47(10, 'Ejan', 'Rb', 'zillmere', '0426513779', 'a', '', '', ''),
48(11, 'Ejan', 'user', 'ewrwr', '47237287', 'a', 'admin', 'password\r\n', ''),
49(50, 'Ejan', 'rb', 'dgwe', '283782', 'a', 'hi', '12', ''),
50(51, 'Ejan', '', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'Ejan123', '71c752b8f438fad2d4a59cc0377fa209', 'Ejancool12gmail.com'),
51(52, 'Ejan', '', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'hi', 'c20ad4d76fe97759aa27a0c99bff6710', 'Ejancool12gmail.com'),
52(53, 'EJan', 'Rajbhandari', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'user', '5f4dcc3b5aa765d61d8327deb882cf99', 'Ejancool12gmail.com'),
53(54, 'ram', '', '19 riverview terrace', '0426513999', 'A', 'Ejan', '5dc43a157403ca98c96f70d302986b73', 'Ejancool1222gmail.com'),
54(55, 'Hari', '', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'hi', 'c20ad4d76fe97759aa27a0c99bff6710', 'Ejancool12gmail.com'),
55(56, 'Ejan', '', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'hihi', 'e9f5713dec55d727bb35392cec6190ce', 'Ejancool1222gmail.com'),
56(57, 'ronish', '', 'biratnagar', '985561561212', 'A', 'Ronish', '83bb954275029d2a7849fb24e549643f', 'ronish@gmail.com'),
57(58, 'hari', '', 'nepal', '0426513999', 'A', 'hari', 'c20ad4d76fe97759aa27a0c99bff6710', 'rewanta@gmail.com'),
58(59, 'hari', 'Rajbhandari', 'nepal', '0426513999', 'A', 'hari', 'c20ad4d76fe97759aa27a0c99bff6710', 'rewanta@gmail.com'),
59(60, 'hari', 'Rajbhandari', 'nepal', '0426513999', 'A', 'hari', 'c20ad4d76fe97759aa27a0c99bff6710', 'rewanta@gmail.com'),
60(61, 'Ejan', 'Rajbhandari', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'admin', 'c20ad4d76fe97759aa27a0c99bff6710', 'Ejancool12gmail.com'),
61(62, 'Ejan', 'Rajbhandari', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'admin', 'c20ad4d76fe97759aa27a0c99bff6710', 'Ejancool12gmail.com'),
62(63, 'Ejan', 'Rajbhandari', '60 Hirschfield street, Zillmere', '0426513999', 'A', 'admin', 'c20ad4d76fe97759aa27a0c99bff6710', 'Ejancool12gmail.com'),
63(64, 'Rewanta', 'dahal', '19 Riverview terrace', '0426513779', 'A', 'Rewanta', 'c20ad4d76fe97759aa27a0c99bff6710', 'Rewanta@gmail.com'),
64(65, 'Ejan', 'Rajbhandari', '19 Riverview terrace', '0426513779', 'A', 'test', '$2y$10$sNn3Y6g6miKu8Wmixef9kebWXrPZOaua4nywd4btT2zWn9eABIgXe', 'Ejancool12@gmail.com'),
65(66, 'Ejan', 'Rajbhandari', '19 Riverview terrace', '0426513779', 'A', 'test', '$2y$10$VLH6V1KQWJUFkGGymgHkZuqbYC1/vAYkAb.biV5j0YCk9as3blh2m', 'Ejancool12@gmail.com');
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `lpa_invoices`
71--
72
73CREATE TABLE `lpa_invoices` (
74 `lpa_inv_no` int(10) NOT NULL,
75 `lpa_inv_date` datetime NOT NULL DEFAULT current_timestamp(),
76 `lpa_inv_client_ID` varchar(20) DEFAULT NULL,
77 `lpa_inv_client_name` varchar(50) NOT NULL,
78 `lpa_inv_client_address` varchar(250) NOT NULL,
79 `lpa_inv_amount` decimal(8,2) NOT NULL,
80 `lpa_inv_status` char(1) NOT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82
83--
84-- Dumping data for table `lpa_invoices`
85--
86
87INSERT INTO `lpa_invoices` (`lpa_inv_no`, `lpa_inv_date`, `lpa_inv_client_ID`, `lpa_inv_client_name`, `lpa_inv_client_address`, `lpa_inv_amount`, `lpa_inv_status`) VALUES
88(96, '2019-09-22 15:02:43', '1', 'Juan Fernando', 'rthr5h5h', 3000.00, 'a'),
89(97, '2019-09-22 15:11:40', '53', 'EJan', '60 Hirschfield street, Zillmere', 3250.00, 'a'),
90(98, '2019-09-22 15:11:50', '53', 'EJan', '60 Hirschfield street, Zillmere', 3250.00, 'a'),
91(99, '2019-09-22 15:19:54', '53', 'EJan', '60 Hirschfield street, Zillmere', 674.00, 'a'),
92(100, '2019-09-22 15:20:24', '1', 'Juan Fernando', 'rthr5h5h', 1750.00, 'a'),
93(101, '2019-10-03 02:41:44', '64', 'Rewanta', '19 Riverview terrace', 1783.00, 'a'),
94(102, '2019-11-02 00:45:22', '1', 'Juan Fernando', 'rthr5h5h', 1533.00, 'a'),
95(103, '2019-11-02 00:45:41', '1', 'Juan Fernando', 'rthr5h5h', 1533.00, 'a'),
96(104, '2019-11-05 01:50:47', '53', 'EJan', '60 Hirschfield street, Zillmere', 1500.00, 'a');
97
98-- --------------------------------------------------------
99
100--
101-- Table structure for table `lpa_invoice_items`
102--
103
104CREATE TABLE `lpa_invoice_items` (
105 `lpa_invitem_no` int(20) NOT NULL,
106 `lpa_invitem_inv_no` varchar(20) DEFAULT NULL,
107 `lpa_invitem_stock_ID` varchar(20) NOT NULL,
108 `lpa_invitem_stock_name` varchar(250) NOT NULL,
109 `lpa_invitem_qty` varchar(6) NOT NULL,
110 `lpa_invitem_stock_price` decimal(7,2) NOT NULL,
111 `lpa_invitem_stock_amount` decimal(7,2) NOT NULL,
112 `lpa_inv_status` char(1) NOT NULL
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114
115--
116-- Dumping data for table `lpa_invoice_items`
117--
118
119INSERT INTO `lpa_invoice_items` (`lpa_invitem_no`, `lpa_invitem_inv_no`, `lpa_invitem_stock_ID`, `lpa_invitem_stock_name`, `lpa_invitem_qty`, `lpa_invitem_stock_price`, `lpa_invitem_stock_amount`, `lpa_inv_status`) VALUES
120(1, NULL, '123', 'Computer', '4', 1500.00, 1.00, 'a'),
121(2, NULL, '138', 'duke', '10', 100.00, 1.00, 'a'),
122(3, NULL, '123', 'Computer', '4', 1500.00, 1.00, 'a'),
123(4, NULL, '123', 'Computer', '4', 1500.00, 1.00, 'a'),
124(9, NULL, '125', 'Mini Display Port to VGA', '1', 33.00, 33.00, 'a'),
125(10, NULL, '127', 'USB2.0 To Ethernet Adapter', '1', 9.00, 42.00, 'a'),
126(11, NULL, '125', 'Mini Display Port to VGA', '1', 33.00, 33.00, 'a'),
127(12, NULL, '127', 'USB2.0 To Ethernet Adapter', '1', 9.00, 42.00, 'a'),
128(13, '66', '124', 'Apple iPad 4', '1', 250.00, 1750.00, 'a'),
129(14, '67', '123', 'Computer', '1', 1500.00, 3250.00, 'a'),
130(15, '67', '124', 'Apple iPad 4', '1', 250.00, 3500.00, 'a'),
131(16, '68', '123', 'Computer', '1', 1500.00, 3250.00, 'a'),
132(17, '68', '124', 'Apple iPad 4', '1', 250.00, 3500.00, 'a'),
133(18, '70', '123', 'Computer', '1', 1500.00, 3500.00, 'a'),
134(19, '70', '124', 'Apple iPad 4', '2', 250.00, 4000.00, 'a'),
135(20, '71', '123', 'Computer', '1', 1500.00, 3500.00, 'a'),
136(21, '71', '124', 'Apple iPad 4', '2', 250.00, 4000.00, 'a'),
137(22, '72', '123', 'Computer', '2', 1500.00, 5000.00, 'a'),
138(23, '72', '124', 'Apple iPad 4', '2', 250.00, 5500.00, 'a'),
139(24, '73', '123', 'Computer', '2', 1500.00, 5000.00, 'a'),
140(25, '73', '124', 'Apple iPad 4', '2', 250.00, 5500.00, 'a'),
141(26, '74', '123', 'Computer', '2', 1500.00, 5000.00, 'a'),
142(27, '74', '124', 'Apple iPad 4', '2', 250.00, 5500.00, 'a'),
143(28, '75', '123', 'Computer', '2', 1500.00, 5000.00, 'a'),
144(29, '75', '124', 'Apple iPad 4', '2', 250.00, 5500.00, 'a'),
145(30, '76', '123', 'Computer', '2', 1500.00, 5000.00, 'a'),
146(31, '76', '124', 'Apple iPad 4', '2', 250.00, 5500.00, 'a'),
147(32, '77', '123', 'Computer', '2', 1500.00, 5000.00, 'a'),
148(33, '77', '124', 'Apple iPad 4', '2', 250.00, 5500.00, 'a'),
149(34, '78', '123', 'Computer', '1', 1500.00, 3250.00, 'a'),
150(35, '78', '124', 'Apple iPad 4', '1', 250.00, 3500.00, 'a'),
151(36, '79', '123', 'Computer', '1', 1500.00, 3250.00, 'a'),
152(37, '79', '124', 'Apple iPad 4', '1', 250.00, 3500.00, 'a'),
153(38, '80', '123', 'Computer', '1', 1500.00, 3250.00, 'a'),
154(39, '80', '124', 'Apple iPad 4', '1', 250.00, 3500.00, 'a'),
155(40, '81', '123', 'Computer', '1', 1500.00, 6009.00, 'a'),
156(41, '81', '127', 'USB2.0 To Ethernet Adapter', '1', 9.00, 6018.00, 'a'),
157(42, '82', '124', 'Apple iPad 4', '1', 250.00, 500.00, 'a'),
158(43, '83', '123', 'Computer', '1', 1500.00, 3022.00, 'a'),
159(44, '83', '128', 'Computer Monitor', '1', 22.00, 3044.00, 'a'),
160(45, '84', '123', 'Computer', '1', 1500.00, 3022.00, 'a'),
161(46, '84', '128', 'Computer Monitor', '1', 22.00, 3044.00, 'a'),
162(47, '85', '124', 'Apple iPad 4', '1', 250.00, 600.00, 'a'),
163(48, '85', '145', 'index image', '1', 100.00, 700.00, 'a'),
164(49, '86', '124', 'Apple iPad 4', '2', 250.00, 1000.00, 'a'),
165(50, '87', '124', 'Apple iPad 4', '2', 250.00, 1000.00, 'a'),
166(51, '88', '124', 'Apple iPad 4', '1', 250.00, 600.00, 'a'),
167(52, '88', '138', 'duke', '1', 100.00, 700.00, 'a'),
168(53, '89', '124', 'Apple iPad 4', '1', 250.00, 600.00, 'a'),
169(54, '89', '138', 'duke', '1', 100.00, 700.00, 'a'),
170(55, '90', '123', 'Computer', '1', 1500.00, 3000.00, 'a'),
171(56, '91', '123', 'Computer', '1', 1500.00, 3000.00, 'a'),
172(57, '92', '123', 'Computer', '1', 1500.00, 3000.00, 'a'),
173(58, '0', '123', 'Computer', '2', 1500.00, 6000.00, 'a'),
174(59, '94', '123', 'Computer', '2', 1500.00, 6000.00, 'a'),
175(60, '95', '123', 'Computer', '2', 1500.00, 6000.00, 'a'),
176(61, '96', '123', 'Computer', '2', 1500.00, 6000.00, 'a'),
177(62, '97', '123', 'Computer', '1', 1500.00, 4750.00, 'a'),
178(63, '97', '124', 'Apple iPad 4', '1', 250.00, 5000.00, 'a'),
179(64, '98', '123', 'Computer', '1', 1500.00, 4750.00, 'a'),
180(65, '98', '124', 'Apple iPad 4', '1', 250.00, 5000.00, 'a'),
181(66, '99', '124', 'Apple iPad 4', '1', 250.00, 924.00, 'a'),
182(67, '99', '126', ' StLab U-470 USB 2.0 to VGA Adapter ', '1', 424.00, 1348.00, 'a'),
183(68, '100', '123', 'Computer', '1', 1500.00, 3250.00, 'a'),
184(69, '100', '124', 'Apple iPad 4', '1', 250.00, 3500.00, 'a'),
185(70, '101', '123', 'Computer', '1', 1500.00, 3283.00, 'a'),
186(71, '101', '124', 'Apple iPad 4', '1', 250.00, 3533.00, 'a'),
187(72, '101', '125', 'Mini Display Port to VGA', '1', 33.00, 3566.00, 'a'),
188(73, '102', '123', 'Computer', '1', 1500.00, 3033.00, 'a'),
189(74, '102', '125', 'Mini Display Port to VGA', '1', 33.00, 3066.00, 'a'),
190(75, '103', '123', 'Computer', '1', 1500.00, 3033.00, 'a'),
191(76, '103', '125', 'Mini Display Port to VGA', '1', 33.00, 3066.00, 'a'),
192(77, '104', '123', 'Computer', '1', 1500.00, 3000.00, 'a');
193
194-- --------------------------------------------------------
195
196--
197-- Table structure for table `lpa_stock`
198--
199
200CREATE TABLE `lpa_stock` (
201 `lpa_stock_ID` int(10) NOT NULL,
202 `lpa_stock_name` varchar(250) NOT NULL,
203 `lpa_stock_desc` varchar(500) NOT NULL,
204 `lpa_stock_onhand` varchar(5) NOT NULL,
205 `lpa_stock_price` int(250) NOT NULL,
206 `lpa_image` varchar(255) DEFAULT NULL,
207 `lpa_stock_status` char(1) DEFAULT NULL
208) ENGINE=InnoDB DEFAULT CHARSET=latin1;
209
210--
211-- Dumping data for table `lpa_stock`
212--
213
214INSERT INTO `lpa_stock` (`lpa_stock_ID`, `lpa_stock_name`, `lpa_stock_desc`, `lpa_stock_onhand`, `lpa_stock_price`, `lpa_image`, `lpa_stock_status`) VALUES
215(123, 'Computer', 'Computer system', '4', 1500, 'Computer.png', 'a'),
216(124, 'Apple iPad 4', 'This is an apple iPad 4', '4', 250, 'iPad.png', 'D'),
217(125, 'Mini Display Port to VGA', 'Cable for Apple', '3', 33, 'VGA.png', 'a'),
218(126, ' StLab U-470 USB 2.0 to VGA Adapter ', ' VGA Adapter ', ' 555', 424, 'VGA adapter.png', 'a'),
219(127, 'USB2.0 To Ethernet Adapter', 'Cable ', '5', 9, 'Ethernet Adapter.png', 'a'),
220(128, 'Computer Monitor', 'LCD screen', '4', 22, 'Monitor.png', 'a'),
221(135, 'keyboard', 'gamming', '10', 100, 'keyboard.png', '1'),
222(136, 'momo', 'Good', '10', 100, 'keyboard.png', '1'),
223(137, 'momo', 'Good', '10', 100, 'bikesh.png', '1'),
224(138, 'duke', 'Good', '10', 100, 'bikesh.png', '1'),
225(139, 'momo', 'Good', '20', 100, 'keyboard.png', '1'),
226(140, 'momo', 'Good', '10', 100, 'keyboard.png', '1'),
227(141, ' StLab U-470 USB 2.0 to VGA Adapter ', ' VGA Adapter ', ' 5 ', 424545, 'defult.png', '1'),
228(142, 'Car', 'TOOO fast', '10', 1000000, 'car.png', '1'),
229(143, 'dilip', 'playboy', '1', 1000000000, 'dilip.png', '1'),
230(144, 'sajan', 'playboy', '1', 100, '64845347_781741492227184_6398782100241121280_n.jpg', '1'),
231(145, 'index image', 'Good', '1', 100, 'parts.jpg', '1'),
232(146, 'test', 'for test', '1', 1, '2018-06-04.png', '1'),
233(147, 'test', 'for test', '1', 1, '2018-06-04.png', '1'),
234(148, 'test', 'for test', '1', 1, '2018-06-04.png', '1'),
235(149, 'Try', 'Test item', '1', 100, '2018-09-01.png', '1'),
236(150, 'bag', 'bag', '1', 100, '2018-06-17.png', '1');
237
238-- --------------------------------------------------------
239
240--
241-- Table structure for table `lpa_users`
242--
243
244CREATE TABLE `lpa_users` (
245 `lpa_user_ID` int(10) NOT NULL,
246 `lpa_user_username` varchar(30) NOT NULL,
247 `lpa_user_password` varchar(50) NOT NULL,
248 `lpa_user_firstname` varchar(50) NOT NULL,
249 `lpa_user_lastname` varchar(50) NOT NULL,
250 `lpa_user_status` char(1) DEFAULT NULL,
251 `lpa_address` varchar(500) NOT NULL,
252 `lpa_phonenumber` int(15) NOT NULL,
253 `lpa_Email` varchar(50) NOT NULL
254) ENGINE=InnoDB DEFAULT CHARSET=latin1;
255
256--
257-- Dumping data for table `lpa_users`
258--
259
260INSERT INTO `lpa_users` (`lpa_user_ID`, `lpa_user_username`, `lpa_user_password`, `lpa_user_firstname`, `lpa_user_lastname`, `lpa_user_status`, `lpa_address`, `lpa_phonenumber`, `lpa_Email`) VALUES
261(1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Juan Fernando', 'Osorio S', '1', 'rthr5h5h', 654165161, ''),
262(2, 'user', '12345', 'Oscar Mauricio', 'Salazar Ospina', '1', '', 0, ''),
263(16, 'Ejan007', '8a7d7ba288ca0f0ea1ecf975b026e8e1', 'Ejan', 'RB', NULL, '60 Hirschfield street, Zillmere', 426513779, 'ejancool12@gmail.com'),
264(17, 'Ejan', '5dc43a157403ca98c96f70d302986b73', 'Ejan', '', NULL, '60 Hirschfield street, Zillmere', 426513779, 'ejancool12@gmail.com');
265
266--
267-- Indexes for dumped tables
268--
269
270--
271-- Indexes for table `lpa_clients`
272--
273ALTER TABLE `lpa_clients`
274 ADD PRIMARY KEY (`lpa_client_ID`);
275
276--
277-- Indexes for table `lpa_invoices`
278--
279ALTER TABLE `lpa_invoices`
280 ADD PRIMARY KEY (`lpa_inv_no`);
281
282--
283-- Indexes for table `lpa_invoice_items`
284--
285ALTER TABLE `lpa_invoice_items`
286 ADD PRIMARY KEY (`lpa_invitem_no`);
287
288--
289-- Indexes for table `lpa_stock`
290--
291ALTER TABLE `lpa_stock`
292 ADD PRIMARY KEY (`lpa_stock_ID`);
293
294--
295-- Indexes for table `lpa_users`
296--
297ALTER TABLE `lpa_users`
298 ADD PRIMARY KEY (`lpa_user_ID`);
299
300--
301-- AUTO_INCREMENT for dumped tables
302--
303
304--
305-- AUTO_INCREMENT for table `lpa_clients`
306--
307ALTER TABLE `lpa_clients`
308 MODIFY `lpa_client_ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
309
310--
311-- AUTO_INCREMENT for table `lpa_invoices`
312--
313ALTER TABLE `lpa_invoices`
314 MODIFY `lpa_inv_no` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105;
315
316--
317-- AUTO_INCREMENT for table `lpa_invoice_items`
318--
319ALTER TABLE `lpa_invoice_items`
320 MODIFY `lpa_invitem_no` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
321
322--
323-- AUTO_INCREMENT for table `lpa_stock`
324--
325ALTER TABLE `lpa_stock`
326 MODIFY `lpa_stock_ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;
327
328--
329-- AUTO_INCREMENT for table `lpa_users`
330--
331ALTER TABLE `lpa_users`
332 MODIFY `lpa_user_ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
333COMMIT;