API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 27th, 2015
251
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.22 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 11:30 AM
  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, 0, 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_amount` float(10,2) NOT NULL DEFAULT '0.00',
  237. `quote_product_id` int(10) NOT NULL,
  238. `quote_variant` varchar(255) DEFAULT NULL,
  239. `quote_weight` float(10,2) NOT NULL DEFAULT '0.00',
  240. `quote_tax` float(10,2) DEFAULT '0.00',
  241. `quote_active` int(1) unsigned NOT NULL DEFAULT '1',
  242. `quote_type` varchar(255) DEFAULT NULL,
  243. `quote_flag` int(1) unsigned NOT NULL DEFAULT '0',
  244. `quote_created` datetime NOT NULL,
  245. `quote_updated` datetime NOT NULL
  246. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  247.  
  248. --
  249. -- Dumping data for table `quote`
  250. --
  251.  
  252. INSERT INTO `quote` (`quote_id`, `quote_name`, `quote_reference`, `quote_amount`, `quote_product_id`, `quote_variant`, `quote_weight`, `quote_tax`, `quote_active`, `quote_type`, `quote_flag`, `quote_created`, `quote_updated`) VALUES
  253. (1, 'Quote Name', '1234', 300.00, 1, NULL, 3.00, 0.00, 1, NULL, 0, '2015-10-27 17:23:11', '2015-10-27 17:23:11');
  254.  
  255. -- --------------------------------------------------------
  256.  
  257. --
  258. -- Table structure for table `refund`
  259. --
  260.  
  261. CREATE TABLE IF NOT EXISTS `refund` (
  262. `refund_id` int(10) unsigned NOT NULL,
  263. `refund_method` varchar(255) NOT NULL,
  264. `refund_reason` varchar(255) NOT NULL,
  265. `refund_status` varchar(255) DEFAULT 'PENDING',
  266. `refund_active` int(1) unsigned NOT NULL DEFAULT '1',
  267. `refund_type` varchar(255) DEFAULT NULL,
  268. `refund_flag` int(1) unsigned NOT NULL DEFAULT '0',
  269. `refund_created` datetime NOT NULL,
  270. `refund_updated` datetime NOT NULL
  271. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  272.  
  273. --
  274. -- Dumping data for table `refund`
  275. --
  276.  
  277. INSERT INTO `refund` (`refund_id`, `refund_method`, `refund_reason`, `refund_status`, `refund_active`, `refund_type`, `refund_flag`, `refund_created`, `refund_updated`) VALUES
  278. (1, 'lbc-otc', 'Test', 'PENDING', 1, NULL, 0, '2015-10-26 10:45:15', '2015-10-26 10:45:15'),
  279. (2, 'lbc-otc', 'Test', 'APPROVED', 1, NULL, 0, '2015-10-26 10:48:22', '2015-10-26 10:48:33'),
  280. (3, 'lbc-otc', 'Test', 'PENDING', 1, NULL, 0, '2015-10-26 10:50:56', '2015-10-26 10:50:56');
  281.  
  282. -- --------------------------------------------------------
  283.  
  284. --
  285. -- Table structure for table `refund_quote`
  286. --
  287.  
  288. CREATE TABLE IF NOT EXISTS `refund_quote` (
  289. `refund_quote_refund` int(10) unsigned NOT NULL,
  290. `refund_quote_quote` int(10) unsigned NOT NULL
  291. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  292.  
  293. --
  294. -- Dumping data for table `refund_quote`
  295. --
  296.  
  297. INSERT INTO `refund_quote` (`refund_quote_refund`, `refund_quote_quote`) VALUES
  298. (2, 1),
  299. (3, 1);
  300.  
  301. -- --------------------------------------------------------
  302.  
  303. --
  304. -- Table structure for table `role`
  305. --
  306.  
  307. CREATE TABLE IF NOT EXISTS `role` (
  308. `role_id` int(10) unsigned NOT NULL,
  309. `role_name` varchar(255) NOT NULL,
  310. `role_group` varchar(255) NOT NULL,
  311. `role_active` int(1) unsigned NOT NULL DEFAULT '1',
  312. `role_type` varchar(255) DEFAULT NULL,
  313. `role_flag` int(1) unsigned NOT NULL DEFAULT '0',
  314. `role_created` datetime NOT NULL,
  315. `role_updated` datetime NOT NULL
  316. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  317.  
  318. --
  319. -- Dumping data for table `role`
  320. --
  321.  
  322. INSERT INTO `role` (`role_id`, `role_name`, `role_group`, `role_active`, `role_type`, `role_flag`, `role_created`, `role_updated`) VALUES
  323. (1, 'Super Admin', 'Marketing', 1, NULL, 0, '2015-10-23 15:51:59', '2015-10-23 15:51:59');
  324.  
  325. -- --------------------------------------------------------
  326.  
  327. --
  328. -- Table structure for table `role_permission`
  329. --
  330.  
  331. CREATE TABLE IF NOT EXISTS `role_permission` (
  332. `role_permission_role` int(10) unsigned NOT NULL,
  333. `role_permission_permission` int(10) unsigned NOT NULL
  334. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  335.  
  336. --
  337. -- Dumping data for table `role_permission`
  338. --
  339.  
  340. INSERT INTO `role_permission` (`role_permission_role`, `role_permission_permission`) VALUES
  341. (1, 1);
  342.  
  343. -- --------------------------------------------------------
  344.  
  345. --
  346. -- Table structure for table `role_profile`
  347. --
  348.  
  349. CREATE TABLE IF NOT EXISTS `role_profile` (
  350. `role_profile_role` int(10) unsigned NOT NULL,
  351. `role_profile_profile` int(10) unsigned NOT NULL
  352. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  353.  
  354. --
  355. -- Dumping data for table `role_profile`
  356. --
  357.  
  358. INSERT INTO `role_profile` (`role_profile_role`, `role_profile_profile`) VALUES
  359. (1, 4),
  360. (1, 5),
  361. (1, 8),
  362. (1, 10),
  363. (1, 11);
  364.  
  365. -- --------------------------------------------------------
  366.  
  367. --
  368. -- Table structure for table `session`
  369. --
  370.  
  371. CREATE TABLE IF NOT EXISTS `session` (
  372. `session_id` int(10) unsigned NOT NULL COMMENT 'Database Generated',
  373. `session_token` varchar(255) NOT NULL COMMENT 'System Generated',
  374. `session_secret` varchar(255) NOT NULL COMMENT 'System Generated',
  375. `session_permissions` text NOT NULL COMMENT 'See permissions.json for options',
  376. `session_status` varchar(255) NOT NULL DEFAULT 'PENDING' COMMENT 'eg. PENDING, ACCESS etc.',
  377. `session_active` int(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Do not delete rows',
  378. `session_type` varchar(255) DEFAULT NULL COMMENT 'General usage type',
  379. `session_flag` int(1) unsigned NOT NULL DEFAULT '0' COMMENT 'General usage flag',
  380. `session_created` datetime NOT NULL COMMENT 'System Generated',
  381. `session_updated` datetime NOT NULL COMMENT 'System Generated'
  382. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  383.  
  384. -- --------------------------------------------------------
  385.  
  386. --
  387. -- Table structure for table `session_app`
  388. --
  389.  
  390. CREATE TABLE IF NOT EXISTS `session_app` (
  391. `session_app_session` int(10) unsigned NOT NULL,
  392. `session_app_app` int(10) unsigned NOT NULL
  393. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  394.  
  395. -- --------------------------------------------------------
  396.  
  397. --
  398. -- Table structure for table `session_auth`
  399. --
  400.  
  401. CREATE TABLE IF NOT EXISTS `session_auth` (
  402. `session_auth_session` int(10) unsigned NOT NULL,
  403. `session_auth_auth` int(10) unsigned NOT NULL
  404. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  405.  
  406. -- --------------------------------------------------------
  407.  
  408. --
  409. -- Table structure for table `settlement`
  410. --
  411.  
  412. CREATE TABLE IF NOT EXISTS `settlement` (
  413. `settlement_id` int(10) unsigned NOT NULL,
  414. `settlement_fee` int(10) NOT NULL,
  415. `settlement_amount` float(10,2) NOT NULL,
  416. `settlement_active` int(1) unsigned NOT NULL DEFAULT '1',
  417. `settlement_type` varchar(255) DEFAULT NULL,
  418. `settlement_flag` int(1) unsigned NOT NULL DEFAULT '0',
  419. `settlement_created` datetime NOT NULL,
  420. `settlement_updated` datetime NOT NULL
  421. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  422.  
  423. -- --------------------------------------------------------
  424.  
  425. --
  426. -- Table structure for table `shop`
  427. --
  428.  
  429. CREATE TABLE IF NOT EXISTS `shop` (
  430. `shop_id` int(10) unsigned NOT NULL,
  431. `shop_name` varchar(255) NOT NULL,
  432. `shop_reference` varchar(255) NOT NULL,
  433. `shop_tin` varchar(255) DEFAULT NULL,
  434. `shop_business_name` varchar(255) NOT NULL,
  435. `shop_bank_name` varchar(255) NOT NULL,
  436. `shop_account_name` varchar(255) NOT NULL,
  437. `shop_account_no` int(10) NOT NULL,
  438. `shop_category` varchar(255) NOT NULL,
  439. `shop_active` int(1) unsigned NOT NULL DEFAULT '1',
  440. `shop_type` varchar(255) DEFAULT NULL,
  441. `shop_flag` int(1) unsigned NOT NULL DEFAULT '0',
  442. `shop_created` datetime NOT NULL,
  443. `shop_updated` datetime NOT NULL
  444. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  445.  
  446. --
  447. -- Dumping data for table `shop`
  448. --
  449.  
  450. 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
  451. (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');
  452.  
  453. -- --------------------------------------------------------
  454.  
  455. --
  456. -- Table structure for table `transaction`
  457. --
  458.  
  459. CREATE TABLE IF NOT EXISTS `transaction` (
  460. `transaction_id` int(10) unsigned NOT NULL,
  461. `transaction_name` varchar(255) NOT NULL,
  462. `transaction_po` varchar(255) NOT NULL,
  463. `transaction_order` int(10) NOT NULL,
  464. `transaction_method` varchar(255) NOT NULL,
  465. `transaction_discount_code` varchar(255) DEFAULT NULL,
  466. `transaction_shipping` float(10,2) NOT NULL DEFAULT '0.00',
  467. `transaction_insurance` float(10,2) NOT NULL DEFAULT '0.00',
  468. `transaction_total` float(10,2) NOT NULL DEFAULT '0.00',
  469. `transaction_region` varchar(255) NOT NULL,
  470. `transaction_reference` varchar(255) NOT NULL,
  471. `transaction_order_date` datetime NOT NULL,
  472. `transaction_paid_date` datetime DEFAULT NULL,
  473. `transaction_verified_date` datetime DEFAULT NULL,
  474. `transaction_tax` float(10,2) DEFAULT '0.00',
  475. `transaction_currency` varchar(255) DEFAULT 'PHP',
  476. `transaction_email` varchar(255) DEFAULT NULL,
  477. `transaction_phone` varchar(255) DEFAULT NULL,
  478. `transaction_status` varchar(255) DEFAULT 'PENDING',
  479. `transaction_active` int(1) unsigned NOT NULL DEFAULT '1',
  480. `transaction_type` varchar(255) DEFAULT NULL,
  481. `transaction_flag` int(1) unsigned NOT NULL DEFAULT '0',
  482. `transaction_created` datetime NOT NULL,
  483. `transaction_updated` datetime NOT NULL
  484. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  485.  
  486. --
  487. -- Dumping data for table `transaction`
  488. --
  489.  
  490. 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
  491. (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');
  492.  
  493. -- --------------------------------------------------------
  494.  
  495. --
  496. -- Table structure for table `transaction_app`
  497. --
  498.  
  499. CREATE TABLE IF NOT EXISTS `transaction_app` (
  500. `transaction_app_transaction` int(10) unsigned NOT NULL,
  501. `transaction_app_app` int(10) unsigned NOT NULL
  502. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  503.  
  504. --
  505. -- Dumping data for table `transaction_app`
  506. --
  507.  
  508. INSERT INTO `transaction_app` (`transaction_app_transaction`, `transaction_app_app`) VALUES
  509. (1, 1);
  510.  
  511. -- --------------------------------------------------------
  512.  
  513. --
  514. -- Table structure for table `transaction_file`
  515. --
  516.  
  517. CREATE TABLE IF NOT EXISTS `transaction_file` (
  518. `transaction_file_transaction` int(10) unsigned NOT NULL,
  519. `transaction_file_file` int(10) unsigned NOT NULL
  520. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  521.  
  522. -- --------------------------------------------------------
  523.  
  524. --
  525. -- Table structure for table `transaction_history`
  526. --
  527.  
  528. CREATE TABLE IF NOT EXISTS `transaction_history` (
  529. `transaction_history_transaction` int(10) unsigned NOT NULL,
  530. `transaction_history_history` int(10) unsigned NOT NULL
  531. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  532.  
  533. -- --------------------------------------------------------
  534.  
  535. --
  536. -- Table structure for table `transaction_matching`
  537. --
  538.  
  539. CREATE TABLE IF NOT EXISTS `transaction_matching` (
  540. `transaction_matching_transaction` int(10) unsigned NOT NULL,
  541. `transaction_matching_matching` int(10) unsigned NOT NULL
  542. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  543.  
  544. --
  545. -- Dumping data for table `transaction_matching`
  546. --
  547.  
  548. INSERT INTO `transaction_matching` (`transaction_matching_transaction`, `transaction_matching_matching`) VALUES
  549. (1, 1);
  550.  
  551. -- --------------------------------------------------------
  552.  
  553. --
  554. -- Table structure for table `transaction_profile`
  555. --
  556.  
  557. CREATE TABLE IF NOT EXISTS `transaction_profile` (
  558. `transaction_profile_transaction` int(10) unsigned NOT NULL,
  559. `transaction_profile_profile` int(10) unsigned NOT NULL
  560. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  561.  
  562. -- --------------------------------------------------------
  563.  
  564. --
  565. -- Table structure for table `transaction_quote`
  566. --
  567.  
  568. CREATE TABLE IF NOT EXISTS `transaction_quote` (
  569. `transaction_quote_transaction` int(10) unsigned NOT NULL,
  570. `transaction_quote_quote` int(10) unsigned NOT NULL
  571. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  572.  
  573. --
  574. -- Dumping data for table `transaction_quote`
  575. --
  576.  
  577. INSERT INTO `transaction_quote` (`transaction_quote_transaction`, `transaction_quote_quote`) VALUES
  578. (1, 1);
  579.  
  580. -- --------------------------------------------------------
  581.  
  582. --
  583. -- Table structure for table `transaction_refund`
  584. --
  585.  
  586. CREATE TABLE IF NOT EXISTS `transaction_refund` (
  587. `transaction_refund_transaction` int(10) unsigned NOT NULL,
  588. `transaction_refund_refund` int(10) unsigned NOT NULL
  589. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  590.  
  591. -- --------------------------------------------------------
  592.  
  593. --
  594. -- Table structure for table `transaction_settlement`
  595. --
  596.  
  597. CREATE TABLE IF NOT EXISTS `transaction_settlement` (
  598. `transaction_settlement_transaction` int(10) unsigned NOT NULL,
  599. `transaction_settlement_settlement` int(10) unsigned NOT NULL
  600. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  601.  
  602. -- --------------------------------------------------------
  603.  
  604. --
  605. -- Table structure for table `transaction_shop`
  606. --
  607.  
  608. CREATE TABLE IF NOT EXISTS `transaction_shop` (
  609. `transaction_shop_transaction` int(10) unsigned NOT NULL,
  610. `transaction_shop_shop` int(10) unsigned NOT NULL
  611. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  612.  
  613. --
  614. -- Dumping data for table `transaction_shop`
  615. --
  616.  
  617. INSERT INTO `transaction_shop` (`transaction_shop_transaction`, `transaction_shop_shop`) VALUES
  618. (1, 1);
  619.  
  620. --
  621. -- Indexes for dumped tables
  622. --
  623.  
  624. --
  625. -- Indexes for table `app`
  626. --
  627. ALTER TABLE `app`
  628. 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`);
  629.  
  630. --
  631. -- Indexes for table `app_profile`
  632. --
  633. ALTER TABLE `app_profile`
  634. ADD PRIMARY KEY (`app_profile_app`,`app_profile_profile`), ADD KEY `profile_id_idx` (`app_profile_profile`);
  635.  
  636. --
  637. -- Indexes for table `auth`
  638. --
  639. ALTER TABLE `auth`
  640. 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`);
  641.  
  642. --
  643. -- Indexes for table `auth_profile`
  644. --
  645. ALTER TABLE `auth_profile`
  646. ADD PRIMARY KEY (`auth_profile_auth`,`auth_profile_profile`), ADD KEY `profile_id_idx` (`auth_profile_profile`);
  647.  
  648. --
  649. -- Indexes for table `matching`
  650. --
  651. ALTER TABLE `matching`
  652. 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`);
  653.  
  654. --
  655. -- Indexes for table `permission`
  656. --
  657. ALTER TABLE `permission`
  658. 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`);
  659.  
  660. --
  661. -- Indexes for table `profile`
  662. --
  663. ALTER TABLE `profile`
  664. 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`);
  665.  
  666. --
  667. -- Indexes for table `quote`
  668. --
  669. ALTER TABLE `quote`
  670. 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`);
  671.  
  672. --
  673. -- Indexes for table `refund`
  674. --
  675. ALTER TABLE `refund`
  676. 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`);
  677.  
  678. --
  679. -- Indexes for table `refund_quote`
  680. --
  681. ALTER TABLE `refund_quote`
  682. ADD PRIMARY KEY (`refund_quote_refund`,`refund_quote_quote`), ADD KEY `quote_id_idx` (`refund_quote_quote`);
  683.  
  684. --
  685. -- Indexes for table `role`
  686. --
  687. ALTER TABLE `role`
  688. 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`);
  689.  
  690. --
  691. -- Indexes for table `role_permission`
  692. --
  693. ALTER TABLE `role_permission`
  694. ADD PRIMARY KEY (`role_permission_role`,`role_permission_permission`), ADD KEY `permission_id_idx` (`role_permission_permission`);
  695.  
  696. --
  697. -- Indexes for table `role_profile`
  698. --
  699. ALTER TABLE `role_profile`
  700. ADD PRIMARY KEY (`role_profile_role`,`role_profile_profile`), ADD KEY `profile_id_idx` (`role_profile_profile`);
  701.  
  702. --
  703. -- Indexes for table `session`
  704. --
  705. ALTER TABLE `session`
  706. 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`);
  707.  
  708. --
  709. -- Indexes for table `session_app`
  710. --
  711. ALTER TABLE `session_app`
  712. ADD PRIMARY KEY (`session_app_session`,`session_app_app`), ADD KEY `app_id_idx` (`session_app_app`);
  713.  
  714. --
  715. -- Indexes for table `session_auth`
  716. --
  717. ALTER TABLE `session_auth`
  718. ADD PRIMARY KEY (`session_auth_session`,`session_auth_auth`), ADD KEY `auth_id_idx` (`session_auth_auth`);
  719.  
  720. --
  721. -- Indexes for table `settlement`
  722. --
  723. ALTER TABLE `settlement`
  724. 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`);
  725.  
  726. --
  727. -- Indexes for table `shop`
  728. --
  729. ALTER TABLE `shop`
  730. 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`);
  731.  
  732. --
  733. -- Indexes for table `transaction`
  734. --
  735. ALTER TABLE `transaction`
  736. 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`);
  737.  
  738. --
  739. -- Indexes for table `transaction_app`
  740. --
  741. ALTER TABLE `transaction_app`
  742. ADD PRIMARY KEY (`transaction_app_transaction`,`transaction_app_app`), ADD KEY `app_id_idx` (`transaction_app_app`);
  743.  
  744. --
  745. -- Indexes for table `transaction_file`
  746. --
  747. ALTER TABLE `transaction_file`
  748. ADD PRIMARY KEY (`transaction_file_transaction`,`transaction_file_file`), ADD KEY `file_id_idx` (`transaction_file_file`);
  749.  
  750. --
  751. -- Indexes for table `transaction_history`
  752. --
  753. ALTER TABLE `transaction_history`
  754. ADD PRIMARY KEY (`transaction_history_transaction`,`transaction_history_history`), ADD KEY `history_id_idx` (`transaction_history_history`);
  755.  
  756. --
  757. -- Indexes for table `transaction_matching`
  758. --
  759. ALTER TABLE `transaction_matching`
  760. ADD PRIMARY KEY (`transaction_matching_transaction`,`transaction_matching_matching`), ADD KEY `matching_id_idx` (`transaction_matching_matching`);
  761.  
  762. --
  763. -- Indexes for table `transaction_profile`
  764. --
  765. ALTER TABLE `transaction_profile`
  766. ADD PRIMARY KEY (`transaction_profile_transaction`,`transaction_profile_profile`), ADD KEY `profile_id_idx` (`transaction_profile_profile`);
  767.  
  768. --
  769. -- Indexes for table `transaction_quote`
  770. --
  771. ALTER TABLE `transaction_quote`
  772. ADD PRIMARY KEY (`transaction_quote_transaction`,`transaction_quote_quote`), ADD KEY `quote_id_idx` (`transaction_quote_quote`);
  773.  
  774. --
  775. -- Indexes for table `transaction_refund`
  776. --
  777. ALTER TABLE `transaction_refund`
  778. ADD PRIMARY KEY (`transaction_refund_transaction`,`transaction_refund_refund`), ADD KEY `refund_id_idx` (`transaction_refund_refund`);
  779.  
  780. --
  781. -- Indexes for table `transaction_settlement`
  782. --
  783. ALTER TABLE `transaction_settlement`
  784. ADD PRIMARY KEY (`transaction_settlement_transaction`,`transaction_settlement_settlement`), ADD KEY `settlement_id_idx` (`transaction_settlement_settlement`);
  785.  
  786. --
  787. -- Indexes for table `transaction_shop`
  788. --
  789. ALTER TABLE `transaction_shop`
  790. ADD PRIMARY KEY (`transaction_shop_transaction`,`transaction_shop_shop`), ADD KEY `shop_id_idx` (`transaction_shop_shop`);
  791.  
  792. --
  793. -- AUTO_INCREMENT for dumped tables
  794. --
  795.  
  796. --
  797. -- AUTO_INCREMENT for table `app`
  798. --
  799. ALTER TABLE `app`
  800. MODIFY `app_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=2;
  801. --
  802. -- AUTO_INCREMENT for table `auth`
  803. --
  804. ALTER TABLE `auth`
  805. MODIFY `auth_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=10;
  806. --
  807. -- AUTO_INCREMENT for table `matching`
  808. --
  809. ALTER TABLE `matching`
  810. MODIFY `matching_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
  811. --
  812. -- AUTO_INCREMENT for table `permission`
  813. --
  814. ALTER TABLE `permission`
  815. MODIFY `permission_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
  816. --
  817. -- AUTO_INCREMENT for table `profile`
  818. --
  819. ALTER TABLE `profile`
  820. MODIFY `profile_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated',AUTO_INCREMENT=12;
  821. --
  822. -- AUTO_INCREMENT for table `quote`
  823. --
  824. ALTER TABLE `quote`
  825. MODIFY `quote_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  826. --
  827. -- AUTO_INCREMENT for table `refund`
  828. --
  829. ALTER TABLE `refund`
  830. MODIFY `refund_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
  831. --
  832. -- AUTO_INCREMENT for table `role`
  833. --
  834. ALTER TABLE `role`
  835. MODIFY `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  836. --
  837. -- AUTO_INCREMENT for table `session`
  838. --
  839. ALTER TABLE `session`
  840. MODIFY `session_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Database Generated';
  841. --
  842. -- AUTO_INCREMENT for table `settlement`
  843. --
  844. ALTER TABLE `settlement`
  845. MODIFY `settlement_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
  846. --
  847. -- AUTO_INCREMENT for table `shop`
  848. --
  849. ALTER TABLE `shop`
  850. MODIFY `shop_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  851. --
  852. -- AUTO_INCREMENT for table `transaction`
  853. --
  854. ALTER TABLE `transaction`
  855. 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!