· 8 years ago · Jun 28, 2018, 09:28 PM
1----------------------------------------------------------------------------------------------------------------
2
3____ __. .__ .__ _________ .__ __
4| |/ _|____ | |___ _|__| ____ / _____/ ____ ____ __ _________|__|/ |_ ___.__.
5| <_/ __ | | / / |/ _____ _/ __ _/ ___| | _ __ __< | |
6| | ___/| |_ /| | | / ___/ ___| | /| | / || | ___ |
7|____|__ ___ >____/_/ |__|___| /_______ /___ >___ >____/ |__| |__||__| / ____|
8 / / / / / / /
9--- contact:https://www.facebook.com/pages/KelvinSecurity/1470285456587684
10
11
12----- больш ---------------------------------------------------------------------------------------------------------------
13Што Kelvinsecurity? -Milw0rm- -KelvinSecurity- //1995//1996//2016
14
15
16Kelvinsecurity з'ÑўлÑецца хакер твар шукае збору інфармацыі вÑлікіх людзей па ÑžÑім Ñвеце, падлучаных да Ñеткі, Ñ– ÑžÑ€Ð°Ð·Ð»Ñ–Ð²Ñ‹Ñ Ð´Ð° гÑÑ‚Ñ‹Ñ… платформах.
17
18 Follow In twitter > @nationgoverment
19 EMAIL_CONTACT: > KelvinseZurity@3g2upl4pq6kufc4m.onion
20----------------------------------------------------------------------------------------------------------------
21
22-- phpMyAdmin SQL Dump
23-- version 4.0.10deb1
24-- http://www.phpmyadmin.net
25--
26-- Host: localhost
27-- Generation Time: Feb 03, 2017 at 07:50 PM
28-- Server version: 5.5.50-0ubuntu0.14.04.1
29-- PHP Version: 5.5.9-1ubuntu4.19
30
31SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
32SET time_zone = "+00:00";
33
34
35/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
36/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
37/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
38/*!40101 SET NAMES utf8 */;
39
40--
41-- Database: `oyaoya`
42--
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `discount_types`
48--
49
50CREATE TABLE IF NOT EXISTS `discount_types` (
51 `discount_type_id` bigint(20) NOT NULL AUTO_INCREMENT,
52 `discount_type_name` varchar(255) NOT NULL,
53 `description` longtext,
54 `created_at` datetime NOT NULL,
55 `updated_at` datetime DEFAULT NULL,
56 `deleted_at` datetime DEFAULT NULL,
57 PRIMARY KEY (`discount_type_id`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
59
60--
61-- Dumping data for table `discount_types`
62--
63
64INSERT INTO `discount_types` (`discount_type_id`, `discount_type_name`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
65(1, 'Fixed amount discount', 'No', '2016-05-17 00:00:00', NULL, NULL),
66(2, 'per product discount', 'No', '2016-05-17 00:00:00', NULL, '2016-10-26 00:00:00'),
67(3, 'buy x get y free', 'No', '2016-05-17 00:00:00', NULL, '2016-10-09 00:00:00'),
68(4, 'Staff discount', 'No', '2016-05-17 00:00:00', NULL, NULL);
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `keys`
74--
75
76CREATE TABLE IF NOT EXISTS `keys` (
77 `id` int(11) NOT NULL AUTO_INCREMENT,
78 `key` varchar(40) NOT NULL,
79 `user_id` int(11) NOT NULL,
80 `user_type` tinyint(5) NOT NULL DEFAULT '1',
81 `level` int(2) NOT NULL,
82 `ignore_limits` tinyint(1) NOT NULL DEFAULT '0',
83 `is_private_key` tinyint(1) NOT NULL DEFAULT '0',
84 `ip_addresses` text,
85 `created_at` datetime DEFAULT NULL,
86 `updated_at` datetime DEFAULT NULL,
87 `deleted_at` datetime DEFAULT NULL,
88 PRIMARY KEY (`id`)
89) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;
90
91--
92-- Dumping data for table `keys`
93--
94
95INSERT INTO `keys` (`id`, `key`, `user_id`, `user_type`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `created_at`, `updated_at`, `deleted_at`) VALUES
96(1, '695', 29, 1, 0, 0, 0, NULL, '2016-11-19 12:08:17', NULL, NULL),
97(2, '507', 30, 1, 0, 0, 0, NULL, '2016-11-19 12:24:06', NULL, NULL),
98(4, '671', 32, 1, 0, 0, 0, NULL, '2016-11-19 12:27:11', NULL, NULL),
99(5, '369', 33, 1, 0, 0, 0, NULL, '2016-11-26 10:28:39', NULL, NULL),
100(6, '746', 34, 1, 0, 0, 0, NULL, '2016-11-26 10:32:14', '2016-11-30 11:43:18', NULL),
101(7, '927', 35, 1, 0, 0, 0, NULL, '2016-11-28 18:22:08', NULL, NULL),
102(8, '915', 36, 1, 0, 0, 0, NULL, '2016-11-28 18:25:06', NULL, NULL),
103(9, '265', 37, 1, 0, 0, 0, NULL, '2016-11-28 18:26:58', NULL, NULL),
104(10, '131', 35, 1, 0, 0, 0, NULL, '2016-11-30 16:49:24', NULL, NULL),
105(11, '965', 36, 1, 0, 0, 0, NULL, '2016-11-30 16:50:16', NULL, NULL),
106(12, '145', 37, 1, 0, 0, 0, NULL, '2016-11-30 16:51:54', NULL, NULL),
107(13, '166', 38, 1, 0, 0, 0, NULL, '2016-11-30 16:52:25', NULL, NULL),
108(14, '668', 39, 1, 0, 0, 0, NULL, '2016-11-30 16:54:28', '2016-12-15 14:08:00', NULL),
109(15, '493', 40, 1, 0, 0, 0, NULL, '2016-12-06 08:37:03', '2016-12-09 06:51:56', NULL),
110(16, '763', 41, 1, 0, 0, 0, NULL, '2016-12-09 06:43:54', '2016-12-10 08:40:28', NULL),
111(17, '699', 42, 1, 0, 0, 0, NULL, '2016-12-09 14:48:38', '2016-12-14 07:56:50', NULL),
112(18, '105', 43, 1, 0, 0, 0, NULL, '2016-12-09 14:48:40', NULL, NULL),
113(19, '996', 44, 1, 0, 0, 0, NULL, '2016-12-13 06:54:17', NULL, NULL),
114(20, '263', 45, 1, 0, 0, 0, NULL, '2016-12-13 07:10:15', NULL, NULL),
115(21, '778', 46, 1, 0, 0, 0, NULL, '2016-12-13 07:10:57', NULL, NULL),
116(22, '155', 47, 1, 0, 0, 0, NULL, '2016-12-13 07:36:55', '2016-12-13 14:19:19', NULL),
117(23, '233', 48, 1, 0, 0, 0, NULL, '2016-12-15 12:15:25', NULL, NULL),
118(24, '668', 49, 1, 0, 0, 0, NULL, '2016-12-15 12:25:30', NULL, NULL),
119(25, '473', 50, 1, 0, 0, 0, NULL, '2016-12-15 12:27:41', NULL, NULL),
120(26, '671', 51, 1, 0, 0, 0, NULL, '2016-12-15 12:29:09', NULL, NULL),
121(27, '348', 52, 1, 0, 0, 0, NULL, '2016-12-15 12:31:06', NULL, NULL),
122(28, '701', 53, 1, 0, 0, 0, NULL, '2016-12-15 12:35:40', NULL, NULL),
123(29, '224', 54, 1, 0, 0, 0, NULL, '2016-12-15 12:36:38', NULL, NULL),
124(30, '382', 55, 1, 0, 0, 0, NULL, '2016-12-15 12:39:59', NULL, NULL),
125(31, '272', 56, 1, 0, 0, 0, NULL, '2016-12-15 12:41:23', NULL, NULL),
126(32, '791', 57, 1, 0, 0, 0, NULL, '2016-12-15 12:46:30', NULL, NULL),
127(33, '526', 58, 1, 0, 0, 0, NULL, '2016-12-15 12:48:14', NULL, NULL),
128(34, '927', 59, 1, 0, 0, 0, NULL, '2016-12-15 12:52:48', NULL, NULL),
129(35, '926', 60, 1, 0, 0, 0, NULL, '2016-12-15 12:55:14', NULL, NULL),
130(36, '645', 61, 1, 0, 0, 0, NULL, '2016-12-15 13:00:29', NULL, NULL),
131(37, '164', 62, 1, 0, 0, 0, NULL, '2016-12-15 13:01:14', NULL, NULL),
132(38, '865', 63, 1, 0, 0, 0, NULL, '2016-12-15 13:04:37', NULL, NULL),
133(39, '8bb0761f57f6ee7e5abdbbec35912229', 64, 1, 0, 0, 0, NULL, '2016-12-15 13:15:00', NULL, NULL),
134(40, 'cfb705f04fab83927ce9c85c4e88e227', 65, 1, 0, 0, 0, NULL, '2016-12-15 13:32:31', NULL, NULL),
135(41, '07e645bcb22ddc65db960fedb59db34d', 66, 1, 0, 0, 0, NULL, '2016-12-15 13:49:21', NULL, NULL),
136(42, '999350d037ea93fbc6f4ed3a0c271304', 67, 1, 0, 0, 0, NULL, '2016-12-15 14:09:30', NULL, NULL),
137(43, '2b097640e7a7b1f000d09404a4ea7c73', 68, 1, 0, 0, 0, NULL, '2016-12-15 14:10:48', NULL, NULL),
138(44, '1cb5b52a81379e2a3baebb9205af0590', 69, 1, 0, 0, 0, NULL, '2016-12-15 14:15:12', NULL, NULL),
139(45, 'e9e42821ee97c9319d01a2f0ab3df97b', 70, 1, 0, 0, 0, NULL, '2016-12-15 14:23:29', NULL, NULL),
140(46, 'a80e6ffb9756e1f59a14955833431c7c', 71, 1, 0, 0, 0, NULL, '2016-12-15 14:26:06', NULL, NULL),
141(47, '926ac8701e93189c390be6b004928a1a', 72, 1, 0, 0, 0, NULL, '2016-12-15 15:15:16', NULL, NULL),
142(48, '5c2fdb3965e269d8b6cdd42c1cea5fe7', 73, 1, 0, 0, 0, NULL, '2016-12-15 15:31:09', NULL, NULL),
143(49, '3d1f1abd391229f449822ab0ca4d65e0', 74, 1, 0, 0, 0, NULL, '2016-12-15 15:39:04', NULL, NULL),
144(50, '75ba63d6c30adbfeb1a92e43ae7c2f76', 75, 1, 0, 0, 0, NULL, '2016-12-15 15:41:42', NULL, NULL),
145(51, '1fcf7614e9288c88195df74095c7cf40', 76, 1, 0, 0, 0, NULL, '2016-12-15 16:13:25', NULL, NULL),
146(52, '47c3aaf64780a1ae93e94b63012ee91f', 77, 1, 0, 0, 0, NULL, '2016-12-15 18:31:56', NULL, NULL),
147(55, '6477ab50a0f481553510e418aa094b02', 5, 1, 0, 0, 0, NULL, '2017-02-01 13:22:20', NULL, NULL),
148(56, '6d75a6e1806bb1d0173fe2fbfc7be585', 6, 1, 0, 0, 0, NULL, '2017-02-01 13:24:53', NULL, NULL),
149(57, '961', 7, 1, 0, 0, 0, NULL, '2017-02-01 15:21:17', '2017-02-01 19:36:22', NULL),
150(58, '249383f9e28a3ab5fbd9c18eaeaeae0f', 1, 3, 0, 0, 0, NULL, '2017-02-01 17:12:38', '2017-02-03 15:57:29', NULL),
151(59, '0ebbac5c1a2b9397d872a24731f22b66', 2, 1, 0, 0, 0, NULL, '2017-02-01 17:14:11', NULL, NULL),
152(60, '249383f9e28a3ab5fbd9c18eaeaeae0f', 1, 3, 0, 0, 0, NULL, '2017-02-01 18:26:51', '2017-02-03 15:57:29', NULL),
153(61, '249383f9e28a3ab5fbd9c18eaeaeae0f', 1, 3, 0, 0, 0, NULL, '2017-02-02 12:56:01', '2017-02-03 15:57:29', NULL),
154(62, '8da094ecc4481927b763a7aa8784e037', 2, 1, 0, 0, 0, NULL, '2017-02-02 13:02:49', NULL, NULL),
155(63, 'd2ea3cfa0a7db572edfb5ff17bab27d2', 3, 1, 0, 0, 0, NULL, '2017-02-02 13:16:54', NULL, NULL),
156(64, '2a9cdf40f46f92a16715693debd26d74', 4, 1, 0, 0, 0, NULL, '2017-02-02 14:35:11', NULL, NULL),
157(65, 'bc664317c98ea49bf318babf7ccee331', 5, 1, 0, 0, 0, NULL, '2017-02-02 20:14:04', NULL, NULL),
158(66, '249383f9e28a3ab5fbd9c18eaeaeae0f', 1, 3, 0, 0, 0, NULL, '2017-02-03 11:38:39', '2017-02-03 15:57:29', NULL),
159(67, '19d16eebd4e8e9226ec9bfa67e90b14b', 2, 1, 0, 0, 0, NULL, '2017-02-03 12:42:58', NULL, NULL),
160(68, '838ba8b0e34075b118c8da19f6201362', 3, 1, 0, 0, 0, NULL, '2017-02-03 14:50:22', NULL, NULL);
161
162-- --------------------------------------------------------
163
164--
165-- Table structure for table `oy_admins`
166--
167
168CREATE TABLE IF NOT EXISTS `oy_admins` (
169 `admin_id` int(11) NOT NULL AUTO_INCREMENT,
170 `name` varchar(30) NOT NULL,
171 `email_id` varchar(50) NOT NULL,
172 `password` varchar(100) NOT NULL,
173 `created_at` datetime DEFAULT NULL,
174 `updated_at` datetime DEFAULT NULL,
175 `deleted_at` datetime DEFAULT NULL,
176 PRIMARY KEY (`admin_id`)
177) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
178
179--
180-- Dumping data for table `oy_admins`
181--
182
183INSERT INTO `oy_admins` (`admin_id`, `name`, `email_id`, `password`, `created_at`, `updated_at`, `deleted_at`) VALUES
184(1, 'admin', 'admin@oyaoya.com', 'i7gsIWY4+5FS0EWgfipVDrs2TuPPEbLTzmsmd1crMNBY9u4DeU0/eGSY0V6nai2eehV/pzVhLU5C7FE1rcJx/Q==', '2016-11-26 00:00:00', NULL, NULL);
185
186-- --------------------------------------------------------
187
188--
189-- Table structure for table `oy_agents`
190--
191
192CREATE TABLE IF NOT EXISTS `oy_agents` (
193 `agent_id` int(11) NOT NULL AUTO_INCREMENT,
194 `merchant_id` int(11) NOT NULL,
195 `isVerified` tinyint(5) NOT NULL,
196 `mechant_unique_id` int(11) NOT NULL,
197 `agent_name` varchar(70) NOT NULL,
198 `email_id` varchar(100) NOT NULL,
199 `contact_number` varchar(15) NOT NULL,
200 `password` varchar(100) NOT NULL,
201 `address` varchar(200) NOT NULL,
202 `lat` float NOT NULL,
203 `lon` float NOT NULL,
204 `agent_uuid` varchar(100) NOT NULL,
205 `agent_status` tinyint(5) NOT NULL,
206 `created_at` datetime DEFAULT NULL,
207 `updated_at` datetime DEFAULT NULL,
208 `deleted_at` datetime DEFAULT NULL,
209 PRIMARY KEY (`agent_id`)
210) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
211
212--
213-- Dumping data for table `oy_agents`
214--
215
216INSERT INTO `oy_agents` (`agent_id`, `merchant_id`, `isVerified`, `mechant_unique_id`, `agent_name`, `email_id`, `contact_number`, `password`, `address`, `lat`, `lon`, `agent_uuid`, `agent_status`, `created_at`, `updated_at`, `deleted_at`) VALUES
217(1, 7, 100, 0, 'agent vinod', 'agent@gmail.com', '123456', '/LyqSBSYAB+5f+wjS7Wu+KEMaX9sd3roLClEzbwrrxr1uBXx7rVmIyktagQp34QTac/w/eO6onMolsgFg8t50g==', 'vijaynagar indore', 22.7533, 75.8937, '', 1, '2017-02-01 18:26:51', NULL, NULL);
218
219-- --------------------------------------------------------
220
221--
222-- Table structure for table `oy_agent_porducts`
223--
224
225CREATE TABLE IF NOT EXISTS `oy_agent_porducts` (
226 `agent_id` int(11) NOT NULL AUTO_INCREMENT,
227 `product_id` int(11) NOT NULL,
228 `created_at` int(11) DEFAULT NULL,
229 `updated_at` int(11) DEFAULT NULL,
230 `deleted_at` int(11) DEFAULT NULL,
231 PRIMARY KEY (`agent_id`)
232) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
233
234-- --------------------------------------------------------
235
236--
237-- Table structure for table `oy_companies`
238--
239
240CREATE TABLE IF NOT EXISTS `oy_companies` (
241 `cid` int(11) NOT NULL AUTO_INCREMENT,
242 `company_id` varchar(15) NOT NULL,
243 `company_name` varchar(100) NOT NULL,
244 `company_owner_name` varchar(50) NOT NULL,
245 `company_contact` varchar(15) NOT NULL,
246 `password` varchar(100) NOT NULL,
247 `contact_number` varchar(15) NOT NULL,
248 `email_id` varchar(100) NOT NULL,
249 `isVerified` tinyint(5) NOT NULL,
250 `location` varchar(150) NOT NULL,
251 `company_logo` varchar(250) NOT NULL,
252 `current_address` varchar(200) NOT NULL,
253 `lga` varchar(100) NOT NULL,
254 `types_of_buisness` varchar(200) NOT NULL,
255 `bank_name` varchar(100) NOT NULL,
256 `user_from` tinyint(5) NOT NULL,
257 `account_name` varchar(100) NOT NULL,
258 `account_number` int(11) NOT NULL,
259 `created_at` datetime DEFAULT NULL,
260 `updated_at` datetime DEFAULT NULL,
261 `deleted_at` datetime DEFAULT NULL,
262 `state` varchar(50) NOT NULL,
263 `website` varchar(100) NOT NULL,
264 `facebook_url` varchar(100) NOT NULL,
265 PRIMARY KEY (`cid`)
266) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
267
268--
269-- Dumping data for table `oy_companies`
270--
271
272INSERT INTO `oy_companies` (`cid`, `company_id`, `company_name`, `company_owner_name`, `company_contact`, `password`, `contact_number`, `email_id`, `isVerified`, `location`, `company_logo`, `current_address`, `lga`, `types_of_buisness`, `bank_name`, `user_from`, `account_name`, `account_number`, `created_at`, `updated_at`, `deleted_at`, `state`, `website`, `facebook_url`) VALUES
273(3, 'CPR7T6WOYU5', 'HP INDIA', 'kfjasfd', '9876543210', 'IFZ+IX4Z1CqyHy73o2XPqTtXY7g/xdXWwWQqWtFA8WZ5FD8iGwhHRPLZ2yL/xZndMbpz7Oqn0hOM0pn7c/+tHg==', '7777777777', 'hp@gmail.com', 100, '', '', 'new colony bhopal', 'lga', 'buisness types', 'state bank', 2, 'hp account', 123456, '2017-02-03 14:50:22', NULL, NULL, 'MP', 'www.google.com', '');
274
275-- --------------------------------------------------------
276
277--
278-- Table structure for table `oy_discounts`
279--
280
281CREATE TABLE IF NOT EXISTS `oy_discounts` (
282 `oy_discount_id` int(11) NOT NULL AUTO_INCREMENT,
283 `rs_id` int(11) NOT NULL,
284 `discount_name` varchar(255) NOT NULL,
285 `discount_type_id` int(11) NOT NULL,
286 `stock` int(11) NOT NULL,
287 `valid_from` datetime NOT NULL,
288 `valid_till` datetime NOT NULL,
289 `discount_type` int(11) NOT NULL,
290 `discount_status` int(11) NOT NULL DEFAULT '1',
291 `discount_by` tinyint(4) NOT NULL DEFAULT '1',
292 `description` text,
293 `discount_image` varchar(250) DEFAULT NULL,
294 `created_at` datetime NOT NULL,
295 `updated_at` datetime DEFAULT NULL,
296 `deleted_at` datetime DEFAULT NULL,
297 PRIMARY KEY (`oy_discount_id`)
298) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;
299
300--
301-- Dumping data for table `oy_discounts`
302--
303
304INSERT INTO `oy_discounts` (`oy_discount_id`, `rs_id`, `discount_name`, `discount_type_id`, `stock`, `valid_from`, `valid_till`, `discount_type`, `discount_status`, `discount_by`, `description`, `discount_image`, `created_at`, `updated_at`, `deleted_at`) VALUES
305(1, 3, 'STAFF005', 4, 10, '2016-08-31 02:00:00', '2016-11-30 02:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-06-25 12:38:32', '2016-10-21 06:31:48', NULL),
306(2, 2, 'Flat10', 2, 100, '2016-08-22 00:00:00', '2016-09-29 00:00:00', 1, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-06-25 12:38:32', NULL, NULL),
307(3, 4, 'GANA5', 1, 1000, '2016-08-20 00:00:00', '2016-09-30 00:00:00', 1, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-06-25 12:38:32', NULL, NULL),
308(4, 2, 'CUS005', 1, 100, '2016-08-18 09:30:00', '2016-12-28 09:30:00', 2, 0, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-06-25 12:38:32', '2016-10-28 08:22:57', NULL),
309(5, 20, 'Sunday5', 1, 100, '2016-08-20 00:00:00', '2016-09-23 00:00:00', 1, 0, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-06-25 12:38:32', NULL, NULL),
310(6, 2, 'SD1', 1, 1000, '2016-09-06 00:00:00', '2017-12-30 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479292687/restaurant_services/discount/coupon_banner.jpg', '2016-09-07 00:00:00', NULL, NULL),
311(7, 2, 'SD2', 1, 1000, '2016-09-06 00:00:00', '2017-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
312(8, 2, 'SD3', 1, 1000, '2016-09-06 00:00:00', '2017-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479292767/restaurant_services/discount/coupon1_banner.jpg', '2016-09-07 00:00:00', NULL, NULL),
313(9, 2, 'SD4', 1, 1000, '2016-09-06 00:00:00', '2017-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
314(10, 2, 'SD5', 1, 1000, '2016-09-06 00:00:00', '2017-01-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479292767/restaurant_services/discount/coupon1_banner.jpg', '2016-09-07 00:00:00', NULL, NULL),
315(11, 2, 'SD6', 1, 1000, '2016-09-05 18:30:00', '2016-12-30 18:30:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479292767/restaurant_services/discount/coupon1_banner.jpg', '2016-09-07 00:00:00', '2016-10-21 08:01:43', NULL),
316(12, 2, 'SD7', 1, 1000, '2016-09-06 00:00:00', '2016-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
317(13, 2, 'SD8', 1, 1000, '2016-09-06 00:00:00', '2016-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
318(14, 2, 'SD9', 1, 1000, '2016-09-06 00:00:00', '2016-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
319(15, 2, 'SD10', 1, 1000, '2016-09-06 00:00:00', '2016-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
320(16, 2, 'SD25P', 1, 1000, '2016-09-06 00:00:00', '2016-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
321(17, 2, 'SD50P', 1, 1000, '2016-09-06 00:00:00', '2016-12-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
322(18, 2, 'SD75P', 1, 1000, '2016-09-06 00:00:00', '2016-10-31 00:00:00', 3, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-09-07 00:00:00', NULL, NULL),
323(19, 20, 'Name', 1, 100, '2016-10-14 18:30:00', '2016-10-16 18:30:00', 0, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-10-15 07:23:05', NULL, NULL),
324(20, 2, 'Namw', 3, 1000, '2016-10-16 02:00:00', '2016-10-22 02:00:00', 0, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-10-15 07:28:20', '2016-10-15 08:02:01', NULL),
325(21, 2, 'Discount ON site', 1, 100, '2016-10-14 13:00:00', '2016-10-16 13:00:00', 0, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-10-15 11:04:10', '2016-10-15 11:04:33', NULL),
326(22, 2, 'hjkhjk', 1, 8000, '2016-10-17 18:30:00', '2016-11-14 18:30:00', 0, 1, 100, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-10-18 15:14:03', NULL, NULL),
327(23, -1, 'Super Admin Discount', 1, 100, '2016-10-19 18:30:00', '2016-10-26 18:30:00', 0, 1, 2, 'dummy test for discount', 'http://res.cloudinary.com/restaurant/image/upload/v1479281295/restaurant_services/discount/offer.png', '2016-10-20 14:34:34', NULL, NULL),
328(41, 2, 'sd500', 4, 100, '2016-10-26 18:30:00', '2016-10-30 18:30:00', 0, 1, 1, 'dummy test for discount', NULL, '2016-10-22 07:17:29', NULL, NULL),
329(43, -1, 'staff discount', 1, 50, '2016-11-03 00:00:00', '2016-12-03 00:00:00', 0, 1, 2, 'dummy test for discount', NULL, '2016-11-03 15:28:31', NULL, '2016-11-24 00:00:00');
330
331-- --------------------------------------------------------
332
333--
334-- Table structure for table `oy_discount_actions`
335--
336
337CREATE TABLE IF NOT EXISTS `oy_discount_actions` (
338 `oy_discount_action_id` int(11) NOT NULL AUTO_INCREMENT,
339 `oy_discount_id` int(11) NOT NULL,
340 `isPercentage` int(11) NOT NULL,
341 `discount_value` float NOT NULL,
342 `max_value` float NOT NULL DEFAULT '0',
343 `min_value` int(11) NOT NULL,
344 `created_at` datetime NOT NULL,
345 `updated_at` datetime DEFAULT NULL,
346 `deleted_at` datetime DEFAULT NULL,
347 PRIMARY KEY (`oy_discount_action_id`)
348) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;
349
350--
351-- Dumping data for table `oy_discount_actions`
352--
353
354INSERT INTO `oy_discount_actions` (`oy_discount_action_id`, `oy_discount_id`, `isPercentage`, `discount_value`, `max_value`, `min_value`, `created_at`, `updated_at`, `deleted_at`) VALUES
355(1, 1, 100, 5, 5, 0, '2016-06-25 12:38:32', '2016-10-21 06:31:48', NULL),
356(2, 2, 101, 10, 100, 2, '2016-06-25 12:38:32', NULL, NULL),
357(3, 3, 100, 5, 5, 0, '2016-06-25 12:38:32', NULL, NULL),
358(4, 4, 101, 5, 2, 0, '2016-06-25 12:38:32', '2016-10-28 08:22:57', NULL),
359(5, 5, 101, 5, 50, 2, '2016-06-25 12:38:32', NULL, NULL),
360(6, 6, 100, 1, 1, 0, '2016-09-07 00:00:00', NULL, NULL),
361(7, 7, 100, 2, 2, 0, '2016-09-07 00:00:00', NULL, NULL),
362(8, 8, 100, 3, 3, 0, '2016-09-07 00:00:00', NULL, NULL),
363(9, 9, 100, 4, 4, 0, '2016-09-07 00:00:00', NULL, NULL),
364(10, 10, 100, 5, 5, 0, '2016-09-07 00:00:00', NULL, NULL),
365(11, 11, 100, 6, 6, 0, '2016-09-07 00:00:00', '2016-10-21 08:01:43', NULL),
366(12, 12, 100, 7, 7, 0, '2016-09-07 00:00:00', NULL, NULL),
367(13, 13, 100, 8, 8, 0, '2016-09-07 00:00:00', NULL, NULL),
368(14, 14, 100, 9, 9, 0, '2016-09-07 00:00:00', NULL, NULL),
369(15, 15, 100, 10, 10, 0, '2016-09-07 00:00:00', NULL, NULL),
370(16, 16, 100, 0.25, 0.25, 0, '2016-09-07 00:00:00', NULL, NULL),
371(17, 17, 100, 0.5, 0.5, 0, '2016-09-07 00:00:00', NULL, NULL),
372(18, 18, 100, 0.75, 0.75, 0, '2016-09-07 00:00:00', NULL, NULL),
373(19, 19, 101, 100, 100, 0, '2016-10-15 07:23:05', NULL, NULL),
374(20, 20, 101, 100, 10, 0, '2016-10-15 07:28:20', '2016-10-15 08:02:01', NULL),
375(21, 21, 101, 100, 100, 0, '2016-10-15 11:04:10', '2016-10-15 11:04:33', NULL),
376(22, 22, 101, 5, 15, 0, '2016-10-18 15:14:03', NULL, NULL),
377(23, 23, 101, 100, 10, 0, '2016-10-20 14:34:34', NULL, NULL),
378(24, 24, 101, 10, 6, 0, '2016-10-21 06:56:17', NULL, NULL),
379(25, 25, 101, 10, 6, 0, '2016-10-21 06:57:07', NULL, NULL),
380(26, 26, 101, 10, 6, 0, '2016-10-21 07:00:25', NULL, NULL),
381(27, 27, 101, 10, 6, 0, '2016-10-21 07:01:42', NULL, NULL),
382(28, 28, 101, 10, 6, 0, '2016-10-21 07:07:01', NULL, NULL),
383(29, 29, 101, 10, 6, 0, '2016-10-21 07:20:11', NULL, NULL),
384(30, 30, 101, 10, 6, 0, '2016-10-21 07:20:30', NULL, NULL),
385(31, 31, 101, 10, 5, 0, '2016-10-21 07:48:08', NULL, NULL),
386(32, 32, 101, 10, 5, 0, '2016-10-21 07:49:42', NULL, NULL),
387(33, 33, 101, 10, 10, 0, '2016-10-21 10:17:10', NULL, NULL),
388(34, 34, 101, 10, 10, 0, '2016-10-21 10:21:26', NULL, NULL),
389(35, 35, 101, 10, 10, 0, '2016-10-21 10:31:54', NULL, NULL),
390(36, 36, 101, 10, 6, 0, '2016-10-21 10:33:36', NULL, NULL),
391(37, 37, 101, 10, 5, 0, '2016-10-21 14:26:12', NULL, NULL),
392(38, 38, 101, 10, 10, 0, '2016-10-21 14:38:26', NULL, NULL),
393(39, 39, 101, 10, 10, 0, '2016-10-21 14:56:11', NULL, NULL),
394(40, 40, 101, 10, 10, 0, '2016-10-22 07:03:44', NULL, NULL),
395(41, 41, 101, 10, 10, 0, '2016-10-22 07:17:29', NULL, NULL),
396(42, 42, 101, 10, 10, 0, '2016-10-22 08:03:59', NULL, NULL),
397(43, 43, 101, 10, 50, 0, '2016-11-03 15:28:31', NULL, NULL);
398
399-- --------------------------------------------------------
400
401--
402-- Table structure for table `oy_discount_action_rules`
403--
404
405CREATE TABLE IF NOT EXISTS `oy_discount_action_rules` (
406 `oy_discount_action_rule_id` int(11) NOT NULL AUTO_INCREMENT,
407 `oy_discount_id` int(11) NOT NULL,
408 `valid_categories` varchar(255) NOT NULL,
409 `valid_addons` varchar(255) NOT NULL,
410 `valid_products` varchar(255) NOT NULL,
411 `freebies` varchar(255) NOT NULL,
412 `created_at` datetime NOT NULL,
413 `updated_at` datetime DEFAULT NULL,
414 `deleted_at` datetime DEFAULT NULL,
415 PRIMARY KEY (`oy_discount_action_rule_id`)
416) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
417
418--
419-- Dumping data for table `oy_discount_action_rules`
420--
421
422INSERT INTO `oy_discount_action_rules` (`oy_discount_action_rule_id`, `oy_discount_id`, `valid_categories`, `valid_addons`, `valid_products`, `freebies`, `created_at`, `updated_at`, `deleted_at`) VALUES
423(1, 1, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
424(2, 2, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
425(3, 3, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
426(4, 4, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
427(5, 5, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
428(6, 6, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
429(7, 7, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
430(8, 8, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
431(9, 9, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
432(10, 10, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
433(11, 11, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
434(12, 12, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
435(13, 13, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
436(14, 14, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
437(15, 15, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
438(16, 16, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
439(17, 17, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL),
440(18, 18, '-1', '-1', '-1', '-1', '2016-06-25 12:38:32', NULL, NULL);
441
442-- --------------------------------------------------------
443
444--
445-- Table structure for table `oy_discount_rules`
446--
447
448CREATE TABLE IF NOT EXISTS `oy_discount_rules` (
449 `oy_discount_rule_id` int(11) NOT NULL AUTO_INCREMENT,
450 `oy_discount_id` int(11) NOT NULL,
451 `rule_id` int(11) NOT NULL,
452 `operator_id` int(11) NOT NULL,
453 `value` float NOT NULL,
454 `created_at` datetime NOT NULL,
455 `updated_at` datetime DEFAULT NULL,
456 `deleted_at` datetime DEFAULT NULL,
457 PRIMARY KEY (`oy_discount_rule_id`)
458) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;
459
460--
461-- Dumping data for table `oy_discount_rules`
462--
463
464INSERT INTO `oy_discount_rules` (`oy_discount_rule_id`, `oy_discount_id`, `rule_id`, `operator_id`, `value`, `created_at`, `updated_at`, `deleted_at`) VALUES
465(1, 1, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
466(2, 2, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
467(3, 3, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
468(4, 4, 2, 3, 5, '2016-06-25 12:38:32', NULL, '2016-10-28 08:01:15'),
469(5, 5, 4, 1, 5, '2016-06-25 12:38:32', NULL, NULL),
470(6, 6, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
471(7, 7, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
472(8, 8, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
473(9, 9, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
474(10, 10, 2, 3, 6, '2016-06-25 12:38:32', NULL, NULL),
475(11, 11, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
476(12, 12, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
477(13, 13, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
478(14, 14, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
479(15, 15, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
480(16, 16, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
481(17, 17, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
482(18, 18, 2, 3, 5, '2016-06-25 12:38:32', NULL, NULL),
483(19, 19, 2, 2, 1000, '2016-10-15 07:23:05', NULL, NULL),
484(20, 20, 3, 7, 10, '2016-10-15 07:28:20', NULL, NULL),
485(21, 20, 1, 2, 20202, '2016-10-15 07:56:49', NULL, '2016-10-15 08:02:01'),
486(22, 20, 1, 1, 10010, '2016-10-15 08:00:26', NULL, '2016-10-15 08:02:01'),
487(23, 20, 1, 1, 77, '2016-10-15 08:02:01', NULL, NULL),
488(24, 21, 3, 2, 100, '2016-10-15 11:04:10', NULL, '2016-10-15 11:04:33'),
489(25, 21, 4, 1, 789, '2016-10-15 11:04:33', NULL, NULL),
490(27, 22, 1, 1, 20, '2016-10-18 15:14:03', NULL, NULL),
491(28, 23, 1, 1, 1, '2016-10-20 14:34:34', NULL, NULL),
492(29, 23, 3, 2, 20, '2016-10-20 14:34:34', NULL, NULL),
493(30, 23, 4, 2, 2, '2016-10-20 14:34:34', NULL, NULL),
494(31, 0, 0, 0, 0, '2016-10-21 06:56:17', NULL, NULL),
495(32, 0, 0, 0, 0, '2016-10-21 06:57:07', NULL, NULL),
496(33, 0, 0, 0, 0, '2016-10-21 07:00:25', NULL, NULL),
497(34, 0, 0, 0, 0, '2016-10-21 07:01:42', NULL, NULL),
498(35, 0, 0, 0, 0, '2016-10-21 07:07:01', NULL, NULL),
499(36, 0, 0, 0, 0, '2016-10-21 07:20:11', NULL, NULL),
500(37, 0, 0, 0, 0, '2016-10-21 07:20:30', NULL, NULL),
501(38, 0, 0, 0, 0, '2016-10-21 07:48:08', NULL, NULL),
502(39, 32, 2, 2, 5000, '2016-10-21 07:49:42', NULL, NULL),
503(40, 11, 3, 3, 500, '2016-10-21 08:01:43', NULL, NULL),
504(41, 0, 0, 0, 0, '2016-10-21 10:17:10', NULL, NULL),
505(42, 0, 0, 0, 0, '2016-10-21 10:21:26', NULL, NULL),
506(43, 35, 2, 2, 500, '2016-10-21 10:31:54', NULL, NULL),
507(44, 36, 1, 1, 500, '2016-10-21 10:33:36', NULL, NULL),
508(45, 37, 2, 4, 5000, '2016-10-21 14:26:12', NULL, NULL),
509(46, 38, 2, 3, 1000, '2016-10-21 14:38:26', NULL, NULL),
510(47, 39, 1, 1, 3, '2016-10-21 14:56:11', NULL, NULL),
511(48, 40, 2, 2, 1500, '2016-10-22 07:03:44', NULL, NULL),
512(49, 41, 3, 7, 100, '2016-10-22 07:17:29', NULL, NULL),
513(50, 42, 2, 1, 1500, '2016-10-22 08:03:59', NULL, NULL),
514(51, 4, 2, 3, 20, '2016-10-28 08:01:15', NULL, NULL),
515(52, 4, 2, 3, 20, '2016-10-28 08:02:45', NULL, '2016-10-28 08:20:01'),
516(53, 4, 3, 1, 2, '2016-10-28 08:02:45', NULL, '2016-10-28 08:20:21'),
517(54, 4, 2, 3, 20, '2016-10-28 08:03:28', NULL, '2016-10-28 08:20:21'),
518(55, 4, 3, 1, 2, '2016-10-28 08:22:37', NULL, '2016-10-28 08:22:57'),
519(56, 43, 3, 2, 1, '2016-11-03 15:28:31', NULL, NULL);
520
521-- --------------------------------------------------------
522
523--
524-- Table structure for table `oy_menus`
525--
526
527CREATE TABLE IF NOT EXISTS `oy_menus` (
528 `menu_id` int(11) NOT NULL AUTO_INCREMENT,
529 `parent_id` int(11) NOT NULL,
530 `menu_name` int(100) NOT NULL,
531 `menu_image` varchar(500) NOT NULL,
532 `description` varchar(200) NOT NULL,
533 `created_at` datetime DEFAULT NULL,
534 `updated_at` datetime DEFAULT NULL,
535 `deleted_at` datetime DEFAULT NULL,
536 PRIMARY KEY (`menu_id`)
537) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
538
539-- --------------------------------------------------------
540
541--
542-- Table structure for table `oy_merchants`
543--
544
545CREATE TABLE IF NOT EXISTS `oy_merchants` (
546 `merchant_id` int(11) NOT NULL AUTO_INCREMENT,
547 `email_id` varchar(100) NOT NULL,
548 `merchant_status` tinyint(5) NOT NULL,
549 `password` varchar(100) NOT NULL,
550 `isVerified` tinyint(5) NOT NULL,
551 `contact_number` varchar(15) NOT NULL,
552 `owner_name` varchar(50) NOT NULL,
553 `company_name` varchar(50) NOT NULL,
554 `address` varchar(100) NOT NULL,
555 `merchant_logo` varchar(250) NOT NULL,
556 `short_description` varchar(250) NOT NULL,
557 `long_decription` varchar(500) NOT NULL,
558 `company_id` varchar(100) NOT NULL,
559 `productBased` varchar(50) NOT NULL,
560 `transportBased` varchar(50) NOT NULL,
561 `mechant_unique_id` int(11) NOT NULL,
562 `created_at` datetime DEFAULT NULL,
563 `updated_at` datetime DEFAULT NULL,
564 `deleted_at` datetime DEFAULT NULL,
565 PRIMARY KEY (`merchant_id`)
566) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
567
568--
569-- Dumping data for table `oy_merchants`
570--
571
572INSERT INTO `oy_merchants` (`merchant_id`, `email_id`, `merchant_status`, `password`, `isVerified`, `contact_number`, `owner_name`, `company_name`, `address`, `merchant_logo`, `short_description`, `long_decription`, `company_id`, `productBased`, `transportBased`, `mechant_unique_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
573(7, 'merchant@gmail.com', 2, 'PnxXR7Rd+XBtooF82PCBpSpi4FSKC46hT1EFr9PVul7MjG9MmVzWqF0Puq/hIkvStlRVfB9EI2PFvUHmf3XY1Q==', 101, '9876543210', '', '', '', '', '', '', 'xyet123', '', '', 655, '2017-02-01 15:21:17', '2017-02-02 11:17:51', NULL);
574
575-- --------------------------------------------------------
576
577--
578-- Table structure for table `oy_merchant_products`
579--
580
581CREATE TABLE IF NOT EXISTS `oy_merchant_products` (
582 `merchant_id` int(11) NOT NULL AUTO_INCREMENT,
583 `product_id` int(11) NOT NULL,
584 `created_at` datetime DEFAULT NULL,
585 `updated_at` datetime DEFAULT NULL,
586 `deleted_at` datetime DEFAULT NULL,
587 PRIMARY KEY (`merchant_id`)
588) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
589
590-- --------------------------------------------------------
591
592--
593-- Table structure for table `oy_products`
594--
595
596CREATE TABLE IF NOT EXISTS `oy_products` (
597 `product_id` int(11) NOT NULL AUTO_INCREMENT,
598 `menu_id` int(11) NOT NULL,
599 `product_name` varchar(100) NOT NULL,
600 `product_image` varchar(500) NOT NULL,
601 `description` varchar(200) NOT NULL,
602 `created_at` datetime DEFAULT NULL,
603 `updated_at` datetime DEFAULT NULL,
604 `deleted_at` datetime DEFAULT NULL,
605 PRIMARY KEY (`product_id`)
606) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
607
608-- --------------------------------------------------------
609
610--
611-- Table structure for table `oy_users`
612--
613
614CREATE TABLE IF NOT EXISTS `oy_users` (
615 `user_id` int(11) NOT NULL AUTO_INCREMENT,
616 `customer_name` varchar(50) NOT NULL,
617 `isVerified` tinyint(5) NOT NULL,
618 `contact_number` varchar(15) NOT NULL,
619 `email_id` varchar(80) NOT NULL,
620 `password` varchar(100) NOT NULL,
621 `user_uuid` varchar(100) NOT NULL,
622 `signup_type_id` int(11) NOT NULL,
623 `otp` varchar(50) NOT NULL,
624 `otp_created` datetime NOT NULL,
625 `age` int(5) NOT NULL,
626 `user_image` varchar(250) NOT NULL,
627 `user_status` tinyint(5) NOT NULL,
628 `device_key` varchar(100) NOT NULL,
629 `created_at` datetime DEFAULT NULL,
630 `update_at` datetime DEFAULT NULL,
631 `deleted_at` datetime DEFAULT NULL,
632 PRIMARY KEY (`user_id`)
633) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
634
635--
636-- Dumping data for table `oy_users`
637--
638
639INSERT INTO `oy_users` (`user_id`, `customer_name`, `isVerified`, `contact_number`, `email_id`, `password`, `user_uuid`, `signup_type_id`, `otp`, `otp_created`, `age`, `user_image`, `user_status`, `device_key`, `created_at`, `update_at`, `deleted_at`) VALUES
640(1, 'customer john', 100, '8888888888', 'user1@gmail.com', 'GewVEo5itYF+0PDmW5Eoe0ynGtp8HXu8t6NVuggvL2+V0jL6qtG3Qvjg4qiy8NhuUzOdimfuquAgaYAmf/JXGw==', '', 0, '2222', '2017-02-01 17:12:38', 0, '', 1, '45', '2017-02-01 17:12:38', NULL, NULL),
641(2, 'Henary', 100, '123456', 'user2@gmail.com', '0aw6mUS/E45fNSlmKucbweVrStQm1JP74WLR5CwEZqDwIJaoYh3LH4Fwvpbunzyzp5nH0uGCxdAFiI6MpqS9sQ==', '', 0, '2222', '2017-02-01 17:14:11', 0, '', 1, '852yytr', '2017-02-01 17:14:11', NULL, NULL);
642
643-- --------------------------------------------------------
644
645--
646-- Table structure for table `oy_user_payment`
647--
648
649CREATE TABLE IF NOT EXISTS `oy_user_payment` (
650 `user_payment_id` int(11) NOT NULL AUTO_INCREMENT,
651 `request_id` int(11) NOT NULL,
652 `transport_amount` float NOT NULL,
653 `product_amount` float NOT NULL,
654 `total_amount` float NOT NULL,
655 `final_amount` float NOT NULL,
656 `amount_paid` float NOT NULL,
657 `created_at` datetime DEFAULT NULL,
658 `updated_at` datetime DEFAULT NULL,
659 `deleted_at` datetime DEFAULT NULL,
660 PRIMARY KEY (`user_payment_id`)
661) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
662
663-- --------------------------------------------------------
664
665--
666-- Table structure for table `oy_user_request`
667--
668
669CREATE TABLE IF NOT EXISTS `oy_user_request` (
670 `request_id` int(11) NOT NULL AUTO_INCREMENT,
671 `user_id` int(11) NOT NULL,
672 `product_id` int(11) NOT NULL,
673 `quantity` int(11) NOT NULL,
674 `unit_id` int(11) NOT NULL,
675 `product_merchant_id` int(11) NOT NULL,
676 `request_status` int(11) NOT NULL,
677 `needTransport` int(11) NOT NULL,
678 `merchantClear` int(11) NOT NULL,
679 `transportClear` int(11) NOT NULL,
680 `transport_merchant_id` int(11) NOT NULL,
681 `costIncludesTransport` int(11) NOT NULL,
682 `product_price` float NOT NULL,
683 `transport_price` float NOT NULL,
684 `created_at` datetime NOT NULL,
685 `updated_at` datetime NOT NULL,
686 `deleted_at` datetime NOT NULL,
687 PRIMARY KEY (`request_id`)
688) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
689
690-- --------------------------------------------------------
691
692--
693-- Table structure for table `rules`
694--
695
696CREATE TABLE IF NOT EXISTS `rules` (
697 `rule_id` int(11) NOT NULL AUTO_INCREMENT,
698 `rule_name` varchar(255) NOT NULL,
699 `code_name` varchar(100) DEFAULT NULL,
700 `created_at` datetime NOT NULL,
701 `updated_at` datetime DEFAULT NULL,
702 `deleted_at` datetime DEFAULT NULL,
703 PRIMARY KEY (`rule_id`)
704) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
705
706--
707-- Dumping data for table `rules`
708--
709
710INSERT INTO `rules` (`rule_id`, `rule_name`, `code_name`, `created_at`, `updated_at`, `deleted_at`) VALUES
711(1, 'total_item_quantity', 'On Product Quantity', '2016-06-22 00:00:00', NULL, NULL),
712(2, 'order_amount', 'On Order Amount', '2016-06-22 00:00:00', NULL, NULL),
713(3, 'order_type', 'On Order Type', '2016-06-22 00:00:00', NULL, NULL),
714(4, 'payment_type', 'Payment Method', '2016-06-22 00:00:00', NULL, NULL),
715(5, 'product_price', NULL, '2016-06-22 00:00:00', NULL, '2016-08-22 00:00:00');
716
717-- --------------------------------------------------------
718
719--
720-- Table structure for table `rule_operators`
721--
722
723CREATE TABLE IF NOT EXISTS `rule_operators` (
724 `rule_operator_id` int(11) NOT NULL AUTO_INCREMENT,
725 `rule_id` int(11) NOT NULL,
726 `operator_id` int(11) NOT NULL,
727 `created_at` datetime NOT NULL,
728 `updated_at` datetime DEFAULT NULL,
729 `deleted_at` datetime DEFAULT NULL,
730 PRIMARY KEY (`rule_operator_id`)
731) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
732
733--
734-- Dumping data for table `rule_operators`
735--
736
737INSERT INTO `rule_operators` (`rule_operator_id`, `rule_id`, `operator_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
738(1, 1, 1, '2016-06-23 00:00:00', NULL, NULL),
739(2, 1, 2, '2016-06-23 00:00:00', NULL, NULL),
740(3, 1, 3, '2016-06-23 00:00:00', NULL, NULL),
741(4, 1, 4, '2016-06-23 00:00:00', NULL, NULL),
742(5, 1, 5, '2016-06-23 00:00:00', NULL, NULL),
743(6, 2, 1, '2016-06-23 00:00:00', NULL, NULL),
744(7, 2, 2, '2016-06-23 00:00:00', NULL, NULL),
745(8, 2, 3, '2016-06-23 00:00:00', NULL, NULL),
746(9, 2, 4, '2016-06-23 00:00:00', NULL, NULL),
747(10, 2, 5, '2016-06-23 00:00:00', NULL, NULL),
748(11, 3, 1, '2016-06-23 00:00:00', NULL, NULL),
749(12, 3, 2, '2016-06-23 00:00:00', NULL, NULL),
750(13, 3, 6, '2016-06-23 00:00:00', NULL, NULL),
751(14, 3, 7, '2016-06-23 00:00:00', NULL, NULL),
752(15, 3, 8, '2016-06-23 00:00:00', NULL, NULL),
753(16, 3, 9, '2016-06-23 00:00:00', NULL, NULL),
754(17, 4, 1, '2016-06-23 00:00:00', NULL, NULL),
755(18, 4, 2, '2016-06-23 00:00:00', NULL, NULL),
756(19, 4, 6, '2016-06-23 00:00:00', NULL, NULL),
757(20, 4, 7, '2016-06-23 00:00:00', NULL, NULL),
758(21, 4, 8, '2016-06-23 00:00:00', NULL, NULL),
759(22, 4, 9, '2016-06-23 00:00:00', NULL, NULL),
760(23, 5, 3, '2016-06-23 00:00:00', NULL, '2016-08-22 00:00:00');
761
762/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
763/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
764/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;