-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathorderingdb.sql
172 lines (142 loc) · 40.7 KB
/
orderingdb.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
-- phpMyAdmin SQL Dump
-- version 4.5.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 20, 2016 at 10:11 AM
-- Server version: 5.7.11
-- PHP Version: 5.6.19
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `orderingdb`
--
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `migrations`
--
INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2016_10_18_152534_create_products_table', 1),
('2016_10_18_165455_Users', 1),
('2016_10_20_070017_create_orders_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `orders`
--
CREATE TABLE `orders` (
`id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`user_id` int(11) NOT NULL,
`cart` text COLLATE utf8_unicode_ci NOT NULL,
`address` text COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`payment_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `orders`
--
INSERT INTO `orders` (`id`, `created_at`, `updated_at`, `user_id`, `cart`, `address`, `name`, `payment_id`) VALUES
(1, '2016-10-20 01:04:36', '2016-10-20 01:04:36', 2, 'O:8:"App\\Cart":3:{s:5:"items";a:3:{i:1;a:3:{s:3:"qty";i:1;s:5:"price";i:100;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:2;a:3:{s:3:"qty";i:3;s:5:"price";i:300;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:5;a:3:{s:3:"qty";i:1;s:5:"price";i:225;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:5;s:10:"created_at";s:19:"2016-10-20 08:41:07";s:10:"updated_at";s:19:"2016-10-20 08:41:07";s:9:"imagePath";s:67:"http://www.franklinbaker.com/wp-content/uploads/2015/01/DC15new.jpg";s:5:"title";s:15:"Creamed Coconut";s:11:"description";s:208:"Finely ground fresh coconut made using a proprietary and hygienic milling process. It is very versatile and cost effective especially where the full flavor, texture and rich aroma of pure coconut is required.";s:5:"price";i:225;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:5;s:10:"created_at";s:19:"2016-10-20 08:41:07";s:10:"updated_at";s:19:"2016-10-20 08:41:07";s:9:"imagePath";s:67:"http://www.franklinbaker.com/wp-content/uploads/2015/01/DC15new.jpg";s:5:"title";s:15:"Creamed Coconut";s:11:"description";s:208:"Finely ground fresh coconut made using a proprietary and hygienic milling process. It is very versatile and cost effective especially where the full flavor, texture and rich aroma of pure coconut is required.";s:5:"price";i:225;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}}s:8:"totalQty";i:5;s:10:"totalPrice";i:625;}', '27somethingVillage', 'Some Guy', 'ch_196cV2CipBpyEBDImrgIjYv7'),
(2, '2016-10-20 01:24:20', '2016-10-20 01:24:20', 2, 'O:8:"App\\Cart":3:{s:5:"items";a:6:{i:1;a:3:{s:3:"qty";i:1;s:5:"price";i:100;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:2;a:3:{s:3:"qty";i:2;s:5:"price";i:200;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:4;a:3:{s:3:"qty";i:1;s:5:"price";i:200;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:4;s:10:"created_at";s:19:"2016-10-20 08:40:17";s:10:"updated_at";s:19:"2016-10-20 08:40:17";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CF1new.jpg";s:5:"title";s:13:"Coconut Flour";s:11:"description";s:472:"An off white to cream coloured powder produced from the residue of desiccated coconut cake material after the extraction of VCO. It is a rich source of dietary fiber and has highest protein content of any flour. It also has a very low level of digestible carbohydrates which makes it an excellent choice for consumers who want to restrict their intake of carbohydrates. With a natural nutty coconut flavour, it is gluten free and most suitable for gluten restricted diets.";s:5:"price";i:200;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:4;s:10:"created_at";s:19:"2016-10-20 08:40:17";s:10:"updated_at";s:19:"2016-10-20 08:40:17";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CF1new.jpg";s:5:"title";s:13:"Coconut Flour";s:11:"description";s:472:"An off white to cream coloured powder produced from the residue of desiccated coconut cake material after the extraction of VCO. It is a rich source of dietary fiber and has highest protein content of any flour. It also has a very low level of digestible carbohydrates which makes it an excellent choice for consumers who want to restrict their intake of carbohydrates. With a natural nutty coconut flavour, it is gluten free and most suitable for gluten restricted diets.";s:5:"price";i:200;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:5;a:3:{s:3:"qty";i:1;s:5:"price";i:225;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:5;s:10:"created_at";s:19:"2016-10-20 08:41:07";s:10:"updated_at";s:19:"2016-10-20 08:41:07";s:9:"imagePath";s:67:"http://www.franklinbaker.com/wp-content/uploads/2015/01/DC15new.jpg";s:5:"title";s:15:"Creamed Coconut";s:11:"description";s:208:"Finely ground fresh coconut made using a proprietary and hygienic milling process. It is very versatile and cost effective especially where the full flavor, texture and rich aroma of pure coconut is required.";s:5:"price";i:225;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:5;s:10:"created_at";s:19:"2016-10-20 08:41:07";s:10:"updated_at";s:19:"2016-10-20 08:41:07";s:9:"imagePath";s:67:"http://www.franklinbaker.com/wp-content/uploads/2015/01/DC15new.jpg";s:5:"title";s:15:"Creamed Coconut";s:11:"description";s:208:"Finely ground fresh coconut made using a proprietary and hygienic milling process. It is very versatile and cost effective especially where the full flavor, texture and rich aroma of pure coconut is required.";s:5:"price";i:225;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:3;a:3:{s:3:"qty";i:1;s:5:"price";i:400;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:3;s:10:"created_at";s:19:"2016-10-20 08:39:16";s:10:"updated_at";s:19:"2016-10-20 08:39:16";s:9:"imagePath";s:63:"http://www.franklinbaker.com/wp-content/uploads/2015/01/VC1.jpg";s:5:"title";s:18:"Virgin Coconut Oil";s:11:"description";s:577:"Virgin Coconut Oil (VCO) is derived by the press from desiccated coconut or endosperm of a mature coconut, rather than the sundried coconut meat known as Copra. Virgin Coconut Oil is a colorless clear liquid with a perceptible coconut – nutty aroma. It is recognized to be the purest form of coconut oil, being chemical & additive free. At ambient condition (28 -32 deg C), the product is liquid and tends to solidify if stored below 25 deg C. Due to its many beneficial properties, it is used extensively in food, food supplements, dietary, culinary and beauty applications.";s:5:"price";i:400;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:3;s:10:"created_at";s:19:"2016-10-20 08:39:16";s:10:"updated_at";s:19:"2016-10-20 08:39:16";s:9:"imagePath";s:63:"http://www.franklinbaker.com/wp-content/uploads/2015/01/VC1.jpg";s:5:"title";s:18:"Virgin Coconut Oil";s:11:"description";s:577:"Virgin Coconut Oil (VCO) is derived by the press from desiccated coconut or endosperm of a mature coconut, rather than the sundried coconut meat known as Copra. Virgin Coconut Oil is a colorless clear liquid with a perceptible coconut – nutty aroma. It is recognized to be the purest form of coconut oil, being chemical & additive free. At ambient condition (28 -32 deg C), the product is liquid and tends to solidify if stored below 25 deg C. Due to its many beneficial properties, it is used extensively in food, food supplements, dietary, culinary and beauty applications.";s:5:"price";i:400;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:6;a:3:{s:3:"qty";i:1;s:5:"price";i:250;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:6;s:10:"created_at";s:19:"2016-10-20 08:42:00";s:10:"updated_at";s:19:"2016-10-20 08:42:00";s:9:"imagePath";s:83:"http://www.franklinbaker.com/wp-content/uploads/2014/11/31coconut-concentrate-a.jpg";s:5:"title";s:19:"Coconut Concentrate";s:11:"description";s:259:"Coconut Concentrate is a dehydrated coconut refined to a very fine particle with a semi-liquid consistency using a proprietary process which solidifies to a shortening-like paste. It is produced from full fat desiccated coconut with a natural and full flavor.";s:5:"price";i:250;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:6;s:10:"created_at";s:19:"2016-10-20 08:42:00";s:10:"updated_at";s:19:"2016-10-20 08:42:00";s:9:"imagePath";s:83:"http://www.franklinbaker.com/wp-content/uploads/2014/11/31coconut-concentrate-a.jpg";s:5:"title";s:19:"Coconut Concentrate";s:11:"description";s:259:"Coconut Concentrate is a dehydrated coconut refined to a very fine particle with a semi-liquid consistency using a proprietary process which solidifies to a shortening-like paste. It is produced from full fat desiccated coconut with a natural and full flavor.";s:5:"price";i:250;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}}s:8:"totalQty";i:7;s:10:"totalPrice";i:1375;}', '27somethingVillage', 'Some Guy', 'ch_196co7CipBpyEBDIdzADjLK5'),
(3, '2016-10-20 01:32:03', '2016-10-20 01:32:03', 2, 'O:8:"App\\Cart":3:{s:5:"items";a:3:{i:1;a:3:{s:3:"qty";i:2;s:5:"price";i:200;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:4;a:3:{s:3:"qty";i:2;s:5:"price";i:400;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:4;s:10:"created_at";s:19:"2016-10-20 08:40:17";s:10:"updated_at";s:19:"2016-10-20 08:40:17";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CF1new.jpg";s:5:"title";s:13:"Coconut Flour";s:11:"description";s:472:"An off white to cream coloured powder produced from the residue of desiccated coconut cake material after the extraction of VCO. It is a rich source of dietary fiber and has highest protein content of any flour. It also has a very low level of digestible carbohydrates which makes it an excellent choice for consumers who want to restrict their intake of carbohydrates. With a natural nutty coconut flavour, it is gluten free and most suitable for gluten restricted diets.";s:5:"price";i:200;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:4;s:10:"created_at";s:19:"2016-10-20 08:40:17";s:10:"updated_at";s:19:"2016-10-20 08:40:17";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CF1new.jpg";s:5:"title";s:13:"Coconut Flour";s:11:"description";s:472:"An off white to cream coloured powder produced from the residue of desiccated coconut cake material after the extraction of VCO. It is a rich source of dietary fiber and has highest protein content of any flour. It also has a very low level of digestible carbohydrates which makes it an excellent choice for consumers who want to restrict their intake of carbohydrates. With a natural nutty coconut flavour, it is gluten free and most suitable for gluten restricted diets.";s:5:"price";i:200;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:5;a:3:{s:3:"qty";i:1;s:5:"price";i:225;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:5;s:10:"created_at";s:19:"2016-10-20 08:41:07";s:10:"updated_at";s:19:"2016-10-20 08:41:07";s:9:"imagePath";s:67:"http://www.franklinbaker.com/wp-content/uploads/2015/01/DC15new.jpg";s:5:"title";s:15:"Creamed Coconut";s:11:"description";s:208:"Finely ground fresh coconut made using a proprietary and hygienic milling process. It is very versatile and cost effective especially where the full flavor, texture and rich aroma of pure coconut is required.";s:5:"price";i:225;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:5;s:10:"created_at";s:19:"2016-10-20 08:41:07";s:10:"updated_at";s:19:"2016-10-20 08:41:07";s:9:"imagePath";s:67:"http://www.franklinbaker.com/wp-content/uploads/2015/01/DC15new.jpg";s:5:"title";s:15:"Creamed Coconut";s:11:"description";s:208:"Finely ground fresh coconut made using a proprietary and hygienic milling process. It is very versatile and cost effective especially where the full flavor, texture and rich aroma of pure coconut is required.";s:5:"price";i:225;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}}s:8:"totalQty";i:5;s:10:"totalPrice";i:825;}', 'sadsafgsad21321312', 'Some Guy', 'ch_196cvbCipBpyEBDIFQabFm2d'),
(4, '2016-10-20 02:05:43', '2016-10-20 02:05:43', 3, 'O:8:"App\\Cart":3:{s:5:"items";a:1:{i:2;a:3:{s:3:"qty";i:1;s:5:"price";i:100;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}}s:8:"totalQty";i:1;s:10:"totalPrice";i:100;}', 'sadsafgsad21321312', 'Some Guy', 'ch_196dSBCipBpyEBDIfqiKVHaP'),
(5, '2016-10-20 02:09:53', '2016-10-20 02:09:53', 1, 'O:8:"App\\Cart":3:{s:5:"items";a:2:{i:1;a:3:{s:3:"qty";i:2;s:5:"price";i:200;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:1;s:10:"created_at";s:19:"2016-10-20 08:37:41";s:10:"updated_at";s:19:"2016-10-20 08:37:41";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg";s:5:"title";s:29:"Single Strength Coconut Water";s:11:"description";s:396:"Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}i:2;a:3:{s:3:"qty";i:1;s:5:"price";i:100;s:4:"item";O:11:"App\\Product":24:{s:11:"\0*\0fillable";a:5:{i:0;s:9:"imagePath";i:1;s:5:"title";i:2;s:11:"description";i:3;s:5:"price";i:4;s:4:"item";}s:13:"\0*\0connection";N;s:8:"\0*\0table";N;s:13:"\0*\0primaryKey";s:2:"id";s:10:"\0*\0keyType";s:3:"int";s:10:"\0*\0perPage";i:15;s:12:"incrementing";b:1;s:10:"timestamps";b:1;s:13:"\0*\0attributes";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:11:"\0*\0original";a:8:{s:2:"id";i:2;s:10:"created_at";s:19:"2016-10-20 08:38:20";s:10:"updated_at";s:19:"2016-10-20 08:38:20";s:9:"imagePath";s:66:"http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg";s:5:"title";s:25:"Coconut Water Concentrate";s:11:"description";s:435:"Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink";s:5:"price";i:100;s:6:"amount";i:0;}s:12:"\0*\0relations";a:0:{}s:9:"\0*\0hidden";a:0:{}s:10:"\0*\0visible";a:0:{}s:10:"\0*\0appends";a:0:{}s:10:"\0*\0guarded";a:1:{i:0;s:1:"*";}s:8:"\0*\0dates";a:0:{}s:13:"\0*\0dateFormat";N;s:8:"\0*\0casts";a:0:{}s:10:"\0*\0touches";a:0:{}s:14:"\0*\0observables";a:0:{}s:7:"\0*\0with";a:0:{}s:13:"\0*\0morphClass";N;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;}}}s:8:"totalQty";i:3;s:10:"totalPrice";i:300;}', 'sadsafgsad21321312', 'Some Guy', 'ch_196dWDCipBpyEBDIGlgRszio');
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE `products` (
`id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`imagePath` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`price` int(11) NOT NULL,
`amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`id`, `created_at`, `updated_at`, `imagePath`, `title`, `description`, `price`, `amount`) VALUES
(1, '2016-10-20 00:37:41', '2016-10-20 00:37:41', 'http://www.franklinbaker.com/wp-content/uploads/2015/01/CW2new.jpg', 'Single Strength Coconut Water', 'Is the regular strength version of pure, filtered coconut water extracted from fresh coconuts, and is a clear, to slightly cloudy liquid and free from extraneous materials. The characteristic of natural coconut water are a refreshing, slightly sweet and nutty natural taste. Used as a hydrating drink, coconut water helps to replenish fluids and minerals long during prolonged physical activity.', 100, 0),
(2, '2016-10-20 00:38:20', '2016-10-20 00:38:20', 'http://www.franklinbaker.com/wp-content/uploads/2015/01/CW3new.jpg', 'Coconut Water Concentrate', 'Coconut Water Concentrate is a highly concentrated, slight cloudy but transparent liquid. It is the end product of concentrating the naturally occurring liquid endosperms (coconut water) of fresh, mature Philippine coconuts before undergoing an HTST pasteurization process. Coconut Water Concentrate is intended for food and beverage manufacturers that require the distinct flavor of natural fresh coconut in a low calorie health drink', 100, 0),
(3, '2016-10-20 00:39:16', '2016-10-20 00:39:16', 'http://www.franklinbaker.com/wp-content/uploads/2015/01/VC1.jpg', 'Virgin Coconut Oil', 'Virgin Coconut Oil (VCO) is derived by the press from desiccated coconut or endosperm of a mature coconut, rather than the sundried coconut meat known as Copra. Virgin Coconut Oil is a colorless clear liquid with a perceptible coconut – nutty aroma. It is recognized to be the purest form of coconut oil, being chemical & additive free. At ambient condition (28 -32 deg C), the product is liquid and tends to solidify if stored below 25 deg C. Due to its many beneficial properties, it is used extensively in food, food supplements, dietary, culinary and beauty applications.', 400, 0),
(4, '2016-10-20 00:40:17', '2016-10-20 00:40:17', 'http://www.franklinbaker.com/wp-content/uploads/2015/01/CF1new.jpg', 'Coconut Flour', 'An off white to cream coloured powder produced from the residue of desiccated coconut cake material after the extraction of VCO. It is a rich source of dietary fiber and has highest protein content of any flour. It also has a very low level of digestible carbohydrates which makes it an excellent choice for consumers who want to restrict their intake of carbohydrates. With a natural nutty coconut flavour, it is gluten free and most suitable for gluten restricted diets.', 200, 0),
(5, '2016-10-20 00:41:07', '2016-10-20 00:41:07', 'http://www.franklinbaker.com/wp-content/uploads/2015/01/DC15new.jpg', 'Creamed Coconut', 'Finely ground fresh coconut made using a proprietary and hygienic milling process. It is very versatile and cost effective especially where the full flavor, texture and rich aroma of pure coconut is required.', 225, 0),
(6, '2016-10-20 00:42:00', '2016-10-20 00:42:00', 'http://www.franklinbaker.com/wp-content/uploads/2014/11/31coconut-concentrate-a.jpg', 'Coconut Concentrate', 'Coconut Concentrate is a dehydrated coconut refined to a very fine particle with a semi-liquid consistency using a proprietary process which solidifies to a shortening-like paste. It is produced from full fat desiccated coconut with a natural and full flavor.', 250, 0);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`contact` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`address` text COLLATE utf8_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `created_at`, `updated_at`, `email`, `password`, `first_name`, `last_name`, `contact`, `address`, `remember_token`) VALUES
(1, '2016-10-20 01:00:14', '2016-10-20 02:10:06', '[email protected]', '$2y$10$uT6QZo/tHLWi0vGMP1RAjuni8qhJC8bLUkiVtlC5plLfm9w1yeAay', '', '', '', 'sadsafgsad21321312', 'JNoXPuW9mpSEsu8ZiCH6qfXrV0sL4w9z4upmVQftki5nrZ7Va3PqAHZTaUBR'),
(2, '2016-10-20 01:03:55', '2016-10-20 02:02:05', '[email protected]', '$2y$10$5ZtNdAL3paiGMlGyhKKQXe9wPif24fSJZaeAMCWS1RLyiZuU5DU0C', '', '', '', '27somethingVillage', 'HYKViZxgSpWzfH43lASAEBhUHb7rBisngiZui9gVLoLPMWGzU5FWPITls8XJ'),
(3, '2016-10-20 02:02:28', '2016-10-20 02:05:49', '[email protected]', '$2y$10$1RAcyKFmuWWHt2Hvs949ROh9VNFsvyeuxMCEXJzkojBMnVvgpA3YO', '', '', '', 'sadsafgsad21321312', 'nNYhQ94oljzwmr8fdyqlyi0UfZ7YZbwNB89i6mo42nVSVC8xuAVDLf0i9aja');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;