SHARE
TWEET

Untitled

a guest Oct 27th, 2015 173 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
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
 
Top