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

START TRANSACTION;



--
-- Database: `devmindz_updated_shipjunction`
--

DELIMITER $$
END$$
 END$$

DELIMITER ;

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

--
-- Table structure for table `Sj_account_details`
--

CREATE TABLE `Sj_account_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) NOT NULL,
  `pan_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gstin_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_suffix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `beneficiary_account_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `beneficiary_account_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `beneficiary_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ifsc_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_pic` bigint(20) UNSIGNED DEFAULT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT 0,
  `reason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bankverified` tinyint(1) NOT NULL DEFAULT 0,
  `bankreason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_account_details`
--

INSERT INTO `Sj_account_details` (`id`, `company_id`, `user_id`, `pan_number`, `gstin_no`, `invoice_prefix`, `invoice_suffix`, `signature`, `beneficiary_account_no`, `beneficiary_account_type`, `beneficiary_name`, `ifsc_code`, `cheque_pic`, `verified`, `reason`, `bankverified`, `bankreason`, `created_at`, `updated_at`) VALUES
(1, '1', 1, 'AAAPL1234C', '22AAAAA0000A1Z5', 'test', 'as', '2', 'enfjwefnj', 'Current Account', 'nrjfnerjfnejrfnjernfnj', 'frefjrnfjnf', 3, 0, 'fadfdafasfasfafafafafasfasrtetretretretretret', 0, 'sdfdafadfadfafretretretertre', '2019-03-07 11:34:02', '2019-04-05 13:34:52'),
(2, '1', 1, '1234567890', 'Gst1234567890', '001', 'Ser', '1', '12354789024', 'Saving Account', 'Mohit Arora', '98765432102', 1, 0, NULL, 0, NULL, '2019-03-08 18:24:08', '2019-03-08 18:24:08'),
(3, '1', 1, '1234567890', 'Gst1234567890', '001', 'Ser', '1', '12354789024', 'Saving Account', 'Mohit Arora', '98765432102', 1, 0, NULL, 0, NULL, '2019-03-08 18:24:31', '2019-03-08 18:24:31'),
(4, '1', 1, '1234567890', 'Gst1234567890', '001', 'Ser', '22', '12354789024', 'Saving Account', 'Mohit Arora', '98765432102', 23, 0, NULL, 0, NULL, '2019-03-08 18:25:09', '2019-03-08 18:25:09'),
(5, '2', 2, '1234567890', 'Gst1234567890', '0011111', 'Ser1111111', '76', '12354789024', 'Saving Account', 'Mohit Arora', '98765432102', 64, 0, NULL, 0, NULL, '2019-03-08 18:25:24', '2019-03-11 19:22:05'),
(6, '3', 3, NULL, NULL, '1', 'Br1', '74', '12354789024', 'Saving Account', 'Mohit Arora', '98765432102', 75, 0, NULL, 0, NULL, '2019-03-11 19:19:12', '2019-03-11 19:19:44'),
(7, '1', 1, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 1, 0, NULL, 0, NULL, '2019-03-11 19:39:42', '2019-03-11 19:39:42'),
(8, '1', 1, '102', NULL, NULL, NULL, '1', NULL, 'Current Account', NULL, '98765432102', 1, 0, NULL, 0, NULL, '2019-03-11 19:39:53', '2019-03-11 19:39:53'),
(9, '1', 1, '1021121212', NULL, NULL, NULL, '1', NULL, 'Current Account', NULL, '98765432102', 1, 0, NULL, 0, NULL, '2019-03-11 19:40:01', '2019-03-11 19:40:01'),
(10, '1', 1, NULL, NULL, NULL, NULL, '1', NULL, 'Current Account', NULL, '98765432102', 1, 0, NULL, 0, NULL, '2019-03-11 19:40:08', '2019-03-11 19:40:08'),
(11, '1', 1, '122', NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 1, 0, NULL, 0, NULL, '2019-03-11 19:40:20', '2019-03-11 19:40:20'),
(13, '9', 7, 'AJZPA8856A', 'sadsad', 'dfsdfsdfsdf', 'sdadsaasASAS', '88', '1111111111', 'Saving Account', 'asd', 'sbioooo1', 89, 1, NULL, 0, 'werwerwerwerwerwer', '2019-04-08 05:59:03', '2019-04-08 08:12:23');

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

--
-- Table structure for table `Sj_addresses`
--

CREATE TABLE `Sj_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) DEFAULT NULL,
  `shipping_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_address_two` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_zipcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_address_two` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_zipcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_addresses`
--

INSERT INTO `Sj_addresses` (`id`, `company_id`, `user_id`, `shipping_address`, `shipping_address_two`, `shipping_city`, `shipping_state`, `shipping_zipcode`, `shipping_contact`, `billing_address`, `billing_address_two`, `billing_city`, `billing_state`, `billing_zipcode`, `billing_contact`, `created_at`, `updated_at`) VALUES
(2, '2', 2, 'adsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf', NULL, 'jaipur', '70', '302010', '5824251424', 'adsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf', NULL, 'jaipur', '70', '302010', '5824251424', '2019-03-11 16:11:26', '2019-03-11 16:19:58'),
(3, '1', 1, 'Vashali Nagar jaipur', NULL, 'jaipur', '70', '302033', '8005937903', 'Vashali Nagar jaipur', NULL, 'jaipur', '70', '302033', '8005937903', '2019-03-11 17:30:20', '2019-03-12 09:05:29'),
(4, '3', 3, 'Vashali Nagar jaipur, Vashali Nagar Second jaipur', NULL, 'jaipur', '54', '302034', '8005937903', 'Vashali Nagar jaipur, Vashali Nagar Second jaipur', NULL, 'jaipur', '54', '302034', '8005937903', '2019-03-11 19:09:15', '2019-03-11 19:09:15'),
(6, '9', 7, 'sad, sdadsa, sdadsa, sda, sdadsaasASAS, sdadsaasASAS', 'sdadsaasASAS', 'asdsad', '38', '324411', '3423411111', 'sad, sdadsa, sdadsa, sda, sdadsaasASAS, sdadsaasASAS', 'sdadsaasASAS', 'asdsad', '38', '324411', '3423411111', '2019-04-08 05:58:07', '2019-04-08 05:58:07');

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

--
-- Table structure for table `Sj_companies`
--

CREATE TABLE `Sj_companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `organization` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` bigint(20) UNSIGNED DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zipcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` bigint(20) DEFAULT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT 0,
  `wallet` float NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_companies`
--

INSERT INTO `Sj_companies` (`id`, `organization`, `url`, `email`, `logo`, `address`, `city`, `state`, `zipcode`, `phone`, `verified`, `wallet`, `created_at`, `updated_at`) VALUES
(1, 'vellebrother', 'http://192.168.0.93/shipjunction', 'mohitarora@marketingmindz.in', 85, NULL, NULL, NULL, NULL, NULL, 0, 280, NULL, '2019-04-13 12:49:47'),
(3, 'techcreater', 'http://192.168.0.93/shipjunction', 'tarunjains@marketingmindz.in', 67, NULL, NULL, NULL, NULL, NULL, 0, 0, '2019-03-11 19:05:39', '2019-03-11 19:09:00'),
(5, 'Ship junction', 'http://127.0.0.1:8000/company/d', 'ashok@marketingmindz.in', 96, NULL, NULL, NULL, NULL, NULL, 0, 12640, '2019-04-04 06:29:30', '2019-04-13 09:53:12');

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

--
-- Table structure for table `Sj_courier_awb_series`
--

CREATE TABLE `Sj_courier_awb_series` (
  `id` int(11) NOT NULL,
  `courier_id` int(11) DEFAULT NULL,
  `awb_series_start` varchar(255) DEFAULT NULL,
  `awb_series_end` varchar(255) DEFAULT NULL,
  `last_used` varchar(255) DEFAULT NULL,
  `expiry_date` datetime DEFAULT NULL,
  `batch_id` varchar(255) DEFAULT NULL,
  `awb_genrate_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sj_courier_awb_series`
--

INSERT INTO `Sj_courier_awb_series` (`id`, `courier_id`, `awb_series_start`, `awb_series_end`, `last_used`, `expiry_date`, `batch_id`, `awb_genrate_date`) VALUES
(1, 1, '141008196400000', '141008196499999', '141008196400012', NULL, 'Dsq69e1008', '2019-04-12 05:53:36');

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

--
-- Table structure for table `Sj_courier_priority`
--

CREATE TABLE `Sj_courier_priority` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` int(20) NOT NULL,
  `priority` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Aramex` int(1) NOT NULL,
  `BlueDart` int(2) NOT NULL,
  `Dehlivery` int(3) NOT NULL,
  `Dtdc` int(4) NOT NULL,
  `EcomExpress` int(5) NOT NULL,
  `FedEx` int(6) NOT NULL,
  `Gati` int(7) NOT NULL,
  `XpreeBee` int(8) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Sj_courier_selection`
--

CREATE TABLE `Sj_courier_selection` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` int(20) NOT NULL,
  `Aramex` tinyint(1) NOT NULL DEFAULT 0,
  `BlueDart` tinyint(1) NOT NULL DEFAULT 0,
  `Dehlivery` tinyint(1) NOT NULL DEFAULT 0,
  `Dtdc` tinyint(1) NOT NULL DEFAULT 0,
  `EcomExpress` tinyint(1) NOT NULL DEFAULT 0,
  `FedEx` tinyint(1) NOT NULL DEFAULT 0,
  `Gati` tinyint(1) NOT NULL DEFAULT 0,
  `XpreeBee` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Sj_galleries`
--

CREATE TABLE `Sj_galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_galleries`
--

INSERT INTO `Sj_galleries` (`id`, `path`, `created_at`, `updated_at`) VALUES
(1, '/uploads/logo/1551938679.jpeg', '2019-03-07 11:04:39', '2019-03-07 11:04:39'),
(2, '/uploads/signature/1551940442.jpeg', '2019-03-07 11:34:02', '2019-03-07 11:34:02'),
(3, '/uploads/cheque_pic/1551940442.jpeg', '2019-03-07 11:34:02', '2019-03-07 11:34:02'),
(4, '/uploads/kyc/1551945891.png', '2019-03-07 13:04:51', '2019-03-07 13:04:51'),
(5, '/uploads/address/1551945891.png', '2019-03-07 13:04:51', '2019-03-07 13:04:51'),
(6, '/uploads/logo/1551952186.png', '2019-03-07 14:49:46', '2019-03-07 14:49:46'),
(7, '/uploads/logo/1551952674.jpeg', '2019-03-07 14:57:54', '2019-03-07 14:57:54'),
(8, '/uploads/logo/1551952687.png', '2019-03-07 14:58:07', '2019-03-07 14:58:07'),
(9, '/uploads/logo/1551954612.jpeg', '2019-03-07 15:30:12', '2019-03-07 15:30:12'),
(10, '/uploads/logo/1552022533.jpg', '2019-03-08 10:22:13', '2019-03-08 10:22:13'),
(11, '/uploads/logo/1552022577.png', '2019-03-08 10:22:57', '2019-03-08 10:22:57'),
(12, '/uploads/signature/1552023167.png', '2019-03-08 10:32:47', '2019-03-08 10:32:47'),
(13, '/uploads/kyc/1552023670.png', '2019-03-08 10:41:10', '2019-03-08 10:41:10'),
(14, '/uploads/address/1552023670.png', '2019-03-08 10:41:10', '2019-03-08 10:41:10'),
(15, '/uploads/kyc/1552023682.png', '2019-03-08 10:41:22', '2019-03-08 10:41:22'),
(16, '/uploads/address/1552023682.png', '2019-03-08 10:41:22', '2019-03-08 10:41:22'),
(17, '/uploads/kyc/1552023684.png', '2019-03-08 10:41:24', '2019-03-08 10:41:24'),
(18, '/uploads/address/1552023684.png', '2019-03-08 10:41:24', '2019-03-08 10:41:24'),
(19, '/uploads/address/1552023703.png', '2019-03-08 10:41:43', '2019-03-08 10:41:43'),
(20, '/uploads/address/1552023768.png', '2019-03-08 10:42:48', '2019-03-08 10:42:48'),
(21, '/uploads/address/1552023769.png', '2019-03-08 10:42:49', '2019-03-08 10:42:49'),
(22, '/uploads/signature/1552051509.png', '2019-03-08 18:25:09', '2019-03-08 18:25:09'),
(23, '/uploads/cheque_pic/1552051509.jpeg', '2019-03-08 18:25:09', '2019-03-08 18:25:09'),
(24, '/uploads/signature/1552051524.jpeg', '2019-03-08 18:25:24', '2019-03-08 18:25:24'),
(25, '/uploads/cheque_pic/1552051524.jpg', '2019-03-08 18:25:24', '2019-03-08 18:25:24'),
(26, '/uploads/logo/1552052261.jpeg', '2019-03-08 18:37:41', '2019-03-08 18:37:41'),
(27, '/uploads/logo/1552289361.png', '2019-03-11 11:29:21', '2019-03-11 11:29:21'),
(28, '/uploads/logo/1552297874.jpeg', '2019-03-11 13:51:14', '2019-03-11 13:51:14'),
(29, '/uploads/kyc/1552305517.jpeg', '2019-03-11 15:58:37', '2019-03-11 15:58:37'),
(30, '/uploads/address/1552305517.png', '2019-03-11 15:58:37', '2019-03-11 15:58:37'),
(31, '/uploads/kyc/1552305649.jpeg', '2019-03-11 16:00:49', '2019-03-11 16:00:49'),
(32, '/uploads/address/1552305649.png', '2019-03-11 16:00:49', '2019-03-11 16:00:49'),
(33, '/uploads/kyc/1552305658.jpeg', '2019-03-11 16:00:58', '2019-03-11 16:00:58'),
(34, '/uploads/address/1552305658.png', '2019-03-11 16:00:58', '2019-03-11 16:00:58'),
(35, '/uploads/kyc/1552305752.jpeg', '2019-03-11 16:02:32', '2019-03-11 16:02:32'),
(36, '/uploads/address/1552305752.png', '2019-03-11 16:02:32', '2019-03-11 16:02:32'),
(37, '/uploads/kyc/1552305763.jpeg', '2019-03-11 16:02:43', '2019-03-11 16:02:43'),
(38, '/uploads/address/1552305763.png', '2019-03-11 16:02:43', '2019-03-11 16:02:43'),
(39, '/uploads/kyc/1552305850.png', '2019-03-11 16:04:10', '2019-03-11 16:04:10'),
(40, '/uploads/address/1552305850.png', '2019-03-11 16:04:10', '2019-03-11 16:04:10'),
(41, '/uploads/logo/1552306052.png', '2019-03-11 16:07:32', '2019-03-11 16:07:32'),
(42, '/uploads/logo/1552306087.png', '2019-03-11 16:08:07', '2019-03-11 16:08:07'),
(43, '/uploads/kyc/1552306314.jpeg', '2019-03-11 16:11:54', '2019-03-11 16:11:54'),
(44, '/uploads/address/1552306314.png', '2019-03-11 16:11:54', '2019-03-11 16:11:54'),
(45, '/uploads/logo/1552307075.png', '2019-03-11 16:24:35', '2019-03-11 16:24:35'),
(46, '/uploads/kyc/1552310465.jpeg', '2019-03-11 17:21:05', '2019-03-11 17:21:05'),
(47, '/uploads/address/1552310465.png', '2019-03-11 17:21:05', '2019-03-11 17:21:05'),
(48, '/uploads/logo/1552311008.png', '2019-03-11 17:30:08', '2019-03-11 17:30:08'),
(49, '/uploads/kyc/1552312331.png', '2019-03-11 17:52:11', '2019-03-11 17:52:11'),
(50, '/uploads/address/1552312331.jpeg', '2019-03-11 17:52:11', '2019-03-11 17:52:11'),
(51, '/uploads/signature/1552312514.png', '2019-03-11 17:55:14', '2019-03-11 17:55:14'),
(52, '/uploads/cheque_pic/1552312514.png', '2019-03-11 17:55:14', '2019-03-11 17:55:14'),
(53, '/uploads/signature/1552312599.png', '2019-03-11 17:56:39', '2019-03-11 17:56:39'),
(54, '/uploads/signature/1552312743.png', '2019-03-11 17:59:03', '2019-03-11 17:59:03'),
(55, '/uploads/cheque_pic/1552312835.png', '2019-03-11 18:00:35', '2019-03-11 18:00:35'),
(56, '/uploads/kyc/1552313053.jpeg', '2019-03-11 18:04:13', '2019-03-11 18:04:13'),
(57, '/uploads/address/1552313053.jpg', '2019-03-11 18:04:13', '2019-03-11 18:04:13'),
(58, '/uploads/kyc/1552313281.png', '2019-03-11 18:08:01', '2019-03-11 18:08:01'),
(59, '/uploads/address/1552313281.png', '2019-03-11 18:08:01', '2019-03-11 18:08:01'),
(60, '/uploads/kyc/1552313480.png', '2019-03-11 18:11:20', '2019-03-11 18:11:20'),
(61, '/uploads/address/1552313480.jpg', '2019-03-11 18:11:20', '2019-03-11 18:11:20'),
(62, '/uploads/kyc/1552313699.png', '2019-03-11 18:14:59', '2019-03-11 18:14:59'),
(63, '/uploads/address/1552313699.jpeg', '2019-03-11 18:14:59', '2019-03-11 18:14:59'),
(64, '/uploads/cheque_pic/1552316640.png', '2019-03-11 19:04:00', '2019-03-11 19:04:00'),
(65, '/uploads/kyc/1552316701.png', '2019-03-11 19:05:01', '2019-03-11 19:05:01'),
(66, '/uploads/address/1552316701.png', '2019-03-11 19:05:01', '2019-03-11 19:05:01'),
(67, '/uploads/logo/1552316939.png', '2019-03-11 19:08:59', '2019-03-11 19:08:59'),
(68, '/uploads/kyc/1552317070.png', '2019-03-11 19:11:10', '2019-03-11 19:11:10'),
(69, '/uploads/address/1552317070.png', '2019-03-11 19:11:10', '2019-03-11 19:11:10'),
(70, '/uploads/kyc/1552317145.png', '2019-03-11 19:12:25', '2019-03-11 19:12:25'),
(71, '/uploads/address/1552317145.png', '2019-03-11 19:12:25', '2019-03-11 19:12:25'),
(72, '/uploads/kyc/1552317159.png', '2019-03-11 19:12:39', '2019-03-11 19:12:39'),
(73, '/uploads/address/1552317159.png', '2019-03-11 19:12:39', '2019-03-11 19:12:39'),
(74, '/uploads/signature/1552317552.png', '2019-03-11 19:19:12', '2019-03-11 19:19:12'),
(75, '/uploads/cheque_pic/1552317552.jpeg', '2019-03-11 19:19:12', '2019-03-11 19:19:12'),
(76, '/uploads/signature/1552317725.png', '2019-03-11 19:22:05', '2019-03-11 19:22:05'),
(77, '/uploads/kyc/1552317829.png', '2019-03-11 19:23:49', '2019-03-11 19:23:49'),
(78, '/uploads/address/1552317829.png', '2019-03-11 19:23:49', '2019-03-11 19:23:49'),
(79, '/uploads/kyc/1552317882.png', '2019-03-11 19:24:42', '2019-03-11 19:24:42'),
(80, '/uploads/address/1552317882.png', '2019-03-11 19:24:42', '2019-03-11 19:24:42'),
(81, '/uploads/kyc/1552318023.png', '2019-03-11 19:27:03', '2019-03-11 19:27:03'),
(82, '/uploads/address/1552318023.png', '2019-03-11 19:27:03', '2019-03-11 19:27:03'),
(83, '/uploads/kyc/1552318085.png', '2019-03-11 19:28:05', '2019-03-11 19:28:05'),
(84, '/uploads/address/1552318085.png', '2019-03-11 19:28:05', '2019-03-11 19:28:05'),
(85, '/uploads/logo/1552367098.png', '2019-03-12 09:04:58', '2019-03-12 09:04:58'),
(86, '/uploads/signature/1554702510.png', '2019-04-08 05:48:30', '2019-04-08 05:48:30'),
(87, '/uploads/cheque_pic/1554702510.png', '2019-04-08 05:48:30', '2019-04-08 05:48:30'),
(88, '/uploads/signature/1554703143.png', '2019-04-08 05:59:03', '2019-04-08 05:59:03'),
(89, '/uploads/cheque_pic/1554703143.png', '2019-04-08 05:59:03', '2019-04-08 05:59:03'),
(90, '/uploads/kyc/53017_1554705469.png', '2019-04-08 06:37:49', '2019-04-08 06:37:49'),
(91, '/uploads/address/90833_1554705470.png', '2019-04-08 06:37:50', '2019-04-08 06:37:50'),
(92, '/uploads/kyc/25891_1554705519.png', '2019-04-08 06:38:39', '2019-04-08 06:38:39'),
(93, '/uploads/address/79364_1554705519.png', '2019-04-08 06:38:39', '2019-04-08 06:38:39'),
(94, '/uploads/kyc/69935_1554705554.png', '2019-04-08 06:39:14', '2019-04-08 06:39:14'),
(95, '/uploads/address/49034_1554705554.png', '2019-04-08 06:39:14', '2019-04-08 06:39:14'),
(96, '/uploads/logo/1554986960.png', '2019-04-11 12:49:20', '2019-04-11 12:49:20');

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

--
-- Table structure for table `Sj_kyc_details`
--

CREATE TABLE `Sj_kyc_details` (
  `id` int(10) UNSIGNED NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pan_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pan_image` bigint(20) UNSIGNED NOT NULL,
  `address_proff` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_proff_pic` bigint(20) UNSIGNED NOT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT 0,
  `reason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `panverified` tinyint(1) NOT NULL DEFAULT 0,
  `panreason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_kyc_details`
--

INSERT INTO `Sj_kyc_details` (`id`, `company_id`, `pan_number`, `pan_image`, `address_proff`, `address_proff_pic`, `verified`, `reason`, `panverified`, `panreason`, `created_at`, `updated_at`) VALUES
(6, '1', 'AAPFA3421J', 39, 'Electricity bill', 40, 1, 'sdsadasda', 0, NULL, '2019-03-11 16:04:10', '2019-04-05 13:35:51'),
(12, '3', 'AJZPA8856A', 72, 'Company Incorporation document', 73, 0, NULL, 0, NULL, '2019-03-11 19:12:39', '2019-03-11 19:12:39'),
(13, '2', 'AJZPA8856A', 83, 'Electricity bill', 84, 0, NULL, 0, NULL, '2019-03-11 19:28:05', '2019-03-11 19:28:05'),
(14, '9', 'AJZPA8856A', 94, 'Landline postpaid bill', 95, 0, 'dsfsdfdsfsdfsdfsdf', 0, 'dsfsdfdsfsdfsd', '2019-04-08 06:39:14', '2019-04-08 06:47:09');

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

--
-- Table structure for table `Sj_label__settings`
--

CREATE TABLE `Sj_label__settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) NOT NULL,
  `format` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Order_COD_Prepaid` tinyint(1) NOT NULL,
  `Shippers_Mobile` tinyint(1) NOT NULL,
  `Shipper_Address` tinyint(1) NOT NULL,
  `Buyer_sms` tinyint(1) NOT NULL,
  `Buyer_Mobile` tinyint(1) NOT NULL,
  `Buyer_Email` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_label__settings`
--

INSERT INTO `Sj_label__settings` (`id`, `company_id`, `user_id`, `format`, `Order_COD_Prepaid`, `Shippers_Mobile`, `Shipper_Address`, `Buyer_sms`, `Buyer_Mobile`, `Buyer_Email`, `created_at`, `updated_at`) VALUES
(1, '1', 1, 'Old Format', 1, 1, 1, 1, 1, 1, '2019-03-09 02:29:03', '2019-03-12 09:54:57'),
(11, '2', 2, 'New Format', 1, 1, 1, 0, 0, 1, '2019-03-11 10:53:20', '2019-03-11 17:38:31'),
(12, '3', 3, 'Old Format', 1, 1, 0, 1, 1, 1, '2019-03-11 19:20:36', '2019-03-11 19:20:36');

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

--
-- Table structure for table `Sj_migrations`
--

CREATE TABLE `Sj_migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Sj_orders`
--

CREATE TABLE `Sj_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) DEFAULT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` bigint(50) NOT NULL,
  `order_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prices_include_tax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(50) NOT NULL,
  `discount_total` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_total` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_tax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_orders`
--

INSERT INTO `Sj_orders` (`id`, `store_id`, `company_id`, `order_id`, `order_number`, `order_status`, `order_currency`, `prices_include_tax`, `user_id`, `discount_total`, `shipping_total`, `total`, `total_tax`, `order_date`, `payment_method`, `created_at`, `updated_at`) VALUES
(1, 2, '1', 1001, '911396536382', 'complete', 'USD', '10.00', 1, NULL, NULL, '10.00', '0.00', '2019-03-27 07:37:02', 'COD', '2019-04-08 07:51:56', '2019-04-08 07:51:56'),
(2, 2, '1', 1002, '911396569150', 'refund', 'USD', '12.00', 1, NULL, NULL, '12.00', '0.00', '2019-03-27 07:37:03', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(3, 2, '1', 1003, '911396601918', 'refund', 'USD', '14.00', 1, NULL, NULL, '14.00', '0.00', '2019-03-27 07:37:05', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(4, 2, '1', 1004, '911396667454', 'pending', 'USD', '8.00', 1, NULL, NULL, '8.00', '0.00', '2019-03-27 07:37:07', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(5, 2, '1', 1005, '911396700222', 'pending', 'USD', '10.00', 1, NULL, NULL, '10.00', '0.00', '2019-03-27 07:37:08', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(6, 2, '1', 1006, '911396765758', 'pending', 'USD', '12.00', 1, NULL, NULL, '12.00', '0.00', '2019-03-27 07:37:10', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(7, 2, '1', 1007, '911396798526', 'pending', 'USD', '14.00', 1, NULL, NULL, '14.00', '0.00', '2019-03-27 07:37:11', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(8, 2, '1', 1008, '911398502462', 'pending', 'USD', '225.00', 1, NULL, NULL, '225.00', '0.00', '2019-03-27 07:42:22', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(9, 2, '1', 1009, '911398600766', 'cancelled', 'USD', '225.00', 1, NULL, NULL, '225.00', '0.00', '2019-03-27 07:42:24', 'COD', '2019-04-08 07:51:57', '2019-04-13 07:03:51'),
(10, 2, '1', 1010, '911398633534', 'pending', 'USD', '240.00', 1, NULL, NULL, '240.00', '0.00', '2019-03-27 07:42:25', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(11, 2, '1', 1011, '911398666302', 'pending', 'USD', '230.00', 1, NULL, NULL, '230.00', '0.00', '2019-03-27 07:42:27', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(12, 2, '1', 1012, '911398699070', 'paid', 'USD', '0.00', 1, NULL, NULL, '0.00', '0.00', '2019-03-27 07:42:28', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(13, 2, '1', 1013, '911398731838', 'cancelled', 'USD', '12.00', 1, NULL, NULL, '12.00', '0.00', '2019-03-27 07:42:31', 'COD', '2019-04-08 07:51:57', '2019-04-12 12:21:57'),
(14, 2, '1', 1014, '911398764606', 'pending', 'USD', '8.00', 1, NULL, NULL, '8.00', '0.00', '2019-03-27 07:42:32', 'COD', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(15, 16, '1', 76, NULL, 'processing', 'INR', '0', 1, NULL, '0.00', '100.00', '0.00', '2019-04-02 08:31:43', 'COD', '2019-04-08 07:57:52', '2019-04-08 07:57:52'),
(16, 16, '1', 75, NULL, 'processing', 'INR', '0', 1, NULL, '0.00', '190.00', '0.00', '2019-03-29 08:32:12', 'COD', '2019-04-08 07:57:52', '2019-04-08 07:57:52');

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

--
-- Table structure for table `Sj_orders_billing`
--

CREATE TABLE `Sj_orders_billing` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `billing_first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_address_two` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_orders_billing`
--

INSERT INTO `Sj_orders_billing` (`id`, `order_id`, `billing_first_name`, `billing_last_name`, `billing_address`, `billing_address_two`, `billing_city`, `billing_state`, `billing_postcode`, `billing_country`, `billing_phone`, `billing_email`, `created_at`, `updated_at`) VALUES
(1, 1, 'Vismita', 'Sharma', 'yhjfgjh', 'fghfghfg', 'fghfghfghfg', 'Rajasthan', '333300', 'India', '1234 564 567', 'gorav@virtual-email.com', '2019-04-08 07:51:56', '2019-04-08 07:51:56'),
(2, 2, 'Sohel', 'Khan', 'rtfgr', 'erterter', 'ertert', NULL, NULL, 'Aruba', '9647878774', 'vismita@virtual-email.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(3, 3, 'Hemant', 'Dave', 'fvsdf', 'sdfsdfsdf', 'sdfsdfsdf', 'Goa', '123456', 'India', '1235 665 655', 'hemant@virtual-email.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(4, 4, 'asdasd', 'dasdas', 'asdasd', 'asdas', 'asdasd', 'Kerala', '123456', 'India', '21312312312', 'mayank@virtual-email.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(5, 5, 'gdfgdf', 'fgdfgd', 'dfgdfg', 'fgdfgd', 'dfgdfgdfg', 'Mizoram', '123456', 'India', '96325 81470', 'tarun@virtual-email.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(6, 6, 'dfsdf', 'sdfsdf', 'fsdfsdfs', 'dfsd', 'sdfsdfsd', 'Himachal Pradesh', '123456', 'India', '98765412345', 'mohit@virtual-email.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(7, 7, 'dfxgdfg', 'gdfgdf', 'dfgdfgfdgdf', 'dfgdf', 'dfgdfgd', 'Himachal Pradesh', '123455', 'India', '1212 312 432 43', 'amit@virtual-email.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(8, 8, 'grvvv', 'srrr', 'dsddsad', 'sdas', 'sdasd', 'Daman and Diu', '789456', 'India', NULL, 'gecc@gmail.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(9, 9, 'srma', 'grv', 'sdsd', 'das', 'sadas', 'Gujarat', '123456', 'India', NULL, 'srma@gmail.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(10, 10, 'sr', 'ma', 'vdfvd', 'dfsdf', 'fsdfsdf', 'Himachal Pradesh', '123456', 'India', NULL, 'sr@gmail.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(11, 11, 'q', 'w', 'sdfs', 'fsd', 'dfs', 'Haryana', '456123', 'India', NULL, 'ma@gmail.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(12, 12, 'Pi', ' Jop', 'Tsongmo Lake', '14', 'Jaipur', 'Sikkim', '737103', 'India', NULL, 'pijop@nextmail.info', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(13, 13, 'Gaurav', 'Sharma', '550 Brookwood Point Place', '56', 'Simpsonville', 'South Carolina', '29681', 'United States', '(964) 919-6949', 'gorav@marketingmindz.in', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(14, 14, 'Vikram', 'Chippa', 'gdfgdf', 'dfgdfgdfg', 'dfgdfgdfgdf', 'Rajasthan', '333031', 'India', '78945 61230', 'wulasitifi@virtual-email.com', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(15, 15, 'Yogesh', 'jangid', '119/325 mansarovergfdg', 'fdgjfdg', 'jaipur', 'RJ', '302020', 'IN', '4514165456', 'developer.marketingmindz@gmail.com', '2019-04-08 07:57:52', '2019-04-08 07:57:52'),
(16, 16, 'sdfdsf', 'sdfsdf', '119/325 mansarover', 'fdgjfdg', 'jaipur', 'RJ', '302020', 'IN', '4514165456', 'developer.marketingmindz@gmail.com', '2019-04-08 07:57:52', '2019-04-08 07:57:52');

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

--
-- Table structure for table `Sj_orders_products_info`
--

CREATE TABLE `Sj_orders_products_info` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `variation_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` bigint(20) DEFAULT NULL,
  `tax_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtotal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtotal_tax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_tax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_orders_products_info`
--

INSERT INTO `Sj_orders_products_info` (`id`, `order_id`, `product_id`, `name`, `sku`, `variation_id`, `quantity`, `tax_class`, `price`, `subtotal`, `subtotal_tax`, `total`, `total_tax`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 'Paleo Snack #1 5 days', 'PS#1-5', NULL, 1, NULL, '10.00', '10.00', NULL, '10.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(2, 2, NULL, 'Paleo Snack #1 6 days', 'PS#1-6', NULL, 1, NULL, '12.00', '12.00', NULL, '12.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(3, 3, NULL, 'Paleo Snack #1 7 days', 'PS#1-7', NULL, 1, NULL, '14.00', '14.00', NULL, '14.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(4, 4, NULL, 'Paleo Snack #2 4 days', 'PS#2-4', NULL, 1, NULL, '8.00', '8.00', NULL, '8.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(5, 5, NULL, 'Paleo Snack #2 5 days', 'PS#2-5', NULL, 1, NULL, '10.00', '10.00', NULL, '10.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(6, 6, NULL, 'Paleo Snack #2 6 days', 'PS#2-6', NULL, 1, NULL, '12.00', '12.00', NULL, '12.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(7, 7, NULL, 'Paleo Snack #2 7 days', 'PS#2-7', NULL, 1, NULL, '14.00', '14.00', NULL, '14.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(8, 8, NULL, '10 Days of Healthy Meals + Breakfast Shake - Pesctarian Paleo Lunch & Dinner / Keto Friendly - SFH Pure Whey - After Work Out Protein -  Tropical', 'SFH-PURE-TROPICAL-PES-P-LD-10', NULL, 1, NULL, '225.00', '225.00', NULL, '225.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(9, 9, NULL, '10 Days of Healthy Meals + Breakfast Shake - Paleo Athlete Lunch & Dinner / Keto Friendly - SFH Pure Whey - After Work Out Protein -  Chocolate', 'SFH-PURE-CHOCOLATE-PA-LD-10', NULL, 1, NULL, '225.00', '225.00', NULL, '225.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(10, 10, NULL, '10 Days of Healthy Meals + Breakfast Shake - Keto Male Lunch & Dinner / Keto Friendly - SFH Pure Whey - After Work Out Protein - Vanilla', 'SFH-PURE-VANILLA-KETO-M-LD-10', NULL, 1, NULL, '240.00', '240.00', NULL, '240.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(11, 11, NULL, '10 Days of Healthy Meals + Breakfast Shake - Keto Female Lunch & Dinner / Keto Friendly - SFH Pure Whey - After Work Out Protein -  Tropical', 'SFH-PURE-TROPICAL-KETO-F-LD-10', NULL, 1, NULL, '230.00', '230.00', NULL, '230.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(12, 12, NULL, '10 Days of Healthy Meals + Breakfast Shake - Balanced Lunch & Dinner / Keto Friendly - SFH Fuel Anytime Protein - Coconut', 'SFH-FUEL-COCONUT-B-LD-10', NULL, 1, NULL, '0.00', '0.00', NULL, '0.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(13, 13, NULL, 'Paleo Snack #1 6 days', 'PS#1-6', NULL, 1, NULL, '12.00', '12.00', NULL, '12.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(14, 14, NULL, 'Paleo Snack #1 4 days', 'PS#1-4', NULL, 1, NULL, '8.00', '8.00', NULL, '8.00', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(15, 15, 74, 'product2', '', '0', 1, NULL, '100.00', '100.00', NULL, '100.00', NULL, '2019-04-08 07:57:52', '2019-04-08 07:57:52'),
(16, 16, 24, 'Product1', 'RDFDSFD', '0', 1, NULL, '90.00', '90.00', NULL, '90.00', NULL, '2019-04-08 07:57:52', '2019-04-08 07:57:52'),
(17, 16, 74, 'product2', '', '0', 1, NULL, '100.00', '100.00', NULL, '100.00', NULL, '2019-04-08 07:57:52', '2019-04-08 07:57:52');

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

--
-- Table structure for table `Sj_orders_shipping`
--

CREATE TABLE `Sj_orders_shipping` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `shipping_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_addres` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_address_two` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_orders_shipping`
--

INSERT INTO `Sj_orders_shipping` (`id`, `order_id`, `shipping_name`, `shipping_addres`, `shipping_address_two`, `shipping_city`, `shipping_state`, `shipping_postcode`, `shipping_country`, `shipping_email`, `shipping_phone`, `created_at`, `updated_at`) VALUES
(1, 1, 'Mohit arora', 'jaipur', 'jaipur', 'Jaipur', 'RAJASTHAN', '302021', 'India', 'chetan@marketingmindz.in', '1234567890', '2019-04-08 07:51:56', '2019-04-08 13:08:16'),
(2, 2, 'Sohel Khan', 'rtfgr', 'erterter', 'ertert', NULL, NULL, 'Aruba', 'vismita@virtual-email.com', '9647878774', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(3, 3, 'Hemant Dave', 'fvsdf', 'sdfsdfsdf', 'sdfsdfsdf', 'Goa', '123456', 'India', 'hemant@virtual-email.com', '1235 665 655', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(4, 4, 'asdasd dasdas', 'asdasd', 'asdas', 'asdasd', 'Kerala', '123456', 'India', 'mayank@virtual-email.com', '21312312312', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(5, 5, 'gdfgdf fgdfgd', 'dfgdfg', 'fgdfgd', 'dfgdfgdfg', 'Mizoram', '123456', 'India', 'tarun@virtual-email.com', '96325 81470', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(6, 6, 'dfsdf sdfsdf', 'fsdfsdfs', 'dfsd', 'sdfsdfsd', 'Himachal Pradesh', '123456', 'India', 'mohit@virtual-email.com', '98765412345', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(7, 7, 'dfxgdfg gdfgdf', 'dfgdfgfdgdf', 'dfgdf', 'dfgdfgd', 'Himachal Pradesh', '123455', 'India', 'amit@virtual-email.com', '1212 312 432 43', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(8, 8, 'grvvv srrr', 'dsddsad', 'sdas', 'sdasd', 'Daman and Diu', '789456', 'India', 'gecc@gmail.com', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(9, 9, 'srma grv', 'sdsd', 'das', 'sadas', 'Gujarat', '123456', 'India', 'srma@gmail.com', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(10, 10, 'sr ma', 'vdfvd', 'dfsdf', 'fsdfsdf', 'Himachal Pradesh', '123456', 'India', 'sr@gmail.com', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(11, 11, 'q w', 'sdfs', 'fsd', 'dfs', 'Haryana', '456123', 'India', 'ma@gmail.com', NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(12, 12, 'Ashok parmas', 'vashali nagar jaipur', '14', 'jaipur', 'RAJASTHAN', '302020', 'India', 'developer.marketingmindz@gmail.com', '8559954236', '2019-04-08 07:51:57', '2019-04-13 05:56:38'),
(13, 13, 'Gaurav Sharma', '550 Brookwood Point Place', '56', 'Simpsonville', 'South Carolina', '29681', 'United States', 'gorav@marketingmindz.in', '(964) 919-6949', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(14, 14, 'Vikram Chippa', 'gdfgdf', 'dfgdfgdfg', 'dfgdfgdfgdf', 'Rajasthan', '333031', 'India', 'wulasitifi@virtual-email.com', '78945 61230', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(15, 15, 'sdfdsf sdfsdf', '119/325 mansarover', 'fdgjfdg', 'jaipur', 'RJ', '302020', 'IN', 'developer.marketingmindz@gmail.com', '4514165456', '2019-04-08 07:57:52', '2019-04-08 07:57:52'),
(16, 16, 'Ashok parmas', 'vashali nagar jaipur', 'gergergergerg', 'jaipur', 'RAJASTHAN', '302020', 'India', 'developer.marketingmindz@gmail.com', '8559954236', '2019-04-08 07:57:52', '2019-04-10 07:22:45');

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

--
-- Table structure for table `Sj_orders_transactions`
--

CREATE TABLE `Sj_orders_transactions` (
  `id` int(10) NOT NULL,
  `order_id` int(50) NOT NULL,
  `user_id` int(20) NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` float NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_orders_transactions`
--

INSERT INTO `Sj_orders_transactions` (`id`, `order_id`, `user_id`, `email`, `amount`, `company_id`, `transaction_by`, `status`, `created_at`, `updated_at`) VALUES
(1, 7, 1, 'mohitarora@marketingmindz.in', 500, '1', 'User', 'success', NULL, NULL),
(2, 7, 1, 'mohitarora@marketingmindz.in', 500, '1', 'User', 'success', '2019-04-12 07:36:34', NULL),
(3, 7, 1, 'mohitarora@marketingmindz.in', 500, '1', 'User', 'success', '2019-04-12 09:53:07', NULL),
(4, 7, 1, 'mohitarora@marketingmindz.in', 500, '1', 'User', 'success', '2019-04-12 11:39:47', NULL),
(5, 12, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 08:20:46', NULL),
(6, 12, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 08:21:25', NULL),
(7, 12, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 08:22:58', NULL),
(8, 13, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 08:26:45', NULL),
(9, 1, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 08:28:22', NULL),
(10, 1, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 08:30:22', NULL),
(11, 12, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 09:46:01', NULL),
(12, 5, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 10:13:20', NULL),
(13, 5, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 10:13:37', NULL),
(14, 15, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 10:15:36', NULL),
(15, 4, 1, 'mohitarora@marketingmindz.in', 10, '1', 'User', 'success', '2019-04-13 10:18:17', NULL);

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

--
-- Table structure for table `Sj_order_activity`
--

CREATE TABLE `Sj_order_activity` (
  `id` int(11) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sj_order_activity`
--

INSERT INTO `Sj_order_activity` (`id`, `order_id`, `message`, `created_at`, `updated_at`) VALUES
(1, '1', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(2, '2', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(3, '3', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(4, '4', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(5, '5', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(6, '6', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(7, '7', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(8, '8', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(9, '9', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(10, '10', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(11, '11', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(12, '12', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(13, '13', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(14, '14', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(15, '15', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:57:52', '2019-04-08 07:57:52'),
(16, '16', 'ORDER FETCHED IN THE SYSTEM', '2019-04-08 07:57:52', '2019-04-08 07:57:52'),
(17, '1', 'ADDRESS MODIFIED', '2019-04-08 12:41:30', '2019-04-08 12:41:30'),
(18, '1', 'ADDRESS MODIFIED', '2019-04-08 12:42:55', '2019-04-08 12:42:55'),
(19, '1', 'SHIPMENT DETAILS EDITED', '2019-04-08 12:44:43', '2019-04-08 12:44:43'),
(20, '1', 'ADDRESS MODIFIED', '2019-04-08 13:06:48', '2019-04-08 13:06:48'),
(21, '1', 'ADDRESS MODIFIED', '2019-04-08 13:07:01', '2019-04-08 13:07:01'),
(22, '1', 'ADDRESS MODIFIED', '2019-04-08 13:08:16', '2019-04-08 13:08:16'),
(23, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 09:46:30', '2019-04-09 09:46:30'),
(24, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 09:46:32', '2019-04-09 09:46:32'),
(25, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 10:08:48', '2019-04-09 10:08:48'),
(26, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 10:08:57', '2019-04-09 10:08:57'),
(27, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 10:09:08', '2019-04-09 10:09:08'),
(28, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 10:09:18', '2019-04-09 10:09:18'),
(29, '16', 'ADDRESS MODIFIED', '2019-04-09 10:09:52', '2019-04-09 10:09:52'),
(30, '16', 'ADDRESS MODIFIED', '2019-04-09 10:19:06', '2019-04-09 10:19:06'),
(31, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 10:29:26', '2019-04-09 10:29:26'),
(32, '16', 'ADDRESS MODIFIED', '2019-04-09 11:22:28', '2019-04-09 11:22:28'),
(33, '16', 'ADDRESS MODIFIED', '2019-04-09 11:28:12', '2019-04-09 11:28:12'),
(34, '16', 'ADDRESS MODIFIED', '2019-04-09 11:40:09', '2019-04-09 11:40:09'),
(35, '16', 'ADDRESS MODIFIED', '2019-04-09 12:02:11', '2019-04-09 12:02:11'),
(36, '16', 'ADDRESS MODIFIED', '2019-04-09 12:04:30', '2019-04-09 12:04:30'),
(37, '16', 'ADDRESS MODIFIED', '2019-04-09 13:05:40', '2019-04-09 13:05:40'),
(38, '16', 'SHIPMENT DETAILS EDITED', '2019-04-09 13:10:37', '2019-04-09 13:10:37'),
(39, '16', 'ADDRESS MODIFIED', '2019-04-10 07:21:39', '2019-04-10 07:21:39'),
(40, '16', 'ADDRESS MODIFIED', '2019-04-10 07:22:45', '2019-04-10 07:22:45'),
(41, '12', 'ADDRESS MODIFIED', '2019-04-10 09:58:12', '2019-04-10 09:58:12'),
(42, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:07:08', '2019-04-10 10:07:08'),
(43, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:18:26', '2019-04-10 10:18:26'),
(44, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:19:09', '2019-04-10 10:19:09'),
(45, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:19:26', '2019-04-10 10:19:26'),
(46, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:19:55', '2019-04-10 10:19:55'),
(47, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:23:07', '2019-04-10 10:23:07'),
(48, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:24:09', '2019-04-10 10:24:09'),
(49, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:26:04', '2019-04-10 10:26:04'),
(50, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:29:12', '2019-04-10 10:29:12'),
(51, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:30:04', '2019-04-10 10:30:04'),
(52, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:31:20', '2019-04-10 10:31:20'),
(53, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 10:38:43', '2019-04-10 10:38:43'),
(54, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 11:54:49', '2019-04-10 11:54:49'),
(55, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:27:38', '2019-04-10 12:27:38'),
(56, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:28:16', '2019-04-10 12:28:16'),
(57, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:31:51', '2019-04-10 12:31:51'),
(58, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:33:10', '2019-04-10 12:33:10'),
(59, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:36:13', '2019-04-10 12:36:13'),
(60, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:37:13', '2019-04-10 12:37:13'),
(61, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:41:15', '2019-04-10 12:41:15'),
(62, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:42:03', '2019-04-10 12:42:03'),
(63, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:43:07', '2019-04-10 12:43:07'),
(64, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:44:23', '2019-04-10 12:44:23'),
(65, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:45:53', '2019-04-10 12:45:53'),
(66, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:46:07', '2019-04-10 12:46:07'),
(67, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:46:57', '2019-04-10 12:46:57'),
(68, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 12:47:11', '2019-04-10 12:47:11'),
(69, '15', 'SHIPMENT DETAILS EDITED', '2019-04-10 13:00:43', '2019-04-10 13:00:43'),
(70, '12', 'SHIPMENT DETAILS EDITED', '2019-04-10 13:11:37', '2019-04-10 13:11:37'),
(71, '13', 'SHIPMENT DETAILS EDITED', '2019-04-12 07:01:37', '2019-04-12 07:01:37'),
(72, '13', 'SHIPMENT DETAILS EDITED', '2019-04-12 07:03:35', '2019-04-12 07:03:35'),
(73, '12', 'SHIPMENT DETAILS EDITED', '2019-04-12 10:11:26', '2019-04-12 10:11:26'),
(74, '12', 'SHIPMENT DETAILS EDITED', '2019-04-12 10:11:49', '2019-04-12 10:11:49'),
(75, '13', 'SHIPMENT DETAILS EDITED', '2019-04-12 10:59:29', '2019-04-12 10:59:29'),
(76, '12', 'ADDRESS MODIFIED', '2019-04-13 05:56:38', '2019-04-13 05:56:38'),
(77, '12', 'SHIPMENT DETAILS EDITED', '2019-04-13 06:41:52', '2019-04-13 06:41:52'),
(78, '12', 'SHIPMENT DETAILS EDITED', '2019-04-13 06:51:31', '2019-04-13 06:51:31'),
(79, '12', 'SHIPMENT DETAILS EDITED', '2019-04-13 07:06:58', '2019-04-13 07:06:58'),
(80, '12', 'SHIPMENT DETAILS EDITED', '2019-04-13 07:09:56', '2019-04-13 07:09:56'),
(81, '4', 'SHIPMENT DETAILS EDITED', '2019-04-13 10:07:36', '2019-04-13 10:07:36'),
(82, '12', 'SHIPMENT DETAILS EDITED', '2019-04-13 10:10:11', '2019-04-13 10:10:11'),
(83, '5', 'SHIPMENT DETAILS EDITED', '2019-04-13 10:12:23', '2019-04-13 10:12:23'),
(84, '3', 'SHIPMENT DETAILS EDITED', '2019-04-13 10:17:12', '2019-04-13 10:17:12'),
(85, '12', 'SHIPMENT DETAILS EDITED', '2019-04-13 12:21:15', '2019-04-13 12:21:15'),
(86, '16', 'SHIPMENT DETAILS EDITED', '2019-04-13 12:24:57', '2019-04-13 12:24:57');

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

--
-- Table structure for table `Sj_order_contact`
--

CREATE TABLE `Sj_order_contact` (
  `id` int(11) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact_no` varchar(255) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `Sj_order_meta`
--

CREATE TABLE `Sj_order_meta` (
  `id` int(11) NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `total_length` varchar(255) DEFAULT NULL,
  `total_width` varchar(255) DEFAULT NULL,
  `total_height` varchar(255) DEFAULT NULL,
  `total_weight` varchar(255) DEFAULT NULL,
  `volumemetric_weight` varchar(255) DEFAULT NULL,
  `courier_company` varchar(255) DEFAULT NULL,
  `awb_code` varchar(255) DEFAULT NULL,
  `awb_assigned_date` datetime DEFAULT NULL,
  `pickup_location_id` varchar(255) NOT NULL DEFAULT '0',
  `order_shipped_date` varchar(255) DEFAULT NULL,
  `order_delivered_date` datetime DEFAULT NULL,
  `rto_initiated_date` datetime DEFAULT NULL,
  `rto_delivred_date` datetime DEFAULT NULL,
  `system_order_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 = Processing | 1 = Ready To ship | 2 = Pickup | 3 = Return Order | 4 = Cancel Order',
  `batch_id` varchar(20) DEFAULT NULL,
  `token_number` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sj_order_meta`
--

INSERT INTO `Sj_order_meta` (`id`, `order_id`, `total_length`, `total_width`, `total_height`, `total_weight`, `volumemetric_weight`, `courier_company`, `awb_code`, `awb_assigned_date`, `pickup_location_id`, `order_shipped_date`, `order_delivered_date`, `rto_initiated_date`, `rto_delivred_date`, `system_order_status`, `batch_id`, `token_number`, `created_at`, `updated_at`) VALUES
(1, '1', '87', '100', '91', '11111', '158.34', 'Xpressbees', '141008196400006', NULL, '1', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2019-04-08 07:51:57', '2019-04-13 08:30:22'),
(2, '2', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, NULL, NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(3, '3', '15', '15', '15', '15', '1', NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, NULL, NULL, '2019-04-08 07:51:57', '2019-04-13 10:17:12'),
(4, '4', '15', '15', '15', '12', '1', 'Xpressbees', '141008196400012', NULL, '1', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2019-04-08 07:51:57', '2019-04-13 10:18:17'),
(5, '5', '20', '20', '20', '20', '2', 'Xpressbees', '141008196400010', NULL, '1', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2019-04-08 07:51:57', '2019-04-13 10:13:37'),
(6, '6', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, NULL, NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(7, '7', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, NULL, NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(8, '8', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, NULL, NULL, '2019-04-08 07:51:57', '2019-04-08 07:51:57'),
(9, '9', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, NULL, NULL, '2019-04-08 07:51:57', '2019-04-13 07:03:51'),
(10, '10', '0', '0', '0', '0', NULL, NULL, '141008194100000', NULL, '1', NULL, NULL, NULL, NULL, 0, 'QRXCtF1008', NULL, '2019-04-08 07:51:57', '2019-04-10 13:04:21'),
(11, '11', '0', '0', '0', '0', NULL, NULL, '141008193700000', NULL, '1', NULL, NULL, NULL, NULL, 0, 'm9erdl1008', NULL, '2019-04-08 07:51:57', '2019-04-10 12:52:58'),
(12, '12', '0.5', '1', '0.5', '0.5555', '1', 'Xpressbees', '141008196400008', NULL, '1', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2019-04-08 07:51:57', '2019-04-13 13:30:04'),
(13, '13', '7', '8', '8', '10', '1', 'Xpressbees', '141008196400004', NULL, '1', NULL, NULL, NULL, NULL, 1, 'e7sFkK1008', NULL, '2019-04-08 07:51:57', '2019-04-13 08:26:45'),
(14, '14', '0', '0', '0', '0', NULL, NULL, '141008193900000', NULL, '1', NULL, NULL, NULL, NULL, 0, 'DEnLBa1008', '1008_M34_11042019', '2019-04-08 07:51:57', '2019-04-10 12:59:01'),
(15, '15', '1', '1', '1', '1.00', '0.0002', 'Xpressbees', '141008196400011', NULL, '1', NULL, NULL, NULL, NULL, 1, '956JSt1008', '1008_M34_11042019', '2019-04-08 07:57:52', '2019-04-13 10:15:36'),
(16, '16', '1', '0.5', '0.5', '2', '1', NULL, '141008193600000', NULL, '1', NULL, NULL, NULL, NULL, 0, 'cy9X8z1008', NULL, '2019-04-08 07:57:52', '2019-04-13 12:25:17');

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

--
-- Table structure for table `Sj_pickup__addresses`
--

CREATE TABLE `Sj_pickup__addresses` (
  `id` int(11) NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) NOT NULL,
  `nickname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_two` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zipcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `primary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_pickup__addresses`
--

INSERT INTO `Sj_pickup__addresses` (`id`, `company_id`, `user_id`, `nickname`, `contact_name`, `address`, `address_two`, `city`, `state`, `zipcode`, `contact`, `email`, `rto`, `primary`, `status`, `created_at`, `updated_at`) VALUES
(1, '1', 1, 'Home me', 'ashok singh', 'Vashali Nagar jaipur, Vashali Nagar Second jaipur', 'Vashali Nagar Second jaipur', 'jaipur', '54', '302034', '1234567890', 'mohitarora@marketingmindz.in', '0', '1', 1, '2019-03-11 15:14:26', '2019-03-12 09:32:26'),
(2, '2', 2, 'sdafsdf', 'sdfsdfsd', 'adsdaf, sdfsdaf, sdfsdaf', 'sdfsdaf', 'jaipur', '54', '30', '4253453453', 'jaintarun@gmail.com', '0', '0', 1, '2019-03-11 16:05:02', '2019-03-11 19:01:29'),
(3, '2', 2, 'add new', 'sdfsdfsdgfgfdgs', 'adsdaf, sdfsdaf, sdfsdaf, sdfsdaf', 'sdfsdaf', 'jaipur', '54', '30', '54234534', 'jaintarun@5.com', '0', '0', 1, '2019-03-11 16:05:17', '2019-03-11 19:01:29'),
(4, '2', 2, 'add new', 'sdfsdfsd', 'adsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf', 'sdfsdaf', 'jaipur', '54', '30', '4253453453555', 'jaintarun@gmail.com', '0', '0', 0, '2019-03-11 16:21:07', '2019-03-11 19:01:31'),
(5, '2', 2, 'tarun', 'sdfsdfsd', 'adsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf, sdfsdaf', 'sdfsdaf', 'jaipur', '54', '30', '4253453453', 'jaintarun@gmail.com', '0', '1', 1, '2019-03-11 16:43:44', '2019-03-11 19:01:29'),
(6, '2', 2, 'adsad', 'wqeqwe', 'sad, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa', 'sdadsa', 'asdsad', '38', '3244', '34234', 'ashok@marketingmindz.in', '0', '0', 0, '2019-03-11 17:32:54', '2019-03-11 19:01:33'),
(7, '2', 2, 'adsad', 'wqeqwe', 'sad, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa', 'sdadsa', 'asdsad', '38', '3244', '342341111111', 'ashok@marketingmindz.in', '0', '0', 0, '2019-03-11 17:35:01', '2019-03-11 19:01:53'),
(8, '2', 2, 'adsad', 'dfdsfsdf', 'sad, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa, sdadsa', 'sdadsa', 'asdsad', '38', '3244', '342342222', 'ashok@marketingmindz.in', '0', '0', 1, '2019-03-11 17:38:46', '2019-03-11 19:01:42'),
(9, '3', 3, 'Home me', 'ashok singh', 'Vashali Nagar jaipur, Vashali Nagar Second jaipur, Vashali Nagar Second jaipur', 'Vashali Nagar Second jaipur', 'jaipur', '54', '302034', '1234567890', 'mohitarora@marketingmindz.in', '0', '1', 1, '2019-03-11 19:10:21', '2019-03-11 19:10:24'),
(10, '1', 1, 'Tarun', 'Hahajaj', 'Djsjsjjssk', 'Snndxnndxjjs', 'Jaipur', '40', '303030', '99983077255', 'tarun@marketingmindz.in', '0', '0', 1, '2019-03-12 09:33:08', '2019-03-12 09:33:08'),
(11, '4', 4, 'ssdsd', '3423423423', 'sdfgf', 'sdf', 'fdgfdg', '46', '545443', '5435435435', 'ttt@gmail.com', '0', '1', 1, '2019-04-03 10:27:45', '2019-04-03 10:44:48');

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

--
-- Table structure for table `Sj_products`
--

CREATE TABLE `Sj_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `Product_id` bigint(50) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permalink` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_date` datetime NOT NULL,
  `product_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `catalog_visibility` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `regular_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sale_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `length` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `width` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `height` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dimension_unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Sj_product_meta`
--

CREATE TABLE `Sj_product_meta` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `Product_id` bigint(50) NOT NULL,
  `tax_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manage_stock` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock_quantity` bigint(20) DEFAULT NULL,
  `in_stock` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backorders` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backorders_allowed` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dimensions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_required` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_taxable` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_class_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reviews_allowed` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `average_rating` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating_count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `related_ids` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upsell_ids` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cross_sell_ids` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `categories` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tags` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `images` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Sj_roles`
--

CREATE TABLE `Sj_roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_roles`
--

INSERT INTO `Sj_roles` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'admin', 1, NULL, '2019-02-27 23:57:18'),
(2, 'Courier Partner', 1, NULL, NULL),
(3, 'E-commerce Vendor', 1, NULL, NULL),
(4, 'Social Reseller', 1, NULL, '2019-02-27 07:09:11');

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

--
-- Table structure for table `Sj_rto__addresses`
--

CREATE TABLE `Sj_rto__addresses` (
  `id` int(10) UNSIGNED NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pick_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `same` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_rto__addresses`
--

INSERT INTO `Sj_rto__addresses` (`id`, `company_id`, `user_id`, `pick_id`, `same`, `created_at`, `updated_at`) VALUES
(5, '1', '1', '1', 1, '2019-03-09 06:49:08', '2019-03-09 06:49:08'),
(6, '2', '2', '3', 1, '2019-03-11 11:21:50', '2019-03-11 16:05:34'),
(7, '3', '3', '9', 1, '2019-03-11 19:19:59', '2019-03-11 19:19:59');

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

--
-- Table structure for table `Sj_state`
--

CREATE TABLE `Sj_state` (
  `StateID` int(11) NOT NULL,
  `CountryID` int(11) NOT NULL,
  `StateName` varchar(50) NOT NULL,
  `Notes` longtext DEFAULT NULL,
  `ChangeDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sj_state`
--

INSERT INTO `Sj_state` (`StateID`, `CountryID`, `StateName`, `Notes`, `ChangeDate`) VALUES
(36, 1, 'ANDHRA PRADESH', NULL, '2019-02-28 10:07:29'),
(37, 1, 'ASSAM', NULL, '2019-02-28 10:07:29'),
(38, 1, 'ARUNACHAL PRADESH', NULL, '2019-02-28 10:07:29'),
(39, 1, 'GUJRAT', NULL, '2019-02-28 10:07:29'),
(40, 1, 'BIHAR', NULL, '2019-02-28 10:07:29'),
(41, 1, 'HARYANA', NULL, '2019-02-28 10:07:29'),
(42, 1, 'HIMACHAL PRADESH', NULL, '2019-02-28 10:07:29'),
(43, 1, 'JAMMU & KASHMIR', NULL, '2019-02-28 10:07:29'),
(44, 1, 'KARNATAKA', NULL, '2019-02-28 10:07:29'),
(45, 1, 'KERALA', NULL, '2019-02-28 10:07:29'),
(46, 1, 'MADHYA PRADESH', NULL, '2019-02-28 10:07:29'),
(47, 1, 'MAHARASHTRA', NULL, '2019-02-28 10:07:29'),
(48, 1, 'MANIPUR', NULL, '2019-02-28 10:07:29'),
(49, 1, 'MEGHALAYA', NULL, '2019-02-28 10:07:29'),
(50, 1, 'MIZORAM', NULL, '2019-02-28 10:07:29'),
(51, 1, 'NAGALAND', NULL, '2019-02-28 10:07:29'),
(52, 1, 'ORISSA', NULL, '2019-02-28 10:07:29'),
(53, 1, 'PUNJAB', NULL, '2019-02-28 10:07:29'),
(54, 1, 'RAJASTHAN', NULL, '2019-02-28 10:07:29'),
(55, 1, 'SIKKIM', NULL, '2019-02-28 10:07:29'),
(56, 1, 'TAMIL NADU', NULL, '2019-02-28 10:07:29'),
(57, 1, 'TRIPURA', NULL, '2019-02-28 10:07:29'),
(58, 1, 'UTTAR PRADESH', NULL, '2019-02-28 10:07:29'),
(59, 1, 'WEST BENGAL', NULL, '2019-02-28 10:07:29'),
(60, 1, 'DELHI', NULL, '2019-02-28 10:07:29'),
(61, 1, 'GOA', NULL, '2019-02-28 10:07:29'),
(62, 1, 'PONDICHERY', NULL, '2019-02-28 10:07:29'),
(63, 1, 'LAKSHDWEEP', NULL, '2019-02-28 10:07:29'),
(64, 1, 'DAMAN & DIU', NULL, '2019-02-28 10:07:29'),
(65, 1, 'DADRA & NAGAR', NULL, '2019-02-28 10:07:29'),
(66, 1, 'CHANDIGARH', NULL, '2019-02-28 10:07:29'),
(67, 1, 'ANDAMAN & NICOBAR', NULL, '2019-02-28 10:07:29'),
(68, 1, 'UTTARANCHAL', NULL, '2019-02-28 10:07:29'),
(69, 1, 'JHARKHAND', NULL, '2019-02-28 10:07:29'),
(70, 1, 'CHATTISGARH', NULL, '2019-02-28 10:07:29');

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

--
-- Table structure for table `Sj_transactions`
--

CREATE TABLE `Sj_transactions` (
  `id` int(10) NOT NULL,
  `user_id` int(20) NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` float NOT NULL,
  `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `remark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_transactions`
--

INSERT INTO `Sj_transactions` (`id`, `user_id`, `email`, `amount`, `company_id`, `transaction_by`, `transaction_id`, `status`, `remark`, `deleted_at`, `created_at`, `updated_at`) VALUES
(3, 2, 'ashok@marketingmindz.in', 1.02, '2', '', '20190326111212800110168074800364011', 'success', NULL, NULL, '2019-03-26 12:40:56', '2019-03-26 12:41:28'),
(5, 2, 'ashok@marketingmindz.in', 1.02, '2', '', '20190326111212800110168094400359493', 'failed', NULL, NULL, '2019-03-26 12:53:40', '2019-03-26 13:06:04'),
(6, 2, 'ashok@marketingmindz.in', 1.02, '2', '', '20190326111212800110168104300352072', 'success', NULL, NULL, '2019-03-26 13:06:37', '2019-03-27 05:16:19'),
(7, 2, 'ashok@marketingmindz.in', 1.02, '2', '', '20190327111212800110168111100366143', 'failed', NULL, NULL, '2019-03-27 00:16:10', '2019-03-27 00:16:16'),
(13, 2, 'ashok@marketingmindz.in', 5, '2', '', '20190327111212800110168666000360688', 'success', NULL, NULL, '2019-03-27 04:55:20', '2019-03-27 06:37:42'),
(26, 2, 'ashok@marketingmindz.in', 120, '2', '', '81492', 'success', NULL, NULL, '2019-03-28 06:34:03', '2019-03-28 06:40:47'),
(28, 2, 'ashok@marketingmindz.in', 120, '2', '', '81620', 'success', NULL, NULL, '2019-03-28 23:35:42', '2019-03-28 23:36:07'),
(29, 2, 'ashok@marketingmindz.in', 120, '2', 'Cashfree', '81623', 'success', 'enjoyyyyyy', NULL, '2019-03-28 23:55:13', '2019-03-28 23:55:31'),
(30, 2, 'ashok@marketingmindz.in', 120, '2', 'Cashfree', NULL, 'Processing', '12345111111111', NULL, '2019-03-28 23:58:38', '2019-03-28 23:58:38'),
(37, 2, 'ashok@marketingmindz.in', 120, '26', 'By Admin', NULL, 'success', '12345', NULL, '2019-03-29 01:11:42', '2019-03-29 01:11:43'),
(38, 2, 'ashok@marketingmindz.in', 120, '2', 'By Admin', NULL, 'success', '1234511111', NULL, '2019-03-29 01:13:49', '2019-03-29 01:13:49'),
(39, 2, 'ashok@marketingmindz.in', 120, '1', 'By Admin', NULL, 'success', 'enjoyyyyyy', NULL, '2019-03-29 01:18:46', '2019-03-29 01:18:46'),
(40, 2, 'ashok@marketingmindz.in', 122, '2', 'Cashfree', '81655', 'success', '12345', NULL, '2019-03-29 01:23:40', '2019-03-29 01:24:07'),
(41, 2, 'ashok@marketingmindz.in', 120, '3', 'By Admin', NULL, 'success', '1234511111', NULL, '2019-03-29 02:01:36', '2019-03-29 02:01:36'),
(42, 2, 'ashok@marketingmindz.in', 120, '3', 'By Admin', NULL, 'success', '1234511111', NULL, '2019-03-29 02:03:09', '2019-03-29 02:03:09'),
(43, 2, 'ashok@marketingmindz.in', 120, '3', 'By Admin', NULL, 'success', '1234511111', NULL, '2019-03-29 02:12:38', '2019-03-29 02:12:38'),
(44, 2, 'ashok@marketingmindz.in', 120, '3', 'By Admin', NULL, 'success', '1234511111', NULL, '2019-03-29 02:13:21', '2019-03-29 02:13:22'),
(45, 2, 'ashok@marketingmindz.in', 200, '2', 'Paytm', '20190329111212800110168610700358380', 'failed', 'enjoyyyyyy', NULL, '2019-03-29 05:26:53', '2019-03-29 05:27:04'),
(46, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', '81848', 'success', 'enjoyyyyyy', NULL, '2019-03-29 05:30:58', '2019-03-29 05:31:25'),
(47, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', '81870', 'success', '1234511111', NULL, '2019-03-29 05:47:01', '2019-03-29 05:47:49'),
(48, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', '81874', 'success', '1234511111', NULL, '2019-03-29 05:48:10', '2019-03-29 05:48:44'),
(49, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', '81875', 'success', 'enjoyyyyyy', NULL, '2019-03-29 05:49:11', '2019-03-29 05:49:29'),
(50, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', NULL, 'Processing', '1234511111', NULL, '2019-03-29 06:03:33', '2019-03-29 06:03:33'),
(51, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', NULL, 'Processing', '1234511111', NULL, '2019-03-29 06:04:39', '2019-03-29 06:04:39'),
(52, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', '81900', 'success', '1234511111', NULL, '2019-03-29 06:05:49', '2019-03-29 06:06:14'),
(53, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', '81956', 'success', 'enjoyyyyyy', NULL, '2019-03-29 07:58:55', '2019-03-29 07:59:15'),
(54, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', '82693', 'success', NULL, NULL, '2019-04-01 12:31:00', '2019-04-01 12:31:38'),
(57, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-01 12:45:14', '2019-04-01 12:45:14'),
(58, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', '82706', 'success', NULL, NULL, '2019-04-01 12:45:28', '2019-04-01 12:46:04'),
(59, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'success', NULL, NULL, '2019-04-01 12:46:29', '2019-04-01 12:46:40'),
(60, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'success', NULL, NULL, '2019-04-01 12:47:07', '2019-04-01 12:47:16'),
(61, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-01 12:51:01', '2019-04-01 12:51:01'),
(62, 1, 'mohitarora@marketingmindz.in', 200, '1', 'Cashfree', 'N/A', 'success', NULL, NULL, '2019-04-01 12:53:11', '2019-04-01 12:53:39'),
(63, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', '82714', 'success', NULL, NULL, '2019-04-01 12:58:12', '2019-04-01 13:00:54'),
(64, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'success', NULL, NULL, '2019-04-01 13:01:42', '2019-04-01 13:02:03'),
(65, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'success', NULL, NULL, '2019-04-01 13:04:10', '2019-04-01 13:04:40'),
(66, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:10:29', '2019-04-01 13:17:13'),
(67, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:17:28', '2019-04-01 13:17:41'),
(68, 1, 'mohitarora@marketingmindz.in', 200, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:18:52', '2019-04-01 13:18:59'),
(69, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:21:29', '2019-04-01 13:21:40'),
(70, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:28:37', '2019-04-01 13:28:43'),
(71, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:28:52', '2019-04-01 13:28:56'),
(72, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:29:12', '2019-04-01 13:29:16'),
(73, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', '82747', 'success', NULL, NULL, '2019-04-01 13:29:32', '2019-04-01 13:29:54'),
(74, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:30:04', '2019-04-01 13:30:17'),
(75, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:31:20', '2019-04-01 13:31:25'),
(76, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:34:16', '2019-04-01 13:34:20'),
(77, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:41:47', '2019-04-01 13:41:52'),
(78, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', '82756', 'success', NULL, NULL, '2019-04-01 13:42:36', '2019-04-01 13:43:02'),
(79, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:43:24', '2019-04-01 13:43:30'),
(80, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', '82757', 'success', NULL, NULL, '2019-04-01 13:44:02', '2019-04-01 13:44:30'),
(81, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:45:18', '2019-04-01 13:45:24'),
(82, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', '82758', 'success', NULL, NULL, '2019-04-01 13:45:41', '2019-04-01 13:46:05'),
(83, 2, 'ashok@marketingmindz.in', 200, '2', 'Cashfree', '82763', 'success', NULL, NULL, '2019-04-01 13:46:34', '2019-04-01 13:52:21'),
(84, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', '82765', 'failed', NULL, NULL, '2019-04-01 13:52:33', '2019-04-01 13:53:05'),
(85, 2, 'ashok@marketingmindz.in', 400, '2', 'Cashfree', '82769', 'success', NULL, NULL, '2019-04-01 13:56:08', '2019-04-01 13:56:29'),
(86, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:57:09', '2019-04-01 13:57:13'),
(87, 2, 'ashok@marketingmindz.in', 400, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:57:21', '2019-04-01 13:57:24'),
(88, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:57:38', '2019-04-01 13:57:41'),
(89, 2, 'ashok@marketingmindz.in', 400, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:57:58', '2019-04-01 13:58:02'),
(90, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:58:12', '2019-04-01 13:58:15'),
(91, 2, 'ashok@marketingmindz.in', 300, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:58:39', '2019-04-01 13:58:46'),
(92, 2, 'ashok@marketingmindz.in', 300, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 13:58:56', '2019-04-01 13:58:59'),
(93, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:00:08', '2019-04-01 14:00:14'),
(94, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:00:51', '2019-04-01 14:00:55'),
(95, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:01:06', '2019-04-01 14:01:09'),
(96, 2, 'ashok@marketingmindz.in', 400, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:02:13', '2019-04-01 14:02:17'),
(97, 2, 'ashok@marketingmindz.in', 300, '2', 'Cashfree', '82773', 'failed', NULL, NULL, '2019-04-01 14:02:29', '2019-04-01 14:02:57'),
(98, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:03:10', '2019-04-01 14:03:14'),
(99, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:03:34', '2019-04-01 14:03:38'),
(100, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:04:25', '2019-04-01 14:04:29'),
(101, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:04:37', '2019-04-01 14:04:40'),
(102, 2, 'ashok@marketingmindz.in', 300, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:04:49', '2019-04-01 14:04:53'),
(103, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:05:34', '2019-04-01 14:05:37'),
(104, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:05:44', '2019-04-01 14:05:47'),
(105, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:05:55', '2019-04-01 14:05:58'),
(106, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:06:44', '2019-04-01 14:06:51'),
(107, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:07:02', '2019-04-01 14:07:06'),
(108, 2, 'ashok@marketingmindz.in', 100, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-01 14:12:14', '2019-04-01 14:12:19'),
(109, 2, 'ashok@marketingmindz.in', 400, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-02 05:07:04', '2019-04-02 05:07:14'),
(110, 2, 'ashok@marketingmindz.in', 400, '2', 'Cashfree', '82885', 'failed', NULL, NULL, '2019-04-02 05:07:27', '2019-04-02 05:07:56'),
(111, 2, 'ashok@marketingmindz.in', 300, '2', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-02 05:08:12', '2019-04-02 05:09:41'),
(112, 2, 'ashok@marketingmindz.in', 200, '2', 'By Admin', NULL, 'success', 'enjoyyyyyyyyyyyyyyyyyy', NULL, '2019-04-02 05:45:23', '2019-04-02 05:45:23'),
(113, 2, 'ashok@marketingmindz.in', 200, '1', 'By Admin', NULL, 'success', 'enjoyyyyyyyyyyyyyyyyyy', NULL, '2019-04-02 06:08:58', '2019-04-02 06:08:58'),
(114, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-02 06:36:47', '2019-04-02 06:36:58'),
(115, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 06:39:09', '2019-04-02 06:39:09'),
(116, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 06:40:55', '2019-04-02 06:40:55'),
(117, 1, 'mohitarora@marketingmindz.in', 487, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-04 06:43:51', '2019-04-02 06:43:51'),
(118, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 06:45:37', '2019-04-02 06:45:37'),
(119, 1, 'mohitarora@marketingmindz.in', 300, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 06:57:33', '2019-04-02 06:57:33'),
(120, 1, 'mohitarora@marketingmindz.in', 300, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:03:34', '2019-04-02 07:03:34'),
(121, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:04:13', '2019-04-02 07:04:13'),
(122, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:06:07', '2019-04-02 07:06:07'),
(123, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:06:29', '2019-04-02 07:06:29'),
(124, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:09:47', '2019-04-02 07:09:47'),
(125, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:09:53', '2019-04-02 07:09:53'),
(126, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:10:32', '2019-04-02 07:10:32'),
(127, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:13:20', '2019-04-02 07:13:20'),
(128, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:16:26', '2019-04-02 07:16:26'),
(129, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:17:19', '2019-04-02 07:17:19'),
(130, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:17:36', '2019-04-02 07:17:36'),
(131, 1, 'mohitarora@marketingmindz.in', 100, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:18:20', '2019-04-02 07:18:20'),
(132, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-02 07:20:54', '2019-04-02 07:20:54'),
(133, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', '82999', 'success', NULL, NULL, '2019-04-04 07:21:08', '2019-04-04 07:22:15'),
(134, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', '85431', 'success', NULL, NULL, '2019-04-08 13:19:17', '2019-04-08 13:19:41'),
(135, 1, 'mohitarora@marketingmindz.in', 300, '1', 'Cashfree', '85454', 'success', NULL, NULL, '2019-04-08 13:41:59', '2019-04-08 13:42:18'),
(136, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-10 06:03:18', '2019-04-10 06:03:18'),
(137, 1, 'mohitarora@marketingmindz.in', 400, '1', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-10 06:04:08', '2019-04-10 06:13:52'),
(138, 5, 'ashok@marketingmindz.in', 100, '5', 'Cashfree', '87215', 'success', NULL, NULL, '2019-04-12 07:39:41', '2019-04-12 07:40:20'),
(139, 5, 'ashok@marketingmindz.in', 200, '5', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-12 07:41:52', '2019-04-12 07:41:52'),
(140, 5, 'ashok@marketingmindz.in', 200, '5', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-12 07:48:53', '2019-04-12 07:48:53'),
(141, 5, 'ashok@marketingmindz.in', 100, '5', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-12 07:49:51', '2019-04-12 07:50:03'),
(142, 5, 'ashok@marketingmindz.in', 300, '5', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-12 07:50:48', '2019-04-12 07:51:03'),
(143, 5, 'ashok@marketingmindz.in', 100, '5', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-12 07:51:26', '2019-04-12 07:52:12'),
(144, 5, 'ashok@marketingmindz.in', 300, '5', 'Cashfree', '87226', 'success', NULL, NULL, '2019-04-12 07:58:51', '2019-04-12 07:59:20'),
(145, 5, 'ashok@marketingmindz.in', 200, '5', 'Cashfree', '87381', 'success', NULL, NULL, '2019-04-12 11:59:00', '2019-04-12 11:59:45'),
(146, 5, 'ashok@marketingmindz.in', 120, '5', 'By Admin', NULL, 'success', 'enjoyyyyyywqfrrfsadfsdafsdfsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff', NULL, '2019-04-12 13:13:14', '2019-04-12 13:13:14'),
(147, 5, 'ashok@marketingmindz.in', 200, '5', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-12 13:15:55', '2019-04-12 13:15:59'),
(148, 5, 'ashok@marketingmindz.in', 200, '5', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-12 13:33:21', '2019-04-12 13:33:26'),
(149, 5, 'ashok@marketingmindz.in', 100, '5', 'Cashfree', 'N/A', 'failed', NULL, NULL, '2019-04-12 13:33:50', '2019-04-12 13:34:00'),
(150, 5, 'ashok@marketingmindz.in', 600, '5', 'By Admin', NULL, 'success', 'test', NULL, '2019-04-13 03:55:27', '2019-04-13 03:55:27'),
(151, 5, 'ashok@marketingmindz.in', 10000, '5', 'By Admin', NULL, 'success', 'ejrgnerjgn', NULL, '2019-04-13 05:21:07', '2019-04-13 05:21:07'),
(152, 5, 'ashok@marketingmindz.in', 1200, '5', 'By Admin', NULL, 'success', 'enjoyyyyyywqfrrfsadfsdafsdfsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff', NULL, '2019-04-13 09:51:47', '2019-04-13 09:51:47'),
(153, 5, 'ashok@marketingmindz.in', 120, '5', 'By Admin', NULL, 'success', 'enjoyyyyyywqfrrfsadfsdafsdfsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff', NULL, '2019-04-13 09:53:12', '2019-04-13 09:53:12'),
(154, 5, 'ashok@marketingmindz.in', 300, '5', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-13 12:13:16', '2019-04-13 12:13:16'),
(174, 5, 'ashok@marketingmindz.in', 100, '5', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-13 12:38:45', '2019-04-13 12:38:45'),
(175, 5, 'ashok@marketingmindz.in', 100, '5', 'Cashfree', NULL, 'Processing', NULL, NULL, '2019-04-13 12:39:16', '2019-04-13 12:39:16'),
(177, 5, 'ashok@marketingmindz.in', 200, '1', 'By Admin', NULL, 'success', 'enjoyyyyyyyyyyyyyyyyyy', NULL, '2019-04-13 12:49:47', '2019-04-13 12:49:47');

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

--
-- Table structure for table `Sj_userprofiles`
--

CREATE TABLE `Sj_userprofiles` (
  `id` int(10) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Sj_userprofiles`
--

INSERT INTO `Sj_userprofiles` (`id`, `user_id`, `first_name`, `last_name`, `mobile_no`, `created_at`, `updated_at`) VALUES
(1, 1, 'Mohit', 'Arora', '8005937903', '2019-03-07 10:34:12', '2019-03-07 10:34:12'),
(3, 3, 'mohit', 'arora', '1234567890', '2019-03-11 19:05:39', '2019-03-11 19:05:39'),
(5, 5, 'ashok', 'mm', '8504055318', '2019-04-04 06:29:30', '2019-04-13 12:57:24');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `Sj_state`
--
ALTER TABLE `Sj_state`
  ADD PRIMARY KEY (`StateID`);

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

--
-- Indexes for table `Sj_userprofiles`
--
ALTER TABLE `Sj_userprofiles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Sj_account_details`
--
ALTER TABLE `Sj_account_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `Sj_addresses`
--
ALTER TABLE `Sj_addresses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `Sj_companies`
--
ALTER TABLE `Sj_companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

--
-- AUTO_INCREMENT for table `Sj_courier_priority`
--
ALTER TABLE `Sj_courier_priority`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Sj_courier_selection`
--
ALTER TABLE `Sj_courier_selection`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Sj_galleries`
--
ALTER TABLE `Sj_galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `Sj_kyc_details`
--
ALTER TABLE `Sj_kyc_details`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `Sj_label__settings`
--
ALTER TABLE `Sj_label__settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `Sj_orders`
--
ALTER TABLE `Sj_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `Sj_orders_billing`
--
ALTER TABLE `Sj_orders_billing`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `Sj_orders_products_info`
--
ALTER TABLE `Sj_orders_products_info`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `Sj_orders_shipping`
--
ALTER TABLE `Sj_orders_shipping`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `Sj_orders_transactions`
--
ALTER TABLE `Sj_orders_transactions`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

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

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

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

--
-- AUTO_INCREMENT for table `Sj_products`
--
ALTER TABLE `Sj_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Sj_product_meta`
--
ALTER TABLE `Sj_product_meta`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Sj_roles`
--
ALTER TABLE `Sj_roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `Sj_rto__addresses`
--
ALTER TABLE `Sj_rto__addresses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `Sj_state`
--
ALTER TABLE `Sj_state`
  MODIFY `StateID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `Sj_transactions`
--
ALTER TABLE `Sj_transactions`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=178;

--
-- AUTO_INCREMENT for table `Sj_userprofiles`
--
ALTER TABLE `Sj_userprofiles`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;

