API tools faq
paste
Advertisement
Guest User

app

a guest
Jul 23rd, 2014
182
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 96.48 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.6deb1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jul 23, 2014 at 07:37 PM
  7. -- Server version: 5.5.37-0ubuntu0.13.10.1
  8. -- PHP Version: 5.5.14-1+deb.sury.org~saucy+1
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `dealerpresentation_apps`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `activities`
  21. --
  22.  
  23. CREATE TABLE IF NOT EXISTS `activities` (
  24. `id` int(11) NOT NULL AUTO_INCREMENT,
  25. `user_id` int(8) DEFAULT NULL,
  26. `lead_id` int(8) DEFAULT NULL,
  27. `title` varchar(255) NOT NULL,
  28. `description` text NOT NULL,
  29. `created` datetime NOT NULL,
  30. `modified` datetime NOT NULL,
  31. PRIMARY KEY (`id`)
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf16 AUTO_INCREMENT=185 ;
  33.  
  34. --
  35. -- Dumping data for table `activities`
  36. --
  37.  
  38. INSERT INTO `activities` (`id`, `user_id`, `lead_id`, `title`, `description`, `created`, `modified`) VALUES
  39. (1, 1, NULL, 'New Market Created', 'new market has been created byAdmin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And market name is (<a href="http://app.dealer-presentation.dev/~prefix~/markets/edit/1">Stock Exchange Bangladesh)</a>', '2014-06-15 03:40:14', '2014-06-15 03:40:14'),
  40. (2, 1, NULL, 'New Market Created', 'new market has been created byAdmin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And market name is (<a href="http://app.dealer-presentation.dev/~prefix~/markets/edit/2">IT Market in Bangladesh)</a>', '2014-06-15 03:41:51', '2014-06-15 03:41:51'),
  41. (3, 1, NULL, 'New Market Created', 'new market has been created byAdmin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And market name is (<a href="http://app.dealer-presentation.dev/~prefix~/markets/edit/3">Electronics Market in Bangladesh)</a>', '2014-06-15 03:43:29', '2014-06-15 03:43:29'),
  42. (4, 1, NULL, 'New Market Created', 'new market has been created byAdmin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And market name is (<a href="http://app.dealer-presentation.dev/~prefix~/markets/edit/4">Plastic Industry in Bangladesh)</a>', '2014-06-15 03:45:20', '2014-06-15 03:45:20'),
  43. (5, 2, 1, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/1">Access Code: 2PD1506142941</a>)', '2014-06-15 03:59:31', '2014-06-15 03:59:31'),
  44. (6, 2, 1, 'Edit Access Request Code', 'Access request code has been edited by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Edited access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/1">Access Code: 2PD1506142941</a>)', '2014-06-15 03:59:56', '2014-06-15 03:59:56'),
  45. (7, 2, 1, 'Edit Access Request Code', 'Access request code has been edited by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Edited access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/1">Access Code: 2PD1506142941</a>)', '2014-06-15 04:02:47', '2014-06-15 04:02:47'),
  46. (8, 2, 1, 'Edit Access Request Code', 'Access request code has been edited by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Edited access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/1">Access Code: 2PD1506142941</a>)', '2014-06-15 04:02:59', '2014-06-15 04:02:59'),
  47. (9, 2, 2, 'Edit Access Request Code', 'Access request code has been edited by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Edited access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/2">Access Code: </a>)', '2014-06-15 04:04:37', '2014-06-15 04:04:37'),
  48. (10, 2, 5, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD1506141551</a>)', '2014-06-15 04:07:22', '2014-06-15 04:07:22'),
  49. (11, 2, 4, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Access Code: 2PD1506141434</a>)', '2014-06-15 04:07:58', '2014-06-15 04:07:58'),
  50. (12, 2, 3, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/3">Access Code: 2PD1506141491</a>)', '2014-06-15 04:08:20', '2014-06-15 04:08:20'),
  51. (13, 2, 2, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/2">Access Code: 2PD1506144635</a>)', '2014-06-15 04:12:17', '2014-06-15 04:12:17'),
  52. (14, 3, 6, 'Create Access Request Code', 'Access request code has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/3">Prospect ID: 3</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/6">Access Code: 3PD1506142721</a>)', '2014-06-15 04:21:35', '2014-06-15 04:21:35'),
  53. (15, 3, 7, 'Create Access Request Code', 'Access request code has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/3">Prospect ID: 3</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/7">Access Code: 3PD1506141490</a>)', '2014-06-15 04:22:53', '2014-06-15 04:22:53'),
  54. (16, 3, 8, 'Create Access Request Code', 'Access request code has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/3">Prospect ID: 3</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/8">Access Code: 3PD1506142668</a>)', '2014-06-15 04:25:29', '2014-06-15 04:25:29'),
  55. (17, 3, 7, 'Edit Access Request Code', 'Access request code has been edited by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/3">Prospect ID: 3</a>). Edited access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/7">Access Code: 3PD1506141490</a>)', '2014-06-15 04:26:25', '2014-06-15 04:26:25'),
  56. (18, 4, 9, 'Create Access Request Code', 'Access request code has been created by Agent3 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/4">Prospect ID: 4</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/9">Access Code: 4PD1506141909</a>)', '2014-06-15 04:27:50', '2014-06-15 04:27:50'),
  57. (19, 4, 10, 'Create Access Request Code', 'Access request code has been created by Agent3 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/4">Prospect ID: 4</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/10">Access Code: 4PD1506141015</a>)', '2014-06-15 04:29:38', '2014-06-15 04:29:38'),
  58. (20, 4, 11, 'Create Access Request Code', 'Access request code has been created by Agent3 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/4">Prospect ID: 4</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/11">Access Code: 4PD1506144125</a>)', '2014-06-15 04:31:23', '2014-06-15 04:31:23'),
  59. (21, 4, 12, 'Create Access Request Code', 'Access request code has been created by Agent3 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/4">Prospect ID: 4</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/12">Access Code: 4PD1506142715</a>)', '2014-06-15 04:32:55', '2014-06-15 04:32:55'),
  60. (22, 4, 13, 'Create Access Request Code', 'Access request code has been created by Agent3 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/4">Prospect ID: 4</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/13">Access Code: 4PD1506141939</a>)', '2014-06-15 04:33:55', '2014-06-15 04:33:55'),
  61. (23, 5, 14, 'Create Access Request Code', 'Access request code has been created by Agent4 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/5">Prospect ID: 5</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/14">Access Code: 5PD1506141580</a>)', '2014-06-15 04:36:04', '2014-06-15 04:36:04'),
  62. (24, 5, 15, 'Create Access Request Code', 'Access request code has been created by Agent4 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/5">Prospect ID: 5</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/15">Access Code: 5PD1506141510</a>)', '2014-06-15 04:37:16', '2014-06-15 04:37:16'),
  63. (25, 6, 16, 'Create Access Request Code', 'Access request code has been created by Agent5 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/6">Prospect ID: 6</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/16">Access Code: 6PD1506142709</a>)', '2014-06-15 04:39:11', '2014-06-15 04:39:11'),
  64. (26, 7, 17, 'Create Access Request Code', 'Access request code has been created by Agent6 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/7">Prospect ID: 7</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/17">Access Code: 7PD1506142877</a>)', '2014-06-15 04:41:20', '2014-06-15 04:41:20'),
  65. (27, 7, 18, 'Create Access Request Code', 'Access request code has been created by Agent6 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/7">Prospect ID: 7</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/18">Access Code: 7PD1506141687</a>)', '2014-06-15 04:42:24', '2014-06-15 04:42:24'),
  66. (28, 7, 19, 'Create Access Request Code', 'Access request code has been created by Agent6 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/7">Prospect ID: 7</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/19">Access Code: 7PD1506142453</a>)', '2014-06-15 04:43:29', '2014-06-15 04:43:29'),
  67. (29, 8, 20, 'Create Access Request Code', 'Access request code has been created by Agent7 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/8">Prospect ID: 8</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/20">Access Code: 8PD1506141499</a>)', '2014-06-15 05:25:43', '2014-06-15 05:25:43'),
  68. (30, 8, 21, 'Create Access Request Code', 'Access request code has been created by Agent7 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/8">Prospect ID: 8</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/21">Access Code: 8PD1506142865</a>)', '2014-06-15 05:26:46', '2014-06-15 05:26:46'),
  69. (31, 8, 22, 'Create Access Request Code', 'Access request code has been created by Agent7 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/8">Prospect ID: 8</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/22">Access Code: 8PD1506142287</a>)', '2014-06-15 05:27:40', '2014-06-15 05:27:40'),
  70. (32, 9, 23, 'Create Access Request Code', 'Access request code has been created by Agent8 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/9">Prospect ID: 9</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/23">Access Code: 9PD1506142658</a>)', '2014-06-15 05:28:42', '2014-06-15 05:28:42'),
  71. (33, 9, 24, 'Create Access Request Code', 'Access request code has been created by Agent8 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/9">Prospect ID: 9</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/24">Access Code: 9PD1506142457</a>)', '2014-06-15 05:29:24', '2014-06-15 05:29:24'),
  72. (34, 10, 25, 'Create Access Request Code', 'Access request code has been created by Agent9 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/10">Prospect ID: 10</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/25">Access Code: 10PD1506142685</a>)', '2014-06-15 05:30:26', '2014-06-15 05:30:26'),
  73. (35, 11, 26, 'Create Access Request Code', 'Access request code has been created by Agent10 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/11">Prospect ID: 11</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/26">Access Code: 11PD1506142531</a>)', '2014-06-15 05:33:00', '2014-06-15 05:33:00'),
  74. (36, 11, 30, 'Create Access Request Code', 'Access request code has been created by Agent10 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/11">Prospect ID: 11</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/30">Access Code: 11PD1506146656</a>)', '2014-06-15 05:33:15', '2014-06-15 05:33:15'),
  75. (37, 11, 29, 'Create Access Request Code', 'Access request code has been created by Agent10 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/11">Prospect ID: 11</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/29">Access Code: 11PD1506144140</a>)', '2014-06-15 05:33:22', '2014-06-15 05:33:22'),
  76. (38, 11, 28, 'Create Access Request Code', 'Access request code has been created by Agent10 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/11">Prospect ID: 11</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/28">Access Code: 11PD1506141607</a>)', '2014-06-15 05:33:41', '2014-06-15 05:33:41'),
  77. (39, 11, 27, 'Create Access Request Code', 'Access request code has been created by Agent10 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/11">Prospect ID: 11</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/27">Access Code: 11PD1506148711</a>)', '2014-06-15 05:33:45', '2014-06-15 05:33:45'),
  78. (40, 2, 4, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Access Code: 2PD2406142057</a>)', '2014-06-24 09:40:17', '2014-06-24 09:40:17'),
  79. (41, 2, 4, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Lead ID: 4</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Access Code: 2PD2406142057</a>)', '2014-06-24 09:41:01', '2014-06-24 09:41:01'),
  80. (42, 2, 4, 'Access Request Video Watched', 'Access request video has been watch by Test Lead One<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Lead ID: 4</a> And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Access Code: 2PD2406142057</a>', '2014-06-24 09:41:14', '2014-06-24 09:41:14'),
  81. (43, 2, 4, 'Access Request Approved', 'Access request has been approved by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Access Code: 2PD2406142057</a>)', '2014-06-24 09:44:10', '2014-06-24 09:44:10'),
  82. (44, 2, 4, 'Access Request Approved', 'Access request has been approved by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Access Code: 2PD2406142057</a>)', '2014-06-24 09:44:24', '2014-06-24 09:44:24'),
  83. (45, 2, 4, 'Create Application Code', 'Application code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created application code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/4">Signup Code: 2PD2406141862-S</a>)', '2014-06-24 10:09:39', '2014-06-24 10:09:39'),
  84. (46, 2, 5, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2406141310</a>)', '2014-06-24 10:21:25', '2014-06-24 10:21:25'),
  85. (47, 2, 5, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2406141310</a>)', '2014-06-24 10:26:35', '2014-06-24 10:26:36'),
  86. (48, 2, 5, 'Access Request Video Watched', 'Access request video has been watch by Test Two Lead One<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2406141310</a>', '2014-06-24 10:26:44', '2014-06-24 10:26:44'),
  87. (49, 2, 5, 'Access Request Approved', 'Access request has been approved by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2406141310</a>)', '2014-06-24 10:27:31', '2014-06-24 10:27:31'),
  88. (50, 2, 5, 'Create Application Code', 'Application code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created application code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2406141654-S</a>)', '2014-06-24 10:27:56', '2014-06-24 10:27:56'),
  89. (51, 2, 5, 'Application Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> watching the application video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2406141654-S</a>)', '2014-06-24 10:29:57', '2014-06-24 10:29:57'),
  90. (52, 2, 5, 'Application Video Watched', 'Application video has been watch by Test Two Lead One<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> Application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2406141654-S</a>', '2014-06-24 10:30:18', '2014-06-24 10:30:18'),
  91. (53, 12, 5, 'Application Approved', 'Application has been approved by Reviwer Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000012">Reviewer ID: 00000012</a>). And the application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2406141654-S</a>', '2014-06-24 10:30:45', '2014-06-24 10:30:45'),
  92. (54, 2, 5, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2506148227</a>)', '2014-06-25 06:54:41', '2014-06-25 06:54:41'),
  93. (55, 2, 5, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2506148227</a>)', '2014-06-25 06:55:16', '2014-06-25 06:55:16'),
  94. (56, 2, 5, 'Access Request Video Watched', 'Access request video has been watch by Test Two Lead One<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2506148227</a>', '2014-06-25 06:55:21', '2014-06-25 06:55:21'),
  95. (57, 2, 5, 'Access Request Approved', 'Access request has been approved by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Access Code: 2PD2506148227</a>)', '2014-06-25 06:55:48', '2014-06-25 06:55:48'),
  96. (58, 2, 5, 'Create Application Code', 'Application code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created application code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2506141706-S</a>)', '2014-06-25 06:56:08', '2014-06-25 06:56:08'),
  97. (59, 2, 5, 'Application Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> watching the application video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2506141706-S</a>)', '2014-06-25 06:56:34', '2014-06-25 06:56:34'),
  98. (60, 2, 5, 'Application Video Watched', 'Application video has been watch by Test Two Lead One<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Lead ID: 5</a> Application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2506141706-S</a>', '2014-06-25 06:56:43', '2014-06-25 06:56:43'),
  99. (61, 12, 5, 'Application Approved', 'Application has been approved by Reviwer Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000012">Reviewer ID: 00000012</a>). And the application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/5">Signup Code: 2PD2506141706-S</a>', '2014-06-25 06:57:42', '2014-06-25 06:57:42'),
  100. (62, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/14">00000000014</a>)', '2014-07-01 06:13:17', '2014-07-01 06:13:17'),
  101. (63, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/15">00000000015</a>)', '2014-07-01 07:14:32', '2014-07-01 07:14:32'),
  102. (64, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/16">00000000016</a>)', '2014-07-01 07:21:24', '2014-07-01 07:21:24'),
  103. (65, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/17">00000000017</a>)', '2014-07-01 07:24:44', '2014-07-01 07:24:44'),
  104. (66, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/18">00000000018</a>)', '2014-07-01 07:31:15', '2014-07-01 07:31:15'),
  105. (67, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/19">00000000019</a>)', '2014-07-01 08:00:48', '2014-07-01 08:00:48'),
  106. (68, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/20">00000000020</a>)', '2014-07-01 08:02:05', '2014-07-01 08:02:05'),
  107. (69, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/21">00000000021</a>)', '2014-07-01 08:04:12', '2014-07-01 08:04:12'),
  108. (70, 2, 47, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Access Code: 2PD0207141376</a>)', '2014-07-02 02:32:56', '2014-07-02 02:32:56'),
  109. (71, 2, 47, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Lead ID: 47</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Access Code: 2PD0207141376</a>)', '2014-07-02 02:38:12', '2014-07-02 02:38:13'),
  110. (72, 2, 47, 'Access Request Video Watched', 'Access request video has been watch by Prospect Demo<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Lead ID: 47</a> And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Access Code: 2PD0207141376</a>', '2014-07-02 02:38:40', '2014-07-02 02:38:40'),
  111. (73, 2, 47, 'Access Request Approved', 'Access request has been approved by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Access Code: 2PD0207141376</a>)', '2014-07-02 02:39:10', '2014-07-02 02:39:10'),
  112. (74, 2, 47, 'Create Application Code', 'Application code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created application code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Signup Code: 2PD0207144993-S</a>)', '2014-07-02 02:39:40', '2014-07-02 02:39:40'),
  113. (75, 2, 47, 'Application Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Lead ID: 47</a> watching the application video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Signup Code: 2PD0207144993-S</a>)', '2014-07-02 02:40:23', '2014-07-02 02:40:23'),
  114. (76, 2, 47, 'Application Video Watched', 'Application video has been watch by Prospect Demo<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Lead ID: 47</a> Application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Signup Code: 2PD0207144993-S</a>', '2014-07-02 02:40:33', '2014-07-02 02:40:33'),
  115. (77, 12, 47, 'Application Approved', 'Application has been approved by Reviwer Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000012">Reviewer ID: 00000012</a>). And the application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Signup Code: 2PD0207144993-S</a>', '2014-07-02 02:41:51', '2014-07-02 02:41:51'),
  116. (78, 2, 35, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-02 03:23:03', '2014-07-02 03:23:03'),
  117. (79, 2, 59, 'Create Access Request Code', 'Access request code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Access Code: 2PD0607141552</a>)', '2014-07-06 05:14:40', '2014-07-06 05:14:40'),
  118. (80, 2, 59, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Lead ID: 59</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Access Code: 2PD0607141552</a>)', '2014-07-06 05:15:02', '2014-07-06 05:15:02'),
  119. (81, 2, 59, 'Access Request Video Watched', 'Access request video has been watch by reza azad<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Lead ID: 59</a> And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Access Code: 2PD0607141552</a>', '2014-07-06 05:15:09', '2014-07-06 05:15:09'),
  120. (82, 2, 59, 'Access Request Approved', 'Access request has been approved by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Access Code: 2PD0607141552</a>)', '2014-07-06 05:15:23', '2014-07-06 05:15:23'),
  121. (83, 2, 59, 'Create Application Code', 'Application code has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Prospect ID: 2</a>). Created application code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Signup Code: 2PD0607141676-S</a>)', '2014-07-06 05:15:34', '2014-07-06 05:15:34'),
  122. (84, 2, 59, 'Application Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Lead ID: 59</a> watching the application video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Signup Code: 2PD0607141676-S</a>)', '2014-07-06 05:15:46', '2014-07-06 05:15:47'),
  123. (85, 2, 59, 'Application Video Watched', 'Application video has been watch by reza azad<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Lead ID: 59</a> Application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Signup Code: 2PD0607141676-S</a>', '2014-07-06 05:15:54', '2014-07-06 05:15:54'),
  124. (86, 12, 59, 'Application Approved', 'Application has been approved by Reviwer Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000012">Reviewer ID: 00000012</a>). And the application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/59">Signup Code: 2PD0607141676-S</a>', '2014-07-06 05:16:40', '2014-07-06 05:16:40'),
  125. (87, 1, 60, 'Create Access Request Code', 'Access request code has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Prospect ID: 1</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>)', '2014-07-06 05:21:12', '2014-07-06 05:21:12'),
  126. (88, 1, 60, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Lead ID: 60</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>)', '2014-07-06 05:21:31', '2014-07-06 05:21:31'),
  127. (89, 1, 60, 'Access Request Video Watched', 'Access request video has been watch by mahedi azad<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Lead ID: 60</a> And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>', '2014-07-06 05:21:37', '2014-07-06 05:21:37'),
  128. (90, 1, 60, 'Edit Access Request Code', 'Access request code has been edited by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Prospect ID: 1</a>). Edited access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>)', '2014-07-06 06:36:20', '2014-07-06 06:36:20'),
  129. (91, 1, 60, 'Access Request Approved', 'Access request has been approved by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Recruiter ID: 1</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>)', '2014-07-06 06:49:27', '2014-07-06 06:49:27'),
  130. (92, 1, 60, 'Access Request Cancelled', 'Access request has been cancelled by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Recruiter ID: 1</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>)', '2014-07-06 06:52:30', '2014-07-06 06:52:30'),
  131. (93, 1, 60, 'Access Request Approved', 'Access request has been approved by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Recruiter ID: 1</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>)', '2014-07-06 06:53:55', '2014-07-06 06:53:55'),
  132. (94, 1, 60, 'Access Request Cancelled', 'Access request has been cancelled by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Recruiter ID: 1</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/60">Access Code: 1PD0607141019</a>)', '2014-07-06 06:54:05', '2014-07-06 06:54:05'),
  133. (95, 2, 35, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Lead ID: 35</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-06 06:56:00', '2014-07-06 06:56:00'),
  134. (96, 2, 35, 'Request for Access Request Video', 'Darrick Darrick (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Lead ID: 35</a>) has been request for access request video: Access request code (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-06 07:02:18', '2014-07-06 07:02:18'),
  135. (97, 2, 35, 'Approved Request for Access Request Video', 'Approved request for access request video by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Recruiter ID: 00000001</a>) Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-06 07:03:35', '2014-07-06 07:03:35'),
  136. (98, 2, 35, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Lead ID: 35</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-06 07:03:56', '2014-07-06 07:03:56'),
  137. (99, 2, 35, 'Access Request Video Watched', 'Access request video has been watch by Darrick Darrick<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Lead ID: 35</a> And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>', '2014-07-06 07:04:05', '2014-07-06 07:04:05'),
  138. (100, 2, 35, 'Access Request Approved', 'Access request has been approved by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-06 07:04:25', '2014-07-06 07:04:25'),
  139. (101, 1, 35, 'Create Application Code', 'Application code has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Prospect ID: 1</a>). Created application code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Signup Code: 1PD0607141298-S</a>)', '2014-07-06 07:04:43', '2014-07-06 07:04:43'),
  140. (102, 2, 35, 'Application Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Lead ID: 35</a> watching the application video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Signup Code: 1PD0607141298-S</a>)', '2014-07-06 07:04:56', '2014-07-06 07:04:56'),
  141. (103, 2, 35, 'Application Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Lead ID: 35</a> watching the application video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Signup Code: 1PD0607141298-S</a>)', '2014-07-06 07:04:56', '2014-07-06 07:04:57'),
  142. (104, 2, 35, 'Application Video Watched', 'Application video has been watch by Darrick Darrick<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Lead ID: 35</a> Application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Signup Code: 1PD0607141298-S</a>', '2014-07-06 07:05:03', '2014-07-06 07:05:03'),
  143. (105, 2, 35, 'Access Request Cancelled', 'Application request has been cancelled by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-06 07:05:10', '2014-07-06 07:05:10'),
  144. (106, 2, 35, 'Access Request Cancelled', 'Application request has been cancelled by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/2">Recruiter ID: 2</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/35">Access Code: 2PD0207141749</a>)', '2014-07-06 07:05:17', '2014-07-06 07:05:17'),
  145. (107, 1, 68, 'Create Access Request Code', 'Access request code has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/1">Prospect ID: 1</a>). Created access request code: (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/68">Access Code: 1PD0607142386</a>)', '2014-07-06 07:46:39', '2014-07-06 07:46:39'),
  146. (108, 1, 68, 'Access Request Video Watching', '<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/68">Lead ID: 68</a> watching the access request video (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/68">Access Code: 1PD0607142386</a>)', '2014-07-06 07:47:05', '2014-07-06 07:47:05'),
  147. (109, NULL, NULL, 'Try To Watch Access Request Video', 'Someone trying to watch access request video. And the access request code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/">Access Code: </a>)', '2014-07-07 05:50:45', '2014-07-07 05:50:45'),
  148. (110, 12, 47, 'Application Approved', 'Application has been approved by Reviwer Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000012">Reviewer ID: 00000012</a>). And the application code is (<a href="http://app.dealer-presentation.dev/~prefix~/leads/view/47">Signup Code: 2PD0207144993-S</a>', '2014-07-09 06:08:17', '2014-07-09 06:08:17'),
  149. (111, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/22">00000000022</a>)', '2014-07-09 06:58:17', '2014-07-09 06:58:17'),
  150. (112, 2, NULL, 'New Order Created', 'New order has been created by Agent Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000002">Agent ID: 00000002</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/23">00000000023</a>)', '2014-07-09 07:16:22', '2014-07-09 07:16:22'),
  151. (113, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/24">00000000024</a>)', '2014-07-09 07:19:15', '2014-07-09 07:19:15'),
  152. (114, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/25">00000000025</a>)', '2014-07-15 03:32:47', '2014-07-15 03:32:47'),
  153. (115, 16, NULL, 'New Order Created', 'New order has been created by Manager Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000016">Manager ID: 00000016</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/26">00000000026</a>)', '2014-07-15 04:34:58', '2014-07-15 04:34:58'),
  154. (116, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/27">00000000027</a>)', '2014-07-16 06:22:50', '2014-07-16 06:22:50'),
  155. (117, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/28">00000000028</a>)', '2014-07-16 06:26:00', '2014-07-16 06:26:00'),
  156. (118, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/29">00000000029</a>)', '2014-07-16 06:32:58', '2014-07-16 06:32:58'),
  157. (119, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/30">00000000030</a>)', '2014-07-16 06:46:59', '2014-07-16 06:46:59'),
  158. (120, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/31">00000000031</a>)', '2014-07-16 06:48:35', '2014-07-16 06:48:35'),
  159. (121, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/32">00000000032</a>)', '2014-07-16 07:55:28', '2014-07-16 07:55:28'),
  160. (122, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/33">00000000033</a>)', '2014-07-16 07:56:09', '2014-07-16 07:56:09'),
  161. (123, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/34">00000000034</a>)', '2014-07-16 07:56:55', '2014-07-16 07:56:55'),
  162. (124, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/35">00000000035</a>)', '2014-07-16 07:57:47', '2014-07-16 07:57:47'),
  163. (125, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/36">00000000036</a>)', '2014-07-16 07:58:24', '2014-07-16 07:58:24'),
  164. (126, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/37">00000000037</a>)', '2014-07-16 08:05:41', '2014-07-16 08:05:41'),
  165. (127, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/38">00000000038</a>)', '2014-07-16 08:06:27', '2014-07-16 08:06:27'),
  166. (128, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/39">00000000039</a>)', '2014-07-16 08:06:52', '2014-07-16 08:06:52'),
  167. (129, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/40">00000000040</a>)', '2014-07-16 08:07:31', '2014-07-16 08:07:31'),
  168. (130, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/41">00000000041</a>)', '2014-07-16 08:07:58', '2014-07-16 08:07:58'),
  169. (131, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/42">00000000042</a>)', '2014-07-16 08:09:06', '2014-07-16 08:09:06'),
  170. (132, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/43">00000000043</a>)', '2014-07-16 08:09:44', '2014-07-16 08:09:44'),
  171. (133, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/44">00000000044</a>)', '2014-07-16 08:10:14', '2014-07-16 08:10:14'),
  172. (134, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/45">00000000045</a>)', '2014-07-16 08:10:55', '2014-07-16 08:10:55'),
  173. (135, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/46">00000000046</a>)', '2014-07-16 08:13:56', '2014-07-16 08:13:56'),
  174. (136, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/47">00000000047</a>)', '2014-07-16 08:14:21', '2014-07-16 08:14:21'),
  175. (137, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/48">00000000048</a>)', '2014-07-16 08:15:06', '2014-07-16 08:15:06'),
  176. (138, 3, NULL, 'New Order Created', 'New order has been created by Agent2 Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000003">Agent ID: 00000003</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/49">00000000049</a>)', '2014-07-16 08:15:29', '2014-07-16 08:15:29'),
  177. (139, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/1">00000000001</a>)', '2014-07-20 04:01:35', '2014-07-20 04:01:35'),
  178. (140, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/2">00000000002</a>)', '2014-07-20 04:03:35', '2014-07-20 04:03:35'),
  179. (141, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/3">00000000003</a>)', '2014-07-20 04:19:15', '2014-07-20 04:19:15'),
  180. (142, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/4">00000000004</a>)', '2014-07-20 04:58:38', '2014-07-20 04:58:38'),
  181. (143, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/5">00000000005</a>)', '2014-07-20 05:53:21', '2014-07-20 05:53:21'),
  182. (144, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/1">00000000001</a>)', '2014-07-20 05:54:19', '2014-07-20 05:54:19'),
  183. (145, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/2">00000000002</a>)', '2014-07-20 06:00:19', '2014-07-20 06:00:19');
  184. INSERT INTO `activities` (`id`, `user_id`, `lead_id`, `title`, `description`, `created`, `modified`) VALUES
  185. (146, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/3">00000000003</a>)', '2014-07-20 06:14:05', '2014-07-20 06:14:05'),
  186. (147, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/4">00000000004</a>)', '2014-07-20 06:15:11', '2014-07-20 06:15:11'),
  187. (148, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/5">00000000005</a>)', '2014-07-20 06:15:44', '2014-07-20 06:15:44'),
  188. (149, 29, 332, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000005">00000000005</a>)', '2014-07-20 06:26:21', '2014-07-20 06:26:21'),
  189. (150, 29, 332, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000005">00000000005</a>)', '2014-07-20 06:26:22', '2014-07-20 06:26:22'),
  190. (151, 1, NULL, 'New Order Created', 'New order has been created by Admin Demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000001">Admin ID: 00000001</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/6">00000000006</a>)', '2014-07-20 08:30:29', '2014-07-20 08:30:29'),
  191. (152, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000006">00000000006</a>)', '2014-07-23 06:38:07', '2014-07-23 06:38:07'),
  192. (153, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000006">00000000006</a>)', '2014-07-23 06:38:09', '2014-07-23 06:38:09'),
  193. (154, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 06:55:01', '2014-07-23 06:55:01'),
  194. (155, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 06:57:49', '2014-07-23 06:57:49'),
  195. (156, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 06:58:10', '2014-07-23 06:58:10'),
  196. (157, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:02:05', '2014-07-23 07:02:05'),
  197. (158, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:02:48', '2014-07-23 07:02:48'),
  198. (159, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:05:53', '2014-07-23 07:05:53'),
  199. (160, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:06:06', '2014-07-23 07:06:06'),
  200. (161, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:31:36', '2014-07-23 07:31:36'),
  201. (162, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:31:50', '2014-07-23 07:31:50'),
  202. (163, 29, 333, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000003">00000000003</a>)', '2014-07-23 07:33:07', '2014-07-23 07:33:07'),
  203. (164, 29, 334, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000004">00000000004</a>)', '2014-07-23 07:34:36', '2014-07-23 07:34:36'),
  204. (165, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:47:33', '2014-07-23 07:47:33'),
  205. (166, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:47:37', '2014-07-23 07:47:37'),
  206. (167, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:50:28', '2014-07-23 07:50:28'),
  207. (168, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:50:29', '2014-07-23 07:50:29'),
  208. (169, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:52:48', '2014-07-23 07:52:48'),
  209. (170, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:52:50', '2014-07-23 07:52:50'),
  210. (171, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:53:11', '2014-07-23 07:53:11'),
  211. (172, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:53:13', '2014-07-23 07:53:13'),
  212. (173, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:53:33', '2014-07-23 07:53:33'),
  213. (174, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:54:32', '2014-07-23 07:54:32'),
  214. (175, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:55:25', '2014-07-23 07:55:25'),
  215. (176, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:55:26', '2014-07-23 07:55:26'),
  216. (177, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:55:57', '2014-07-23 07:55:57'),
  217. (178, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:56:20', '2014-07-23 07:56:20'),
  218. (179, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 07:56:21', '2014-07-23 07:56:21'),
  219. (180, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 08:03:27', '2014-07-23 08:03:27'),
  220. (181, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 08:03:29', '2014-07-23 08:03:29'),
  221. (182, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 08:04:36', '2014-07-23 08:04:36'),
  222. (183, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 08:06:47', '2014-07-23 08:06:47'),
  223. (184, 29, 331, 'Payment has been Received', 'Payment has been received by billing demo (<a href="http://app.dealer-presentation.dev/~prefix~/users/view/00000029">Billing ID: 00000029</a>). And order id is (<a href="http://app.dealer-presentation.dev/~prefix~/orders/view/00000000001">00000000001</a>)', '2014-07-23 08:07:27', '2014-07-23 08:07:27');
  224.  
  225. -- --------------------------------------------------------
  226.  
  227. --
  228. -- Table structure for table `dealers`
  229. --
  230.  
  231. CREATE TABLE IF NOT EXISTS `dealers` (
  232. `id` int(11) NOT NULL AUTO_INCREMENT,
  233. `dealer_id` int(11) NOT NULL,
  234. `status` int(1) NOT NULL DEFAULT '1',
  235. `authorise_dot_net_customer_profile_id` int(11) DEFAULT NULL,
  236. `authorise_dot_net_payment_profile_id` int(11) DEFAULT NULL,
  237. `authorise_dot_net_shipping_id` int(11) DEFAULT NULL,
  238. `created` datetime NOT NULL,
  239. `modified` datetime NOT NULL,
  240. `ship_to_name` varchar(20) NOT NULL,
  241. `phone_number` varchar(20) NOT NULL,
  242. `crm_id` int(11) NOT NULL,
  243. `name` varchar(20) NOT NULL,
  244. `date_entered` datetime NOT NULL,
  245. `date_modified` datetime NOT NULL,
  246. `modified_user_id` int(11) NOT NULL,
  247. `created_by` int(11) NOT NULL,
  248. `description` varchar(100) NOT NULL,
  249. `title` varchar(20) NOT NULL,
  250. `next_delivery_date` datetime NOT NULL,
  251. `payment_type` varchar(15) NOT NULL,
  252. `sub_total` varchar(20) NOT NULL,
  253. `total_price` varchar(15) NOT NULL,
  254. `discount` varchar(10) NOT NULL,
  255. `tax` varchar(10) NOT NULL,
  256. `grand_total` varchar(15) NOT NULL,
  257. `address_street` varchar(30) NOT NULL,
  258. `address_city` varchar(15) NOT NULL,
  259. `address_state` varchar(15) NOT NULL,
  260. `address_postalcode` varchar(10) NOT NULL,
  261. `address_country` varchar(10) NOT NULL,
  262. `shipping_address1` varchar(30) NOT NULL,
  263. `shipping_address2` varchar(30) NOT NULL,
  264. `billing_address_street` varchar(20) NOT NULL,
  265. `billing_address_city` varchar(15) NOT NULL,
  266. `billing_address_state` varchar(15) NOT NULL,
  267. `billing_address_postalcode` varchar(10) NOT NULL,
  268. `billing_address_country` varchar(10) NOT NULL,
  269. `account_id_c` int(11) NOT NULL,
  270. `resupply_schedule` varchar(20) NOT NULL,
  271. `rt_locations_id_c` int(11) NOT NULL,
  272. `subscription_start_date` datetime NOT NULL,
  273. `subscription_end_date` datetime NOT NULL,
  274. `occurrence` varchar(10) NOT NULL,
  275. `total_product_count` varchar(11) NOT NULL,
  276. `total_product_subtotal` varchar(10) NOT NULL,
  277. `total_discount` varchar(10) NOT NULL,
  278. `total_row_subtotal` varchar(10) NOT NULL,
  279. `shipping_address_street` varchar(20) NOT NULL,
  280. `shipping_address_city` varchar(10) NOT NULL,
  281. `shipping_address_state` varchar(10) NOT NULL,
  282. `shipping_address_postalcode` int(10) NOT NULL,
  283. `shipping_address_country` varchar(10) NOT NULL,
  284. `order_number` int(10) NOT NULL,
  285. `cash_money_order` varchar(10) NOT NULL,
  286. `credit_card` varchar(20) NOT NULL,
  287. `name_on_card` varchar(10) NOT NULL,
  288. `card_type` varchar(10) NOT NULL,
  289. `card_number` int(20) NOT NULL,
  290. `expiration_month` varchar(5) NOT NULL,
  291. `expiration_year` varchar(5) NOT NULL,
  292. `varification_number` varchar(5) NOT NULL,
  293. `payment_done` int(2) NOT NULL,
  294. `order_status` int(2) NOT NULL,
  295. `tracking_number` varchar(10) NOT NULL,
  296. `shipping_option` varchar(10) NOT NULL,
  297. `payment_option` varchar(10) NOT NULL,
  298. `shipping_fee` varchar(5) NOT NULL,
  299. `sales_tax` varchar(5) NOT NULL,
  300. `delivery_date` datetime NOT NULL,
  301. `phone_number2` varchar(10) NOT NULL,
  302. PRIMARY KEY (`id`)
  303. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
  304.  
  305. --
  306. -- Dumping data for table `dealers`
  307. --
  308.  
  309. INSERT INTO `dealers` (`id`, `dealer_id`, `status`, `authorise_dot_net_customer_profile_id`, `authorise_dot_net_payment_profile_id`, `authorise_dot_net_shipping_id`, `created`, `modified`, `ship_to_name`, `phone_number`, `crm_id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `title`, `next_delivery_date`, `payment_type`, `sub_total`, `total_price`, `discount`, `tax`, `grand_total`, `address_street`, `address_city`, `address_state`, `address_postalcode`, `address_country`, `shipping_address1`, `shipping_address2`, `billing_address_street`, `billing_address_city`, `billing_address_state`, `billing_address_postalcode`, `billing_address_country`, `account_id_c`, `resupply_schedule`, `rt_locations_id_c`, `subscription_start_date`, `subscription_end_date`, `occurrence`, `total_product_count`, `total_product_subtotal`, `total_discount`, `total_row_subtotal`, `shipping_address_street`, `shipping_address_city`, `shipping_address_state`, `shipping_address_postalcode`, `shipping_address_country`, `order_number`, `cash_money_order`, `credit_card`, `name_on_card`, `card_type`, `card_number`, `expiration_month`, `expiration_year`, `varification_number`, `payment_done`, `order_status`, `tracking_number`, `shipping_option`, `payment_option`, `shipping_fee`, `sales_tax`, `delivery_date`, `phone_number2`) VALUES
  310. (1, 331, 1, 27996285, 25463855, 26120203, '2014-07-20 06:00:19', '2014-07-20 06:00:19', '', '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', 0, '', 0, '', '', '', '', 0, '', '', '', 0, 0, '', '', '', '', '', '0000-00-00 00:00:00', ''),
  311. (2, 333, 1, 28024519, 25490784, 26150710, '2014-07-20 06:14:05', '2014-07-23 07:32:50', '', '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', 0, '', 0, '', '', '', '', 0, '', '', '', 0, 0, '', '', '', '', '', '0000-00-00 00:00:00', ''),
  312. (3, 334, 1, 28024526, 25490789, 26150714, '2014-07-20 06:15:11', '2014-07-23 07:34:19', '', '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', 0, '', 0, '', '', '', '', 0, '', '', '', 0, 0, '', '', '', '', '', '0000-00-00 00:00:00', '');
  313.  
  314. -- --------------------------------------------------------
  315.  
  316. --
  317. -- Table structure for table `forms`
  318. --
  319.  
  320. CREATE TABLE IF NOT EXISTS `forms` (
  321. `id` int(8) NOT NULL AUTO_INCREMENT,
  322. `name` varchar(50) NOT NULL,
  323. `content` text NOT NULL,
  324. `created_by` int(8) NOT NULL,
  325. `status` int(1) NOT NULL DEFAULT '1',
  326. `modified` datetime NOT NULL,
  327. `created` datetime NOT NULL,
  328. PRIMARY KEY (`id`)
  329. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
  330.  
  331. --
  332. -- Dumping data for table `forms`
  333. --
  334.  
  335. INSERT INTO `forms` (`id`, `name`, `content`, `created_by`, `status`, `modified`, `created`) VALUES
  336. (1, 'Personal Details', '<form class="form-horizontal">\r\n<fieldset>\r\n\r\n<!-- Form Name -->\r\n<legend>Personal Details</legend>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="Your name">Name</label>\r\n <div class="controls">\r\n <input id="Your name" name="Your name" type="text" placeholder="Your Name" class="input-xlarge">\r\n <p class="help-block">write down your name</p>\r\n </div>\r\n</div>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="Address">Address</label>\r\n <div class="controls">\r\n <input id="Address" name="Address" type="text" placeholder="Your Address" class="input-xlarge">\r\n <p class="help-block">write down your address</p>\r\n </div>\r\n</div>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="phone">Phone</label>\r\n <div class="controls">\r\n <input id="phone" name="phone" type="text" placeholder="Phone Number" class="input-xlarge">\r\n <p class="help-block">write down your phone number</p>\r\n </div>\r\n</div>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="Email">Email</label>\r\n <div class="controls">\r\n <input id="Email" name="Email" type="text" placeholder="Your Email" class="input-xlarge">\r\n <p class="help-block">write down your email</p>\r\n </div>\r\n</div>\r\n\r\n</fieldset>\r\n</form>\r\n', 1, 1, '2014-06-15 03:31:39', '2014-06-15 03:31:39'),
  337. (2, 'Education Background', '<form class="form-horizontal">\r\n<fieldset>\r\n\r\n<!-- Form Name -->\r\n<legend>Education Background</legend>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="University">University Name</label>\r\n <div class="controls">\r\n <input id="University" name="University" type="text" placeholder="University Name" class="input-xlarge">\r\n <p class="help-block">write down your university name</p>\r\n </div>\r\n</div>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="Dept">Deptartment</label>\r\n <div class="controls">\r\n <input id="Dept" name="Dept" type="text" placeholder="Your Department" class="input-xlarge">\r\n <p class="help-block">write down your department</p>\r\n </div>\r\n</div>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="Lavel">Label</label>\r\n <div class="controls">\r\n <input id="Lavel" name="Lavel" type="text" placeholder="semester number " class="input-xlarge">\r\n <p class="help-block">write down your label</p>\r\n </div>\r\n</div>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="result">CGPA</label>\r\n <div class="controls">\r\n <input id="result" name="result" type="text" placeholder="Your CGPA" class="input-xlarge">\r\n <p class="help-block">write down your cgpa</p>\r\n </div>\r\n</div>\r\n\r\n</fieldset>\r\n</form>\r\n', 1, 1, '2014-06-15 03:34:27', '2014-06-15 03:34:27'),
  338. (3, 'Additional Information', '<form class="form-horizontal">\r\n<fieldset>\r\n\r\n<!-- Form Name -->\r\n<legend>Additional Information</legend>\r\n\r\n<!-- Text input-->\r\n<div class="control-group">\r\n <label class="control-label" for="age">Age</label>\r\n <div class="controls">\r\n <input id="age" name="age" type="text" placeholder="Your Age" class="input-xlarge">\r\n <p class="help-block">write down your age</p>\r\n </div>\r\n</div>\r\n\r\n<!-- Textarea -->\r\n<div class="control-group">\r\n <label class="control-label" for="Bio">Bio</label>\r\n <div class="controls"> \r\n <textarea id="Bio" name="Bio">Your bio</textarea>\r\n </div>\r\n</div>\r\n\r\n</fieldset>\r\n</form>\r\n', 1, 1, '2014-06-15 03:36:19', '2014-06-15 03:36:19');
  339.  
  340. -- --------------------------------------------------------
  341.  
  342. --
  343. -- Table structure for table `industries`
  344. --
  345.  
  346. CREATE TABLE IF NOT EXISTS `industries` (
  347. `id` int(8) NOT NULL AUTO_INCREMENT,
  348. `name` varchar(80) NOT NULL,
  349. `status` int(1) NOT NULL DEFAULT '1' COMMENT '<status 1= active> = <status 0 = inactive>',
  350. `created` datetime NOT NULL,
  351. `modified` datetime NOT NULL,
  352. PRIMARY KEY (`id`)
  353. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
  354.  
  355. --
  356. -- Dumping data for table `industries`
  357. --
  358.  
  359. INSERT INTO `industries` (`id`, `name`, `status`, `created`, `modified`) VALUES
  360. (1, ' Airlines of Bangladesh', 1, '2014-06-15 03:24:55', '2014-06-15 03:24:55'),
  361. (2, ' Banks of Bangladesh', 1, '2014-06-15 03:25:02', '2014-06-15 03:25:02'),
  362. (3, ' Real estate in Bangladesh‎', 1, '2014-06-15 03:25:11', '2014-06-15 03:25:11'),
  363. (4, ' Pharmaceutical companies of Bangladesh', 1, '2014-06-15 03:25:23', '2014-06-15 03:25:23'),
  364. (5, 'IT of Bangladesh', 1, '2014-06-15 03:25:52', '2014-06-15 03:25:52');
  365.  
  366. -- --------------------------------------------------------
  367.  
  368. --
  369. -- Table structure for table `infos`
  370. --
  371.  
  372. CREATE TABLE IF NOT EXISTS `infos` (
  373. `id` int(8) NOT NULL AUTO_INCREMENT,
  374. `lead_id` int(8) NOT NULL,
  375. `field` text NOT NULL,
  376. `value` text NOT NULL,
  377. `created` datetime NOT NULL,
  378. PRIMARY KEY (`id`)
  379. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
  380.  
  381. --
  382. -- Dumping data for table `infos`
  383. --
  384.  
  385. INSERT INTO `infos` (`id`, `lead_id`, `field`, `value`, `created`) VALUES
  386. (1, 5, 'Your_name', 'demo', '2014-06-24 10:30:17'),
  387. (2, 5, 'Address', 'demo', '2014-06-24 10:30:17'),
  388. (3, 5, 'phone', '(456) 789-1245', '2014-06-24 10:30:18'),
  389. (4, 5, 'Email', 'dealer1@example.com', '2014-06-24 10:30:18'),
  390. (5, 5, 'Your_name', 'dealer demo', '2014-06-25 06:56:43'),
  391. (6, 5, 'Address', '21st new', '2014-06-25 06:56:43'),
  392. (7, 5, 'phone', '(456) 789-1245', '2014-06-25 06:56:43'),
  393. (8, 5, 'Email', 'dealer1@example.com', '2014-06-25 06:56:43'),
  394. (9, 47, 'Your_name', 'dealer demo', '2014-07-02 02:40:33'),
  395. (10, 47, 'Address', '21st new', '2014-07-02 02:40:33'),
  396. (11, 47, 'phone', '(456) 789-1245', '2014-07-02 02:40:33'),
  397. (12, 47, 'Email', 'dealer1@example.com', '2014-07-02 02:40:33'),
  398. (13, 59, 'Your_name', 'dealer demo', '2014-07-06 05:15:54'),
  399. (14, 59, 'Address', '21st new', '2014-07-06 05:15:54'),
  400. (15, 59, 'phone', '(456) 789-1245', '2014-07-06 05:15:54'),
  401. (16, 59, 'Email', 'dealer1@example.com', '2014-07-06 05:15:54'),
  402. (17, 35, 'Your_name', 'dealer demo', '2014-07-06 07:05:03'),
  403. (18, 35, 'Address', '21st new', '2014-07-06 07:05:03'),
  404. (19, 35, 'phone', '(456) 789-1245', '2014-07-06 07:05:03'),
  405. (20, 35, 'Email', 'dealer1@example.com', '2014-07-06 07:05:03');
  406.  
  407. -- --------------------------------------------------------
  408.  
  409. --
  410. -- Table structure for table `leads`
  411. --
  412.  
  413. CREATE TABLE IF NOT EXISTS `leads` (
  414. `id` int(8) unsigned NOT NULL,
  415. `market_id` int(8) DEFAULT NULL,
  416. `industry_id` int(8) DEFAULT NULL,
  417. `manager_id` int(8) DEFAULT NULL,
  418. `is_agent_allow_to_create_order` int(1) NOT NULL DEFAULT '0',
  419. `pam_id` int(11) DEFAULT NULL,
  420. `who_will_create_order` int(11) DEFAULT NULL,
  421. `first_name` varchar(25) DEFAULT NULL,
  422. `last_name` varchar(25) DEFAULT NULL,
  423. `company_name` varchar(100) DEFAULT NULL,
  424. `position_in_company` varchar(50) DEFAULT NULL,
  425. `address` varchar(100) DEFAULT NULL,
  426. `city` varchar(25) DEFAULT NULL,
  427. `state` varchar(25) DEFAULT NULL,
  428. `county` varchar(25) NOT NULL,
  429. `country` varchar(25) DEFAULT NULL,
  430. `zip_code` varchar(10) DEFAULT NULL,
  431. `company_website` varchar(100) DEFAULT NULL,
  432. `bbb_rating` varchar(5) DEFAULT NULL,
  433. `contact_by` varchar(6) DEFAULT NULL,
  434. `email` varchar(200) DEFAULT NULL,
  435. `phone` varchar(16) DEFAULT NULL,
  436. `authorise_dot_net_customer_profile_id` int(11) DEFAULT NULL,
  437. `authorise_dot_net_payment_profile_id` int(11) DEFAULT NULL,
  438. `authorise_dot_net_shipping_id` int(11) DEFAULT NULL,
  439. `card_type` varchar(50) NOT NULL,
  440. `contact_time` varchar(22) DEFAULT NULL,
  441. `note` text,
  442. `created_by` int(8) DEFAULT NULL,
  443. `reviewed_by` int(8) unsigned zerofill DEFAULT NULL,
  444. `access_value` varchar(20) NOT NULL,
  445. `access_value_created` varchar(20) NOT NULL,
  446. `access_value_for_signup` varchar(21) DEFAULT NULL,
  447. `signup_value_created` varchar(20) NOT NULL,
  448. `access_expiry` varchar(20) DEFAULT NULL,
  449. `is_access_expired` int(1) NOT NULL DEFAULT '1',
  450. `signup_expiry` varchar(20) DEFAULT NULL,
  451. `is_signup_expired` int(1) NOT NULL DEFAULT '1',
  452. `visibility` int(1) NOT NULL DEFAULT '1',
  453. `access_validity` int(1) NOT NULL DEFAULT '1',
  454. `signup_validity` int(1) NOT NULL DEFAULT '1',
  455. `prefer_contact_time` varchar(20) DEFAULT NULL,
  456. `is_video1_watch` int(1) NOT NULL DEFAULT '0',
  457. `is_video2_watch` int(1) NOT NULL DEFAULT '0',
  458. `is_request_for_video1` int(1) NOT NULL DEFAULT '0',
  459. `progress_time_video1` varchar(30) NOT NULL,
  460. `progress_type_video1` varchar(10) NOT NULL,
  461. `progress_track_time_video1` datetime NOT NULL,
  462. `progress_time_video2` varchar(30) NOT NULL,
  463. `progress_type_video2` varchar(30) NOT NULL,
  464. `progress_track_time_video2` datetime NOT NULL,
  465. `video1_current_status` int(11) DEFAULT '0',
  466. `video2_current_status` int(1) NOT NULL DEFAULT '0',
  467. `video2_current_status_time` int(30) NOT NULL,
  468. `video2_extra` text NOT NULL,
  469. `video1_current_status_time` int(30) NOT NULL,
  470. `video1_extra` text NOT NULL,
  471. `is_request_for_video2` int(1) NOT NULL DEFAULT '0',
  472. `is_complete_step1` int(1) NOT NULL DEFAULT '0',
  473. `step1_complete_date` varchar(20) NOT NULL,
  474. `is_complete_step2` int(1) NOT NULL DEFAULT '0',
  475. `step2_complete_date` varchar(20) NOT NULL,
  476. `reviewer_queue` varchar(20) NOT NULL,
  477. `status` int(11) DEFAULT '0',
  478. `created` datetime NOT NULL,
  479. `modified` datetime NOT NULL
  480. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  481.  
  482. --
  483. -- Dumping data for table `leads`
  484. --
  485.  
  486. INSERT INTO `leads` (`id`, `market_id`, `industry_id`, `manager_id`, `is_agent_allow_to_create_order`, `pam_id`, `who_will_create_order`, `first_name`, `last_name`, `company_name`, `position_in_company`, `address`, `city`, `state`, `county`, `country`, `zip_code`, `company_website`, `bbb_rating`, `contact_by`, `email`, `phone`, `authorise_dot_net_customer_profile_id`, `authorise_dot_net_payment_profile_id`, `authorise_dot_net_shipping_id`, `card_type`, `contact_time`, `note`, `created_by`, `reviewed_by`, `access_value`, `access_value_created`, `access_value_for_signup`, `signup_value_created`, `access_expiry`, `is_access_expired`, `signup_expiry`, `is_signup_expired`, `visibility`, `access_validity`, `signup_validity`, `prefer_contact_time`, `is_video1_watch`, `is_video2_watch`, `is_request_for_video1`, `progress_time_video1`, `progress_type_video1`, `progress_track_time_video1`, `progress_time_video2`, `progress_type_video2`, `progress_track_time_video2`, `video1_current_status`, `video2_current_status`, `video2_current_status_time`, `video2_extra`, `video1_current_status_time`, `video1_extra`, `is_request_for_video2`, `is_complete_step1`, `step1_complete_date`, `is_complete_step2`, `step2_complete_date`, `reviewer_queue`, `status`, `created`, `modified`) VALUES
  487. (5, 1, 2, 16, 0, 0, NULL, 'Test Two', 'Lead One', 'Test Company Two', 'Test Two', '', 'Tampa', 'Florida', 'United States', '', '33612', 'http://www.google.com', '', '', 'shaharia.azam@example.com', '29374233', NULL, NULL, NULL, '', '', '', 2, 00000012, '2PD2506148227', '2014-06-25 06:54:40', '2PD2506141706-S', '2014-06-25 06:56:07', '2014-06-28 06:54:40', 1, '2014-06-28 06:56:07', 1, 1, 0, 0, '', 1, 1, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 9, 9, 1, '', 1, '', 0, 1, '2014-06-25 06:55:48', 1, '2014-06-25 06:57:42', '2014-06-25 06:56:43', 6, '0000-00-00 00:00:00', '2014-06-25 06:57:42'),
  488. (47, 1, 3, 16, 0, NULL, 1, 'Prospect', 'Demo', 'New Company', '', '', '', '', '', '', '', '', '', '', '', '111 222 3333', NULL, NULL, NULL, '', '07/02/2014 1:22 PM', '', 2, 00000012, '2PD0207141376', '2014-07-02 02:32:55', '2PD0207144993-S', '2014-07-02 02:39:39', '2014-07-05 02:32:55', 1, '2014-07-05 02:39:39', 1, 1, 0, 0, '', 1, 1, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 9, 9, 1, '', 1, '', 0, 1, '2014-07-02 02:39:10', 1, '2014-07-09 06:08:17', '2014-07-02 02:40:33', 6, '0000-00-00 00:00:00', '2014-07-09 06:08:17'),
  489. (35, 3, 1, 16, 0, NULL, NULL, 'Darrick', 'Darrick', 'Brothers', '', '', '', '', '', '', '', '', '', '', 'dealer1@example.com', '', NULL, NULL, NULL, '', '07/02/2014 1:22 PM', '', 2, 00000001, '2PD0207141749', '2014-07-02 03:23:02', '1PD0607141298-S', '2014-07-06 07:04:36', '2014-07-09 07:03:35', 1, '2014-07-09 07:04:36', 1, 1, 0, 0, NULL, 1, 1, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 9, 9, 1, '', 1, '', 0, 1, '2014-07-06 07:04:25', 1, '2014-07-06 07:05:17', '2014-07-06 07:05:03', 7, '2014-07-02 03:22:58', '2014-07-06 07:05:17'),
  490. (59, 1, 1, 16, 0, NULL, NULL, 'reza', 'azad', 'Preview ICT', 'Sr. officer', '21st new', 'New York', 'Alabama', '', '', '30001', 'http://www.google.com', '', '', 'dealer1@example.com', '111 222 3333', NULL, NULL, NULL, '', '', '', 2, 00000012, '2PD0607141552', '2014-07-06 05:14:39', '2PD0607141676-S', '2014-07-06 05:15:33', '2014-07-09 05:14:39', 1, '2014-07-09 05:15:33', 1, 1, 0, 0, '', 1, 1, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 9, 9, 1, '', 1, '', 0, 1, '2014-07-06 05:15:23', 1, '2014-07-06 05:16:40', '2014-07-06 05:15:54', 6, '0000-00-00 00:00:00', '2014-07-06 05:16:40'),
  491. (60, 2, 5, NULL, 0, NULL, 2, 'mahedis', 'azad', 'Preview ICT', 'Sr. officer', '21st new', 'New York', 'Alabama', '', '', '30001', 'http://www.google.com', '', '', 'manager@gmail.com', '111 222 3333', NULL, NULL, NULL, '', '', '', 1, NULL, '1PD0607141019', '2014-07-06 05:21:11', NULL, '', '2014-07-09 06:36:19', 1, NULL, 1, 1, 0, 1, NULL, 1, 0, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 9, 0, 0, '', 1, '', 0, 1, '2014-07-06 06:54:05', 0, '', '', 4, '2014-07-06 05:21:04', '2014-07-06 06:54:05'),
  492. (65, 4, 3, 16, 0, NULL, NULL, 'parbej', 'azad', 'Preview ICT', 'Sr. officer', '21st new', 'New York', 'Alabama', '', NULL, '30001', 'http://www.google.com', '', '', 'managejhgkjgr@gmail.com', '111 222 3333', NULL, NULL, NULL, '', '', '', 2, NULL, '', '', NULL, '', NULL, 1, NULL, 1, 1, 1, 1, NULL, 0, 0, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 0, 0, 0, '', 0, '', 0, 0, '', 0, '', '', 0, '2014-07-06 07:12:26', '2014-07-06 07:25:30'),
  493. (66, 1, 1, 16, 0, NULL, NULL, 'ranan', 'azad', 'Preview ICT', 'Sr. officer', '21st new', 'New York', 'Alabama', '', NULL, '30001', 'http://www.google.com', '', '', 'ranan@gmail.com', '111 222 3333', NULL, NULL, NULL, '', '', '', 2, NULL, '', '', NULL, '', NULL, 1, NULL, 1, 1, 1, 1, NULL, 0, 0, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 0, 0, 0, '', 0, '', 0, 0, '', 0, '', '', 0, '2014-07-06 07:16:59', '2014-07-06 07:22:50'),
  494. (68, 1, 2, 16, 0, NULL, 2, 'sharukh', 'khan', 'Preview ICT', 'Jr.admin officer', '21st new', 'New York', 'Alabama', '', '', '30001', 'http://www.google.com', '', '', 'agent2@gmail.com', '111 222 3333', NULL, NULL, NULL, '', '', '', 1, NULL, '1PD0607142386', '2014-07-06 07:46:38', NULL, '', '2014-07-09 07:46:38', 1, NULL, 1, 1, 1, 1, NULL, 0, 0, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 5, 0, 0, '', 3, '', 0, 0, '', 0, '', '', 1, '2014-07-06 07:31:21', '2014-07-06 08:08:39'),
  495. (0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', '', NULL, '', NULL, 0, NULL, 1, 1, 1, 1, NULL, 0, 0, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 0, 0, 0, '', 0, '', 0, 0, '', 0, '', '', 0, '2014-07-07 05:50:45', '2014-07-07 05:50:45'),
  496. (89, 1, 2, 16, 0, NULL, NULL, 'test one', 'demo', 'demo company', '', '', '', '', '', NULL, '', '', '', '', '', '', NULL, NULL, NULL, '', '', '', 3, NULL, '', '', NULL, '', NULL, 1, NULL, 1, 1, 1, 1, NULL, 0, 0, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 0, 0, 0, '', 0, '', 0, 0, '', 0, '', '', 1, '2014-07-08 07:03:54', '2014-07-08 07:03:54'),
  497. (90, 3, 2, 16, 0, NULL, NULL, 'test three', 'demo', 'demo company', '', '', '', '', '', NULL, '', '', '', '', '', '', NULL, NULL, NULL, '', '', '', 3, NULL, '', '', NULL, '', NULL, 1, NULL, 1, 1, 1, 1, NULL, 0, 0, 0, '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', 0, 0, 0, '', 0, '', 0, 0, '', 0, '', '', 1, '2014-07-08 07:21:29', '2014-07-08 07:21:29');
  498.  
  499. -- --------------------------------------------------------
  500.  
  501. --
  502. -- Table structure for table `markets`
  503. --
  504.  
  505. CREATE TABLE IF NOT EXISTS `markets` (
  506. `id` int(8) NOT NULL AUTO_INCREMENT,
  507. `form_id` int(8) DEFAULT NULL,
  508. `title` varchar(255) NOT NULL,
  509. `name` varchar(255) NOT NULL,
  510. `state` varchar(20) NOT NULL,
  511. `city` varchar(20) NOT NULL,
  512. `zip` varchar(20) NOT NULL,
  513. `step1_video_link` varchar(100) NOT NULL,
  514. `step2_video_link` varchar(100) NOT NULL,
  515. `status` int(1) NOT NULL DEFAULT '1',
  516. `modified` datetime NOT NULL,
  517. `created` datetime NOT NULL,
  518. PRIMARY KEY (`id`)
  519. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
  520.  
  521. --
  522. -- Dumping data for table `markets`
  523. --
  524.  
  525. INSERT INTO `markets` (`id`, `form_id`, `title`, `name`, `state`, `city`, `zip`, `step1_video_link`, `step2_video_link`, `status`, `modified`, `created`) VALUES
  526. (1, 1, 'Stock Exchange Bangladesh', 'Stock Exchange Bangladesh', 'Kentucky', 'Dhaka', '12050', 'https://www.youtube.com/watch?v=HyaUtejtniw', 'https://www.youtube.com/watch?v=HyaUtejtniw', 1, '2014-06-15 03:40:14', '2014-06-15 03:40:14'),
  527. (2, 2, 'IT Market in Bangladesh', 'IT Market in Bangladesh', 'Iowa', 'Dhaka', '1205', 'https://www.youtube.com/watch?v=HyaUtejtniw', 'https://www.youtube.com/watch?v=HyaUtejtniw', 1, '2014-06-15 03:41:51', '2014-06-15 03:41:51'),
  528. (3, 1, 'Electronics Market in Bangladesh', 'Electronics Market in Bangladesh', 'Kansas', 'Dhaka', '1205', 'https://www.youtube.com/watch?v=HyaUtejtniw', 'https://www.youtube.com/watch?v=HyaUtejtniw', 1, '2014-06-15 03:43:29', '2014-06-15 03:43:29'),
  529. (4, 3, 'Plastic Industry in Bangladesh', 'Plastic Industry in Bangladesh', 'Kansas', 'Dhaka', '12050', 'https://www.youtube.com/watch?v=HyaUtejtniw', 'https://www.youtube.com/watch?v=HyaUtejtniw', 1, '2014-06-15 03:45:19', '2014-06-15 03:45:19');
  530.  
  531. -- --------------------------------------------------------
  532.  
  533. --
  534. -- Table structure for table `markets_users`
  535. --
  536.  
  537. CREATE TABLE IF NOT EXISTS `markets_users` (
  538. `id` int(8) NOT NULL AUTO_INCREMENT,
  539. `market_id` int(8) unsigned zerofill NOT NULL,
  540. `user_id` int(8) unsigned zerofill NOT NULL,
  541. `status` int(1) NOT NULL DEFAULT '1',
  542. `modfied` datetime NOT NULL,
  543. `created` datetime NOT NULL,
  544. PRIMARY KEY (`id`)
  545. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
  546.  
  547. --
  548. -- Dumping data for table `markets_users`
  549. --
  550.  
  551. INSERT INTO `markets_users` (`id`, `market_id`, `user_id`, `status`, `modfied`, `created`) VALUES
  552. (1, 00000001, 00000016, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  553. (2, 00000001, 00000017, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  554. (3, 00000002, 00000018, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  555. (4, 00000002, 00000019, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  556. (5, 00000003, 00000016, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  557. (6, 00000003, 00000017, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  558. (7, 00000003, 00000018, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  559. (8, 00000003, 00000019, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  560. (9, 00000004, 00000016, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  561.  
  562. -- --------------------------------------------------------
  563.  
  564. --
  565. -- Table structure for table `orders`
  566. --
  567.  
  568. CREATE TABLE IF NOT EXISTS `orders` (
  569. `id` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
  570. `type` int(1) NOT NULL DEFAULT '1',
  571. `lead_id` int(8) NOT NULL,
  572. `address` varchar(255) NOT NULL,
  573. `company_name` varchar(100) DEFAULT NULL,
  574. `total` decimal(8,2) NOT NULL,
  575. `tax` decimal(8,0) DEFAULT NULL,
  576. `shipping` decimal(8,0) DEFAULT NULL,
  577. `status` int(1) NOT NULL DEFAULT '1',
  578. `created_by` int(7) NOT NULL,
  579. `order_date` varchar(20) NOT NULL,
  580. `subtotal` decimal(8,0) DEFAULT NULL,
  581. `created` datetime NOT NULL,
  582. `modified` datetime NOT NULL,
  583. `sales_status` int(1) NOT NULL,
  584. `billing_status` int(1) NOT NULL,
  585. `shipping_status` int(1) NOT NULL,
  586. `credit` int(11) NOT NULL,
  587. `payment_response_code` int(1) NOT NULL,
  588. `payment_response_subcode` int(1) NOT NULL,
  589. `payment_response_reason_code` int(1) NOT NULL,
  590. `payment_response_reason_subcode` int(1) NOT NULL,
  591. `order_type` varchar(25) NOT NULL,
  592. `payment_response_reason_text` varchar(255) NOT NULL,
  593. `payment_avs_response` varchar(10) NOT NULL,
  594. `payment_authorization_code` varchar(10) DEFAULT NULL,
  595. `payment_invoice_no` varchar(255) NOT NULL,
  596. `payment_transaction_id` varchar(255) DEFAULT NULL,
  597. `payment_transaction_type` varchar(255) NOT NULL,
  598. `payment_account_number` varchar(255) NOT NULL,
  599. `payment_card_type` varchar(255) NOT NULL,
  600. `payment_response_text_full` varchar(255) NOT NULL,
  601. `payment_final_status` int(1) DEFAULT NULL,
  602. `payment_date` varchar(20) NOT NULL,
  603. `name` varchar(20) NOT NULL,
  604. `shipping_address_street1` varchar(15) NOT NULL,
  605. `shipping_address_street2` varchar(15) NOT NULL,
  606. `shipping_address_city` varchar(15) NOT NULL,
  607. `shipping_address_state` varchar(15) NOT NULL,
  608. `shipping_address_postalcode` varchar(15) NOT NULL,
  609. `shipping_address_country` varchar(10) NOT NULL,
  610. `billing_address_street1` varchar(15) NOT NULL,
  611. `billing_address_street2` varchar(15) NOT NULL,
  612. `billing_address_city` varchar(15) NOT NULL,
  613. `billing_address_state` varchar(15) NOT NULL,
  614. `billing_address_postalcode` varchar(15) NOT NULL,
  615. `billing_address_country` varchar(10) NOT NULL,
  616. `primary_email_address` varchar(100) NOT NULL,
  617. `secondary_email_address` varchar(100) NOT NULL,
  618. `phone_number` varchar(20) NOT NULL,
  619. `fax_number` varchar(20) NOT NULL,
  620. PRIMARY KEY (`id`)
  621. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
  622.  
  623. --
  624. -- Dumping data for table `orders`
  625. --
  626.  
  627. INSERT INTO `orders` (`id`, `type`, `lead_id`, `address`, `company_name`, `total`, `tax`, `shipping`, `status`, `created_by`, `order_date`, `subtotal`, `created`, `modified`, `sales_status`, `billing_status`, `shipping_status`, `credit`, `payment_response_code`, `payment_response_subcode`, `payment_response_reason_code`, `payment_response_reason_subcode`, `order_type`, `payment_response_reason_text`, `payment_avs_response`, `payment_authorization_code`, `payment_invoice_no`, `payment_transaction_id`, `payment_transaction_type`, `payment_account_number`, `payment_card_type`, `payment_response_text_full`, `payment_final_status`, `payment_date`, `name`, `shipping_address_street1`, `shipping_address_street2`, `shipping_address_city`, `shipping_address_state`, `shipping_address_postalcode`, `shipping_address_country`, `billing_address_street1`, `billing_address_street2`, `billing_address_city`, `billing_address_state`, `billing_address_postalcode`, `billing_address_country`, `primary_email_address`, `secondary_email_address`, `phone_number`, `fax_number`) VALUES
  628. (00000000001, 2, 331, '', 'test1', '57.00', NULL, NULL, 1, 1, '07/01/2014 5:13 PM', '57', '2014-07-20 05:54:19', '2014-07-20 05:54:19', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', NULL, '', NULL, '', '', '', '', NULL, '', '', '34st', '', 'New York', 'Alaska', '30001', 'USA', '21st new', '', 'New York', 'Alabama', '30001', 'USA', '', '', '', ''),
  629. (00000000002, 0, 331, '', 'test1', '5.58', NULL, NULL, 1, 1, '07/20/2014 3:59 PM', '6', '2014-07-20 06:00:19', '2014-07-20 06:00:19', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', NULL, '', NULL, '', '', '', '', NULL, '', '', '34st', '', 'New York', 'Alaska', '30001', 'USA', '21st new', '', 'New York', 'Alabama', '30001', 'USA', '', '', '', ''),
  630. (00000000003, 0, 333, '', 'test3', '5.58', NULL, NULL, 1, 1, '07/01/2014 5:13 PM', '6', '2014-07-20 06:14:05', '2014-07-23 07:32:52', 0, 0, 0, 0, 1, 0, 1, 1, '', 'This transaction has been approved.', 'Y', 'AWTALV', '', '2216768582', 'auth_capture', 'XXXX1881', 'Visa', '|1|,|1|,|1|,|This transaction has been approved.|,|AWTALV|,|Y|,|2216768582|,||,||,|5.58|,|CC|,|auth_capture|,|14061151645|,||,||,||,||,||,||,||,||,||,||,|test3@test.com|,|test3|,|test3|,|test3|,|21st new|,|New York|,|Alabama|,|30001|,|USA|,||,||,||,||,||,', 1, '', '', '21st new', '', 'New York', 'Alabama', '30001', 'USA', '21st new', '', 'New York', 'Alabama', '30001', 'USA', '', '', '', ''),
  631. (00000000004, 0, 334, '', 'test4', '57.00', NULL, NULL, 1, 1, '07/01/2014 5:13 PM', '57', '2014-07-20 06:15:11', '2014-07-23 07:34:21', 0, 0, 0, 0, 1, 0, 1, 1, '', 'This transaction has been approved.', 'Y', 'NOW1B3', '', '2216768606', 'auth_capture', 'XXXX1881', 'Visa', '|1|,|1|,|1|,|This transaction has been approved.|,|NOW1B3|,|Y|,|2216768606|,||,||,|57.00|,|CC|,|auth_capture|,|14061152535|,||,||,||,||,||,||,||,||,||,||,|test4@test.com|,|test4|,|test4|,|test4|,|21st new|,|New York|,|Alabama|,|30001|,|Bangladesh|,||,||,|', 1, '', '', '21st new', '', 'New York', 'Alabama', '30001', 'Bangladesh', '21st new', '', 'New York', 'Alabama', '30001', 'Bangladesh', '', '', '', ''),
  632. (00000000005, 2, 332, '', 'test2', '57.00', NULL, NULL, 1, 1, '07/01/2014 5:13 PM', '57', '2014-07-20 06:15:44', '2014-07-20 06:15:44', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', NULL, '', NULL, '', '', '', '', NULL, '', '', '21st new', '', 'New York', 'Alabama', '30001', 'USA', '34st', '', 'New York', 'Alaska', '30001', 'Bangladesh', '', '', '', ''),
  633. (00000000006, 2, 331, '', 'test1', '125.00', '34', '34', 1, 1, '07/20/2014 6:30 PM', '57', '2014-07-20 08:30:29', '2014-07-20 08:30:29', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', NULL, '', NULL, '', '', '', '', NULL, '', '', '34st', '', 'New York', 'Alaska', '30001', 'USA', '21st new', '', 'New York', 'Alabama', '30001', 'USA', '', '', '', '');
  634.  
  635. -- --------------------------------------------------------
  636.  
  637. --
  638. -- Table structure for table `order_items`
  639. --
  640.  
  641. CREATE TABLE IF NOT EXISTS `order_items` (
  642. `id` int(11) NOT NULL AUTO_INCREMENT,
  643. `order_id` int(11) unsigned zerofill NOT NULL,
  644. `item` int(7) unsigned zerofill DEFAULT NULL,
  645. `note` varchar(100) NOT NULL,
  646. `price` decimal(8,2) NOT NULL,
  647. `quantity` int(11) NOT NULL,
  648. `sub_total` decimal(8,2) NOT NULL,
  649. `modified` datetime NOT NULL,
  650. `created` datetime NOT NULL,
  651. PRIMARY KEY (`id`)
  652. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
  653.  
  654. --
  655. -- Dumping data for table `order_items`
  656. --
  657.  
  658. INSERT INTO `order_items` (`id`, `order_id`, `item`, `note`, `price`, `quantity`, `sub_total`, `modified`, `created`) VALUES
  659. (1, 00000000001, 0000002, 'note', '28.50', 2, '57.00', '2014-07-20 05:54:19', '2014-07-20 05:54:19'),
  660. (2, 00000000002, 0000003, '', '2.79', 2, '5.58', '2014-07-20 06:00:19', '2014-07-20 06:00:19'),
  661. (3, 00000000004, 0000002, 'note', '28.50', 2, '57.00', '2014-07-20 06:15:11', '2014-07-20 06:15:11'),
  662. (4, 00000000005, 0000002, '', '28.50', 2, '57.00', '2014-07-20 06:15:44', '2014-07-20 06:15:44'),
  663. (5, 00000000006, 0000002, 'note1', '28.50', 2, '57.00', '2014-07-20 08:30:29', '2014-07-20 08:30:29');
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!