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

START TRANSACTION;



--
-- Database: `azsoluti_lovecans`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `method` varchar(255) NOT NULL,
  `account_number` varchar(255) NOT NULL,
  `account_name` varchar(255) 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 `accounts`
--

INSERT INTO `accounts` (`id`, `user_id`, `method`, `account_number`, `account_name`, `created_at`, `updated_at`) VALUES
(1, 2, 'stripe', 'acct_1QncRQRfI1E93qAj', 'David', '2025-02-01 04:00:44', '2025-02-01 04:00:44');

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `action` varchar(255) NOT NULL,
  `details` text 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 `activity_logs`
--

INSERT INTO `activity_logs` (`id`, `user_id`, `action`, `details`, `created_at`, `updated_at`) VALUES
(1, 2, 'Logged In', 'User logged in from 127.0.0.1', '2025-02-04 10:42:28', '2025-02-04 10:42:28'),
(2, 1, 'Deleted Log', 'Admin cleared activity log', '2025-02-04 11:03:14', '2025-02-04 11:03:14'),
(3, 2, 'Logged In', 'User logged in from 127.0.0.1', '2025-02-05 04:11:14', '2025-02-05 04:11:14'),
(4, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-08 09:06:25', '2025-02-08 09:06:25'),
(5, 2, 'Ad Created', 'Seller (Female) created an ad titled \'product\' from 137.59.221.222', '2025-02-08 09:09:06', '2025-02-08 09:09:06'),
(6, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-08 09:12:12', '2025-02-08 09:12:12'),
(7, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-08 11:23:54', '2025-02-08 11:23:54'),
(8, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-08 14:22:13', '2025-02-08 14:22:13'),
(9, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-08 16:03:46', '2025-02-08 16:03:46'),
(10, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-10 07:37:54', '2025-02-10 07:37:54'),
(11, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-10 13:12:55', '2025-02-10 13:12:55'),
(12, 2, 'Ad Created', 'Seller (Male) created an ad titled \'product-2\' from 137.59.221.222', '2025-02-10 13:14:07', '2025-02-10 13:14:07'),
(13, 2, 'Ad Created', 'Seller (Male) created an ad titled \'product-2\' from 137.59.221.222', '2025-02-10 13:15:06', '2025-02-10 13:15:06'),
(14, 2, 'Ad Created', 'Seller (Male) created an ad titled \'product-3\' from 137.59.221.222', '2025-02-10 13:15:59', '2025-02-10 13:15:59'),
(15, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-10 13:38:02', '2025-02-10 13:38:02'),
(16, 2, 'Logged In', 'User logged in from 84.177.19.98', '2025-02-10 18:44:29', '2025-02-10 18:44:29'),
(17, 2, 'Logged In', 'User logged in from 39.50.233.7', '2025-02-11 08:32:49', '2025-02-11 08:32:49'),
(18, 2, 'Logged In', 'User logged in from 79.231.127.225', '2025-02-15 08:35:54', '2025-02-15 08:35:54'),
(19, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-17 10:40:18', '2025-02-17 10:40:18'),
(20, 2, 'Ad Created', 'Seller (Male) created an ad titled \'test\' from 137.59.221.222', '2025-02-17 11:43:12', '2025-02-17 11:43:12'),
(21, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-17 14:50:24', '2025-02-17 14:50:24'),
(22, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 07:50:59', '2025-02-18 07:50:59'),
(23, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 08:35:54', '2025-02-18 08:35:54'),
(24, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 08:37:23', '2025-02-18 08:37:23'),
(25, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 10:16:59', '2025-02-18 10:16:59'),
(26, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 12:32:39', '2025-02-18 12:32:39'),
(27, 2, 'Ad Created', 'Seller (Male) created an ad titled \'Product-1\' from 137.59.221.222', '2025-02-18 12:33:52', '2025-02-18 12:33:52'),
(28, 2, 'Ad Created', 'Seller (Male) created an ad titled \'Product-2\' from 137.59.221.222', '2025-02-18 12:35:47', '2025-02-18 12:35:47'),
(29, 2, 'Ad Created', 'Seller (Male) created an ad titled \'product-3\' from 137.59.221.222', '2025-02-18 12:37:18', '2025-02-18 12:37:18'),
(30, 2, 'Ad Created', 'Seller (Male) created an ad titled \'product-4\' from 137.59.221.222', '2025-02-18 12:38:13', '2025-02-18 12:38:13'),
(31, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 12:43:04', '2025-02-18 12:43:04'),
(32, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 14:21:39', '2025-02-18 14:21:39'),
(33, 2, 'Logged In', 'User logged in from 137.59.221.222', '2025-02-18 14:42:23', '2025-02-18 14:42:23'),
(34, 2, 'Logged In', 'User logged in from 43.242.176.248', '2025-02-18 17:33:50', '2025-02-18 17:33:50'),
(35, 2, 'Logged In', 'User logged in from 43.242.176.110', '2025-02-18 17:43:50', '2025-02-18 17:43:50'),
(36, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-19 07:52:57', '2025-02-19 07:52:57'),
(37, 2, 'Ad Created', 'Seller (Male) created an ad titled \'Pink Panties\' from 39.50.235.215', '2025-02-19 08:05:10', '2025-02-19 08:05:10'),
(38, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-19 08:15:31', '2025-02-19 08:15:31'),
(39, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 07:34:31', '2025-02-20 07:34:31'),
(40, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 07:36:24', '2025-02-20 07:36:24'),
(41, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 07:39:04', '2025-02-20 07:39:04'),
(42, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 07:43:24', '2025-02-20 07:43:24'),
(43, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:00:43', '2025-02-20 09:00:43'),
(44, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:11:27', '2025-02-20 09:11:27'),
(45, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:30:06', '2025-02-20 09:30:06'),
(46, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:30:53', '2025-02-20 09:30:53'),
(47, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:40:10', '2025-02-20 09:40:10'),
(48, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:41:47', '2025-02-20 09:41:47'),
(49, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:45:07', '2025-02-20 09:45:07'),
(50, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:47:17', '2025-02-20 09:47:17'),
(51, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:49:05', '2025-02-20 09:49:05'),
(52, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 09:50:08', '2025-02-20 09:50:08'),
(53, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 10:09:41', '2025-02-20 10:09:41'),
(54, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 10:11:32', '2025-02-20 10:11:32'),
(55, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 11:05:04', '2025-02-20 11:05:04'),
(56, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 12:09:26', '2025-02-20 12:09:26'),
(57, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 14:46:39', '2025-02-20 14:46:39'),
(58, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-20 15:34:53', '2025-02-20 15:34:53'),
(59, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-21 08:57:02', '2025-02-21 08:57:02'),
(60, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-21 12:08:15', '2025-02-21 12:08:15'),
(61, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-21 13:08:26', '2025-02-21 13:08:26'),
(62, 2, 'Logged In', 'User logged in from 39.50.235.215', '2025-02-21 13:25:48', '2025-02-21 13:25:48'),
(63, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-25 13:12:22', '2025-02-25 13:12:22'),
(64, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-25 14:06:03', '2025-02-25 14:06:03'),
(65, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 07:24:34', '2025-02-26 07:24:34'),
(66, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 08:02:41', '2025-02-26 08:02:41'),
(67, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:23:31', '2025-02-26 09:23:31'),
(68, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:26:56', '2025-02-26 09:26:56'),
(69, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:31:34', '2025-02-26 09:31:34'),
(70, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:38:18', '2025-02-26 09:38:18'),
(71, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:39:25', '2025-02-26 09:39:25'),
(72, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:42:16', '2025-02-26 09:42:16'),
(73, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:49:36', '2025-02-26 09:49:36'),
(74, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 09:50:19', '2025-02-26 09:50:19'),
(75, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 12:15:26', '2025-02-26 12:15:26'),
(76, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 12:17:41', '2025-02-26 12:17:41'),
(77, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 12:50:56', '2025-02-26 12:50:56'),
(78, 2, 'Logged In', 'User logged in from 39.50.254.27', '2025-02-26 15:11:50', '2025-02-26 15:11:50'),
(79, 2, 'Logged In', 'User logged in from 39.50.230.197', '2025-02-27 13:41:37', '2025-02-27 13:41:37'),
(80, 2, 'Logged In', 'User logged in from 39.50.252.138', '2025-03-19 07:46:05', '2025-03-19 07:46:05'),
(81, 2, 'Logged In', 'User logged in from 39.50.250.231', '2025-03-19 12:07:44', '2025-03-19 12:07:44'),
(82, 2, 'Logged In', 'User logged in from 39.50.250.231', '2025-03-19 12:11:13', '2025-03-19 12:11:13'),
(83, 2, 'Logged In', 'User logged in from 39.50.250.231', '2025-03-20 07:12:25', '2025-03-20 07:12:25'),
(84, 2, 'Logged In', 'User logged in from 39.50.250.231', '2025-03-20 08:27:03', '2025-03-20 08:27:03'),
(85, 2, 'Logged In', 'User logged in from 39.50.240.157', '2025-03-24 10:25:41', '2025-03-24 10:25:41'),
(86, 2, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-25 08:41:19', '2025-03-25 08:41:19'),
(87, 2, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-25 08:43:54', '2025-03-25 08:43:54'),
(88, 2, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-25 09:36:55', '2025-03-25 09:36:55'),
(89, 2, 'Logged In', 'User logged in from 43.242.178.165', '2025-03-25 20:05:08', '2025-03-25 20:05:08'),
(90, 142, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-26 06:45:48', '2025-03-26 06:45:48'),
(91, 143, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-26 06:46:52', '2025-03-26 06:46:52'),
(92, 142, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-26 07:13:26', '2025-03-26 07:13:26'),
(93, 143, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-26 07:39:19', '2025-03-26 07:39:19'),
(94, 2, 'Logged In', 'User logged in from 39.50.241.141', '2025-03-27 10:25:30', '2025-03-27 10:25:30'),
(95, 2, 'Logged In', 'User logged in from 91.5.54.51', '2025-03-28 18:13:25', '2025-03-28 18:13:25'),
(96, 2, 'Logged In', 'User logged in from 84.177.29.253', '2025-03-30 12:48:10', '2025-03-30 12:48:10'),
(97, 2, 'Logged In', 'User logged in from 39.50.232.132', '2025-04-03 08:05:35', '2025-04-03 08:05:35'),
(98, 143, 'Logged In', 'User logged in from 39.50.232.132', '2025-04-03 10:18:59', '2025-04-03 10:18:59'),
(99, 2, 'Logged In', 'User logged in from 39.50.232.132', '2025-04-03 10:31:31', '2025-04-03 10:31:31'),
(100, 2, 'Logged In', 'User logged in from 39.50.247.22', '2025-04-03 11:17:48', '2025-04-03 11:17:48'),
(101, 2, 'Logged In', 'User logged in from 39.50.247.22', '2025-04-03 11:20:51', '2025-04-03 11:20:51'),
(102, 2, 'Logged In', 'User logged in from 84.177.21.183', '2025-04-03 13:18:26', '2025-04-03 13:18:26'),
(103, 143, 'Logged In', 'User logged in from 39.50.240.134', '2025-04-03 13:26:17', '2025-04-03 13:26:17');

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

--
-- Table structure for table `additional_refinements`
--

CREATE TABLE `additional_refinements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `refinement_title` varchar(255) NOT NULL,
  `ad_id` bigint(20) UNSIGNED NOT NULL,
  `refinement_price` varchar(255) 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 `additional_refinements`
--

INSERT INTO `additional_refinements` (`id`, `refinement_title`, `ad_id`, `refinement_price`, `created_at`, `updated_at`) VALUES
(235, 'Wearing pictures', 29, '19', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(236, 'Waring videos', 29, '21', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(237, 'Worn during sport', 29, '21', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(238, 'Golden shower', 29, '19', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(239, 'Worn during sex', 29, '21', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(240, 'Worn inside', 29, '19', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(241, 'Lisptick', 29, '21', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(242, 'Parfume', 29, '19', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(243, 'Worn during masturbation', 29, '21', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(244, 'Kaviar', 29, '19', '2025-03-01 18:16:50', '2025-03-01 18:16:50'),
(245, 'Wearing pictures', 30, '21', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(246, 'Waring videos', 30, '18', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(247, 'Worn during sport', 30, '21', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(248, 'Golden shower', 30, '18', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(249, 'Worn during sex', 30, '21', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(250, 'Worn inside', 30, '21', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(251, 'Lisptick', 30, '21', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(252, 'Parfume', 30, '21', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(253, 'Worn during masturbation', 30, '18', '2025-03-01 18:18:02', '2025-03-01 18:18:02'),
(254, 'Kaviar', 30, '21', '2025-03-01 18:18:02', '2025-03-01 18:18:02');

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

--
-- Table structure for table `admin_messages`
--

CREATE TABLE `admin_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `is_read` 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 `admin_messages`
--

INSERT INTO `admin_messages` (`id`, `seller_id`, `message`, `is_read`, `created_at`, `updated_at`) VALUES
(1, 2, 'i want to change my gender female to male', 0, '2025-02-08 10:16:10', '2025-02-08 10:16:10');

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `gallery` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `description` text NOT NULL,
  `worn_days` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `free_of_diseases` tinyint(1) NOT NULL,
  `drugs_free` tinyint(1) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'Unapproved',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ad_status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `paused` tinyint(1) NOT NULL DEFAULT 0,
  `is_lovecans` tinyint(1) NOT NULL DEFAULT 0,
  `admin_approved` tinyint(1) NOT NULL DEFAULT 0,
  `is_promoted` tinyint(1) NOT NULL DEFAULT 0,
  `promotion_expiry` timestamp NULL DEFAULT NULL,
  `promotion_paid_amount` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads`
--

INSERT INTO `ads` (`id`, `user_id`, `title`, `type`, `image`, `gallery`, `description`, `worn_days`, `price`, `free_of_diseases`, `drugs_free`, `status`, `created_at`, `updated_at`, `ad_status`, `paused`, `is_lovecans`, `admin_approved`, `is_promoted`, `promotion_expiry`, `promotion_paid_amount`) VALUES
(29, 1, 'red socks', 'socks', '1740853010.jpeg', '[]', 'normal', 9, 21, 1, 1, 'Approved', '2025-03-01 18:16:50', '2025-03-01 18:37:32', 'active', 0, 0, 0, 1, '2025-03-09 18:36:54', 0),
(30, 1, 'socks', 'socks', '1740853082.jpeg', '[]', 'normal', 21, 18, 1, 1, 'Approved', '2025-03-01 18:18:02', '2025-03-01 18:39:06', 'active', 0, 0, 0, 1, '2025-03-09 18:38:43', 0),
(39, 2, 'First Scoks', 'socks', '1742893768.jpeg', '[]', '<p>This is first socks pair</p>', 5, 150, 1, 1, 'Approved', '2025-03-25 09:09:28', '2025-03-25 10:48:25', 'active', 0, 0, 0, 0, NULL, 0),
(40, 2, 'Second Socks', 'socks', '1742893846.jpeg', '[]', '<p>This is second Socks Pair</p>', 3, 120, 1, 1, 'Approved', '2025-03-25 09:10:46', '2025-03-25 10:48:39', 'active', 0, 0, 0, 0, NULL, 0),
(41, 2, 'Third Socks', 'socks', '1742893910.jpeg', '[]', '<p>This is third Socks Pair</p>', 2, 100, 1, 1, 'Unapproved', '2025-03-25 09:11:50', '2025-03-30 12:48:42', 'active', 0, 0, 0, 0, NULL, 0),
(42, 2, 'Forth Socks', 'socks', '1742894144.jpeg', '[]', '<p>This is forth Socks Pair</p>', 6, 80, 1, 1, 'Unapproved', '2025-03-25 09:15:44', '2025-03-25 09:15:44', 'active', 0, 0, 0, 0, NULL, 0),
(43, 2, 'Fifth Socks', 'socks', '1742894212.jpeg', '[]', '<p>This is Fifth Socks Pair</p>', 4, 180, 1, 1, 'Unapproved', '2025-03-25 09:16:52', '2025-03-25 09:16:52', 'active', 0, 0, 0, 0, NULL, 0),
(44, 2, 'Sixth Socks', 'socks', '1742894273.jpeg', '[]', '<p>This is sixth Socks Pair</p>', 7, 200, 1, 1, 'Unapproved', '2025-03-25 09:17:53', '2025-03-25 09:17:53', 'active', 0, 0, 0, 0, NULL, 0),
(45, 2, 'Socke, blabla', 'socks', '1742894324.jpeg', '[]', '<p>This is seventh Socks Pair</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Das ist der Beschreibungstext</p>', 2, 140, 1, 1, 'Unapproved', '2025-03-25 09:18:44', '2025-04-03 09:45:47', 'inactive', 0, 0, 0, 0, NULL, 0);

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

--
-- Table structure for table `banner_sliders`
--

CREATE TABLE `banner_sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sliderimages` varchar(255) 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 `banner_sliders`
--

INSERT INTO `banner_sliders` (`id`, `sliderimages`, `created_at`, `updated_at`) VALUES
(1, 'bannerimages/xXhuk310ar6VBWv6e7DvttsTH6F7TcnNvVNmCi2N.jpg', '2025-03-01 16:21:13', '2025-03-01 16:21:13'),
(2, 'bannerimages/C1NjYkFudSlRAlz0MKt8wk4tptL1ML03wYidmpHP.png', '2025-03-01 16:21:23', '2025-03-01 16:21:23'),
(3, 'bannerimages/wWY5ZhwH96NRM7qGvc0HUejAymFuswuYSosowRtt.webp', '2025-03-01 16:21:31', '2025-03-01 16:21:31');

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

--
-- Table structure for table `cans`
--

CREATE TABLE `cans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `stock` int(11) DEFAULT 0,
  `user_id` bigint(20) UNSIGNED 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 `cans`
--

INSERT INTO `cans` (`id`, `stock`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 28, 1, '2024-12-27 14:44:14', '2025-03-01 18:18:02'),
(2, -36, 2, '2025-01-11 05:35:10', '2025-04-03 08:07:33'),
(3, 3, 143, '2025-03-26 07:06:25', '2025-03-26 07:13:34');

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

--
-- Table structure for table `can_requests`
--

CREATE TABLE `can_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `cans` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `payment_id` varchar(255) NOT NULL,
  `payment_status` varchar(255) NOT NULL DEFAULT 'Pending',
  `status` varchar(255) NOT NULL DEFAULT 'Pending',
  `source` varchar(255) 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 `can_requests`
--

INSERT INTO `can_requests` (`id`, `user_id`, `cans`, `amount`, `currency`, `payment_id`, `payment_status`, `status`, `source`, `created_at`, `updated_at`) VALUES
(1, 1, 5, 100, 'USD', 'ch_3QaekHDOV3QK0LcG0wzIgvJH', 'paid', 'Approved', 'stripe', '2024-12-27 14:42:34', '2024-12-27 14:44:14'),
(2, 2, 5, 100, 'USD', 'ch_3Qg1ynDOV3QK0LcG13aVy6ss', 'paid', 'Approved', 'stripe', '2025-01-11 05:31:49', '2025-01-11 05:35:10'),
(3, 1, 20, 400, 'USD', 'ch_3Qg40bDOV3QK0LcG2AG34Q8k', 'paid', 'Approved', 'stripe', '2025-01-11 07:41:49', '2025-02-18 15:43:01'),
(4, 1, 20, 400, 'USD', 'ch_3QiCvRDOV3QK0LcG23IN92QZ', 'paid', 'Pending', 'stripe', '2025-01-17 05:37:19', '2025-01-17 05:37:19'),
(5, 143, 5, 100, 'USD', 'ch_3R6o1bPbo4b8faeB24zgshTz', 'paid', 'Approved', 'stripe', '2025-03-26 07:05:20', '2025-03-26 07:06:25');

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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ad_id` bigint(20) UNSIGNED 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 `categorys`
--

CREATE TABLE `categorys` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` varchar(255) 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 `categorys`
--

INSERT INTO `categorys` (`id`, `category`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'socks', 'category_images/TOf4lJu0m8GWIoJY3To7mGl7F3wlrRQtqKARJHZj.jpg', '1', '2025-02-18 11:07:46', '2025-02-18 11:07:46'),
(2, 'thongs', 'category_images/U5QvldviWzjT8SseEang22awl5PJTTLvqR19ym48.jpg', '1', '2025-02-18 11:08:38', '2025-02-18 11:08:38'),
(3, 'berief', 'category_images/9jlQHjt7mZ3JoqZDgOCsWMYZZuo4TlXR59yWzQb3.jpg', '1', '2025-02-18 11:09:28', '2025-02-18 11:19:59'),
(4, 'shorts', 'category_images/cBhvSGLIylUDi27gPqSH5f4poPyw34vTiXZIyK5s.jpg', '1', '2025-02-18 11:10:11', '2025-02-18 11:10:11'),
(5, 'other', 'category_images/EwUN6EGwlphzTteZvf8ZIwjpBDWOYDreiyGW1Eak.jpg', '1', '2025-02-20 07:38:48', '2025-02-20 07:38:48');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text 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 `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(1, 'David', 'a@gd.f', 'subjects', 'messages', '2024-12-28 14:40:55', '2024-12-28 14:40:55'),
(2, 'fwfb', 'jbubf@gmail', 'mfib', 'iwbcib', '2025-03-19 10:20:31', '2025-03-19 10:20:31'),
(3, 'Tom Issac', 'admin@admin.com', 'nen', 'bvubue', '2025-03-21 11:26:14', '2025-03-21 11:26:14');

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

--
-- Table structure for table `customer_payments`
--

CREATE TABLE `customer_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_detail_id` bigint(20) UNSIGNED NOT NULL,
  `amount` int(11) NOT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `payment_status` varchar(255) NOT NULL DEFAULT 'unpaid',
  `source` varchar(255) 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 `customer_payments`
--

INSERT INTO `customer_payments` (`id`, `order_detail_id`, `amount`, `payment_id`, `payment_status`, `source`, `created_at`, `updated_at`) VALUES
(23, 55, 100, 'pi_3Qng60DOV3QK0LcG2JZHdztJ', 'paid', 'stripe', '2025-02-01 07:46:53', '2025-02-01 07:46:53'),
(24, 58, 43, 'pi_3QtsqsDOV3QK0LcG2SFJgMnW', 'paid', 'stripe', '2025-02-18 15:36:52', '2025-02-18 15:36:52'),
(25, 59, 11, 'pi_3QtumRDOV3QK0LcG12hb5cPs', 'paid', 'stripe', '2025-02-18 17:40:26', '2025-02-18 17:40:26');

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

--
-- Table structure for table `document_media`
--

CREATE TABLE `document_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pdf` varchar(255) DEFAULT NULL,
  `media` varchar(255) 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 `document_media`
--

INSERT INTO `document_media` (`id`, `pdf`, `media`, `created_at`, `updated_at`) VALUES
(1, 'order-docs/gcfe7gVLPq2WwktcTbMTCtybrvkAnY1RRXuOERwI.pdf', 'media/snippets/nDfu44Da1GaVti953raPkP7cQrzF7hhDINdrIZIJ.mp4', '2025-02-03 06:00:20', '2025-02-03 06:00:20'),
(2, 'order-docs/jiitrv0kcbyTIlzZxN9lLiPkVmpV6fZqsIwGWtSf.pdf', 'media/snippets/Ij4YKLEf6nft9DvZgwTL5pEul1Y9ycg8f0WQPIui.mp4', '2025-02-03 06:03:04', '2025-02-03 06:03:04'),
(3, 'order-docs/BalEXJgXV8YHmS3YrIte09dzAcUCSGjCvUg0uTcq.pdf', 'media/snippets/jvLcFwBIK1vlxB2Id1SqGBOtCjzDfsxoK2yg18jM.mp4', '2025-02-03 06:06:20', '2025-02-03 06:06:20'),
(4, 'order-docs/j046yEXbRrrufX2PCSdinCnNcGoj7BxsSKJkmG6x.pdf', 'media/snippets/KYq4QiyfaA8Q2CmHVm3qKWy23jxaHF0eTtzGTKA2.mp4', '2025-02-03 06:08:24', '2025-02-03 06:08:24'),
(5, 'order-docs/RjBuqq7WPRWs2cikvg6c2uJq43Ej2A79dQIIS8AQ.pdf', 'media/snippets/hLeQKRNi9To9FYlx72BfeeRH1qwYfY5IkKN5YBKH.mp4', '2025-02-03 06:11:27', '2025-02-03 06:11:27'),
(6, 'order-docs/l0nGG0q65RFi0JQD0bLZEC0VA1YMZS4bojkveTnd.pdf', 'media/snippets/fyk8nEPcmI9JXX2eHiqx76GUtdriUC2XzyOt8H7L.mp4', '2025-02-03 06:13:02', '2025-02-03 06:13:02'),
(7, 'order-docs/tQQcyWnXv56rtvVa7UtntMPgVN73KjjWAHTztfQq.pdf', 'media/snippets/YpU5loe3hLOANKJUt5pxju0xvSUoll5kRg7m1yxp.mp4', '2025-02-03 06:14:33', '2025-02-03 06:14:33'),
(8, 'order-docs/hGbrZSo5Bj1uEVYuqo3GecFjtjhcEMphoDbdAqEL.pdf', 'media/snippets/PXiprZ1oRhB0ROfOuaO1rKxw62Gxc1BcSpUNxysz.mp4', '2025-02-03 06:17:25', '2025-02-03 06:17:25'),
(9, 'order-docs/6biKzT8dofYgVS5dbwKSSwe03V99RAyOs0i9EXTf.pdf', 'media/snippets/n2Qf18pjaSdNqmnTJ1pKpSPPSFSElOc3gDfPFq0A.mp4', '2025-02-03 06:19:08', '2025-02-03 06:19:08'),
(10, 'order-docs/2jUspahRt45ck07zcCUHGj1xhVYHSDhVUJG3EAZ8.pdf', 'media/snippets/LZ5PcT1K5H9vyDKlYR8ku647kWkYj9LYFsr3YRVe.mp4', '2025-02-03 06:23:04', '2025-02-03 06:23:04'),
(11, 'order-docs/Jn1QU0asKvv1PckNPfSWHm45qd4Q9Zb75H0sw515.pdf', 'media/snippets/Wwnx4AFIckn6EyGt2KdJclgbivAQyJ2mq1cg9sS3.mp4', '2025-02-03 06:24:55', '2025-02-03 06:24:55'),
(12, 'order-docs/WxxJnlzq9V25bGxg66cX1LuneLxUzFbpNaEdwWqk.pdf', 'media/snippets/XhneIOrbObad72xQmrfXuNmXvIRy9sM19yPPkGK8.mp4', '2025-02-03 07:00:40', '2025-02-03 07:00:40'),
(13, 'order-docs/IK3Mgb3wr0ridJAOgZaO3yOvq1NUpudgZPjwJYY0.pdf', 'media/snippets/OzEzGfMXBlbrJfS4GPzE5CcUYdJY5y3Te6LgHAMC.mp4', '2025-02-03 07:16:23', '2025-02-03 07:16:23'),
(14, 'order-docs/xQkocHh7WDI1hTqiKG4YhIx2As2mllwwWDCKlwQr.pdf', 'media/snippets/rdVvZGgbJtFDJ04nx0KLHo4Vd17suYIAvzkmpWFp.mp4', '2025-02-03 07:19:15', '2025-02-03 07:19:15'),
(15, 'order-docs/iJLb1cpjlUwb7eYPLg2jUej9BRvlmhFbNAvAxn8R.pdf', 'media/snippets/ykbgzUC9f2hwJjEbxwAoe9AhqNVaKlgouDre0PcD.mp4', '2025-02-03 07:22:30', '2025-02-03 07:22:30');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `generic_archives`
--

CREATE TABLE `generic_archives` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `table_name` varchar(255) NOT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`data`)),
  `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 `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"24875862-56db-4355-8658-122f02069e4a\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:27;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:13:36.990851\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737717216, 1737716917),
(2, 'default', '{\"uuid\":\"99c15292-6866-48bb-b3af-6e5f56bd9ed1\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:28;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:16:02.940260\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737717362, 1737717062),
(3, 'default', '{\"uuid\":\"1dbdc0f6-f020-4766-8678-fbc8e62079a0\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:29;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:21:27.329970\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737717687, 1737717387),
(4, 'default', '{\"uuid\":\"0989b504-2b0e-4233-84eb-ad9840140149\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:30;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:24:25.418427\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737717865, 1737717565),
(5, 'default', '{\"uuid\":\"512372ad-8a0e-491b-80da-db3d46d1990a\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:31;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:26:07.792633\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737717967, 1737717667),
(6, 'default', '{\"uuid\":\"de879cac-16b1-4c5e-8d8a-7ebb854e3479\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:32;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:34:50.301114\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737718490, 1737718190),
(7, 'default', '{\"uuid\":\"7caadc2c-1263-44e1-9998-9a1943c0f5bb\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:33;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:39:05.508658\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737718745, 1737718445),
(8, 'default', '{\"uuid\":\"b3c067c4-8848-4f13-baac-79f067c031a3\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:34;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 11:43:39.002042\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737719019, 1737718719),
(9, 'default', '{\"uuid\":\"5c4fb714-a79a-4ea3-9955-3e150d05b6f6\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:39;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:04:45.127058\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737720285, 1737719985),
(10, 'default', '{\"uuid\":\"8b6aa514-c77a-4971-924d-d71fbf2b9d63\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:41;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:09:41.220354\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737720581, 1737720281),
(11, 'default', '{\"uuid\":\"76d739eb-ef22-449e-bae4-c493563d631d\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:44;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:21:01.013347\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737721261, 1737720961),
(12, 'default', '{\"uuid\":\"19eb7168-df08-40b6-a654-10b8c6fae214\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:45;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:23:24.980431\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737721404, 1737721104),
(13, 'default', '{\"uuid\":\"ede90f10-a4a4-4858-b387-c10a518e3926\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:46;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:26:13.250034\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737721573, 1737721273),
(14, 'default', '{\"uuid\":\"298487d9-1180-488f-a2d9-c98f2265afe3\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:47;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:27:46.073311\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737721666, 1737721366),
(15, 'default', '{\"uuid\":\"b4cd8ac8-4c79-49ad-bc0b-97813af31ed3\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:48;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:30:47.377558\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737721847, 1737721547),
(16, 'default', '{\"uuid\":\"fa0354c0-3419-4c1b-aeaa-be5e3ed64995\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:49;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:35:01.696412\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737722101, 1737721801),
(17, 'default', '{\"uuid\":\"13e11bbc-087b-4a96-9ea9-92b9843b6245\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:50;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:39:16.821273\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737722356, 1737722056),
(18, 'default', '{\"uuid\":\"fd0d8472-dfbf-448a-be07-d1149d4d5d91\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:51;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-24 12:40:43.178383\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737722443, 1737722143),
(19, 'default', '{\"uuid\":\"08048ef9-749c-4e24-8c5c-63b1d0c379b5\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:52;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-25 09:20:25.326036\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737796825, 1737796525),
(20, 'default', '{\"uuid\":\"982e7494-dcfc-4b8e-a956-a1bd4245ec72\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:53;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-25 09:25:59.187151\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737797159, 1737796859),
(21, 'default', '{\"uuid\":\"ca65a595-0f76-4e68-b77b-bd8c066cdd49\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:54;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-25 09:37:07.679635\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737797827, 1737797527),
(22, 'default', '{\"uuid\":\"44c3e62e-8cfd-4ec0-a2ee-b6d729b3da07\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:57;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-25 09:48:44.096319\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737798524, 1737798224),
(23, 'default', '{\"uuid\":\"9b9d37a9-6c65-4a29-9214-ac20930b66d4\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:58;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-25 09:52:56.747170\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737798776, 1737798476),
(24, 'default', '{\"uuid\":\"9b1da026-cd32-46be-96f7-375db5fe5f4b\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:59;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-25 09:58:56.304410\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737799136, 1737798836),
(25, 'default', '{\"uuid\":\"e18f5dce-b3af-4ef3-89a9-f8a0691bb6c4\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:62;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-25 10:31:36.748105\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1737801096, 1737800796),
(26, 'default', '{\"uuid\":\"4ad4317e-5560-4e8a-8aae-2e49d5009664\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:116;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-01-31 13:59:36.060087\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1738331976, 1738331676),
(27, 'default', '{\"uuid\":\"b3a30b22-d245-4368-9154-e33302d2ff80\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:134;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-02-03 14:18:22.984664\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1738592302, 1738592003),
(28, 'default', '{\"uuid\":\"6d718893-a7df-4a9a-bb4a-6c03ff81c9be\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:137;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-02-03 14:36:57.041846\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1738593417, 1738593117),
(29, 'default', '{\"uuid\":\"0de8d10a-16e3-48da-8a03-68792517e915\",\"displayName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\DeleteUnverifiedUser\",\"command\":\"O:29:\\\"App\\\\Jobs\\\\DeleteUnverifiedUser\\\":2:{s:9:\\\"\\u0000*\\u0000userId\\\";i:138;s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-02-03 14:40:06.003691\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}}\"}}', 0, NULL, 1738593606, 1738593306);

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `media_files`
--

CREATE TABLE `media_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_path` text DEFAULT NULL,
  `external_link` text DEFAULT NULL,
  `price` decimal(8,2) DEFAULT NULL,
  `type` enum('image','video','external_link') 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 `media_files`
--

INSERT INTO `media_files` (`id`, `seller_id`, `name`, `file_path`, `external_link`, `price`, `type`, `created_at`, `updated_at`) VALUES
(29, 1, 'Fashion Clips', 'media/snippets/EPFpB2EvrAdkrtgOAixPi7QDLgtrutot19md3qGo.mp4', 'https://docs.google.com/document/d/1rqfW18GKl_7E3rSKkot2E84W3JCGh2ZdtiyfeAFvAvw/edit?usp=drive_link', 19.00, 'external_link', '2025-02-21 13:52:55', '2025-02-21 13:52:55'),
(30, 1, 'Trendy Fashion', 'media/snippets/vVIlmH9BwFxKGk8F4OXs4OpdN28QqrTJtCr45l5g.mp4', 'https://docs.google.com/document/d/1rqfW18GKl_7E3rSKkot2E84W3JCGh2ZdtiyfeAFvAvw/edit?usp=drive_link', 33.00, 'external_link', '2025-02-21 13:53:16', '2025-02-21 13:53:16'),
(32, 2, 'Fashion Moments', 'media/snippets/wzaA8GJmlBk167jccUKTyXtleb4sFBCaYJt9GCZ0.mp4', 'https://docs.google.com/document/d/1rqfW18GKl_7E3rSKkot2E84W3JCGh2ZdtiyfeAFvAvw/edit?usp=drive_link', 19.00, 'external_link', '2025-02-26 08:03:10', '2025-02-26 08:03:10'),
(33, 143, 'New Karachi', 'media/snippets/aeZt53X8iV6cZP1WXRNM2z3CTneXLqzfVT7l1U1a.webp', 'https://docs.google.com/document/d/1GukpnllE-MDKfYK54uLpuag4gd0THFhiHRiVwl_-DqQ/edit?tab=t.0', 200.00, 'external_link', '2025-03-26 07:18:00', '2025-03-26 07:18:00');

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

--
-- Table structure for table `media_purchases`
--

CREATE TABLE `media_purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED NOT NULL,
  `media_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending',
  `name` varchar(255) NOT NULL,
  `buyer_email` varchar(255) 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 `media_purchases`
--

INSERT INTO `media_purchases` (`id`, `seller_id`, `media_id`, `status`, `name`, `buyer_email`, `created_at`, `updated_at`) VALUES
(4, 1, 29, 'pending', 'test', 'testing@gmail.com', '2025-02-26 09:30:46', '2025-02-26 09:30:46');

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

--
-- Table structure for table `memberships`
--

CREATE TABLE `memberships` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `ad_limit` int(11) NOT NULL DEFAULT 5,
  `image_limit` int(11) NOT NULL DEFAULT 3,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `duration_days` int(11) NOT NULL DEFAULT 30,
  `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 `memberships`
--

INSERT INTO `memberships` (`id`, `name`, `ad_limit`, `image_limit`, `price`, `duration_days`, `created_at`, `updated_at`) VALUES
(1, 'Standard', 5, 3, 0.00, 0, NULL, NULL),
(2, 'Premium', 30, 10, 25.00, 30, NULL, NULL);

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` varchar(255) 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 `messages`
--

INSERT INTO `messages` (`id`, `user_id`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(1, 2, 'for unbloking', 'please unblock my account', '2025-02-20 09:40:35', '2025-02-20 09:40:35'),
(2, 2, 'for unbloking', 'please unblock my account', '2025-02-26 09:43:04', '2025-02-26 09:43:04'),
(3, 2, 'for unbloking', 'please unblock my account', '2025-02-26 12:17:14', '2025-02-26 12:17:14');

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

--
-- Table structure for table `migrations`
--

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(55, '0001_01_01_000000_create_users_table', 1),
(56, '0001_01_01_000001_create_cache_table', 1),
(57, '0001_01_01_000002_create_jobs_table', 1),
(58, '2024_11_15_102953_create_ads_table', 1),
(59, '2024_11_15_103118_create_profiles_table', 1),
(60, '2024_11_30_105918_create_cans_table', 1),
(61, '2024_12_03_104130_create_verifications_table', 1),
(62, '2024_12_05_143314_create_messages_table', 1),
(63, '2024_12_06_153527_create_carts_table', 1),
(64, '2024_12_07_113825_create_order_details_table', 1),
(65, '2024_12_07_134607_create_can_requests_table', 1),
(66, '2024_12_09_104941_create_orders_table', 1),
(67, '2024_12_10_155752_create_payments_table', 1),
(68, '2024_12_16_102939_create_reports_table', 1),
(69, '2024_12_19_115329_create_accounts_table', 1),
(70, '2024_12_19_115427_create_sellerads_table', 1),
(71, '2024_12_23_135203_create_categorys_table', 1),
(72, '2024_12_27_090837_create_customer_payments_table', 1),
(73, '2024_12_28_082206_create_payment_requests_table', 2),
(74, '2024_12_28_140558_create_contacts_table', 3),
(75, '2024_12_31_082513_create_additional_refinements_table', 4),
(76, '2024_12_31_150110_create_customer_columns', 4),
(77, '2024_12_31_150111_create_subscriptions_table', 4),
(78, '2024_12_31_150112_create_subscription_items_table', 4),
(79, '2024_12_31_150227_create_plans_table', 4),
(80, '2025_01_11_100051_add_ad_status_to_ads', 5),
(81, '2025_01_11_151434_add_show_age_and_show_clothing_size_to_profiles_table', 6),
(82, '2025_01_11_155901_add_paused_to_ads_table', 7),
(83, '2025_01_13_121018_add_phone_number_to_users_table', 8),
(84, '2025_01_21_101848_create_seller_activity_logs_table', 9),
(85, '2025_01_21_141620_rename_report_reason_to_seller_id_in_reports_table', 10),
(86, '2025_01_21_145529_add_premium_membership_to_users', 10),
(87, '2025_01_22_145530_add_lovecans_feature_to_ads_table', 11),
(88, '2025_01_23_110100_update_profiles_table_for_limits', 12),
(89, '2025_01_23_123714_add_max_ads_premium_to_profiles_table', 13),
(90, '2025_01_23_124041_add_max_media_per_ads_premium_to_profiles_table', 14),
(91, '2025_01_23_133123_create_media_files_table', 15),
(92, '2025_01_24_094717_add_otp_to_users_table', 16),
(93, '2025_01_25_121808_add_seller_id_and_product_id_to_reports_table', 17),
(94, '2025_01_25_122057_remove_report_reason_from_reports_table', 18),
(95, '2025_01_25_122955_remove_product_id_from_reports_table', 19),
(96, '2025_01_25_150332_add_report_id_to_reports_table', 19),
(97, '2025_01_25_150515_remove_report_reason_from_reports_table', 20),
(98, '2025_01_25_153044_change_report_id_to_user_id_in_reports_table', 21),
(99, '2025_01_25_153227_add_user_id_to_reports_table', 22),
(100, '2025_01_25_154014_remove_report_reason_from_reports_table', 22),
(101, '2025_01_25_154150_change_user_id_to_report_id_in_reports_table', 23),
(102, '2025_01_25_154336_add_report_id_to_reports_table', 24),
(103, '2025_01_28_135545_create_settings_table', 24),
(104, '2025_01_28_140354_drop_report_reason_from_reports_table', 25),
(105, '2025_01_28_140708_add_promotion_fields_to_ads_table', 26),
(106, '2025_01_28_141249_add_promotion_fields_to_payments_table', 27),
(107, '2025_01_29_092553_modify_payment_status_column_in_payments_table', 27),
(108, '2025_01_30_104941_add_duration_to_payments_table', 28),
(109, '2025_01_30_105113_add_duration_to_payments_table', 29),
(110, '2025_01_31_100204_create_payemnts_table', 30),
(111, '2025_01_31_100612_create_payments_table', 31),
(112, '2025_01_31_103532_create_seller_payments_table', 32),
(113, '2025_01_31_105807_create_seller_payments_table', 33),
(114, '2025_01_31_110023_create_payments_table', 33),
(115, '2025_02_03_083938_create_document_media_table', 34),
(116, '2025_02_03_085148_create_document_media_table', 35),
(117, '2025_02_04_143117_create_activity_logs_table', 36),
(118, '2025_02_05_122401_add_notes_to_order_details_table', 37);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ad_id` bigint(20) UNSIGNED NOT NULL,
  `order_detail_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL,
  `tracking_link` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `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 `order_details`
--

CREATE TABLE `order_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `postcode` varchar(255) NOT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `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 `order_details`
--

INSERT INTO `order_details` (`id`, `first_name`, `last_name`, `email`, `phone_number`, `address`, `city`, `postcode`, `notes`, `status`, `created_at`, `updated_at`) VALUES
(55, 'testing', 'test', 'test@gmail.com', '12346789', 'hyderabad', 'hyderabad', '71000', NULL, 'pending', '2025-02-01 07:46:47', '2025-02-05 13:01:37'),
(58, 'testing', 'test', 'test@gmail.com', '12346789', 'hyderabad', 'hyderabad', '71000', NULL, 'pending', '2025-02-18 15:36:48', '2025-02-18 15:36:48'),
(59, 'testing', 'test', 'test@gmail.com', '12346789', 'hyderabad', 'hyderabad', '71000', NULL, 'pending', '2025-02-18 17:40:22', '2025-02-18 17:40:22');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status` varchar(255) NOT NULL,
  `payment_method` varchar(255) 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 `payments`
--

INSERT INTO `payments` (`id`, `status`, `payment_method`, `created_at`, `updated_at`) VALUES
(1, 'enabled', 'stripe', NULL, NULL),
(2, 'disabled', 'paypal', NULL, NULL);

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

--
-- Table structure for table `payment_requests`
--

CREATE TABLE `payment_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `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 `payment_requests`
--

INSERT INTO `payment_requests` (`id`, `user_id`, `amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 79.96, 'pending', '2024-12-28 08:46:38', '2025-01-11 06:56:42');

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `stripe_price_id` varchar(255) DEFAULT NULL,
  `price` decimal(8,2) NOT NULL,
  `duration_days` int(11) NOT NULL DEFAULT 30,
  `max_ads` int(11) NOT NULL DEFAULT 5,
  `max_media` int(11) NOT NULL DEFAULT 3,
  `is_premium` 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 `plans`
--

INSERT INTO `plans` (`id`, `name`, `stripe_price_id`, `price`, `duration_days`, `max_ads`, `max_media`, `is_premium`, `created_at`, `updated_at`) VALUES
(8, 'plan-5', '74', 30.00, 12, 10, 10, 1, '2025-01-11 06:23:16', '2025-02-10 15:30:55'),
(9, 'plan-4', '1', 60.00, 8, 4, 4, 1, '2025-01-11 06:23:36', '2025-02-10 15:30:22'),
(10, 'plan-3', '19', 60.00, 5, 10, 13, 1, '2025-01-11 06:24:19', '2025-02-10 15:29:13'),
(11, 'plan-2', '13', 450.00, 40, 10, 19, 0, '2025-01-11 06:25:20', '2025-02-10 15:26:32'),
(12, 'plan-1', '10', 400.00, 9, 5, 10, 0, '2025-01-11 06:25:48', '2025-02-19 08:12:47');

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

--
-- Table structure for table `product_refinements`
--

CREATE TABLE `product_refinements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `refinement_name` varchar(255) NOT NULL,
  `price` decimal(8,2) 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 `profiles`
--

CREATE TABLE `profiles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `gender` varchar(255) NOT NULL,
  `age` int(11) NOT NULL,
  `clothing_size` enum('xs','s','m','l','xl','xxl','xxxl') NOT NULL,
  `type` varchar(255) NOT NULL,
  `figure` varchar(255) NOT NULL,
  `hair_color` varchar(255) NOT NULL,
  `eye_color` varchar(255) NOT NULL,
  `nickname` varchar(255) NOT NULL,
  `profile_picture` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `onlyfans` varchar(255) DEFAULT NULL,
  `snapchat` varchar(255) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `show_age` tinyint(1) NOT NULL DEFAULT 0,
  `show_clothing_size` tinyint(1) NOT NULL DEFAULT 0,
  `profile_type` enum('Standard','Premium') NOT NULL DEFAULT 'Standard',
  `max_ads` int(11) NOT NULL DEFAULT 5,
  `max_media_per_ad` int(11) NOT NULL DEFAULT 3,
  `allow_custom_fonts` tinyint(1) NOT NULL DEFAULT 0,
  `allow_emojis` tinyint(1) NOT NULL DEFAULT 0,
  `allow_bold` tinyint(1) NOT NULL DEFAULT 0,
  `allow_italic` tinyint(1) NOT NULL DEFAULT 0,
  `allow_underline` tinyint(1) NOT NULL DEFAULT 0,
  `max_ads_premium` int(11) NOT NULL DEFAULT 5,
  `max_media_per_ads_premium` int(11) NOT NULL DEFAULT 5,
  `membership_id` bigint(20) UNSIGNED DEFAULT NULL,
  `membership_expiry` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`id`, `user_id`, `gender`, `age`, `clothing_size`, `type`, `figure`, `hair_color`, `eye_color`, `nickname`, `profile_picture`, `address`, `instagram`, `onlyfans`, `snapchat`, `description`, `status`, `created_at`, `updated_at`, `show_age`, `show_clothing_size`, `profile_type`, `max_ads`, `max_media_per_ad`, `allow_custom_fonts`, `allow_emojis`, `allow_bold`, `allow_italic`, `allow_underline`, `max_ads_premium`, `max_media_per_ads_premium`, `membership_id`, `membership_expiry`) VALUES
(1, 1, 'male', 23, 'xs', 'German', 'Athletic', 'Blonde', 'Blue', 'John', '1743070345.jpeg', 'UK', NULL, NULL, NULL, 'das', 'verified', '2024-12-27 09:42:09', '2025-03-27 10:12:25', 0, 0, 'Standard', 5, 3, 0, 0, 0, 0, 0, 5, 9, NULL, NULL),
(2, 2, 'male', 35, 'l', 'Western European', 'Normal', 'Black', 'Grey', 'David Smith', '1743669281.jpeg', 'UK', 'https://instagram.com', 'https://onlyfans.com', 'https://snapchat.com', 'Hello, \r\nI am David Smith, from Western European', 'verified', '2024-12-28 06:04:55', '2025-04-03 08:36:44', 1, 0, 'Standard', 5, 3, 0, 0, 0, 0, 0, 5, 5, 2, '2025-03-23'),
(3, 142, 'male', 96, 'xxl', 'Oriental', 'Normal', 'Red', 'Grey', 'Petra Robles', '1742983327.png', 'Totam iure quia quas', 'Qui quidem quo est t', 'Eum tenetur dolorem', 'Voluptate labore mol', 'Id laboriosam fugit', 'verified', '2025-03-26 06:51:31', '2025-03-26 10:02:07', 0, 0, 'Standard', 5, 3, 0, 0, 0, 0, 0, 5, 5, NULL, NULL),
(4, 143, 'male', 24, 'xs', 'Asian', 'Normal', 'Black', 'Blue', 'Mehdi', '1742971978.jpeg', 'House No 1308 Mohallah Near Bilal Masjid, Paretabad, Hyderabad', 'https://www.instagram.com/', NULL, 'https://www.snapchat.com/', 'sasabjksadsda', 'verified', '2025-03-26 06:52:58', '2025-03-26 07:24:24', 0, 0, 'Standard', 5, 3, 0, 0, 0, 0, 0, 5, 5, 2, '2025-04-25');

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

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ad_id` bigint(20) UNSIGNED NOT NULL,
  `report_id` bigint(20) UNSIGNED NOT NULL,
  `report_details` varchar(255) 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 `reports`
--

INSERT INTO `reports` (`id`, `ad_id`, `report_id`, `report_details`, `created_at`, `updated_at`) VALUES
(4, 40, 2, NULL, '2025-04-03 13:19:47', '2025-04-03 13:19:47');

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

--
-- Table structure for table `section_rights`
--

CREATE TABLE `section_rights` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `images` varchar(255) 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 `section_rights`
--

INSERT INTO `section_rights` (`id`, `images`, `created_at`, `updated_at`) VALUES
(1, 'sectionright/eA2zlyG4jxASczvSlpAsNts0zsKHrjnoX2i59gzS.jpg', '2025-03-01 16:22:29', '2025-03-01 16:22:29'),
(2, 'sectionright/1CveI9RBg6uQXE8Z8OoTOUnygvF1kL69kCrzi85D.jpg', '2025-03-01 16:22:37', '2025-03-01 16:22:37');

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

--
-- Table structure for table `sellerads`
--

CREATE TABLE `sellerads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `quantity` int(11) NOT NULL,
  `worn_days` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `free_of_diseases` tinyint(1) NOT NULL DEFAULT 0,
  `drugs_free` tinyint(1) NOT NULL DEFAULT 0,
  `tracking_link` varchar(255) DEFAULT NULL,
  `is_received` tinyint(1) NOT NULL DEFAULT 0,
  `payment_status` tinyint(1) NOT NULL DEFAULT 0,
  `offer_status` varchar(255) NOT NULL DEFAULT 'Unapproved',
  `offer_sent_status` varchar(255) NOT NULL DEFAULT 'pending',
  `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 `sellerads`
--

INSERT INTO `sellerads` (`id`, `user_id`, `title`, `type`, `image`, `description`, `quantity`, `worn_days`, `price`, `free_of_diseases`, `drugs_free`, `tracking_link`, `is_received`, `payment_status`, `offer_status`, `offer_sent_status`, `created_at`, `updated_at`) VALUES
(1, 1, 'teste', 'Others', '1736599560.PNG', 'newafadsdasf', 4, 30, 100, 1, 1, '123', 1, 1, 'Accepted', 'pending', '2025-01-11 07:46:00', '2025-01-22 08:58:44'),
(2, 1, 'nuce', 'Others', '1736599854.jpg', 'sdasad', 12, 12, 12, 1, 1, NULL, 1, 1, 'Accepted', 'inprogress', '2025-01-11 07:50:54', '2025-01-22 08:58:57'),
(3, 2, 'test', 'test', '1737624509.jpg', 'try', 12, 21, 21, 1, 1, NULL, 0, 0, 'Unapproved', 'pending', '2025-01-23 04:28:29', '2025-01-23 04:28:29'),
(4, 2, 'test', 'test', '1737624719.jpg', 'try', 12, 12, 21, 1, 1, NULL, 0, 0, 'Unapproved', 'pending', '2025-01-23 04:31:59', '2025-01-23 04:31:59'),
(5, 2, 'test', 'test', '1737624768.jpg', 'try', 34, 43, 43, 1, 1, NULL, 0, 0, 'Unapproved', 'pending', '2025-01-23 04:32:48', '2025-01-23 04:32:48'),
(6, 2, 'wre', 'test', '1737624828.jpg', 'try', 54, 54, 54, 1, 1, NULL, 0, 0, 'Rejected', 'pending', '2025-01-23 04:33:48', '2025-02-03 10:11:02'),
(7, 143, 'Hand Bags', 'other', '1742973214.jpg', 'no', 20, 7, 200, 1, 1, 'https://youtube.com/', 0, 0, 'Accepted', 'sent', '2025-03-26 07:13:34', '2025-03-26 07:27:34');

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

--
-- Table structure for table `seller_activity_logs`
--

CREATE TABLE `seller_activity_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `browser_details` text NOT NULL,
  `activity_time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seller_activity_logs`
--

INSERT INTO `seller_activity_logs` (`id`, `seller_id`, `ip_address`, `location`, `browser_details`, `activity_time`) VALUES
(1, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-21 12:44:07'),
(4, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-21 14:03:21'),
(5, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-22 13:11:30'),
(6, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-22 13:32:18'),
(7, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-22 13:35:27'),
(8, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-22 13:36:58'),
(9, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-22 13:39:14'),
(10, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-22 13:41:49'),
(11, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-23 08:49:11'),
(12, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-23 09:05:41'),
(13, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-23 12:59:39'),
(14, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-23 14:30:59'),
(15, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-23 14:31:42'),
(16, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-23 14:57:47'),
(17, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-23 15:09:17'),
(18, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-24 07:55:44'),
(19, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 07:45:56'),
(20, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 07:57:28'),
(21, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 08:10:46'),
(22, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 09:33:07'),
(23, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 09:55:14'),
(24, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 10:24:44'),
(25, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 10:35:03'),
(26, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 12:16:16'),
(28, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '2025-01-27 15:31:47'),
(29, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-28 12:31:03'),
(30, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-28 12:48:34'),
(31, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-28 12:51:13'),
(32, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-28 13:01:44'),
(33, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-29 09:11:21'),
(34, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-29 11:38:32'),
(35, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-30 08:18:29'),
(36, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-30 11:47:25'),
(37, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-30 11:51:46'),
(38, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-30 12:04:15'),
(39, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-30 12:05:33'),
(40, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-30 12:21:28'),
(41, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 09:00:40'),
(42, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 11:05:36'),
(43, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 11:22:24'),
(44, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 11:25:50'),
(45, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 11:36:06'),
(46, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 11:41:41'),
(47, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 12:14:53'),
(48, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-01-31 15:29:46'),
(49, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-01 08:46:19'),
(50, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-01 08:47:46'),
(51, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-01 08:49:12'),
(52, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-01 08:51:18'),
(53, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-04 15:42:28'),
(54, 2, '127.0.0.1', 'Localhost - Unknown Location', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-05 09:11:14'),
(55, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-08 09:06:25'),
(56, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-08 09:12:12'),
(57, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-08 11:23:54'),
(58, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-08 14:22:13'),
(59, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-08 16:03:46'),
(60, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-10 07:37:54'),
(61, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-10 13:12:55'),
(62, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-10 13:38:02'),
(63, 2, '84.177.19.98', 'Lohr a. Main, Germany', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', '2025-02-10 18:44:29'),
(64, 2, '39.50.233.7', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-11 08:32:49'),
(65, 2, '79.231.127.225', 'Lohr a. Main, Germany', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:135.0) Gecko/20100101 Firefox/135.0', '2025-02-15 08:35:54'),
(66, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-17 10:40:18'),
(67, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-17 14:50:24'),
(68, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 07:50:59'),
(69, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 08:35:54'),
(70, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 08:37:23'),
(71, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 10:16:59'),
(72, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 12:32:39'),
(73, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 12:43:04'),
(74, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 14:21:39'),
(75, 2, '137.59.221.222', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 14:42:23'),
(76, 2, '43.242.176.248', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 17:33:50'),
(77, 2, '43.242.176.110', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-18 17:43:50'),
(78, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-19 07:52:57'),
(79, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-19 08:15:31'),
(80, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 07:34:31'),
(81, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 07:36:24'),
(82, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 07:39:04'),
(83, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 07:43:24'),
(84, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:00:43'),
(85, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:11:27'),
(86, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:30:06'),
(87, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:30:53'),
(88, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:40:10'),
(89, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:41:47'),
(90, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:45:07'),
(91, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:47:17'),
(92, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:49:05'),
(93, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 09:50:08'),
(94, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 10:09:41'),
(95, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 10:11:32'),
(96, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 11:05:04'),
(97, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 12:09:26'),
(98, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 14:46:39'),
(99, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-20 15:34:53'),
(100, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-21 08:57:02'),
(101, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-21 12:08:15'),
(102, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-21 13:08:26'),
(103, 2, '39.50.235.215', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-21 13:25:48'),
(104, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-25 13:12:22'),
(105, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-25 14:06:03'),
(106, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 07:24:34'),
(107, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 08:02:41'),
(108, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:23:31'),
(109, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:26:56'),
(110, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:31:34'),
(111, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:38:18'),
(112, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:39:25'),
(113, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:42:16'),
(114, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:49:36'),
(115, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 09:50:19'),
(116, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 12:15:26'),
(117, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 12:17:41'),
(118, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 12:50:56'),
(119, 2, '39.50.254.27', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-26 15:11:50'),
(120, 2, '39.50.230.197', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', '2025-02-27 13:41:37'),
(121, 2, '39.50.252.138', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', '2025-03-19 07:46:05'),
(122, 2, '39.50.250.231', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', '2025-03-19 12:07:44'),
(123, 2, '39.50.250.231', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', '2025-03-19 12:11:13'),
(124, 2, '39.50.250.231', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', '2025-03-20 07:12:25'),
(125, 2, '39.50.250.231', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', '2025-03-20 08:27:03'),
(126, 2, '39.50.240.157', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-24 10:25:41'),
(127, 2, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-25 08:41:19'),
(128, 2, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-25 08:43:54'),
(129, 2, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-25 09:36:55'),
(130, 2, '43.242.178.165', 'Jamshoro, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-25 20:05:08'),
(131, 142, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-26 06:45:48'),
(132, 143, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-26 06:46:52'),
(133, 142, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-26 07:13:26'),
(134, 143, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-26 07:39:19'),
(135, 2, '39.50.241.141', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-03-27 10:25:30'),
(136, 2, '91.5.54.51', 'Lohr a. Main, Germany', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', '2025-03-28 18:13:25'),
(137, 2, '84.177.29.253', 'Lohr a. Main, Germany', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0', '2025-03-30 12:48:10'),
(138, 2, '39.50.232.132', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-04-03 08:05:35'),
(139, 143, '39.50.232.132', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-04-03 10:18:59'),
(140, 2, '39.50.232.132', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', '2025-04-03 10:31:31'),
(141, 2, '39.50.247.22', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-04-03 11:17:48'),
(142, 2, '39.50.247.22', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-04-03 11:20:51'),
(143, 2, '84.177.21.183', 'Lohr a. Main, Germany', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0', '2025-04-03 13:18:26'),
(144, 143, '39.50.240.134', 'Hyderabad, Pakistan', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', '2025-04-03 13:26:17');

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

--
-- Table structure for table `seller_payments`
--

CREATE TABLE `seller_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ad_id` bigint(20) UNSIGNED NOT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `duration` varchar(255) DEFAULT NULL,
  `payment_status` varchar(255) NOT NULL DEFAULT 'unpaid',
  `transaction_id` varchar(255) 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 `seller_payments`
--

INSERT INTO `seller_payments` (`id`, `user_id`, `ad_id`, `payment_method`, `amount`, `duration`, `payment_status`, `transaction_id`, `created_at`, `updated_at`) VALUES
(12, 1, 29, 'card', 90.00, '9', 'success', 'cs_test_a1gAtWZYD5B2WvF0ZJwd8X1L1O42VAiFWUMrQbvQOoPLhMwxaRCxNMVc72', '2025-03-01 18:36:14', '2025-03-01 18:36:14'),
(13, 1, 29, 'card', 80.00, '8', 'success', 'cs_test_a1CVPUS3OB09c86YuxKsEkB6TWXCaQXURcHCmYZbNLrDvYrngab5pbtCH5', '2025-03-01 18:36:54', '2025-03-01 18:36:54'),
(14, 1, 30, 'card', 80.00, '8', 'success', 'cs_test_a1AH5mGkMczBUz0QXxL6EJRH93BnhgFLRZl9ZU0IxPBBGqigMXsryu8sOZ', '2025-03-01 18:38:43', '2025-03-01 18:38:43');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `promotion_fee` decimal(10,2) NOT NULL DEFAULT 100.00,
  `promotion_duration` int(11) NOT NULL DEFAULT 7,
  `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 `settings`
--

INSERT INTO `settings` (`id`, `promotion_fee`, `promotion_duration`, `created_at`, `updated_at`) VALUES
(2, 90.00, 9, '2025-01-28 10:48:00', '2025-01-28 10:48:58'),
(3, 80.00, 8, '2025-01-29 06:13:36', '2025-01-29 10:38:31'),
(5, 400.00, 15, '2025-01-29 06:32:57', '2025-01-29 06:32:57');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_status` varchar(255) NOT NULL,
  `stripe_price` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_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;

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

--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subscription_id` bigint(20) UNSIGNED NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_product` varchar(255) NOT NULL,
  `stripe_price` varchar(255) NOT NULL,
  `quantity` 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 `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `images` varchar(255) NOT NULL,
  `category_id` bigint(20) UNSIGNED 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 `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `title`, `description`, `images`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 'black socks', 'Lorem ipsum dolor, sit amet consectetur adipisicing elit. Quia, quo molestiae distinctio esse molestias nihil doloribus magni inventore, ullam aut incidunt aperiam explicabo.', 'storage/subcategories/rhAh8tneInMimM3HzXFSe3tZqVbIPXxkQZ72KpHi.jpg', 1, '2025-02-27 12:10:32', '2025-02-27 12:10:32'),
(2, 'red socks', 'Lorem ipsum dolor, sit amet consectetur adipisicing elit. Quia, quo molestiae distinctio esse molestias nihil doloribus magni inventore, ullam aut incidunt aperiam explicabo.', 'storage/subcategories/fd1cOBvn2SOBM1kRQwv87D3ibsf3F5enh0dZ2Kuc.jpg', 1, '2025-02-27 12:10:56', '2025-02-27 12:10:56'),
(3, 'colorful socks', 'Lorem ipsum dolor, sit amet consectetur adipisicing elit. Quia, quo molestiae distinctio esse molestias nihil doloribus magni inventore, ullam aut incidunt aperiam explicabo.', 'storage/subcategories/mEMw19MNr7ldFH9GqAASvmcqZ7JXCJvdCYymKnFK.jpg', 1, '2025-02-27 12:11:17', '2025-02-27 12:11:17');

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

--
-- Table structure for table `verifications`
--

CREATE TABLE `verifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `file_path` varchar(255) 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 `verifications`
--

INSERT INTO `verifications` (`id`, `user_id`, `file_path`, `created_at`, `updated_at`) VALUES
(21, 143, 'images/1742974480.jpg', '2025-03-26 07:34:40', '2025-03-26 07:34:40');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `additional_refinements`
--
ALTER TABLE `additional_refinements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `additional_refinements_ad_id_foreign` (`ad_id`);

--
-- Indexes for table `admin_messages`
--
ALTER TABLE `admin_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_messages_seller_id_foreign` (`seller_id`);

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

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

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

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

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_user_id_foreign` (`user_id`),
  ADD KEY `carts_ad_id_foreign` (`ad_id`);

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

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

--
-- Indexes for table `customer_payments`
--
ALTER TABLE `customer_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_payments_order_detail_id_foreign` (`order_detail_id`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `media_files`
--
ALTER TABLE `media_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_files_seller_id_foreign` (`seller_id`);

--
-- Indexes for table `media_purchases`
--
ALTER TABLE `media_purchases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_purchases_seller_id_foreign` (`seller_id`),
  ADD KEY `media_purchases_media_id_foreign` (`media_id`);

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_ad_id_foreign` (`ad_id`),
  ADD KEY `orders_order_detail_id_foreign` (`order_detail_id`);

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

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

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

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

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

--
-- Indexes for table `profiles`
--
ALTER TABLE `profiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `profiles_user_id_foreign` (`user_id`),
  ADD KEY `profiles_membership_id_foreign` (`membership_id`);

--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reports_ad_id_foreign` (`ad_id`);

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

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

--
-- Indexes for table `seller_activity_logs`
--
ALTER TABLE `seller_activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `seller_activity_logs_seller_id_foreign` (`seller_id`);

--
-- Indexes for table `seller_payments`
--
ALTER TABLE `seller_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `seller_payments_user_id_foreign` (`user_id`),
  ADD KEY `seller_payments_ad_id_foreign` (`ad_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscriptions_stripe_id_unique` (`stripe_id`),
  ADD KEY `subscriptions_user_id_stripe_status_index` (`user_id`,`stripe_status`);

--
-- Indexes for table `subscription_items`
--
ALTER TABLE `subscription_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscription_items_stripe_id_unique` (`stripe_id`),
  ADD KEY `subscription_items_subscription_id_stripe_price_index` (`subscription_id`,`stripe_price`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `accounts`
--
ALTER TABLE `accounts`
  ADD CONSTRAINT `accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `additional_refinements`
--
ALTER TABLE `additional_refinements`
  ADD CONSTRAINT `additional_refinements_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `admin_messages`
--
ALTER TABLE `admin_messages`
  ADD CONSTRAINT `admin_messages_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ads`
--
ALTER TABLE `ads`
  ADD CONSTRAINT `ads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cans`
--
ALTER TABLE `cans`
  ADD CONSTRAINT `cans_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `can_requests`
--
ALTER TABLE `can_requests`
  ADD CONSTRAINT `can_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_payments`
--
ALTER TABLE `customer_payments`
  ADD CONSTRAINT `customer_payments_order_detail_id_foreign` FOREIGN KEY (`order_detail_id`) REFERENCES `order_details` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `media_files`
--
ALTER TABLE `media_files`
  ADD CONSTRAINT `media_files_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `media_purchases`
--
ALTER TABLE `media_purchases`
  ADD CONSTRAINT `media_purchases_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `media_purchases_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_order_detail_id_foreign` FOREIGN KEY (`order_detail_id`) REFERENCES `order_details` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_requests`
--
ALTER TABLE `payment_requests`
  ADD CONSTRAINT `payment_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `profiles`
--
ALTER TABLE `profiles`
  ADD CONSTRAINT `profiles_membership_id_foreign` FOREIGN KEY (`membership_id`) REFERENCES `memberships` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `reports`
--
ALTER TABLE `reports`
  ADD CONSTRAINT `reports_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sellerads`
--
ALTER TABLE `sellerads`
  ADD CONSTRAINT `sellerads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `seller_activity_logs`
--
ALTER TABLE `seller_activity_logs`
  ADD CONSTRAINT `seller_activity_logs_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `seller_payments`
--
ALTER TABLE `seller_payments`
  ADD CONSTRAINT `seller_payments_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `seller_payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `verifications`
--
ALTER TABLE `verifications`
  ADD CONSTRAINT `verifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

