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

START TRANSACTION;



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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `link` text DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `heading`, `position`, `image`, `link`, `description`, `status`, `created_at`, `updated_at`) VALUES
(2, NULL, NULL, 1, 'banner/1743526646_img-gallery-1.jpg', NULL, NULL, 1, '2025-04-01 11:27:17', '2025-04-05 10:27:10'),
(3, 'new offfer for you', 'Happy offer', 2, 'banner/1743771452_silly1.png', NULL, 'new offer', 0, '2025-04-04 12:57:32', '2025-04-04 12:57:32');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `publish_at` date NOT NULL,
  `tags` text DEFAULT NULL,
  `categories` text DEFAULT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `image`, `publish_at`, `tags`, `categories`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ut omnis dolores nul', 'blog/1738147498_blog_img.png', '2001-10-11', '[\"Laudantium\",\"vero\"]', '[\"Quia soluta\",\"dignissi\"]', 'But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?\n\n“sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.”\n\nBykewala Emranx\nSed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt.', 1, '2025-01-29 04:24:41', '2025-01-29 05:14:58'),
(2, 'Ut omnis dolores nul', 'blog/1738147498_blog_img.png', '2001-10-11', '[\"Laudantium\",\"vero\"]', '[\"Quia soluta\",\"dignissi\"]', 'But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?\r\n\r\n“sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.”\r\n\r\nBykewala Emranx\r\nSed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt.', 1, '2025-01-29 04:24:41', '2025-01-29 05:14:58'),
(3, 'Ut omnis dolores nul', 'blog/1738147498_blog_img.png', '2001-10-11', '[\"Laudantium\",\"vero\"]', '[\"Quia soluta\",\"dignissi\"]', 'But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?\r\n\r\n“sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.”\r\n\r\nBykewala Emranx\r\nSed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt.', 1, '2025-01-29 04:24:41', '2025-01-29 05:14:58');

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

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

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

INSERT INTO `contacts` (`id`, `name`, `phone`, `email`, `message`, `created_at`, `updated_at`) VALUES
(1, 'Grant Ortiz', '5455364989', 'vywegyhi@mailinator.com', 'Quae reprehenderit d', '2025-01-30 04:22:47', '2025-01-30 04:22:47'),
(2, 'Indira Crawford', '5926545887', 'ryguta@mailinator.com', 'Elit voluptatum pro', '2025-01-30 04:26:49', '2025-01-30 04:26:49');

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

--
-- Table structure for table `device_logins`
--

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

INSERT INTO `device_logins` (`id`, `user_id`, `device_id`, `device_name`, `created_at`, `updated_at`) VALUES
(8, 15, '1', 'oppo', '2025-02-06 00:43:52', '2025-02-06 00:43:52'),
(11, 6, 'a2', 'dfdf', '2025-02-13 00:59:24', '2025-02-13 00:59:24'),
(13, 15, 'RKQ1.201004.002', 'Redmi Note 8', '2025-04-02 15:06:23', '2025-04-02 15:06:23'),
(14, 6, 'RKQ1.201004.002', 'Redmi Note 8', '2025-04-02 15:25:59', '2025-04-02 15:25:59'),
(15, 22, 'RKQ1.201004.002', 'Redmi Note 8', '2025-04-03 16:24:44', '2025-04-03 16:24:44'),
(17, 24, 'UP1A.231005.007', 'RMX3852', '2025-04-04 13:09:31', '2025-04-04 13:09:31'),
(18, 24, 'RKQ1.201004.002', 'Redmi Note 8', '2025-04-04 13:34:58', '2025-04-04 13:34:58'),
(19, 25, 'RKQ1.201004.002', 'Redmi Note 8', '2025-04-06 19:38:40', '2025-04-06 19:38:40'),
(20, 26, '1', 'oppo', '2025-05-21 03:06:05', '2025-05-21 03:06:05'),
(21, 28, '1', 'oppo', '2025-05-21 03:11:03', '2025-05-21 03:11:03'),
(22, 29, '1', 'oppo', '2025-05-21 03:12:12', '2025-05-21 03:12:12');

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

--
-- Table structure for table `device_subscriptions`
--

CREATE TABLE `device_subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `device_id` varchar(255) NOT NULL,
  `device_name` varchar(255) NOT NULL,
  `data_use` bigint(20) NOT NULL DEFAULT 0,
  `time_duration` bigint(20) NOT NULL DEFAULT 0,
  `duration` int(11) NOT NULL,
  `duration_type` 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;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `title`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'f', 'ff', 1, '2025-05-21 02:59:14', '2025-05-21 02:59:31');

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

--
-- Table structure for table `feed_backs`
--

CREATE TABLE `feed_backs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feed_backs`
--

INSERT INTO `feed_backs` (`id`, `user_id`, `title`, `description`, `status`, `created_at`, `updated_at`) VALUES
(2, 6, 'Hello', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 0, '2025-05-21 03:08:06', '2025-05-21 03:08:06');

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

--
-- Table structure for table `generals`
--

CREATE TABLE `generals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `terms_and_condition` text DEFAULT NULL,
  `privacy_policy` text DEFAULT NULL,
  `security` text DEFAULT NULL,
  `eula` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `generals`
--

INSERT INTO `generals` (`id`, `terms_and_condition`, `privacy_policy`, `security`, `eula`, `status`, `created_at`, `updated_at`) VALUES
(1, '<p><span style=\"font-weight: bolder; margin: 0px; padding: 0px; font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">Lorem Ipsum</span><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', '<p><strong style=\"margin: 0px; padding: 0px; font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">Lorem Ipsum</strong><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', '<p><strong style=\"margin: 0px; padding: 0px; font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">Lorem Ipsum</strong><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', '<p>This is sample eula</p>', 1, '2025-01-30 01:00:53', '2025-07-11 00:03: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
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '2025_01_28_112155_create_admins_table', 2),
(4, '2025_01_29_045559_create_plans_table', 3),
(5, '2025_01_29_081506_create_banners_table', 4),
(6, '2025_01_29_085854_create_blogs_table', 5),
(7, '2025_01_29_102831_create_partners_table', 6),
(8, '2025_01_29_113929_create_testimonials_table', 7),
(9, '2025_01_30_054229_create_settings_table', 8),
(11, '2025_01_30_060400_create_generals_table', 9),
(12, '2025_01_30_083423_create_tips_and_tricks_table', 10),
(13, '2025_01_30_093951_create_contacts_table', 11),
(14, '2025_01_31_070902_create_subscriptions_table', 12),
(15, '2025_01_31_074345_create_servers_table', 13),
(16, '2025_01_31_114236_create_recharges_table', 14),
(17, '2025_02_01_064720_create_personal_access_tokens_table', 15),
(18, '2025_02_03_073314_create_device_logins_table', 16),
(19, '2025_02_06_082524_create_payment_settings_table', 17),
(20, '2025_02_12_151702_create_device_subscriptions_table', 18),
(22, '2025_03_29_041651_create_otps_table', 19),
(23, '2025_05_21_043631_create_faqs_table', 19),
(24, '2025_05_21_050414_create_feed_backs_table', 19),
(25, '2025_09_19_123150_create_supports_table', 20);

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `title`, `image`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Lorem Ipsum is simply dummy text of the printing', 'partner/1738147201_logo1.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 1, '2025-01-29 05:10:01', '2025-01-29 05:10:01'),
(2, 'Occaecat minima enim', 'partner/1738147286_logo2.png', 'Fuga Voluptatem nis', 1, '2025-01-29 05:11:26', '2025-01-29 05:11:26'),
(3, 'Ea est ab quasi unde', 'partner/1738147424_logo3.png', 'Eligendi consequatur', 1, '2025-01-29 05:13:44', '2025-01-29 05:13:44'),
(4, 'Asperiores inventore', 'partner/1738147436_logo4.png', 'Dolore sapiente sed', 1, '2025-01-29 05:13:56', '2025-01-29 05:13:56'),
(5, 'Asperiores aut persp', 'partner/1738147448_logo5.png', 'Corrupti in reicien', 1, '2025-01-29 05:14:08', '2025-01-29 05:14:08'),
(6, 'Eligendi et qui quas', 'partner/1738147459_logo6.png', 'Harum quam dicta vel', 1, '2025-01-29 05:14:19', '2025-01-29 05:14:19');

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

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

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `duration` int(11) NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `discount_price` decimal(8,2) NOT NULL,
  `price_type` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `device` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` (`id`, `title`, `duration`, `price`, `discount_price`, `price_type`, `description`, `device`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Free Plan', 1, 0.00, 0.00, 'Day', 'Free User Registration', 1, 1, '2025-01-29 00:59:23', '2025-02-12 11:07:42'),
(2, 'Device Plan', 3, 430.00, 4.49, 'Day', 'Free Device Registration', 1, 1, '2025-01-29 01:01:50', '2025-01-29 01:06:08'),
(3, 'standard Plan', 5, 430.00, 6.90, 'Year', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 1, 1, '2025-01-29 01:05:37', '2025-01-29 01:05:37'),
(4, 'gold Plan', 7, 430.00, 9.49, 'Year', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 1, 1, '2025-01-29 01:06:54', '2025-01-29 01:18:45'),
(5, 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 'ok', 1, 1, '2025-02-06 01:23:39', '2025-02-06 01:23:39'),
(6, 'Premium Plan', 3, 430.00, 4.49, 'Year', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 1, 1, '2025-01-29 01:01:50', '2025-01-29 01:06:08');

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

--
-- Table structure for table `recharges`
--

CREATE TABLE `recharges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `free_time` int(11) NOT NULL,
  `recharge_time` int(11) NOT NULL,
  `notification_time` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `recharges`
--

INSERT INTO `recharges` (`id`, `free_time`, `recharge_time`, `notification_time`, `status`, `created_at`, `updated_at`) VALUES
(1, 60, 120, 180, 1, '2025-01-31 06:32:14', '2025-01-31 06:32:33');

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

--
-- 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,
  `phone1` varchar(255) DEFAULT NULL,
  `phone2` varchar(255) DEFAULT NULL,
  `phone3` varchar(255) DEFAULT NULL,
  `email1` varchar(255) DEFAULT NULL,
  `email2` varchar(255) DEFAULT NULL,
  `email3` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `pinterest` varchar(255) DEFAULT NULL,
  `reddit` varchar(255) DEFAULT NULL,
  `vimeo` varchar(255) DEFAULT NULL,
  `github` varchar(255) DEFAULT NULL,
  `telegram` varchar(255) DEFAULT NULL,
  `behence` varchar(255) DEFAULT NULL,
  `address1` text DEFAULT NULL,
  `address2` text DEFAULT NULL,
  `android_link` varchar(255) DEFAULT NULL,
  `ios_link` varchar(255) DEFAULT NULL,
  `desktop_link` varchar(255) DEFAULT NULL,
  `mac_os_link` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `sticky_logo` varchar(255) DEFAULT NULL,
  `android_reward_id` varchar(255) DEFAULT NULL,
  `apple_reward_id` varchar(255) DEFAULT NULL,
  `admob_id` varchar(255) DEFAULT NULL,
  `android_revenue_id` varchar(255) DEFAULT NULL,
  `apple_revenue_id` varchar(255) DEFAULT NULL,
  `android_open_unit_id` varchar(255) DEFAULT NULL,
  `ios_open_unit_id` varchar(255) DEFAULT NULL,
  `android_native_unit_id` varchar(255) DEFAULT NULL,
  `ios_native_unit_id` varchar(255) DEFAULT NULL,
  `android_interstitial_unit_id` varchar(255) DEFAULT NULL,
  `ios_interstitial_unit_id` varchar(255) DEFAULT NULL,
  `android_banner_unit_id` varchar(255) DEFAULT NULL,
  `ios_banner_unit_id` varchar(255) DEFAULT NULL,
  `android_revenuecat_unit_id` varchar(255) DEFAULT NULL,
  `ios_revenuecat_unit_id` varchar(255) DEFAULT NULL,
  `share` text DEFAULT NULL,
  `free_time` int(11) DEFAULT NULL,
  `recharge_time` int(11) DEFAULT NULL,
  `notification_time` int(11) DEFAULT NULL,
  `allow_device` 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;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `phone1`, `phone2`, `phone3`, `email1`, `email2`, `email3`, `whatsapp`, `facebook`, `instagram`, `linkedin`, `twitter`, `youtube`, `pinterest`, `reddit`, `vimeo`, `github`, `telegram`, `behence`, `address1`, `address2`, `android_link`, `ios_link`, `desktop_link`, `mac_os_link`, `logo`, `sticky_logo`, `android_reward_id`, `apple_reward_id`, `admob_id`, `android_revenue_id`, `apple_revenue_id`, `android_open_unit_id`, `ios_open_unit_id`, `android_native_unit_id`, `ios_native_unit_id`, `android_interstitial_unit_id`, `ios_interstitial_unit_id`, `android_banner_unit_id`, `ios_banner_unit_id`, `android_revenuecat_unit_id`, `ios_revenuecat_unit_id`, `share`, `free_time`, `recharge_time`, `notification_time`, `allow_device`, `created_at`, `updated_at`) VALUES
(1, '919131220924', NULL, NULL, 'chandrakaraakash60@gmail.com', NULL, NULL, NULL, 'https://x.com/GreenLeaf_VPN', 'https://x.com/GreenLeaf_VPN', 'https://x.com/GreenLeaf_VPN', 'https://x.com/GreenLeaf_VPN', 'https://x.com/GreenLeaf_VPN', 'https://x.com/GreenLeaf_VPN', NULL, NULL, NULL, NULL, NULL, '8565 Manina Avenue • Brisbon Street NY 91335, United States', NULL, 'upcommig', 'upcommig', 'upcommig', 'Upcomming', 'logo/1750439658_Screenshot_1.jpg', 'sticky_logo/1750439658_Screenshot_1.jpg', 'ca-app-pub-3940256099942544/1712485313', 'ca-app-pub-3940256099942544/1712485313', 'ca-app-pub-3940256099942544/1712485313', 'ca-app-pub-3940256099942544/1712485313', 'ca-app-pub-3940256099942544/1712485313', 'ca-app-pub-3940256099942544/9257395921', 'ca-app-pub-3940256099942544/5575463023', 'ca-app-pub-3940256099942544/2247696110', 'ca-app-pub-3940256099942544/3986624511', 'ca-app-pub-3940256099942544/1033173712', 'ca-app-pub-3940256099942544/4411468910', 'ca-app-pub-3940256099942544/9214589741', 'ca-app-pub-3940256099942544/2435281174', 'ra', 'ri', 'ok', 1800, 900, 3, 2, '2025-01-30 00:31:49', '2025-07-11 00:04:11');

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

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

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) NOT NULL,
  `payment_status` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `duration` int(11) NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `discount_price` decimal(8,2) NOT NULL,
  `price_type` varchar(255) NOT NULL,
  `device` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `user_id`, `plan_id`, `order_id`, `payment_id`, `payment_method`, `payment_status`, `title`, `duration`, `price`, `discount_price`, `price_type`, `device`, `status`, `created_at`, `updated_at`) VALUES
(3, 6, 1, '11', '324dsf', 'inapp', '', 'ww', 1, 150.00, 120.00, 'month', 1, 0, '2025-02-02 04:48:38', '2025-02-02 04:48:38'),
(4, 6, 1, '1738565536_6', NULL, 'Stripe', 'Success', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-03 01:22:16', '2025-02-03 01:22:43'),
(5, 6, 1, '1738565627_6', 'pi_3QoJY5LPc4bUcGLc1bHWI54x', 'Stripe', 'Success', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-03 01:23:47', '2025-02-03 01:24:32'),
(6, 6, 1, '1738566644_6', NULL, 'Stripe', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-03 01:40:44', '2025-02-03 01:40:44'),
(7, 6, 1, '1738567841_6', NULL, 'Stripe', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-03 02:00:41', '2025-02-03 02:00:41'),
(8, 6, 1, '1738567897_6', NULL, 'Stripe', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-03 02:01:37', '2025-02-03 02:01:37'),
(9, 6, 2, '1738575438_6', 'pi_3QoM70LPc4bUcGLc1sCXR5dR', 'Stripe', 'Success', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-03 04:07:18', '2025-02-03 04:09:06'),
(14, 6, 4, '1739032913_6', NULL, 'Stripe', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-08 11:11:53', '2025-02-08 11:11:53'),
(15, 6, 1, '1739034015_6', NULL, 'Stripe', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 11:30:15', '2025-02-08 11:30:15'),
(16, 6, 1, '1739034062_6', NULL, 'Stripe', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 11:31:02', '2025-02-08 11:31:02'),
(17, 6, 1, '1739034164_6', NULL, 'Stripe', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 11:32:44', '2025-02-08 11:32:44'),
(18, 6, 1, '1739034299_6', NULL, 'Stripe', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 11:34:59', '2025-02-08 11:34:59'),
(19, 6, 1, '1739036581_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:13:01', '2025-02-08 12:13:01'),
(20, 6, 1, '1739036623_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:13:43', '2025-02-08 12:13:43'),
(21, 6, 1, '1739036728_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:15:29', '2025-02-08 12:15:29'),
(22, 6, 1, '1739037241_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:24:01', '2025-02-08 12:24:01'),
(23, 6, 1, '1739037266_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:24:26', '2025-02-08 12:24:26'),
(24, 6, 1, '1739037321_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:25:21', '2025-02-08 12:25:21'),
(25, 6, 1, '1739037323_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:25:23', '2025-02-08 12:25:23'),
(26, 6, 1, '1739037324_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:25:24', '2025-02-08 12:25:24'),
(27, 6, 1, '1739037350_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:25:50', '2025-02-08 12:25:50'),
(28, 6, 1, '1739037411_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:26:51', '2025-02-08 12:26:51'),
(29, 6, 1, '1739037420_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:27:00', '2025-02-08 12:27:00'),
(30, 6, 1, '1739037454_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:27:34', '2025-02-08 12:27:34'),
(31, 6, 1, '1739037483_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:28:03', '2025-02-08 12:28:03'),
(32, 6, 1, '1739037490_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:28:10', '2025-02-08 12:28:10'),
(33, 6, 1, '1739037877_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:34:37', '2025-02-08 12:34:37'),
(34, 6, 1, '1739037974_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:36:14', '2025-02-08 12:36:14'),
(35, 6, 1, '1739038232_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:40:32', '2025-02-08 12:40:32'),
(36, 6, 1, '1739038243_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:40:43', '2025-02-08 12:40:43'),
(37, 6, 1, '1739038384_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:43:04', '2025-02-08 12:43:04'),
(38, 6, 1, '1739038439_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:43:59', '2025-02-08 12:43:59'),
(39, 6, 1, '1739038503_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:45:03', '2025-02-08 12:45:03'),
(40, 6, 1, '1739038564_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:46:04', '2025-02-08 12:46:04'),
(41, 6, 1, '1739038795_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:49:55', '2025-02-08 12:49:55'),
(42, 6, 1, '1739038809_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:50:09', '2025-02-08 12:50:09'),
(43, 6, 1, '1739039093_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:54:53', '2025-02-08 12:54:53'),
(44, 6, 1, '1739039171_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:56:11', '2025-02-08 12:56:11'),
(45, 6, 1, '1739039363_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 12:59:23', '2025-02-08 12:59:23'),
(46, 6, 1, '1739039453_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:00:53', '2025-02-08 13:00:53'),
(47, 6, 1, '1739039636_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:03:56', '2025-02-08 13:03:56'),
(48, 6, 1, '1739039648_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:04:08', '2025-02-08 13:04:08'),
(49, 6, 1, '1739039679_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:04:39', '2025-02-08 13:04:39'),
(50, 6, 1, '1739039680_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:04:40', '2025-02-08 13:04:40'),
(51, 6, 1, '1739039696_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:04:56', '2025-02-08 13:04:56'),
(52, 6, 1, '1739039879_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:07:59', '2025-02-08 13:07:59'),
(53, 6, 1, '1739039900_6', NULL, 'Unio', 'Pending', 'Basic Plan', 1, 430.00, 3.49, 'Year', 1, 0, '2025-02-08 13:08:20', '2025-02-08 13:08:20'),
(54, 6, 5, '1739115130_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:02:10', '2025-02-09 10:02:10'),
(55, 6, 5, '1739115337_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:05:37', '2025-02-09 10:05:37'),
(56, 6, 5, '1739116082_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:18:02', '2025-02-09 10:18:02'),
(57, 6, 5, '1739116233_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:20:33', '2025-02-09 10:20:33'),
(58, 6, 5, '1739116321_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:22:01', '2025-02-09 10:22:01'),
(59, 6, 5, '1739116328_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:22:08', '2025-02-09 10:22:08'),
(60, 6, 5, '1739116367_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:22:47', '2025-02-09 10:22:47'),
(61, 6, 5, '1739116395_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:23:15', '2025-02-09 10:23:15'),
(62, 6, 5, '1739116652_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 10:27:32', '2025-02-09 10:27:32'),
(63, 6, 4, '1739116719_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:28:39', '2025-02-09 10:28:39'),
(64, 6, 4, '1739116724_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:28:44', '2025-02-09 10:28:44'),
(65, 6, 4, '1739117318_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:38:38', '2025-02-09 10:38:38'),
(66, 6, 4, '1739117349_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:39:09', '2025-02-09 10:39:09'),
(67, 6, 4, '1739117440_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:40:40', '2025-02-09 10:40:40'),
(68, 6, 4, '1739117465_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:41:05', '2025-02-09 10:41:05'),
(69, 6, 4, '1739117480_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:41:20', '2025-02-09 10:41:20'),
(70, 6, 4, '1739117509_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:41:49', '2025-02-09 10:41:49'),
(71, 6, 4, '1739117589_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-09 10:43:09', '2025-02-09 10:43:09'),
(72, 6, 5, '1739162893_6', NULL, 'Unio', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-09 23:18:13', '2025-02-09 23:18:13'),
(73, 6, 6, '1739639856_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 11:47:36', '2025-02-15 11:47:36'),
(74, 6, 6, '1739639899_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 11:48:19', '2025-02-15 11:48:19'),
(75, 6, 6, '1739639905_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 11:48:25', '2025-02-15 11:48:25'),
(76, 6, 6, '1739640067_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 11:51:07', '2025-02-15 11:51:07'),
(77, 6, 6, '1739640297_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 11:54:57', '2025-02-15 11:54:57'),
(78, 6, 6, '1739640299_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 11:54:59', '2025-02-15 11:54:59'),
(79, 6, 6, '1739640656_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:00:56', '2025-02-15 12:00:56'),
(80, 6, 6, '1739640781_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:03:01', '2025-02-15 12:03:01'),
(81, 6, 6, '1739640789_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:03:09', '2025-02-15 12:03:09'),
(82, 6, 6, '1739640792_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:03:12', '2025-02-15 12:03:12'),
(83, 6, 6, '1739641865_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:21:05', '2025-02-15 12:21:05'),
(84, 6, 5, '1739642101_6', NULL, 'Paypal', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-15 12:25:01', '2025-02-15 12:25:01'),
(85, 6, 5, '1739642181_6', NULL, 'Paypal', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-15 12:26:21', '2025-02-15 12:26:21'),
(86, 6, 5, '1739642416_6', NULL, 'Paypal', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-15 12:30:16', '2025-02-15 12:30:16'),
(87, 6, 5, '1739642447_6', NULL, 'Paypal', 'Pending', 'Tempore maiores pos', 4, 50.00, 45.00, 'Month', 1, 0, '2025-02-15 12:30:47', '2025-02-15 12:30:47'),
(88, 6, 6, '1739642598_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:33:18', '2025-02-15 12:33:18'),
(89, 6, 6, '1739642617_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:33:37', '2025-02-15 12:33:37'),
(90, 6, 6, '1739642639_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-15 12:33:59', '2025-02-15 12:33:59'),
(91, 6, 6, '1739642687_6', '89V67401YL561525H', 'Paypal', 'Success', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2024-12-31 18:30:00', '2025-03-01 01:44:41'),
(92, 6, 4, '1739719602_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-16 09:56:42', '2025-02-16 09:56:42'),
(93, 6, 4, '1739719653_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-16 09:57:33', '2025-02-16 09:57:33'),
(94, 6, 4, '1739722889_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-16 10:51:29', '2025-02-16 10:51:29'),
(95, 6, 4, '1739723415_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-16 11:00:15', '2025-02-16 11:00:15'),
(96, 6, 4, '1739723438_6', NULL, 'Unio', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-16 11:00:38', '2025-02-16 11:00:38'),
(97, 6, 4, '1739810037_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 11:03:57', '2025-02-17 11:03:57'),
(98, 6, 4, '1739811556_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 11:29:16', '2025-02-17 11:29:16'),
(99, 6, 4, '1739811657_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 11:30:57', '2025-02-17 11:30:57'),
(100, 6, 4, '1739811680_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 11:31:20', '2025-02-17 11:31:20'),
(101, 6, 4, '1739811753_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 11:32:33', '2025-02-17 11:32:33'),
(102, 6, 4, '1739813685_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 12:04:45', '2025-02-17 12:04:45'),
(103, 6, 4, '1739813920_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 12:08:40', '2025-02-17 12:08:40'),
(104, 6, 4, '1739813922_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 12:08:42', '2025-02-17 12:08:42'),
(105, 6, 4, '1739813924_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 12:08:44', '2025-02-17 12:08:44'),
(106, 6, 4, '1739813949_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 12:09:09', '2025-02-17 12:09:09'),
(107, 6, 4, '1739813974_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-17 12:09:34', '2025-02-17 12:09:34'),
(108, 6, 3, '1739818236_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:20:36', '2025-02-17 13:20:36'),
(109, 6, 3, '1739818267_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:21:07', '2025-02-17 13:21:07'),
(110, 6, 3, '1739818317_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:21:57', '2025-02-17 13:21:57'),
(111, 6, 3, '1739818411_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:23:31', '2025-02-17 13:23:31'),
(112, 6, 3, '1739818484_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:24:44', '2025-02-17 13:24:44'),
(113, 6, 3, '1739818552_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:25:52', '2025-02-17 13:25:52'),
(114, 6, 3, '1739818708_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:28:28', '2025-02-17 13:28:28'),
(115, 6, 3, '1739818731_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:28:51', '2025-02-17 13:28:51'),
(116, 6, 3, '1739818800_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:30:00', '2025-02-17 13:30:00'),
(117, 6, 3, '1739818836_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:30:36', '2025-02-17 13:30:36'),
(118, 6, 3, '1739818877_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:31:17', '2025-02-17 13:31:17'),
(119, 6, 3, '1739818888_6', NULL, 'Paypal', 'Pending', 'standard Plan', 5, 430.00, 6.90, 'Year', 1, 0, '2025-02-17 13:31:28', '2025-02-17 13:31:28'),
(120, 6, 6, '1739818942_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-17 13:32:22', '2025-02-17 13:32:22'),
(121, 6, 6, '1739818970_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-17 13:32:50', '2025-02-17 13:32:50'),
(122, 6, 6, '1739818986_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-17 13:33:06', '2025-02-17 13:33:06'),
(123, 6, 6, '1739818996_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-17 13:33:16', '2025-02-17 13:33:16'),
(124, 6, 6, '1739819014_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-17 13:33:34', '2025-02-17 13:33:34'),
(125, 6, 6, '1739819031_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-17 13:33:51', '2025-02-17 13:33:51'),
(126, 6, 6, '1739819045_6', NULL, 'Paypal', 'Pending', 'Premium Plan', 3, 430.00, 4.49, 'Year', 1, 0, '2025-02-17 13:34:05', '2025-02-17 13:34:05'),
(127, 6, 4, '1739861028_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-18 01:13:48', '2025-02-18 01:13:48'),
(128, 6, 4, '1739861081_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-18 01:14:41', '2025-02-18 01:14:41'),
(129, 6, 4, '1739861360_6', NULL, 'Paypal', 'Pending', 'gold Plan', 7, 430.00, 9.49, 'Year', 1, 0, '2025-02-18 01:19:20', '2025-02-18 01:19:20'),
(130, 18, 1, '1741193521_18', NULL, 'Free', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-03-05 11:22:01', '2025-03-05 11:22:01'),
(132, 20, 1, '1743130753_20', NULL, 'Free', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-03-27 18:30:00', '2025-03-27 21:29:45'),
(134, 22, 1, '1743697484_22', NULL, 'Admin Paid', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-04-04 00:00:00', '2025-04-03 16:26:40'),
(136, 24, 1, '1743772171_24', NULL, 'Admin Paid', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-04-09 00:00:00', '2025-04-05 18:53:08'),
(137, 25, 1, '1743968320_25', NULL, 'Free', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-04-06 19:38:40', '2025-04-06 19:38:40'),
(138, 26, 1, '1747816565_26', NULL, 'Free', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-05-21 03:06:05', '2025-05-21 03:06:05'),
(139, 28, 1, '1747816863_28', NULL, 'Free', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-05-21 03:11:03', '2025-05-21 03:11:03'),
(140, 29, 1, '1747816932_29', NULL, 'Free', 'Trial', 'Free Plan', 1, 0.00, 0.00, 'Day', 1, 0, '2025-05-21 03:12:12', '2025-05-21 03:12:12');

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

--
-- Table structure for table `supports`
--

CREATE TABLE `supports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`message`)),
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `designation`, `position`, `image`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Jennifer Lida', 'UX Consultant', 1, 'testimonial/1738159784_testimonial1.png', 'World where everyone is carrying around small computer one', 1, '2025-01-29 08:39:44', '2025-01-29 08:43:01');

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

--
-- Table structure for table `tips_and_tricks`
--

CREATE TABLE `tips_and_tricks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `publish_at` date NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tips_and_tricks`
--

INSERT INTO `tips_and_tricks` (`id`, `title`, `image`, `publish_at`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Lorem Ipsum is simply dummy text of the printing', 'tipsAndTricks/1738227250_blog_img3.png', '2025-01-30', '<p><strong style=\"margin: 0px; padding: 0px; font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">Lorem Ipsum</strong><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', 1, '2025-01-30 03:24:10', '2025-01-30 03:26:27'),
(2, 'Lorem Ipsum is simply dummy text', 'tipsAndTricks/1738232841_blog_img5.png', '2025-01-30', '<p><strong style=\"margin: 0px; padding: 0px; font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">Lorem Ipsum</strong><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', 1, '2025-01-30 04:57:21', '2025-01-30 04:57:26'),
(3, 'Lorem Ipsum is simply dummy text', 'tipsAndTricks/1738232841_blog_img5.png', '2025-01-30', '<p><strong style=\"margin: 0px; padding: 0px; font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">Lorem Ipsum</strong><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;\">&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span></p>', 1, '2025-01-30 04:57:21', '2025-01-30 04:57:26');

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `recharges`
--
ALTER TABLE `recharges`
  ADD PRIMARY KEY (`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 KEY `subscriptions_user_id_foreign` (`user_id`),
  ADD KEY `subscriptions_plan_id_foreign` (`plan_id`);

--
-- Indexes for table `supports`
--
ALTER TABLE `supports`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `supports_ticket_id_unique` (`ticket_id`),
  ADD KEY `supports_user_id_foreign` (`user_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

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

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

--
-- Constraints for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subscriptions_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

