API tools faq
paste
Advertisement
Guest User

data

a guest
Nov 22nd, 2014
151
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.54 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.10deb1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Nov 22, 2014 at 07:09 PM
  7. -- Server version: 5.5.40-0ubuntu0.14.04.1
  8. -- PHP Version: 5.5.9-1ubuntu4.5
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `pigi-order`
  15. --
  16.  
  17. --
  18. -- Dumping data for table `cake_sessions`
  19. --
  20.  
  21. INSERT INTO `cake_sessions` (`id`, `data`, `expires`) VALUES
  22. ('p2erbo4l1pic0um1bocr4gl0d1', 'Config|a:3:{s:9:"userAgent";s:32:"44d8d13a16633613187a7c43252cf28f";s:4:"time";i:1416676166;s:9:"countdown";i:10;}Message|a:1:{s:4:"auth";a:3:{s:7:"message";s:47:"You are not authorized to access that location.";s:7:"element";s:7:"default";s:6:"params";a:0:{}}}Auth|a:1:{s:4:"User";a:16:{s:2:"id";s:5:"00001";s:4:"uuid";s:8:"s kldsel";s:8:"username";s:15:"admin@admin.com";s:10:"is_visible";b:1;s:15:"incorrect_login";s:1:"0";s:10:"last_login";N;s:23:"force_password_required";b:0;s:14:"is_super_admin";b:0;s:14:"email_verified";b:0;s:19:"email_verified_code";N;s:21:"forgot_password_token";N;s:30:"forgot_password_token_validity";N;s:6:"status";s:1:"0";s:7:"created";s:19:"0000-00-00 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:7:"Profile";a:21:{s:2:"id";s:5:"00001";s:7:"user_id";s:5:"00001";s:4:"uuid";s:3:"ede";s:10:"first_name";s:6:"Sohel ";s:9:"last_name";s:4:"Rana";s:6:"gender";s:1:"1";s:13:"date_of_birth";s:19:"1970-00-00 00:00:00";s:22:"address_primary_street";s:0:"";s:24:"address_secondary_street";s:0:"";s:12:"address_city";s:0:"";s:13:"address_state";N;s:15:"address_country";s:3:"USA";s:19:"address_postal_code";s:5:"00000";s:23:"secondary_email_address";s:1:"-";s:13:"primary_phone";s:12:"xxx xxx-xxxx";s:15:"secondary_phone";s:12:"xxx xxx-xxxx";s:11:"order_count";s:1:"0";s:13:"company_count";s:1:"0";s:6:"status";s:1:"0";s:7:"created";s:19:"0000-00-00 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";}}}', 1416676166);
  23.  
  24. --
  25. -- Dumping data for table `companies`
  26. --
  27.  
  28. INSERT INTO `companies` (`id`, `name`, `slogan`, `description`, `website`, `primary_email_address`, `secondary_email_address`, `billing_email_address`, `admin_email_address`, `primary_street`, `secondary_street`, `city`, `state`, `postal_code`, `primary_phone`, `secondary_phone`, `crm_api_url`, `crm_api_username`, `crm_api_password`, `crm_db_host`, `crm_db_username`, `crm_db_password`, `crm_db_database`, `logo_url`, `authorizenet_api_id`, `authorizenet_access_key`, `authorizenet_sandbox`, `email_gateway_smtp_host`, `email_gateway_smtp_port`, `email_gateway_smtp_username`, `email_gateway_smtp_password`, `email_gateway_mail_from`, `is_visible`, `user_count`, `customer_count`, `order_count`, `status`, `user_id`, `created`, `modified`) VALUES
  29. (3, 'Company Name', '-Company Name', 'Company Name', '-', 'Address', '-', '-', '-', '-', '-', '-', '-', 00000, '-', '-', '', '', '', '', '', '', '', 'http://placehold.it/120x120', NULL, '', 1, 'smtp.mandrillapp.com', 587, 'sean@pigi.com', '657bkksxhJM6oDrobQh_4w', 'no-reply@pigiorders.com', 1, 0, 0, 0, 0, 00001, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  30. (4, 'ANother COmpany', '-', '', '-', '', '-', '-', '-', '-', '-', '-', '-', 00000, '-', '-', '', '', '', '', '', '', '', 'http://placehold.it/120x120', NULL, '', 1, 'smtp.mandrillapp.com', 587, 'sean@pigi.com', '657bkksxhJM6oDrobQh_4w', 'no-reply@pigiorders.com', 1, 0, 0, 0, 0, 00001, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  31. (5, 'Hello', '-', '', '-', '', '-', '-', '-', '-', '-', '-', '-', 00000, '-', '-', '', '', '', '', '', '', '', 'http://placehold.it/120x120', NULL, '', 1, 'smtp.mandrillapp.com', 587, 'sean@pigi.com', '657bkksxhJM6oDrobQh_4w', 'no-reply@pigiorders.com', 1, 0, 0, 0, 0, 00001, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  32.  
  33. --
  34. -- Dumping data for table `companies_users`
  35. --
  36.  
  37. INSERT INTO `companies_users` (`id`, `company_id`, `user_id`, `status`, `created`, `modified`) VALUES
  38. (11, 4, 00020, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  39. (12, 5, 00020, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  40. (13, 3, 00021, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  41. (14, 4, 00021, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  42. (15, 5, 00021, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  43. (16, 3, 00022, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  44. (17, 4, 00022, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  45. (18, 5, 00022, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  46. (19, 4, 00023, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  47. (20, 5, 00023, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  48. (21, 3, 00024, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  49. (22, 4, 00024, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  50. (23, 5, 00024, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  51.  
  52. --
  53. -- Dumping data for table `groups`
  54. --
  55.  
  56. INSERT INTO `groups` (`id`, `name`, `description`, `user_id`, `is_visible`, `status`, `created`, `modified`) VALUES
  57. (1, 'Admin', 'ADmi', 00000001, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  58. (3, 'Billing', 'sad', 00000001, 1, 0, '2014-11-22 19:09:11', '2014-11-22 19:09:11');
  59.  
  60. --
  61. -- Dumping data for table `groups_users`
  62. --
  63.  
  64. INSERT INTO `groups_users` (`id`, `group_id`, `user_id`, `status`, `created`, `modified`) VALUES
  65. (5, 1, 00020, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  66. (6, 1, 00021, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  67. (7, 1, 00022, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  68. (8, 1, 00023, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  69. (9, 1, 00024, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  70. (10, 3, 00020, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  71. (11, 3, 00021, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  72. (12, 3, 00022, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  73. (13, 3, 00023, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  74.  
  75. --
  76. -- Dumping data for table `profiles`
  77. --
  78.  
  79. INSERT INTO `profiles` (`id`, `user_id`, `uuid`, `first_name`, `last_name`, `gender`, `date_of_birth`, `address_primary_street`, `address_secondary_street`, `address_city`, `address_state`, `address_country`, `address_postal_code`, `secondary_email_address`, `primary_phone`, `secondary_phone`, `order_count`, `company_count`, `status`, `created`, `modified`) VALUES
  80. (00001, 00001, 'ede', 'Sohel ', 'Rana', 1, '1970-00-00 00:00:00', '', '', '', NULL, 'USA', 00000, '-', 'xxx xxx-xxxx', 'xxx xxx-xxxx', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  81. (00007, 00020, '', 'adsdasd', 'asdas', 1, '1970-00-00 00:00:00', '', '', '', NULL, 'USA', 00000, '-', 'xxx xxx-xxxx', 'xxx xxx-xxxx', 0, 0, 0, '2014-11-22 18:02:36', '2014-11-22 18:02:36'),
  82. (00008, 00021, '', 'First', 'Last', 1, '1970-00-00 00:00:00', '', '', '', NULL, 'USA', 00000, '-', 'xxx xxx-xxxx', 'xxx xxx-xxxx', 0, 0, 0, '2014-11-22 18:04:35', '2014-11-22 18:04:35'),
  83. (00009, 00022, '', 'test', 'Test', 1, '1970-00-00 00:00:00', '', '', '', NULL, 'USA', 00000, '-', 'xxx xxx-xxxx', 'xxx xxx-xxxx', 0, 0, 0, '2014-11-22 18:12:25', '2014-11-22 18:12:25'),
  84. (00010, 00023, '', 'First Name', 'Last Name', 1, '1970-00-00 00:00:00', '', '', '', NULL, 'USA', 00000, '-', 'xxx xxx-xxxx', 'xxx xxx-xxxx', 0, 0, 0, '2014-11-22 18:52:09', '2014-11-22 18:52:09'),
  85. (00011, 00024, '', 'First Name', 'Last Name', 1, '1970-00-00 00:00:00', '', '', '', NULL, 'USA', 00000, '-', 'xxx xxx-xxxx', 'xxx xxx-xxxx', 0, 0, 0, '2014-11-22 18:57:27', '2014-11-22 18:57:27');
  86.  
  87. --
  88. -- Dumping data for table `users`
  89. --
  90.  
  91. INSERT INTO `users` (`id`, `uuid`, `username`, `password`, `is_visible`, `incorrect_login`, `last_login`, `force_password_required`, `is_super_admin`, `email_verified`, `email_verified_code`, `forgot_password_token`, `forgot_password_token_validity`, `status`, `created`, `modified`) VALUES
  92. (00001, 's kldsel', 'admin@admin.com', '3b9cfce2378d0548a323d3484463d0a5f04cedb4', 1, 0, NULL, 0, 0, 0, NULL, NULL, NULL, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  93. (00020, '', 'asdasd', '', 1, 0, NULL, 1, 0, 0, NULL, NULL, NULL, 0, '2014-11-22 18:02:36', '2014-11-22 18:02:36'),
  94. (00021, '54707bd3-73fc-4611-a87a-3b9f7f000101', 'email@gmail.com', '', 1, 0, NULL, 1, 1, 0, NULL, NULL, NULL, 0, '2014-11-22 18:04:35', '2014-11-22 18:04:35'),
  95. (00022, '54707da9-6ae8-46b2-a579-3cd17f000101', 'test@gmail.comtest', '', 1, 0, NULL, 1, 1, 0, NULL, NULL, NULL, 0, '2014-11-22 18:12:25', '2014-11-22 18:12:25'),
  96. (00023, '547086f9-a6c4-423d-8852-3cd17f000101', 'emaiel@gmail.com', '123456', 1, 0, NULL, 0, 0, 0, NULL, NULL, NULL, 0, '2014-11-22 18:52:09', '2014-11-22 18:52:09'),
  97. (00024, '54708837-e5a0-4017-9f50-3eb67f000101', 'adminf@admin.com', '3b9cfce2378d0548a323d3484463d0a5f04cedb4', 0, 0, NULL, 1, 0, 0, NULL, NULL, NULL, 0, '2014-11-22 18:57:27', '2014-11-22 18:57:27');
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!