API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 28th, 2015
251
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 33.89 KB | None | 0 0
raw download clone embed print report
  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.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `finance`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `app`
  21. --
  22.  
  23. CREATE 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.  
  42. INSERT 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.  
  51. CREATE 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.  
  60. INSERT 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.  
  69. CREATE 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.  
  95. INSERT 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.  
  109. CREATE 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.  
  118. INSERT 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.  
  132. CREATE 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.  
  152. INSERT 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.  
  162. CREATE 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.  
  176. INSERT 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.  
  188. CREATE 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.  
  218. INSERT 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.  
  232. CREATE 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.  
  256. CREATE 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.  
  272. INSERT 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.  
  283. CREATE 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.  
  292. INSERT 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.  
  302. CREATE 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.  
  317. INSERT 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.  
  326. CREATE 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.  
  335. INSERT 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.  
  344. CREATE 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.  
  353. INSERT 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.  
  366. CREATE 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.  
  385. CREATE 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.  
  396. CREATE 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.  
  407. CREATE 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.  
  424. CREATE 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.  
  445. INSERT 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.  
  454. CREATE 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.  
  485. INSERT 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.  
  494. CREATE 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.  
  503. INSERT 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.  
  512. CREATE 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.  
  523. CREATE 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.  
  534. CREATE 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.  
  543. INSERT 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.  
  552. CREATE 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.  
  563. CREATE 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.  
  572. INSERT 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.  
  581. CREATE 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.  
  592. CREATE 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.  
  603. CREATE 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.  
  612. INSERT 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. --
  622. ALTER 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. --
  628. ALTER 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. --
  634. ALTER 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. --
  640. ALTER 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. --
  646. ALTER 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. --
  652. ALTER 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. --
  658. ALTER 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. --
  664. ALTER 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. --
  670. ALTER 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. --
  676. ALTER 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. --
  682. ALTER 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. --
  688. ALTER 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. --
  694. ALTER 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. --
  700. ALTER 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. --
  706. ALTER 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. --
  712. ALTER 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. --
  718. ALTER 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. --
  724. ALTER 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. --
  730. ALTER 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. --
  736. ALTER 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. --
  742. ALTER 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. --
  748. ALTER 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. --
  754. ALTER 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. --
  760. ALTER 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. --
  766. ALTER 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. --
  772. ALTER 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. --
  778. ALTER 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. --
  784. ALTER 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. --
  794. ALTER TABLE `app`
  795. MODIFY `app_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=2;
  796. --
  797. -- AUTO_INCREMENT for table `auth`
  798. --
  799. ALTER TABLE `auth`
  800. MODIFY `auth_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=10;
  801. --
  802. -- AUTO_INCREMENT for table `matching`
  803. --
  804. ALTER TABLE `matching`
  805. MODIFY `matching_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
  806. --
  807. -- AUTO_INCREMENT for table `permission`
  808. --
  809. ALTER TABLE `permission`
  810. MODIFY `permission_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
  811. --
  812. -- AUTO_INCREMENT for table `profile`
  813. --
  814. ALTER TABLE `profile`
  815. MODIFY `profile_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=12;
  816. --
  817. -- AUTO_INCREMENT for table `quote`
  818. --
  819. ALTER TABLE `quote`
  820. MODIFY `quote_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
  821. --
  822. -- AUTO_INCREMENT for table `refund`
  823. --
  824. ALTER TABLE `refund`
  825. MODIFY `refund_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
  826. --
  827. -- AUTO_INCREMENT for table `role`
  828. --
  829. ALTER TABLE `role`
  830. MODIFY `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  831. --
  832. -- AUTO_INCREMENT for table `session`
  833. --
  834. ALTER TABLE `session`
  835. MODIFY `session_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated';
  836. --
  837. -- AUTO_INCREMENT for table `settlement`
  838. --
  839. ALTER TABLE `settlement`
  840. MODIFY `settlement_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
  841. --
  842. -- AUTO_INCREMENT for table `shop`
  843. --
  844. ALTER TABLE `shop`
  845. MODIFY `shop_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  846. --
  847. -- AUTO_INCREMENT for table `transaction`
  848. --
  849. ALTER TABLE `transaction`
  850. MODIFY `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!