-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `psfitness`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_activity_level`
--

CREATE TABLE `tbl_activity_level` (
  `id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `iimage` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_activity_level`
--

INSERT INTO `tbl_activity_level` (`id`, `name`, `iimage`, `status`, `insertdate`, `updatetime`) VALUES
(1, 'light activity', 'abc.png', 'Active', '2023-07-15 13:50:40', '2023-07-15 13:50:40');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_admin_menu`
--

CREATE TABLE `tbl_admin_menu` (
  `id` int(11) NOT NULL,
  `menu_page_title` varchar(200) NOT NULL,
  `menu_icon` varchar(264) NOT NULL,
  `menu_parent_id` int(11) DEFAULT NULL,
  `controller_name` varchar(500) NOT NULL,
  `controller_path` varchar(500) NOT NULL DEFAULT 'index',
  `menu_listed_in_menu` bit(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_admin_menu`
--

INSERT INTO `tbl_admin_menu` (`id`, `menu_page_title`, `menu_icon`, `menu_parent_id`, `controller_name`, `controller_path`, `menu_listed_in_menu`, `is_active`, `insertdate`) VALUES
(1, 'Dashboard', '<i class=\"zmdi zmdi-home\"></i>', 0, 'dashboard', 'home/dashboard', b'1', 1, '2020-05-01 13:18:51'),
(2, 'Admin', '<i class=\"zmdi zmdi-account-add zmd-fw\"></i>', 0, 'sub_admin', 'admin/sub_admin', b'1', 1, '2020-05-01 13:31:05'),
(3, 'User', '<i class=\"zmdi zmdi-account\"></i>', 0, 'user', 'admin/user', b'1', 1, '2020-05-01 13:32:37'),
(4, 'Industries', ' <i class=\"zmdi zmdi-store\"></i>', 0, 'industries', 'admin/industries', b'1', 1, '2020-05-01 13:41:39'),
(5, 'risk_tolerance', '<i class=\"zmdi zmdi-bug\"></i>', 0, 'risk_tolerance', 'admin/risk_tolerance', b'1', 1, '2020-05-01 13:42:20'),
(6, 'broker', '<i class=\"zmdi zmdi-broken-image\"></i>', 0, 'broker', 'admin/broker', b'1', 1, '2020-05-01 13:43:01'),
(7, 'notification', '<i class=\"zmdi zmdi-notifications\"></i>', 0, 'notification', 'admin/notification', b'1', 1, '2020-05-01 13:43:45'),
(8, 'contact_us', '<i class=\"zmdi zmdi-email\"></i>', 0, 'contact_us', 'admin/contact_us', b'1', 1, '2020-05-01 13:45:18'),
(9, 'setting', '<i class=\"zmdi zmdi-settings\"></i>', 0, 'setting', 'admin/setting', b'1', 1, '2020-05-01 13:46:03'),
(10, 'Manage content', '<i class=\"zmdi zmdi-copy\"></i>', 0, 'pages', 'admin/pages', b'1', 1, '2020-05-01 13:47:54'),
(11, 'Edit', '', 2, 'sub_admin', 'sub_admin/edit', b'0', 1, '2020-05-02 04:01:22'),
(12, 'permission', '', 2, 'sub_admin', 'sub_admin/permission', b'0', 1, '2020-05-02 04:02:19'),
(13, 'remove', '', 2, 'sub_admin', 'sub_admin/remove', b'0', 1, '2020-05-02 04:03:08'),
(14, 'change_state', '', 2, 'sub_admin', 'sub_admin/change_state', b'0', 1, '2020-05-02 04:08:49'),
(15, 'view', '', 3, 'user', 'user/view', b'0', 1, '2020-05-02 04:36:58'),
(16, 'change_state', '', 3, 'user', 'user/change_state', b'0', 1, '2020-05-02 04:37:13'),
(17, 'remove', '', 3, 'user', 'user/remove', b'0', 1, '2020-05-02 04:37:27'),
(18, 'activity_change_state', '', 3, 'user', 'user/activity_change_state', b'0', 1, '2020-05-02 04:42:54'),
(19, 'activity_remove', '', 3, 'user', 'user/activity_remove', b'0', 1, '2020-05-02 04:43:06'),
(20, 'edit', '', 4, 'industries', 'industries/edit', b'0', 1, '2020-05-02 05:44:30'),
(21, 'change_state', '', 4, 'industries', 'industries/change_state', b'0', 1, '2020-05-02 05:46:10'),
(22, 'remove', '', 4, 'industries', 'industries/remove', b'0', 1, '2020-05-02 05:47:00'),
(23, 'rearrange', '', 4, 'industries', 'industries/rearrange', b'0', 1, '2020-05-02 05:47:49'),
(24, 'trending_down', '', 4, 'industries', 'industries/trending_down', b'0', 1, '2020-05-02 05:48:52'),
(25, 'trending_up', '', 4, 'industries', 'industries/trending_up', b'0', 1, '2020-05-02 05:49:24'),
(26, 'edit', '', 6, 'broker', 'broker/edit', b'0', 1, '2020-05-02 05:53:40'),
(27, 'change_state', '', 6, 'broker', 'broker/change_state', b'0', 1, '2020-05-02 05:55:26'),
(28, 'rearrange', '', 6, 'broker', 'broker/rearrange', b'0', 1, '2020-05-02 05:55:46'),
(29, 'remove', '', 6, 'broker', 'broker/remove', b'0', 1, '2020-05-02 05:55:58'),
(30, 'add', '', 7, 'notification', 'notification/add', b'0', 1, '2020-05-02 05:59:33'),
(31, 'setting update', '', 9, 'setting', 'setting/save', b'0', 1, '2020-05-02 06:02:38'),
(32, 'change_state', '', 8, 'contact_us', 'contact_us/change_state', b'0', 1, '2020-05-02 06:05:10'),
(33, 'remove', '', 8, 'contact_us', 'contact_us/remove', b'0', 1, '2020-05-02 06:06:16'),
(34, 'pages', '', 10, 'pages', 'pages/details', b'0', 1, '2020-05-02 06:12:13');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_admin_user_permissions`
--

CREATE TABLE `tbl_admin_user_permissions` (
  `id` int(11) NOT NULL,
  `adm_user_id` int(11) NOT NULL,
  `admin_menu_id` int(11) NOT NULL,
  `is_active` bit(1) NOT NULL DEFAULT b'0',
  `is_delete` bit(1) NOT NULL DEFAULT b'0',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_admin_user_permissions`
--

INSERT INTO `tbl_admin_user_permissions` (`id`, `adm_user_id`, `admin_menu_id`, `is_active`, `is_delete`, `insertdate`) VALUES
(1, 0, 1, b'1', b'0', '2020-05-01 14:39:00'),
(3, 0, 1, b'1', b'0', '2020-05-01 14:39:06'),
(5, 0, 1, b'1', b'0', '2020-05-02 03:56:29'),
(8, 0, 1, b'1', b'0', '2020-05-02 03:59:55'),
(12, 0, 1, b'1', b'0', '2020-05-02 04:37:37'),
(13, 2, 2, b'1', b'0', '2020-05-02 04:37:37'),
(14, 2, 3, b'1', b'0', '2020-05-02 04:37:37'),
(15, 2, 15, b'1', b'0', '2020-05-02 04:37:37'),
(16, 2, 9, b'1', b'0', '2020-05-02 04:37:37');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_blog`
--

CREATE TABLE `tbl_blog` (
  `id` int(11) NOT NULL,
  `title` varchar(256) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_brings`
--

CREATE TABLE `tbl_brings` (
  `id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `image` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_brings`
--

INSERT INTO `tbl_brings` (`id`, `name`, `image`, `status`, `insertdate`, `updatetime`) VALUES
(1, 'Diet Plan', 'abc.png', 'Active', '2023-07-15 13:49:53', '2023-07-15 13:49:53');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_cities`
--

CREATE TABLE `tbl_cities` (
  `id` bigint(20) NOT NULL,
  `name` text NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_cities`
--

INSERT INTO `tbl_cities` (`id`, `name`, `status`, `insertdate`, `updatetime`) VALUES
(1, 'jamnager', 'Active', '2023-07-15 13:50:07', '2023-07-15 13:50:07');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_contact_details`
--

CREATE TABLE `tbl_contact_details` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `email` varchar(128) NOT NULL,
  `subject` text NOT NULL,
  `description` text NOT NULL,
  `full_name` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_contact_details`
--

INSERT INTO `tbl_contact_details` (`id`, `user_id`, `email`, `subject`, `description`, `full_name`, `status`, `insertdate`, `updatetime`) VALUES
(1, 0, 'abc@gmail.com', 'Other', 'Test comments', '', 'Active', '2020-03-25 05:37:06', '2020-04-27 12:35:49'),
(2, 0, 'abcd@gmail.com', 'Customer Support', 'This is a sample comment', '', 'Active', '2020-03-28 12:33:51', '2020-04-27 12:35:58'),
(3, 0, 'jagdish@gmail.com', 'test', '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.', '', 'Active', '2020-04-27 12:43:15', '2020-04-30 10:26:07'),
(4, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Deleted', '2020-04-27 13:27:52', '2020-06-11 17:38:08'),
(5, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Active', '2020-04-27 14:26:43', '2020-04-27 14:26:43'),
(6, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Active', '2020-04-27 14:30:26', '2020-04-27 14:30:26'),
(7, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Active', '2020-04-27 14:31:10', '2020-04-27 14:31:10'),
(8, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Active', '2020-04-27 14:33:29', '2020-04-27 14:33:29'),
(9, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Active', '2020-04-27 14:33:57', '2020-04-27 14:33:57'),
(10, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Deleted', '2020-04-27 14:35:17', '2020-05-07 04:55:04'),
(11, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Deleted', '2020-04-28 03:49:16', '2020-04-29 06:30:35'),
(12, 0, 'jagdish@gmail.com', 'test', 'tetsing new product', '', 'Deleted', '2020-04-28 03:51:00', '2020-06-11 17:38:11'),
(13, 0, 'test@gmail.com', 'test', 'test', '', 'Deleted', '2020-05-06 15:08:32', '2020-06-11 17:38:14'),
(14, 0, 'shhs@g.com', 'hdhsh', 'hdhsh', '', 'Active', '2020-06-16 11:45:14', '2020-06-16 11:45:14'),
(15, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:10:17', '2020-06-25 09:10:17'),
(16, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:14:49', '2020-06-25 09:14:49'),
(17, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:21:15', '2020-06-25 09:21:15'),
(18, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:22:00', '2020-06-25 09:22:00'),
(19, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:23:00', '2020-06-25 09:23:00'),
(20, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:24:23', '2020-06-25 09:24:23'),
(21, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:24:40', '2020-06-25 09:24:40'),
(22, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:24:56', '2020-06-25 09:24:56'),
(23, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:25:19', '2020-06-25 09:25:19'),
(24, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:26:17', '2020-06-25 09:26:17'),
(25, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:26:27', '2020-06-25 09:26:27'),
(26, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:26:43', '2020-06-25 09:26:43'),
(27, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:27:00', '2020-06-25 09:27:00'),
(28, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-25 09:36:10', '2020-06-25 09:36:10'),
(29, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 04:26:25', '2020-06-26 04:26:25'),
(30, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 04:33:58', '2020-06-26 04:33:58'),
(31, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:35:22', '2020-06-26 08:35:22'),
(32, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:42:42', '2020-06-26 08:42:42'),
(33, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:43:35', '2020-06-26 08:43:35'),
(34, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:44:13', '2020-06-26 08:44:13'),
(35, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:44:52', '2020-06-26 08:44:52'),
(36, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:45:09', '2020-06-26 08:45:09'),
(37, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:46:18', '2020-06-26 08:46:18'),
(38, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:50:09', '2020-06-26 08:50:09'),
(39, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:50:50', '2020-06-26 08:50:50'),
(40, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:53:52', '2020-06-26 08:53:52'),
(41, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:54:10', '2020-06-26 08:54:10'),
(42, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:54:53', '2020-06-26 08:54:53'),
(43, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:56:01', '2020-06-26 08:56:01'),
(44, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:56:37', '2020-06-26 08:56:37'),
(45, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:57:29', '2020-06-26 08:57:29'),
(46, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:58:01', '2020-06-26 08:58:01'),
(47, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 08:58:29', '2020-06-26 08:58:29'),
(48, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:00:34', '2020-06-26 09:00:34'),
(49, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:01:02', '2020-06-26 09:01:02'),
(50, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:01:41', '2020-06-26 09:01:41'),
(51, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:02:07', '2020-06-26 09:02:07'),
(52, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:03:54', '2020-06-26 09:03:54'),
(53, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:04:51', '2020-06-26 09:04:51'),
(54, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:05:09', '2020-06-26 09:05:09'),
(55, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:06:07', '2020-06-26 09:06:07'),
(56, 0, 'test@gmail.com', 'test', 'test', '', 'Active', '2020-06-26 09:06:22', '2020-06-26 09:06:22'),
(57, 0, 'test@gmail.com', 'test', 'test123456', '', 'Active', '2020-06-26 10:12:31', '2020-06-26 10:12:31'),
(58, 0, 'test@gmail.com', 'test', 'test123456', '', 'Active', '2020-06-26 10:17:03', '2020-06-26 10:17:03'),
(59, 0, 'test@gmail.com', 'test', 'test123456', '', 'Active', '2020-06-26 10:17:19', '2020-06-26 10:17:19'),
(60, 0, 'test@gmail.com', 'test', 'test123456', '', 'Active', '2020-06-26 10:18:54', '2020-06-26 10:18:54'),
(61, 0, 'test@gmail.com', 'test', 'test123456', '', 'Active', '2020-06-26 10:20:02', '2020-06-26 10:20:02'),
(62, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-27 14:30:20', '2020-06-27 14:30:20'),
(63, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-27 14:30:35', '2020-06-27 14:30:35'),
(64, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-27 14:30:42', '2020-06-27 14:30:42'),
(65, 0, 'Test@gmail.com', 'ddfdff', 'dfdfdfdfdfdf', '', 'Active', '2020-06-30 08:47:18', '2020-06-30 08:47:18'),
(66, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:01:21', '2020-06-30 09:01:21'),
(67, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:02:10', '2020-06-30 09:02:10'),
(68, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:02:42', '2020-06-30 09:02:42'),
(69, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:04:27', '2020-06-30 09:04:27'),
(70, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Deleted', '2020-06-30 09:04:55', '2020-07-06 16:32:11'),
(71, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:22:19', '2020-06-30 09:22:19'),
(72, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:22:37', '2020-06-30 09:22:37'),
(73, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:23:03', '2020-06-30 09:23:03'),
(74, 0, 'test@gmail.com', 'test', 'eszdgjsdhgj', '', 'Active', '2020-06-30 09:23:49', '2020-06-30 09:23:49'),
(75, 0, 'test@gmail.com', 'test', 'eszdgjsdhgj', '', 'Active', '2020-06-30 09:24:43', '2020-06-30 09:24:43'),
(76, 0, 'test@gmail.com', '12', 'eszdgjsdhgj', '', 'Active', '2020-06-30 09:24:55', '2020-06-30 09:24:55'),
(77, 0, 'test@gmail.com', '12', 'eszdgjsdhgj', '', 'Active', '2020-06-30 09:25:41', '2020-06-30 09:25:41'),
(78, 0, 'test@gmail.com', 'test', 'testtesttest', '', 'Active', '2020-06-30 09:31:29', '2020-06-30 09:31:29'),
(79, 0, 'Test@gmail.com', 'dfdfdfdf', 'dfsddfdfdf', '', 'Active', '2020-06-30 09:40:48', '2020-06-30 09:40:48'),
(80, 0, 'aukoyfman@gmail.com', 'help!', 'help please!', '', 'Active', '2020-07-15 14:17:23', '2020-07-15 14:17:23'),
(81, 0, 'mona@gmail.com', 'asdfg', '12345678912', '', 'Active', '2020-07-16 09:38:21', '2020-07-16 09:38:21'),
(82, 0, 'mona@gmail.com', 'asdfg', '1234567899', '', 'Active', '2020-07-16 14:59:02', '2020-07-16 14:59:02'),
(83, 0, 'mona@gmail.com', '1234', '1234567899', '', 'Active', '2020-07-16 15:02:04', '2020-07-16 15:02:04'),
(84, 0, 'kushalm@hyperlinkinfosystem.net.in', 'Test email', 'test email', '', 'Active', '2020-07-16 15:26:42', '2020-07-16 15:26:42'),
(85, 0, 'kushalm@hyperlinkinfosystem.net.in', 'Test again', 'test again', '', 'Active', '2020-07-16 15:39:59', '2020-07-16 15:39:59'),
(86, 0, 'aukoyfman@gmail.com', 'this works', 'this works', '', 'Active', '2020-08-25 17:25:38', '2020-08-25 17:25:38');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_country`
--

CREATE TABLE `tbl_country` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `nationality` varchar(64) NOT NULL,
  `sortname` varchar(3) NOT NULL,
  `calling_code` varchar(10) NOT NULL,
  `currency_code` varchar(6) NOT NULL,
  `currency_name` varchar(32) NOT NULL,
  `currency_symbol` varchar(8) NOT NULL,
  `status` enum('Inactive','Active','Deleted') NOT NULL,
  `insertdate` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`id`, `name`, `nationality`, `sortname`, `calling_code`, `currency_code`, `currency_name`, `currency_symbol`, `status`, `insertdate`) VALUES
(1, 'Afghanistan', 'Afghan', 'AF', '+93', '', '', '', 'Inactive', '2017-09-01 17:05:50'),
(2, 'Albania', 'Albanian', 'AL', '+355', 'ALL', 'Albanian lek', 'L', 'Inactive', '2017-09-01 17:05:50'),
(3, 'Algeria', 'Algerian', 'DZ', '+213', 'DZD', 'Algerian dinar', 'د.ج', 'Inactive', '2017-09-01 17:05:50'),
(4, 'American Samoa', 'American Samoan', 'AS', '+1684', 'USD', 'United State Dollar', '$', 'Inactive', '2017-09-01 17:05:50'),
(5, 'Andorra', 'Andorran', 'AD', '+376', 'EUR', 'Euro', '€', 'Inactive', '2017-09-01 17:05:50'),
(6, 'Angola', 'Angolan', 'AO', '+244', 'AOA', 'Angolan kwanza', 'Kz', 'Inactive', '2017-09-01 17:05:50'),
(7, 'Anguilla', 'Anguillian', 'AI', '+1264', 'XCD', 'East Caribbean dollar', '$', 'Inactive', '2017-09-01 17:05:50'),
(8, 'Antarctica', 'Antarctica', 'AQ', '+672', '', '', '', 'Inactive', '2017-09-01 17:05:50'),
(9, 'Antigua And Barbuda', 'Antiguan, Barbudan', 'AG', '+1268', 'XCD', 'East Caribbean dollar', '$', 'Inactive', '2017-09-01 17:05:50'),
(10, 'Argentina', 'Argentinean', 'AR', '+54', 'ARS', 'Argentine peso', '$', 'Inactive', '2017-09-01 17:05:50'),
(11, 'Armenia', 'Armenian', 'AM', '+374', 'AMD', 'Armenian dram', '', 'Active', '2017-09-01 17:05:50'),
(12, 'Aruba', 'Aruban', 'AW', '+297', 'AWG', 'Aruban florin', 'ƒ', 'Active', '2017-09-01 17:05:50'),
(13, 'Australia', 'Australian', 'AU', '+61', 'AUD', 'Australian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(14, 'Austria', 'Austrian', 'AT', '+43', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(15, 'Azerbaijan', 'Azerbaijani', 'AZ', '994', 'AZN', 'Azerbaijani manat', '', 'Active', '2017-09-01 17:05:50'),
(16, 'Bahamas The', 'Bahamian', 'BS', '+1', '', '', '', 'Active', '2017-09-01 17:05:50'),
(17, 'Bahrain', 'Bahraini', 'BH', '+973', 'BHD', 'Bahraini dinar', '.د.ب', 'Active', '2017-09-01 17:05:50'),
(18, 'Bangladesh', 'Bangladeshi', 'BD', '+880', 'BDT', 'Bangladeshi taka', '৳', 'Active', '2017-09-01 17:05:50'),
(19, 'Barbados', 'Barbadian', 'BB', '+1246', 'BBD', 'Barbadian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(20, 'Belarus', 'Belarusian', 'BY', '+375', 'BYN', 'New Belarusian ruble', 'Br', 'Active', '2017-09-01 17:05:50'),
(21, 'Belgium', 'Belgian', 'BE', '+32', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(22, 'Belize', 'Belizean', 'BZ', '+501', 'BZD', 'Belize dollar', '$', 'Active', '2017-09-01 17:05:50'),
(23, 'Benin', 'Beninese', 'BJ', '+229', 'XOF', 'West African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(24, 'Bermuda', 'Bermudian', 'BM', '+1441', 'BMD', 'Bermudian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(25, 'Bhutan', 'Bhutanese', 'BT', '+975', 'BTN', 'Bhutanese ngultrum', 'Nu.', 'Active', '2017-09-01 17:05:50'),
(26, 'Bolivia', 'Bolivian', 'BO', '+591', 'BOB', 'Bolivian boliviano', 'Bs.', 'Active', '2017-09-01 17:05:50'),
(27, 'Bosnia and Herzegovina', 'Bosnian, Herzegovinian', 'BA', '+387', '', '', '', 'Active', '2017-09-01 17:05:50'),
(28, 'Botswana', 'Motswana', 'BW', '+267', 'BWP', 'Botswana pula', 'P', 'Active', '2017-09-01 17:05:50'),
(29, 'Bouvet Island', '', 'BV', '+55', '', '', '', '', '2017-09-01 17:05:50'),
(30, 'Brazil', 'Brazilian', 'BR', '+55', 'BRL', 'Brazilian real', 'R$', 'Active', '2017-09-01 17:05:50'),
(31, 'British Indian Ocean Territory', 'Indian', 'IO', '+246', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(32, 'Brunei', 'Bruneian', 'BN', '+673', '', '', '', 'Active', '2017-09-01 17:05:50'),
(33, 'Bulgaria', 'Bulgarian', 'BG', '+359', 'BGN', 'Bulgarian lev', 'лв', 'Active', '2017-09-01 17:05:50'),
(34, 'Burkina Faso', 'Burkinabe', 'BF', '+226', 'XOF', 'West African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(35, 'Burundi', 'Burundian', 'BI', '+257', 'BIF', 'Burundian franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(36, 'Cambodia', 'Cambodian', 'KH', '+855', 'KHR', 'Cambodian riel', '៛', 'Active', '2017-09-01 17:05:50'),
(37, 'Cameroon', 'Cameroonian', 'CM', '+237', 'XAF', 'Central African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(38, 'Canada', 'Canadian', 'CA', '+1', 'CAD', 'Canadian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(39, 'Cape Verde', 'Cape Verdian', 'CV', '+238', '', '', '', 'Active', '2017-09-01 17:05:50'),
(40, 'Cayman Islands', 'Caymanian', 'KY', '+1345', 'KYD', 'Cayman Islands dollar', '$', 'Active', '2017-09-01 17:05:50'),
(41, 'Central African Republic', 'Central African', 'CF', '+236', 'XAF', 'Central African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(42, 'Chad', 'Chadian', 'TD', '+235', 'XAF', 'Central African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(43, 'Chile', 'Chilean', 'CL', '+56', 'CLP', 'Chilean peso', '$', 'Active', '2017-09-01 17:05:50'),
(44, 'China', 'Chinese', 'CN', '+86', 'CNY', 'Chinese yuan', '¥', 'Active', '2017-09-01 17:05:50'),
(45, 'Christmas Island', 'Christmas Island', 'CX', '+61', 'AUD', 'Australian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(46, 'Cocos (Keeling) Islands', 'Cocos Islander', 'CC', '+61', 'AUD', 'Australian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(47, 'Colombia', 'Colombian', 'CO', '+57', 'COP', 'Colombian peso', '$', 'Active', '2017-09-01 17:05:50'),
(48, 'Comoros', 'Comoran', 'KM', '+269', 'KMF', 'Comorian franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(49, 'Republic Of The Congo', 'Congolese', 'CG', '+242', '', '', '', 'Active', '2017-09-01 17:05:50'),
(50, 'Democratic Republic Of The Congo', 'Congolese', 'CD', '+243', '', '', '', 'Active', '2017-09-01 17:05:50'),
(51, 'Cook Islands', 'Cook Islander', 'CK', '+682', 'NZD', 'New Zealand dollar', '$', 'Active', '2017-09-01 17:05:50'),
(52, 'Costa Rica', 'Costa Rican', 'CR', '+506', 'CRC', 'Costa Rican colón', '₡', 'Active', '2017-09-01 17:05:50'),
(53, 'Cote D\'Ivoire (Ivory Coast)', 'Ivorian', 'CI', '+225', '', '', '', 'Active', '2017-09-01 17:05:50'),
(54, 'Croatia (Hrvatska)', 'Croatian', 'HR', '+385', '', '', '', 'Active', '2017-09-01 17:05:50'),
(55, 'Cuba', 'Cuban', 'CU', '+53', 'CUC', 'Cuban convertible peso', '$', 'Active', '2017-09-01 17:05:50'),
(56, 'Cyprus', 'Cypriot', 'CY', '+357', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(57, 'Czech Republic', 'Czech', 'CZ', '+420', 'CZK', 'Czech koruna', 'Kč', 'Active', '2017-09-01 17:05:50'),
(58, 'Denmark', 'Danish', 'DK', '+45', 'DKK', 'Danish krone', 'kr', 'Active', '2017-09-01 17:05:50'),
(59, 'Djibouti', 'Djibouti', 'DJ', '+253', 'DJF', 'Djiboutian franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(60, 'Dominica', 'Dominican', 'DM', '+1767', 'XCD', 'East Caribbean dollar', '$', 'Active', '2017-09-01 17:05:50'),
(61, 'Dominican Republic', 'Dominican', 'DO', '+1809', 'DOP', 'Dominican peso', '$', 'Active', '2017-09-01 17:05:50'),
(62, 'East Timor', 'Zimbabwean', 'TP', '+670', '', '', '', 'Active', '2017-09-01 17:05:50'),
(63, 'Ecuador', 'Ecuadorean', 'EC', '+593', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(64, 'Egypt', 'Egyptian', 'EG', '+20', 'EGP', 'Egyptian pound', '£', 'Active', '2017-09-01 17:05:50'),
(65, 'El Salvador', 'Salvadoran', 'SV', '+503', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(66, 'Equatorial Guinea', 'Equatorial Guinean', 'GQ', '+240', 'XAF', 'Central African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(67, 'Eritrea', 'Eritrean', 'ER', '+291', 'ERN', 'Eritrean nakfa', 'Nfk', 'Active', '2017-09-01 17:05:50'),
(68, 'Estonia', 'Estonian', 'EE', '+372', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(69, 'Ethiopia', 'Ethiopian', 'ET', '+251', 'ETB', 'Ethiopian birr', 'Br', 'Active', '2017-09-01 17:05:50'),
(70, 'External Territories of Australia', 'Zimbabwean', 'XA', '+672', '', '', '', 'Active', '2017-09-01 17:05:50'),
(71, 'Falkland Islands', 'Falkland Islander', 'FK', '+500', '', '', '', 'Active', '2017-09-01 17:05:50'),
(72, 'Faroe Islands', 'Faroese', 'FO', '+298', 'DKK', 'Danish krone', 'kr', 'Active', '2017-09-01 17:05:50'),
(73, 'Fiji Islands', 'Fijian', 'FJ', '+679', '', '', '', 'Active', '2017-09-01 17:05:50'),
(74, 'Finland', 'Finnish', 'FI', '+358', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(75, 'France', 'French', 'FR', '+33', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(76, 'French Guiana', '', 'GF', '+594', '', '', '', '', '2017-09-01 17:05:50'),
(77, 'French Polynesia', 'French Polynesian', 'PF', '+689', 'XPF', 'CFP franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(78, 'French Southern Territories', 'French', 'TF', '+262', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(79, 'Gabon', 'Gabonese', 'GA', '+241', 'XAF', 'Central African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(80, 'Gambia The', 'Gambian', 'GM', '+220', '', '', '', 'Active', '2017-09-01 17:05:50'),
(81, 'Georgia', 'Georgian', 'GE', '+995', 'GEL', 'Georgian Lari', 'ლ', 'Active', '2017-09-01 17:05:50'),
(82, 'Germany', 'German', 'DE', '+49', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(83, 'Ghana', 'Ghanaian', 'GH', '+233', 'GHS', 'Ghanaian cedi', '₵', 'Active', '2017-09-01 17:05:50'),
(84, 'Gibraltar', 'Gibraltar', 'GI', '+350', 'GIP', 'Gibraltar pound', '£', 'Active', '2017-09-01 17:05:50'),
(85, 'Greece', 'Greek', 'GR', '+30', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(86, 'Greenland', 'Greenlandic', 'GL', '+299', 'DKK', 'Danish krone', 'kr', 'Active', '2017-09-01 17:05:50'),
(87, 'Grenada', 'Grenadian', 'GD', '+1473', 'XCD', 'East Caribbean dollar', '$', 'Active', '2017-09-01 17:05:50'),
(88, 'Guadeloupe', 'Guadeloupian', 'GP', '+590', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(89, 'Guam', 'Guamanian', 'GU', '+1671', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(90, 'Guatemala', 'Guatemalan', 'GT', '+502', 'GTQ', 'Guatemalan quetzal', 'Q', 'Active', '2017-09-01 17:05:50'),
(91, 'Guernsey and Alderney', 'Zimbabwean', 'XU', '+44-1481', '', '', '', 'Active', '2017-09-01 17:05:50'),
(92, 'Guinea', 'Guinean', 'GN', '+224', 'GNF', 'Guinean franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(93, 'Guinea-Bissau', 'Guinea-Bissauan', 'GW', '+245', 'XOF', 'West African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(94, 'Guyana', 'Guyanese', 'GY', '+592', 'GYD', 'Guyanese dollar', '$', 'Active', '2017-09-01 17:05:50'),
(95, 'Haiti', 'Haitian', 'HT', '+509', 'HTG', 'Haitian gourde', 'G', 'Active', '2017-09-01 17:05:50'),
(96, 'Heard and McDonald Islands', 'Heard and McDonald Islander', 'HM', '+0', '', '', '', 'Active', '2017-09-01 17:05:50'),
(97, 'Honduras', 'Honduran', 'HN', '+504', 'HNL', 'Honduran lempira', 'L', 'Active', '2017-09-01 17:05:50'),
(98, 'Hong Kong S.A.R.', 'Chinese', 'HK', '+852', '', '', '', 'Active', '2017-09-01 17:05:50'),
(99, 'Hungary', 'Hungarian', 'HU', '+36', 'HUF', 'Hungarian forint', 'Ft', 'Active', '2017-09-01 17:05:50'),
(100, 'Iceland', 'Icelander', 'IS', '+354', 'ISK', 'Icelandic króna', 'kr', 'Active', '2017-09-01 17:05:50'),
(101, 'India', 'Indian', 'IN', '+91', 'INR', 'Indian rupee', '₹', 'Active', '2017-09-01 17:05:50'),
(102, 'Indonesia', 'Indonesian', 'ID', '+62', 'IDR', 'Indonesian rupiah', 'Rp', 'Active', '2017-09-01 17:05:50'),
(103, 'Iran', 'Iranian', 'IR', '+98', 'IRR', 'Iranian rial', '﷼', 'Active', '2017-09-01 17:05:50'),
(104, 'Iraq', 'Iraqi', 'IQ', '+964', 'IQD', 'Iraqi dinar', 'ع.د', 'Active', '2017-09-01 17:05:50'),
(105, 'Ireland', 'Irish', 'IE', '+353', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(106, 'Israel', 'Israeli', 'IL', '+972', 'ILS', 'Israeli new shekel', '₪', 'Active', '2017-09-01 17:05:50'),
(107, 'Italy', 'Italian', 'IT', '+39', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(108, 'Jamaica', 'Jamaican', 'JM', '+1876', 'JMD', 'Jamaican dollar', '$', 'Active', '2017-09-01 17:05:50'),
(109, 'Japan', 'Japanese', 'JP', '+81', 'JPY', 'Japanese yen', '¥', 'Active', '2017-09-01 17:05:50'),
(110, 'Jersey', 'Zimbabwean', 'XJ', '+44', 'GBP', 'British pound', '£', 'Active', '2017-09-01 17:05:50'),
(111, 'Jordan', 'Jordanian', 'JO', '+962', 'JOD', 'Jordanian dinar', 'د.ا', 'Active', '2017-09-01 17:05:50'),
(112, 'Kazakhstan', 'Kazakhstani', 'KZ', '+7', 'KZT', 'Kazakhstani tenge', '', 'Active', '2017-09-01 17:05:50'),
(113, 'Kenya', 'Kenyan', 'KE', '+254', 'KES', 'Kenyan shilling', 'Sh', 'Active', '2017-09-01 17:05:50'),
(114, 'Kiribati', 'I-Kiribati', 'KI', '+686', 'AUD', 'Australian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(115, 'Korea North', 'North Korean', 'KP', '+850', '', '', '', 'Active', '2017-09-01 17:05:50'),
(116, 'South Korean', 'South Korean', 'KR', '+82', '', '', '', 'Active', '2017-09-01 17:05:50'),
(117, 'Kuwait', 'Kuwaiti', 'KW', '+965', 'KWD', 'Kuwaiti dinar', 'د.ك', 'Active', '2017-09-01 17:05:50'),
(118, 'Kyrgyzstan', 'Kirghiz', 'KG', '+996', 'KGS', 'Kyrgyzstani som', 'с', 'Active', '2017-09-01 17:05:50'),
(119, 'Laos', 'Laotian', 'LA', '+856', '', '', '', 'Active', '2017-09-01 17:05:50'),
(120, 'Latvia', 'Latvian', 'LV', '+371', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(121, 'Lebanon', 'Lebanese', 'LB', '+961', 'LBP', 'Lebanese pound', 'ل.ل', 'Active', '2017-09-01 17:05:50'),
(122, 'Lesotho', 'Mosotho', 'LS', '+266', 'LSL', 'Lesotho loti', 'L', 'Active', '2017-09-01 17:05:50'),
(123, 'Liberia', 'Liberian', 'LR', '+231', 'LRD', 'Liberian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(124, 'Libya', 'Libyan', 'LY', '+218', 'LYD', 'Libyan dinar', 'ل.د', 'Active', '2017-09-01 17:05:50'),
(125, 'Liechtenstein', 'Liechtensteiner', 'LI', '+423', 'CHF', 'Swiss franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(126, 'Lithuania', 'Lithuanian', 'LT', '+370', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(127, 'Luxembourg', 'Luxembourger', 'LU', '+352', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(128, 'Macau S.A.R.', 'Chinese', 'MO', '+853', '', '', '', 'Active', '2017-09-01 17:05:50'),
(129, 'Macedonia', 'Macedonian', 'MK', '+389', 'MKD', 'Macedonian denar', 'ден', 'Active', '2017-09-01 17:05:50'),
(130, 'Madagascar', 'Malagasy', 'MG', '+261', 'MGA', 'Malagasy ariary', 'Ar', 'Active', '2017-09-01 17:05:50'),
(131, 'Malawi', 'Malawian', 'MW', '+265', 'MWK', 'Malawian kwacha', 'MK', 'Active', '2017-09-01 17:05:50'),
(132, 'Malaysia', 'Malaysian', 'MY', '+60', 'MYR', 'Malaysian ringgit', 'RM', 'Active', '2017-09-01 17:05:50'),
(133, 'Maldives', 'Maldivan', 'MV', '+960', 'MVR', 'Maldivian rufiyaa', '.ރ', 'Active', '2017-09-01 17:05:50'),
(134, 'Mali', 'Malian', 'ML', '+223', 'XOF', 'West African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(135, 'Malta', 'Maltese', 'MT', '+356', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(136, 'Man (Isle of)', 'Zimbabwean', 'XM', '+44', '', '', '', 'Active', '2017-09-01 17:05:50'),
(137, 'Marshall Islands', 'Marshallese', 'MH', '+692', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(138, 'Martinique', 'French', 'MQ', '+596', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(139, 'Mauritania', 'Mauritanian', 'MR', '+222', 'MRO', 'Mauritanian ouguiya', 'UM', 'Active', '2017-09-01 17:05:50'),
(140, 'Mauritius', 'Mauritian', 'MU', '+230', 'MUR', 'Mauritian rupee', '₨', 'Active', '2017-09-01 17:05:50'),
(141, 'Mayotte', 'French', 'YT', '+262', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(142, 'Mexico', 'Mexican', 'MX', '+52', 'MXN', 'Mexican peso', '$', 'Active', '2017-09-01 17:05:50'),
(143, 'Micronesia', 'Micronesian', 'FM', '+691', '', '[D]', '$', 'Active', '2017-09-01 17:05:50'),
(144, 'Moldova', 'Moldovan', 'MD', '+373', 'MDL', 'Moldovan leu', 'L', 'Active', '2017-09-01 17:05:50'),
(145, 'Monaco', 'Monegasque', 'MC', '+377', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(146, 'Mongolia', 'Mongolian', 'MN', '+976', 'MNT', 'Mongolian tögrög', '₮', 'Active', '2017-09-01 17:05:50'),
(147, 'Montserrat', 'Montserratian', 'MS', '+1664', 'XCD', 'East Caribbean dollar', '$', 'Active', '2017-09-01 17:05:50'),
(148, 'Morocco', 'Moroccan', 'MA', '+212', 'MAD', 'Moroccan dirham', 'د.م.', 'Active', '2017-09-01 17:05:50'),
(149, 'Mozambique', 'Mozambican', 'MZ', '+258', 'MZN', 'Mozambican metical', 'MT', 'Active', '2017-09-01 17:05:50'),
(150, 'Myanmar', 'Burmese', 'MM', '+95', 'MMK', 'Burmese kyat', 'Ks', 'Active', '2017-09-01 17:05:50'),
(151, 'Namibia', 'Namibian', 'NA', '+264', 'NAD', 'Namibian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(152, 'Nauru', 'Nauruan', 'NR', '+674', 'AUD', 'Australian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(153, 'Nepal', 'Nepalese', 'NP', '+977', 'NPR', 'Nepalese rupee', '₨', 'Active', '2017-09-01 17:05:50'),
(154, 'Netherlands Antilles', 'Zimbabwean', 'AN', '+599', '', '', '', 'Active', '2017-09-01 17:05:50'),
(155, 'Netherlands The', 'Dutch', 'NL', '+31', '', '', '', 'Active', '2017-09-01 17:05:50'),
(156, 'New Caledonia', 'New Caledonian', 'NC', '+687', 'XPF', 'CFP franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(157, 'New Zealand', 'New Zealander', 'NZ', '+64', 'NZD', 'New Zealand dollar', '$', 'Active', '2017-09-01 17:05:50'),
(158, 'Nicaragua', 'Nicaraguan', 'NI', '+505', 'NIO', 'Nicaraguan córdoba', 'C$', 'Active', '2017-09-01 17:05:50'),
(159, 'Niger', 'Nigerien', 'NE', '+227', 'XOF', 'West African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(160, 'Nigeria', 'Nigerian', 'NG', '+234', 'NGN', 'Nigerian naira', '₦', 'Active', '2017-09-01 17:05:50'),
(161, 'Niue', 'Niuean', 'NU', '+683', 'NZD', 'New Zealand dollar', '$', 'Active', '2017-09-01 17:05:50'),
(162, 'Norfolk Island', 'Norfolk Islander', 'NF', '+672', 'AUD', 'Australian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(163, 'Northern Mariana Islands', 'American', 'MP', '+1670', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(164, 'Norway', 'Norwegian', 'NO', '+47', 'NOK', 'Norwegian krone', 'kr', 'Active', '2017-09-01 17:05:50'),
(165, 'Oman', 'Omani', 'OM', '+968', 'OMR', 'Omani rial', 'ر.ع.', 'Active', '2017-09-01 17:05:50'),
(166, 'Pakistan', 'Pakistani', 'PK', '+92', 'PKR', 'Pakistani rupee', '₨', 'Active', '2017-09-01 17:05:50'),
(167, 'Palau', 'Palauan', 'PW', '+680', '(none)', '[E]', '$', 'Active', '2017-09-01 17:05:50'),
(168, 'Palestinian Territory Occupied', 'Palestinian', 'PS', '+970', '', '', '', 'Active', '2017-09-01 17:05:50'),
(169, 'Panama', 'Panamanian', 'PA', '+507', 'PAB', 'Panamanian balboa', 'B/.', 'Active', '2017-09-01 17:05:50'),
(170, 'Papua new Guinea', 'Papua New Guinean', 'PG', '+675', 'PGK', 'Papua New Guinean kina', 'K', 'Active', '2017-09-01 17:05:50'),
(171, 'Paraguay', 'Paraguayan', 'PY', '+595', 'PYG', 'Paraguayan guaraní', '₲', 'Active', '2017-09-01 17:05:50'),
(172, 'Peru', 'Peruvian', 'PE', '+51', 'PEN', 'Peruvian sol', 'S/.', 'Active', '2017-09-01 17:05:50'),
(173, 'Philippines', 'Filipino', 'PH', '+63', 'PHP', 'Philippine peso', '₱', 'Active', '2017-09-01 17:05:50'),
(174, 'Pitcairn Island', 'Pitcairn Islander', 'PN', '+64', '', '', '', 'Active', '2017-09-01 17:05:50'),
(175, 'Poland', 'Polish', 'PL', '+48', 'PLN', 'Polish złoty', 'zł', 'Active', '2017-09-01 17:05:50'),
(176, 'Portugal', 'Portuguese', 'PT', '+351', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(177, 'Puerto Rico', 'Puerto Rican', 'PR', '+1787', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(178, 'Qatar', 'Qatari', 'QA', '+974', 'QAR', 'Qatari riyal', 'ر.ق', 'Active', '2017-09-01 17:05:50'),
(179, 'Reunion', 'French', 'RE', '+262', '', '', '', 'Active', '2017-09-01 17:05:50'),
(180, 'Romania', 'Romanian', 'RO', '+40', 'RON', 'Romanian leu', 'lei', 'Active', '2017-09-01 17:05:50'),
(181, 'Russia', 'Russian', 'RU', '+7', '', '', '', 'Active', '2017-09-01 17:05:50'),
(182, 'Rwanda', 'Rwandan', 'RW', '+250', 'RWF', 'Rwandan franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(183, 'Saint Helena', 'Saint Helenian', 'SH', '+290', 'SHP', 'Saint Helena pound', '£', 'Active', '2017-09-01 17:05:50'),
(184, 'Saint Kitts And Nevis', 'Kittian and Nevisian', 'KN', '+1869', 'XCD', 'East Caribbean dollar', '$', 'Active', '2017-09-01 17:05:50'),
(185, 'Saint Lucia', 'Saint Lucian', 'LC', '+1758', 'XCD', 'East Caribbean dollar', '$', 'Active', '2017-09-01 17:05:50'),
(186, 'Saint Pierre and Miquelon', 'French', 'PM', '+508', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(187, 'Saint Vincent And The Grenadines', 'Saint Vincentian', 'VC', '+1784', 'XCD', 'East Caribbean dollar', '$', 'Active', '2017-09-01 17:05:50'),
(188, 'Samoa', 'Samoan', 'WS', '+685', 'WST', 'Samoan tālā', 'T', 'Active', '2017-09-01 17:05:50'),
(189, 'San Marino', 'Sammarinese', 'SM', '+378', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(190, 'Sao Tome and Principe', 'Sao Tomean', 'ST', '+239', 'STD', 'São Tomé and Príncipe dobra', 'Db', 'Active', '2017-09-01 17:05:50'),
(191, 'Saudi Arabia', 'Saudi Arabian', 'SA', '+966', 'SAR', 'Saudi riyal', 'ر.س', 'Active', '2017-09-01 17:05:50'),
(192, 'Senegal', 'Senegalese', 'SN', '+221', 'XOF', 'West African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(193, 'Serbia', 'Serbian', 'RS', '+381', 'RSD', 'Serbian dinar', 'дин.', 'Active', '2017-09-01 17:05:50'),
(194, 'Seychelles', 'Seychellois', 'SC', '+248', 'SCR', 'Seychellois rupee', '₨', 'Active', '2017-09-01 17:05:50'),
(195, 'Sierra Leone', 'Sierra Leonean', 'SL', '+232', 'SLL', 'Sierra Leonean leone', 'Le', 'Active', '2017-09-01 17:05:50'),
(196, 'Singapore', 'Singaporean', 'SG', '+65', 'BND', 'Brunei dollar', '$', 'Active', '2017-09-01 17:05:50'),
(197, 'Slovakia', 'Slovak', 'SK', '+421', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(198, 'Slovenia', 'Slovene', 'SI', '+386', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(199, 'Smaller Territories of the UK', 'Zimbabwean', 'XG', '+44', '', '', '', 'Active', '2017-09-01 17:05:50'),
(200, 'Solomon Islands', 'Solomon Islander', 'SB', '+677', 'SBD', 'Solomon Islands dollar', '$', 'Active', '2017-09-01 17:05:50'),
(201, 'Somalia', 'Somali', 'SO', '+252', 'SOS', 'Somali shilling', 'Sh', 'Active', '2017-09-01 17:05:50'),
(202, 'South Africa', 'South African', 'ZA', '+27', 'ZAR', 'South African rand', 'R', 'Active', '2017-09-01 17:05:50'),
(203, 'South Georgia', 'South Georgia and the South Sandwich Islander', 'GS', '+500', 'GBP', 'British pound', '£', 'Active', '2017-09-01 17:05:50'),
(204, 'South Sudan', 'South Sudanese', 'SS', '+211', 'SSP', 'South Sudanese pound', '£', 'Active', '2017-09-01 17:05:50'),
(205, 'Spain', 'Spanish', 'ES', '+34', 'EUR', 'Euro', '€', 'Active', '2017-09-01 17:05:50'),
(206, 'Sri Lanka', 'Sri Lankan', 'LK', '+94', 'LKR', 'Sri Lankan rupee', 'Rs', 'Active', '2017-09-01 17:05:50'),
(207, 'Sudan', 'Sudanese', 'SD', '+249', 'SDG', 'Sudanese pound', 'ج.س.', 'Active', '2017-09-01 17:05:50'),
(208, 'Suriname', 'Surinamer', 'SR', '+597', 'SRD', 'Surinamese dollar', '$', 'Active', '2017-09-01 17:05:50'),
(209, 'Svalbard And Jan Mayen Islands', 'Norwegian', 'SJ', '+47', '', '', '', 'Active', '2017-09-01 17:05:50'),
(210, 'Swaziland', 'Swazi', 'SZ', '+268', 'SZL', 'Swazi lilangeni', 'L', 'Active', '2017-09-01 17:05:50'),
(211, 'Sweden', 'Swedish', 'SE', '+46', 'SEK', 'Swedish krona', 'kr', 'Active', '2017-09-01 17:05:50'),
(212, 'Switzerland', 'Swiss', 'CH', '+41', 'CHF', 'Swiss franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(213, 'Syria', 'Syrian', 'SY', '+963', 'SYP', 'Syrian pound', '£', 'Active', '2017-09-01 17:05:50'),
(214, 'Taiwan', 'Taiwanese', 'TW', '+886', 'TWD', 'New Taiwan dollar', '$', 'Active', '2017-09-01 17:05:50'),
(215, 'Tajikistan', 'Tadzhik', 'TJ', '+992', 'TJS', 'Tajikistani somoni', 'ЅМ', 'Active', '2017-09-01 17:05:50'),
(216, 'Tanzania', 'Tanzanian', 'TZ', '+255', 'TZS', 'Tanzanian shilling', 'Sh', 'Active', '2017-09-01 17:05:50'),
(217, 'Thailand', 'Thai', 'TH', '+66', 'THB', 'Thai baht', '฿', 'Active', '2017-09-01 17:05:50'),
(218, 'Togo', 'Togolese', 'TG', '+228', 'XOF', 'West African CFA franc', 'Fr', 'Active', '2017-09-01 17:05:50'),
(219, 'Tokelau', 'Tokelauan', 'TK', '+690', 'NZD', 'New Zealand dollar', '$', 'Active', '2017-09-01 17:05:50'),
(220, 'Tonga', 'Tongan', 'TO', '+676', 'TOP', 'Tongan paʻanga', 'T$', 'Active', '2017-09-01 17:05:50'),
(221, 'Trinidad And Tobago', 'Trinidadian', 'TT', '+1868', 'TTD', 'Trinidad and Tobago dollar', '$', 'Active', '2017-09-01 17:05:50'),
(222, 'Tunisia', 'Tunisian', 'TN', '+216', 'TND', 'Tunisian dinar', 'د.ت', 'Active', '2017-09-01 17:05:50'),
(223, 'Turkey', 'Turkish', 'TR', '+90', 'TRY', 'Turkish lira', '', 'Active', '2017-09-01 17:05:50'),
(224, 'Turkmenistan', 'Turkmen', 'TM', '+993', 'TMT', 'Turkmenistan manat', 'm', 'Active', '2017-09-01 17:05:50'),
(225, 'Turks And Caicos Islands', 'Turks and Caicos Islander', 'TC', '+1649', 'USD', 'United States dollar', '$', 'Active', '2017-09-01 17:05:50'),
(226, 'Tuvalu', 'Tuvaluan', 'TV', '+688', 'AUD', 'Australian dollar', '$', 'Active', '2017-09-01 17:05:50'),
(227, 'Uganda', 'Ugandan', 'UG', '+256', 'UGX', 'Ugandan shilling', 'Sh', 'Active', '2017-09-01 17:05:50'),
(228, 'Ukraine', 'Ukrainian', 'UA', '+380', 'UAH', 'Ukrainian hryvnia', '₴', 'Active', '2017-09-01 17:05:50'),
(229, 'United Arab Emirates', 'Emirati', 'AE', '+971', 'AED', 'United Arab Emirates dirham', 'د.إ', 'Active', '2017-09-01 17:05:50'),
(230, 'United Kingdom', 'British', 'GB', '+44', 'GBP', 'British pound', '£', 'Active', '2017-09-01 17:05:50'),
(231, 'United States', 'American', 'US', '+1', '', '', '', 'Inactive', '2017-09-01 17:05:50'),
(232, 'United States Minor Outlying Islands', 'American', 'UM', '', 'USD', 'United States Dollar', '$', '', '2017-09-01 17:05:50'),
(233, 'Uruguay', 'Uruguayan', 'UY', '+598', 'UYU', 'Uruguayan peso', '$', 'Active', '2017-09-01 17:05:50'),
(234, 'Uzbekistan', 'Uzbekistani', 'UZ', '+998', 'UZS', 'Uzbekistani so\'m', '', 'Active', '2017-09-01 17:05:50'),
(235, 'Vanuatu', 'Ni-Vanuatu', 'VU', '+678', 'VUV', 'Vanuatu vatu', 'Vt', 'Active', '2017-09-01 17:05:50'),
(236, 'Vatican City State (Holy See)', '', 'VA', '+379', '', '', '', '', '2017-09-01 17:05:50'),
(237, 'Venezuela', 'Venezuelan', 'VE', '+58', 'VEF', 'Venezuelan bolívar', 'Bs F', 'Active', '2017-09-01 17:05:50'),
(238, 'Vietnam', 'Vietnamese', 'VN', '84', 'VND', 'Vietnamese đồng', '₫', 'Active', '2017-09-01 17:05:50'),
(239, 'Virgin Islands (British)', 'Virgin Islander', 'VG', '+1284', '', '[D]', '$', 'Active', '2017-09-01 17:05:50'),
(240, 'Virgin Islands (US)', 'Virgin Islander', 'VI', '+340', '', '', '', 'Active', '2017-09-01 17:05:50'),
(241, 'Wallis And Futuna Islands', 'Wallis and Futuna Islander', 'WF', '+681', '', '', '', 'Active', '2017-09-01 17:05:50'),
(242, 'Western Sahara', 'Sahrawi', 'EH', '+212', 'MAD', 'Moroccan dirham', 'د.م.', 'Active', '2017-09-01 17:05:50'),
(243, 'Yemen', 'Yemeni', 'YE', '+967', 'YER', 'Yemeni rial', '﷼', 'Active', '2017-09-01 17:05:50'),
(244, 'Yugoslavia', 'Zimbabwean', 'YU', '+38', '', '', '', 'Active', '2017-09-01 17:05:50'),
(245, 'Zambia', 'Zambian', 'ZM', '+260', 'ZMW', 'Zambian kwacha', 'ZK', 'Active', '2017-09-01 17:05:50'),
(246, 'Zimbabwe', 'Zimbabwean', 'ZW', '+263', 'BWP', 'Botswana pula', 'P', 'Active', '2017-09-01 17:05:50'),
(247, 'ab', '', '', '', '', '', '', 'Deleted', '2019-11-14 13:40:13');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_faq`
--

CREATE TABLE `tbl_faq` (
  `id` bigint(20) NOT NULL,
  `en_question` text NOT NULL,
  `en_answer` text NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_faq`
--

INSERT INTO `tbl_faq` (`id`, `en_question`, `en_answer`, `is_active`, `insertdate`, `updatetime`) VALUES
(1, 'Will the stocks results I receive definitely go up?', 'No. We cannot guarantee the success of any investment, nor can anybody. Stock prices are subject to many external factors, including broad market conditions, as well as company-specific events and realities. It is imperative that you do further research, into all stocks you consider for your live portfolio, prior to investing. 3 Step Stocks is for informational purposes only, and does not purport to provide investing advice.', 1, '2020-04-15 13:21:12', '2020-07-08 02:35:57'),
(2, 'Does 3StepStocks deal with other investment vehicles, such as options?', 'No. 3StepStocks, as indicated by the name, deals only in investment vehicles commonly available on the major US indices. Though primarily stocks, the NYSE and Nasdaq also list exchange-traded-funds (ETFs) which consolidate more than one company under a single listing.', 1, '2020-04-18 07:29:22', '2020-07-08 02:37:59'),
(3, 'Which exchanges does 3StepStocks cover?', '3StepStocks deals exclusively with the NYSE, and the Nasdaq.', 1, '2020-04-18 07:29:38', '2020-07-08 02:38:50'),
(4, 'Will 3StepStocks link me up with a broker that will help me execute my investing decisions?', '3StepStocks will link you to some of today\'s most popular online brokerages, such as ETRADE and TD Ameritrade. Once on their website, you will be able to sign up and start to trade using their platform.', 1, '2020-04-18 07:32:18', '2020-07-08 02:40:24'),
(5, 'How does 3StepStocks\' algorithm work?', 'The answer is simple, and complicated. Based on the responses to the questions we ask, we screen for such variables as industry and risk factor to eliminate the companies which do not fit your unique investment profile. Risk factor, specifically, deals primarily with company size (market capitalization), with larger companies assumed to be less volatile, and small companies assumed to be more volatile.', 1, '2020-04-30 10:07:24', '2020-07-08 02:43:44');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_level`
--

CREATE TABLE `tbl_level` (
  `id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `description` text NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_medical_condition`
--

CREATE TABLE `tbl_medical_condition` (
  `id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_medical_condition`
--

INSERT INTO `tbl_medical_condition` (`id`, `name`, `status`, `insertdate`, `updatetime`) VALUES
(1, 'diebetes', 'Active', '2023-07-15 13:51:13', '2023-07-15 13:51:13');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_notification_list`
--

CREATE TABLE `tbl_notification_list` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `message` text NOT NULL,
  `subject` text NOT NULL,
  `is_unread` tinyint(1) NOT NULL DEFAULT 1,
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_notification_list`
--

INSERT INTO `tbl_notification_list` (`id`, `user_id`, `message`, `subject`, `is_unread`, `insertdate`, `updatetime`) VALUES
(2, 18, 'sss', 'sss', 1, '2020-04-22 06:56:53', '2020-04-22 06:56:53'),
(3, 3, 'dssdfdsfsd', 'sdfsdf', 1, '2020-04-30 10:57:44', '2020-04-30 10:57:44'),
(4, 7, 'dssdfdsfsd', 'sdfsdf', 1, '2020-04-30 10:57:44', '2020-04-30 10:57:44'),
(5, 16, 'dssdfdsfsd', 'sdfsdf', 1, '2020-04-30 10:57:44', '2020-04-30 10:57:44'),
(6, 15, 'dssdfdsfsd', 'sdfsdf', 1, '2020-04-30 10:57:44', '2020-04-30 10:57:44'),
(7, 5, 'Test Message', 'Test', 1, '2020-05-07 04:53:23', '2020-05-07 04:53:23'),
(9, 3, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(11, 2, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(13, 9, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(14, 10, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(15, 11, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(17, 6, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(18, 14, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(19, 18, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(20, 16, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(21, 15, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(22, 22, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(23, 21, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(24, 1, 'sfdfsdfdfdfdfdfdf', 'Test', 1, '2020-05-07 04:56:50', '2020-05-07 04:56:50'),
(25, 1, 'fgfgffgff', 'test', 1, '2020-05-12 07:25:25', '2020-05-12 07:25:25'),
(26, 2, 'fgfgffgff', 'test', 1, '2020-05-12 07:25:25', '2020-05-12 07:25:25'),
(27, 1, 'This is the test notifcation', 'Test Notification', 1, '2020-05-12 09:10:00', '2020-05-12 09:10:00'),
(28, 2, 'This is the test notifcation', 'Test Notification', 1, '2020-05-12 09:10:00', '2020-05-12 09:10:00'),
(29, 3, 'This is the test notifcation', 'Test Notification', 1, '2020-05-12 09:10:00', '2020-05-12 09:10:00'),
(30, 1, 'test', 'test', 1, '2020-05-12 10:20:11', '2020-05-12 10:20:11'),
(31, 2, 'test', 'test', 1, '2020-05-12 10:20:11', '2020-05-12 10:20:11'),
(32, 3, 'test', 'test', 1, '2020-05-12 10:20:11', '2020-05-12 10:20:11'),
(33, 1, 'Test', 'Test', 1, '2020-05-12 10:24:47', '2020-05-12 10:24:47'),
(34, 2, 'Test', 'Test', 1, '2020-05-12 10:24:47', '2020-05-12 10:24:47'),
(35, 3, 'Test', 'Test', 1, '2020-05-12 10:24:47', '2020-05-12 10:24:47'),
(36, 1, 'test message', 'test subject', 1, '2020-05-12 11:01:43', '2020-05-12 11:01:43'),
(37, 2, 'test message', 'test subject', 1, '2020-05-12 11:01:43', '2020-05-12 11:01:43'),
(38, 3, 'test message', 'test subject', 1, '2020-05-12 11:01:43', '2020-05-12 11:01:43'),
(39, 1, 'message', 'hello', 1, '2020-05-12 11:30:04', '2020-05-12 11:30:04'),
(40, 2, 'message', 'hello', 1, '2020-05-12 11:30:04', '2020-05-12 11:30:04'),
(41, 3, 'message', 'hello', 1, '2020-05-12 11:30:04', '2020-05-12 11:30:04'),
(42, 1, 'test message', 'test', 1, '2020-06-16 12:12:12', '2020-06-16 12:12:12'),
(43, 2, 'test message', 'test', 1, '2020-06-16 12:12:12', '2020-06-16 12:12:12'),
(44, 3, 'test message', 'test', 1, '2020-06-16 12:12:12', '2020-06-16 12:12:12'),
(45, 4, 'test message', 'test', 1, '2020-06-16 12:12:12', '2020-06-16 12:12:12'),
(46, 5, 'test message', 'test', 1, '2020-06-16 12:12:12', '2020-06-16 12:12:12'),
(47, 6, 'test message', 'test', 1, '2020-06-16 12:12:12', '2020-06-16 12:12:12'),
(48, 7, 'test message', 'test', 1, '2020-06-16 12:12:12', '2020-06-16 12:12:12'),
(49, 1, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(50, 2, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(51, 3, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(52, 4, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(53, 5, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(54, 6, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(55, 7, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(56, 8, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(57, 9, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(58, 10, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(59, 11, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(60, 12, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(61, 13, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36'),
(62, 14, 'Hello', 'Hi', 1, '2020-08-28 17:41:36', '2020-08-28 17:41:36');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_recipe`
--

CREATE TABLE `tbl_recipe` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `time` varchar(64) NOT NULL,
  `image` varchar(164) NOT NULL,
  `image_thumbnail` varchar(164) NOT NULL,
  `description` text NOT NULL,
  `image_type` varchar(2) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_recipe_favourite`
--

CREATE TABLE `tbl_recipe_favourite` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `recipe_id` int(11) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_recipe_ingredients`
--

CREATE TABLE `tbl_recipe_ingredients` (
  `id` int(11) NOT NULL,
  `recipe_id` int(11) NOT NULL,
  `ingredient_name` text NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_setting_details`
--

CREATE TABLE `tbl_setting_details` (
  `id` bigint(20) NOT NULL,
  `attribute_name` varchar(32) NOT NULL,
  `attribute_value` text NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_setting_details`
--

INSERT INTO `tbl_setting_details` (`id`, `attribute_name`, `attribute_value`, `is_active`, `insertdate`, `updatedate`) VALUES
(1, 'project_name', '3stepstocks', 1, '2017-06-04 08:43:45', '2020-04-15 10:33:38'),
(2, 'header_logo', 'logo.png', 1, '2017-06-04 08:44:05', '2017-06-04 08:44:05'),
(3, 'fav_icon', 'favicon.png', 1, '2017-06-04 08:44:05', '2017-08-24 11:36:35'),
(4, 'from_email', 'info@3stepstocks.com', 1, '2017-06-04 08:44:05', '2020-04-15 10:33:47'),
(5, 'fogot_password_limit', '12', 1, '2017-08-31 13:27:15', '2017-08-31 13:27:15'),
(6, 'description_1', 'I agree to 3 Step Stocks\' Terms of Service.', 1, '2020-04-21 08:40:04', '2020-05-11 11:02:41'),
(7, 'description_2', 'I would like to receive special investment research reports, and offers, from our analysts and affiliates', 1, '2020-04-21 08:40:29', '2020-05-11 11:02:41'),
(8, 'show_text_1', 'on', 1, '2020-04-21 09:55:17', '2020-05-12 06:25:18'),
(9, 'show_text_2', 'on', 1, '2020-04-21 09:55:17', '2020-07-16 16:15:25'),
(10, 'optional_checkbox_1', 'on', 1, '2020-04-21 15:25:17', '2020-07-16 16:15:02'),
(11, 'optional_checkbox_2', 'on', 1, '2020-04-21 15:25:17', '2020-07-16 16:15:25');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sub_category`
--

CREATE TABLE `tbl_sub_category` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `image` varchar(164) NOT NULL,
  `is_level` tinyint(1) NOT NULL DEFAULT 0,
  `is_tag` tinyint(1) NOT NULL DEFAULT 0,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_tags`
--

CREATE TABLE `tbl_tags` (
  `id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user`
--

CREATE TABLE `tbl_user` (
  `id` bigint(11) NOT NULL,
  `social_id` text NOT NULL,
  `email` varchar(128) NOT NULL,
  `bring_id` int(11) NOT NULL,
  `activity_level_id` int(11) NOT NULL,
  `profile_image` varchar(128) NOT NULL,
  `name` varchar(164) NOT NULL,
  `age` int(11) NOT NULL,
  `gender` smallint(1) NOT NULL DEFAULT 1 COMMENT '1->male,2->female',
  `dob` varchar(64) NOT NULL,
  `country_code` varchar(8) NOT NULL,
  `mobile_number` varchar(64) NOT NULL,
  `city_id` int(11) NOT NULL,
  `height` double(11,2) NOT NULL,
  `height_type` varchar(64) NOT NULL,
  `weight` double(11,2) NOT NULL,
  `weight_type` varchar(64) NOT NULL,
  `weight_goal` double(11,2) NOT NULL,
  `weight_goal_type` varchar(64) NOT NULL,
  `reach_your_goal` double(11,2) NOT NULL,
  `reach_your_goal_type` varchar(64) NOT NULL,
  `hours_sleep` double(11,2) NOT NULL,
  `hours_sleep_type` varchar(64) NOT NULL,
  `medical_condition_id` varchar(164) NOT NULL,
  `occupation` text NOT NULL,
  `signup_type` enum('Normal','Facebook','Google','Apple') NOT NULL DEFAULT 'Normal',
  `last_login` datetime NOT NULL,
  `login` enum('Offline','Online') NOT NULL,
  `is_verify` tinyint(1) NOT NULL DEFAULT 0,
  `is_premium` smallint(1) NOT NULL DEFAULT 0,
  `is_notification` smallint(1) NOT NULL DEFAULT 1,
  `start_date` varchar(164) NOT NULL,
  `end_date` varchar(164) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `referral_code` varchar(164) NOT NULL,
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`id`, `social_id`, `email`, `bring_id`, `activity_level_id`, `profile_image`, `name`, `age`, `gender`, `dob`, `country_code`, `mobile_number`, `city_id`, `height`, `height_type`, `weight`, `weight_type`, `weight_goal`, `weight_goal_type`, `reach_your_goal`, `reach_your_goal_type`, `hours_sleep`, `hours_sleep_type`, `medical_condition_id`, `occupation`, `signup_type`, `last_login`, `login`, `is_verify`, `is_premium`, `is_notification`, `start_date`, `end_date`, `status`, `referral_code`, `insertdate`, `updatetime`) VALUES
(1, '', 'jagdish@gmail.com', 1, 1, 'jaglish.png', 'jagdish dharviya', 28, 1, '15-01-1996', '+91', '9712734984', 1, 179.00, '', 70.00, '', 0.00, '', 0.00, '', 0.00, '', '', '', 'Normal', '2023-09-01 15:13:43', 'Online', 1, 0, 1, '', '', 'Active', '', '2023-09-01 14:40:39', '2023-09-01 14:40:39');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user_activity`
--

CREATE TABLE `tbl_user_activity` (
  `id` int(11) NOT NULL,
  `email` varchar(164) NOT NULL,
  `industries_id` int(11) NOT NULL,
  `risk_id` int(11) NOT NULL,
  `investment_goal` text NOT NULL,
  `checkbox_1` varchar(64) NOT NULL,
  `checkbox_2` varchar(64) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL,
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_user_activity`
--

INSERT INTO `tbl_user_activity` (`id`, `email`, `industries_id`, `risk_id`, `investment_goal`, `checkbox_1`, `checkbox_2`, `status`, `insertdate`) VALUES
(1, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-07 04:31:03'),
(2, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-07 04:50:09'),
(3, 'kuldipp@hyperlinkinfosystem.net.in', 6, 2, 'Growth', 'on', 'on', 'Active', '2020-07-07 04:50:50'),
(4, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-07 08:39:39'),
(5, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-07 10:59:24'),
(6, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-08 05:21:54'),
(7, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-08 05:27:07'),
(8, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-08 11:28:36'),
(9, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-09 04:28:33'),
(10, 'kuldipp@hyperlinkinfosystem.net.in', 4, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-09 05:38:46'),
(11, 't@gmail.com', 2, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-09 05:39:42'),
(12, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-09 09:08:00'),
(13, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-09 09:14:21'),
(14, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-09 09:26:08'),
(15, 'test@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-09 09:30:28'),
(16, 'aukoyfman@gmail.com', 7, 3, 'Growth', 'on', 'on', 'Active', '2020-07-09 18:12:33'),
(17, 'test@gmail.com', 12, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 05:10:24'),
(18, 'test@gmail.com', 16, 1, 'Growth', 'on', 'off', 'Active', '2020-07-10 06:51:22'),
(19, 'test@gmail.com', 1, 1, 'Growth', 'on', 'off', 'Active', '2020-07-10 07:05:57'),
(20, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 07:55:34'),
(21, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 08:06:10'),
(22, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 08:30:56'),
(23, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 08:31:39'),
(24, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 08:33:18'),
(25, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 08:41:56'),
(26, 'test@gmail.com', 16, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 08:56:02'),
(27, 'kuldipp@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 09:11:53'),
(28, 'kudipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 09:18:29'),
(29, 'kudipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 09:19:01'),
(30, 'kudipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-10 09:19:18'),
(31, 'test@kushal.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-11 05:42:21'),
(32, 'kuldipp@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-11 07:29:26'),
(33, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-13 08:01:55'),
(34, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-13 09:09:18'),
(35, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:26:51'),
(36, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:30:07'),
(37, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-13 09:33:17'),
(38, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:34:42'),
(39, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:40:47'),
(40, 'kuldipp@hyperlinkinfosystem.net.in', 3, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:45:15'),
(41, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:54:08'),
(42, 'kuldipp@hyperlinkinfosystem.net.in', 3, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:54:38'),
(43, 'kuldipp@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:54:58'),
(44, 'kuldipp@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 09:58:20'),
(45, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-13 10:24:04'),
(46, 'kushalm@hyperlinkinfosystem.net.in', 1, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-13 13:51:04'),
(47, 'kushalm@hyperlinkinfosystem.net.in', 1, 3, 'Wealth Preservation', 'on', 'on', 'Active', '2020-07-13 15:23:35'),
(48, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-14 04:57:04'),
(49, 'kuldipp@hyperlinkinfosystem.net.in', 14, 4, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-14 04:57:58'),
(50, 'kuldipp@hyperlinkinfosystem.net.in', 6, 1, 'Growth', 'on', 'on', 'Active', '2020-07-14 05:03:44'),
(51, 'monak@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 08:56:55'),
(52, 'kushalm@hyperlinkinfosystem.net.in', 1, 3, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-14 09:02:31'),
(53, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 09:55:50'),
(54, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 12:09:18'),
(55, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 13:09:04'),
(56, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 14:22:58'),
(57, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 14:25:20'),
(58, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 14:28:07'),
(59, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-14 14:34:19'),
(60, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-14 14:39:55'),
(61, 'kushalm@hyperlinkinfosystem.net.in', 2, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-14 14:46:32'),
(62, 'aukoyfman@gmail.com', 3, 2, 'Growth', 'on', 'on', 'Active', '2020-07-15 14:11:05'),
(63, 'aukoyfman@gmail.com', 3, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-15 14:11:29'),
(64, 'aukoyfman@gmail.com', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-15 14:11:42'),
(65, 'aukoyfman@gmail.com', 6, 1, 'Retirement Planning', 'on', 'off', 'Active', '2020-07-15 14:16:19'),
(66, 'kuldipp@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-16 04:58:03'),
(67, 'kushalm@hyperlinkinfosystem.net.in', 2, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-16 15:11:26'),
(68, 'aukoyfman@gmail.com', 14, 3, 'Growth', 'on', 'on', 'Active', '2020-07-16 16:18:01'),
(69, 'kuldipp@hyperlinkinfosystem.net.in', 2, 1, 'Retirement Planning', 'off', 'on', 'Active', '2020-07-17 04:57:29'),
(70, 'kuldipp@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'off', 'on', 'Active', '2020-07-17 05:03:34'),
(71, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-17 05:21:16'),
(72, 'kuldipp@hyperlinkinfosystem.net.in', 13, 3, 'Growth', 'off', 'on', 'Active', '2020-07-17 05:39:41'),
(73, 'kushalm@hyperlinkinfosystem.net.in', 14, 3, 'Growth', 'on', 'on', 'Active', '2020-07-17 12:23:53'),
(74, 'aukoyfman@gmail.com', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-22 14:56:27'),
(75, 'aukoyfman@gmail.com', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-22 14:56:34'),
(76, 'aukoyfman@Gmail.com', 5, 2, 'Growth', 'on', 'on', 'Active', '2020-07-26 13:33:12'),
(77, 'kuldipp@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-27 06:19:47'),
(78, 'kuldipp@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-27 06:20:51'),
(79, 'kuldipp@hyperlinkinfosystem.net.in', 14, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-07-27 06:29:06'),
(80, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 06:59:20'),
(81, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 07:06:09'),
(82, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 07:19:26'),
(83, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 08:06:21'),
(84, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 08:42:49'),
(85, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 08:58:46'),
(86, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:01:10'),
(87, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:03:45'),
(88, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:05:06'),
(89, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:12:56'),
(90, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:19:44'),
(91, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:36:04'),
(92, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:57:15'),
(93, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 09:59:01'),
(94, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:01:53'),
(95, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:02:56'),
(96, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:09:06'),
(97, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:11:38'),
(98, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:18:28'),
(99, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:21:01'),
(100, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:26:56'),
(101, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:37:45'),
(102, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:39:32'),
(103, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:46:18'),
(104, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:51:41'),
(105, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:54:39'),
(106, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 10:57:03'),
(107, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:00:52'),
(108, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:11:50'),
(109, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:15:01'),
(110, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:24:03'),
(111, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:26:30'),
(112, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:27:47'),
(113, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:33:55'),
(114, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:35:53'),
(115, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:39:49'),
(116, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 11:41:42'),
(117, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 12:51:53'),
(118, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 13:29:15'),
(119, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-04 14:50:25'),
(120, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 05:27:36'),
(121, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 05:39:23'),
(122, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 05:42:00'),
(123, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 05:43:11'),
(124, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 05:48:33'),
(125, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 05:54:35'),
(126, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 05:56:51'),
(127, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 06:27:54'),
(128, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 06:38:14'),
(129, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 08:43:43'),
(130, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 08:47:48'),
(131, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 08:49:22'),
(132, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 08:51:07'),
(133, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:00:22'),
(134, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:02:22'),
(135, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:06:49'),
(136, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:11:09'),
(137, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:12:25'),
(138, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:15:54'),
(139, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:20:29'),
(140, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 09:23:14'),
(141, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:19:41'),
(142, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:33:31'),
(143, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:36:33'),
(144, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:38:59'),
(145, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:40:19'),
(146, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:41:06'),
(147, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:44:38'),
(148, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:46:13'),
(149, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:48:47'),
(150, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 10:51:14'),
(151, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:13:13'),
(152, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:14:33'),
(153, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:21:44'),
(154, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:25:09'),
(155, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:29:01'),
(156, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:30:02'),
(157, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:33:28'),
(158, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:34:20'),
(159, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 12:35:56'),
(160, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 13:09:00'),
(161, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 13:59:11'),
(162, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 14:00:53'),
(163, 'kushalm@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-05 16:43:18'),
(164, 'aukoyfman@gmail.com', 6, 1, 'Growth', 'on', 'on', 'Active', '2020-08-05 22:21:42'),
(165, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:08:51'),
(166, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:10:30'),
(167, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:13:40'),
(168, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:33:21'),
(169, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:48:12'),
(170, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:52:36'),
(171, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:55:11'),
(172, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 05:58:16'),
(173, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 06:12:00'),
(174, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 06:19:27'),
(175, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 06:36:28'),
(176, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 06:45:56'),
(177, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 06:47:10'),
(178, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 06:49:01'),
(179, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 06:50:04'),
(180, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 07:01:04'),
(181, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 08:53:00'),
(182, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:04:27'),
(183, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:12:26'),
(184, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:15:51'),
(185, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:18:09'),
(186, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:20:57'),
(187, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:27:51'),
(188, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:29:56'),
(189, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 09:35:04'),
(190, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 12:15:45'),
(191, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 12:22:00'),
(192, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 12:37:08'),
(193, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 12:47:07'),
(194, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 12:54:20'),
(195, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 12:56:41'),
(196, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 13:00:53'),
(197, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 13:10:10'),
(198, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 13:20:49'),
(199, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 13:23:13'),
(200, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 13:27:47'),
(201, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-06 13:34:04'),
(202, 'aukoyfman@gmail.com', 9, 2, 'Growth', 'on', 'on', 'Active', '2020-08-06 16:29:47'),
(203, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-07 13:05:46'),
(204, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 07:50:12'),
(205, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 08:38:26'),
(206, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 08:57:31'),
(207, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:03:38'),
(208, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:07:02'),
(209, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:08:41'),
(210, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:10:43'),
(211, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:15:38'),
(212, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:22:24'),
(213, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:26:27'),
(214, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:30:21'),
(215, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:31:44'),
(216, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 09:38:10'),
(217, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 11:32:47'),
(218, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 12:54:54'),
(219, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 13:07:03'),
(220, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 13:09:01'),
(221, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 15:34:09'),
(222, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 15:45:09'),
(223, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 15:51:05'),
(224, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-08 15:52:32'),
(225, 'aukoyfman@gmail.com', 6, 2, 'Growth', 'on', 'on', 'Active', '2020-08-08 22:38:13'),
(226, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-12 04:45:00'),
(227, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-12 04:48:22'),
(228, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-12 04:49:52'),
(229, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-12 13:42:19'),
(230, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-12 14:20:06'),
(231, 'kushalm@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-12 14:39:14'),
(232, 'kushal0409@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-12 14:45:48'),
(233, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 05:08:26'),
(234, 'jagdishd@hyperlinkinfosytem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 05:28:28'),
(235, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 05:30:16'),
(236, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 11:36:32'),
(237, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 13:52:27'),
(238, 'kushal0409@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 14:15:33'),
(239, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 14:52:10'),
(240, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 15:03:54'),
(241, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 15:09:57'),
(242, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 15:13:11'),
(243, 'kushalm@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 17:08:03'),
(244, 'aukoyfman@gmail.com', 2, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-13 20:45:37'),
(245, 'aukoyfman@gmail.com', 14, 3, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-14 01:57:42'),
(246, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-14 04:29:18'),
(247, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-14 04:37:22'),
(248, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-14 04:42:22'),
(249, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Growth', 'on', 'on', 'Active', '2020-08-14 04:42:40'),
(250, 'ravipatel@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-14 04:42:51'),
(251, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 05:20:48'),
(252, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 06:19:46'),
(253, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 09:20:47'),
(254, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 09:36:56'),
(255, 'mkmk06524@gmail.com', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 11:35:21'),
(256, 'mkmk06524@gmail.com', 16, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 12:07:24'),
(257, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 13:14:01'),
(258, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-17 13:40:02'),
(259, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-18 04:44:57'),
(260, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 11:35:08'),
(261, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 11:37:37'),
(262, 'kushalm@hyperlinkinfosystem.net.in', 3, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 11:40:01'),
(263, 'kuldipp@hyperlinkinfosystem.net.in', 16, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 11:42:08'),
(264, 'kuldipp@hyperlinkinfosystem.net.in', 15, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 11:42:31'),
(265, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 11:58:28'),
(266, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 12:25:29'),
(267, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 12:29:51'),
(268, 'aukoyfman@gmail.com', 11, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 13:15:32'),
(269, 'aukoyfman@gmail.com', 11, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 13:15:37'),
(270, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 13:23:42'),
(271, 'kuldipp@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 15:34:32'),
(272, 'kuldipp@hyperlinkinfosystem.net.in', 14, 1, 'Growth', 'on', 'on', 'Active', '2020-08-19 15:34:46'),
(273, 'kuldipp@hyperlinkinfosystem.net.in', 14, 1, 'Wealth Preservation', 'on', 'on', 'Active', '2020-08-19 15:34:57'),
(274, 'kuldipp@hyperlinkinfosystem.net.in', 13, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 15:35:26'),
(275, 'kuldipp@hyperlinkinfosystem.net.in', 13, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 15:37:02'),
(276, 'mkmk06524@gmail.com', 13, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 16:08:05'),
(277, 'kushal0409@gmail.com', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-19 17:41:53'),
(278, 'mkmk06524@gmail.com', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 04:29:10'),
(279, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 04:33:41'),
(280, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 06:32:45'),
(281, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 06:41:13'),
(282, 'mkmk06524@gmail.com', 16, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 06:45:46'),
(283, 'mkmk06524@gmail.com', 16, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 06:47:35'),
(284, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 07:07:31'),
(285, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 08:03:25'),
(286, 'kushalm@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-20 09:50:32'),
(287, 'aukoyfman@gmail.com', 14, 1, 'Growth', 'on', 'on', 'Active', '2020-08-20 15:23:57'),
(288, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 05:22:16'),
(289, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 05:27:27'),
(290, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 05:31:47'),
(291, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 06:41:59'),
(292, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 07:23:52'),
(293, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 10:03:30'),
(294, 'kushalm@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 10:03:45'),
(295, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 10:28:17'),
(296, 'mkmk06524@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-21 13:01:25'),
(297, 'Aukoyfman@gmail.com', 7, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-22 15:00:54'),
(298, 'aukoyfman@gmail.com', 5, 1, 'Growth', 'on', 'on', 'Active', '2020-08-22 16:15:26'),
(299, 'aukoyfman@gmail.com', 4, 2, 'Growth', 'on', 'on', 'Active', '2020-08-23 04:01:18'),
(300, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-24 05:12:14'),
(301, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-25 05:05:48'),
(302, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-25 05:09:54'),
(303, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-25 05:14:30'),
(304, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-25 05:19:36'),
(305, 'kushalm@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-25 05:26:24'),
(306, 'kushalm@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-25 18:00:29'),
(307, 'kuldipp1995@gmail.com', 9, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 04:34:56'),
(308, 'kuldipp1995@gmail.com', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 04:55:14'),
(309, 'jagdishd@hyperlinkinfosystem.net.in', 14, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 05:40:48'),
(310, 'kushal0409@gmail.com', 11, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 06:26:20'),
(311, 'kuldipp1995@gmail.com', 3, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 06:28:30'),
(312, 'kuldipp1995@gmail.com', 3, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 06:33:55'),
(313, 'jagdishd@hyperlinkinfosystem.net.in', 2, 2, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 07:05:29'),
(314, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 08:41:51'),
(315, 'kuldipp@hyperlinkinfosystem.net.in', 16, 1, 'Retirement Planning', 'off', 'on', 'Active', '2020-08-26 09:01:57'),
(316, 'kuldipp@hyperlinkinfosystem.net.in', 16, 1, 'Growth', 'off', 'on', 'Active', '2020-08-26 09:02:03'),
(317, 'kuldipp@hyperlinkinfosystem.net.in', 16, 1, 'Wealth Preservation', 'off', 'on', 'Active', '2020-08-26 09:02:07'),
(318, 'kuldipp@hyperlinkinfosystem.net.in', 15, 1, 'Retirement Planning', 'off', 'on', 'Active', '2020-08-26 09:02:15'),
(319, 'kuldipp@hyperlinkinfosystem.net.in', 15, 3, 'Growth', 'off', 'on', 'Active', '2020-08-26 09:02:29'),
(320, 'kuldipp@hyperlinkinfosystem.net.in', 12, 2, 'Wealth Preservation', 'off', 'on', 'Active', '2020-08-26 09:02:49'),
(321, 'kushal0409@gmail.com', 15, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 09:11:47'),
(322, 'kuldipp@hyperlinkinfosystem.net.in', 9, 1, 'Retirement Planning', 'off', 'on', 'Active', '2020-08-26 09:21:54'),
(323, 'kuldipp@hyperlinkinfosystem.net.in', 3, 1, 'Retirement Planning', 'off', 'on', 'Active', '2020-08-26 09:22:43'),
(324, 'kuldipp@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'off', 'on', 'Active', '2020-08-26 09:22:58'),
(325, 'kuldipp1995@gmail.com', 2, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 09:28:15'),
(326, 'aukoyfman@gmail.com', 2, 2, 'Growth', 'on', 'on', 'Active', '2020-08-26 11:40:43'),
(327, 'aukoyfman@gmail.com', 2, 2, 'Growth', 'on', 'on', 'Active', '2020-08-26 11:40:48'),
(328, 'aukoyfman@gmail.com', 2, 2, 'Growth', 'on', 'on', 'Active', '2020-08-26 11:40:52'),
(329, 'jagdishd@hyperlinkinfosystem.net.in', 6, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-26 12:38:37'),
(330, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-27 12:02:07'),
(331, 'kushalm@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-27 12:17:46'),
(332, 'aukoyfman@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-27 14:50:52'),
(333, 'kushal0409@gmail.com', 2, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-27 15:57:09'),
(334, 'kushal0409@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-27 16:36:33'),
(335, 'kushal0409@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-27 16:38:30'),
(336, 'kushal0409@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-27 16:41:13'),
(337, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 03:11:23'),
(338, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 03:20:29'),
(339, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 05:05:36'),
(340, 'kushal0409@gmail.com', 5, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 14:31:06'),
(341, 'kuldipp@hyperlinkinfosystem.net.in', 3, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 14:34:55'),
(342, 'kuldipp@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 14:35:07'),
(343, 'kushalm@hyperlinkinfosystem.net.in', 4, 3, 'Growth', 'on', 'on', 'Active', '2020-08-28 14:41:51'),
(344, 'kushal0409@gmail.com', 3, 3, 'Wealth Preservation', 'on', 'on', 'Active', '2020-08-28 14:45:28'),
(345, 'kushal0409@gmail.com', 3, 2, 'Growth', 'on', 'on', 'Active', '2020-08-28 14:45:41'),
(346, 'kushal0409@gmail.com', 5, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 14:45:51'),
(347, 'kushal0409@gmail.com', 14, 3, 'Wealth Preservation', 'on', 'on', 'Active', '2020-08-28 14:46:13'),
(348, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 17:37:08'),
(349, 'kushal0409@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 17:38:55'),
(350, 'aukoyfman@gmail.com', 1, 3, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-28 17:52:47'),
(351, 'luke.burgess@angelpub.com', 16, 4, 'Growth', 'on', 'on', 'Active', '2020-08-28 18:04:29'),
(352, 'kushal0409@gmail.com', 6, 4, 'Growth', 'on', 'on', 'Active', '2020-08-28 18:07:42'),
(353, 'kyle@optipub.com', 14, 2, 'Growth', 'on', 'on', 'Active', '2020-08-28 18:16:32'),
(354, 'jason.freiert@gmail.com', 12, 4, 'Wealth Preservation', 'on', 'on', 'Active', '2020-08-28 20:09:32'),
(355, 'aukoyfman@gmail.com', 14, 3, 'Growth', 'on', 'on', 'Active', '2020-08-28 23:21:57'),
(356, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 04:58:59'),
(357, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 04:59:09'),
(358, 'kuldipp1995@gmail.com', 2, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 04:59:31'),
(359, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 05:42:52'),
(360, 'kuldipp1995@gmail.com', 1, 1, 'Growth', 'on', 'on', 'Active', '2020-08-29 06:24:41'),
(361, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 06:26:25'),
(362, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 06:35:17'),
(363, 'kuldipp1995@gmail.com', 1, 3, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 06:56:27'),
(364, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 08:37:40'),
(365, 'kuldipp1995@gmail.com', 1, 1, 'Wealth Preservation', 'on', 'on', 'Active', '2020-08-29 08:41:06'),
(366, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 08:53:57'),
(367, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 08:54:19'),
(368, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 08:55:22'),
(369, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 09:19:09'),
(370, 'kuldipp1995@gmail.com', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-29 09:19:48'),
(371, 'kushal0409@gmail.com', 15, 3, 'Wealth Preservation', 'on', 'on', 'Active', '2020-08-29 10:36:25'),
(372, 'aukoyfman@gmail.com', 6, 1, 'Growth', 'on', 'on', 'Active', '2020-08-31 14:58:34'),
(373, 'kushalm@hyperlinkinfosystem.net.in', 14, 3, 'Wealth Preservation', 'on', 'on', 'Active', '2020-08-31 15:05:51'),
(374, 'jagdishd@hyperlinkinfosystem.net.in', 5, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-08-31 15:41:08'),
(375, 'aukoyfman@gmail.com', 2, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-09-01 10:10:25'),
(376, 'jagdishd@hyperlinkinfosystem.net.in', 1, 1, 'Retirement Planning', 'on', 'on', 'Active', '2020-09-01 13:37:28');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_videos`
--

CREATE TABLE `tbl_videos` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `level_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  `name` varchar(164) NOT NULL,
  `description` text NOT NULL,
  `thumbnail` varchar(64) NOT NULL,
  `video_name` varchar(64) NOT NULL,
  `status` enum('Active','Inactive','Deleted') NOT NULL DEFAULT 'Active',
  `insertdate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_activity_level`
--
ALTER TABLE `tbl_activity_level`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_admin_menu`
--
ALTER TABLE `tbl_admin_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_admin_user_permissions`
--
ALTER TABLE `tbl_admin_user_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_blog`
--
ALTER TABLE `tbl_blog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_brings`
--
ALTER TABLE `tbl_brings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_category`
--
ALTER TABLE `tbl_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_cities`
--
ALTER TABLE `tbl_cities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_contact_details`
--
ALTER TABLE `tbl_contact_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_country`
--
ALTER TABLE `tbl_country`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_faq`
--
ALTER TABLE `tbl_faq`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_level`
--
ALTER TABLE `tbl_level`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_medical_condition`
--
ALTER TABLE `tbl_medical_condition`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_notification_list`
--
ALTER TABLE `tbl_notification_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_recipe`
--
ALTER TABLE `tbl_recipe`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_recipe_favourite`
--
ALTER TABLE `tbl_recipe_favourite`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_recipe_ingredients`
--
ALTER TABLE `tbl_recipe_ingredients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_setting_details`
--
ALTER TABLE `tbl_setting_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sub_category`
--
ALTER TABLE `tbl_sub_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_tags`
--
ALTER TABLE `tbl_tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_user`
--
ALTER TABLE `tbl_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_user_activity`
--
ALTER TABLE `tbl_user_activity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_videos`
--
ALTER TABLE `tbl_videos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_activity_level`
--
ALTER TABLE `tbl_activity_level`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_admin_menu`
--
ALTER TABLE `tbl_admin_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `tbl_admin_user_permissions`
--
ALTER TABLE `tbl_admin_user_permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `tbl_blog`
--
ALTER TABLE `tbl_blog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_brings`
--
ALTER TABLE `tbl_brings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_cities`
--
ALTER TABLE `tbl_cities`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_contact_details`
--
ALTER TABLE `tbl_contact_details`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `tbl_country`
--
ALTER TABLE `tbl_country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=248;

--
-- AUTO_INCREMENT for table `tbl_faq`
--
ALTER TABLE `tbl_faq`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_medical_condition`
--
ALTER TABLE `tbl_medical_condition`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_notification_list`
--
ALTER TABLE `tbl_notification_list`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `tbl_recipe`
--
ALTER TABLE `tbl_recipe`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_recipe_favourite`
--
ALTER TABLE `tbl_recipe_favourite`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_recipe_ingredients`
--
ALTER TABLE `tbl_recipe_ingredients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_setting_details`
--
ALTER TABLE `tbl_setting_details`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tbl_tags`
--
ALTER TABLE `tbl_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_user`
--
ALTER TABLE `tbl_user`
  MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_user_activity`
--
ALTER TABLE `tbl_user_activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=377;

--
-- AUTO_INCREMENT for table `tbl_videos`
--
ALTER TABLE `tbl_videos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

