· 10 years ago · May 24, 2016, 03:42 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: May 24, 2016 at 03:34 AM
7-- Server version: 5.5.44-0ubuntu0.14.04.1
8-- PHP Version: 5.5.9-1ubuntu4.13
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: `godly_aesthetics`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `CART`
27--
28
29CREATE TABLE IF NOT EXISTS `CART` (
30 `MEM_ID` int(11) NOT NULL,
31 `INV_ID` int(11) NOT NULL,
32 `CART_QTY` smallint(6) NOT NULL,
33 PRIMARY KEY (`MEM_ID`,`INV_ID`),
34 KEY `CART_INV_ID_FK` (`INV_ID`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `CART`
39--
40
41INSERT INTO `CART` (`MEM_ID`, `INV_ID`, `CART_QTY`) VALUES
42(1000023, 1000008, 10),
43(1000033, 1000039, 5);
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `CATEGORY`
49--
50
51CREATE TABLE IF NOT EXISTS `CATEGORY` (
52 `CAT_TITLE` varchar(30) NOT NULL,
53 PRIMARY KEY (`CAT_TITLE`)
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56--
57-- Dumping data for table `CATEGORY`
58--
59
60INSERT INTO `CATEGORY` (`CAT_TITLE`) VALUES
61('Hoodies'),
62('Jackets'),
63('Leggings'),
64('Stringers'),
65('Sweatpants'),
66('Tees & Tanks'),
67('Yoga Pants');
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `COLOR`
73--
74
75CREATE TABLE IF NOT EXISTS `COLOR` (
76 `COLOR_ID` varchar(6) NOT NULL,
77 `COLOR_NAME` varchar(25) NOT NULL,
78 PRIMARY KEY (`COLOR_ID`)
79) ENGINE=InnoDB DEFAULT CHARSET=latin1;
80
81--
82-- Dumping data for table `COLOR`
83--
84
85INSERT INTO `COLOR` (`COLOR_ID`, `COLOR_NAME`) VALUES
86('000000', 'Black'),
87('0000FF', 'Blue'),
88('008000', 'Green'),
89('C8C8C8', 'Grey'),
90('FF0000', 'Red'),
91('FF00FC', 'Pink'),
92('FFA500', 'Orange'),
93('FFFF00', 'Yellow'),
94('FFFFFF', 'White');
95
96-- --------------------------------------------------------
97
98--
99-- Table structure for table `EMPLOYEE`
100--
101
102CREATE TABLE IF NOT EXISTS `EMPLOYEE` (
103 `EMP_ID` int(11) NOT NULL AUTO_INCREMENT,
104 `EMP_FIRST_NAME` varchar(30) NOT NULL,
105 `EMP_LAST_NAME` varchar(30) NOT NULL,
106 `EMP_EMAIL` varchar(50) NOT NULL,
107 `EMP_PASSWORD` varchar(60) NOT NULL,
108 `EMP_STREET_ADDRESS` varchar(30) NOT NULL,
109 `EMP_STREET_ADDRESS2` varchar(30) NOT NULL,
110 `EMP_CITY` varchar(30) NOT NULL,
111 `EMP_PROV` varchar(30) NOT NULL,
112 `EMP_COUNTRY` varchar(30) NOT NULL,
113 `EMP_POSTAL_CODE` varchar(7) NOT NULL,
114 `EMP_TITLE` varchar(30) NOT NULL,
115 `EMP_DEPT` varchar(30) NOT NULL,
116 `EMP_GENDER` varchar(6) NOT NULL,
117 `EMP_DOB` datetime NOT NULL,
118 `EMP_HIRE_DATE` datetime NOT NULL,
119 PRIMARY KEY (`EMP_ID`)
120) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000011 ;
121
122--
123-- Dumping data for table `EMPLOYEE`
124--
125
126INSERT INTO `EMPLOYEE` (`EMP_ID`, `EMP_FIRST_NAME`, `EMP_LAST_NAME`, `EMP_EMAIL`, `EMP_PASSWORD`, `EMP_STREET_ADDRESS`, `EMP_STREET_ADDRESS2`, `EMP_CITY`, `EMP_PROV`, `EMP_COUNTRY`, `EMP_POSTAL_CODE`, `EMP_TITLE`, `EMP_DEPT`, `EMP_GENDER`, `EMP_DOB`, `EMP_HIRE_DATE`) VALUES
127(1000001, 'Chuck', 'Nice', 'chucknice@godlyaesthetics.com', '', '3782 Chambly Blvd', '', 'Longueuil', 'Quebec', 'Canada', 'K9F2B4', 'Shipping manager', 'Shipping', 'Male', '1976-05-03 00:00:00', '2015-10-05 00:00:00'),
128(1000002, 'Simon', 'Facchini', 'simonfacchini@godlyaesthetics.com', '', '5544 Av. Auteuil', '', 'Brossard', 'Quebec', 'Canada', 'J4Z1M2', 'CEO', 'Master Employee', 'Male', '1995-10-21 00:00:00', '2015-08-01 00:00:00'),
129(1000003, 'Gregory', 'Wallace', 'gregwallace@godlyaesthetics.com', '', '9832 Av. Papineau', '', 'Montreal', 'Quebec', 'Canada', 'K8L5E1', 'Shipping Employee', 'Shipping', 'Male', '1985-12-25 00:00:00', '2015-09-11 00:00:00'),
130(1000004, 'Remy', 'Chaurand', 'remychaurand@godlyaesthetics.com', '', '4045 rue Orly', '', 'Brossard', 'Quebec', 'Canada', 'J4Y2K6', 'Database Administrator', 'IT', 'Male', '1995-10-27 00:00:00', '2015-08-15 00:00:00'),
131(1000005, 'Domenic', 'Secarrecia', 'domseccareccia@godlyaesthetics.com', '', '9237 Unicorn Road', '', 'Montreal', 'Quebec', 'Canada', 'O8B5C3', 'Database Administrator', 'IT', 'Male', '1995-10-21 00:00:00', '2015-08-01 00:00:00'),
132(1000007, 'Domenic', 'Seccareccia', 'dom@godlyaesthetics.com', '$2y$11$he4eaE75LyVsaT5BOGmxfuqV3DUZ.DEKwDuvrPsY5EDMS.OFbBG7y', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Database Administrator', 'IT', 'Male', '1995-10-19 00:00:00', '2016-02-14 23:58:03'),
133(1000010, 'Domenic', 'Seccareccia', 'fsfds@godlyaesthetics.com', '$2y$11$kLJPNh/fNQ.fTVBOMff6u.DsBe8765tJAz9m7Tgi1yImo6F3o/0Pu', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'hdfghdghd', 'Shipping', 'Male', '1991-03-04 00:00:00', '2016-02-15 19:36:04');
134
135-- --------------------------------------------------------
136
137--
138-- Table structure for table `INVENTORY`
139--
140
141CREATE TABLE IF NOT EXISTS `INVENTORY` (
142 `INV_ID` int(11) NOT NULL,
143 `PROD_ID` int(11) NOT NULL,
144 `INV_SIZE_ID` varchar(25) NOT NULL,
145 `COLOR_ID` varchar(6) NOT NULL,
146 `INV_QTY` smallint(6) NOT NULL DEFAULT '0',
147 `INV_URL_1` varchar(100) NOT NULL,
148 `INV_URL_2` varchar(100) NOT NULL,
149 `INV_URL_3` varchar(100) NOT NULL,
150 `INV_URL_4` varchar(100) NOT NULL,
151 PRIMARY KEY (`INV_ID`),
152 KEY `INVENTORY_PROD_ID_FK` (`PROD_ID`),
153 KEY `INVENTORY_INV_SIZE_ID_FK` (`INV_SIZE_ID`),
154 KEY `INVENTORY_COLOR_ID_FK` (`COLOR_ID`)
155) ENGINE=InnoDB DEFAULT CHARSET=latin1;
156
157--
158-- Dumping data for table `INVENTORY`
159--
160
161INSERT INTO `INVENTORY` (`INV_ID`, `PROD_ID`, `INV_SIZE_ID`, `COLOR_ID`, `INV_QTY`, `INV_URL_1`, `INV_URL_2`, `INV_URL_3`, `INV_URL_4`) VALUES
162(1000000, 1000007, 'Large', '000000', 3, 'images/women/tees-tanks/proving1_black.png', 'images/women/tees-tanks/proving2_black.png', 'images/women/tees-tanks/proving3_black.png\n', 'images/women/tees-tanks/proving4_black.png\n'),
163(1000001, 1000007, 'Medium', '000000', 9, 'images/women/tees-tanks/proving1_black.png', 'images/women/tees-tanks/proving2_black.png', 'images/women/tees-tanks/proving3_black.png', 'images/women/tees-tanks/proving4_black.png'),
164(1000002, 1000011, 'Large', 'C8C8C8', 9, 'images/women/tees-tanks/lady_in_street1_grey.jpg', 'images/women/tees-tanks/lady_in_street2_grey.jpg', 'images/women/tees-tanks/lady_in_street3_grey.jpg', 'images/women/tees-tanks/lady_in_street4_grey.jpg'),
165(1000004, 1000007, 'Small', '008000', 7, 'images/women/tees-tanks/proving1_green.png', 'images/women/tees-tanks/proving1_green.png', 'images/women/tees-tanks/proving1_green.png', 'images/women/tees-tanks/proving1_green.png'),
166(1000005, 1000007, 'Medium', '0000FF', 2, 'images/women/tees-tanks/proving1_blue.png', 'images/women/tees-tanks/proving2_blue.png', 'images/women/tees-tanks/proving3_blue.png', 'images/women/tees-tanks/proving4_blue.png'),
167(1000006, 1000006, 'Small', 'C8C8C8', 1, 'images/men/tees-tanks/shirt1_grey.jpg', 'images/men/tees-tanks/shirt2_grey.jpg', 'images/men/tees-tanks/shirt3_grey.jpg', 'images/men/tees-tanks/shirt4_grey.jpg'),
168(1000007, 1000012, 'Small', '000000', 5, 'images/women/tees-tanks/sweat_is_fat_crying1_black.jpg', 'images/women/tees-tanks/sweat_is_fat_crying2_black.jpg', 'images/women/tees-tanks/sweat_is_fat_crying3_black.jpg', 'images/women/tees-tanks/sweat_is_fat_crying4_black.jpg'),
169(1000008, 1000013, 'X-Small', 'FF00FC', 20, 'images/women/tees-tanks/wednesday_we_go_to_gym1_pink.jpg', 'images/women/tees-tanks/wednesday_we_go_to_gym2_pink.jpg', 'images/women/tees-tanks/wednesday_we_go_to_gym3_pink.jpg', 'images/women/tees-tanks/wednesday_we_go_to_gym4_pink.jpg'),
170(1000009, 1000008, 'Medium', 'FFFF00', 6, 'images/men/tees-tanks/bulking1_yellow.png', 'images/men/tees-tanks/bulking2_yellow.png', 'images/men/tees-tanks/bulking3_yellow.png', 'images/men/tees-tanks/bulking4_yellow.png'),
171(1000010, 1000009, 'Large', '000000', 1, 'images/men/tees-tanks/mind1_black.png', 'images/men/tees-tanks/mind2_black.png', 'images/men/tees-tanks/mind3_black.png', 'images/men/tees-tanks/mind4_black.png'),
172(1000011, 1000010, 'Medium', 'C8C8C8', 14, 'images/men/tees-tanks/id_flex_shirt1_grey.png', 'images/men/tees-tanks/id_flex_shirt2_grey.png', 'images/men/tees-tanks/id_flex_shirt3_grey.png', 'images/men/tees-tanks/id_flex_shirt4_grey.png'),
173(1000012, 1000020, 'Medium', '000000', 7, 'images/men/stringers/black_vest1_black.png', 'images/men/stringers/black_vest2_black.png', 'images/men/stringers/black_vest3_black.png', 'images/men/stringers/black_vest4_black.png'),
174(1000013, 1000021, 'X-Small', 'FF0000', 3, 'images/men/stringers/gym_men_muscle1_red.png', 'images/men/stringers/gym_men_muscle2_red.png', 'images/men/stringers/gym_men_muscle3_red.png', 'images/men/stringers/gym_men_muscle4_red.png'),
175(1000014, 1000022, 'Medium', '000000', 9, 'images/men/stringers/protime_stringer1_black.png', 'images/men/stringers/protime_stringer2_black.png', 'images/men/stringers/protime_stringer3_black.png', 'images/men/stringers/protime_stringer4_black.png'),
176(1000015, 1000014, 'Medium', 'FFFFFF', 8, 'images/men/hoodies/eat_sleep_workout1_white.png', 'images/men/hoodies/eat_sleep_workout2_white.png', 'images/men/hoodies/eat_sleep_workout3_white.png', 'images/men/hoodies/eat_sleep_workout4_white.png'),
177(1000016, 1000015, 'Small', 'C8C8C8', 9, 'images/men/hoodies/the_only_bad_workout1_grey.png', 'images/men/hoodies/the_only_bad_workout2_grey.png', 'images/men/hoodies/the_only_bad_workout3_grey.png', 'images/men/hoodies/the_only_bad_workout4_grey.png'),
178(1000017, 1000016, 'Large', '000000', 20, 'images/men/hoodies/warm_up_is_your_workout1_black.png', 'images/men/hoodies/warm_up_is_your_workout2_black.png', 'images/men/hoodies/warm_up_is_your_workout3_black.png', 'images/men/hoodies/warm_up_is_your_workout4_black.png'),
179(1000018, 1000017, 'Small', '000000', 10, 'images/men/jackets/black_gold_main1_black.png', 'images/men/jackets/black_gold_main2_black.png', 'images/men/jackets/black_gold_main3_black.png', 'images/men/jackets/black_gold_main4_black.png'),
180(1000019, 1000018, 'X-Large', 'C8C8C8', 27, 'images/men/jackets/caribou_track1_grey.png', 'images/men/jackets/caribou_track2_grey.png', 'images/men/jackets/caribou_track3_grey.png', 'images/men/jackets/caribou_track4_grey.png'),
181(1000020, 1000019, 'Medium', 'FF0000', 5, 'images/men/jackets/rethel1_orange.png', 'images/men/jackets/rethel2_orange.png', 'images/men/jackets/rethel3_orange.png', 'images/men/jackets/rethel4_orange.png'),
182(1000021, 1000023, 'Large', '000000', 19, 'images/men/sweatpants/black_sundry1_black.png', 'images/men/sweatpants/black_sundry2_black.png', 'images/men/sweatpants/black_sundry3_black.png', 'images/men/sweatpants/black_sundry4_black.png'),
183(1000022, 1000024, 'Medium', '000000', 8, 'images/men/sweatpants/laced_black1_black.png', 'images/men/sweatpants/laced_black2_black.png', 'images/men/sweatpants/laced_black3_black.png', 'images/men/sweatpants/laced_black4_black.png'),
184(1000024, 1000025, 'Medium', 'C8C8C8', 14, 'images/men/sweatpants/stradium_pant1_grey.jpg', 'images/men/sweatpants/stradium_pant2_grey.jpg', 'images/men/sweatpants/stradium_pant3_grey.jpg', 'images/men/sweatpants/stradium_pant4_grey.jpg'),
185(1000025, 1000026, 'Medium', 'C8C8C8', 11, 'images/women/hoodies/pink_grey1_grey.jpg', 'images/women/hoodies/pink_grey2_grey.jpg', 'images/women/hoodies/pink_grey3_grey.jpg', 'images/women/hoodies/pink_grey4_grey.jpg'),
186(1000026, 1000027, 'X-Small', '000000', 18, 'images/women/hoodies/regret_workout1_black.png', 'images/women/hoodies/regret_workout2_black.png', 'images/women/hoodies/regret_workout3_black.png', 'images/women/hoodies/regret_workout4_black.png'),
187(1000027, 1000028, 'Medium', 'C8C8C8', 20, 'images/women/hoodies/workout_is_my_warmup1_grey.png', 'images/women/hoodies/workout_is_my_warmup2_grey.png', 'images/women/hoodies/workout_is_my_warmup3_grey.png', 'images/women/hoodies/workout_is_my_warmup4_grey.png'),
188(1000028, 1000029, 'Large', '0000FF', 15, 'images/women/jackets/arenite_jacket_wantilles_blue1_blue.png', 'images/women/jackets/arenite_jacket_wantilles_blue2_blue.png', 'images/women/jackets/arenite_jacket_wantilles_blue3_blue.png', 'images/women/jackets/arenite_jacket_wantilles_blue4_blue.png'),
189(1000029, 1000030, 'Small', 'FFFFFF', 5, 'images/women/jackets/grey_black1_white.png', 'images/women/jackets/grey_black2_white.png', 'images/women/jackets/grey_black3_white.png', 'images/women/jackets/grey_black4_white.png'),
190(1000030, 1000031, 'Medium', '0000FF', 9, 'images/women/jackets/blue_grey_black1_blue.png', 'images/women/jackets/blue_grey_black2_blue.png', 'images/women/jackets/blue_grey_black3_blue.png', 'images/women/jackets/blue_grey_black4_blue.png'),
191(1000031, 1000035, 'Medium', 'C8C8C8', 8, 'images/women/sweatpants/bride_wings_vector1_grey.png', 'images/women/sweatpants/bride_wings_vector2_grey.png', 'images/women/sweatpants/bride_wings_vector3_grey.png', 'images/women/sweatpants/bride_wings_vector4_grey.png'),
192(1000032, 1000036, 'Medium', 'C8C8C8', 49, 'images/women/sweatpants/htfu_bulging1_grey.png', 'images/women/sweatpants/htfu_bulging2_grey.png', 'images/women/sweatpants/htfu_bulging3_grey.png', 'images/women/sweatpants/htfu_bulging4_grey.png'),
193(1000033, 1000037, 'Small', '000000', 34, 'images/women/sweatpants/prosper_sweats1_black.png', 'images/women/sweatpants/prosper_sweats2_black.png', 'images/women/sweatpants/prosper_sweats3_black.png', 'images/women/sweatpants/prosper_sweats4_black.png'),
194(1000034, 1000032, 'Medium', '000000', 21, 'images/women/leggings/gore_running1_black.png', 'images/women/leggings/gore_running2_black.png', 'images/women/leggings/gore_running3_black.png', 'images/women/leggings/gore_running4_black.png'),
195(1000035, 1000033, 'X-Small', '000000', 14, 'images/women/leggings/helly_hansen1_black.png', 'images/women/leggings/helly_hansen2_black.png', 'images/women/leggings/helly_hansen3_black.png', 'images/women/leggings/helly_hansen4_black.png'),
196(1000036, 1000034, 'X-Small', 'FF00FC', 9, 'images/women/leggings/pink_white_black1_pink.png', 'images/women/leggings/pink_white_black2_pink.png', 'images/women/leggings/pink_white_black3_pink.png', 'images/women/leggings/pink_white_black4_pink.png'),
197(1000037, 1000038, 'Medium', '000000', 2, 'images/women/yoga-pants/heather1_black.png', 'images/women/yoga-pants/heather2_black.png', 'images/women/yoga-pants/heather3_black.png', 'images/women/yoga-pants/heather4_black.png'),
198(1000038, 1000039, 'Medium', '000000', 7, 'images/women/yoga-pants/simple_yoga_pants1_black.png', 'images/women/yoga-pants/simple_yoga_pants2_black.png', 'images/women/yoga-pants/simple_yoga_pants3_black.png', 'images/women/yoga-pants/simple_yoga_pants4_black.png'),
199(1000039, 1000040, 'Small', 'C8C8C8', 5, 'images/women/yoga-pants/yoga_pants_grey1_grey.png', 'images/women/yoga-pants/yoga_pants_grey2_grey.png', 'images/women/yoga-pants/yoga_pants_grey3_grey.png', 'images/women/yoga-pants/yoga_pants_grey4_grey.png');
200
201-- --------------------------------------------------------
202
203--
204-- Table structure for table `INVENTORY_SIZE`
205--
206
207CREATE TABLE IF NOT EXISTS `INVENTORY_SIZE` (
208 `INV_SIZE_ID` varchar(25) NOT NULL,
209 PRIMARY KEY (`INV_SIZE_ID`)
210) ENGINE=InnoDB DEFAULT CHARSET=latin1;
211
212--
213-- Dumping data for table `INVENTORY_SIZE`
214--
215
216INSERT INTO `INVENTORY_SIZE` (`INV_SIZE_ID`) VALUES
217('Large'),
218('Medium'),
219('Small'),
220('X-Large'),
221('X-Small');
222
223-- --------------------------------------------------------
224
225--
226-- Table structure for table `INVOICE`
227--
228
229CREATE TABLE IF NOT EXISTS `INVOICE` (
230 `INVOICE_ID` int(11) NOT NULL AUTO_INCREMENT,
231 `MEM_ID` int(11) NOT NULL,
232 `INVOICE_ORDER_DATE` datetime NOT NULL,
233 `INVOICE_AMOUNT` decimal(7,2) NOT NULL,
234 `SHIP_ID` int(11) NOT NULL,
235 `PAYPAL_INVOICE_ID` varchar(50) NOT NULL,
236 `PAYMENT_ID` varchar(50) NOT NULL,
237 `PAYER_ID` varchar(50) NOT NULL,
238 `SALE_ID` varchar(50) NOT NULL,
239 `SHIP_DATE` datetime DEFAULT NULL,
240 `PAYPAL_EMAIL` varchar(50) NOT NULL,
241 `SHIP_NAME` varchar(30) NOT NULL,
242 `TRACKING_NO` varchar(50) NOT NULL,
243 PRIMARY KEY (`INVOICE_ID`),
244 KEY `INVOICE_MEM_ID_FK` (`MEM_ID`),
245 KEY `INVOICE_SHIP_ID_FK` (`SHIP_ID`),
246 KEY `INVOICE_ID` (`INVOICE_ID`)
247) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000102 ;
248
249--
250-- Dumping data for table `INVOICE`
251--
252
253INSERT INTO `INVOICE` (`INVOICE_ID`, `MEM_ID`, `INVOICE_ORDER_DATE`, `INVOICE_AMOUNT`, `SHIP_ID`, `PAYPAL_INVOICE_ID`, `PAYMENT_ID`, `PAYER_ID`, `SALE_ID`, `SHIP_DATE`, `PAYPAL_EMAIL`, `SHIP_NAME`, `TRACKING_NO`) VALUES
254(1000028, 1000022, '2016-01-28 17:39:49', '53.18', 1000001, '56aa98a499c35', 'PAY-61X75066CE1889841K2VJRJI', 'YE5RGMG4NMVVC', '3GP875331P692861Y', '2016-02-19 19:52:03', 'godlyaesthetics-buyer@hotmail.com', '', '123445656345353'),
255(1000029, 1000022, '2016-01-28 17:45:47', '53.18', 1000001, '56aa9a09e771b', 'PAY-53B87379TY0578830K2VJUCQ', 'YE5RGMG4NMVVC', '1FG315251D069181N', NULL, 'godlyaesthetics-buyer@hotmail.com', '', ''),
256(1000030, 1000022, '2016-01-28 17:47:47', '53.18', 1000001, '56aa9a8274480', 'PAY-3M421563LY375154WK2VJVAY', 'YE5RGMG4NMVVC', '44X421109Y356551F', NULL, 'godlyaesthetics-buyer@hotmail.com', '', ''),
257(1000031, 1000022, '2016-01-28 17:52:00', '53.18', 1000001, '56aa9b7f69bba', 'PAY-4PW702837P2891722K2VJXAA', 'YE5RGMG4NMVVC', '0HN76223BS163345F', NULL, 'godlyaesthetics-buyer@hotmail.com', '', ''),
258(1000032, 1000022, '2016-02-01 08:29:06', '30.98', 1000001, '56af5d916db7d', 'PAY-7UX3208441014841GK2XV3EQ', 'YE5RGMG4NMVVC', '7SN42291XJ729081B', NULL, 'godlyaesthetics-buyer@hotmail.com', '', ''),
259(1000033, 1000022, '2016-02-03 09:25:15', '53.97', 1000001, '56b20db7b9fd0', 'PAY-4WP64481NS393840LK2ZA3OA', 'YE5RGMG4NMVVC', '6LK04720MB811851P', NULL, 'godlyaesthetics-buyer@hotmail.com', '', ''),
260(1000034, 1000022, '2016-02-03 10:59:20', '75.77', 1000001, '56b223c6c44f4', 'PAY-18K95180NV7170531K2ZCHRY', 'YE5RGMG4NMVVC', '4EB68102SW344931H', NULL, 'godlyaesthetics-buyer@hotmail.com', '', ''),
261(1000035, 1000022, '2016-02-03 20:13:02', '30.59', 1000001, '56b2a58b01b2c', 'PAY-7EN01622J7738371XK2ZKLCY', 'YE5RGMG4NMVVC', '8DV73648AY1485818', NULL, 'godlyaesthetics-buyer@hotmail.com', '', ''),
262(1000036, 1000022, '2016-02-03 20:17:27', '53.18', 1000001, '56b2a6750ab32', 'PAY-9AJ84875G1251864PK2ZKM5I', 'YE5RGMG4NMVVC', '32161611R0800740M', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
263(1000037, 1000022, '2016-02-03 20:25:46', '52.78', 1000001, '56b2a880169de', 'PAY-38W83951SW853521EK2ZKRAA', 'YE5RGMG4NMVVC', '66921856WM253364B', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
264(1000038, 1000023, '2016-02-04 11:53:41', '57.22', 1000002, '56b381b68698e', 'PAY-4FB981306A460862NK2ZYDNY', 'YE5RGMG4NMVVC', '7UM18708UT282381H', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
265(1000039, 1000022, '2016-02-05 12:59:47', '30.98', 1000001, '56b4e29004f7c', 'PAY-3HE18510FK938370TK22OFEA', 'YE5RGMG4NMVVC', '22742531LG5322227', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
266(1000040, 1000022, '2016-02-05 13:08:20', '30.59', 1000001, '56b4e5022b36d', 'PAY-5GH93561JV958005TK22OKAQ', 'YE5RGMG4NMVVC', '09909226SN481693X', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
267(1000041, 1000022, '2016-02-05 13:09:22', '30.59', 1000001, '56b4e5442281c', 'PAY-4A367047CF722751XK22OKRA', 'YE5RGMG4NMVVC', '4FT22918TX105204U', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
268(1000042, 1000022, '2016-02-05 13:10:38', '30.39', 1000001, '56b4e576ad787', 'PAY-7D888262YA5736122K22OK5Y', 'YE5RGMG4NMVVC', '56P64378XV897483K', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
269(1000043, 1000022, '2016-02-05 13:12:57', '30.59', 1000001, '56b4e6186e38c', 'PAY-9EF06819UL504264JK22OMGI', 'YE5RGMG4NMVVC', '9AL43778CS593084D', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
270(1000044, 1000022, '2016-02-09 15:19:42', '52.78', 1000001, '56ba49cc893a9', 'PAY-4HD17489RJ7289648K25ETTI', 'YE5RGMG4NMVVC', '16X87157BV3874408', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
271(1000045, 1000022, '2016-02-11 09:10:48', '637.69', 1000001, '56bc9653b16b8', 'PAY-1A3769439P071351AK26JMVI', 'YE5RGMG4NMVVC', '69310458FY110164T', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
272(1000046, 1000022, '2016-02-11 10:01:45', '122.92', 1000001, '56bca226105cc', 'PAY-3AK837209M975590XK26KEJY', 'YE5RGMG4NMVVC', '7P365760C13429506', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
273(1000047, 1000022, '2016-02-11 10:21:05', '122.92', 1000001, '56bca691b027a', 'PAY-81F41404L9636610PK26KNEQ', 'YE5RGMG4NMVVC', '07483133WJ1338947', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
274(1000048, 1000023, '2016-02-11 10:24:06', '53.97', 1000001, '56bca77e2fb87', 'PAY-7HS17110RB113350CK26KO7Q', 'YE5RGMG4NMVVC', '4W248148K9603562X', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
275(1000049, 1000022, '2016-02-11 10:24:06', '122.92', 1000001, '56bca77d1b1ff', 'PAY-3DS49814MF297011EK26KO7Q', 'HS4E3Q23NYXP2', '6T260874713557225', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
276(1000050, 1000023, '2016-02-11 10:27:56', '53.97', 1000001, '56bca834c5b51', 'PAY-6YN212180G423583PK26KQNI', 'YE5RGMG4NMVVC', '957650923G595471A', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
277(1000051, 1000022, '2016-02-11 10:27:58', '122.92', 1000001, '56bca86aeb3a7', 'PAY-31F35605B1034673SK26KQ2Y', 'HS4E3Q23NYXP2', '0A566882UN8817936', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
278(1000052, 1000023, '2016-02-11 10:32:48', '62.97', 1000002, '56bca9586107e', 'PAY-1FC3105882849311KK26KSWI', 'YE5RGMG4NMVVC', '9XJ50537HJ196220D', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
279(1000053, 1000022, '2016-02-11 10:32:49', '122.92', 1000001, '56bca955efe95', 'PAY-3K128146LT1826931K26KSVY', 'HS4E3Q23NYXP2', '9XV2361803580444M', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
280(1000054, 1000023, '2016-02-11 10:35:00', '70.98', 1000003, '56bcaa0b25866', 'PAY-4T056286H1414824LK26KUCY', 'YE5RGMG4NMVVC', '3AD61021WU728064L', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
281(1000055, 1000022, '2016-02-11 10:35:10', '122.92', 1000001, '56bcaa1bc6a05', 'PAY-8GT19217VU589972XK26KUHI', 'HS4E3Q23NYXP2', '99G27453X0618051T', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
282(1000056, 1000022, '2016-02-11 10:41:12', '120.94', 1000001, '56bcab811645b', 'PAY-5NK61544YA028520WK26KXAI', 'HS4E3Q23NYXP2', '3HB23057VS9973100', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
283(1000057, 1000023, '2016-02-11 10:42:42', '53.97', 1000001, '56bcabde5a9b7', 'PAY-58172783LU098732TK26KXXY', 'YE5RGMG4NMVVC', '0MR37136C11777443', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
284(1000058, 1000022, '2016-02-11 11:26:46', '129.94', 1000002, '56bcb6331f8e5', 'PAY-7MH1688352968442HK26LMMY', 'YE5RGMG4NMVVC', '2SC86266BY820270K', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
285(1000059, 1000022, '2016-02-11 11:27:54', '122.92', 1000001, '56bcb62c970d9', 'PAY-6FA12862RR620534WK26LMLI', 'HS4E3Q23NYXP2', '8RC80226AH563211A', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
286(1000060, 1000023, '2016-02-11 11:33:26', '117.95', 1000001, '56bcb7c35f260', 'PAY-81P91620DU0724443K26LPRA', 'YE5RGMG4NMVVC', '98V7537864851243X', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
287(1000061, 1000023, '2016-02-11 11:35:51', '346.83', 1000001, '56bcb855e41b8', 'PAY-2MR03993KE6393524K26LQVQ', 'YE5RGMG4NMVVC', '7VB36350R0287613M', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
288(1000062, 1000022, '2016-02-11 11:35:54', '122.92', 1000001, '56bcb8267c493', 'PAY-7YR3771515014205GK26LQJY', 'HS4E3Q23NYXP2', '78885157J9307963Y', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
289(1000063, 1000022, '2016-02-11 16:33:41', '30.98', 1000001, '56bcfe0edfb8c', 'PAY-9L172952FL671645WK26P4DY', 'HS4E3Q23NYXP2', '9TM135078R042234H', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
290(1000064, 1000022, '2016-02-11 17:02:00', '30.59', 1000001, '56bd04a3c7c0a', 'PAY-64K61320E3688723RK26QJJA', 'HS4E3Q23NYXP2', '36A70041FF9647720', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
291(1000065, 1000022, '2016-02-11 17:07:13', '30.39', 1000001, '56bd060262097', 'PAY-3L1177574C147601MK26QMAY', 'HS4E3Q23NYXP2', '97081233H9456963T', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
292(1000066, 1000022, '2016-02-11 17:38:22', '30.39', 1000001, '56bd0d4dbd3f0', 'PAY-72F99417DW641204TK26Q2TQ', 'HS4E3Q23NYXP2', '5NH76437JA582731J', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', ''),
293(1000067, 1000022, '2016-02-11 23:07:21', '30.59', 1000001, '56bd5a5975227', 'PAY-8B678508A2331762PK26VUWY', 'YE5RGMG4NMVVC', '53Y25845JA631845U', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
294(1000068, 1000022, '2016-02-11 23:18:38', '30.39', 1000001, '56bd5d02ddcda', 'PAY-1GA84607SR081211KK26V2AY', 'YE5RGMG4NMVVC', '8RK74067B3912302D', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
295(1000069, 1000022, '2016-02-11 23:19:59', '28.99', 1000001, '56bd5d45a8b7e', 'PAY-9GD75736CE238773XK26V2RQ', 'YE5RGMG4NMVVC', '40F91374UN496412C', '2016-02-12 20:57:03', 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', '2005011063855031'),
296(1000070, 1000022, '2016-02-12 19:36:51', '19.49', 1000001, '56be7a9194b08', 'PAY-8NS90776YR9798619K27HVEQ', 'YE5RGMG4NMVVC', '0N241824UW0921208', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
297(1000071, 1000022, '2016-02-12 19:46:12', '19.19', 1000001, '56be7cc2585ae', 'PAY-1T238020GK599832FK27HZQY', 'YE5RGMG4NMVVC', '7TF87269Y3050742K', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
298(1000072, 1000022, '2016-02-12 19:53:40', '36.24', 1000001, '56be7e7d08bfb', 'PAY-8034860203593212RK27H47I', 'YE5RGMG4NMVVC', '3S258011LL630423X', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
299(1000073, 1000022, '2016-02-12 19:56:36', '19.49', 1000001, '56be7f337e9f8', 'PAY-2Y923684U9549935BK27H6NA', 'YE5RGMG4NMVVC', '6SU835939S8295607', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
300(1000074, 1000022, '2016-02-12 20:00:36', '122.95', 1000001, '56be80230013a', 'PAY-2ED43940TH766843XK27IAIY', 'YE5RGMG4NMVVC', '9L057689170494404', '2016-02-13 01:02:49', 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', '2005011063855031'),
301(1000075, 1000022, '2016-02-12 20:16:52', '19.29', 1000001, '56be83dee0e42', 'PAY-8D91223992405601VK27IHXY', 'YE5RGMG4NMVVC', '09F21935WC523473P', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
302(1000076, 1000022, '2016-02-12 20:19:35', '19.19', 1000001, '56be848a0120f', 'PAY-2S3562129F601341SK27IJCQ', 'YE5RGMG4NMVVC', '1H2747628X6998029', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
303(1000077, 1000022, '2016-02-12 20:22:28', '41.88', 1000001, '56be85213c08b', 'PAY-9LP16397DA312392LK27IKII', 'YE5RGMG4NMVVC', '3UV93312YH455013W', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
304(1000078, 1000022, '2016-02-12 20:24:33', '24.94', 1000001, '56be85b6811d4', 'PAY-7UF25777DL073470LK27ILNY', 'YE5RGMG4NMVVC', '4R1612186G623635T', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
305(1000079, 1000022, '2016-02-12 20:43:52', '41.58', 1000001, '56be8a41dbfb6', 'PAY-18V55844NT217583CK27IUQQ', 'YE5RGMG4NMVVC', '1M029708VP8828340', '2013-02-16 01:44:59', 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', '2005011063855031'),
306(1000080, 1000022, '2016-02-12 20:52:49', '30.39', 1000001, '56be8c5caaf66', 'PAY-5RB06167EY706830GK27IYXI', 'YE5RGMG4NMVVC', '7G870677S45692229', '2016-02-13 01:53:31', 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', '2005011063855031'),
307(1000081, 1000022, '2016-02-15 23:39:35', '30.98', 1000001, '56c2a7f188982', 'PAY-5SX43759S3265970PK3BKP4Q', 'YE5RGMG4NMVVC', '4BR34216E37802736', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
308(1000082, 1000022, '2016-02-15 23:53:20', '65.46', 1000001, '56c2ab2d177f5', 'PAY-4EN69107F40120203K3BKWLI', 'YE5RGMG4NMVVC', '5U114069KH758505V', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccia', ''),
309(1000083, 1000030, '2016-02-16 08:31:50', '249.30', 1000001, '56c3249844de2', 'PAY-8S3365643X625403PK3BSJGI', 'HS4E3Q23NYXP2', '77S337059F757634X', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Amin Barrwerew', ''),
310(1000084, 1000031, '2016-02-17 14:52:17', '71.20', 1000001, '56c4cf562f2c5', 'PAY-5WW60726R3465040NK3CM6VY', 'HS4E3Q23NYXP2', '5JL60757DG4159845', '2016-02-17 14:56:51', 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', '2005011063855031'),
311(1000085, 1000032, '2016-02-17 16:06:00', '94.19', 1000001, '56c4e0971bff2', 'PAY-8VH0133951126911FK3COBFY', 'HS4E3Q23NYXP2', '21442901H87725525', '2016-02-17 16:09:00', 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccia', '2005011063855031'),
312(1000086, 1000033, '2016-02-18 10:38:01', '65.45', 1000001, '56c5e51c64c67', 'PAY-8SV13196NK271702TK3C6KHI', 'YE5RGMG4NMVVC', '60889512YM800331J', '2016-02-18 10:40:17', 'godlyaesthetics-buyer@hotmail.com', 'Domenic Seccareccoia', '57468732648732'),
313(1000087, 1000023, '2016-02-18 16:48:24', '94.17', 1000001, '56c63bfba4be2', 'PAY-8W205849WB0961906K3DDX7A', 'YE5RGMG4NMVVC', '6K7990545C1551644', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
314(1000088, 1000030, '2016-02-19 19:42:01', '59.69', 1000001, '56c7b62e731ca', 'PAY-16656916A8054642XK3D3MLY', 'YE5RGMG4NMVVC', '22732282D9730493E', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Amin Barrwerew', ''),
315(1000089, 1000030, '2016-02-21 15:34:54', '103.19', 1000002, '56ca1f54a1245', 'PAY-56A43205G4013293DK3FB6VQ', 'YE5RGMG4NMVVC', '4FG39933KK779515L', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Remy Chaurand', ''),
316(1000090, 1000030, '2016-02-21 18:14:46', '30.98', 1000001, '56ca44d6670ac', 'PAY-2HN86436LB187733EK3FEJVY', 'YE5RGMG4NMVVC', '35676682MM6255924', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Remy Chaurand', ''),
317(1000091, 1000030, '2016-02-22 00:18:50', '53.97', 1000001, '56ca98e4bd39d', 'PAY-2C180889BV1380032K3FJRZI', 'YE5RGMG4NMVVC', '0P698226GX958770R', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Remy Chaurand', ''),
318(1000092, 1000033, '2016-02-22 13:45:05', '71.20', 1000001, '56cb5714bb751', 'PAY-3WH69827P07331006K3FVOFI', 'HS4E3Q23NYXP2', '13K96040AP378761E', NULL, 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccoia', ''),
319(1000093, 1000033, '2016-02-22 21:22:36', '36.73', 1000001, '56cbc252e7219', 'PAY-6TJ84890T6598631BK3F4EUY', 'HS4E3Q23NYXP2', '4MP435654C997721T', '2016-02-22 21:25:15', 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccoia', '45345345345435435435'),
320(1000094, 1000030, '2016-02-24 10:46:19', '122.68', 1000003, '56cdcfda29f15', 'PAY-9GR7893356847484RK3G47YY', 'YE5RGMG4NMVVC', '39X029198H828914X', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Remy Chaurand', ''),
321(1000095, 1000033, '2016-02-28 18:09:57', '36.73', 1000001, '56d37e2a02b9e', 'PAY-7U588242J28646423K3JX4KY', 'HS4E3Q23NYXP2', '66462130FP485511M', '2016-02-28 19:05:31', 'godlyaesthetics-buyer2@hotmail.com', 'Domenic Seccareccoia', 'TEST123'),
322(1000096, 1000023, '2016-03-02 20:10:05', '30.97', 1000001, '56d78ec11417b', 'PAY-1ND33396FJ6254704K3LY5QI', 'YE5RGMG4NMVVC', '7HM75266G7829174M', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
323(1000097, 1000030, '2016-03-20 17:05:14', '117.18', 1000001, '56ef1016c9fa5', 'PAY-856312879C068232AK3XRAGA', 'YE5RGMG4NMVVC', '8N3424202J018482F', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Remy Chaurand', ''),
324(1000098, 1000030, '2016-03-23 14:03:50', '105.68', 1000001, '56f2da5e83af6', 'PAY-9C171592JD0398250K3ZNUXY', 'YE5RGMG4NMVVC', '15M88683V8395983D', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Remy Chaurand', ''),
325(1000099, 1000030, '2016-04-21 19:34:28', '48.22', 1000001, '57196340844d2', 'PAY-038659663N746225PK4MWGQI', 'YE5RGMG4NMVVC', '2W1426184W6625526', NULL, 'godlyaesthetics-buyer@hotmail.com', 'Remy Chaurand', ''),
326(1000100, 1000023, '2016-05-06 21:18:37', '134.39', 1000001, '572d42518216f', 'PAY-3M985810WY7814607K4WUEUY', 'YE5RGMG4NMVVC', '6GL15302H1914480K', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', ''),
327(1000101, 1000023, '2016-05-16 15:33:53', '19.49', 1000001, '573a2054ed8c8', 'PAY-4UX76985GC5925456K45CAVQ', 'YE5RGMG4NMVVC', '73975340J2720181V', NULL, 'godlyaesthetics-buyer@hotmail.com', 'John Cena', '');
328
329-- --------------------------------------------------------
330
331--
332-- Table structure for table `INVOICEDETAIL`
333--
334
335CREATE TABLE IF NOT EXISTS `INVOICEDETAIL` (
336 `INVOICE_ID` int(11) NOT NULL,
337 `INV_ID` int(11) NOT NULL,
338 `INVOICE_DETAIL_PRICE` decimal(5,2) NOT NULL,
339 `QTY` smallint(6) NOT NULL,
340 `STATUS_ID` varchar(15) NOT NULL,
341 PRIMARY KEY (`INVOICE_ID`,`INV_ID`),
342 KEY `INVOICEDETAIL_INVENTORY_ID_FK` (`INV_ID`),
343 KEY `STATUS_STATUS_ID_FK` (`STATUS_ID`)
344) ENGINE=InnoDB DEFAULT CHARSET=latin1;
345
346--
347-- Dumping data for table `INVOICEDETAIL`
348--
349
350INSERT INTO `INVOICEDETAIL` (`INVOICE_ID`, `INV_ID`, `INVOICE_DETAIL_PRICE`, `QTY`, `STATUS_ID`) VALUES
351(1000028, 1000000, '19.99', 2, 'Cancelled'),
352(1000029, 1000000, '19.99', 2, 'Cancelled'),
353(1000030, 1000000, '19.99', 2, 'Cancelled'),
354(1000031, 1000000, '19.99', 2, 'Cancelled'),
355(1000032, 1000001, '19.99', 1, 'Paid'),
356(1000033, 1000001, '19.99', 2, 'Paid'),
357(1000034, 1000001, '19.99', 3, 'Paid'),
358(1000035, 1000001, '19.99', 1, 'Paid'),
359(1000036, 1000000, '19.99', 1, 'Paid'),
360(1000036, 1000001, '19.99', 1, 'Paid'),
361(1000037, 1000000, '19.99', 1, 'Paid'),
362(1000037, 1000001, '19.99', 1, 'Paid'),
363(1000038, 1000000, '19.99', 1, 'Paid'),
364(1000038, 1000002, '14.99', 1, 'Paid'),
365(1000039, 1000000, '19.99', 1, 'Cancelled'),
366(1000040, 1000000, '19.99', 1, 'Paid'),
367(1000041, 1000000, '19.99', 1, 'Paid'),
368(1000042, 1000001, '19.99', 1, 'Paid'),
369(1000043, 1000000, '19.99', 1, 'Paid'),
370(1000044, 1000001, '19.99', 1, 'Paid'),
371(1000044, 1000005, '19.99', 1, 'Paid'),
372(1000045, 1000000, '19.99', 30, 'Cancelled'),
373(1000046, 1000000, '19.99', 5, 'Cancelled'),
374(1000047, 1000000, '19.99', 5, 'Paid'),
375(1000048, 1000000, '19.99', 2, 'Paid'),
376(1000049, 1000000, '19.99', 5, 'Paid'),
377(1000050, 1000000, '19.99', 2, 'Paid'),
378(1000051, 1000000, '19.99', 5, 'Paid'),
379(1000052, 1000000, '19.99', 2, 'Paid'),
380(1000053, 1000000, '19.99', 5, 'Paid'),
381(1000054, 1000000, '19.99', 2, 'Paid'),
382(1000055, 1000000, '19.99', 5, 'Paid'),
383(1000056, 1000000, '19.99', 5, 'Paid'),
384(1000057, 1000000, '19.99', 2, 'Paid'),
385(1000058, 1000000, '19.99', 5, 'Paid'),
386(1000060, 1000000, '19.99', 5, 'Paid'),
387(1000061, 1000000, '19.99', 5, 'Paid'),
388(1000061, 1000001, '19.99', 10, 'Paid'),
389(1000062, 1000000, '19.99', 5, 'Paid'),
390(1000063, 1000001, '19.99', 1, 'Cancelled'),
391(1000064, 1000001, '19.99', 1, 'Cancelled'),
392(1000065, 1000001, '19.99', 1, 'Cancelled'),
393(1000066, 1000001, '19.99', 1, 'Paid'),
394(1000067, 1000001, '19.99', 1, 'Paid'),
395(1000068, 1000001, '19.99', 1, 'Paid'),
396(1000069, 1000001, '19.99', 1, 'Paid'),
397(1000070, 1000006, '9.99', 1, 'Cancelled'),
398(1000071, 1000006, '9.99', 1, 'Cancelled'),
399(1000072, 1000024, '24.99', 1, 'Cancelled'),
400(1000073, 1000006, '9.99', 1, 'Cancelled'),
401(1000074, 1000006, '9.99', 1, 'Paid'),
402(1000074, 1000019, '29.99', 3, 'Paid'),
403(1000075, 1000006, '9.99', 1, 'Paid'),
404(1000076, 1000006, '9.99', 1, 'Paid'),
405(1000077, 1000010, '14.99', 2, 'Paid'),
406(1000078, 1000009, '14.99', 1, 'Paid'),
407(1000079, 1000001, '19.99', 1, 'Paid'),
408(1000079, 1000007, '9.99', 1, 'Paid'),
409(1000080, 1000025, '19.99', 1, 'Paid'),
410(1000081, 1000000, '19.99', 1, 'Paid'),
411(1000082, 1000039, '24.99', 2, 'Paid'),
412(1000083, 1000005, '19.99', 3, 'Cancelled'),
413(1000083, 1000022, '14.99', 10, 'Cancelled'),
414(1000084, 1000001, '19.99', 2, 'Paid'),
415(1000084, 1000013, '14.99', 1, 'Paid'),
416(1000085, 1000001, '19.99', 3, 'Paid'),
417(1000085, 1000013, '14.99', 1, 'Paid'),
418(1000086, 1000001, '19.99', 1, 'Paid'),
419(1000086, 1000013, '14.99', 2, 'Paid'),
420(1000087, 1000013, '14.99', 2, 'Cancelled'),
421(1000087, 1000027, '14.99', 3, 'Cancelled'),
422(1000088, 1000000, '19.99', 1, 'Cancelled'),
423(1000088, 1000014, '4.99', 2, 'Cancelled'),
424(1000088, 1000027, '14.99', 1, 'Cancelled'),
425(1000089, 1000009, '14.99', 2, 'Paid'),
426(1000089, 1000013, '14.99', 1, 'Paid'),
427(1000089, 1000026, '29.99', 1, 'Paid'),
428(1000090, 1000005, '19.99', 1, 'Cancelled'),
429(1000091, 1000005, '19.99', 2, 'Paid'),
430(1000092, 1000037, '9.99', 1, 'Paid'),
431(1000092, 1000038, '19.99', 1, 'Paid'),
432(1000092, 1000039, '24.99', 1, 'Paid'),
433(1000093, 1000039, '24.99', 1, 'Cancelled'),
434(1000094, 1000004, '19.99', 3, 'Paid'),
435(1000094, 1000020, '24.99', 1, 'Paid'),
436(1000095, 1000039, '24.99', 1, 'Paid'),
437(1000096, 1000007, '9.99', 2, 'Cancelled'),
438(1000097, 1000030, '29.99', 3, 'Paid'),
439(1000097, 1000036, '4.99', 1, 'Paid'),
440(1000098, 1000025, '19.99', 3, 'Paid'),
441(1000098, 1000032, '24.99', 1, 'Paid'),
442(1000099, 1000007, '9.99', 1, 'Cancelled'),
443(1000099, 1000020, '24.99', 1, 'Cancelled'),
444(1000100, 1000020, '24.99', 2, 'Paid'),
445(1000100, 1000022, '14.99', 2, 'Paid'),
446(1000100, 1000037, '9.99', 3, 'Paid'),
447(1000101, 1000007, '9.99', 1, 'Cancelled');
448
449-- --------------------------------------------------------
450
451--
452-- Table structure for table `LOCATION`
453--
454
455CREATE TABLE IF NOT EXISTS `LOCATION` (
456 `LOC_ID` int(11) NOT NULL,
457 `SUP_ID` int(11) NOT NULL,
458 `LOC_STREET_ADDRESS` varchar(50) NOT NULL,
459 `LOC_CITY` varchar(30) NOT NULL,
460 `LOC_PROV` varchar(30) NOT NULL,
461 `LOC_COUNTRY` varchar(30) NOT NULL,
462 `LOC_POSTAL_CODE` varchar(6) NOT NULL,
463 PRIMARY KEY (`LOC_ID`),
464 KEY `LOCATION_SUP_ID_FK` (`SUP_ID`)
465) ENGINE=InnoDB DEFAULT CHARSET=latin1;
466
467-- --------------------------------------------------------
468
469--
470-- Table structure for table `MEMBER`
471--
472
473CREATE TABLE IF NOT EXISTS `MEMBER` (
474 `MEM_ID` int(11) NOT NULL AUTO_INCREMENT,
475 `MEM_EMAIL` varchar(50) DEFAULT NULL,
476 `MEM_PASSWORD` varchar(100) DEFAULT NULL,
477 `MEM_FIRST_NAME` varchar(30) DEFAULT NULL,
478 `MEM_LAST_NAME` varchar(30) DEFAULT NULL,
479 `MEM_STREET_ADDRESS` varchar(100) DEFAULT NULL,
480 `MEM_STREET_ADDRESS2` varchar(100) DEFAULT NULL,
481 `MEM_CITY` varchar(30) DEFAULT NULL,
482 `MEM_PROV` varchar(30) DEFAULT NULL,
483 `MEM_COUNTRY` varchar(30) DEFAULT NULL,
484 `MEM_POSTAL_CODE` varchar(7) DEFAULT NULL,
485 `MEM_GENDER` varchar(6) DEFAULT NULL,
486 `MEM_DOB` datetime DEFAULT NULL,
487 `MEM_REGISTER_DATE` datetime DEFAULT NULL,
488 PRIMARY KEY (`MEM_ID`)
489) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000035 ;
490
491--
492-- Dumping data for table `MEMBER`
493--
494
495INSERT INTO `MEMBER` (`MEM_ID`, `MEM_EMAIL`, `MEM_PASSWORD`, `MEM_FIRST_NAME`, `MEM_LAST_NAME`, `MEM_STREET_ADDRESS`, `MEM_STREET_ADDRESS2`, `MEM_CITY`, `MEM_PROV`, `MEM_COUNTRY`, `MEM_POSTAL_CODE`, `MEM_GENDER`, `MEM_DOB`, `MEM_REGISTER_DATE`) VALUES
496(1000022, 'afasfa@hotmail.com', '$2y$11$KVFjdTZDHcK/JM5GHC1.j.zmhq0vMspO9m2zUlXE4mprYTzKtBfEa', 'Domenic', 'Seccareccia', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E4E7', 'Female', '1986-03-02 00:00:00', '2015-12-23 02:12:11'),
497(1000023, 'johncena@wwe.com', '$2y$11$1p9ljsf/OMZ/sVq6iU1pB.3yhfzH20e9F/mXEm0twCF0cQ8LQYlsG', 'John', 'Cena', '938 Tom Drive', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Male', '1981-09-18 00:00:00', '2015-12-23 23:12:01'),
498(1000025, 'dom_seccareccia@hotmail.ca', '$2y$11$ODihFQT./hxAGPOCwkloiO9kFLc6rmd56uPSjrjHxz5K1iTbh7Ib.', 'Domenic', 'Seccareccia', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Male', '1926-06-04 00:00:00', '2016-02-14 21:12:11'),
499(1000026, 'dom_seccareccia@hotml.com', '$2y$11$g5CzXp2Z..K7d6AkvhYhC.zJ2I83klG2OVhCq7G27OgibXrdKnE4i', 'Domenic', 'Seccareccia', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Female', '1983-07-07 00:00:00', '2016-02-14 21:44:17'),
500(1000027, 'dom_seccacia@hotmail.com', '$2y$11$xIg9jlRvkjlA/s5fmJEXc.1c9ZrFQxM0HJVzUIBX5PTMP1HjNxHpK', 'Domenic', 'Seccareccia', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Male', '1904-03-08 00:00:00', '2016-02-14 21:46:26'),
501(1000028, 'dom_seca@hotmail.com', '$2y$11$snLernu7kTQtRPnhwe3K8uRztO.pzlimwV4ecEI63/nQUjL9KBsQS', 'Domenic', 'Seccareccia', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Female', '1993-04-03 00:00:00', '2016-02-14 21:47:27'),
502(1000029, 'oldmofo@oldmen.fr', '$2y$11$/MGHIB12o5XhacHHvw1xie4RrlS9.GnhHtlwpUeNestPPE8a5X5SO', 'Klive', 'Hinegan', '9330 Charleston', 'N/A', 'London', 'AB', 'Canada', 'J4Y 2K7', 'Male', '1936-02-14 00:00:00', '2016-02-15 21:34:55'),
503(1000030, 'remy.chaurand@hotmail.com', '$2y$11$vjkgaIpFBrskd2acf.aKO.yhG3o4RWgv/2uM0eSTiRz6f56/ABac2', 'Remy', 'Chaurand', '4045 rue Saint-Laurent', 'N/A', 'Toronto', 'ON', 'Canada', 'H1E 4E7', 'Male', '1995-10-27 00:00:00', '2016-02-16 08:17:33'),
504(1000031, 'gfg@hotmail.com', '$2y$11$CcTjcMRLNU9VfjlnNTY1tuDsYGNqEGkNOxOO86Ac8g3iqukW9hKAi', 'Domenic', 'Seccareccia', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Male', '1994-10-19 00:00:00', '2016-02-17 14:46:41'),
505(1000032, 'rdfdfc@hotmail.com', '$2y$11$LKERV4vHmJG9u/Z.G3x8ouPoP6J3t763UNipBl7CgyPkFrW6XmTzO', 'Domenic', 'Seccareccia', '12211 Leopold Houle', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Male', '1994-10-19 00:00:00', '2016-02-17 16:00:34'),
506(1000033, 'dom_seccareccia@hotmail.com', '$2y$11$B7gP2UEVGAn34boDierBQOh3GsdW.KGYXbBV12FwVM2jjYyRb.j7O', 'Domenic', 'Seccareccoia', 'rewrr ', 'N/A', 'Montreal', 'QC', 'Canada', 'H1E 4E7', 'Male', '1995-10-19 00:00:00', '2016-02-18 10:31:45'),
507(1000034, 'remy.chaurand@gmail.com', '$2y$11$tPQ3V/HFvD3C2AD3zOt.ue7RNogpRAaTzYpbyetvlFswYor9ZguUm', 'Remy', 'Catnip', '9823 Hickory Blvd', 'App. No. 16', 'Montreal', 'QC', 'Canada', 'J4Y 2K6', 'Male', '1995-10-27 00:00:00', '2016-02-19 19:25:37');
508
509-- --------------------------------------------------------
510
511--
512-- Table structure for table `PRODUCT`
513--
514
515CREATE TABLE IF NOT EXISTS `PRODUCT` (
516 `PROD_ID` int(11) NOT NULL,
517 `PROD_PRICE` decimal(5,2) NOT NULL,
518 `PROD_NAME` varchar(50) NOT NULL,
519 `PROD_DESC` varchar(255) NOT NULL,
520 `CAT_TITLE` varchar(30) NOT NULL,
521 `SUP_ID` int(11) NOT NULL,
522 `PROD_ARRIVAL` datetime NOT NULL,
523 `PROD_URL` varchar(100) NOT NULL,
524 `PROD_GENDER` char(1) NOT NULL,
525 PRIMARY KEY (`PROD_ID`),
526 KEY `PRODUCT_SUP_ID_FK` (`SUP_ID`),
527 KEY `PRODUCT_CAT_TITLE_FK` (`CAT_TITLE`)
528) ENGINE=InnoDB DEFAULT CHARSET=latin1;
529
530--
531-- Dumping data for table `PRODUCT`
532--
533
534INSERT INTO `PRODUCT` (`PROD_ID`, `PROD_PRICE`, `PROD_NAME`, `PROD_DESC`, `CAT_TITLE`, `SUP_ID`, `PROD_ARRIVAL`, `PROD_URL`, `PROD_GENDER`) VALUES
535(1000006, '9.99', 'Single/Taken/Gym Tee', '1000006.txt', 'Tees & Tanks', 1000001, '2016-01-04 19:00:00', 'images/men/tees-tanks/shirt1.png', 'M'),
536(1000007, '19.99', 'Proving You Wrong Tank Top', '1000007.txt', 'Tees & Tanks', 1000002, '2016-01-04 19:00:00', 'images/women/tees-tanks/proving.png', 'F'),
537(1000008, '14.99', 'It''s Ok, I''m Bulking! Tank Top', '1000008.txt', 'Tees & Tanks', 1000003, '2016-01-04 19:00:00', 'images/men/tees-tanks/bulking.png', 'M'),
538(1000009, '14.99', 'Mind Over Mind Tank Top', '1000009.txt', 'Tees & Tanks', 1000005, '2016-01-04 19:00:00', 'images/men/tees-tanks/mind.png', 'M'),
539(1000010, '9.99', 'I''d Flex Tee', '1000010.txt', 'Tees & Tanks', 1000003, '2016-01-07 00:00:00', 'images/men/tees-tanks/id_flex_shirt.jpg', 'M'),
540(1000011, '14.99', 'Lady In The Street Tank Top', '1000011.txt', 'Tees & Tanks', 1000003, '2016-01-07 00:00:00', 'images/women/tees-tanks/lady_in_street.jpg', 'F'),
541(1000012, '9.99', 'Sweat Is Fat Crying Tee', '1000012.txt', 'Tees & Tanks', 1000001, '2016-01-07 00:00:00', 'images/women/tees-tanks/sweat_is_fat_crying.jpg', 'F'),
542(1000013, '14.99', 'Wear Pink Wednesdays Tank Top', '1000013.txt', 'Tees & Tanks', 1000002, '2016-01-07 00:00:00', 'images/women/tees-tanks/wednesday_we_go_to_gym.jpg', 'F'),
543(1000014, '29.99', 'Eat Sleep Workout Hoodie', '1000014.txt', 'Hoodies', 1000001, '2016-01-11 00:00:00', 'images/men/hoodies/eat_sleep_workout.png', 'M'),
544(1000015, '24.99', 'The Only Bad Workout Hoodie', '1000015.txt', 'Hoodies', 1000002, '2016-01-11 00:00:00', 'images/men/hoodies/the_only_bad_workout.png', 'M'),
545(1000016, '49.99', 'My Warm Up Is Your Workout Hoodie', '1000016.txt', 'Hoodies', 1000003, '2016-01-11 00:00:00', 'images/men/hoodies/warm_up_is_your_workout.png', 'M'),
546(1000017, '19.99', 'Peak Performance Jacket', '1000017.txt', 'Jackets', 1000004, '2016-01-11 00:00:00', 'images/men/jackets/black_gold_main.png', 'M'),
547(1000018, '29.99', 'Caribou Track Jacket', '1000018.txt', 'Jackets', 1000002, '2016-01-11 00:00:00', 'images/men/jackets/caribou_track.png', 'M'),
548(1000019, '24.99', 'Rethel Jacket', '1000019.txt', 'Jackets', 1000003, '2016-01-11 00:00:00', 'images/men/jackets/rethel.png', 'M'),
549(1000020, '9.99', 'Resolution Fitness Stringer', '1000020.txt', 'Stringers', 1000003, '2016-01-11 00:00:00', 'images/men/stringers/black_vest.png', 'M'),
550(1000021, '14.99', 'Gold''s Gym Stringer', '1000021.txt', 'Stringers', 1000002, '2016-01-11 00:00:00', 'images/men/stringers/gym_men_muscle.png', 'M'),
551(1000022, '4.99', 'Protime Stringer', '1000022.txt', 'Stringers', 1000002, '2016-01-11 00:00:00', 'images/men/stringers/protime_stringer.png', 'M'),
552(1000023, '14.99', 'Soul Cycle Sweatpants', '1000023.txt', 'Sweatpants', 1000003, '2016-01-11 00:00:00', 'images/men/sweatpants/black_sundry.png', 'M'),
553(1000024, '14.99', 'Laced Sweatpants', '1000024.txt', 'Sweatpants', 1000004, '2016-01-11 00:00:00', 'images/men/sweatpants/laced_black.png', 'M'),
554(1000025, '24.99', 'Stradium Sweatpants', '1000025.txt', 'Sweatpants', 1000002, '2016-01-11 00:00:00', 'images/men/sweatpants/stradium_pant.jpg', 'M'),
555(1000026, '19.99', 'Le Capec Hoodie', '1000026.txt', 'Hoodies', 1000003, '2016-01-11 00:00:00', 'images/women/hoodies/pink_grey.jpg', 'F'),
556(1000027, '29.99', 'Regret That Workout Hoodie', '1000027.txt', 'Hoodies', 1000001, '2016-01-11 00:00:00', 'images/women/hoodies/regret_workout.png', 'F'),
557(1000028, '14.99', 'Your Workout Is My Warmup Hoodie', '1000028.txt', 'Hoodies', 1000004, '2016-01-11 00:00:00', 'images/women/hoodies/workout_is_my_warmup.png', 'F'),
558(1000029, '24.99', 'Arenite Jacket', '1000029.txt', 'Jackets', 1000002, '2016-01-11 00:00:00', 'images/women/jackets/arenite_jacket_wantilles_blue.png', 'F'),
559(1000030, '24.99', 'Leather Racer Jacket', '1000030.txt', 'Jackets', 1000003, '2016-01-11 00:00:00', 'images/women/jackets/grey_black.png', 'F'),
560(1000031, '29.99', 'Peak Perform Jacket', '1000031.txt', 'Jackets', 1000002, '2016-01-11 00:00:00', 'images/women/jackets/blue_grey_black.png', 'F'),
561(1000032, '19.99', 'Gore Running Legging', '1000032.txt', 'Leggings', 1000002, '2016-01-11 00:00:00', 'images/women/leggings/gore_running.jpg', 'F'),
562(1000033, '9.99', 'Helly Hansen Leggings', '1000033.txt', 'Leggings', 1000002, '2016-01-11 00:00:00', 'images/women/leggings/helly_hansen.png', 'F'),
563(1000034, '4.99', 'Space Leggings', '1000034.txt', 'Leggings', 1000001, '2016-01-11 00:00:00', 'images/women/leggings/pink_white_black.png', 'F'),
564(1000035, '19.99', 'Bride Wings Sweatpants', '1000035.txt', 'Sweatpants', 1000005, '2016-01-11 00:00:00', 'images/women/sweatpants/bride_wings_vector.png', 'F'),
565(1000036, '24.99', 'HTFU Sweatpants', '1000036.txt', 'Sweatpants', 1000002, '2016-01-11 00:00:00', 'images/women/sweatpants/htfu_bulging.png', 'F'),
566(1000037, '9.99', 'Prosper Sweatpants', '1000037.txt', 'Sweatpants', 1000003, '2016-01-11 00:00:00', 'images/women/sweatpants/prosper_sweats.png', 'F'),
567(1000038, '9.99', 'Heather Yoga Pants', '1000038.txt', 'Yoga Pants', 1000003, '2016-01-11 00:00:00', 'images/women/yoga-pants/heather.png', 'F'),
568(1000039, '19.99', 'Solita Yoga Pants', '1000039.txt', 'Yoga Pants', 1000003, '2016-01-11 00:00:00', 'images/women/yoga-pants/simple_yoga_pants.jpg', 'F'),
569(1000040, '24.99', 'Russell Yoga Pants', '1000040.txt', 'Yoga Pants', 1000003, '2016-01-11 00:00:00', 'images/women/yoga-pants/yoga_pants_grey.jpg', 'F');
570
571-- --------------------------------------------------------
572
573--
574-- Table structure for table `REFUND`
575--
576
577CREATE TABLE IF NOT EXISTS `REFUND` (
578 `REFUND_ID` int(11) NOT NULL AUTO_INCREMENT,
579 `PAYPAL_REFUND_ID` varchar(50) NOT NULL,
580 `REFUND_AMOUNT` decimal(7,2) NOT NULL,
581 `REFUND_SALE_ID` varchar(50) NOT NULL,
582 `REFUND_PAYMENT_ID` varchar(50) NOT NULL,
583 `INVOICE_ID` int(11) NOT NULL,
584 PRIMARY KEY (`REFUND_ID`),
585 KEY `REFUND_INVOICE_ID_FK` (`INVOICE_ID`)
586) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
587
588--
589-- Dumping data for table `REFUND`
590--
591
592INSERT INTO `REFUND` (`REFUND_ID`, `PAYPAL_REFUND_ID`, `REFUND_AMOUNT`, `REFUND_SALE_ID`, `REFUND_PAYMENT_ID`, `INVOICE_ID`) VALUES
593(3, '75R03952FP147123G', '53.18', '3GP875331P692861Y', 'PAY-61X75066CE1889841K2VJRJI', 1000028),
594(4, '1VP60220BD303482X', '53.18', '1FG315251D069181N', 'PAY-53B87379TY0578830K2VJUCQ', 1000029),
595(5, '4H7185835B338743H', '53.18', '44X421109Y356551F', 'PAY-3M421563LY375154WK2VJVAY', 1000030),
596(6, '8YE86381PT2472610', '53.18', '0HN76223BS163345F', 'PAY-4PW702837P2891722K2VJXAA', 1000031),
597(7, '64L60941P8895841W', '30.98', '22742531LG5322227', 'PAY-3HE18510FK938370TK22OFEA', 1000039),
598(8, '4WS498551R590532R', '637.69', '69310458FY110164T', 'PAY-1A3769439P071351AK26JMVI', 1000045),
599(9, '2BP900910U155410H', '122.92', '7P365760C13429506', 'PAY-3AK837209M975590XK26KEJY', 1000046),
600(10, '6MH31018VG0882103', '30.98', '9TM135078R042234H', 'PAY-9L172952FL671645WK26P4DY', 1000063),
601(11, '6CN250421K710715R', '30.59', '36A70041FF9647720', 'PAY-64K61320E3688723RK26QJJA', 1000064),
602(12, '52K342237K632773B', '30.39', '97081233H9456963T', 'PAY-3L1177574C147601MK26QMAY', 1000065),
603(13, '6FA47626N3974411P', '19.49', '0N241824UW0921208', 'PAY-8NS90776YR9798619K27HVEQ', 1000070),
604(14, '2S533077VG6939622', '36.24', '3S258011LL630423X', 'PAY-8034860203593212RK27H47I', 1000072),
605(15, '7LK56554WY7467457', '19.19', '7TF87269Y3050742K', 'PAY-1T238020GK599832FK27HZQY', 1000071),
606(16, '78C79509R85824029', '19.49', '6SU835939S8295607', 'PAY-2Y923684U9549935BK27H6NA', 1000073),
607(17, '5YW5456254844545X', '249.30', '77S337059F757634X', 'PAY-8S3365643X625403PK3BSJGI', 1000083),
608(18, '31B55912D59203327', '94.17', '6K7990545C1551644', 'PAY-8W205849WB0961906K3DDX7A', 1000087),
609(19, '8YC43607EA332205V', '59.69', '22732282D9730493E', 'PAY-16656916A8054642XK3D3MLY', 1000088),
610(20, '19Y10042H10251215', '30.98', '35676682MM6255924', 'PAY-2HN86436LB187733EK3FEJVY', 1000090),
611(21, '1X5572231S590754N', '36.73', '4MP435654C997721T', 'PAY-6TJ84890T6598631BK3F4EUY', 1000093),
612(22, '6L75684446831761P', '30.97', '7HM75266G7829174M', 'PAY-1ND33396FJ6254704K3LY5QI', 1000096),
613(23, '0U948269MP132435E', '48.22', '2W1426184W6625526', 'PAY-038659663N746225PK4MWGQI', 1000099),
614(24, '2K372132AH832464Y', '19.49', '73975340J2720181V', 'PAY-4UX76985GC5925456K45CAVQ', 1000101);
615
616-- --------------------------------------------------------
617
618--
619-- Table structure for table `RESETPASS`
620--
621
622CREATE TABLE IF NOT EXISTS `RESETPASS` (
623 `PASS_CODE` varchar(24) NOT NULL,
624 `MEM_ID` int(11) NOT NULL,
625 `EXPIRATION` datetime NOT NULL,
626 PRIMARY KEY (`PASS_CODE`),
627 KEY `RESETPASS_MEM_ID_FK` (`MEM_ID`)
628) ENGINE=InnoDB DEFAULT CHARSET=latin1;
629
630--
631-- Dumping data for table `RESETPASS`
632--
633
634INSERT INTO `RESETPASS` (`PASS_CODE`, `MEM_ID`, `EXPIRATION`) VALUES
635('91yyn1bkim1m694nrqv60nk6', 1000023, '2016-02-11 14:55:42');
636
637-- --------------------------------------------------------
638
639--
640-- Table structure for table `SHIPPING_TYPE`
641--
642
643CREATE TABLE IF NOT EXISTS `SHIPPING_TYPE` (
644 `SHIP_ID` int(11) NOT NULL,
645 `SHIP_TYPE` varchar(30) NOT NULL,
646 `SHIP_CARRIER` varchar(30) NOT NULL,
647 `SHIP_ETA` varchar(30) NOT NULL,
648 `SHIP_PRICE` decimal(4,2) NOT NULL,
649 PRIMARY KEY (`SHIP_ID`)
650) ENGINE=InnoDB DEFAULT CHARSET=latin1;
651
652--
653-- Dumping data for table `SHIPPING_TYPE`
654--
655
656INSERT INTO `SHIPPING_TYPE` (`SHIP_ID`, `SHIP_TYPE`, `SHIP_CARRIER`, `SHIP_ETA`, `SHIP_PRICE`) VALUES
657(1000001, 'Regular Ground ', 'Canada Post', '4-7 business days', '8.00'),
658(1000002, 'Xpresspost', 'Canada Post', '2-3 business days', '17.00'),
659(1000003, 'Priority', 'Canada Post', '1 business day', '25.00');
660
661-- --------------------------------------------------------
662
663--
664-- Table structure for table `STATUS`
665--
666
667CREATE TABLE IF NOT EXISTS `STATUS` (
668 `STATUS_ID` varchar(15) NOT NULL,
669 PRIMARY KEY (`STATUS_ID`)
670) ENGINE=InnoDB DEFAULT CHARSET=latin1;
671
672--
673-- Dumping data for table `STATUS`
674--
675
676INSERT INTO `STATUS` (`STATUS_ID`) VALUES
677('Cancelled'),
678('Paid'),
679('Refunded'),
680('Shipped');
681
682-- --------------------------------------------------------
683
684--
685-- Table structure for table `SUPPLIER`
686--
687
688CREATE TABLE IF NOT EXISTS `SUPPLIER` (
689 `SUP_ID` int(11) NOT NULL,
690 `SUP_NAME` varchar(30) NOT NULL,
691 PRIMARY KEY (`SUP_ID`)
692) ENGINE=InnoDB DEFAULT CHARSET=latin1;
693
694--
695-- Dumping data for table `SUPPLIER`
696--
697
698INSERT INTO `SUPPLIER` (`SUP_ID`, `SUP_NAME`) VALUES
699(1000001, 'American Apparel'),
700(1000002, 'Airwill Exports'),
701(1000003, 'Carlton Overseas'),
702(1000004, 'A CAP LTD'),
703(1000005, '3W Home Fashion Company');
704
705--
706-- Constraints for dumped tables
707--
708
709--
710-- Constraints for table `CART`
711--
712ALTER TABLE `CART`
713 ADD CONSTRAINT `CART_INV_ID_FK` FOREIGN KEY (`INV_ID`) REFERENCES `INVENTORY` (`INV_ID`),
714 ADD CONSTRAINT `CART_MEM_ID_FK` FOREIGN KEY (`MEM_ID`) REFERENCES `MEMBER` (`MEM_ID`);
715
716--
717-- Constraints for table `INVENTORY`
718--
719ALTER TABLE `INVENTORY`
720 ADD CONSTRAINT `INVENTORY_COLOR_ID_FK` FOREIGN KEY (`COLOR_ID`) REFERENCES `COLOR` (`COLOR_ID`),
721 ADD CONSTRAINT `INVENTORY_INV_SIZE_ID_FK` FOREIGN KEY (`INV_SIZE_ID`) REFERENCES `INVENTORY_SIZE` (`INV_SIZE_ID`),
722 ADD CONSTRAINT `INVENTORY_PROD_ID_FK` FOREIGN KEY (`PROD_ID`) REFERENCES `PRODUCT` (`PROD_ID`) ON DELETE CASCADE ON UPDATE CASCADE;
723
724--
725-- Constraints for table `INVOICE`
726--
727ALTER TABLE `INVOICE`
728 ADD CONSTRAINT `INVOICE_MEM_ID_FK` FOREIGN KEY (`MEM_ID`) REFERENCES `MEMBER` (`MEM_ID`),
729 ADD CONSTRAINT `INVOICE_SHIP_ID_FK` FOREIGN KEY (`SHIP_ID`) REFERENCES `SHIPPING_TYPE` (`SHIP_ID`);
730
731--
732-- Constraints for table `INVOICEDETAIL`
733--
734ALTER TABLE `INVOICEDETAIL`
735 ADD CONSTRAINT `INVOICEDETAIL_INVENTORY_ID_FK` FOREIGN KEY (`INV_ID`) REFERENCES `INVENTORY` (`INV_ID`),
736 ADD CONSTRAINT `INVOICEDETAIL_INVOICE_ID_FK` FOREIGN KEY (`INVOICE_ID`) REFERENCES `INVOICE` (`INVOICE_ID`),
737 ADD CONSTRAINT `STATUS_STATUS_ID_FK` FOREIGN KEY (`STATUS_ID`) REFERENCES `STATUS` (`STATUS_ID`);
738
739--
740-- Constraints for table `LOCATION`
741--
742ALTER TABLE `LOCATION`
743 ADD CONSTRAINT `LOCATION_SUP_ID_FK` FOREIGN KEY (`SUP_ID`) REFERENCES `SUPPLIER` (`SUP_ID`);
744
745--
746-- Constraints for table `PRODUCT`
747--
748ALTER TABLE `PRODUCT`
749 ADD CONSTRAINT `PRODUCT_CAT_TITLE_FK` FOREIGN KEY (`CAT_TITLE`) REFERENCES `CATEGORY` (`CAT_TITLE`),
750 ADD CONSTRAINT `PRODUCT_SUP_ID_FK` FOREIGN KEY (`SUP_ID`) REFERENCES `SUPPLIER` (`SUP_ID`);
751
752--
753-- Constraints for table `REFUND`
754--
755ALTER TABLE `REFUND`
756 ADD CONSTRAINT `REFUND_INVOICE_ID_FK` FOREIGN KEY (`INVOICE_ID`) REFERENCES `INVOICE` (`INVOICE_ID`);
757
758--
759-- Constraints for table `RESETPASS`
760--
761ALTER TABLE `RESETPASS`
762 ADD CONSTRAINT `RESETPASS_MEM_ID_FK` FOREIGN KEY (`MEM_ID`) REFERENCES `MEMBER` (`MEM_ID`);
763
764/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
765/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
766/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;