API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 11th, 2018
221
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 87.80 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.7
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost
  6. -- Generation Time: May 11, 2018 at 05:42 AM
  7. -- Server version: 5.6.38
  8. -- PHP Version: 7.2.1
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `cottageyumz`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `admins`
  21. --
  22.  
  23. CREATE TABLE `admins` (
  24. `id` int(11) NOT NULL,
  25. `first_name` varchar(255) DEFAULT NULL,
  26. `last_name` varchar(255) DEFAULT NULL,
  27. `email` varchar(255) NOT NULL,
  28. `password` varchar(255) NOT NULL,
  29. `access_token` varchar(255) DEFAULT NULL,
  30. `deleted_at` timestamp NULL DEFAULT NULL,
  31. `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  32. `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  33. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  34.  
  35. --
  36. -- Dumping data for table `admins`
  37. --
  38.  
  39. INSERT INTO `admins` (`id`, `first_name`, `last_name`, `email`, `password`, `access_token`, `deleted_at`, `created_at`, `updated_at`) VALUES
  40. (1, 'admin', 'admin', 'admin@admin.com', 'e10adc3949ba59abbe56e057f20f883e', 'Uuun69ykSN0ImweE8YTgbWi7Nm1TQu', NULL, '2018-03-12 08:06:58', '2018-03-16 11:22:12');
  41.  
  42. -- --------------------------------------------------------
  43.  
  44. --
  45. -- Table structure for table `blocked_users`
  46. --
  47.  
  48. CREATE TABLE `blocked_users` (
  49. `id` int(11) NOT NULL,
  50. `user_id_1` int(11) NOT NULL,
  51. `user_id_2` int(11) NOT NULL,
  52. `created_at` timestamp NULL DEFAULT NULL,
  53. `updated_at` timestamp NULL DEFAULT NULL
  54. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  55.  
  56. --
  57. -- Dumping data for table `blocked_users`
  58. --
  59.  
  60. INSERT INTO `blocked_users` (`id`, `user_id_1`, `user_id_2`, `created_at`, `updated_at`) VALUES
  61. (1, 12, 13, '2018-03-09 13:40:40', '2018-03-09 13:40:40'),
  62. (4, 2, 1, '2018-03-14 07:59:31', '2018-03-14 07:59:31'),
  63. (9, 11, 8, '2018-03-15 12:12:28', '2018-03-15 12:12:28'),
  64. (18, 17, 13, '2018-03-16 13:29:23', '2018-03-16 13:29:23');
  65.  
  66. -- --------------------------------------------------------
  67.  
  68. --
  69. -- Table structure for table `categories`
  70. --
  71.  
  72. CREATE TABLE `categories` (
  73. `id` int(11) NOT NULL,
  74. `name` varchar(128) NOT NULL,
  75. `type` tinyint(4) NOT NULL COMMENT '1 - Food, 2 - Supplies, 3 - Community and Services',
  76. `image` varchar(255) NOT NULL,
  77. `icon_image` varchar(255) NOT NULL,
  78. `created_at` timestamp NULL DEFAULT NULL,
  79. `updated_at` timestamp NULL DEFAULT NULL
  80. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  81.  
  82. --
  83. -- Dumping data for table `categories`
  84. --
  85.  
  86. INSERT INTO `categories` (`id`, `name`, `type`, `image`, `icon_image`, `created_at`, `updated_at`) VALUES
  87. (1, 'Bread', 1, 'img_bread.png', 'ic_bread.png', NULL, NULL),
  88. (2, 'Candy', 1, 'img_candy.png', 'ic_candy.png', NULL, NULL),
  89. (3, 'Condiments', 1, 'img_condiments.png', 'ic_condiments.png', NULL, NULL),
  90. (4, 'Dry Goods', 1, 'img_dry_goods.png', 'ic_dry_goods.png', NULL, NULL),
  91. (5, 'Pastries', 1, 'img_pastries.png', 'ic_pastries.png', NULL, NULL),
  92. (6, 'Preserves', 1, 'img_preserves.png', 'ic_preserves.png', NULL, NULL),
  93. (7, 'Snacks', 1, 'img_snacks.png', 'ic_snacks.png', NULL, NULL),
  94. (8, 'Eggs & Fresh Produce', 1, 'img_eggs_fresh_produce.png', 'ic_eggs_fresh_produce.png', NULL, NULL),
  95. (9, 'Food Beauty Products', 1, 'img_food_beauty_products.png', 'ic_food_beauty_products.png', NULL, NULL),
  96. (10, 'Display & Storage', 2, 'img_display_storage.png', 'ic_display_storage.png', NULL, NULL),
  97. (11, 'Decorating Tools', 2, 'img_decorating_tools.png', 'ic_decorating_tools.png', NULL, NULL),
  98. (12, 'Bakeware', 2, 'img_bakeware.png', 'ic_bakeware.png', NULL, NULL),
  99. (13, 'Cookware', 2, 'img_cookware.png', 'ic_cookware.png', NULL, NULL),
  100. (14, 'Tableware', 2, 'img_tableware.png', 'ic_tableware.png', NULL, NULL),
  101. (15, 'Linens & Accessories', 2, 'img_linens_accessories.png', 'ic_linens_accessories.png', NULL, NULL),
  102. (16, 'Small Appliances', 2, 'img_small_appliances.png', 'ic_small_appliances.png', NULL, NULL),
  103. (17, 'Refrigiration ', 2, 'img_refrigiration .png', 'ic_refrigiration .png', NULL, NULL),
  104. (18, 'Commercial Equipment', 2, 'img_commercial_equipment.png', 'ic_commercial_equipment.png', NULL, NULL),
  105. (19, 'Community', 3, 'img_community.png', 'ic_community.png', NULL, NULL),
  106. (20, 'For Rent', 3, 'img_for_rent.png', 'ic_for_rent.png', NULL, NULL),
  107. (21, 'Services', 1, '1521199975lQhV8duJq4ZqZyPgcNInhxlwioOrJU.jpg', '1521199976Evxi4qDqTJaoCDbIEcpPDK0Bqrj5Ov.jpg', NULL, '2018-03-16 11:32:56');
  108.  
  109. -- --------------------------------------------------------
  110.  
  111. --
  112. -- Table structure for table `chats`
  113. --
  114.  
  115. CREATE TABLE `chats` (
  116. `id` int(11) NOT NULL,
  117. `sent_by` int(11) NOT NULL,
  118. `sent_to` int(11) NOT NULL,
  119. `post_id` int(11) NOT NULL,
  120. `chat_type` tinyint(4) NOT NULL COMMENT '1 - Buy, 2 - Sell',
  121. `message_type` tinyint(4) NOT NULL COMMENT '0 - message, 1 - image, 2 - location',
  122. `message` varchar(512) NOT NULL,
  123. `image` varchar(255) DEFAULT NULL,
  124. `file_name` varchar(255) DEFAULT NULL,
  125. `location` varchar(255) DEFAULT NULL,
  126. `lat` double DEFAULT NULL,
  127. `lng` double DEFAULT NULL,
  128. `is_read` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 - unread, 1 - read',
  129. `created_at` timestamp NULL DEFAULT NULL,
  130. `updated_at` timestamp NULL DEFAULT NULL
  131. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  132.  
  133. --
  134. -- Dumping data for table `chats`
  135. --
  136.  
  137. INSERT INTO `chats` (`id`, `sent_by`, `sent_to`, `post_id`, `chat_type`, `message_type`, `message`, `image`, `file_name`, `location`, `lat`, `lng`, `is_read`, `created_at`, `updated_at`) VALUES
  138. (1, 12, 11, 21, 0, 0, 'hi sahil', NULL, NULL, '', 0, 0, 1, '2018-03-09 06:14:37', '2018-03-15 12:11:56'),
  139. (2, 12, 11, 21, 0, 0, 'nice post', NULL, NULL, '', 0, 0, 1, '2018-03-09 06:14:42', '2018-03-15 12:11:56'),
  140. (3, 11, 12, 21, 0, 0, 'thanks bro', NULL, NULL, '', 0, 0, 1, '2018-03-09 06:15:38', '2018-03-09 11:07:19'),
  141. (4, 12, 11, 22, 0, 0, 'hiii', NULL, NULL, '', 0, 0, 1, '2018-03-09 10:58:07', '2018-03-15 12:11:56'),
  142. (5, 12, 11, 22, 0, 0, 'hello sahil kumar', NULL, NULL, '', 0, 0, 1, '2018-03-09 10:58:15', '2018-03-15 12:11:56'),
  143. (6, 11, 12, 22, 0, 0, 'hello brother', NULL, NULL, '', 0, 0, 1, '2018-03-09 10:58:45', '2018-03-09 11:07:19'),
  144. (7, 12, 11, 23, 0, 0, 'hello sir', NULL, NULL, '', 0, 0, 1, '2018-03-09 11:06:54', '2018-03-15 12:11:56'),
  145. (8, 12, 11, 23, 0, 0, 'I want to buy this for my girlfriend', NULL, NULL, '', 0, 0, 1, '2018-03-09 11:07:14', '2018-03-15 12:11:56'),
  146. (25, 11, 12, 23, 0, 0, 'hii', NULL, NULL, '', 0, 0, 0, '2018-03-09 13:19:36', '2018-03-09 13:19:36'),
  147. (26, 11, 12, 23, 0, 0, 'vvvx', NULL, NULL, '', 0, 0, 0, '2018-03-09 13:19:42', '2018-03-09 13:19:42'),
  148. (27, 11, 12, 23, 0, 0, 'vvvg', NULL, NULL, '', 0, 0, 0, '2018-03-09 13:19:50', '2018-03-09 13:19:50'),
  149. (28, 11, 12, 23, 0, 0, 'bzbzb', NULL, NULL, '', 0, 0, 0, '2018-03-09 13:19:54', '2018-03-09 13:19:54'),
  150. (59, 2, 1, 39, 0, 0, 'hi', NULL, NULL, '', 0, 0, 1, '2018-03-14 07:59:22', '2018-03-14 09:51:34'),
  151. (60, 2, 1, 39, 0, 0, 'hi', NULL, NULL, '', 0, 0, 1, '2018-03-14 09:13:30', '2018-03-14 09:51:34'),
  152. (61, 1, 2, 39, 0, 0, '?', NULL, NULL, '', 0, 0, 1, '2018-03-14 09:13:48', '2018-03-14 09:21:33'),
  153. (62, 2, 1, 39, 0, 0, '?', NULL, NULL, '', 0, 0, 1, '2018-03-14 09:13:56', '2018-03-14 09:51:34'),
  154. (63, 1, 2, 39, 0, 0, '?', NULL, NULL, '', 0, 0, 1, '2018-03-14 09:14:16', '2018-03-14 09:21:33'),
  155. (64, 1, 2, 39, 0, 0, '?', NULL, NULL, '', 0, 0, 1, '2018-03-14 09:17:33', '2018-03-14 09:21:33'),
  156. (65, 2, 1, 39, 0, 0, 'done', NULL, NULL, '', 0, 0, 1, '2018-03-14 09:18:34', '2018-03-14 09:51:34'),
  157. (66, 1, 2, 39, 0, 0, 'done', NULL, NULL, '', 0, 0, 1, '2018-03-14 09:18:44', '2018-03-14 09:21:33'),
  158. (67, 11, 2, 15, 0, 0, 'hii sir', NULL, NULL, '', 0, 0, 1, '2018-03-14 11:08:53', '2018-03-15 13:52:46'),
  159. (68, 11, 2, 15, 0, 0, 'howw are you', NULL, NULL, '', 0, 0, 1, '2018-03-14 11:09:00', '2018-03-15 13:52:46'),
  160. (69, 2, 11, 15, 0, 0, 'hii', NULL, NULL, '', 0, 0, 1, '2018-03-14 11:09:16', '2018-03-15 13:07:30'),
  161. (70, 2, 11, 15, 0, 0, 'bdbdhd', NULL, NULL, '', 0, 0, 1, '2018-03-14 11:09:52', '2018-03-15 13:07:30'),
  162. (71, 2, 11, 32, 0, 0, 'hi sir', NULL, NULL, '', 0, 0, 1, '2018-03-14 11:19:15', '2018-03-15 13:07:30'),
  163. (72, 11, 2, 32, 0, 0, 'hii ji', NULL, NULL, '', 0, 0, 1, '2018-03-14 11:19:44', '2018-03-15 13:52:46'),
  164. (73, 11, 12, 23, 0, 0, 'hzhdb', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:02:55', '2018-03-14 12:02:55'),
  165. (74, 11, 12, 23, 0, 0, 'vzjsjdj', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:02:56', '2018-03-14 12:02:56'),
  166. (75, 11, 12, 23, 0, 0, 'gshrh', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:02:57', '2018-03-14 12:02:57'),
  167. (76, 11, 12, 23, 0, 0, 'hxhshhd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:02:59', '2018-03-14 12:02:59'),
  168. (77, 11, 12, 23, 0, 0, 'vshdhdh', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:00', '2018-03-14 12:03:00'),
  169. (78, 11, 12, 23, 0, 0, 'vshhdhd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:01', '2018-03-14 12:03:01'),
  170. (79, 11, 12, 23, 0, 0, 'vshdhd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:02', '2018-03-14 12:03:02'),
  171. (80, 11, 12, 23, 0, 0, 'vdhdhhdh', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:03', '2018-03-14 12:03:03'),
  172. (81, 11, 12, 23, 0, 0, 'cshshdh', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:04', '2018-03-14 12:03:04'),
  173. (82, 11, 12, 23, 0, 0, 'vshshvd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:05', '2018-03-14 12:03:05'),
  174. (83, 11, 12, 23, 0, 0, 's bebbd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:06', '2018-03-14 12:03:06'),
  175. (84, 11, 12, 23, 0, 0, 'vshhsbd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:07', '2018-03-14 12:03:07'),
  176. (85, 11, 12, 23, 0, 0, 'vsbdbhd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:08', '2018-03-14 12:03:08'),
  177. (86, 11, 12, 23, 0, 0, 'vsjhe', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:09', '2018-03-14 12:03:09'),
  178. (87, 11, 12, 23, 0, 0, 'vwhehbe', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:11', '2018-03-14 12:03:11'),
  179. (88, 11, 12, 23, 0, 0, 'vwjdbeb', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:12', '2018-03-14 12:03:12'),
  180. (89, 11, 12, 23, 0, 0, 'vshdbbd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:13', '2018-03-14 12:03:13'),
  181. (90, 11, 12, 23, 0, 0, 'svhshe', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:14', '2018-03-14 12:03:14'),
  182. (91, 11, 12, 23, 0, 0, 'svhshdv', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:15', '2018-03-14 12:03:15'),
  183. (92, 11, 12, 23, 0, 0, 'vebvevd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:16', '2018-03-14 12:03:16'),
  184. (93, 11, 12, 23, 0, 0, 'shheheh', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:17', '2018-03-14 12:03:17'),
  185. (94, 11, 12, 23, 0, 0, 'evheheb', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:18', '2018-03-14 12:03:18'),
  186. (95, 11, 12, 23, 0, 0, 'evhehr', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:19', '2018-03-14 12:03:19'),
  187. (96, 11, 12, 23, 0, 0, 'wghehe', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:20', '2018-03-14 12:03:20'),
  188. (97, 11, 12, 23, 0, 0, 'be when', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:21', '2018-03-14 12:03:21'),
  189. (98, 11, 12, 23, 0, 0, 'e', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:22', '2018-03-14 12:03:22'),
  190. (99, 11, 12, 23, 0, 0, 'I will', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:23', '2018-03-14 12:03:23'),
  191. (100, 11, 12, 23, 0, 0, 'thanks for', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:25', '2018-03-14 12:03:25'),
  192. (101, 11, 12, 23, 0, 0, 'thanks for', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:26', '2018-03-14 12:03:26'),
  193. (102, 11, 12, 23, 0, 0, 'we are', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:28', '2018-03-14 12:03:28'),
  194. (103, 11, 12, 23, 0, 0, 'thanks for', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:30', '2018-03-14 12:03:30'),
  195. (104, 11, 12, 23, 0, 0, 'we', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:32', '2018-03-14 12:03:32'),
  196. (105, 11, 12, 23, 0, 0, 'thanks', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:33', '2018-03-14 12:03:33'),
  197. (106, 11, 12, 23, 0, 0, 'I', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:34', '2018-03-14 12:03:34'),
  198. (107, 11, 12, 23, 0, 0, 'eth', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:35', '2018-03-14 12:03:35'),
  199. (108, 11, 12, 23, 0, 0, 'ehwbidbd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:37', '2018-03-14 12:03:37'),
  200. (109, 11, 12, 23, 0, 0, 'svbe', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:03:38', '2018-03-14 12:03:38'),
  201. (110, 11, 12, 23, 0, 0, 'ncjfj', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:14:34', '2018-03-14 12:14:34'),
  202. (111, 11, 12, 23, 0, 0, 'hshhd', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:36:14', '2018-03-14 12:36:14'),
  203. (112, 11, 12, 23, 0, 0, 'hiii', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:36:19', '2018-03-14 12:36:19'),
  204. (113, 11, 12, 23, 0, 0, 'hellow', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:36:24', '2018-03-14 12:36:24'),
  205. (114, 11, 12, 23, 0, 0, 'hiii', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:54:48', '2018-03-14 12:54:48'),
  206. (115, 11, 12, 23, 0, 0, 'ggddftg', NULL, NULL, '', 0, 0, 0, '2018-03-14 12:54:58', '2018-03-14 12:54:58'),
  207. (122, 11, 8, 17, 0, 0, 'hii john', NULL, NULL, '', 0, 0, 0, '2018-03-14 13:05:31', '2018-03-14 13:05:31'),
  208. (123, 11, 8, 17, 0, 0, 'how are you', NULL, NULL, '', 0, 0, 0, '2018-03-14 13:05:37', '2018-03-14 13:05:37'),
  209. (124, 11, 8, 17, 0, 2, '', NULL, NULL, 'Sector 62, Phase - VIII, Sector 62, Sahibzada Ajit Singh Nagar, Punjab 160062, India', 30.694485599999997, 76.7308001, 0, '2018-03-14 13:05:47', '2018-03-14 13:05:47'),
  210. (125, 11, 8, 17, 0, 1, '', '1521032909DHDqmESOwLBCnsO4xaytyhYhiMlwDL.jpg', NULL, '', 0, 0, 0, '2018-03-14 13:08:30', '2018-03-14 13:08:30'),
  211. (126, 11, 2, 32, 0, 0, 'how are you?', NULL, NULL, '', 0, 0, 1, '2018-03-14 18:44:56', '2018-03-15 13:52:46'),
  212. (130, 2, 11, 44, 0, 0, 'hii bro', NULL, NULL, '', 0, 0, 1, '2018-03-15 09:58:22', '2018-03-15 13:07:30'),
  213. (131, 2, 11, 44, 0, 0, 'how are you', NULL, NULL, '', 0, 0, 1, '2018-03-15 10:00:25', '2018-03-15 13:07:30'),
  214. (132, 11, 2, 44, 0, 0, 'fine sir', NULL, NULL, '', 0, 0, 1, '2018-03-15 10:01:16', '2018-03-15 13:52:46'),
  215. (133, 2, 11, 44, 0, 0, 'hello again sahil', NULL, NULL, '', 0, 0, 1, '2018-03-15 10:41:35', '2018-03-15 13:07:30'),
  216. (134, 2, 11, 44, 0, 0, 'hii sahil', NULL, NULL, '', 0, 0, 1, '2018-03-15 12:30:38', '2018-03-15 13:07:30'),
  217. (135, 2, 11, 44, 0, 0, 'after block', NULL, NULL, '', 0, 0, 1, '2018-03-15 12:32:56', '2018-03-15 13:07:30'),
  218. (136, 2, 11, 44, 0, 0, 'hiii', NULL, NULL, '', 0, 0, 1, '2018-03-15 12:36:36', '2018-03-15 13:07:30'),
  219. (137, 11, 2, 44, 0, 0, 'hiii', NULL, NULL, '', 0, 0, 1, '2018-03-15 12:43:19', '2018-03-15 13:52:46'),
  220. (138, 2, 11, 44, 0, 0, 'hdhdhr', NULL, NULL, '', 0, 0, 1, '2018-03-15 12:46:06', '2018-03-15 13:07:30'),
  221. (139, 11, 2, 44, 0, 0, 'hello 1', NULL, NULL, '', 0, 0, 1, '2018-03-15 12:49:51', '2018-03-15 13:52:46'),
  222. (140, 2, 18, 45, 0, 1, '', '1521177160uO8NAsy28PK9HYrFsc4KwLVL8u3n49.jpg', NULL, '', 0, 0, 0, '2018-03-16 05:12:41', '2018-03-16 05:12:41'),
  223. (141, 2, 18, 45, 0, 2, '', NULL, NULL, 'Sector 62, Phase - VIII, Sector 62, Sahibzada Ajit Singh Nagar, Punjab 160062, India', 30.694485599999997, 76.7308001, 0, '2018-03-16 05:13:07', '2018-03-16 05:13:07'),
  224. (142, 2, 18, 45, 0, 0, 'cff', NULL, NULL, '', 0, 0, 0, '2018-03-16 06:15:54', '2018-03-16 06:15:54'),
  225. (143, 2, 18, 45, 0, 0, 'vshs', NULL, NULL, '', 0, 0, 0, '2018-03-16 06:16:04', '2018-03-16 06:16:04'),
  226. (144, 19, 18, 46, 0, 0, 'hii', NULL, NULL, '', 0, 0, 0, '2018-03-16 07:59:15', '2018-03-16 07:59:15'),
  227. (145, 19, 3, 10, 0, 0, 'hi', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:02:38', '2018-03-16 13:08:50'),
  228. (146, 3, 19, 10, 0, 0, 'hi', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:03:08', '2018-03-17 04:50:30'),
  229. (147, 3, 19, 10, 0, 0, 'hi', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:03:54', '2018-03-17 04:50:30'),
  230. (148, 19, 3, 10, 0, 0, 'krse', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:03:55', '2018-03-16 13:08:50'),
  231. (149, 3, 19, 10, 0, 0, 'gg', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:04:02', '2018-03-17 04:50:30'),
  232. (150, 19, 3, 10, 0, 0, 'hcugu', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:04:09', '2018-03-16 13:08:50'),
  233. (151, 19, 3, 10, 0, 0, 'gxhcuc', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:04:11', '2018-03-16 13:08:50'),
  234. (152, 3, 19, 10, 0, 0, 'uuruurururudur\n\n\njxjjddn', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:04:19', '2018-03-17 04:50:30'),
  235. (153, 3, 19, 10, 0, 1, '', '1521205482Kx2dCoSXJt4RilFKmsRJiW9TomQB1l.jpg', NULL, '', 0, 0, 1, '2018-03-16 13:04:43', '2018-03-17 04:50:30'),
  236. (154, 3, 19, 10, 0, 2, '', NULL, NULL, 'Sector 62, Phase - VIII, Sector 62, Sahibzada Ajit Singh Nagar, Punjab 160062, India', 30.694485599999997, 76.7308001, 1, '2018-03-16 13:05:01', '2018-03-17 04:50:30'),
  237. (155, 3, 19, 10, 0, 0, 'gggggggghhhjjhgh7ridiydutdutdgzttysutdut', NULL, NULL, '', 0, 0, 1, '2018-03-16 13:05:44', '2018-03-17 04:50:30'),
  238. (171, 19, 3, 10, 0, 0, '?', NULL, NULL, '', 0, 0, 0, '2018-03-17 04:49:41', '2018-03-17 04:49:41'),
  239. (172, 19, 13, 37, 0, 0, 'fhfh', NULL, NULL, '', 0, 0, 1, '2018-03-17 05:07:38', '2018-03-17 06:25:45'),
  240. (173, 19, 13, 34, 0, 0, 'hu', NULL, NULL, '', 0, 0, 1, '2018-03-17 05:22:17', '2018-03-17 06:25:45'),
  241. (174, 19, 13, 34, 0, 0, 'h', NULL, NULL, '', 0, 0, 1, '2018-03-17 05:22:35', '2018-03-17 06:25:45'),
  242. (175, 19, 13, 34, 0, 0, 'gudgjdu', NULL, NULL, '', 0, 0, 1, '2018-03-17 05:23:00', '2018-03-17 06:25:45'),
  243. (176, 13, 19, 48, 0, 0, 'hiii', NULL, NULL, '', 0, 0, 1, '2018-03-17 06:25:33', '2018-03-19 12:58:42'),
  244. (177, 19, 13, 48, 0, 0, 'hoiii', NULL, NULL, '', 0, 0, 0, '2018-03-17 06:26:10', '2018-03-17 06:26:10'),
  245. (178, 20, 13, 35, 0, 0, 'hi', NULL, NULL, '', 0, 0, 0, '2018-03-19 13:02:36', '2018-03-19 13:02:36');
  246.  
  247. -- --------------------------------------------------------
  248.  
  249. --
  250. -- Table structure for table `favorites`
  251. --
  252.  
  253. CREATE TABLE `favorites` (
  254. `id` int(11) NOT NULL,
  255. `user_id` int(11) NOT NULL,
  256. `post_id` int(11) NOT NULL,
  257. `created_at` timestamp NULL DEFAULT NULL,
  258. `updated_at` timestamp NULL DEFAULT NULL
  259. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  260.  
  261. --
  262. -- Dumping data for table `favorites`
  263. --
  264.  
  265. INSERT INTO `favorites` (`id`, `user_id`, `post_id`, `created_at`, `updated_at`) VALUES
  266. (1, 2, 2, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  267. (2, 3, 4, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  268. (3, 4, 13, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  269. (4, 10, 10, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  270. (5, 5, 5, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  271. (6, 9, 8, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  272. (8, 6, 17, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  273. (9, 4, 7, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  274. (10, 5, 13, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  275. (11, 11, 21, '2018-03-09 05:41:35', '2018-03-09 05:41:35'),
  276. (15, 12, 33, '2018-03-09 13:48:54', '2018-03-09 13:48:54'),
  277. (16, 12, 32, '2018-03-09 13:49:43', '2018-03-09 13:49:43'),
  278. (17, 12, 24, '2018-03-09 13:49:48', '2018-03-09 13:49:48'),
  279. (18, 12, 25, '2018-03-09 13:49:51', '2018-03-09 13:49:51'),
  280. (19, 12, 21, '2018-03-09 13:50:13', '2018-03-09 13:50:13'),
  281. (20, 12, 36, '2018-03-09 14:23:18', '2018-03-09 14:23:18'),
  282. (21, 13, 24, '2018-03-09 14:39:00', '2018-03-09 14:39:00'),
  283. (23, 13, 35, '2018-03-09 14:39:22', '2018-03-09 14:39:22'),
  284. (24, 13, 36, '2018-03-09 14:39:27', '2018-03-09 14:39:27'),
  285. (35, 11, 25, '2018-03-14 05:09:30', '2018-03-14 05:09:30'),
  286. (36, 1, 32, '2018-03-14 05:54:15', '2018-03-14 05:54:15'),
  287. (38, 11, 18, '2018-03-14 07:28:21', '2018-03-14 07:28:21'),
  288. (40, 11, 15, '2018-03-14 07:28:36', '2018-03-14 07:28:36'),
  289. (42, 2, 39, '2018-03-14 09:13:20', '2018-03-14 09:13:20'),
  290. (48, 1, 42, '2018-03-14 10:40:03', '2018-03-14 10:40:03'),
  291. (54, 2, 32, '2018-03-14 11:06:32', '2018-03-14 11:06:32'),
  292. (55, 11, 19, '2018-03-14 11:16:05', '2018-03-14 11:16:05'),
  293. (58, 11, 22, '2018-03-14 15:51:19', '2018-03-14 15:51:19'),
  294. (60, 11, 32, '2018-03-14 16:01:17', '2018-03-14 16:01:17'),
  295. (61, 11, 23, '2018-03-14 16:02:58', '2018-03-14 16:02:58'),
  296. (62, 11, 20, '2018-03-14 16:06:42', '2018-03-14 16:06:42'),
  297. (63, 11, 43, '2018-03-15 09:48:39', '2018-03-15 09:48:39'),
  298. (64, 2, 44, '2018-03-15 10:02:23', '2018-03-15 10:02:23'),
  299. (65, 11, 37, '2018-03-15 13:12:03', '2018-03-15 13:12:03'),
  300. (66, 2, 16, '2018-03-15 15:44:52', '2018-03-15 15:44:52'),
  301. (69, 2, 46, '2018-03-16 06:02:44', '2018-03-16 06:02:44'),
  302. (70, 2, 45, '2018-03-16 06:03:21', '2018-03-16 06:03:21'),
  303. (72, 19, 46, '2018-03-16 06:04:01', '2018-03-16 06:04:01'),
  304. (73, 19, 45, '2018-03-16 06:04:14', '2018-03-16 06:04:14'),
  305. (77, 3, 11, '2018-03-16 06:37:27', '2018-03-16 06:37:27'),
  306. (79, 3, 16, '2018-03-16 06:48:58', '2018-03-16 06:48:58'),
  307. (80, 3, 10, '2018-03-16 12:58:38', '2018-03-16 12:58:38'),
  308. (81, 19, 10, '2018-03-16 13:02:18', '2018-03-16 13:02:18'),
  309. (82, 13, 33, '2018-03-16 14:33:38', '2018-03-16 14:33:38'),
  310. (84, 20, 46, '2018-03-16 14:37:51', '2018-03-16 14:37:51'),
  311. (87, 19, 51, '2018-03-19 10:10:42', '2018-03-19 10:10:42'),
  312. (88, 19, 49, '2018-03-19 10:10:44', '2018-03-19 10:10:44'),
  313. (89, 19, 47, '2018-03-19 10:10:50', '2018-03-19 10:10:50'),
  314. (90, 19, 35, '2018-03-19 10:10:59', '2018-03-19 10:10:59'),
  315. (91, 19, 25, '2018-03-19 10:11:01', '2018-03-19 10:11:01'),
  316. (92, 19, 24, '2018-03-19 10:11:03', '2018-03-19 10:11:03'),
  317. (93, 19, 18, '2018-03-19 10:11:10', '2018-03-19 10:11:10'),
  318. (94, 19, 17, '2018-03-19 10:11:11', '2018-03-19 10:11:11'),
  319. (95, 19, 7, '2018-03-19 10:11:16', '2018-03-19 10:11:16'),
  320. (96, 19, 11, '2018-03-19 10:11:18', '2018-03-19 10:11:18'),
  321. (97, 19, 4, '2018-03-19 10:11:21', '2018-03-19 10:11:21'),
  322. (98, 19, 6, '2018-03-19 10:11:23', '2018-03-19 10:11:23'),
  323. (99, 19, 50, '2018-03-19 10:11:29', '2018-03-19 10:11:29'),
  324. (100, 19, 19, '2018-03-19 10:11:30', '2018-03-19 10:11:30'),
  325. (101, 19, 16, '2018-03-19 10:11:33', '2018-03-19 10:11:33'),
  326. (102, 19, 13, '2018-03-19 10:11:35', '2018-03-19 10:11:35'),
  327. (103, 19, 9, '2018-03-19 10:11:38', '2018-03-19 10:11:38'),
  328. (104, 19, 8, '2018-03-19 10:11:40', '2018-03-19 10:11:40'),
  329. (105, 19, 5, '2018-03-19 10:11:42', '2018-03-19 10:11:42'),
  330. (106, 19, 2, '2018-03-19 10:11:43', '2018-03-19 10:11:43');
  331.  
  332. -- --------------------------------------------------------
  333.  
  334. --
  335. -- Table structure for table `follows`
  336. --
  337.  
  338. CREATE TABLE `follows` (
  339. `id` int(11) NOT NULL,
  340. `user_id_1` int(11) NOT NULL,
  341. `user_id_2` int(11) NOT NULL,
  342. `created_at` timestamp NULL DEFAULT NULL,
  343. `updated_at` timestamp NULL DEFAULT NULL
  344. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  345.  
  346. --
  347. -- Dumping data for table `follows`
  348. --
  349.  
  350. INSERT INTO `follows` (`id`, `user_id_1`, `user_id_2`, `created_at`, `updated_at`) VALUES
  351. (1, 6, 6, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  352. (2, 6, 8, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  353. (3, 10, 10, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  354. (4, 5, 7, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  355. (5, 2, 4, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  356. (6, 5, 4, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  357. (7, 5, 8, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  358. (8, 5, 8, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  359. (9, 4, 5, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  360. (10, 3, 9, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  361. (11, 7, 2, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  362. (12, 2, 7, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  363. (13, 2, 8, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  364. (14, 5, 6, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  365. (15, 1, 10, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  366. (16, 2, 6, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  367. (17, 5, 8, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  368. (18, 4, 5, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  369. (19, 8, 8, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  370. (20, 1, 9, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  371. (21, 12, 13, '2018-03-09 13:42:54', '2018-03-09 13:42:54'),
  372. (25, 2, 11, '2018-03-14 11:02:33', '2018-03-14 11:02:33'),
  373. (26, 20, 13, '2018-03-16 15:07:37', '2018-03-16 15:07:37'),
  374. (27, 13, 10, '2018-03-17 05:01:33', '2018-03-17 05:01:33'),
  375. (30, 13, 20, '2018-03-17 05:10:37', '2018-03-17 05:10:37'),
  376. (31, 13, 19, '2018-03-17 05:38:03', '2018-03-17 05:38:03'),
  377. (38, 19, 13, '2018-03-17 06:22:08', '2018-03-17 06:22:08');
  378.  
  379. -- --------------------------------------------------------
  380.  
  381. --
  382. -- Table structure for table `notifications`
  383. --
  384.  
  385. CREATE TABLE `notifications` (
  386. `id` int(11) NOT NULL,
  387. `user_id_1` int(11) NOT NULL COMMENT 'Sender',
  388. `user_id_2` int(11) NOT NULL COMMENT 'Receiver',
  389. `notif_type` tinyint(11) NOT NULL COMMENT '1 - Post Sold, 2 - Favourite, 3 - Follow, 4 - Praise, 5 - Post Duplicate',
  390. `notif_msg` varchar(255) NOT NULL,
  391. `post_id` int(11) DEFAULT NULL,
  392. `favorite_id` int(11) DEFAULT NULL,
  393. `follow_id` int(11) DEFAULT NULL,
  394. `praise_id` int(11) DEFAULT NULL,
  395. `is_read` tinyint(1) NOT NULL,
  396. `created_at` timestamp NULL DEFAULT NULL,
  397. `updated_at` timestamp NULL DEFAULT NULL
  398. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  399.  
  400. --
  401. -- Dumping data for table `notifications`
  402. --
  403.  
  404. INSERT INTO `notifications` (`id`, `user_id_1`, `user_id_2`, `notif_type`, `notif_msg`, `post_id`, `favorite_id`, `follow_id`, `praise_id`, `is_read`, `created_at`, `updated_at`) VALUES
  405. (8, 1, 12, 2, 'just loved your listing', 21, 81, NULL, NULL, 0, '2018-03-08 05:14:44', '2018-03-08 05:14:44'),
  406. (9, 1, 41, 2, 'just loved your listing', 70, 82, NULL, NULL, 0, '2018-03-08 05:15:43', '2018-03-08 05:15:43'),
  407. (14, 40, 53, 2, 'just loved your listing', 80, 87, NULL, NULL, 0, '2018-03-08 06:09:08', '2018-03-08 06:09:08'),
  408. (15, 40, 53, 3, 'started following you', NULL, NULL, 26, NULL, 0, '2018-03-08 06:53:07', '2018-03-08 06:53:07'),
  409. (16, 40, 50, 2, 'just loved your listing', 62, 88, NULL, NULL, 0, '2018-03-08 07:35:55', '2018-03-08 07:35:55'),
  410. (19, 53, 53, 2, 'just loved your listing', 80, 91, NULL, NULL, 0, '2018-03-08 07:54:48', '2018-03-08 07:54:48'),
  411. (20, 53, 40, 2, 'just loved your listing', 79, 92, NULL, NULL, 0, '2018-03-08 07:55:30', '2018-03-08 07:55:30'),
  412. (21, 50, 50, 2, 'just loved your listing', 56, 93, NULL, NULL, 0, '2018-03-08 12:23:04', '2018-03-08 12:23:04'),
  413. (22, 5, 50, 3, 'started following you', NULL, NULL, 27, NULL, 0, '2018-03-08 12:37:11', '2018-03-08 12:37:11'),
  414. (23, 50, 4, 2, 'just loved your listing', 20, 94, NULL, NULL, 0, '2018-03-08 12:40:53', '2018-03-08 12:40:53'),
  415. (24, 50, 5, 2, 'just loved your listing', 11, 95, NULL, NULL, 0, '2018-03-08 12:40:57', '2018-03-08 12:40:57'),
  416. (25, 11, 11, 2, 'just loved your listing', 21, 11, NULL, NULL, 1, '2018-03-09 05:41:35', '2018-03-15 13:41:13'),
  417. (26, 11, 12, 1, 'has been marked as reduced', 21, NULL, NULL, NULL, 0, '2018-03-09 06:16:10', '2018-03-09 06:16:10'),
  418. (28, 11, 8, 1, 'has been marked as reduced', 23, NULL, NULL, NULL, 0, '2018-03-09 11:14:21', '2018-03-09 11:14:21'),
  419. (29, 11, 11, 4, 'praised you', 23, NULL, NULL, 1, 1, '2018-03-09 11:14:32', '2018-03-15 13:41:13'),
  420. (30, 11, 12, 1, 'has been marked as reduced', 22, NULL, NULL, NULL, 0, '2018-03-09 12:27:23', '2018-03-09 12:27:23'),
  421. (31, 11, 12, 1, 'has been marked as reduced', 22, NULL, NULL, NULL, 0, '2018-03-09 13:06:17', '2018-03-09 13:06:17'),
  422. (32, 11, 11, 4, 'praised you', 22, NULL, NULL, 2, 1, '2018-03-09 13:06:26', '2018-03-15 13:41:13'),
  423. (35, 12, 13, 3, 'started following you', NULL, NULL, 21, NULL, 1, '2018-03-09 13:42:54', '2018-03-17 09:04:37'),
  424. (36, 12, 13, 2, 'just loved your listing', 33, 15, NULL, NULL, 1, '2018-03-09 13:48:54', '2018-03-17 09:04:37'),
  425. (37, 12, 11, 2, 'just loved your listing', 32, 16, NULL, NULL, 1, '2018-03-09 13:49:43', '2018-03-15 13:41:13'),
  426. (38, 12, 13, 2, 'just loved your listing', 24, 17, NULL, NULL, 1, '2018-03-09 13:49:48', '2018-03-17 09:04:37'),
  427. (39, 12, 13, 2, 'just loved your listing', 25, 18, NULL, NULL, 1, '2018-03-09 13:49:51', '2018-03-17 09:04:37'),
  428. (40, 12, 11, 2, 'just loved your listing', 21, 19, NULL, NULL, 1, '2018-03-09 13:50:13', '2018-03-15 13:41:13'),
  429. (41, 13, 12, 1, 'has been marked as reduced', 33, NULL, NULL, NULL, 0, '2018-03-09 14:00:47', '2018-03-09 14:00:47'),
  430. (42, 12, 13, 2, 'just loved your listing', 36, 20, NULL, NULL, 1, '2018-03-09 14:23:18', '2018-03-17 09:04:37'),
  431. (43, 13, 13, 2, 'just loved your listing', 24, 21, NULL, NULL, 1, '2018-03-09 14:39:00', '2018-03-17 09:04:37'),
  432. (45, 13, 13, 2, 'just loved your listing', 35, 23, NULL, NULL, 1, '2018-03-09 14:39:22', '2018-03-17 09:04:37'),
  433. (46, 13, 13, 2, 'just loved your listing', 36, 24, NULL, NULL, 1, '2018-03-09 14:39:27', '2018-03-17 09:04:37'),
  434. (47, 13, 12, 1, 'has been marked as reduced', 36, NULL, NULL, NULL, 0, '2018-03-09 14:49:04', '2018-03-09 14:49:04'),
  435. (48, 13, 12, 1, 'has been marked as reduced', 26, NULL, NULL, NULL, 0, '2018-03-09 14:50:37', '2018-03-09 14:50:37'),
  436. (60, 11, 13, 2, 'just loved your listing', 25, 35, NULL, NULL, 1, '2018-03-14 05:09:30', '2018-03-17 09:04:37'),
  437. (61, 1, 11, 2, 'just loved your listing', 32, 36, NULL, NULL, 1, '2018-03-14 05:54:15', '2018-03-15 13:41:13'),
  438. (63, 11, 10, 2, 'just loved your listing', 18, 38, NULL, NULL, 0, '2018-03-14 07:28:21', '2018-03-14 07:28:21'),
  439. (65, 11, 2, 2, 'just loved your listing', 15, 40, NULL, NULL, 1, '2018-03-14 07:28:36', '2018-03-14 11:22:34'),
  440. (68, 2, 1, 2, 'just loved your listing', 39, 42, NULL, NULL, 0, '2018-03-14 09:13:20', '2018-03-14 09:13:20'),
  441. (69, 1, 2, 1, 'has been marked as reduced', 39, NULL, NULL, NULL, 1, '2018-03-14 09:19:28', '2018-03-14 11:22:34'),
  442. (70, 1, 1, 4, 'praised you', 39, NULL, NULL, 3, 0, '2018-03-14 09:19:52', '2018-03-14 09:19:52'),
  443. (76, 1, 1, 2, 'just loved your listing', 42, 48, NULL, NULL, 0, '2018-03-14 10:40:03', '2018-03-14 10:40:03'),
  444. (83, 2, 11, 3, 'started following you', NULL, NULL, 25, NULL, 1, '2018-03-14 11:02:33', '2018-03-15 13:41:13'),
  445. (84, 2, 11, 2, 'just loved your listing', 32, 54, NULL, NULL, 1, '2018-03-14 11:06:32', '2018-03-15 13:41:13'),
  446. (85, 2, 11, 1, 'has been marked as reduced', 15, NULL, NULL, NULL, 1, '2018-03-14 11:10:42', '2018-03-15 13:41:13'),
  447. (86, 2, 2, 4, 'praised you', 15, NULL, NULL, 4, 1, '2018-03-14 11:11:11', '2018-03-14 11:22:34'),
  448. (87, 11, 5, 2, 'just loved your listing', 19, 55, NULL, NULL, 0, '2018-03-14 11:16:05', '2018-03-14 11:16:05'),
  449. (89, 11, 2, 1, 'has been marked as reduced', 32, NULL, NULL, NULL, 1, '2018-03-14 11:21:17', '2018-03-14 11:22:34'),
  450. (90, 11, 11, 4, 'praised you', 32, NULL, NULL, 5, 1, '2018-03-14 11:23:24', '2018-03-15 13:41:13'),
  451. (92, 11, 11, 2, 'just loved your listing', 22, 58, NULL, NULL, 1, '2018-03-14 15:51:19', '2018-03-15 13:41:13'),
  452. (94, 11, 11, 2, 'just loved your listing', 32, 60, NULL, NULL, 1, '2018-03-14 16:01:17', '2018-03-15 13:41:13'),
  453. (95, 11, 11, 2, 'just loved your listing', 23, 61, NULL, NULL, 1, '2018-03-14 16:02:58', '2018-03-15 13:41:13'),
  454. (96, 11, 4, 2, 'just loved your listing', 20, 62, NULL, NULL, 0, '2018-03-14 16:06:42', '2018-03-14 16:06:42'),
  455. (97, 11, 2, 2, 'just loved your listing', 43, 63, NULL, NULL, 0, '2018-03-15 09:48:39', '2018-03-15 09:48:39'),
  456. (98, 2, 11, 1, 'has been marked as reduced', 43, NULL, NULL, NULL, 1, '2018-03-15 09:50:26', '2018-03-15 13:41:13'),
  457. (99, 11, 2, 4, 'praised you', 43, NULL, NULL, 6, 0, '2018-03-15 09:50:43', '2018-03-15 09:50:43'),
  458. (100, 2, 11, 2, 'just loved your listing', 44, 64, NULL, NULL, 1, '2018-03-15 10:02:23', '2018-03-15 13:41:13'),
  459. (101, 11, 2, 1, 'has been marked as reduced', 44, NULL, NULL, NULL, 0, '2018-03-15 10:03:26', '2018-03-15 10:03:26'),
  460. (102, 11, 13, 2, 'just loved your listing', 37, 65, NULL, NULL, 1, '2018-03-15 13:12:03', '2018-03-17 09:04:37'),
  461. (103, 2, 1, 2, 'just loved your listing', 16, 66, NULL, NULL, 0, '2018-03-15 15:44:52', '2018-03-15 15:44:52'),
  462. (106, 2, 18, 2, 'just loved your listing', 46, 69, NULL, NULL, 0, '2018-03-16 06:02:44', '2018-03-16 06:02:44'),
  463. (107, 2, 18, 2, 'just loved your listing', 45, 70, NULL, NULL, 0, '2018-03-16 06:03:21', '2018-03-16 06:03:21'),
  464. (109, 19, 18, 2, 'just loved your listing', 46, 72, NULL, NULL, 0, '2018-03-16 06:04:01', '2018-03-16 06:04:01'),
  465. (110, 19, 18, 2, 'just loved your listing', 45, 73, NULL, NULL, 0, '2018-03-16 06:04:14', '2018-03-16 06:04:14'),
  466. (114, 3, 1, 2, 'just loved your listing', 11, 77, NULL, NULL, 0, '2018-03-16 06:37:27', '2018-03-16 06:37:27'),
  467. (116, 3, 1, 2, 'just loved your listing', 16, 79, NULL, NULL, 0, '2018-03-16 06:48:58', '2018-03-16 06:48:58'),
  468. (117, 3, 3, 2, 'just loved your listing', 10, 80, NULL, NULL, 0, '2018-03-16 12:58:38', '2018-03-16 12:58:38'),
  469. (118, 19, 3, 2, 'just loved your listing', 10, 81, NULL, NULL, 0, '2018-03-16 13:02:18', '2018-03-16 13:02:18'),
  470. (119, 13, 13, 2, 'just loved your listing', 33, 82, NULL, NULL, 1, '2018-03-16 14:33:38', '2018-03-17 09:04:37'),
  471. (121, 20, 18, 2, 'just loved your listing', 46, 84, NULL, NULL, 0, '2018-03-16 14:37:51', '2018-03-16 14:37:51'),
  472. (124, 20, 13, 3, 'started following you', NULL, NULL, 26, NULL, 1, '2018-03-16 15:07:37', '2018-03-17 09:04:37'),
  473. (125, 13, 10, 3, 'started following you', NULL, NULL, 27, NULL, 0, '2018-03-17 05:01:33', '2018-03-17 05:01:33'),
  474. (126, 13, 20, 3, 'started following you', NULL, NULL, 30, NULL, 0, '2018-03-17 05:10:37', '2018-03-17 05:10:37'),
  475. (127, 13, 19, 1, 'has been marked as reduced', 37, NULL, NULL, NULL, 1, '2018-03-17 05:13:00', '2018-03-19 11:22:04'),
  476. (128, 19, 13, 4, 'praised you', 37, NULL, NULL, 7, 1, '2018-03-17 05:13:12', '2018-03-17 09:04:37'),
  477. (129, 13, 19, 1, 'has been marked as reduced', 34, NULL, NULL, NULL, 1, '2018-03-17 05:24:07', '2018-03-19 11:22:04'),
  478. (130, 19, 13, 4, 'praised you', 34, NULL, NULL, 8, 1, '2018-03-17 05:25:10', '2018-03-17 09:04:37'),
  479. (131, 13, 19, 3, 'started following you', NULL, NULL, 31, NULL, 1, '2018-03-17 05:38:03', '2018-03-19 11:22:04'),
  480. (134, 19, 13, 3, 'started following you', NULL, NULL, 38, NULL, 1, '2018-03-17 06:22:08', '2018-03-17 09:04:37'),
  481. (135, 19, 13, 1, 'has been marked as reduced', 48, NULL, NULL, NULL, 1, '2018-03-17 06:26:38', '2018-03-17 09:04:37'),
  482. (136, 19, 19, 2, 'just loved your listing', 51, 87, NULL, NULL, 1, '2018-03-19 10:10:42', '2018-03-19 11:22:04'),
  483. (137, 19, 13, 2, 'just loved your listing', 49, 88, NULL, NULL, 0, '2018-03-19 10:10:44', '2018-03-19 10:10:44'),
  484. (138, 19, 19, 2, 'just loved your listing', 47, 89, NULL, NULL, 1, '2018-03-19 10:10:50', '2018-03-19 11:22:04'),
  485. (139, 19, 13, 2, 'just loved your listing', 35, 90, NULL, NULL, 0, '2018-03-19 10:10:59', '2018-03-19 10:10:59'),
  486. (140, 19, 13, 2, 'just loved your listing', 25, 91, NULL, NULL, 0, '2018-03-19 10:11:01', '2018-03-19 10:11:01'),
  487. (141, 19, 13, 2, 'just loved your listing', 24, 92, NULL, NULL, 0, '2018-03-19 10:11:03', '2018-03-19 10:11:03'),
  488. (142, 19, 10, 2, 'just loved your listing', 18, 93, NULL, NULL, 0, '2018-03-19 10:11:10', '2018-03-19 10:11:10'),
  489. (143, 19, 8, 2, 'just loved your listing', 17, 94, NULL, NULL, 0, '2018-03-19 10:11:11', '2018-03-19 10:11:11'),
  490. (144, 19, 10, 2, 'just loved your listing', 7, 95, NULL, NULL, 0, '2018-03-19 10:11:16', '2018-03-19 10:11:16'),
  491. (145, 19, 1, 2, 'just loved your listing', 11, 96, NULL, NULL, 0, '2018-03-19 10:11:18', '2018-03-19 10:11:18'),
  492. (146, 19, 6, 2, 'just loved your listing', 4, 97, NULL, NULL, 0, '2018-03-19 10:11:21', '2018-03-19 10:11:21'),
  493. (147, 19, 6, 2, 'just loved your listing', 6, 98, NULL, NULL, 0, '2018-03-19 10:11:23', '2018-03-19 10:11:23'),
  494. (148, 19, 19, 2, 'just loved your listing', 50, 99, NULL, NULL, 1, '2018-03-19 10:11:29', '2018-03-19 11:22:04'),
  495. (149, 19, 5, 2, 'just loved your listing', 19, 100, NULL, NULL, 0, '2018-03-19 10:11:30', '2018-03-19 10:11:30'),
  496. (150, 19, 1, 2, 'just loved your listing', 16, 101, NULL, NULL, 0, '2018-03-19 10:11:33', '2018-03-19 10:11:33'),
  497. (151, 19, 4, 2, 'just loved your listing', 13, 102, NULL, NULL, 0, '2018-03-19 10:11:35', '2018-03-19 10:11:35'),
  498. (152, 19, 10, 2, 'just loved your listing', 9, 103, NULL, NULL, 0, '2018-03-19 10:11:38', '2018-03-19 10:11:38'),
  499. (153, 19, 1, 2, 'just loved your listing', 8, 104, NULL, NULL, 0, '2018-03-19 10:11:40', '2018-03-19 10:11:40'),
  500. (154, 19, 8, 2, 'just loved your listing', 5, 105, NULL, NULL, 0, '2018-03-19 10:11:42', '2018-03-19 10:11:42'),
  501. (155, 19, 1, 2, 'just loved your listing', 2, 106, NULL, NULL, 0, '2018-03-19 10:11:43', '2018-03-19 10:11:43');
  502.  
  503. -- --------------------------------------------------------
  504.  
  505. --
  506. -- Table structure for table `password_resets`
  507. --
  508.  
  509. CREATE TABLE `password_resets` (
  510. `id` int(11) NOT NULL,
  511. `user_id` int(11) NOT NULL,
  512. `email` varchar(255) NOT NULL,
  513. `token` varchar(255) NOT NULL,
  514. `created_at` timestamp NULL DEFAULT NULL,
  515. `updated_at` timestamp NULL DEFAULT NULL
  516. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  517.  
  518. --
  519. -- Dumping data for table `password_resets`
  520. --
  521.  
  522. INSERT INTO `password_resets` (`id`, `user_id`, `email`, `token`, `created_at`, `updated_at`) VALUES
  523. (1, 14, 'ekta.henceforth@gmail.com', 'MxUs7KgwhL4mI9SZAjhDD3VBTZhy1T', '2018-03-09 11:03:58', '2018-03-09 11:03:58');
  524.  
  525. -- --------------------------------------------------------
  526.  
  527. --
  528. -- Table structure for table `posts`
  529. --
  530.  
  531. CREATE TABLE `posts` (
  532. `id` int(11) NOT NULL,
  533. `user_id` int(11) NOT NULL,
  534. `title` varchar(128) NOT NULL,
  535. `type` tinyint(4) NOT NULL COMMENT '1 - food, 2 - supply, 3 - community & service',
  536. `category_id` int(11) NOT NULL,
  537. `sub_category_id` int(11) NOT NULL,
  538. `images` text,
  539. `price` int(11) NOT NULL,
  540. `is_firm` tinyint(4) NOT NULL DEFAULT '0',
  541. `order_type` tinyint(4) DEFAULT NULL COMMENT '1 - Available, 2 - Pre Order',
  542. `made_out_of` tinyint(4) NOT NULL COMMENT '1 - Home kitchen, 2 - Commercial',
  543. `rate` int(11) DEFAULT NULL COMMENT '1 - per hour, 2 - per full, 3 - rent, 4 - other',
  544. `location` varchar(255) DEFAULT NULL,
  545. `lat` double DEFAULT NULL,
  546. `lng` double DEFAULT NULL,
  547. `condition_type` tinyint(4) DEFAULT NULL COMMENT '0 - Unused, 1 - Used',
  548. `description` text,
  549. `weight_quantity` int(11) DEFAULT NULL,
  550. `tags` varchar(255) NOT NULL,
  551. `is_location_visible` tinyint(4) NOT NULL DEFAULT '0',
  552. `is_free_delivery` tinyint(4) NOT NULL DEFAULT '0',
  553. `is_looking_for` tinyint(4) NOT NULL DEFAULT '0',
  554. `is_fb_share` tinyint(4) NOT NULL DEFAULT '0',
  555. `share_count` int(11) DEFAULT NULL,
  556. `sold_to` int(11) DEFAULT NULL,
  557. `created_at` timestamp NULL DEFAULT NULL,
  558. `updated_at` timestamp NULL DEFAULT NULL
  559. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  560.  
  561. --
  562. -- Dumping data for table `posts`
  563. --
  564.  
  565. INSERT INTO `posts` (`id`, `user_id`, `title`, `type`, `category_id`, `sub_category_id`, `images`, `price`, `is_firm`, `order_type`, `made_out_of`, `rate`, `location`, `lat`, `lng`, `condition_type`, `description`, `weight_quantity`, `tags`, `is_location_visible`, `is_free_delivery`, `is_looking_for`, `is_fb_share`, `share_count`, `sold_to`, `created_at`, `updated_at`) VALUES
  566. (1, 8, 'Title 1', 3, 9, 4, '[{\"image\": \"img3.jpg\",\"is_cover\": \"1\"},{\"image\": \"img6.jpg\",\"is_cover\": \"0\"}]', 223, 1, 1, 1, 3, 'Chandigarh', 30.733315, 76.779418, 0, 'QhWOPpX8NWAB076BHeXaDPKuwzlLPoHIo0qNdshuj9Xk1CcHhTxcs9Y2itrVSQmc4vMNBfjU82PuA17a ISL48Qe6xpipNK2troELmOUxzV0gVSIelM3hWtz0hhj499m9vaEJXanx2RQipYIFuvcuggREcn1Tl5piJQREKEG6BjdZwY6JUoFi', 27, '[\"1\", \"5\", \"5\"]', 0, 0, 0, 1, 58, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  567. (2, 1, 'Title 2', 2, 5, 8, '[{\"image\": \"img6.jpg\",\"is_cover\": \"1\"},{\"image\": \"img1.jpg\",\"is_cover\": \"0\"}]', 711, 0, 1, 2, 4, 'Chandigarh', 30.733315, 76.779418, 0, 'bbJprikRkwWV1jZawfoqEpaHMHHYmUNydIX3x69gRczBR56fjkHslBua7O2ltlOlrWkiZAtJGgxbRztl XcjTDpXgU57v1axSsrI2mDoxyYqToYvqvlcvDMmeK90Ma1F1T4Tiwt606o1FfY8iNknYQpkMl98WWxsqE1UGubyqCEZDdkbUhuJW', 36, '[\"2\", \"3\", \"1\"]', 0, 0, 0, 0, 7, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  568. (3, 6, 'Title 3', 3, 2, 5, '[{\"image\": \"img9.jpg\",\"is_cover\": \"1\"},{\"image\": \"img6.jpg\",\"is_cover\": \"0\"}]', 798, 0, 1, 1, 2, 'Chandigarh', 30.733315, 76.779418, 0, 'l4G68MPCEdQqQDWxYEKWL8WA6VWTOikFYM2HVd2CoiaBl3Qh1rM1oh05EvGbkaAPpD6n71Z1TkM4Kspe zAaOtWtBXtRID6UDCkM3ico9ZGA3AW510O7z2N4MODy5iHwz3xI7y0SjTc00uFg7tiiZId8vKXnPZ1uWA1loI4kn55aW7U5Xckrq', 45, '[\"1\", \"3\", \"5\"]', 1, 1, 0, 0, 59, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  569. (4, 6, 'Title 4', 1, 8, 1, '[{\"image\": \"img3.jpg\",\"is_cover\": \"1\"},{\"image\": \"img2.jpg\",\"is_cover\": \"0\"}]', 492, 1, 2, 2, 1, 'Chandigarh', 30.733315, 76.779418, 0, '2Y92hzkN0bkm8sIzm5UdzTC0nvd9lkYNLcHCcpLKJ3qplLKSizmK5RsiChZqL6u9pjVRMXnrPXkjYytK kFvgmTkdT7n1jApZXGMsUvcCLT0BChPbhFl7YydezCorn0Uag5RU87QuWcqjp9OtN75x7WAsfQSqbMc7oA4AhlPdRPBhfu74vDMN', 39, '[\"4\", \"1\", \"2\"]', 0, 0, 1, 1, 76, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  570. (5, 8, 'Title 5', 2, 8, 3, '[{\"image\": \"img6.jpg\",\"is_cover\": \"1\"},{\"image\": \"img7.jpg\",\"is_cover\": \"0\"}]', 101, 1, 1, 2, 3, 'Chandigarh', 30.733315, 76.779418, 0, 'ryDZ3HySzZbPB8dQCVpXTBgFBOCtLt4rxjTTgAKr2AoqB9CTKgucN8uc11gBKrtjgaZ5qBMRPOIQKcbO yb0zbS8RvBblrcBVjQEc9LMD8vuQXQEjoEBA8SDOKs3mPnIaUb1fkMwVqipeOsJ0ubtif0TLi5ukVRArAhZBDZTjgCdQIVX4RpWa', 26, '[\"4\", \"3\", \"4\"]', 0, 0, 0, 1, 24, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  571. (6, 6, 'Title 6', 1, 9, 7, '[{\"image\": \"img6.jpg\",\"is_cover\": \"1\"},{\"image\": \"img4.jpg\",\"is_cover\": \"0\"}]', 295, 0, 1, 2, 4, 'Chandigarh', 30.733315, 76.779418, 1, 'PyJ4Bw8kqxh4y1alCHMp6rqSMCHPuGZvgapcA8wo5xFF5EokQTOSbtTXFK0zcnHkWIUVBb8J1O61Eo8C uBFU9bVq6GBx4RPprydB208B5EpMtVzVKzBwsh5WanrTFliXHRxRI2WLNJVA5azAv8YSBul34k1DtYbmZfKi4s2e4UD99LyMVn4S', 44, '[\"2\", \"2\", \"3\"]', 0, 0, 1, 1, 83, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  572. (7, 10, 'Title 7', 1, 5, 5, '[{\"image\": \"img9.jpg\",\"is_cover\": \"1\"},{\"image\": \"img6.jpg\",\"is_cover\": \"0\"}]', 681, 0, 1, 2, 3, 'Chandigarh', 30.733315, 76.779418, 0, 'jsk4BLOqSo1whKTXeF8ftTHPvyF45qgASvj8R2o7vdydC52RBKRXhwLPfMreaq40Ru4vnPDojoqxWxsj 3gMJtXueHjgO1HxXAVbh6JdL05fj5vCIfUUDwbUGTVvAvy4lcsdDAFmbs4XbfBCNdI0wKE9flNR4EP7P2UEgxF3iSfulN22zsADR', 42, '[\"2\", \"5\", \"1\"]', 1, 0, 0, 1, 9, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  573. (8, 1, 'Title 8', 2, 4, 4, '[{\"image\": \"img10.jpg\",\"is_cover\": \"1\"},{\"image\": \"img7.jpg\",\"is_cover\": \"0\"}]', 762, 1, 1, 2, 3, 'Chandigarh', 30.733315, 76.779418, 1, 'JXmW6Wjvnr2638VorLMBedwucSF6fDDODKlPGMm3GFpnB3oHB3u65vqzfJf5tSxfoI5LHHFIMrg4mJk8 SrhL8xt2L7JIZKldBvQFpXvldeBmf06uA9IRWudJrfzsiVqiyu2FTfbfyeBYtsqj1aiMi0PxCvsstKHIIfv2ZMIKr8xs9il5FvJi', 10, '[\"1\", \"3\", \"3\"]', 1, 1, 1, 1, 19, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  574. (9, 10, 'Title 9', 2, 6, 8, '[{\"image\": \"img6.jpg\",\"is_cover\": \"1\"},{\"image\": \"img2.jpg\",\"is_cover\": \"0\"}]', 120, 1, 2, 1, 4, 'Chandigarh', 30.733315, 76.779418, 0, 'CIhlPLLGHn2pD11lWnClafg5pE9cGdqZrWDd0LdXM9YJXzaOos0rUwrg8valLwXlZEmDA6bWzzTTO7jc p4yoFMZo3EzQDIgCAZN9lexrouwAbXiFFUQvJgXfAXeciGOCUQIP18DSTxSFA720H6YLdpPDhxddYmiyUjT7iOL05fWQaOOJX2UZ', 28, '[\"2\", \"1\", \"1\"]', 0, 1, 1, 1, 28, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  575. (10, 3, 'Title 10', 2, 4, 7, '[{\"image\": \"img2.jpg\",\"is_cover\": \"1\"},{\"image\": \"img2.jpg\",\"is_cover\": \"0\"}]', 406, 1, 2, 2, 4, 'Chandigarh', 30.733315, 76.779418, 0, 'TOGhAaVU4ZeLXdMgF0TiVoXf7GsdFHcNCG1vtaOtVTvXtoBCvvUMJktzo0VOgEBZT6Fxf6LaFEwzAw4B 8yhokqXaMCc4uuatDRLrF5jG03shrgL2bfurWdzl6kXhpbrWl9IPkwjBtOeqZYI2YCJyWyuCOUujHwGuXv1nxNjnp8lMUcWSPK2E', 13, '[\"4\", \"5\", \"2\"]', 1, 1, 1, 1, 56, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  576. (11, 1, 'Title 11', 1, 9, 2, '[{\"image\": \"img4.jpg\",\"is_cover\": \"1\"},{\"image\": \"img10.jpg\",\"is_cover\": \"0\"}]', 825, 1, 2, 1, 1, 'Chandigarh', 30.733315, 76.779418, 0, 'YezgMjj5DEz81Uc29JSnawi9VFWmtOTAH31HGAVixWiGdsHY27d9NEMZKz5YHOfVG6QaLar6F5ZliZDs ZqwetLcc2Lgv4Gc6dkT2jh6BMYMKV4Lc5DxFdga5ly3yIH7RIiKGqmw3HtHgCQGI0ob1FONiU0hvEBF014TXUoxCmoGUF9aMncgk', 29, '[\"5\", \"3\", \"4\"]', 0, 0, 0, 1, 100, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  577. (12, 7, 'Title 12', 3, 6, 4, '[{\"image\": \"img10.jpg\",\"is_cover\": \"1\"},{\"image\": \"img4.jpg\",\"is_cover\": \"0\"}]', 178, 1, 1, 2, 4, 'Chandigarh', 30.733315, 76.779418, 0, 'gnj90b5A5L6ckryaPL2h8vbpRzZ1LvAX8XuolS7rbc2b8MEhtFC7ZLXBkmKwDe4hevfnxTqMgfw3z8aM 40JZxFrEV9nEl4042AQVkATSominr0AczbfSK0aTHiuapeFZOPCxihMYwQCQ3cfrrPYiyXIU6Ff3RQc2zyTaQE6cclaxdsLkIMVG', 31, '[\"1\", \"4\", \"3\"]', 1, 1, 0, 1, 56, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  578. (13, 4, 'Title 13', 2, 4, 8, '[{\"image\": \"img1.jpg\",\"is_cover\": \"1\"},{\"image\": \"img6.jpg\",\"is_cover\": \"0\"}]', 115, 0, 1, 1, 1, 'Chandigarh', 30.733315, 76.779418, 1, 'meUFajynBosTX6pAvrXoupquccvg4gymytsCtPKPopWgEnibJ9RQpJ1qbmvsqL0yESiM3r1zT0kMu3Ym zRz3Txmj1PGlUPy88qY9XvtnSOjlggc7R9JM3TAslbHIPsvAz9vWilQER38uac2Z60ONBPZyB26y2P1lgWdBV8Ly3UOugiZTZ9Kw', 37, '[\"3\", \"5\", \"1\"]', 1, 1, 0, 0, 77, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  579. (14, 5, 'Title 14', 3, 8, 2, '[{\"image\": \"img3.jpg\",\"is_cover\": \"1\"},{\"image\": \"img8.jpg\",\"is_cover\": \"0\"}]', 727, 0, 2, 1, 3, 'Chandigarh', 30.733315, 76.779418, 0, '0jBZhiFd6Hm781ezRGnPpRYzvaW5adbJu0HoeGGyPpV3psBfLUcc8uolAi2ZQuZKAbFq2SW9soF6sV01 SbF7iKpUk86BbpT0x8xtN1d2whpIld2aqJkn5A7ynYkM66anplZwP7ycJTgcLBPZVyITbiUGCOw5Al5fRm5jV18pcoegu0B5rfMN', 34, '[\"3\", \"1\", \"1\"]', 1, 1, 0, 1, 72, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  580. (15, 2, 'Title 15', 1, 3, 1, '[{\"image\": \"img3.jpg\",\"is_cover\": \"1\"},{\"image\": \"img9.jpg\",\"is_cover\": \"0\"}]', 901, 0, 1, 2, 4, 'Chandigarh', 30.733315, 76.779418, 1, '0PDeSSews68M8fh1GLkVRK66ZMgT1aYQtrO9HA2PFTpAU6v2r7k3Fur9Zs4bM365OJQtecuzD5b7nWgy BFyVHc36KNVBZ8VJ8kBuJ5WiodWXveWiw4r9i8Nr9nQLFKiT6s47njmvie277qTtp8e65inTXUzFWgpu13CUyyKFfCMMEhrp2Z3C', 30, '[\"1\", \"1\", \"2\"]', 1, 1, 1, 1, 30, 11, '2018-03-08 13:09:06', '2018-03-14 11:10:42'),
  581. (16, 1, 'Title 16', 2, 8, 3, '[{\"image\": \"img7.jpg\",\"is_cover\": \"1\"},{\"image\": \"img4.jpg\",\"is_cover\": \"0\"}]', 906, 1, 2, 2, 1, 'Chandigarh', 30.733315, 76.779418, 0, 'LbZoanJDoMrb3KxM6oZbTyAPtjXwFTbPjm08CYlZR5nSlYt1RhJjjr4zGRroMS46BDl4WjaZ3U62n1lz 1RPuESlcPgNVgKPohtxhNbf8PRiYXqxYYse2lJ6RBUQez2QIpchtYs5uUnOTt86lew5n3zZhGCz19PKXNicJkMw7SamS0wkhiNze', 45, '[\"2\", \"2\", \"4\"]', 0, 1, 1, 1, 53, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  582. (17, 8, 'Title 17', 1, 6, 9, '[{\"image\": \"img6.jpg\",\"is_cover\": \"1\"},{\"image\": \"img3.jpg\",\"is_cover\": \"0\"}]', 562, 1, 1, 2, 3, 'Chandigarh', 30.733315, 76.779418, 1, 'A2z3RXrXT3Bc54hPepDQMjJyoYi5JU6WfeVG0Waf5akYT7OWOsE8BhXL4aYAkr9M3v5ujPULZMVK7yBc oU2xfq7kewSJhLxQbRxcwHxzVcy2x7xKnrIAEfZEAiNC3O0r4ShdKRg3OuJVA0imrATxAGLb6ysY5ny1udeRYL0JH5Ird0yiHsEF', 35, '[\"5\", \"3\", \"5\"]', 1, 1, 1, 0, 70, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  583. (18, 10, 'Title 18', 1, 9, 3, '[{\"image\": \"img10.jpg\",\"is_cover\": \"1\"},{\"image\": \"img1.jpg\",\"is_cover\": \"0\"}]', 952, 1, 2, 1, 3, 'Chandigarh', 30.733315, 76.779418, 0, 'l9bauD06mQ7VH7WyqSq1WHIntK9b2ZpGK5nTTV8zlHtMWKpL2D4E2HSc9V1TwXynZSBFiMCbYuTjU9iQ PLi4i4INZCnnIHQQ7tpE2OcThr0alz1o00wNF2RWegWJFrlpc0ClXzvfHl08wL2RVkyIDL9OMXh7O1268h8OoUZZzw0xJdtHAZoZ', 11, '[\"3\", \"4\", \"2\"]', 0, 0, 1, 1, 85, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  584. (19, 5, 'Title 19', 2, 7, 9, '[{\"image\": \"img4.jpg\",\"is_cover\": \"1\"},{\"image\": \"img5.jpg\",\"is_cover\": \"0\"}]', 561, 0, 2, 1, 1, 'Chandigarh', 30.733315, 76.779418, 0, '57KBMXvBo87TLI6AxvMXjsj4l5Zs0vPOFvERrzMj60wNPeKRGyHn2tCBrDR9CUmxsbV0LLPng67XewZN BGii6GAgEyozsJPL5piM7BJ1454uv2puigDtsVxLvmmQJY4QtfgZ3BBiOjmKNLkAktWmUE7Z9l3JQe98lFcMs8PqFuI3wfT7d6IY', 16, '[\"3\", \"5\", \"2\"]', 0, 1, 0, 1, 31, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  585. (20, 4, 'Title 20', 3, 8, 2, '[{\"image\": \"img2.jpg\",\"is_cover\": \"1\"},{\"image\": \"img9.jpg\",\"is_cover\": \"0\"}]', 457, 1, 2, 1, 1, 'Chandigarh', 30.733315, 76.779418, 0, 'YaCzF6TfXFDnMCaxefvhbdZya1iWEmAVvOpL0gPFLLNFxppOOuYQRTryB1ddiz7T6IAyXp05sdH7YQgu SXyLx1QPvKzVlIiMV0r5UC4DOekfDRlLVBZWQLV0YHtJgtn60Uia81GkkLBcTcFA35RdtJiHkS7QJd9ZaIdrPe1nIlIU5pGwnz5L', 48, '[\"1\", \"3\", \"2\"]', 1, 1, 0, 1, 83, NULL, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  586. (21, 11, 'Test Post 1', 1, 1, 4, '[{\"image\":\"1520573610yWTGl3fOSXWIoNA7C0s9vUOQ09zTuh.jpg\",\"is_cover\":\"0\"},{\"image\":\"1520573619xGYE4NzmWuk9vktTBiBdcSU70tM4cp.jpg\",\"is_cover\":\"0\"},{\"image\":\"1520573634fsD3IQ7K2MxGDDmHxK3XB3zmA3GPQA.jpg\",\"is_cover\":\"1\"}]', 220, 0, 1, 2, NULL, 'Mohali Bypass, Phase 3B-2, Sector 60, Sahibzada Ajit Singh Nagar, Punjab, India', 30.7074632, 76.7155901, NULL, 'This is mode outside the kitchen.\nPlease ensure it befire purchasing it.\nReturn is not available.\nAll payments will be done offline.\nNo online payment', 123, '[\"5\",\"3\"]', 1, 1, 0, 1, 1, 12, NULL, '2018-03-09 06:16:10'),
  587. (22, 11, 'Title10', 1, 3, 10, '[{\"image\":\"15205801534Fz3fwos4rtj3JZ1xtMJ3ke9l50ZdH.jpg\",\"is_cover\":\"1\"}]', 2121, 1, 2, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'bdncbc\nxbbxcbcjf\nbxbxx', 13455, '[\"3\",\"2\",\"1\"]', 1, 0, 0, 1, NULL, 12, NULL, '2018-03-09 13:06:17'),
  588. (23, 11, 'Bags in market', 2, 15, 22, '[{\"image\":\"1520593427UvM80QVMkobceiGHg4RsAvvHbc0c6c.jpg\",\"is_cover\":\"0\"},{\"image\":\"1520593435yJGoXYEVSCVbqWdzvqrDiiTWpLlsVh.jpg\",\"is_cover\":\"0\"},{\"image\":\"1520593451QoA6RL2DAC9qqZdAKVhfyqVZpbLMLe.jpg\",\"is_cover\":\"1\"},{\"image\":\"1520593463YxAaa3jQ62RKT0rUE0y1D8Xq2IifQJ.jpg\",\"is_cover\":\"0\"}]', 2000, 1, NULL, 0, 3, 'Chandigarh, India', 30.7333148, 76.7794179, NULL, 'Clear the cell.... sale is going on', 12, '[\"5\",\"3\",\"2\",\"4\"]', 1, 1, 1, 1, NULL, 8, NULL, '2018-03-09 11:14:21'),
  589. (24, 13, 'ekta meena', 1, 7, 14, '[{\"image\":\"1520595557VKoCwcOXf5OxE4Tfq8qOJgSUVS94jw.jpg\",\"is_cover\":\"1\"},{\"image\":\"15205955855nmxEuNNcZLO0ztxjA3i6QvBp1DBWQ.jpg\",\"is_cover\":\"0\"}]', 120, 1, 2, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.7178726, NULL, 'hshshshhshsgsgsgsggsgegegggegegeggegegegegegsgsvsvevsgsgehshhshshshehshheheebhsys jdjdhd hdhdhd hdhd hdhdh jdhdh hdbdbd y hdvdhdhd udhdhd udhdhd hdhdhd hdhdhhd hdud Vd', 14, '[\"2\",\"3\"]', 1, 1, 1, 1, NULL, NULL, NULL, '2018-03-09 11:40:38'),
  590. (25, 13, 'cake', 1, 1, 7, '[{\"image\":\"1520595870SqKLH6HqifigFZvmULjEStA2aAmrh9.jpg\",\"is_cover\":\"1\"},{\"image\":\"1520595918Z5rC4OzKJsqBS9F47lX4ecsAAB0hiD.jpg\",\"is_cover\":\"0\"}]', 150, 1, 1, 1, NULL, 'Chandigarh, India', 30.7333148, 76.7794179, NULL, 'xmxkhfkhcmgxjgxjgxjgxjgx cjyxjgc. ddff\njdhshhdusuotditdifi\ndudutxiyfkyfoufodiyxkyditd5digdutj\nhtsutdutdifu', 150, '[\"1\",\"3\"]', 1, 1, 1, 1, NULL, NULL, NULL, '2018-03-09 11:48:11'),
  591. (26, 13, 'demo', 2, 11, 18, '[{\"image\":\"1520599998U3cANZAfG3ZkcgBBhHByOdFCACVb5E.jpg\",\"is_cover\":\"1\"},{\"image\":\"1520600016W8rmSlfGMned0G1lea77E06soCo6tD.jpg\",\"is_cover\":\"0\"}]', 188, 1, NULL, 0, 2, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'snsnsbsbs zjjshshss. zhshsbdjeudjufkhfjtudlhtdkhgdmhtsmgsmtdkyjjdjydjydkydkhdiydkyfiydiydiydiyfiydiydutdutduydiyduydiyfiyfy. cyici 8y 8*iy iyc 8 yyciyci iy yyu iy y uyi u ycyifyrjtsfeahfs vcxydjyc. jgdixjgxkgcxsjsjshsshdhshdhd dhshshd shshs gshsgss\nnsndbd\nndndndjdjdhhddhjjdddndbdbdbdhdbdhhd\nbsbsbd\nhsbshshdb\nnsbsn', 50, '[\"3\",\"4\",\"5\"]', 1, 1, 0, 0, NULL, 12, NULL, '2018-03-09 14:50:37'),
  592. (27, 13, 'asdf', 1, 1, 1, '[{\"image\":\"1520601801xwIP6yxNG1ZE0JbHQJKlzTiLpLLo6J.jpg\",\"is_cover\":\"1\"}]', 150, 1, 2, 1, NULL, 'Moga, Punjab 142001, India', 30.823011400000006, 75.17344709999999, NULL, 'jtsu5du5eu6ei6ri6rjgshtsjgdhtdjtdjt\nngdhtshtshtshtsht\nhfshtshtsjtsngdjydhtsjtsjydiydi6r', 23, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL),
  593. (28, 13, 'asdf', 1, 1, 1, '[{\"image\":\"1520601801xwIP6yxNG1ZE0JbHQJKlzTiLpLLo6J.jpg\",\"is_cover\":\"1\"}]', 150, 1, 2, 1, NULL, 'Moga, Punjab 142001, India', 30.823011400000006, 75.17344709999999, NULL, 'jtsu5du5eu6ei6ri6rjgshtsjgdhtdjtdjt\nngdhtshtshtshtsht\nhfshtshtsjtsngdjydhtsjtsjydiydi6r', 23, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL),
  594. (29, 13, 'asdf', 1, 1, 1, '[{\"image\":\"1520601801xwIP6yxNG1ZE0JbHQJKlzTiLpLLo6J.jpg\",\"is_cover\":\"1\"}]', 150, 1, 2, 1, NULL, 'Moga, Punjab 142001, India', 30.823011400000006, 75.17344709999999, NULL, 'jtsu5du5eu6ei6ri6rjgshtsjgdhtdjtdjt\nngdhtshtshtshtsht\nhfshtshtsjtsngdjydhtsjtsjydiydi6r', 23, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL),
  595. (30, 13, 'asdf', 1, 1, 1, '[{\"image\":\"1520601801xwIP6yxNG1ZE0JbHQJKlzTiLpLLo6J.jpg\",\"is_cover\":\"1\"}]', 150, 1, 2, 1, NULL, 'Moga, Punjab 142001, India', 30.823011400000006, 75.17344709999999, NULL, 'jtsu5du5eu6ei6ri6rjgshtsjgdhtdjtdjt\nngdhtshtshtshtsht\nhfshtshtsjtsngdjydhtsjtsjydiydi6r', 23, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL),
  596. (31, 13, 'asdf', 1, 1, 1, '[{\"image\":\"1520601801xwIP6yxNG1ZE0JbHQJKlzTiLpLLo6J.jpg\",\"is_cover\":\"1\"}]', 150, 1, 2, 1, NULL, 'Moga, Punjab 142001, India', 30.823011400000006, 75.17344709999999, NULL, 'jtsu5du5eu6ei6ri6rjgshtsjgdhtdjtdjt\nngdhtshtshtshtsht\nhfshtshtsjtsngdjydhtsjtsjydiydi6r', 23, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL),
  597. (32, 11, 'vjdsff', 1, 1, 5, '[{\"image\":\"1520601929io7noiUgtDIkEkBYsF2DxqfUsVira8.jpg\",\"is_cover\":\"1\"},{\"image\":\"1520601935fD75Kv7CYhjoVi7vH76Hfg0RgkIUyn.jpg\",\"is_cover\":\"0\"}]', 8888, 1, 1, 2, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'chgxxxz', 1234, '[\"2\",\"4\",\"5\"]', 1, 0, 0, 0, 1, 2, NULL, '2018-03-14 11:21:17'),
  598. (33, 13, '120', 1, 1, 1, '[{\"image\":\"1520601945lzJ1refNVAIuacPzXQzF2zBrRgu4Pf.jpg\",\"is_cover\":\"1\"}]', 150, 0, 2, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'fhgg', 5, '[\"2\",\"3\",\"4\"]', 1, 0, 1, 0, NULL, 12, NULL, '2018-03-09 14:00:47'),
  599. (34, 13, 'cookies', 1, 1, 1, '[{\"image\":\"1520605183YmGuUYGxsDSZYleY494nXj2w9rNnLl.jpg\",\"is_cover\":\"1\"}]', 150, 1, 1, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'ababa', 5, '', 1, 1, 0, 1, NULL, 19, NULL, '2018-03-17 05:24:07'),
  600. (35, 13, 'cookies', 1, 1, 1, '[{\"image\":\"1520605183YmGuUYGxsDSZYleY494nXj2w9rNnLl.jpg\",\"is_cover\":\"1\"}]', 150, 1, 1, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'ababa', 5, '', 1, 1, 0, 1, NULL, NULL, NULL, NULL),
  601. (36, 13, 'cookies', 1, 1, 1, '[{\"image\":\"1520605183YmGuUYGxsDSZYleY494nXj2w9rNnLl.jpg\",\"is_cover\":\"1\"}]', 150, 1, 1, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'ababa', 5, '[\"4\",\"3\",\"2\"]', 1, 1, 0, 1, NULL, 12, NULL, '2018-03-09 14:49:04'),
  602. (37, 13, 'test21', 1, 1, 1, '[{\"image\":\"1520831109NMi3j9iHPNFLl8AzcZaBtUmHbO1Ssf.jpg\",\"is_cover\":\"1\"}]', 150, 1, 1, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'kudjydjtdutd', 24, '[\"3\"]', 1, 1, 0, 1, 3, 19, NULL, '2018-03-17 05:13:00'),
  603. (38, 1, 'test 123 :', 1, 1, 1, '[]', 100, 1, 1, 1, NULL, 'Bhopal, Madhya Pradesh, India', 23.2599333, 77.412615, NULL, 'jshssbsvbsbsvzbssbsbsb', 15, '[\"2\",\"1\",\"3\"]', 1, 1, 0, 1, NULL, NULL, NULL, NULL),
  604. (39, 1, 'yipii', 1, 1, 1, '[{\"image\":\"1521011010ORCeZtGpw7VHVMgFlQ6OkSCBsxGToh.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521011032h507S3VMCJIVL1MW9QQbHZGBIA1iP0.jpg\",\"is_cover\":\"0\"},{\"image\":\"15210110496fJjGnw2GodWgQgWyK4kcdkWqZRRCc.jpg\",\"is_cover\":\"0\"}]', 1200, 1, 2, 1, NULL, 'Bhopal, Madhya Pradesh, India', 23.2599333, 77.412615, NULL, 'emekekkenennsjejejejejejzbsjjahahshshzhzggffgtfttgsdddd d d d d d d d d d d d d. d d d dzhzhs-VV:vdZdbd z : sjs sus shss svud sjeehydbvxj v jhchvjhckycy n jtdmhvngckyfjbv nvxjgxjgckhcifkckhckyfkhfiyf vviciyciyfv. iviycuyciyciyc vfi6fiyfiyc iuciyf kyciyf. diydiyditditdjhxiyjtxjt kfhfitfyjtxjtxut jciyfiyfy jhcjhciyfkyc', 15, '[\"2\",\"3\",\"4\"]', 1, 1, 0, 0, 1, 2, NULL, '2018-03-14 09:19:28'),
  605. (40, 1, 'service test 01', 3, 21, 28, '[{\"image\":\"1521020486Bt4FRvxSw831mTPPRTgURW4Wheq4XW.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521020507hY5Ai3jrcK7ZvdwrVmorQLbcOZ4M6C.jpg\",\"is_cover\":\"0\"},{\"image\":\"1521020537lAJbTATRyIiYHBC9DABdaCHi95w1ar.jpg\",\"is_cover\":\"0\"},{\"image\":\"1521020549ABcxI273NNzBO0yVWWXneMeRYj3GsW.jpg\",\"is_cover\":\"0\"},{\"image\":\"15210205679jJXldBv46U8nU0cpBSshRvZcLOt6D.jpg\",\"is_cover\":\"0\"}]', 180, 1, NULL, 0, NULL, 'Delhi, India', 28.686273800000006, 77.2217831, 1, 'hshshsnsnsdbshshsgsGsggssbzbbss s oigiyfiydiyciyxiydiyckhdkyfoufkgxkhcmhcjgdjfzhfzugxjxhfxjgxuxiycucihciycgggfffff\nfff.fff nfjf\niydjtdiyfi6f\nxugxifiyfiy', 12, '[\"3\",\"2\",\"4\",\"5\"]', 1, 1, 0, 1, NULL, NULL, NULL, NULL),
  606. (41, 1, 'cmt 123', 3, 19, 26, '[{\"image\":\"1521022097BHBGc8LvAp5iU2rM6vLVbAL7J4RSBM.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521022114aKTxR7AX8IKG5jd3AQfYbbWIgiQm9U.jpg\",\"is_cover\":\"0\"}]', 160, 1, NULL, 0, NULL, 'Delhi, India', 28.686273800000006, 77.2217831, 0, 'jensbsbsbbsbsbsbsbsbs dd\ndfff\nffffff\nhhdhshsgsghs\nhdhhshsgs\nhsnhsbsbsgs\nhsbsbbs\nhzhsb', 120, '[\"3\",\"4\",\"2\"]', 1, 1, 0, 1, 1, NULL, NULL, '2018-03-14 10:11:28'),
  607. (42, 1, 'sup test 01', 2, 10, 17, '[{\"image\":\"1521023832yxljCRebRkH2tDzAb9P8A8x6XYhftB.jpg\",\"is_cover\":\"1\"}]', 150, 1, NULL, 0, 3, 'Delhi, India', 28.686273800000006, 77.2217831, NULL, 'jsjshhshwsnsnsnns', 15, '[\"3\",\"4\"]', 1, 1, 0, 1, NULL, NULL, NULL, NULL),
  608. (43, 2, 'New Sold Test', 1, 1, 1, '[{\"image\":\"1521107262OPzP3nraG9jCkGoMGpB42NEm8rKpVM.jpg\",\"is_cover\":\"0\"},{\"image\":\"1521107273c3QtT12ywzR3VcljAqOTov4MDFdLnE.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521107282Oyvv4t8UX5iKQoOQA0ldKq6MmKN0wr.jpg\",\"is_cover\":\"0\"}]', 220, 0, 1, 2, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'hello sold test\nnew to test\nlet\'s try this', 123, '[\"2\",\"4\",\"3\"]', 1, 1, 1, 1, 1, 11, NULL, '2018-03-15 09:50:26'),
  609. (44, 11, 'From sahil', 1, 4, 11, '[{\"image\":\"152110775168RYOXNvtjdR8qL8ALRxtEI8jsXEvO.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521107776Xyc6uENp1YB8IKJRbQzPOAHa2AOTlv.jpg\",\"is_cover\":\"0\"}]', 120, 0, 2, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'zbbshshhdf\nnxndnd\ndnbdnd', 112, '[\"2\",\"3\",\"4\"]', 0, 1, 1, 0, NULL, 2, NULL, '2018-03-15 10:03:26'),
  610. (45, 18, 'test05', 1, 1, 1, '[{\"image\":\"1521129009JtcQZ6Aealz3kPM7aU1tlOtoKFNodS.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521129019lTA4yP8jvev7yFo4Zs9fIHzMyxW9qV.jpg\",\"is_cover\":\"0\"}]', 150, 1, 1, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'bsbsbsbhsvsvsbs shshhsdhhs', 150, '[\"3\",\"4\",\"5\"]', 1, 1, 0, 1, NULL, NULL, NULL, NULL),
  611. (46, 18, 'test 06', 1, 3, 10, '[{\"image\":\"1521174702X1eFYmAEU7NFPJi5zPkH8KooGWFWxF.jpg\",\"is_cover\":\"1\"}]', 155, 1, 1, 2, NULL, 'Chandigarh, India', 30.7333148, 76.7794179, NULL, 'jsnsnnbssnss\nsssss\nss', 158, '[\"3\",\"1\",\"2\",\"4\",\"5\"]', 1, 1, 0, 1, 1, NULL, NULL, '2018-03-16 04:55:40'),
  612. (47, 19, 'gsbvsvs', 1, 1, 1, '[{\"image\":\"1521193364EQnX6FFp44CkYz0bNWjE79MYPLShcs.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521193375dKgRnUDqb3hdYSDq5j4jSqVEc3QsA8.jpg\",\"is_cover\":\"0\"}]', 123, 0, 1, 2, NULL, 'Mohali Bypass, Phase 3B-2, Sector 60, Sahibzada Ajit Singh Nagar, Punjab, India', 30.7074632, 76.7155901, NULL, 'sbbsbsbbsbsbbd', 12, '[\"1\",\"5\"]', 1, 1, 1, 0, 1, NULL, NULL, '2018-03-16 10:17:02'),
  613. (48, 19, 'gshwhhsge', 1, 2, 9, '[{\"image\":\"1521195011PtMNcaiMUzlXLLHcqTYdGqzmTUOIfy.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521195019uyVcmxcDNNMWP48hLilaVMFrbn93Ic.jpg\",\"is_cover\":\"0\"}]', 4664848, 0, 1, 2, NULL, '241 S Moreno Dr, Beverly Hills, CA 90212, USA', 34.06146379999999, -118.41042499999999, NULL, 'vzvshjsbs\ndjdbhsje', 4522, '[\"4\",\"3\",\"2\"]', 1, 0, 1, 1, NULL, 13, NULL, '2018-03-17 06:26:38'),
  614. (49, 13, 'test 09', 1, 1, 1, '[{\"image\":\"15212799925MnWFBRNdSbDSXBX04gb21iDlBIM3l.jpg\",\"is_cover\":\"1\"}]', 158, 1, 1, 1, NULL, 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.71787259999999, NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 15, '[\"1\",\"2\",\"3\",\"4\",\"5\"]', 1, 1, 0, 1, 1, NULL, NULL, '2018-03-17 09:47:34'),
  615. (50, 19, 'Deep Link Post', 2, 11, 18, '[{\"image\":\"15212873515EL6hbR82txPvYo1w73egLGIxJAZ9T.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521287362K1mqLlO7rCz5YEmrBuC4UfzhXDs41R.jpg\",\"is_cover\":\"0\"}]', 2000, 0, NULL, 0, 1, 'Mohali Bypass, Phase 3B-2, Sector 60, Sahibzada Ajit Singh Nagar, Punjab, India', 30.7074632, 76.7155901, NULL, 'I m testing deep link.\nPlease dont angry me because i am frustrated already.\nSorry no content available', 12, '[\"1\",\"3\",\"5\"]', 1, 1, 1, 1, NULL, NULL, NULL, NULL),
  616. (51, 19, 'Deep link 3', 1, 21, 28, '[{\"image\":\"1521287718eeqGR7i96zU0hXWhYXTT4V4312vC6j.jpg\",\"is_cover\":\"0\"},{\"image\":\"1521287727oGyEXZO2qyaMTdA1oGRfGZHgqVPAJ7.jpg\",\"is_cover\":\"1\"},{\"image\":\"1521287739Fqj8brw6PbwOiN8XDi6ER1NWCHRspZ.jpg\",\"is_cover\":\"0\"}]', 2100, 0, 1, 2, NULL, 'Mohali Bypass, Phase 3B-2, Sector 60, Sahibzada Ajit Singh Nagar, Punjab, India', 30.7074632, 76.7155901, NULL, 'Check with you to see if it\'s working fine or not.', 123, '[\"5\",\"3\",\"1\"]', 1, 1, 1, 1, NULL, NULL, NULL, NULL);
  617.  
  618. -- --------------------------------------------------------
  619.  
  620. --
  621. -- Table structure for table `praises`
  622. --
  623.  
  624. CREATE TABLE `praises` (
  625. `id` int(11) NOT NULL,
  626. `user_id_1` int(11) NOT NULL,
  627. `user_id_2` int(11) NOT NULL,
  628. `post_id` int(11) NOT NULL,
  629. `praise` varchar(128) NOT NULL,
  630. `created_at` timestamp NULL DEFAULT NULL,
  631. `updated_at` timestamp NULL DEFAULT NULL
  632. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  633.  
  634. --
  635. -- Dumping data for table `praises`
  636. --
  637.  
  638. INSERT INTO `praises` (`id`, `user_id_1`, `user_id_2`, `post_id`, `praise`, `created_at`, `updated_at`) VALUES
  639. (1, 11, 11, 23, '[\"2\",\"5\"]', '2018-03-09 11:14:32', '2018-03-09 11:14:32'),
  640. (2, 11, 11, 22, '[\"1\",\"5\"]', '2018-03-09 13:06:26', '2018-03-09 13:08:44'),
  641. (3, 1, 1, 39, '[\"2\",\"3\",\"4\"]', '2018-03-14 09:19:52', '2018-03-14 09:19:52'),
  642. (4, 2, 2, 15, '[\"1\",\"2\",\"6\"]', '2018-03-14 11:11:11', '2018-03-14 11:11:11'),
  643. (5, 11, 11, 32, '[\"1\",\"2\",\"3\"]', '2018-03-14 11:23:24', '2018-03-14 11:23:24'),
  644. (6, 11, 2, 43, '[\"2\",\"5\",\"6\"]', '2018-03-15 09:50:43', '2018-03-15 09:50:43'),
  645. (7, 19, 13, 37, '[\"1\",\"2\",\"5\"]', '2018-03-17 05:13:12', '2018-03-17 05:13:12'),
  646. (8, 19, 13, 34, '[\"1\",\"2\",\"3\",\"4\"]', '2018-03-17 05:25:10', '2018-03-17 07:05:15');
  647.  
  648. -- --------------------------------------------------------
  649.  
  650. --
  651. -- Table structure for table `promotions`
  652. --
  653.  
  654. CREATE TABLE `promotions` (
  655. `id` int(11) NOT NULL,
  656. `title` varchar(128) NOT NULL,
  657. `image` varchar(255) DEFAULT NULL,
  658. `created_at` timestamp NULL DEFAULT NULL,
  659. `updated_at` timestamp NULL DEFAULT NULL
  660. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  661.  
  662. --
  663. -- Dumping data for table `promotions`
  664. --
  665.  
  666. INSERT INTO `promotions` (`id`, `title`, `image`, `created_at`, `updated_at`) VALUES
  667. (2, 'BaLzwQJtNF', 'img6.jpg', '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  668. (3, 'lxzZvEyCim', 'img3.jpg', '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  669. (4, 'eRk0ppUipt', 'img6.jpg', '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  670. (6, 'z2qIJxn2vP', 'img8.jpg', '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  671. (7, 'sZ3mQcSAMS', 'img4.jpg', '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  672. (8, 'lLus606B4D', 'img6.jpg', '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  673. (9, 'i2T23SL2JL', '1521200376natQ83PZJt8xlIQf05Hli1olGaG8C8.jpg', '2018-03-08 13:09:06', '2018-03-16 11:39:36'),
  674. (10, '58BZvndN8S', 'img7.jpg', '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  675. (11, 'fsdgtsdg', '1521116413qRlvPdZTeme8pHlRQwfKGHShAOIExA.jpg', '2018-03-15 12:20:13', '2018-03-15 12:20:13');
  676.  
  677. -- --------------------------------------------------------
  678.  
  679. --
  680. -- Table structure for table `report_posts`
  681. --
  682.  
  683. CREATE TABLE `report_posts` (
  684. `id` int(11) NOT NULL,
  685. `user_id` int(11) NOT NULL,
  686. `post_id` int(11) NOT NULL,
  687. `created_at` timestamp NULL DEFAULT NULL,
  688. `updated_at` timestamp NULL DEFAULT NULL
  689. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  690.  
  691. --
  692. -- Dumping data for table `report_posts`
  693. --
  694.  
  695. INSERT INTO `report_posts` (`id`, `user_id`, `post_id`, `created_at`, `updated_at`) VALUES
  696. (1, 12, 26, '2018-03-09 13:35:39', '2018-03-09 13:35:39'),
  697. (2, 13, 8, '2018-03-17 04:59:11', '2018-03-17 04:59:11');
  698.  
  699. -- --------------------------------------------------------
  700.  
  701. --
  702. -- Table structure for table `report_users`
  703. --
  704.  
  705. CREATE TABLE `report_users` (
  706. `id` int(11) NOT NULL,
  707. `user_id_1` int(11) NOT NULL,
  708. `user_id_2` int(11) NOT NULL,
  709. `created_at` timestamp NULL DEFAULT NULL,
  710. `updated_at` timestamp NULL DEFAULT NULL
  711. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  712.  
  713. --
  714. -- Dumping data for table `report_users`
  715. --
  716.  
  717. INSERT INTO `report_users` (`id`, `user_id_1`, `user_id_2`, `created_at`, `updated_at`) VALUES
  718. (1, 2, 1, '2018-03-14 09:14:58', '2018-03-14 09:14:58'),
  719. (2, 2, 18, '2018-03-16 05:11:42', '2018-03-16 05:11:42'),
  720. (3, 17, 13, '2018-03-16 13:28:18', '2018-03-16 13:28:18');
  721.  
  722. -- --------------------------------------------------------
  723.  
  724. --
  725. -- Table structure for table `sub_categories`
  726. --
  727.  
  728. CREATE TABLE `sub_categories` (
  729. `id` int(11) NOT NULL,
  730. `category_id` int(11) NOT NULL,
  731. `name` varchar(128) NOT NULL,
  732. `created_at` timestamp NULL DEFAULT NULL,
  733. `updated_at` timestamp NULL DEFAULT NULL
  734. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  735.  
  736. --
  737. -- Dumping data for table `sub_categories`
  738. --
  739.  
  740. INSERT INTO `sub_categories` (`id`, `category_id`, `name`, `created_at`, `updated_at`) VALUES
  741. (1, 1, 'Biscuits', NULL, NULL),
  742. (2, 1, 'Bagels', NULL, NULL),
  743. (3, 1, 'Bars & squares', NULL, NULL),
  744. (4, 1, 'Biscottis', NULL, NULL),
  745. (5, 1, 'Breads', NULL, NULL),
  746. (6, 1, 'Brownies', NULL, NULL),
  747. (7, 1, 'Cake pops', NULL, NULL),
  748. (8, 1, 'CakesCookies', NULL, NULL),
  749. (9, 2, 'Brittles', NULL, NULL),
  750. (10, 3, 'Honey', NULL, NULL),
  751. (11, 4, 'Cereals', NULL, NULL),
  752. (12, 5, 'Churros', NULL, NULL),
  753. (13, 6, 'Fruit butters', NULL, NULL),
  754. (14, 7, 'Candied apples', NULL, NULL),
  755. (15, 8, 'Eggs', NULL, NULL),
  756. (16, 9, 'Body', NULL, NULL),
  757. (17, 10, 'Bags', NULL, NULL),
  758. (18, 11, 'Candles', NULL, NULL),
  759. (19, 12, 'Bakeware sets', NULL, NULL),
  760. (20, 13, 'Cooking Utensils', NULL, NULL),
  761. (21, 14, 'Baby tableware', NULL, NULL),
  762. (22, 15, 'Aprons', NULL, NULL),
  763. (23, 16, 'Blenders', NULL, NULL),
  764. (24, 17, 'Coolers', NULL, NULL),
  765. (25, 18, 'Cooking equipment', NULL, NULL),
  766. (26, 19, 'Adult classes', NULL, NULL),
  767. (27, 20, 'Appliances & tools', NULL, NULL),
  768. (28, 21, 'Catering', NULL, NULL);
  769.  
  770. -- --------------------------------------------------------
  771.  
  772. --
  773. -- Table structure for table `tags`
  774. --
  775.  
  776. CREATE TABLE `tags` (
  777. `id` int(11) NOT NULL,
  778. `name` varchar(128) NOT NULL,
  779. `created_at` timestamp NULL DEFAULT NULL,
  780. `updated_at` timestamp NULL DEFAULT NULL
  781. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  782.  
  783. --
  784. -- Dumping data for table `tags`
  785. --
  786.  
  787. INSERT INTO `tags` (`id`, `name`, `created_at`, `updated_at`) VALUES
  788. (1, 'Kosher', NULL, NULL),
  789. (2, 'Halal', NULL, NULL),
  790. (3, 'Dairy Free', NULL, NULL),
  791. (4, 'Gluten Free', NULL, NULL),
  792. (5, 'Organic', NULL, NULL);
  793.  
  794. -- --------------------------------------------------------
  795.  
  796. --
  797. -- Table structure for table `users`
  798. --
  799.  
  800. CREATE TABLE `users` (
  801. `id` int(11) NOT NULL,
  802. `email` varchar(255) DEFAULT NULL,
  803. `password` varchar(255) DEFAULT NULL,
  804. `name` varchar(128) DEFAULT NULL,
  805. `image` varchar(255) DEFAULT NULL,
  806. `shop_name` varchar(128) DEFAULT NULL,
  807. `shop_image` varchar(255) DEFAULT NULL,
  808. `location` varchar(128) DEFAULT NULL,
  809. `lat` double DEFAULT NULL,
  810. `lng` double DEFAULT NULL,
  811. `description` text,
  812. `fb_id` varchar(255) DEFAULT NULL,
  813. `google_id` varchar(255) DEFAULT NULL,
  814. `fb_connect` tinyint(1) NOT NULL,
  815. `google_connect` tinyint(1) NOT NULL,
  816. `id_type` tinyint(4) DEFAULT NULL COMMENT '1 - food handler id no, 2 -business license no',
  817. `id_no` varchar(128) DEFAULT NULL,
  818. `is_insurance` tinyint(4) DEFAULT NULL COMMENT '0 - No, 1 - Yes',
  819. `deleted_at` timestamp NULL DEFAULT NULL,
  820. `created_at` timestamp NULL DEFAULT NULL,
  821. `updated_at` timestamp NULL DEFAULT NULL
  822. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  823.  
  824. --
  825. -- Dumping data for table `users`
  826. --
  827.  
  828. INSERT INTO `users` (`id`, `email`, `password`, `name`, `image`, `shop_name`, `shop_image`, `location`, `lat`, `lng`, `description`, `fb_id`, `google_id`, `fb_connect`, `google_connect`, `id_type`, `id_no`, `is_insurance`, `deleted_at`, `created_at`, `updated_at`) VALUES
  829. (1, 'john1@gmail.com', '$2y$10$GcYJvg/o.xkC/9x36ESr4u0fntuqpBLmHaiU6TKBvXKNMBtPVCTsq', 'ekta', '1521014703Iqc2E9bdbYvY7kj4wOVa9sgjdsLaV1.jpg', 'John Shop 1', 'img7.jpg', 'Chandigarh', 30.733315, 76.779418, '4YUVD29NR6UiAmRU6CuZ7CnZ2UujRE0HhI5QHIFGGQ9bQqhjjgc54VY7oLM23rqtQEkuITaR5IdQV9ep HGPOvMEYwyzg4kOH2HigOJ5fJPmSqxbIBXBonWXtcBdHl6Qr2gdvvRFjTpkCVrpQVHmMSWQC56R3jJAG0NGVyneNw1jOavC6fKD5', NULL, NULL, 0, 0, 1, '5GwRc', 0, NULL, '2018-03-08 13:09:05', '2018-03-14 09:35:58'),
  830. (2, 'john2@gmail.com', '$2y$10$YTm11M.unkRJ6mJ6.k91p.Js9VQyMbW5lLV8Omvoc8aFcPSF6WYv2', 'John2', '1521006751Z8YzzpWihaQwqmwmXoeqkdcDJ08ahl.jpg', 'John Shop 2', 'img1.jpg', 'Chandigarh', 30.733315, 76.779418, 'v1o3bgbmyLNukqjZaWrZlpt7hJj73qI6rdB9M0nbC3QvE2xAOpTLkCFVxLLFml2hQJKb7cvEC8QUSOvQ 2RLfkZpomw9ouA4dZI0lgu1Cr9cFosLSu5AvTGEhOla5d29wQboV3fz6TucUE0zYdzXcrQHRUBRtsynFFFR8qcZrfHfAW1TKnTXfhdbdbdbddbdvxb', NULL, NULL, 0, 0, 2, '838HGGV3828HG', 1, NULL, '2018-03-08 13:09:05', '2018-03-14 07:25:42'),
  831. (3, 'john3@gmail.com', '$2y$10$FgIs6/90QU5v1LqXE/dWiuXaivBhRJDicll1YYg88n/T76p.5V7aO', 'John3', 'user-img2.jpg', 'John Shop 3', 'img2.jpg', 'Chandigarh', 30.733315, 76.779418, 'LFaYfxHwfNHw6KbH1n0y3hKMS0xUi02xzIPJspEkeVoW4MU27TXnyP7gLA5kceQGUc468kkfolDqiUQH T0zgERPD3gw2PQWKqFRfXdtnj68qANEPUBOO5Nwbf38uWo2x2qLlGZtHA0JIk31fRBJyNqN8zZcfywRmBNtf3iuup04Bdm7Q6CmW', NULL, NULL, 1, 1, 1, 'sjJbx', 1, NULL, '2018-03-08 13:09:05', '2018-03-16 12:57:06'),
  832. (4, 'john4@gmail.com', '$2y$10$Hc5ydw4TJgRK8yw3.jXsfe3.4xZxAgPtMpGUQqF0DLWo01EGEoeq.', 'John4', 'user-img6.jpg', 'John Shop 4', 'img5.jpg', 'Chandigarh', 30.733315, 76.779418, 'X1p3yqcHtteVg79BGZOcDfJG9FfExaqiheSONDlEasTQf0pjjXuFT1FXiuTQf4bGLk04ExAEfUMTgWC9 hvcqq7pLHC1LykhDwlwV2hsTV3ZILAZ5c0tCRn5PwCBXUNcRoZ5xCBPrGbV6CQtdUDYIqmX7vjblx0cCnoXcWSZtL43Upt87kPs9', NULL, NULL, 0, 0, 2, 'Meefa', 1, NULL, '2018-03-08 13:09:05', '2018-03-08 13:09:05'),
  833. (5, 'john5@gmail.com', '$2y$10$tDyCw5cBtgtgHRFUtn219en1LBOkVOX1BkajlQm9lfF0heYxlD9TK', 'John5', 'user-img6.jpg', 'John Shop 5', 'img6.jpg', 'Chandigarh', 30.733315, 76.779418, '4Cn7UKmn4gtEnDGugnMy3YfDXibC0apXt7y71JaI9co2TEzWEipDiWnbPOyCZzoP8GaEE65tTmvRJ5ha u7W6t9Et4sfo6lCb6zmRnPZwEhoG6vWKLr3dNlqawVKfu9wm6B8jWN7GDnKSS4jCHT12wJbXkR24Ve1b4FJyQVZ6XPiBrPeKfJFj', NULL, NULL, 0, 0, 2, 'DxKAL', 1, '2018-03-20 06:10:37', '2018-03-08 13:09:05', '2018-03-20 06:10:37'),
  834. (6, 'john6@gmail.com', '$2y$10$fegWs69vDrDuIXN0IX2NuudpgSBjLXSSxJdomv98KdrPcZTucqYN6', 'John6', 'user-img3.jpg', 'John Shop 6', 'img5.jpg', 'Chandigarh', 30.733315, 76.779418, 'qFC8ZkSYO61FPDtoKXGfnNuYZdQXBaLU0mpTByOJW0VLNamjgJZbUabrLrUdRYuAoF3TsP7OMOy4pPug dvC7i8mpFN5wskmrC7oywHHKnY4BEN1r4WU2TaZ9PjeHSqbPLbqdElYW4FSe1LErY2YXyFjGzqnzQGIyS6RNvYfGsbfUvzMUhtDa', NULL, NULL, 0, 0, 1, 'AyqLY', 1, NULL, '2018-03-08 13:09:05', '2018-03-08 13:09:05'),
  835. (7, 'john7@gmail.com', '$2y$10$cjpac39jnodWTZhyVMnGeuZHNCy/bcxVOLA.N/b94y0g9xZq0E8Y6', 'John7', 'user-img6.jpg', 'John Shop 7', 'img2.jpg', 'Chandigarh', 30.733315, 76.779418, 'ymwFF7RUVhFOqEt8qWfGGxXnk16EFUf2xzM8MKeZRqFaCPK5ww2P6Y4RopUEhF1RAnms322OXxOK05zf PjMfBVLp0Fz3WeltKOSEE74sUbz1F4OVPI2k8fvcy7mAUhfD49xAPi7sc8uzOqVp2hCc9sViasb9YF8zTP3msiPKTf3HAUnyIo9J', NULL, NULL, 0, 0, 1, 'py1l2', 0, NULL, '2018-03-08 13:09:05', '2018-03-08 13:09:05'),
  836. (8, 'john8@gmail.com', '$2y$10$x89synmQhsPrnhexatnjZOsp8bxVoCLbXZ7r4/mSoTFwmA3DGED/u', 'John8', 'user-img6.jpg', 'John Shop 8', 'img4.jpg', 'Chandigarh', 30.733315, 76.779418, 'g9fr4cgZE7RNTemvmdUyLb0tKLIYFEPOUaZbcYFKqiXES6m0ZiZ2gZf4xwE3IceJvro78PIGv38Rvn6f v1F5u06xV9ai8UutyWiRSzPbaLjXWIoSs4CBR9f6j3p0UoDynmetaKzHHZwBcueslbioiCS6884CMLgd6MjOAQmIPBEpmiVLHChh', NULL, NULL, 0, 0, 2, 'uVTOn', 1, NULL, '2018-03-08 13:09:05', '2018-03-08 13:09:05'),
  837. (9, 'john9@gmail.com', '$2y$10$oH3A3mdl5MNyth6tEvgtpeFfFM3ZSSWmU4Rfn3vEeLnpd/3.wjqxm', 'John9', 'user-img10.jpg', 'John Shop 9', 'img8.jpg', 'Chandigarh', 30.733315, 76.779418, 'spyfMkX0k350wWt2rOYrBLJ4M89Ku6zCsQJ76guduJ5PyZey77QHE3lsIzBa5QqMIiJ2nBqzEMSD6ZHa GuSnhPrLrvgG9aNgWkqAO7ChTQupiRVvSY72PYpQss2AAewomoL75GpHx2MTz1eQzxr5d0MnyFITgefgi9JG9TWxPbIsHs8cLb4m', NULL, NULL, 0, 0, 2, 'Uik58', 1, NULL, '2018-03-08 13:09:05', '2018-03-08 13:09:05'),
  838. (10, 'john10@gmail.com', '$2y$10$BhIv6fR0XnH0INkINFW6l.EPh1n5H9llN/NCEqHG6tuUJXBYPEYJ2', 'John10', 'user-img9.jpg', 'John Shop 10', 'img6.jpg', 'Chandigarh', 30.733315, 76.779418, 'ttEIIOqqlJudhkhDOzYny8J0La4BgAPuvBWPNHLNW8nnLa5BNlI4cTbVDQe0yqrjCP2pEbMLw9RvnLA6 w6B8aTgBzAGfawpYhN9cu3H2BwvnPTrydB7ivuxRhHllVYDvGyHBA0WGuO27TFOV5xFcFSNZ5MSeYNS3A21FFuJruLhxcbFny1bM', NULL, NULL, 0, 0, 1, '1xvRL', 1, NULL, '2018-03-08 13:09:05', '2018-03-08 13:09:05'),
  839. (11, 'cu.uicsahil8138@outlook.com', NULL, 'Sahil Kumar', 'http://graph.facebook.com/383783015426853/picture?type=large', NULL, '1520515578EgXHZRejs1ayo5poRg8GqhC9KA53H2.jpg', 'Sahibzada Ajit Singh Nagar, Chandigarh, India', 30.7046486, 76.7178726, 'Devil works for none . No one make me work until i don\'t want to do that please make it sur if you want to make me work then ready to convince me otherwise forget about work.\nI dont want to work right now. I m not in working mood or mode.', '383783015426853', NULL, 0, 0, 0, NULL, 0, NULL, '2018-03-08 13:10:41', '2018-03-13 07:36:25'),
  840. (12, 'sahiltest@gmail.com', '$2y$10$tPVmQ0V4o2wgVgiaNmOnmOC64xHNn7cpv0T04Sz5M1xDOelIW8ZjG', 'Test Sahil', 'http://18.219.42.101:8001/photos/thumb/1520575957j6EvmHfAQDPlXDaREt0nQk3TfLMyxO.jpg', 'Test Shop', 'http://18.219.42.101:8001/photos/thumb/15205759339DsP3EvC8qSHIMd4pAwcEez5p9l8UV.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '2018-03-09 06:13:12', '2018-03-09 06:13:12'),
  841. (13, 'ektameena23@gmail.com', NULL, 'Ekta Meena', 'http://graph.facebook.com/1593431257430689/picture?type=large', NULL, '', NULL, 0, 0, NULL, '1593431257430689', NULL, 1, 1, 0, NULL, 1, NULL, '2018-03-09 09:46:36', '2018-03-19 13:11:31'),
  842. (14, 'ekta.henceforth@gmail.com', '$2y$10$tNELIuhak.33QXQhrosDMeRHbHpythQKZQ9/8BmLIw7HHdDoHPU3K', 'ekta', '1520589156a2psDiHb2KMUAN1shnR4MoYD9Ly2vq.jpg', 'asdf', '1520589227q9ZMT0EWUEdtm9wpBXbv1DtJ8Oqy5n.jpg', 'Chandigarh, India', 30.7333148, 76.7794179, 'hjsjs shs shs shs shsvshckzcuCpqbdpoarhfpiqhdcpiabdpf8hwdpihwpdivfp8qdhfp8qhs0f8hqs08fhqp8shf08qshf08qwhr0qher97gqw9r7hwe97fhw08dh0q8rhf818er971egsbsbbsbsbs shhbsbshhshdysgddgydgdgdgshhsgsgsgssgyahahshshshshsgsgsgsgsggsgsgsgsgsgsgsshsgs', NULL, NULL, 0, 0, 1, 'BBA12345', 0, '2018-03-09 11:02:32', '2018-03-09 09:48:13', '2018-03-09 11:02:32'),
  843. (15, 'test@test.com', '$2y$10$mdRAKLTZM/v9pETIgrp8ZusoX4ssX9UWum5R5CSJU6ViGRapWip32', 'test', '/tmp/phpcZ5Iwa', 'bankai', '/tmp/phpERtEcE', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '2018-03-13 05:51:39', '2018-03-13 05:51:39'),
  844. (16, 'karivata@gmail.com', '$2y$10$b0x.d4cDX5qNgDXGK0L9H.FzGi3K7EyehVxJoZdFN4ZXtmWL7k74W', 'kavi', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '2018-03-13 16:34:52', '2018-03-13 16:34:52'),
  845. (17, 'sahil002.henceforth@gmail.com', '$2y$10$BLx4IGUvr11rst8tHYxk4ui.8Ed5vIkJe9gJoZz5VddtlZ67sIGvC', 'Sahil Kumar', 'https://lh4.googleusercontent.com/-T-I4Sf08e7Q/AAAAAAAAAAI/AAAAAAAAAIg/vUFuNmrr80A/photo.jpg', 'ToNight Shop', '1521175402JzdqWGpPzJCGZqYnuZUP6hVkJ0wxXU.jpg', NULL, 0, 0, NULL, NULL, '114080307219038560487', 0, 0, 0, NULL, 0, NULL, '2018-03-14 06:00:13', '2018-03-16 13:24:11'),
  846. (18, 'test01@gmail.com', '$2y$10$DBrSW104wqYG1Cs.28vq2ey6W.oTwLGl9Rm5uKoc3kUpo6RgVJ9ii', 'test 01', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '2018-03-15 15:49:19', '2018-03-15 15:49:19'),
  847. (19, 'kumarrohit.sharmasahil002@gmail.com', NULL, 'Sahil Kumar Sharma', 'http://graph.facebook.com/1268110923290859/picture?type=large', NULL, '', NULL, 0, 0, NULL, '1268110923290859', NULL, 1, 1, 0, NULL, 0, NULL, '2018-03-16 05:54:33', '2018-03-17 09:39:48'),
  848. (20, 'harmanpreet.saini@hotmail.com', '$2y$10$egcvFBGtAF98frEieLwNpOaOPGD6kaH8B8EZtDqmiz.W3/xyf9DVK', 'Harman Preet', 'http://graph.facebook.com/1848082518543500/picture?type=large', NULL, NULL, NULL, NULL, NULL, NULL, '1848082518543500', NULL, 0, 0, NULL, NULL, NULL, NULL, '2018-03-16 14:34:22', '2018-03-19 12:09:02'),
  849. (21, NULL, NULL, 'asdf', '', NULL, NULL, NULL, NULL, NULL, NULL, 'qwer1234', NULL, 0, 0, NULL, NULL, NULL, NULL, '2018-03-17 07:36:39', '2018-03-17 07:36:39');
  850.  
  851. -- --------------------------------------------------------
  852.  
  853. --
  854. -- Table structure for table `user_devices`
  855. --
  856.  
  857. CREATE TABLE `user_devices` (
  858. `id` int(11) NOT NULL,
  859. `user_id` int(11) NOT NULL,
  860. `access_token` varchar(255) NOT NULL,
  861. `fcm_id` varchar(255) DEFAULT NULL,
  862. `device_type` tinyint(4) NOT NULL COMMENT '0 - Web, 1 - iOS, 2 - Android',
  863. `is_push_notif` tinyint(1) NOT NULL DEFAULT '1',
  864. `is_email_notif` tinyint(1) NOT NULL DEFAULT '1',
  865. `app_version` float NOT NULL,
  866. `ip` varchar(128) DEFAULT NULL,
  867. `last_login` datetime DEFAULT NULL,
  868. `logout_at` datetime DEFAULT NULL,
  869. `created_at` timestamp NULL DEFAULT NULL,
  870. `updated_at` timestamp NULL DEFAULT NULL
  871. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  872.  
  873. --
  874. -- Dumping data for table `user_devices`
  875. --
  876.  
  877. INSERT INTO `user_devices` (`id`, `user_id`, `access_token`, `fcm_id`, `device_type`, `is_push_notif`, `is_email_notif`, `app_version`, `ip`, `last_login`, `logout_at`, `created_at`, `updated_at`) VALUES
  878. (1, 4, 'E6qmmnzYFQezgWziFrMRQnrIOjV2JQ2hvhTHkHQdihU6cCuUGnk5IvNlynVvPI0R3iy1iy7ceYF3Mz6TAOSjiJ8Dr3WItWJ1xKBv', 'asdf1', 0, 1, 1, 1, '127.0.0.1', '2018-03-20 12:11:30', NULL, '2018-03-20 06:41:30', '2018-04-12 07:02:22');
  879.  
  880. -- --------------------------------------------------------
  881.  
  882. --
  883. -- Table structure for table `views`
  884. --
  885.  
  886. CREATE TABLE `views` (
  887. `id` int(11) NOT NULL,
  888. `user_id` int(11) NOT NULL,
  889. `post_id` int(11) NOT NULL,
  890. `created_at` timestamp NULL DEFAULT NULL,
  891. `updated_at` timestamp NULL DEFAULT NULL
  892. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  893.  
  894. --
  895. -- Dumping data for table `views`
  896. --
  897.  
  898. INSERT INTO `views` (`id`, `user_id`, `post_id`, `created_at`, `updated_at`) VALUES
  899. (1, 4, 15, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  900. (2, 8, 11, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  901. (3, 4, 19, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  902. (4, 3, 17, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  903. (5, 5, 6, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  904. (6, 8, 13, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  905. (7, 9, 5, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  906. (8, 4, 4, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  907. (9, 7, 3, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  908. (10, 10, 14, '2018-03-08 13:09:06', '2018-03-08 13:09:06'),
  909. (11, 11, 37, '2018-03-15 13:11:57', '2018-03-15 13:11:57'),
  910. (12, 11, 17, '2018-03-15 13:12:23', '2018-03-15 13:12:23'),
  911. (13, 11, 4, '2018-03-15 13:19:37', '2018-03-15 13:19:37'),
  912. (14, 11, 6, '2018-03-15 13:19:56', '2018-03-15 13:19:56'),
  913. (15, 11, 44, '2018-03-15 13:39:56', '2018-03-15 13:39:56'),
  914. (16, 11, 43, '2018-03-15 13:40:16', '2018-03-15 13:40:16'),
  915. (17, 18, 45, '2018-03-15 15:53:43', '2018-03-15 15:53:43'),
  916. (18, 18, 37, '2018-03-16 04:29:24', '2018-03-16 04:29:24'),
  917. (19, 18, 46, '2018-03-16 04:34:03', '2018-03-16 04:34:03'),
  918. (20, 18, 35, '2018-03-16 04:34:23', '2018-03-16 04:34:23'),
  919. (21, 18, 11, '2018-03-16 04:35:29', '2018-03-16 04:35:29'),
  920. (22, 17, 46, '2018-03-16 04:41:57', '2018-03-16 04:41:57'),
  921. (23, 2, 45, '2018-03-16 05:09:39', '2018-03-16 05:09:39'),
  922. (24, 17, 45, '2018-03-16 05:19:50', '2018-03-16 05:19:50'),
  923. (25, 17, 35, '2018-03-16 05:21:07', '2018-03-16 05:21:07'),
  924. (26, 17, 37, '2018-03-16 05:21:22', '2018-03-16 05:21:22'),
  925. (27, 2, 46, '2018-03-16 05:57:09', '2018-03-16 05:57:09'),
  926. (28, 19, 45, '2018-03-16 06:03:22', '2018-03-16 06:03:22'),
  927. (29, 19, 46, '2018-03-16 06:03:59', '2018-03-16 06:03:59'),
  928. (30, 1, 16, '2018-03-16 06:41:27', '2018-03-16 06:41:27'),
  929. (31, 19, 47, '2018-03-16 09:44:06', '2018-03-16 09:44:06'),
  930. (32, 19, 48, '2018-03-16 10:11:57', '2018-03-16 10:11:57'),
  931. (33, 3, 46, '2018-03-16 12:47:58', '2018-03-16 12:47:58'),
  932. (34, 3, 10, '2018-03-16 12:55:37', '2018-03-16 12:55:37'),
  933. (35, 19, 10, '2018-03-16 13:02:15', '2018-03-16 13:02:15'),
  934. (36, 3, 16, '2018-03-16 13:02:24', '2018-03-16 13:02:24'),
  935. (37, 13, 37, '2018-03-16 13:24:47', '2018-03-16 13:24:47'),
  936. (38, 17, 47, '2018-03-16 13:50:54', '2018-03-16 13:50:54'),
  937. (39, 13, 36, '2018-03-16 14:38:21', '2018-03-16 14:38:21'),
  938. (40, 20, 37, '2018-03-16 14:39:05', '2018-03-16 14:39:05'),
  939. (41, 13, 45, '2018-03-16 15:48:54', '2018-03-16 15:48:54'),
  940. (42, 13, 8, '2018-03-17 04:59:01', '2018-03-17 04:59:01'),
  941. (43, 13, 7, '2018-03-17 05:01:26', '2018-03-17 05:01:26'),
  942. (44, 19, 37, '2018-03-17 05:07:31', '2018-03-17 05:07:31'),
  943. (45, 13, 33, '2018-03-17 05:08:52', '2018-03-17 05:08:52'),
  944. (46, 13, 46, '2018-03-17 05:12:41', '2018-03-17 05:12:41'),
  945. (47, 13, 47, '2018-03-17 05:15:56', '2018-03-17 05:15:56'),
  946. (48, 19, 34, '2018-03-17 05:22:12', '2018-03-17 05:22:12'),
  947. (49, 13, 35, '2018-03-17 05:23:52', '2018-03-17 05:23:52'),
  948. (50, 19, 18, '2018-03-17 05:43:03', '2018-03-17 05:43:03'),
  949. (51, 13, 48, '2018-03-17 06:04:12', '2018-03-17 06:04:12'),
  950. (52, 19, 35, '2018-03-17 06:41:54', '2018-03-17 06:41:54'),
  951. (53, 20, 18, '2018-03-17 09:46:49', '2018-03-17 09:46:49'),
  952. (54, 13, 49, '2018-03-17 09:47:40', '2018-03-17 09:47:40'),
  953. (55, 19, 11, '2018-03-17 10:08:16', '2018-03-17 10:08:16'),
  954. (56, 20, 47, '2018-03-17 10:10:22', '2018-03-17 10:10:22'),
  955. (57, 19, 25, '2018-03-17 10:13:44', '2018-03-17 10:13:44'),
  956. (58, 19, 51, '2018-03-17 11:58:32', '2018-03-17 11:58:32'),
  957. (59, 19, 20, '2018-03-19 07:47:29', '2018-03-19 07:47:29'),
  958. (60, 19, 49, '2018-03-19 09:58:11', '2018-03-19 09:58:11'),
  959. (61, 19, 6, '2018-03-19 09:58:55', '2018-03-19 09:58:55'),
  960. (62, 19, 50, '2018-03-19 09:59:17', '2018-03-19 09:59:17'),
  961. (63, 19, 17, '2018-03-19 12:34:37', '2018-03-19 12:34:37'),
  962. (64, 19, 8, '2018-03-19 12:48:25', '2018-03-19 12:48:25');
  963.  
  964. --
  965. -- Indexes for dumped tables
  966. --
  967.  
  968. --
  969. -- Indexes for table `admins`
  970. --
  971. ALTER TABLE `admins`
  972. ADD PRIMARY KEY (`id`);
  973.  
  974. --
  975. -- Indexes for table `blocked_users`
  976. --
  977. ALTER TABLE `blocked_users`
  978. ADD PRIMARY KEY (`id`),
  979. ADD KEY `user_id_1` (`user_id_1`),
  980. ADD KEY `user_id_2` (`user_id_2`);
  981.  
  982. --
  983. -- Indexes for table `categories`
  984. --
  985. ALTER TABLE `categories`
  986. ADD PRIMARY KEY (`id`);
  987.  
  988. --
  989. -- Indexes for table `chats`
  990. --
  991. ALTER TABLE `chats`
  992. ADD PRIMARY KEY (`id`),
  993. ADD KEY `sent_by` (`sent_by`),
  994. ADD KEY `sent_to` (`sent_to`),
  995. ADD KEY `post_id` (`post_id`);
  996.  
  997. --
  998. -- Indexes for table `favorites`
  999. --
  1000. ALTER TABLE `favorites`
  1001. ADD PRIMARY KEY (`id`),
  1002. ADD KEY `user_id` (`user_id`),
  1003. ADD KEY `post_id` (`post_id`);
  1004.  
  1005. --
  1006. -- Indexes for table `follows`
  1007. --
  1008. ALTER TABLE `follows`
  1009. ADD PRIMARY KEY (`id`),
  1010. ADD KEY `user_id_1` (`user_id_1`),
  1011. ADD KEY `user_id_2` (`user_id_2`);
  1012.  
  1013. --
  1014. -- Indexes for table `notifications`
  1015. --
  1016. ALTER TABLE `notifications`
  1017. ADD PRIMARY KEY (`id`),
  1018. ADD KEY `post_id` (`post_id`),
  1019. ADD KEY `favorite_id` (`favorite_id`),
  1020. ADD KEY `follow_id` (`follow_id`),
  1021. ADD KEY `praise_id` (`praise_id`),
  1022. ADD KEY `user_id_1` (`user_id_1`),
  1023. ADD KEY `user_id_2` (`user_id_2`);
  1024.  
  1025. --
  1026. -- Indexes for table `password_resets`
  1027. --
  1028. ALTER TABLE `password_resets`
  1029. ADD PRIMARY KEY (`id`),
  1030. ADD KEY `user_id` (`user_id`);
  1031.  
  1032. --
  1033. -- Indexes for table `posts`
  1034. --
  1035. ALTER TABLE `posts`
  1036. ADD PRIMARY KEY (`id`),
  1037. ADD KEY `user_id` (`user_id`),
  1038. ADD KEY `category_id` (`category_id`),
  1039. ADD KEY `sub_category_id` (`sub_category_id`),
  1040. ADD KEY `sold_to` (`sold_to`);
  1041.  
  1042. --
  1043. -- Indexes for table `praises`
  1044. --
  1045. ALTER TABLE `praises`
  1046. ADD PRIMARY KEY (`id`),
  1047. ADD KEY `user_id_1` (`user_id_1`),
  1048. ADD KEY `post_id` (`post_id`),
  1049. ADD KEY `user_id_2` (`user_id_2`);
  1050.  
  1051. --
  1052. -- Indexes for table `promotions`
  1053. --
  1054. ALTER TABLE `promotions`
  1055. ADD PRIMARY KEY (`id`);
  1056.  
  1057. --
  1058. -- Indexes for table `report_posts`
  1059. --
  1060. ALTER TABLE `report_posts`
  1061. ADD PRIMARY KEY (`id`),
  1062. ADD KEY `user_id` (`user_id`),
  1063. ADD KEY `post_id` (`post_id`);
  1064.  
  1065. --
  1066. -- Indexes for table `report_users`
  1067. --
  1068. ALTER TABLE `report_users`
  1069. ADD PRIMARY KEY (`id`);
  1070.  
  1071. --
  1072. -- Indexes for table `sub_categories`
  1073. --
  1074. ALTER TABLE `sub_categories`
  1075. ADD PRIMARY KEY (`id`),
  1076. ADD KEY `category_id` (`category_id`);
  1077.  
  1078. --
  1079. -- Indexes for table `tags`
  1080. --
  1081. ALTER TABLE `tags`
  1082. ADD PRIMARY KEY (`id`);
  1083.  
  1084. --
  1085. -- Indexes for table `users`
  1086. --
  1087. ALTER TABLE `users`
  1088. ADD PRIMARY KEY (`id`);
  1089.  
  1090. --
  1091. -- Indexes for table `user_devices`
  1092. --
  1093. ALTER TABLE `user_devices`
  1094. ADD PRIMARY KEY (`id`),
  1095. ADD KEY `user_id` (`user_id`);
  1096.  
  1097. --
  1098. -- Indexes for table `views`
  1099. --
  1100. ALTER TABLE `views`
  1101. ADD PRIMARY KEY (`id`),
  1102. ADD KEY `user_id` (`user_id`),
  1103. ADD KEY `post_id` (`post_id`);
  1104.  
  1105. --
  1106. -- AUTO_INCREMENT for dumped tables
  1107. --
  1108.  
  1109. --
  1110. -- AUTO_INCREMENT for table `admins`
  1111. --
  1112. ALTER TABLE `admins`
  1113. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1114.  
  1115. --
  1116. -- AUTO_INCREMENT for table `blocked_users`
  1117. --
  1118. ALTER TABLE `blocked_users`
  1119. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
  1120.  
  1121. --
  1122. -- AUTO_INCREMENT for table `categories`
  1123. --
  1124. ALTER TABLE `categories`
  1125. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  1126.  
  1127. --
  1128. -- AUTO_INCREMENT for table `chats`
  1129. --
  1130. ALTER TABLE `chats`
  1131. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=179;
  1132.  
  1133. --
  1134. -- AUTO_INCREMENT for table `favorites`
  1135. --
  1136. ALTER TABLE `favorites`
  1137. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;
  1138.  
  1139. --
  1140. -- AUTO_INCREMENT for table `follows`
  1141. --
  1142. ALTER TABLE `follows`
  1143. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
  1144.  
  1145. --
  1146. -- AUTO_INCREMENT for table `notifications`
  1147. --
  1148. ALTER TABLE `notifications`
  1149. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;
  1150.  
  1151. --
  1152. -- AUTO_INCREMENT for table `password_resets`
  1153. --
  1154. ALTER TABLE `password_resets`
  1155. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1156.  
  1157. --
  1158. -- AUTO_INCREMENT for table `posts`
  1159. --
  1160. ALTER TABLE `posts`
  1161. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
  1162.  
  1163. --
  1164. -- AUTO_INCREMENT for table `praises`
  1165. --
  1166. ALTER TABLE `praises`
  1167. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  1168.  
  1169. --
  1170. -- AUTO_INCREMENT for table `promotions`
  1171. --
  1172. ALTER TABLE `promotions`
  1173. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  1174.  
  1175. --
  1176. -- AUTO_INCREMENT for table `report_posts`
  1177. --
  1178. ALTER TABLE `report_posts`
  1179. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1180.  
  1181. --
  1182. -- AUTO_INCREMENT for table `report_users`
  1183. --
  1184. ALTER TABLE `report_users`
  1185. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  1186.  
  1187. --
  1188. -- AUTO_INCREMENT for table `sub_categories`
  1189. --
  1190. ALTER TABLE `sub_categories`
  1191. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
  1192.  
  1193. --
  1194. -- AUTO_INCREMENT for table `tags`
  1195. --
  1196. ALTER TABLE `tags`
  1197. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  1198.  
  1199. --
  1200. -- AUTO_INCREMENT for table `users`
  1201. --
  1202. ALTER TABLE `users`
  1203. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  1204.  
  1205. --
  1206. -- AUTO_INCREMENT for table `user_devices`
  1207. --
  1208. ALTER TABLE `user_devices`
  1209. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1210.  
  1211. --
  1212. -- AUTO_INCREMENT for table `views`
  1213. --
  1214. ALTER TABLE `views`
  1215. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;
  1216.  
  1217. --
  1218. -- Constraints for dumped tables
  1219. --
  1220.  
  1221. --
  1222. -- Constraints for table `blocked_users`
  1223. --
  1224. ALTER TABLE `blocked_users`
  1225. ADD CONSTRAINT `blocked_users_ibfk_1` FOREIGN KEY (`user_id_1`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1226. ADD CONSTRAINT `blocked_users_ibfk_2` FOREIGN KEY (`user_id_2`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  1227.  
  1228. --
  1229. -- Constraints for table `chats`
  1230. --
  1231. ALTER TABLE `chats`
  1232. ADD CONSTRAINT `chats_ibfk_1` FOREIGN KEY (`sent_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1233. ADD CONSTRAINT `chats_ibfk_2` FOREIGN KEY (`sent_to`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1234. ADD CONSTRAINT `chats_ibfk_3` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  1235.  
  1236. --
  1237. -- Constraints for table `favorites`
  1238. --
  1239. ALTER TABLE `favorites`
  1240. ADD CONSTRAINT `favorites_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1241. ADD CONSTRAINT `favorites_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  1242.  
  1243. --
  1244. -- Constraints for table `follows`
  1245. --
  1246. ALTER TABLE `follows`
  1247. ADD CONSTRAINT `follows_ibfk_1` FOREIGN KEY (`user_id_1`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1248. ADD CONSTRAINT `follows_ibfk_2` FOREIGN KEY (`user_id_2`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  1249.  
  1250. --
  1251. -- Constraints for table `password_resets`
  1252. --
  1253. ALTER TABLE `password_resets`
  1254. ADD CONSTRAINT `password_resets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
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!