· 10 years ago · Dec 02, 2015, 09:36 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 02, 2015 at 10:31 AM
7-- Server version: 5.5.39
8-- PHP Version: 5.4.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `lms`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `appusers`
21--
22
23CREATE TABLE IF NOT EXISTS `appusers` (
24`id` int(11) NOT NULL,
25 `stname` varchar(225) NOT NULL,
26 `username` varchar(20) NOT NULL,
27 `password` varchar(35) NOT NULL,
28 `email` varchar(20) NOT NULL,
29 `mobile_no` varchar(20) NOT NULL,
30 `address` text,
31 `registration_date` date NOT NULL,
32 `roles` varchar(30) DEFAULT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
34
35--
36-- Dumping data for table `appusers`
37--
38
39INSERT INTO `appusers` (`id`, `stname`, `username`, `password`, `email`, `mobile_no`, `address`, `registration_date`, `roles`) VALUES
40
41(3, '', 'Mike ', 'd41d8cd98f00b204e9800998ecf8427e', '', '0801111112', '', '2015-05-02', NULL),
42(11, 'Hassan Ola', 'sas1', 'sas1', 'sas1@sas1.net', '07060450259', 'sas1sas1sas1', '2015-05-10', 'Clerk'),
43
44
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `calendar`
50--
51
52CREATE TABLE IF NOT EXISTS `calendar` (
53 `datefield` date NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `clients`
60--
61
62CREATE TABLE IF NOT EXISTS `clients` (
63 `id` varchar(20) NOT NULL,
64 `fullname` varchar(20) NOT NULL,
65 `c_address` varchar(60) DEFAULT NULL,
66 `contact_no` varchar(20) NOT NULL,
67 `email` varchar(60) NOT NULL,
68 `reg_date` date NOT NULL,
69 `sex` varchar(7) NOT NULL,
70 `dob` date NOT NULL,
71 `cust_type` varchar(25) NOT NULL
72) ENGINE=InnoDB DEFAULT CHARSET=utf8;
73
74--
75-- Dumping data for table `clients`
76--
77
78INSERT INTO `clients` (`id`, `fullname`, `c_address`, `contact_no`, `email`, `reg_date`, `sex`, `dob`, `cust_type`) VALUES
79('NL093278', 'Ordinary Price', 'Ilorin', '07060450259', 'prince@prince.com', '2015-05-06', 'Male', '2010-06-26', 'Bronze'),
80('NL129116', 'Hassan Lai', '1222', '070604502592', 'ww@haha2.coc', '2015-05-10', 'Male', '2015-05-26', 'Bronze'),
81('NL152301', 'Ibrahim Subair', 'Lagos', '08159093636', 'ibr@gmail.com', '2015-05-13', 'Male', '2015-05-18', 'Bronze'),
82('NL162684', 'Kikelomo Ambibola', '39 Oladokun Morogbo', '08105331490', 'kiks@yahoo.co.uk', '2015-05-15', 'Female', '1990-12-01', 'Bronze'),
83('NL169217', 'Bod Bay', '36, Agbejo Street Ikeja', '08188977111', 'bodyjayi@gmail.com', '2015-05-14', 'Male', '1988-12-12', 'Bronze'),
84('NL492352', 'Alibaba Segun', '32 Sabal Palm Avenue', '08133180349', 'topebose69@yahoo.com', '2015-10-16', 'Female', '2015-10-20', 'Silver'),
85('NL504806', 'Olaoge BobShege', 'NSCDC', '07063730550', 'victoverry@yahoo.com', '2015-10-16', 'Male', '1981-10-16', 'Diamond'),
86
87
88-- --------------------------------------------------------
89
90--
91-- Table structure for table `clothes`
92--
93
94CREATE TABLE IF NOT EXISTS `clothes` (
95`id` int(11) NOT NULL,
96 `category_id` int(11) NOT NULL,
97 `name` varchar(60) NOT NULL,
98 `laundry_rate` double NOT NULL,
99 `dryclean_rate` double NOT NULL,
100 `ironing_rate` double NOT NULL
101) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=95 ;
102
103--
104-- Dumping data for table `clothes`
105--
106
107INSERT INTO `clothes` (`id`, `category_id`, `name`, `laundry_rate`, `dryclean_rate`, `ironing_rate`) VALUES
108(1, 2, 'Skirt/Trouser', 1300, 1400, 700),
109(2, 2, 'Skirt/TrouserSuit3', 1500, 1600, 800),
110(3, 2, 'Dress-Suits', 700, 800, 700),
111(4, 1, 'Trousers-Jeans', 400, 500, 250),
112(5, 1, 'Shirt', 500, 600, 300),
113(6, 2, 'T-Shirt', 300, 400, 200),
114(7, 1, 'Trousers -Silk/Linen', 500, 600, 300),
115(8, 1, 'Jackets-Silk/Linen', 900, 1000, 500),
116(9, 1, 'Waist-Coats', 400, 500, 200),
117(10, 1, 'Jackets-Leather', 1400, 1500, 750),
118(11, 1, 'Jackets-Jeans', 600, 700, 350),
119(12, 1, 'Long-Coats', 1400, 1500, 750),
120(13, 1, 'Safari/Without-Line', 1100, 1200, 600),
121(14, 1, 'Trousers', 500, 600, 250),
122(15, 1, 'Suit/Safari-2pcs', 1700, 1800, 900),
123(16, 1, 'Suit-3pcs', 1800, 2000, 1000),
124(17, 1, 'Shorts/Knickers', 300, 400, 200),
125(18, 1, 'SportsWear-CPLT', 1100, 1200, 600),
126(19, 1, 'Singlet', 200, 300, 150),
127(20, 1, 'Pyjamas', 400, 500, 250),
128(21, 1, 'Boxer/Short', 300, 400, 200),
129(22, 1, 'French/Military-Suit', 1500, 1600, 800),
130(23, 1, 'Lawyer/Graduatn-Robe', 1800, 2000, 1000),
131(24, 1, 'Canvas/Sport-Shoes', 500, 500, 250),
132(25, 1, 'Socks-Pair', 100, 100, 50),
133(26, 1, 'Caps/Hats', 700, 800, 250),
134(27, 1, 'Sweater', 500, 600, 300),
135(28, 1, 'Jalabiya', 500, 600, 300),
136(29, 1, 'Complete-National', 1800, 2000, 1000),
137(30, 1, 'Kaftan', 400, 500, 500),
138(31, 1, 'Kaftans-Silk/Senegal', 1000, 1200, 650),
139(32, 1, 'Buba/Sokoto', 500, 600, 450),
140(33, 1, 'Agbada-Only', 800, 1000, 500),
141(34, 2, 'Pleated-Skirt(Suit)', 1800, 2000, 1000),
142(35, 2, 'Dresses', 800, 900, 450),
143(36, 2, 'Trouser', 400, 500, 250),
144(37, 2, 'Camisole', 200, 300, 150),
145(38, 2, 'Shirt/Blouse', 300, 400, 500),
146(39, 2, 'Jacket', 800, 900, 500),
147(40, 2, 'Skirts(Short)', 400, 500, 250),
148(41, 2, 'Gown(Long/Short)', 800, 1000, 500),
149(42, 2, 'Evening-Gown(L/S)', 800, 1000, 500),
150(43, 2, 'Special-Lace', 1800, 2000, 1000),
151(45, 1, 'T-Shirts', 200, 400, 200),
152(46, 1, 'Ties', 300, 300, 150),
153(47, 2, 'Beaded/Sequins-Eveng', 1800, 2000, 1000),
154(48, 2, 'Waist-Coat', 300, 400, 200),
155(49, 2, 'Scarf-Small', 300, 400, 200),
156(50, 2, 'Head-Tie', 900, 1000, 525),
157(51, 2, 'Gele', 1400, 1500, 200),
158(52, 2, 'Knickers/Shorts', 300, 400, 200),
159(53, 2, 'Wedding-Gown(Small)', 7500, 8000, 4000),
160(54, 2, 'Wedding-Gown(Big)', 9000, 10000, 5000),
161(55, 2, 'India-Saree(Complete)', 1800, 2000, 1000),
162(56, 2, 'India-Saree(Half)', 1100, 1200, 600),
163(57, 2, 'Kaftaan', 800, 900, 450),
164(58, 2, 'Wrapper/Buba/Headtie', 900, 1050, 525),
165(59, 2, 'Buba', 800, 900, 450),
166(60, 2, 'Pant', 300, 400, 200),
167(61, 2, 'Skirt/Blouse', 900, 1000, 500),
168(62, 2, 'National-Blouse', 500, 600, 300),
169(63, 3, 'Bed-sheet', 600, 700, 350),
170(64, 3, 'Blanket(Single-Bed)', 1300, 1500, 750),
171(65, 3, 'Blanket(Double-Bed)', 1800, 2000, 1000),
172(66, 3, 'Mattress-Cover(Single)', 900, 1000, 500),
173(67, 3, 'Mattress-Cover(Double)', 1100, 1200, 600),
174(68, 3, 'Flat/Fitted-Sht(Single)', 900, 1000, 500),
175(69, 3, 'Flat/Fitted-Sheet(Double)', 1400, 1500, 750),
176(70, 3, 'Sheet-With-Skirting(Single)', 900, 1000, 500),
177(71, 3, 'Sheet-With-Skirting(Double)', 1400, 1500, 750),
178(72, 3, 'Duvet(Single-Bed)', 1000, 1200, 600),
179(73, 3, 'Duvet(Double-Bed)', 1300, 1500, 750),
180(74, 3, 'Duvet-Cover(Single-Bed)', 900, 1000, 500),
181(75, 3, 'Duvet-Cover(Double-Bed)', 900, 1000, 500),
182(76, 3, 'Quilt(Single-Bed)', 900, 1000, 500),
183(77, 3, 'Quilt(Double-Bed)', 1300, 1500, 750),
184(78, 3, 'Pillow', 900, 1000, 500),
185(79, 3, 'Throw/Collar-Pillow', 1200, 1300, 650),
186(80, 3, 'Pillow-Case', 100, 200, 100),
187(81, 3, 'Throw/Collar-Pillow-Cover', 200, 400, 650),
188(82, 3, 'Face-Towels', 50, 100, 50),
189(83, 3, 'Hand-Towels', 100, 200, 100),
190(84, 3, 'Bath-Towels', 300, 400, 200),
191(85, 3, 'Bath Towels (Large)', 325, 650, 300),
192(86, 3, 'Bath-Towels(X-Large)', 1300, 1500, 750),
193(87, 3, 'Bathroom-Floor(Rugs)', 1800, 2000, 1000),
194(88, 3, 'Bath-Robes', 500, 600, 300),
195(89, 3, 'Curtains-(Small Singles)', 700, 800, 400),
196(90, 3, 'Curtains-(Big Doubles)', 1100, 1200, 600),
197(91, 3, 'Foot-Mats', 300, 400, 200),
198(92, 3, 'Linen', 300, 400, 200),
199(93, 3, 'Table-Covers-(Cotton)-SM', 700, 800, 300),
200(94, 3, 'Table-Covers-(Cotton)-LG', 900, 1000, 400);
201
202-- --------------------------------------------------------
203
204--
205-- Table structure for table `job_order`
206--
207
208CREATE TABLE IF NOT EXISTS `job_order` (
209 `id` varchar(20) NOT NULL,
210 `user_id` int(11) NOT NULL,
211 `client_id` varchar(12) NOT NULL,
212 `submission_date` date NOT NULL,
213 `expected_delivery_date` date NOT NULL,
214 `total_quantity` int(11) NOT NULL,
215 `amount` double NOT NULL,
216 `delivery_status` int(11) NOT NULL,
217 `amt_paid` int(6) DEFAULT '0',
218 `amt_due` int(6) NOT NULL,
219 `fullname` varchar(20) NOT NULL,
220 `discount` int(11) NOT NULL
221) ENGINE=InnoDB DEFAULT CHARSET=utf8;
222
223--
224-- Dumping data for table `job_order`
225--
226
227INSERT INTO `job_order` (`id`, `user_id`, `client_id`, `submission_date`, `expected_delivery_date`, `total_quantity`, `amount`, `delivery_status`, `amt_paid`, `amt_due`, `fullname`, `discount`) VALUES
228('', 13, 'NL169217', '2015-11-30', '2015-12-02', 3, 850, 0, 0, 0, '', 0),
229('565', 13, 'NL169217', '2015-11-30', '2015-12-02', 3, 850, 0, 0, 0, '', 0);
230
231-- --------------------------------------------------------
232
233--
234-- Table structure for table `order_details`
235--
236
237CREATE TABLE IF NOT EXISTS `order_details` (
238 `job_order_id` varchar(20) NOT NULL,
239 `cloth_name` varchar(20) NOT NULL,
240 `quantity` int(11) NOT NULL,
241 `amount` double NOT NULL,
242 `order_type` varchar(11) NOT NULL,
243 `submission_date` date NOT NULL
244) ENGINE=InnoDB DEFAULT CHARSET=utf8;
245
246--
247-- Dumping data for table `order_details`
248--
249
250INSERT INTO `order_details` (`job_order_id`, `cloth_name`, `quantity`, `amount`, `order_type`, `submission_date`) VALUES
251('0', 'Skirt/Trouser', 4, 2800, 'Dryclean', '2015-11-29'),
252('0', 'Skirt/Trouser', 3, 2100, 'Dryclean', '2015-11-29'),
253('0', 'Trousers-Jeans', 1, 250, 'Laundry', '2015-11-29'),
254('0', 'Jackets-Silk/Linen', 2, 1000, 'Dryclean', '2015-11-29'),
255('0', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-29'),
256('0', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-29'),
257('0', 'Trousers-Jeans', 3, 750, 'Dryclean', '2015-11-29'),
258('0', 'Trousers-Jeans', 1, 500, 'dryclean', '0000-00-00'),
259('565', 'Trousers-Jeans', 2, 500, 'Dryclean', '2015-11-29'),
260('565', 'Shirt', 4, 1200, 'Dryclean', '2015-11-29'),
261('565', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-29'),
262('565', 'Shirt', 2, 600, 'Dryclean', '2015-11-29'),
263('565', 'Trousers-Jeans', 2, 500, 'Dryclean', '2015-11-29'),
264('Array', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-30'),
265('Array', 'Shirt', 3, 900, 'Laundry', '2015-11-30'),
266('', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-30'),
267('', 'Shirt', 2, 600, 'Ironing', '2015-11-30'),
268('565c239d85f17', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-30'),
269('565c239d85f17', 'Shirt', 1, 300, 'Dryclean', '2015-11-30'),
270('565c23dfd1937', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-30'),
271('565c23dfd1937', 'Shirt', 1, 300, 'Dryclean', '2015-11-30'),
272('565c2549d1fe1', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-30'),
273('565c2549d1fe1', 'Shirt', 2, 600, 'Dryclean', '2015-11-30'),
274('', 'Trousers-Jeans', 1, 250, 'Dryclean', '2015-11-30'),
275('', 'Shirt', 2, 600, 'Dryclean', '2015-11-30');
276
277--
278-- Indexes for dumped tables
279--
280
281--
282-- Indexes for table `appusers`
283--
284ALTER TABLE `appusers`
285 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_UNIQUE` (`id`), ADD UNIQUE KEY `username_UNIQUE` (`username`), ADD UNIQUE KEY `email_UNIQUE` (`email`), ADD UNIQUE KEY `mobile_no_UNIQUE` (`mobile_no`);
286
287--
288-- Indexes for table `clients`
289--
290ALTER TABLE `clients`
291 ADD PRIMARY KEY (`id`);
292
293--
294-- Indexes for table `clothes`
295--
296ALTER TABLE `clothes`
297 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_UNIQUE` (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);
298
299--
300-- Indexes for table `job_order`
301--
302ALTER TABLE `job_order`
303 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_UNIQUE` (`id`), ADD KEY `userId_idx` (`user_id`), ADD KEY `client_id` (`client_id`), ADD KEY `client_id_2` (`client_id`);
304
305--
306-- Indexes for table `order_details`
307--
308ALTER TABLE `order_details`
309 ADD KEY `cloth_name` (`cloth_name`);
310
311--
312-- AUTO_INCREMENT for dumped tables
313--
314
315--
316-- AUTO_INCREMENT for table `appusers`
317--
318ALTER TABLE `appusers`
319MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
320--
321-- AUTO_INCREMENT for table `clothes`
322--
323ALTER TABLE `clothes`
324MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=95;