· 10 years ago · Oct 28, 2015, 08:39 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 28, 2015 at 04:37 PM
7-- Server version: 5.6.25-0ubuntu0.15.04.1
8-- PHP Version: 5.6.4-4ubuntu6.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `finance`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `app`
21--
22
23CREATE TABLE IF NOT EXISTS `app` (
24`app_id` int(10) unsigned NOT NULL COMMENT 'Database Generated',
25 `app_name` varchar(255) NOT NULL,
26 `app_domain` varchar(255) DEFAULT NULL,
27 `app_website` varchar(255) DEFAULT NULL,
28 `app_permissions` varchar(255) NOT NULL,
29 `app_token` varchar(255) DEFAULT NULL,
30 `app_secret` varchar(255) DEFAULT NULL,
31 `app_active` int(1) unsigned NOT NULL DEFAULT '1',
32 `app_type` varchar(255) DEFAULT NULL,
33 `app_flag` int(1) unsigned NOT NULL DEFAULT '0',
34 `app_created` datetime NOT NULL,
35 `app_updated` datetime NOT NULL
36) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
37
38--
39-- Dumping data for table `app`
40--
41
42INSERT INTO `app` (`app_id`, `app_name`, `app_domain`, `app_website`, `app_permissions`, `app_token`, `app_secret`, `app_active`, `app_type`, `app_flag`, `app_created`, `app_updated`) VALUES
43(1, 'Main Application', '*.openovate.com', 'http://openovate.com/', 'public_profile,public_sso,personal_profile,user_profile', '71d89077361fef0de88f37f7fe058dec', '3fbfaa6d8eff3759398475e8162e8264', 1, NULL, 0, '2015-08-21 00:00:00', '2015-10-21 14:54:49');
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `app_profile`
49--
50
51CREATE TABLE IF NOT EXISTS `app_profile` (
52 `app_profile_app` int(10) unsigned NOT NULL,
53 `app_profile_profile` int(10) unsigned NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=utf8;
55
56--
57-- Dumping data for table `app_profile`
58--
59
60INSERT INTO `app_profile` (`app_profile_app`, `app_profile_profile`) VALUES
61(1, 1);
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `auth`
67--
68
69CREATE TABLE IF NOT EXISTS `auth` (
70`auth_id` int(10) unsigned NOT NULL COMMENT 'Database Generated',
71 `auth_slug` varchar(255) NOT NULL COMMENT 'can be an email or slug',
72 `auth_password` varchar(255) NOT NULL COMMENT 'md5 hash',
73 `auth_token` varchar(255) NOT NULL COMMENT 'System Generated',
74 `auth_secret` varchar(255) NOT NULL COMMENT 'System Generated',
75 `auth_permissions` text NOT NULL COMMENT 'See permissions.json for options',
76 `auth_facebook_token` varchar(255) DEFAULT NULL COMMENT 'Facebook access token',
77 `auth_facebook_secret` varchar(255) DEFAULT NULL COMMENT 'Facebook access secret',
78 `auth_linkedin_token` varchar(255) DEFAULT NULL COMMENT 'LinkedIn access token',
79 `auth_linkedin_secret` varchar(255) DEFAULT NULL COMMENT 'LinkedIn access secret',
80 `auth_twitter_token` varchar(255) DEFAULT NULL COMMENT 'Twitter access token',
81 `auth_twitter_secret` varchar(255) DEFAULT NULL COMMENT 'Twitter access secret',
82 `auth_google_token` varchar(255) DEFAULT NULL COMMENT 'Google access token',
83 `auth_google_secret` varchar(255) DEFAULT NULL COMMENT 'Google access secret',
84 `auth_active` int(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Do not delete rows',
85 `auth_type` varchar(255) DEFAULT NULL COMMENT 'General usage type',
86 `auth_flag` int(1) unsigned NOT NULL DEFAULT '0' COMMENT 'General usage flag',
87 `auth_created` datetime NOT NULL COMMENT 'System Generated',
88 `auth_updated` datetime NOT NULL COMMENT 'System Generated'
89) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
90
91--
92-- Dumping data for table `auth`
93--
94
95INSERT INTO `auth` (`auth_id`, `auth_slug`, `auth_password`, `auth_token`, `auth_secret`, `auth_permissions`, `auth_facebook_token`, `auth_facebook_secret`, `auth_linkedin_token`, `auth_linkedin_secret`, `auth_twitter_token`, `auth_twitter_secret`, `auth_google_token`, `auth_google_secret`, `auth_active`, `auth_type`, `auth_flag`, `auth_created`, `auth_updated`) VALUES
96(1, 'admin@openovate.com', '21232f297a57a5a743894a0e4a801fc3', '986e7ce6bec660838491c1cd0a1f4ef6', 'ba0d2fc7aab09dfa3463943c0aaa8551', 'public_profile,public_sso,personal_profile,user_profile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-09-11 23:05:17', '2015-09-11 23:05:17'),
97(2, 'soy2@gmail.com', '202cb962ac59075b964b07152d234b70', '94be446f419fc57fd67999e03a4bd549', 'c52934dd5e85d11a842de39fa7bbfe56', 'public_profile,public_sso,personal_profile,user_profile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:17:27', '2015-10-23 17:17:27'),
98(3, '123', '202cb962ac59075b964b07152d234b70', 'dd55a61a27da2dad99d3ed99acd70feb', '15a85ee6671dcc2d7c5e05c2fadc3dec', 'public_profile,public_sso,personal_profile,user_profile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:18:43', '2015-10-23 17:18:43'),
99(6, 'soy@gmail.com', '202cb962ac59075b964b07152d234b70', '20f5e8a29e29d832e042d6ef78eccc5b', 'b760464307b9bc220a9bf9433e901e06', 'public_profile,public_sso,personal_profile,user_profile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:20:39', '2015-10-23 17:20:39'),
100(8, '1234', '202cb962ac59075b964b07152d234b70', 'abe7e03e77e21832d5b9a84222d8347a', '7a697b7e79e4cde7f2a3c6e72cf31f2d', 'public_profile,public_sso,personal_profile,user_profile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:28:45', '2015-10-23 17:28:45'),
101(9, 'test@gmail.com', '202cb962ac59075b964b07152d234b70', 'efc75d7048dc2d059487122859832ea5', 'daac81dd8f79386048c062e4e787260c', 'public_profile,public_sso,personal_profile,user_profile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:29:06', '2015-10-23 17:29:06');
102
103-- --------------------------------------------------------
104
105--
106-- Table structure for table `auth_profile`
107--
108
109CREATE TABLE IF NOT EXISTS `auth_profile` (
110 `auth_profile_auth` int(10) unsigned NOT NULL,
111 `auth_profile_profile` int(10) unsigned NOT NULL
112) ENGINE=InnoDB DEFAULT CHARSET=utf8;
113
114--
115-- Dumping data for table `auth_profile`
116--
117
118INSERT INTO `auth_profile` (`auth_profile_auth`, `auth_profile_profile`) VALUES
119(1, 1),
120(2, 4),
121(3, 5),
122(6, 8),
123(8, 10),
124(9, 11);
125
126-- --------------------------------------------------------
127
128--
129-- Table structure for table `matching`
130--
131
132CREATE TABLE IF NOT EXISTS `matching` (
133`matching_id` int(10) unsigned NOT NULL,
134 `matching_app` int(10) NOT NULL,
135 `matching_order` int(10) DEFAULT NULL,
136 `matching_reference` varchar(255) NOT NULL,
137 `matching_method` varchar(255) NOT NULL,
138 `matching_total` float(10,2) NOT NULL DEFAULT '0.00',
139 `matching_processed_by` varchar(255) NOT NULL,
140 `matching_remark` varchar(255) NOT NULL,
141 `matching_active` int(1) unsigned NOT NULL DEFAULT '1',
142 `matching_type` varchar(255) DEFAULT NULL,
143 `matching_flag` int(1) unsigned NOT NULL DEFAULT '0',
144 `matching_created` datetime NOT NULL,
145 `matching_updated` datetime NOT NULL
146) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
147
148--
149-- Dumping data for table `matching`
150--
151
152INSERT INTO `matching` (`matching_id`, `matching_app`, `matching_order`, `matching_reference`, `matching_method`, `matching_total`, `matching_processed_by`, `matching_remark`, `matching_active`, `matching_type`, `matching_flag`, `matching_created`, `matching_updated`) VALUES
153(1, 1, 1, '1234', 'lbc-otc', 5100.00, 'Admin', 'Greater by 4800', 1, '3', 0, '2015-10-28 00:18:18', '2015-10-28 00:26:27'),
154(2, 1, NULL, '1235', 'lbc-otc', 5100.00, 'Admin', 'Unmatched', 1, '4', 0, '2015-10-28 00:19:46', '2015-10-28 00:26:27');
155
156-- --------------------------------------------------------
157
158--
159-- Table structure for table `permission`
160--
161
162CREATE TABLE IF NOT EXISTS `permission` (
163`permission_id` int(10) unsigned NOT NULL,
164 `permission_action` varchar(255) NOT NULL,
165 `permission_active` int(1) unsigned NOT NULL DEFAULT '1',
166 `permission_type` varchar(255) DEFAULT NULL,
167 `permission_flag` int(1) unsigned NOT NULL DEFAULT '0',
168 `permission_created` datetime NOT NULL,
169 `permission_updated` datetime NOT NULL
170) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
171
172--
173-- Dumping data for table `permission`
174--
175
176INSERT INTO `permission` (`permission_id`, `permission_action`, `permission_active`, `permission_type`, `permission_flag`, `permission_created`, `permission_updated`) VALUES
177(1, 'View', 1, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
178(2, 'Edit', 1, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
179(3, 'Delete', 1, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
180(4, 'Add', 1, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
181
182-- --------------------------------------------------------
183
184--
185-- Table structure for table `profile`
186--
187
188CREATE TABLE IF NOT EXISTS `profile` (
189`profile_id` int(10) unsigned NOT NULL COMMENT 'Database Generated',
190 `profile_name` varchar(255) NOT NULL,
191 `profile_first` varchar(255) DEFAULT NULL,
192 `profile_last` varchar(255) DEFAULT NULL,
193 `profile_email` varchar(255) DEFAULT NULL,
194 `profile_phone` varchar(255) DEFAULT NULL,
195 `profile_detail` text,
196 `profile_image` varchar(255) DEFAULT NULL,
197 `profile_company` varchar(255) DEFAULT NULL,
198 `profile_job` varchar(255) DEFAULT NULL,
199 `profile_gender` varchar(255) DEFAULT NULL,
200 `profile_birth` datetime DEFAULT NULL,
201 `profile_website` varchar(255) DEFAULT NULL,
202 `profile_facebook` varchar(255) DEFAULT NULL,
203 `profile_linkedin` varchar(255) DEFAULT NULL,
204 `profile_twitter` varchar(255) DEFAULT NULL,
205 `profile_google` varchar(255) DEFAULT NULL,
206 `profile_reference` varchar(255) DEFAULT NULL,
207 `profile_active` int(1) unsigned NOT NULL DEFAULT '1',
208 `profile_type` varchar(255) DEFAULT NULL,
209 `profile_flag` int(1) unsigned NOT NULL DEFAULT '0',
210 `profile_created` datetime NOT NULL,
211 `profile_updated` datetime NOT NULL
212) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
213
214--
215-- Dumping data for table `profile`
216--
217
218INSERT INTO `profile` (`profile_id`, `profile_name`, `profile_first`, `profile_last`, `profile_email`, `profile_phone`, `profile_detail`, `profile_image`, `profile_company`, `profile_job`, `profile_gender`, `profile_birth`, `profile_website`, `profile_facebook`, `profile_linkedin`, `profile_twitter`, `profile_google`, `profile_reference`, `profile_active`, `profile_type`, `profile_flag`, `profile_created`, `profile_updated`) VALUES
219(1, 'Admin', NULL, NULL, 'admin@openovate.com', '+63 (2) 654-5110', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-09-11 23:05:16', '2015-09-11 23:05:16'),
220(7, 'soy2 123', 'soy2', '123', '123@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:20:19', '2015-10-24 11:29:33'),
221(8, 'soy s', 'soy', 's', 'soy@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:20:38', '2015-10-23 17:20:38'),
222(9, 'soy 123', 'soy', '123', 'soy2@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:27:19', '2015-10-23 17:27:19'),
223(10, 'soy 123', 'soy', '123', '1234', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:28:45', '2015-10-23 17:28:45'),
224(11, 'Test s', 'Test', 's', 'test@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, '2015-10-23 17:29:06', '2015-10-23 17:29:06');
225
226-- --------------------------------------------------------
227
228--
229-- Table structure for table `quote`
230--
231
232CREATE TABLE IF NOT EXISTS `quote` (
233`quote_id` int(10) unsigned NOT NULL,
234 `quote_name` varchar(255) NOT NULL,
235 `quote_reference` varchar(255) NOT NULL,
236 `quote_product_id` int(10) NOT NULL,
237 `quote_product_title` varchar(255) NOT NULL,
238 `quote_srp` float(10,2) NOT NULL DEFAULT '0.00',
239 `quote_cost` float(10,2) DEFAULT '0.00',
240 `quote_variant` varchar(255) DEFAULT NULL,
241 `quote_weight` float(10,2) NOT NULL DEFAULT '0.00',
242 `quote_tax` float(10,2) DEFAULT '0.00',
243 `quote_active` int(1) unsigned NOT NULL DEFAULT '1',
244 `quote_type` varchar(255) DEFAULT NULL,
245 `quote_flag` int(1) unsigned NOT NULL DEFAULT '0',
246 `quote_created` datetime NOT NULL,
247 `quote_updated` datetime NOT NULL
248) ENGINE=InnoDB DEFAULT CHARSET=latin1;
249
250-- --------------------------------------------------------
251
252--
253-- Table structure for table `refund`
254--
255
256CREATE TABLE IF NOT EXISTS `refund` (
257`refund_id` int(10) unsigned NOT NULL,
258 `refund_method` varchar(255) NOT NULL,
259 `refund_reason` varchar(255) NOT NULL,
260 `refund_status` varchar(255) DEFAULT 'PENDING',
261 `refund_active` int(1) unsigned NOT NULL DEFAULT '1',
262 `refund_type` varchar(255) DEFAULT NULL,
263 `refund_flag` int(1) unsigned NOT NULL DEFAULT '0',
264 `refund_created` datetime NOT NULL,
265 `refund_updated` datetime NOT NULL
266) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
267
268--
269-- Dumping data for table `refund`
270--
271
272INSERT INTO `refund` (`refund_id`, `refund_method`, `refund_reason`, `refund_status`, `refund_active`, `refund_type`, `refund_flag`, `refund_created`, `refund_updated`) VALUES
273(1, 'lbc-otc', 'Test', 'PENDING', 1, NULL, 0, '2015-10-26 10:45:15', '2015-10-26 10:45:15'),
274(2, 'lbc-otc', 'Test', 'APPROVED', 1, NULL, 0, '2015-10-26 10:48:22', '2015-10-26 10:48:33'),
275(3, 'lbc-otc', 'Test', 'PENDING', 1, NULL, 0, '2015-10-26 10:50:56', '2015-10-26 10:50:56');
276
277-- --------------------------------------------------------
278
279--
280-- Table structure for table `refund_quote`
281--
282
283CREATE TABLE IF NOT EXISTS `refund_quote` (
284 `refund_quote_refund` int(10) unsigned NOT NULL,
285 `refund_quote_quote` int(10) unsigned NOT NULL
286) ENGINE=InnoDB DEFAULT CHARSET=utf8;
287
288--
289-- Dumping data for table `refund_quote`
290--
291
292INSERT INTO `refund_quote` (`refund_quote_refund`, `refund_quote_quote`) VALUES
293(2, 1),
294(3, 1);
295
296-- --------------------------------------------------------
297
298--
299-- Table structure for table `role`
300--
301
302CREATE TABLE IF NOT EXISTS `role` (
303`role_id` int(10) unsigned NOT NULL,
304 `role_name` varchar(255) NOT NULL,
305 `role_group` varchar(255) NOT NULL,
306 `role_active` int(1) unsigned NOT NULL DEFAULT '1',
307 `role_type` varchar(255) DEFAULT NULL,
308 `role_flag` int(1) unsigned NOT NULL DEFAULT '0',
309 `role_created` datetime NOT NULL,
310 `role_updated` datetime NOT NULL
311) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
312
313--
314-- Dumping data for table `role`
315--
316
317INSERT INTO `role` (`role_id`, `role_name`, `role_group`, `role_active`, `role_type`, `role_flag`, `role_created`, `role_updated`) VALUES
318(1, 'Super Admin', 'Marketing', 1, NULL, 0, '2015-10-23 15:51:59', '2015-10-23 15:51:59');
319
320-- --------------------------------------------------------
321
322--
323-- Table structure for table `role_permission`
324--
325
326CREATE TABLE IF NOT EXISTS `role_permission` (
327 `role_permission_role` int(10) unsigned NOT NULL,
328 `role_permission_permission` int(10) unsigned NOT NULL
329) ENGINE=InnoDB DEFAULT CHARSET=utf8;
330
331--
332-- Dumping data for table `role_permission`
333--
334
335INSERT INTO `role_permission` (`role_permission_role`, `role_permission_permission`) VALUES
336(1, 1);
337
338-- --------------------------------------------------------
339
340--
341-- Table structure for table `role_profile`
342--
343
344CREATE TABLE IF NOT EXISTS `role_profile` (
345 `role_profile_role` int(10) unsigned NOT NULL,
346 `role_profile_profile` int(10) unsigned NOT NULL
347) ENGINE=InnoDB DEFAULT CHARSET=utf8;
348
349--
350-- Dumping data for table `role_profile`
351--
352
353INSERT INTO `role_profile` (`role_profile_role`, `role_profile_profile`) VALUES
354(1, 4),
355(1, 5),
356(1, 8),
357(1, 10),
358(1, 11);
359
360-- --------------------------------------------------------
361
362--
363-- Table structure for table `session`
364--
365
366CREATE TABLE IF NOT EXISTS `session` (
367`session_id` int(10) unsigned NOT NULL COMMENT 'Database Generated',
368 `session_token` varchar(255) NOT NULL COMMENT 'System Generated',
369 `session_secret` varchar(255) NOT NULL COMMENT 'System Generated',
370 `session_permissions` text NOT NULL COMMENT 'See permissions.json for options',
371 `session_status` varchar(255) NOT NULL DEFAULT 'PENDING' COMMENT 'eg. PENDING, ACCESS etc.',
372 `session_active` int(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Do not delete rows',
373 `session_type` varchar(255) DEFAULT NULL COMMENT 'General usage type',
374 `session_flag` int(1) unsigned NOT NULL DEFAULT '0' COMMENT 'General usage flag',
375 `session_created` datetime NOT NULL COMMENT 'System Generated',
376 `session_updated` datetime NOT NULL COMMENT 'System Generated'
377) ENGINE=InnoDB DEFAULT CHARSET=utf8;
378
379-- --------------------------------------------------------
380
381--
382-- Table structure for table `session_app`
383--
384
385CREATE TABLE IF NOT EXISTS `session_app` (
386 `session_app_session` int(10) unsigned NOT NULL,
387 `session_app_app` int(10) unsigned NOT NULL
388) ENGINE=InnoDB DEFAULT CHARSET=utf8;
389
390-- --------------------------------------------------------
391
392--
393-- Table structure for table `session_auth`
394--
395
396CREATE TABLE IF NOT EXISTS `session_auth` (
397 `session_auth_session` int(10) unsigned NOT NULL,
398 `session_auth_auth` int(10) unsigned NOT NULL
399) ENGINE=InnoDB DEFAULT CHARSET=utf8;
400
401-- --------------------------------------------------------
402
403--
404-- Table structure for table `settlement`
405--
406
407CREATE TABLE IF NOT EXISTS `settlement` (
408`settlement_id` int(10) unsigned NOT NULL,
409 `settlement_fee` int(10) NOT NULL,
410 `settlement_amount` float(10,2) NOT NULL,
411 `settlement_active` int(1) unsigned NOT NULL DEFAULT '1',
412 `settlement_type` varchar(255) DEFAULT NULL,
413 `settlement_flag` int(1) unsigned NOT NULL DEFAULT '0',
414 `settlement_created` datetime NOT NULL,
415 `settlement_updated` datetime NOT NULL
416) ENGINE=InnoDB DEFAULT CHARSET=latin1;
417
418-- --------------------------------------------------------
419
420--
421-- Table structure for table `shop`
422--
423
424CREATE TABLE IF NOT EXISTS `shop` (
425`shop_id` int(10) unsigned NOT NULL,
426 `shop_name` varchar(255) NOT NULL,
427 `shop_reference` varchar(255) NOT NULL,
428 `shop_tin` varchar(255) DEFAULT NULL,
429 `shop_business_name` varchar(255) NOT NULL,
430 `shop_bank_name` varchar(255) NOT NULL,
431 `shop_account_name` varchar(255) NOT NULL,
432 `shop_account_no` int(10) NOT NULL,
433 `shop_category` varchar(255) NOT NULL,
434 `shop_active` int(1) unsigned NOT NULL DEFAULT '1',
435 `shop_type` varchar(255) DEFAULT NULL,
436 `shop_flag` int(1) unsigned NOT NULL DEFAULT '0',
437 `shop_created` datetime NOT NULL,
438 `shop_updated` datetime NOT NULL
439) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
440
441--
442-- Dumping data for table `shop`
443--
444
445INSERT INTO `shop` (`shop_id`, `shop_name`, `shop_reference`, `shop_tin`, `shop_business_name`, `shop_bank_name`, `shop_account_name`, `shop_account_no`, `shop_category`, `shop_active`, `shop_type`, `shop_flag`, `shop_created`, `shop_updated`) VALUES
446(1, 'Kimstore', '123', NULL, 'Kimstore Business Name', 'BDO', 'Account Name', 12345678, 'DIY', 1, NULL, 0, '2015-10-27 17:23:11', '2015-10-27 17:23:11');
447
448-- --------------------------------------------------------
449
450--
451-- Table structure for table `transaction`
452--
453
454CREATE TABLE IF NOT EXISTS `transaction` (
455`transaction_id` int(10) unsigned NOT NULL,
456 `transaction_name` varchar(255) NOT NULL,
457 `transaction_po` varchar(255) NOT NULL,
458 `transaction_order` int(10) NOT NULL,
459 `transaction_method` varchar(255) NOT NULL,
460 `transaction_discount_code` varchar(255) DEFAULT NULL,
461 `transaction_shipping` float(10,2) NOT NULL DEFAULT '0.00',
462 `transaction_insurance` float(10,2) NOT NULL DEFAULT '0.00',
463 `transaction_total` float(10,2) NOT NULL DEFAULT '0.00',
464 `transaction_region` varchar(255) NOT NULL,
465 `transaction_reference` varchar(255) NOT NULL,
466 `transaction_order_date` datetime NOT NULL,
467 `transaction_paid_date` datetime DEFAULT NULL,
468 `transaction_verified_date` datetime DEFAULT NULL,
469 `transaction_tax` float(10,2) DEFAULT '0.00',
470 `transaction_currency` varchar(255) DEFAULT 'PHP',
471 `transaction_email` varchar(255) DEFAULT NULL,
472 `transaction_phone` varchar(255) DEFAULT NULL,
473 `transaction_status` varchar(255) DEFAULT 'PENDING',
474 `transaction_active` int(1) unsigned NOT NULL DEFAULT '1',
475 `transaction_type` varchar(255) DEFAULT NULL,
476 `transaction_flag` int(1) unsigned NOT NULL DEFAULT '0',
477 `transaction_created` datetime NOT NULL,
478 `transaction_updated` datetime NOT NULL
479) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
480
481--
482-- Dumping data for table `transaction`
483--
484
485INSERT INTO `transaction` (`transaction_id`, `transaction_name`, `transaction_po`, `transaction_order`, `transaction_method`, `transaction_discount_code`, `transaction_shipping`, `transaction_insurance`, `transaction_total`, `transaction_region`, `transaction_reference`, `transaction_order_date`, `transaction_paid_date`, `transaction_verified_date`, `transaction_tax`, `transaction_currency`, `transaction_email`, `transaction_phone`, `transaction_status`, `transaction_active`, `transaction_type`, `transaction_flag`, `transaction_created`, `transaction_updated`) VALUES
486(1, 'Juan Dela Cruz', '1234', 1, 'lbc-otc', NULL, 15.00, 15.00, 300.00, 'Laguna', '1234', '2015-10-28 00:00:00', NULL, NULL, 0.00, 'PHP', NULL, NULL, 'PENDING', 1, NULL, 0, '2015-10-27 17:23:11', '2015-10-27 17:23:11');
487
488-- --------------------------------------------------------
489
490--
491-- Table structure for table `transaction_app`
492--
493
494CREATE TABLE IF NOT EXISTS `transaction_app` (
495 `transaction_app_transaction` int(10) unsigned NOT NULL,
496 `transaction_app_app` int(10) unsigned NOT NULL
497) ENGINE=InnoDB DEFAULT CHARSET=utf8;
498
499--
500-- Dumping data for table `transaction_app`
501--
502
503INSERT INTO `transaction_app` (`transaction_app_transaction`, `transaction_app_app`) VALUES
504(1, 1);
505
506-- --------------------------------------------------------
507
508--
509-- Table structure for table `transaction_file`
510--
511
512CREATE TABLE IF NOT EXISTS `transaction_file` (
513 `transaction_file_transaction` int(10) unsigned NOT NULL,
514 `transaction_file_file` int(10) unsigned NOT NULL
515) ENGINE=InnoDB DEFAULT CHARSET=utf8;
516
517-- --------------------------------------------------------
518
519--
520-- Table structure for table `transaction_history`
521--
522
523CREATE TABLE IF NOT EXISTS `transaction_history` (
524 `transaction_history_transaction` int(10) unsigned NOT NULL,
525 `transaction_history_history` int(10) unsigned NOT NULL
526) ENGINE=InnoDB DEFAULT CHARSET=utf8;
527
528-- --------------------------------------------------------
529
530--
531-- Table structure for table `transaction_matching`
532--
533
534CREATE TABLE IF NOT EXISTS `transaction_matching` (
535 `transaction_matching_transaction` int(10) unsigned NOT NULL,
536 `transaction_matching_matching` int(10) unsigned NOT NULL
537) ENGINE=InnoDB DEFAULT CHARSET=utf8;
538
539--
540-- Dumping data for table `transaction_matching`
541--
542
543INSERT INTO `transaction_matching` (`transaction_matching_transaction`, `transaction_matching_matching`) VALUES
544(1, 1);
545
546-- --------------------------------------------------------
547
548--
549-- Table structure for table `transaction_profile`
550--
551
552CREATE TABLE IF NOT EXISTS `transaction_profile` (
553 `transaction_profile_transaction` int(10) unsigned NOT NULL,
554 `transaction_profile_profile` int(10) unsigned NOT NULL
555) ENGINE=InnoDB DEFAULT CHARSET=utf8;
556
557-- --------------------------------------------------------
558
559--
560-- Table structure for table `transaction_quote`
561--
562
563CREATE TABLE IF NOT EXISTS `transaction_quote` (
564 `transaction_quote_transaction` int(10) unsigned NOT NULL,
565 `transaction_quote_quote` int(10) unsigned NOT NULL
566) ENGINE=InnoDB DEFAULT CHARSET=utf8;
567
568--
569-- Dumping data for table `transaction_quote`
570--
571
572INSERT INTO `transaction_quote` (`transaction_quote_transaction`, `transaction_quote_quote`) VALUES
573(1, 1);
574
575-- --------------------------------------------------------
576
577--
578-- Table structure for table `transaction_refund`
579--
580
581CREATE TABLE IF NOT EXISTS `transaction_refund` (
582 `transaction_refund_transaction` int(10) unsigned NOT NULL,
583 `transaction_refund_refund` int(10) unsigned NOT NULL
584) ENGINE=InnoDB DEFAULT CHARSET=utf8;
585
586-- --------------------------------------------------------
587
588--
589-- Table structure for table `transaction_settlement`
590--
591
592CREATE TABLE IF NOT EXISTS `transaction_settlement` (
593 `transaction_settlement_transaction` int(10) unsigned NOT NULL,
594 `transaction_settlement_settlement` int(10) unsigned NOT NULL
595) ENGINE=InnoDB DEFAULT CHARSET=utf8;
596
597-- --------------------------------------------------------
598
599--
600-- Table structure for table `transaction_shop`
601--
602
603CREATE TABLE IF NOT EXISTS `transaction_shop` (
604 `transaction_shop_transaction` int(10) unsigned NOT NULL,
605 `transaction_shop_shop` int(10) unsigned NOT NULL
606) ENGINE=InnoDB DEFAULT CHARSET=utf8;
607
608--
609-- Dumping data for table `transaction_shop`
610--
611
612INSERT INTO `transaction_shop` (`transaction_shop_transaction`, `transaction_shop_shop`) VALUES
613(1, 1);
614
615--
616-- Indexes for dumped tables
617--
618
619--
620-- Indexes for table `app`
621--
622ALTER TABLE `app`
623 ADD PRIMARY KEY (`app_id`), ADD KEY `app_active` (`app_active`), ADD KEY `app_type` (`app_type`), ADD KEY `app_flag` (`app_flag`), ADD KEY `app_created` (`app_created`), ADD KEY `app_updated` (`app_updated`);
624
625--
626-- Indexes for table `app_profile`
627--
628ALTER TABLE `app_profile`
629 ADD PRIMARY KEY (`app_profile_app`,`app_profile_profile`), ADD KEY `profile_id_idx` (`app_profile_profile`);
630
631--
632-- Indexes for table `auth`
633--
634ALTER TABLE `auth`
635 ADD PRIMARY KEY (`auth_id`), ADD UNIQUE KEY `auth_slug` (`auth_slug`), ADD KEY `auth_password` (`auth_password`), ADD KEY `auth_token` (`auth_token`), ADD KEY `auth_secret` (`auth_secret`), ADD KEY `auth_active` (`auth_active`), ADD KEY `auth_type` (`auth_type`), ADD KEY `auth_flag` (`auth_flag`), ADD KEY `auth_created` (`auth_created`), ADD KEY `auth_updated` (`auth_updated`);
636
637--
638-- Indexes for table `auth_profile`
639--
640ALTER TABLE `auth_profile`
641 ADD PRIMARY KEY (`auth_profile_auth`,`auth_profile_profile`), ADD KEY `profile_id_idx` (`auth_profile_profile`);
642
643--
644-- Indexes for table `matching`
645--
646ALTER TABLE `matching`
647 ADD PRIMARY KEY (`matching_id`), ADD KEY `matching_active` (`matching_active`), ADD KEY `matching_type` (`matching_type`), ADD KEY `matching_flag` (`matching_flag`), ADD KEY `matching_created` (`matching_created`), ADD KEY `matching_updated` (`matching_updated`);
648
649--
650-- Indexes for table `permission`
651--
652ALTER TABLE `permission`
653 ADD PRIMARY KEY (`permission_id`), ADD KEY `permission_active` (`permission_active`), ADD KEY `permission_type` (`permission_type`), ADD KEY `permission_flag` (`permission_flag`), ADD KEY `permission_created` (`permission_created`), ADD KEY `permission_updated` (`permission_updated`);
654
655--
656-- Indexes for table `profile`
657--
658ALTER TABLE `profile`
659 ADD PRIMARY KEY (`profile_id`), ADD KEY `profile_active` (`profile_active`), ADD KEY `profile_type` (`profile_type`), ADD KEY `profile_flag` (`profile_flag`), ADD KEY `profile_created` (`profile_created`), ADD KEY `profile_updated` (`profile_updated`);
660
661--
662-- Indexes for table `quote`
663--
664ALTER TABLE `quote`
665 ADD PRIMARY KEY (`quote_id`), ADD KEY `quote_active` (`quote_active`), ADD KEY `quote_type` (`quote_type`), ADD KEY `quote_flag` (`quote_flag`), ADD KEY `quote_created` (`quote_created`), ADD KEY `quote_updated` (`quote_updated`);
666
667--
668-- Indexes for table `refund`
669--
670ALTER TABLE `refund`
671 ADD PRIMARY KEY (`refund_id`), ADD KEY `refund_active` (`refund_active`), ADD KEY `refund_type` (`refund_type`), ADD KEY `refund_flag` (`refund_flag`), ADD KEY `refund_created` (`refund_created`), ADD KEY `refund_updated` (`refund_updated`);
672
673--
674-- Indexes for table `refund_quote`
675--
676ALTER TABLE `refund_quote`
677 ADD PRIMARY KEY (`refund_quote_refund`,`refund_quote_quote`), ADD KEY `quote_id_idx` (`refund_quote_quote`);
678
679--
680-- Indexes for table `role`
681--
682ALTER TABLE `role`
683 ADD PRIMARY KEY (`role_id`), ADD KEY `role_active` (`role_active`), ADD KEY `role_type` (`role_type`), ADD KEY `role_flag` (`role_flag`), ADD KEY `role_created` (`role_created`), ADD KEY `role_updated` (`role_updated`);
684
685--
686-- Indexes for table `role_permission`
687--
688ALTER TABLE `role_permission`
689 ADD PRIMARY KEY (`role_permission_role`,`role_permission_permission`), ADD KEY `permission_id_idx` (`role_permission_permission`);
690
691--
692-- Indexes for table `role_profile`
693--
694ALTER TABLE `role_profile`
695 ADD PRIMARY KEY (`role_profile_role`,`role_profile_profile`), ADD KEY `profile_id_idx` (`role_profile_profile`);
696
697--
698-- Indexes for table `session`
699--
700ALTER TABLE `session`
701 ADD PRIMARY KEY (`session_id`), ADD KEY `session_token` (`session_token`), ADD KEY `session_secret` (`session_secret`), ADD KEY `session_status` (`session_status`), ADD KEY `session_active` (`session_active`), ADD KEY `session_type` (`session_type`), ADD KEY `session_flag` (`session_flag`), ADD KEY `session_created` (`session_created`), ADD KEY `session_updated` (`session_updated`);
702
703--
704-- Indexes for table `session_app`
705--
706ALTER TABLE `session_app`
707 ADD PRIMARY KEY (`session_app_session`,`session_app_app`), ADD KEY `app_id_idx` (`session_app_app`);
708
709--
710-- Indexes for table `session_auth`
711--
712ALTER TABLE `session_auth`
713 ADD PRIMARY KEY (`session_auth_session`,`session_auth_auth`), ADD KEY `auth_id_idx` (`session_auth_auth`);
714
715--
716-- Indexes for table `settlement`
717--
718ALTER TABLE `settlement`
719 ADD PRIMARY KEY (`settlement_id`), ADD KEY `settlement_active` (`settlement_active`), ADD KEY `settlement_type` (`settlement_type`), ADD KEY `settlement_flag` (`settlement_flag`), ADD KEY `settlement_created` (`settlement_created`), ADD KEY `settlement_updated` (`settlement_updated`);
720
721--
722-- Indexes for table `shop`
723--
724ALTER TABLE `shop`
725 ADD PRIMARY KEY (`shop_id`), ADD KEY `shop_active` (`shop_active`), ADD KEY `shop_type` (`shop_type`), ADD KEY `shop_flag` (`shop_flag`), ADD KEY `shop_created` (`shop_created`), ADD KEY `shop_updated` (`shop_updated`);
726
727--
728-- Indexes for table `transaction`
729--
730ALTER TABLE `transaction`
731 ADD PRIMARY KEY (`transaction_id`), ADD KEY `transaction_active` (`transaction_active`), ADD KEY `transaction_type` (`transaction_type`), ADD KEY `transaction_flag` (`transaction_flag`), ADD KEY `transaction_created` (`transaction_created`), ADD KEY `transaction_updated` (`transaction_updated`);
732
733--
734-- Indexes for table `transaction_app`
735--
736ALTER TABLE `transaction_app`
737 ADD PRIMARY KEY (`transaction_app_transaction`,`transaction_app_app`), ADD KEY `app_id_idx` (`transaction_app_app`);
738
739--
740-- Indexes for table `transaction_file`
741--
742ALTER TABLE `transaction_file`
743 ADD PRIMARY KEY (`transaction_file_transaction`,`transaction_file_file`), ADD KEY `file_id_idx` (`transaction_file_file`);
744
745--
746-- Indexes for table `transaction_history`
747--
748ALTER TABLE `transaction_history`
749 ADD PRIMARY KEY (`transaction_history_transaction`,`transaction_history_history`), ADD KEY `history_id_idx` (`transaction_history_history`);
750
751--
752-- Indexes for table `transaction_matching`
753--
754ALTER TABLE `transaction_matching`
755 ADD PRIMARY KEY (`transaction_matching_transaction`,`transaction_matching_matching`), ADD KEY `matching_id_idx` (`transaction_matching_matching`);
756
757--
758-- Indexes for table `transaction_profile`
759--
760ALTER TABLE `transaction_profile`
761 ADD PRIMARY KEY (`transaction_profile_transaction`,`transaction_profile_profile`), ADD KEY `profile_id_idx` (`transaction_profile_profile`);
762
763--
764-- Indexes for table `transaction_quote`
765--
766ALTER TABLE `transaction_quote`
767 ADD PRIMARY KEY (`transaction_quote_transaction`,`transaction_quote_quote`), ADD KEY `quote_id_idx` (`transaction_quote_quote`);
768
769--
770-- Indexes for table `transaction_refund`
771--
772ALTER TABLE `transaction_refund`
773 ADD PRIMARY KEY (`transaction_refund_transaction`,`transaction_refund_refund`), ADD KEY `refund_id_idx` (`transaction_refund_refund`);
774
775--
776-- Indexes for table `transaction_settlement`
777--
778ALTER TABLE `transaction_settlement`
779 ADD PRIMARY KEY (`transaction_settlement_transaction`,`transaction_settlement_settlement`), ADD KEY `settlement_id_idx` (`transaction_settlement_settlement`);
780
781--
782-- Indexes for table `transaction_shop`
783--
784ALTER TABLE `transaction_shop`
785 ADD PRIMARY KEY (`transaction_shop_transaction`,`transaction_shop_shop`), ADD KEY `shop_id_idx` (`transaction_shop_shop`);
786
787--
788-- AUTO_INCREMENT for dumped tables
789--
790
791--
792-- AUTO_INCREMENT for table `app`
793--
794ALTER TABLE `app`
795MODIFY `app_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=2;
796--
797-- AUTO_INCREMENT for table `auth`
798--
799ALTER TABLE `auth`
800MODIFY `auth_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=10;
801--
802-- AUTO_INCREMENT for table `matching`
803--
804ALTER TABLE `matching`
805MODIFY `matching_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
806--
807-- AUTO_INCREMENT for table `permission`
808--
809ALTER TABLE `permission`
810MODIFY `permission_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
811--
812-- AUTO_INCREMENT for table `profile`
813--
814ALTER TABLE `profile`
815MODIFY `profile_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=12;
816--
817-- AUTO_INCREMENT for table `quote`
818--
819ALTER TABLE `quote`
820MODIFY `quote_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
821--
822-- AUTO_INCREMENT for table `refund`
823--
824ALTER TABLE `refund`
825MODIFY `refund_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
826--
827-- AUTO_INCREMENT for table `role`
828--
829ALTER TABLE `role`
830MODIFY `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
831--
832-- AUTO_INCREMENT for table `session`
833--
834ALTER TABLE `session`
835MODIFY `session_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated';
836--
837-- AUTO_INCREMENT for table `settlement`
838--
839ALTER TABLE `settlement`
840MODIFY `settlement_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
841--
842-- AUTO_INCREMENT for table `shop`
843--
844ALTER TABLE `shop`
845MODIFY `shop_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
846--
847-- AUTO_INCREMENT for table `transaction`
848--
849ALTER TABLE `transaction`
850MODIFY `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;