-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 13, 2019 at 01:34 PM -- Server version: 10.2.23-MariaDB -- PHP Version: 7.2.7 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `devmindz_updated_shipjunction` -- DELIMITER $$ -- -- Procedures -- CREATE DEFINER=`devmindz`@`localhost` PROCEDURE `fetchAllorders` (IN `companyId` VARCHAR(255)) BEGIN SELECT Sj_orders.id, Sj_orders.order_id, Sj_orders.order_number, Sj_orders.total, Sj_orders.payment_method, Sj_orders.order_date, Sj_stores.store_name, CONCAT(Sj_orders_billing.billing_first_name,' ',Sj_orders_billing.billing_last_name) AS full_name , Sj_orders_billing.billing_email, Sj_orders_billing.billing_phone, Sj_order_meta.total_height, Sj_order_meta.volumemetric_weight, Sj_order_meta.total_length, Sj_order_meta.total_width, Sj_order_meta.total_weight, GROUP_CONCAT(CONCAT(Sj_orders_products_info.name,'|',Sj_orders_products_info.quantity,'|',Sj_orders_products_info.sku)) AS product_data, Sj_pickup__addresses.nickname FROM Sj_orders left join Sj_orders_billing on Sj_orders_billing.order_id = Sj_orders.id left join Sj_stores on Sj_stores.id = Sj_orders.store_id left join Sj_order_meta on Sj_order_meta.order_id = Sj_orders.id left join Sj_orders_products_info on Sj_orders_products_info.order_id = Sj_orders.id left join Sj_pickup__addresses on Sj_pickup__addresses.id = Sj_order_meta.pickup_location_id WHERE Sj_orders.company_id = 1 GROUP BY Sj_orders_products_info.order_id; END$$ CREATE DEFINER=`devmindz`@`localhost` PROCEDURE `orderDetailFetch` (IN `orderId` VARCHAR(255), IN `companyId` VARCHAR(255)) BEGIN select Sj_orders.order_date, Sj_orders.id as orderId, Sj_orders.order_id as orderNo,Sj_orders.created_at, Sj_orders.payment_method, Sj_orders.total as orderAmount, Sj_stores.store_name, Sj_orders_shipping.*, Sj_order_meta.total_length, Sj_order_meta.pickup_location_id, Sj_order_meta.total_width, Sj_order_meta.total_height, Sj_order_meta.total_weight, Sj_order_meta.volumemetric_weight, Sj_order_meta.courier_company, Sj_order_meta.awb_code from Sj_orders left join Sj_order_meta on Sj_order_meta.order_id = Sj_orders.id left join Sj_orders_shipping ON Sj_orders_shipping.order_id = Sj_orders.id left join Sj_stores on Sj_stores.id = Sj_orders.store_id where Sj_orders.id = orderId AND Sj_orders.company_id = companyId; 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_couriers` -- CREATE TABLE `Sj_couriers` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `test_app_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testawbnumberseriesgeneration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testgetawbnumbergeneratedseries` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testaddmanifestdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testgetbulkshipmentstatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testshipmentsummarydetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testrtonotifyshipment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testtokentrackingdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testgetshipmentmanifestdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `testupdatendrdeferreddeliverydate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `live_app_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `liveawbnumberseriesgeneration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `livegetawbnumbergeneratedseries` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `liveaddmanifestdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `livegetbulkshipmentstatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `liveshipmentsummarydetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `livertonotifyshipment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `livetokentrackingdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `livegetshipmentmanifestdetails` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `liveupdatendrdeferreddeliverydate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 0, `deleted_at` date 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_couriers` -- INSERT INTO `Sj_couriers` (`id`, `name`, `test_app_key`, `testawbnumberseriesgeneration`, `testgetawbnumbergeneratedseries`, `testaddmanifestdetails`, `testgetbulkshipmentstatus`, `testshipmentsummarydetails`, `testrtonotifyshipment`, `testtokentrackingdetails`, `testgetshipmentmanifestdetails`, `testupdatendrdeferreddeliverydate`, `live_app_key`, `liveawbnumberseriesgeneration`, `livegetawbnumbergeneratedseries`, `liveaddmanifestdetails`, `livegetbulkshipmentstatus`, `liveshipmentsummarydetails`, `livertonotifyshipment`, `livetokentrackingdetails`, `livegetshipmentmanifestdetails`, `liveupdatendrdeferreddeliverydate`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, 'Xpressbees', 'mj1NnJW1', 'http://114.143.206.69:803/StandardForwardStagingService.svc/AWBNumberSeriesGeneration\'', 'http://114.143.206.69:803/StandardForwardStagingService.svc/GetAWBNumberGeneratedSeries', 'http://114.143.206.69:803/StandardForwardStagingService.svc/AddManifestDetails', 'http://114.143.206.69:803/StandardForwardStagingService.svc/GetBulkShipmentStatus', 'http://114.143.206.69:803/StandardForwardStagingService.svc/GetShipmentSummaryDetails', 'http://114.143.206.69:803/StandardForwardStagingService.svc/RTONotifyShipment', 'http://114.143.206.69:803/StandardForwardStagingService.svc/TokenTrackingDetails', 'http://114.143.206.69:803/ManifestService.svc/GetShipmentManifestDetails', 'http://114.143.206.69:803/StandardForwardStagingService.svc/UpdateNDRDeferredDeliveryDate', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2019-03-31 18:30:00', '2019-04-13 08:25:14'); -- -------------------------------------------------------- -- -- 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_password_resets` -- CREATE TABLE `Sj_password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `Sj_payments` -- CREATE TABLE `Sj_payments` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `test_app_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `test_secret_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `test_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `live_app_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `live_secret_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `live_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` 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; -- -- Dumping data for table `Sj_payments` -- INSERT INTO `Sj_payments` (`id`, `name`, `test_app_key`, `test_secret_key`, `test_url`, `live_app_key`, `live_secret_key`, `live_url`, `status`, `created_at`, `updated_at`) VALUES (1, 'Cashfree', '4302ae40f70e8fa9000ee7a02034', 'acbbf5d6d35d6e6d1e355e3e4dce9209dd2ea9f0', 'https://test.cashfree.com/billpay/checkout/post/submit', '11462edb4a297bff201b734dc26411', 'c9ae0af1fc0b8f9266a2a8f779ee54207435de9f', 'https://www.cashfree.com/checkout/post/submit', 0, NULL, '2019-04-13 12:34:25'); -- -------------------------------------------------------- -- -- 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_stores` -- CREATE TABLE `Sj_stores` ( `id` int(10) NOT NULL, `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `store_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `store_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `api_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `api_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `api_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `store_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'sp = Shopify | woo = Commerce | mg = Magento | oc = Opencart ', `is_sync` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `Sj_stores` -- INSERT INTO `Sj_stores` (`id`, `company_id`, `store_name`, `user_id`, `store_url`, `api_username`, `api_password`, `api_secret`, `store_type`, `is_sync`, `status`, `created_at`, `updated_at`) VALUES (2, '1', 'basant', 1, 'https://shipjucntion.myshopify.com/', 'c9f3f2a9a00e482b81be5306d9c3a27a', 'eaa69d4d085a47b1e37e8e945dfc2d49', '3e2ec6cd0cdfe49823f834901514f487', 'sp', 1, 0, '2019-04-02 13:22:07', '2019-04-03 12:03:45'), (16, '1', 'shipjuntion', 1, 'https://dev.marketingmindz.com/wpthemes/wpdemo/', 'ck_bc6d97394e409d677dce2c032c1af77b51c194be', 'cs_94e37f9f9972e58c2bf0ce10bdf93ecf2a9954f2', NULL, 'woo', 1, 1, '2019-04-04 12:06:56', '2019-04-04 12:08:38'); -- -------------------------------------------------------- -- -- 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'); -- -------------------------------------------------------- -- -- Table structure for table `Sj_users` -- CREATE TABLE `Sj_users` ( `id` int(10) NOT NULL, `role_id` int(11) NOT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `plan_id` int(11) NOT NULL, `company_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `verified` tinyint(1) NOT NULL DEFAULT 0, `verified_mobile` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `Sj_users` -- INSERT INTO `Sj_users` (`id`, `role_id`, `username`, `password`, `email`, `plan_id`, `company_id`, `status`, `remember_token`, `deleted_at`, `created_at`, `updated_at`, `verified`, `verified_mobile`) VALUES (1, 3, 'Mohit', '$2y$10$yAptVa3mKHRMP4in8kFcVeVlM15luSKrNunfkSyDQuMH1b5AL6Fam', 'mohitarora@marketingmindz.in', 1, '1', 0, 'k2VmAxbALQjNCN7mFLIM4JAOxDkApqJc3HBxwC5HJxsUxTuY2hvEBhg4bZW2', NULL, '2019-03-07 10:34:12', '2019-04-13 12:01:41', 1, 1), (3, 3, 'mohit', '$2y$10$Jw6bqZIzXuWcTM/NEr8B8O1YDjKH7aWX0SuHoysFpDhXz4eGu5mPO', 'mindz.maddy@gmail.com', 1, '3', 0, 'drchMXkY7PfBr5UQ1GYcdMn6mf9wTgcnuXCUWBQtammi5SGXMbTCqoOUvZx6', NULL, '2019-03-11 19:05:39', '2019-04-13 12:01:35', 1, 0), (5, 1, 'ashok', '$2y$10$yfSoZ3Z7Vvy/.vh76jaXE.Zl2p2Vz3LfBejGdPHKKr2K5CVghZupS', 'ashok@marketingmindz.in', 1, '5', 1, 'PJoPqWLsrFXx3iiVr9oiy9uiEXaKSV4Xww1z9fpvCMQIwM5WGsmXOsapxyqc', NULL, '2019-04-04 06:29:30', '2019-04-13 05:40:58', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `Sj_verify_users` -- CREATE TABLE `Sj_verify_users` ( `user_id` bigint(20) UNSIGNED NOT NULL, `token` 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_verify_users` -- INSERT INTO `Sj_verify_users` (`user_id`, `token`, `created_at`, `updated_at`) VALUES (1, 'm4nMFDztTu3WCmoKCFNCQ6PQjdpjJ8q7NdrjHMGw', '2019-03-07 10:34:12', '2019-03-07 10:34:12'), (2, 'oAerYGLfAfojJcPbHI2qhd2bIB2tiqlxX53ZVoqG', '2019-03-07 11:39:30', '2019-03-07 11:39:30'), (3, 'pmAAmiqp8QgHmjviUGf88l8bv9jjnwIDuFG7yN83', '2019-03-11 19:05:39', '2019-03-11 19:05:39'), (5, 'ZtlqZTTSFzTgLzWf8CSsnkIxqnTVZ81e0v2R18wc', '2019-04-04 06:29:30', '2019-04-04 06:29:30'), (11, 'cvtNvFDnh3BUEtARqZtE1nW0ms5Tg32DyZSae61B', '2019-04-13 10:12:30', '2019-04-13 10:12:30'); -- -------------------------------------------------------- -- -- Stand-in structure for view `user_details_show` -- (See below for the actual view) -- CREATE TABLE `user_details_show` ( `organization` varchar(255) ,`url` varchar(255) ,`id` int(10) ,`role_id` int(11) ,`username` varchar(255) ,`password` varchar(255) ,`email` varchar(255) ,`plan_id` int(11) ,`company_id` varchar(255) ,`status` tinyint(1) ,`remember_token` varchar(100) ,`deleted_at` timestamp ,`created_at` timestamp ,`updated_at` timestamp ,`verified` tinyint(1) ); -- -------------------------------------------------------- -- -- Structure for view `user_details_show` -- DROP TABLE IF EXISTS `user_details_show`; CREATE ALGORITHM=UNDEFINED DEFINER=`devmindz`@`localhost` SQL SECURITY DEFINER VIEW `user_details_show` AS select `Sj_companies`.`organization` AS `organization`,`Sj_companies`.`url` AS `url`,`Sj_users`.`id` AS `id`,`Sj_users`.`role_id` AS `role_id`,`Sj_users`.`username` AS `username`,`Sj_users`.`password` AS `password`,`Sj_users`.`email` AS `email`,`Sj_users`.`plan_id` AS `plan_id`,`Sj_users`.`company_id` AS `company_id`,`Sj_users`.`status` AS `status`,`Sj_users`.`remember_token` AS `remember_token`,`Sj_users`.`deleted_at` AS `deleted_at`,`Sj_users`.`created_at` AS `created_at`,`Sj_users`.`updated_at` AS `updated_at`,`Sj_users`.`verified` AS `verified` from (`Sj_companies` join `Sj_users` on(`Sj_users`.`company_id` = `Sj_companies`.`id`)) ; -- -- 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_couriers` -- ALTER TABLE `Sj_couriers` 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_password_resets` -- ALTER TABLE `Sj_password_resets` ADD KEY `password_resets_email_index` (`email`(191)); -- -- Indexes for table `Sj_payments` -- ALTER TABLE `Sj_payments` 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_stores` -- ALTER TABLE `Sj_stores` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`) USING BTREE; -- -- 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`); -- -- Indexes for table `Sj_users` -- ALTER TABLE `Sj_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `Sj_verify_users` -- ALTER TABLE `Sj_verify_users` ADD PRIMARY KEY (`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_couriers` -- ALTER TABLE `Sj_couriers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- 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_payments` -- ALTER TABLE `Sj_payments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- 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_stores` -- ALTER TABLE `Sj_stores` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- 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; -- -- AUTO_INCREMENT for table `Sj_users` -- ALTER TABLE `Sj_users` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;