zBYUQaG0

1-- phpMyAdmin SQL Dump
2-- version 4.0.4
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Oct 07, 2015 at 03:23 AM
7-- Server version: 5.5.32
8-- PHP Version: 5.4.16
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 utf8 */;
18
19--
20-- Database: `db_project`
21--
22CREATE DATABASE IF NOT EXISTS `db_project` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `db_project`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `messages`
29--
30
31CREATE TABLE IF NOT EXISTS `messages` (
32  `message_id` int(11) NOT NULL AUTO_INCREMENT,
33  `name` varchar(40) NOT NULL,
34  `Email` varchar(30) NOT NULL,
35  `message` varchar(1000) NOT NULL,
36  PRIMARY KEY (`message_id`)
37) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `order_details`
43--
44
45CREATE TABLE IF NOT EXISTS `order_details` (
46  `id` int(11) NOT NULL AUTO_INCREMENT,
47  `memberID` int(11) NOT NULL,
48  `qty` int(5) NOT NULL,
49  `price` double(11,2) NOT NULL,
50  `productID` int(11) NOT NULL,
51  `total` double(11,2) NOT NULL,
52  `status` varchar(100) NOT NULL,
53  `modeofpayment` varchar(100) NOT NULL,
54  `orderdate` varchar(30) NOT NULL,
55  `location` varchar(2000) NOT NULL,
56  `orderid` varchar(50) NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=181 ;
59
60--
61-- Dumping data for table `order_details`
62--
63
64INSERT INTO `order_details` (`id`, `memberID`, `qty`, `price`, `productID`, `total`, `status`, `modeofpayment`, `orderdate`, `location`, `orderid`) VALUES
65(180, 34, 5, 1150.00, 21, 5750.00, 'Pending', '', 'Wednesday, October 07, 2015', '', '34_2015-10-07'),
66(179, 34, 198, 1222.00, 20, 241956.00, 'Pending', '', 'Wednesday, October 07, 2015', '', '34_2015-10-07'),
67(178, 40, 10, 1222.00, 20, 12220.00, 'Pending', '', 'Wednesday, October 07, 2015', 'batangas', '40_2015-10-07'),
68(177, 33, 9, 1222.00, 20, 10998.00, 'Pending', '', 'Saturday, October 24, 2015', 'asd', '33_2015-10-24'),
69(176, 33, 1001, 1222.00, 20, 1223222.00, 'Pending', '', 'Saturday, October 24, 2015', '', ''),
70(175, 33, 1, 93.08, 15, 93.08, 'Confirmed', 'Cash on Delivery', 'Saturday, October 24, 2015', 'asd', '33_2015-10-24'),
71(174, 33, 1, 241.77, 14, 241.77, 'Pending', '', 'Saturday, October 24, 2015', 'asd', '33_2015-10-24'),
72(173, 33, 1, 241.77, 14, 241.77, 'Pending', '', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06'),
73(171, 33, 1, 54.45, 16, 54.45, 'Pending', '', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06'),
74(170, 33, 1, 45.30, 13, 45.30, 'Confirmed', 'Cash on Delivery', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06'),
75(172, 33, 1, 93.08, 15, 93.08, 'Pending', '', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06'),
76(169, 33, 1, 93.08, 15, 93.08, 'Confirmed', 'Cash on Delivery', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06'),
77(168, 33, 1, 45.30, 13, 45.30, 'Confirmed', 'Cash on Delivery', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06'),
78(167, 33, 1, 241.77, 14, 241.77, 'Confirmed', 'Cash on Delivery', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06'),
79(166, 33, 1, 45.30, 13, 45.30, 'Confirmed', 'Cash on Delivery', 'Tuesday, October 06, 2015', 'Labak', '33_2015-10-06');
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `product_inventory`
85--
86
87CREATE TABLE IF NOT EXISTS `product_inventory` (
88  `id` int(11) NOT NULL AUTO_INCREMENT,
89  `product` int(11) NOT NULL,
90  `qty` int(11) NOT NULL,
91  `arrival` varchar(30) NOT NULL,
92  `departure` varchar(30) NOT NULL,
93  `status` varchar(30) NOT NULL,
94  `confirmation` varchar(30) NOT NULL,
95  PRIMARY KEY (`id`)
96) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
97
98--
99-- Dumping data for table `product_inventory`
100--
101
102INSERT INTO `product_inventory` (`id`, `product`, `qty`, `arrival`, `departure`, `status`, `confirmation`) VALUES
103(1, 11, 1, '26/12/2012', '27/12/2012', 'active', '720c36aa'),
104(2, 15, 1, '26/12/2012', '27/12/2012', 'active', '720c36aa'),
105(3, 15, 1, '17/12/2012', '19/12/2012', 'active', 'qie3thni'),
106(4, 12, 1, '17/12/2012', '19/12/2012', 'active', 'qie3thni'),
107(5, 18, 1, '17/12/2012', '19/12/2012', 'active', 'qie3thni'),
108(6, 16, 1, '30/06/2015', '03/07/2015', 'active', 'kxnzii0b'),
109(7, 14, 1, '30/06/2015', '03/07/2015', 'active', 'kxnzii0b'),
110(8, 11, 1, '', '', 'active', 'kdupfy48'),
111(9, 11, 1, '', '', 'active', 'pudgmce4'),
112(10, 11, 1, '', '08/07/2015', 'active', '83m3y2w5'),
113(11, 14, 1, '05/07/2015', '07/07/2015', 'active', 'eapmd7ep'),
114(12, 13, 1, '05/07/2015', '07/07/2015', 'active', 'eapmd7ep');
115
116-- --------------------------------------------------------
117
118--
119-- Table structure for table `tb_member`
120--
121
122CREATE TABLE IF NOT EXISTS `tb_member` (
123  `memberID` int(25) NOT NULL AUTO_INCREMENT,
124  `Firstname` varchar(25) NOT NULL,
125  `Lastname` varchar(25) NOT NULL,
126  `Email` varchar(25) NOT NULL,
127  `Password` varchar(25) NOT NULL,
128  `Contact_Number` varchar(25) NOT NULL,
129  `address` varchar(200) NOT NULL,
130  `status` varchar(50) NOT NULL,
131  PRIMARY KEY (`memberID`)
132) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
133
134--
135-- Dumping data for table `tb_member`
136--
137
138INSERT INTO `tb_member` (`memberID`, `Firstname`, `Lastname`, `Email`, `Password`, `Contact_Number`, `address`, `status`) VALUES
139(34, 'norylen', 'frane', 'norylenfrane@gmail.com', 'norylen', '09999999999', 'tulo', 'Confirmed'),
140(33, 'sam', 'ple', 'sample@yahoo.com', 'sampler12345', '0999999999', 'test', 'Confirmed'),
141(37, 'test', 'test', 'test@yahoo.com', 'test', '21345', 'test', 'Confirmed'),
142(38, 'paul', 'ilag', 'pol@wews.com', 'paolo', '9999', 'dagatan', 'Confirmed'),
143(39, 'asd', 'asd', 'annasd@gmail.com', 'asd', 'asd', 'asd', 'pending'),
144(40, 'paolo', 'ilag', 'paolo@yahoo.com', 'paolo', '00909090', 'dagatan', 'pending');
145
146-- --------------------------------------------------------
147
148--
149-- Table structure for table `tb_products`
150--
151
152CREATE TABLE IF NOT EXISTS `tb_products` (
153  `productID` int(11) NOT NULL AUTO_INCREMENT,
154  `name` varchar(500) NOT NULL,
155  `description` varchar(500) NOT NULL,
156  `category` varchar(200) NOT NULL,
157  `originated` varchar(500) NOT NULL,
158  `price` double(11,2) NOT NULL,
159  `quantity` int(11) NOT NULL,
160  `location` varchar(500) NOT NULL,
161  PRIMARY KEY (`productID`)
162) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=81 ;
163
164--
165-- Dumping data for table `tb_products`
166--
167
168INSERT INTO `tb_products` (`productID`, `name`, `description`, `category`, `originated`, `price`, `quantity`, `location`) VALUES
169(16, 'Pork Tocino 225 grams', 'Pork Tocino', 'PROCESS MEAT', 'LBPI', 54.45, 1000, 'upload/225g..jpg'),
170(13, 'Bologna 250grams', 'Bologna ', 'Process Meat', 'LBPI', 45.30, 1000, 'upload/IMG_20150410_134747.jpg'),
171(14, 'Pork Tocino 1kl', 'tocino', 'Process Meat', 'LBPI', 241.77, 100, 'upload/1k. tocino.jpg'),
172(15, 'Hotdog J4.5 500g', 'Hotdog 500 grams', 'PROCESS MEAT', 'LBPI', 93.08, 1000, 'upload/500g..jpg'),
173(17, 'Pork Tapa 225grams', 'Pork Tapa', 'Process Meat', 'LBPI', 57.90, 1000, 'upload/225g.jpg'),
174(18, 'Boneless Ham 1kl', 'Boneless Ham', 'PROCESS MEAT', 'LBPI', 300.00, 1000, 'upload/Boneless ham 1kl..jpg'),
175(20, 'Broiler Starter Mash', 'Broiler Starter Mash', 'FEEDS', 'LMPC', 1222.00, 1000, 'upload/broiler starter mash.jpg'),
176(21, 'Chick Grower Crumble', 'Chick Grower Crumble', 'FEEDS', 'LMPC', 1150.00, 1000, 'upload/cgrowercrumble.jpg'),
177(22, 'Chick Booster Premium', 'Chick Booster Premium', 'FEEDS', 'LMPC', 691.00, 1000, 'upload/chick booster premium.jpg'),
178(24, 'Chick Starter Mash', 'Chick Starter Mash', 'FEEDS', 'LMPC', 1203.00, 1000, 'upload/chick starter mash.jpg'),
179(26, 'Chicken Longanisa 250g', 'Chicken Longanisa 250g', 'PROCESS MEAT', 'LBPI', 48.18, 1000, 'upload/chicken long prem. 250g.jpg'),
180(27, 'Golden Corn Grits', 'Golden Corn Grits', 'FEEDS', 'LMPC', 637.00, 1000, 'upload/corn grits.jpg'),
181(28, 'BFCC Classsic', 'BFCC Classsic', 'FEEDS', 'LMPC', 506.00, 1000, 'upload/fc clasic.jpg'),
182(29, 'BFCC Special', 'BFCC Special', 'FEEDS', 'LMPC', 576.00, 100087, 'upload/fcspecial.jpg'),
183(30, 'BFCC Super Conditioner', 'BFCC Super Conditioner', 'FEEDS', 'LMPC', 686.00, 1000, 'upload/fcsuperconditional.jpg'),
184(31, 'Broiler Finisher Crumble', 'Broiler Finisher Crumble', 'FEEDS', 'LMPC', 1228.00, 1000, 'upload/finisher crumble.jpg'),
185(32, 'Broiler Finisher Mash', 'Broiler Finisher Mash', 'FEEDS', 'LMPC', 1197.00, 1000, 'upload/finisher smash.jpg'),
186(33, 'Golden Cracked Corn', 'Golden Cracked Corn', 'FEEDS', 'LMPC', 818.00, 1000, 'upload/golden crack corn.jpg'),
187(34, 'Hog Grower Mash', 'Hog Grower Mash', 'FEEDS', 'LMPC', 1085.00, 1000, 'upload/grower mash.jpg'),
188(42, 'Hog Grower Pellet', 'Hog Grower Pellet', 'FEEDS', 'LMPC', 1125.00, 1000, 'upload/hog grower p.jpg'),
189(36, 'Hog Breeder Mash', 'Hog Breeder Mash', 'FEEDS', 'LMPC', 987.00, 1000, 'upload/hgbreeder mash.jpg'),
190(37, 'Hog Breeder Pellet', 'Hog Breeder Pellet', 'FEEDS', 'LMPC', 1055.00, 1000, 'upload/hgpellet.jpg'),
191(38, 'Chick Grower Mash', 'Chick Grower Mash', 'FEEDS', 'LMPC', 1130.00, 1000, 'upload/grower mash.jpg'),
192(39, 'Hog Finisher Pellet', 'Hog Finisher Pellet', 'FEEDS', 'LMPC', 1077.00, 1000, 'upload/hgpellet.jpg'),
193(40, 'Titanium High Performance', 'Titanium High Performance', 'FEEDS', 'LMPC', 677.00, 1000, 'upload/highperformance.jpg'),
194(41, 'Hog Finisher Mash', 'Hog Finisher Mash', 'FEEDS', 'LMPC', 1035.00, 1000, 'upload/hog finisher mash.jpg'),
195(43, 'Garantisado Hog Grower Pellet', 'Garantisado Hog Grower Pellet', 'FEEDS', 'LMPC', 1165.00, 1000, 'upload/hog growerpellet.jpg'),
196(44, 'Garantisado Hog Grower Mash', 'Garantisado Hog Grower Mash', 'FEEDS', 'LMPC', 1115.00, 1000, 'upload/hog growersmash.jpg'),
197(45, 'Hog Starter Mash', 'Hog Starter Mash', 'FEEDS', 'LMPC', 1166.00, 1000, 'upload/hog startermash.jpg'),
198(46, 'Hog Per-starter Mash', 'Hog Per-starter Mash', 'FEEDS', 'LMPC', 900.00, 1000, 'upload/hogprestarte.jpg'),
199(47, 'Garantisado Hog Pre-starter Pellet', 'Garantisado Hog Pre-starter Pellet', 'FEEDS', 'LMPC', 1298.00, 1000, 'upload/hogprestarterbullet.jpg'),
200(48, 'Hog Starter Pellet', 'Hog Starter Pellet', 'FEEDS', 'LMPC', 1228.00, 1000, 'upload/hogstarterpellet.jpg'),
201(49, 'Pre-starter Crumble', 'PRE-STARTIMA Pre-starter Crumble', 'FEEDS', 'LMPC', 940.00, 1000, 'upload/hprestartercrumble.jpg'),
202(50, 'Laying Mash I', 'Laying Mash I', 'FEEDS', 'LMPC', 1188.00, 1000, 'upload/layingmash.jpg'),
203(51, 'Laying Mash II', 'Laying Mash II', 'FEEDS', 'LMPC', 1175.00, 1000, 'upload/layingmash2.jpg'),
204(52, 'Piglet Booster Mash', 'Garantisado Piglet Booster Mash', 'FEEDS', 'LMPC', 76.00, 1000, 'upload/pigletboostersmash.jpg'),
205(53, 'Titanium Pre Conditioning', 'Titanium Pre Conditioning', 'FEEDS', 'LMPC', 615.00, 1000, 'upload/preconditioning.jpg'),
206(54, 'Quail Laying Mash', 'Quail Laying Mash', 'FEEDS', 'LMPC', 1245.00, 1000, 'upload/quail layer mash.jpg'),
207(55, 'Limcoma Rabbit Pellet', 'Limcoma Rabbit Pellet', 'FEEDS', 'LMPC', 525.00, 1000, 'upload/rabit pellet.jpg'),
208(56, 'Horse Feed Mash', 'Horse Feed Mash', 'FEEDS', 'LMPC', 790.00, 1000, 'upload/range horse feed mash.jpg'),
209(57, 'Hotdog Premium 225g', 'Hotdog Premium 225g', 'PROCESS MEAT', 'LBPI', 46.50, 1000, 'upload/Prem. hd 225g.jpg'),
210(58, 'Hotdog Regular 225g', 'Hotdog Regular 225g', 'PROCESS MEAT', 'LBPI', 38.50, 1000, 'upload/Reg. HD 225g.jpg'),
211(59, 'Swine Lactating Pellet', 'Swine Lactating Pellet', 'FEEDS', 'LMPC', 1180.00, 1000, 'upload/sl pellet.jpg'),
212(60, 'Smoked Longanisa 250g', 'Smoked Longanisa 250g', 'PROCESS MEAT', 'LBPI', 46.86, 1000, 'upload/smoke long reg. 225g.jpg'),
213(61, 'Stag Developer Pellet 1kl', 'Stag Developer Pellet 1kl', 'FEEDS', 'LMPC', 27.00, 1000, 'upload/stag developer pellet.jpg'),
214(62, 'Swine laying Mash', 'Swine laying Mash', 'FEEDS', 'LMPC', 1135.00, 1000, 'upload/swinel mash.jpg'),
215(64, 'Vita Choice Hog Grower Mash', 'Vita Choice Hog Grower Mash', 'FEEDS', 'LMPC', 1030.00, 1000, 'upload/vchgmash.jpg'),
216(65, 'Vita Choice Hog Breeder Mash', 'Vita Choice Hog Breeder Mash', 'FEEDS', 'LMPC', 935.00, 1000, 'upload/vths mash.jpg'),
217(66, 'Vita Choice Hog Starter Pellet', 'Vita Choice Hog Starter Pellet', 'FEEDS', 'LMPC', 1135.00, 1000, 'upload/vthspellet.jpg'),
218(67, 'Cheesedog 225g', 'Cheesedog 225g', 'PROCESS MEAT', 'LBPI', 46.84, 1000, 'upload/IMG_20150410_134621.jpg'),
219(68, 'Skinless Premium 250g', 'Skinless Premium 250g', 'PROCESS MEAT', 'LBPI', 45.05, 1000, 'upload/IMG_20150410_134828.jpg'),
220(69, 'Hamburger Patties 250g', 'Hamburger Patties 250g', 'PROCESS MEAT', 'LBPI', 44.99, 1000, 'upload/IMG_20150410_141132.jpg'),
221(70, 'Sisig 250g', 'Sisig 250g', 'PROCESS MEAT', 'LBPI', 67.40, 1000, 'upload/IMG_20150410_134736.jpg'),
222(71, 'Embotido Roll 250g', 'Embotido Roll 250g', 'PROCESS MEAT', 'LBPI', 46.73, 1000, 'upload/IMG_20150410_134506.jpg'),
223(72, 'Embotido 5pcs (regular) 225g', 'Embotido 5pcs (regular) 225g', 'PROCESS MEAT', 'LBPI', 39.50, 1000, 'upload/IMG_20150410_134847.jpg'),
224(73, 'Sliced/Square Ham 250g', 'Sliced/square Ham 250g', 'PROCESS MEAT', 'LBPI', 54.25, 1000, 'upload/IMG_20150410_134650.jpg'),
225(75, 'Hotdog J4.5 1kl', 'Hotdog J4.5 1kl', 'PROCESS MEAT', 'LBPI', 186.17, 1000, 'upload/J4.5 500g.jpg'),
226(76, 'Pork Tapa 1kl', 'Pork Tapa 1kl', 'PROCESS MEAT', 'LBPI', 257.07, 1000, 'upload/tapa 1kl.jpg'),
227(77, 'Chicken Hamonado Regular (225g)', 'Chicken Hamonado Regular (225g)', 'PROCESS MEAT', 'LBPI', 39.50, 1000, 'upload/chicken hamonado reg.jpg'),
228(78, 'Chicken Long Regular (225g)', 'Chicken Long Regular (225g)', 'PROCESS MEAT', 'LBPI', 39.50, 1000, 'upload/Chicken long reg.jpg'),
229(79, 'Smoked Longanisa Regular (225g)', 'Smoked Longanisa Regular (225g)', 'PROCESS MEAT', 'LBPI', 39.50, 1000, 'upload/smoke long regular.jpg'),
230(80, 'BP Franks 450g', 'BP Franks 450g', 'PROCESS MEAT', 'LBPI', 76.35, 1000, 'upload/IMG_20150410_134452.jpg');
231
232-- --------------------------------------------------------
233
234--
235-- Table structure for table `tb_user`
236--
237
238CREATE TABLE IF NOT EXISTS `tb_user` (
239  `user_id` int(11) NOT NULL AUTO_INCREMENT,
240  `username` varchar(100) NOT NULL,
241  `password` varchar(100) NOT NULL,
242  `firstname` varchar(100) NOT NULL,
243  `lastname` varchar(100) NOT NULL,
244  PRIMARY KEY (`user_id`)
245) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
246
247--
248-- Dumping data for table `tb_user`
249--
250
251INSERT INTO `tb_user` (`user_id`, `username`, `password`, `firstname`, `lastname`) VALUES
252(18, 'admin', 'admin', 'admin', 'admin');
253
254/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
255/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
256/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;