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

START TRANSACTION;



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

--
-- Table structure for table `contact_lists`
--

CREATE TABLE `contact_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_url` varchar(255) NOT NULL,
  `count_contacts` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `flag` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `native_name` varchar(255) NOT NULL,
  `phone_code` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `flag`, `name`, `native_name`, `phone_code`, `status`, `created_at`, `updated_at`) VALUES
(1, '🇮🇷', 'Iran', 'Iran', '+98', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(2, '🇦🇩', 'Andorra', 'Andorra', '+376', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(3, '🇦🇪', 'United Arab Emirates', 'United Arab Emirates', '+971', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(4, '🇦🇫', 'Afghanistan', 'Afghanistan', '+93', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(7, '🇦🇱', 'Albania', 'Albania', '+355', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(8, '🇦🇲', 'Armenia', 'Armenia', '+374', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(9, '🇦🇴', 'Angola', 'Angola', '+244', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(10, '🇦🇶', 'Antarctica', 'Antarctica', '+672', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(11, '🇦🇷', 'Argentina', 'Argentina', '+54', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(13, '🇦🇹', 'Austria', 'Austria', '+43', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(14, '🇦🇺', 'Australia', 'Australia', '+61', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(15, '🇦🇼', 'Aruba', 'Aruba', '+297', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(16, '🇦🇽', 'Åland Islands', 'Åland Islands', '+358', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(17, '🇦🇿', 'Azerbaijan', 'Azerbaijan', '+994', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(18, '🇧🇦', 'Bosnia & Herzegovina', 'Bosnia & Herzegovina', '+387', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(20, '🇧🇩', 'Bangladesh', 'Bangladesh', '+880', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(21, '🇧🇪', 'Belgium', 'Belgium', '+32', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(22, '🇧🇫', 'Burkina Faso', 'Burkina Faso', '+226', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(23, '🇧🇬', 'Bulgaria', 'Bulgaria', '+359', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(24, '🇧🇭', 'Bahrain', 'Bahrain', '+973', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(25, '🇧🇮', 'Burundi', 'Burundi', '+257', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(26, '🇧🇯', 'Benin', 'Benin', '+229', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(27, '🇧🇱', 'Saint Barthélemy', 'Saint Barthélemy', '+590', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(29, '🇧🇳', 'Brunei Darussalam', 'Brunei Darussalam', '+673', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(30, '🇧🇴', 'Bolivia, Plurinational State Of', 'Bolivia, Plurinational State Of', '+591', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(31, '🇧🇶', 'Bonaire, Saint Eustatius And Saba', 'Bonaire, Saint Eustatius And Saba', '+599', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(32, '🇧🇷', 'Brazil', 'Brazil', '+55', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(34, '🇧🇹', 'Bhutan', 'Bhutan', '+975', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(35, '🇧🇼', 'Botswana', 'Botswana', '+267', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(36, '🇧🇾', 'Belarus', 'Belarus', '+375', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(37, '🇧🇿', 'Belize', 'Belize', '+501', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(38, '🇨🇦', 'Canada', 'Canada', '+1', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(39, '🇨🇨', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', '+61', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(40, '🇨🇩', 'Democratic Republic Of Congo', 'Democratic Republic Of Congo', '+243', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(41, '🇨🇫', 'Central African Republic', 'Central African Republic', '+236', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(42, '🇨🇬', 'Republic Of Congo', 'Republic Of Congo', '+242', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(43, '🇨🇭', 'Switzerland', 'Switzerland', '+41', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(44, '🇨🇮', 'Côte d\'Ivoire', 'Côte d\'Ivoire', '+225', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(45, '🇨🇰', 'Cook Islands', 'Cook Islands', '+682', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(46, '🇨🇱', 'Chile', 'Chile', '+56', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(47, '🇨🇲', 'Cameroon', 'Cameroon', '+237', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(48, '🇨🇳', 'China', 'China', '+86', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(49, '🇨🇴', 'Colombia', 'Colombia', '+57', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(50, '🇨🇷', 'Costa Rica', 'Costa Rica', '+506', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(51, '🇨🇺', 'Cuba', 'Cuba', '+53', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(52, '🇨🇻', 'Cabo Verde', 'Cabo Verde', '+238', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(53, '🇨🇼', 'Curacao', 'Curacao', '+599', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(54, '🇨🇽', 'Christmas Island', 'Christmas Island', '+61', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(55, '🇨🇾', 'Cyprus', 'Cyprus', '+357', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(56, '🇨🇿', 'Czech Republic', 'Czech Republic', '+420', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(57, '🇩🇪', 'Germany', 'Germany', '+49', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(58, '🇩🇯', 'Djibouti', 'Djibouti', '+253', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(59, '🇩🇰', 'Denmark', 'Denmark', '+45', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(62, '🇩🇿', 'Algeria', 'Algeria', '+213', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(63, '🇪🇨', 'Ecuador', 'Ecuador', '+593', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(64, '🇪🇪', 'Estonia', 'Estonia', '+372', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(65, '🇪🇬', 'Egypt', 'Egypt', '+20', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(66, '🇪🇭', 'Western Sahara', 'Western Sahara', '+212', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(67, '🇪🇷', 'Eritrea', 'Eritrea', '+291', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(68, '🇪🇸', 'Spain', 'Spain', '+34', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(69, '🇪🇹', 'Ethiopia', 'Ethiopia', '+251', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(70, '🇪🇺', 'European Union', 'European Union', '+388', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(71, '🇫🇮', 'Finland', 'Finland', '+358', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(72, '🇫🇯', 'Fiji', 'Fiji', '+679', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(73, '🇫🇰', 'Falkland Islands', 'Falkland Islands', '+500', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(74, '🇫🇲', 'Micronesia, Federated States Of', 'Micronesia, Federated States Of', '+691', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(75, '🇫🇴', 'Faroe Islands', 'Faroe Islands', '+298', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(76, '🇫🇷', 'France', 'France', '+33', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(77, '🇬🇦', 'Gabon', 'Gabon', '+241', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(78, '🇬🇧', 'United Kingdom', 'United Kingdom', '+44', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(79, '🇬🇩', 'Grenada', 'Grenada', '+473', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(80, '🇬🇪', 'Georgia', 'Georgia', '+995', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(81, '🇬🇫', 'French Guiana', 'French Guiana', '+594', 1, '2025-04-18 15:07:55', '2025-04-18 15:07:55'),
(82, '🇬🇬', 'Guernsey', 'Guernsey', '+44', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(83, '🇬🇭', 'Ghana', 'Ghana', '+233', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(84, '🇬🇮', 'Gibraltar', 'Gibraltar', '+350', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(85, '🇬🇱', 'Greenland', 'Greenland', '+299', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(86, '🇬🇲', 'Gambia', 'Gambia', '+220', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(87, '🇬🇳', 'Guinea', 'Guinea', '+224', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(88, '🇬🇵', 'Guadeloupe', 'Guadeloupe', '+590', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(89, '🇬🇶', 'Equatorial Guinea', 'Equatorial Guinea', '+240', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(90, '🇬🇷', 'Greece', 'Greece', '+30', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(91, '🇬🇹', 'Guatemala', 'Guatemala', '+502', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(93, '🇬🇼', 'Guinea-bissau', 'Guinea-bissau', '+245', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(94, '🇬🇾', 'Guyana', 'Guyana', '+592', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(95, '🇭🇰', 'Hong Kong', 'Hong Kong', '+852', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(96, '🇭🇳', 'Honduras', 'Honduras', '+504', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(97, '🇭🇷', 'Croatia', 'Croatia', '+385', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(98, '🇭🇹', 'Haiti', 'Haiti', '+509', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(99, '🇭🇺', 'Hungary', 'Hungary', '+36', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(100, '🇮🇩', 'Indonesia', 'Indonesia', '+62', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(101, '🇮🇪', 'Ireland', 'Ireland', '+353', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(102, '🇮🇲', 'Isle Of Man', 'Isle Of Man', '+44', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(103, '🇮🇳', 'India', 'India', '+91', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(104, '🇮🇴', 'British Indian Ocean Territory', 'British Indian Ocean Territory', '+246', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(105, '🇮🇶', 'Iraq', 'Iraq', '+964', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(106, '🇮🇸', 'Iceland', 'Iceland', '+354', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(107, '🇮🇹', 'Italy', 'Italy', '+39', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(108, '🇯🇪', 'Jersey', 'Jersey', '+44', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(110, '🇯🇴', 'Jordan', 'Jordan', '+962', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(111, '🇯🇵', 'Japan', 'Japan', '+81', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(112, '🇰🇪', 'Kenya', 'Kenya', '+254', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(113, '🇰🇬', 'Kyrgyzstan', 'Kyrgyzstan', '+996', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(114, '🇰🇭', 'Cambodia', 'Cambodia', '+855', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(115, '🇰🇮', 'Kiribati', 'Kiribati', '+686', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(116, '🇰🇲', 'Comoros', 'Comoros', '+269', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(118, '🇰🇵', 'Korea, Democratic People\'s Republic Of', 'Korea, Democratic People\'s Republic Of', '+850', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(119, '🇰🇷', 'Korea, Republic Of', 'Korea, Republic Of', '+82', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(120, '🇰🇼', 'Kuwait', 'Kuwait', '+965', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(122, '🇰🇿', 'Kazakhstan', 'Kazakhstan', '+7', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(123, '🇱🇦', 'Lao People\'s Democratic Republic', 'Lao People\'s Democratic Republic', '+856', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(124, '🇱🇧', 'Lebanon', 'Lebanon', '+961', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(126, '🇱🇮', 'Liechtenstein', 'Liechtenstein', '+423', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(127, '🇱🇰', 'Sri Lanka', 'Sri Lanka', '+94', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(128, '🇱🇷', 'Liberia', 'Liberia', '+231', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(129, '🇱🇸', 'Lesotho', 'Lesotho', '+266', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(130, '🇱🇹', 'Lithuania', 'Lithuania', '+370', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(131, '🇱🇺', 'Luxembourg', 'Luxembourg', '+352', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(132, '🇱🇻', 'Latvia', 'Latvia', '+371', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(133, '🇱🇾', 'Libya', 'Libya', '+218', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(134, '🇲🇦', 'Morocco', 'Morocco', '+212', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(135, '🇲🇨', 'Monaco', 'Monaco', '+377', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(136, '🇲🇩', 'Moldova', 'Moldova', '+373', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(137, '🇲🇪', 'Montenegro', 'Montenegro', '+382', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(138, '🇲🇫', 'Saint Martin', 'Saint Martin', '+590', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(139, '🇲🇬', 'Madagascar', 'Madagascar', '+261', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(140, '🇲🇭', 'Marshall Islands', 'Marshall Islands', '+692', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(141, '🇲🇰', 'Macedonia, The Former Yugoslav Republic Of', 'Macedonia, The Former Yugoslav Republic Of', '+389', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(142, '🇲🇱', 'Mali', 'Mali', '+223', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(143, '🇲🇲', 'Myanmar', 'Myanmar', '+95', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(144, '🇲🇳', 'Mongolia', 'Mongolia', '+976', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(145, '🇲🇴', 'Macao', 'Macao', '+853', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(147, '🇲🇶', 'Martinique', 'Martinique', '+596', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(148, '🇲🇷', 'Mauritania', 'Mauritania', '+222', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(150, '🇲🇹', 'Malta', 'Malta', '+356', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(151, '🇲🇺', 'Mauritius', 'Mauritius', '+230', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(152, '🇲🇻', 'Maldives', 'Maldives', '+960', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(153, '🇲🇼', 'Malawi', 'Malawi', '+265', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(154, '🇲🇽', 'Mexico', 'Mexico', '+52', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(155, '🇲🇾', 'Malaysia', 'Malaysia', '+60', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(156, '🇲🇿', 'Mozambique', 'Mozambique', '+258', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(157, '🇳🇦', 'Namibia', 'Namibia', '+264', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(158, '🇳🇨', 'New Caledonia', 'New Caledonia', '+687', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(159, '🇳🇪', 'Niger', 'Niger', '+227', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(160, '🇳🇫', 'Norfolk Island', 'Norfolk Island', '+672', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(161, '🇳🇬', 'Nigeria', 'Nigeria', '+234', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(162, '🇳🇮', 'Nicaragua', 'Nicaragua', '+505', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(163, '🇳🇱', 'Netherlands', 'Netherlands', '+31', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(164, '🇳🇴', 'Norway', 'Norway', '+47', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(165, '🇳🇵', 'Nepal', 'Nepal', '+977', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(166, '🇳🇷', 'Nauru', 'Nauru', '+674', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(167, '🇳🇺', 'Niue', 'Niue', '+683', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(168, '🇳🇿', 'New Zealand', 'New Zealand', '+64', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(169, '🇴🇲', 'Oman', 'Oman', '+968', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(170, '🇵🇦', 'Panama', 'Panama', '+507', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(171, '🇵🇪', 'Peru', 'Peru', '+51', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(172, '🇵🇫', 'French Polynesia', 'French Polynesia', '+689', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(173, '🇵🇬', 'Papua New Guinea', 'Papua New Guinea', '+675', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(174, '🇵🇭', 'Philippines', 'Philippines', '+63', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(175, '🇵🇰', 'Pakistan', 'Pakistan', '+92', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(176, '🇵🇱', 'Poland', 'Poland', '+48', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(177, '🇵🇲', 'Saint Pierre And Miquelon', 'Saint Pierre And Miquelon', '+508', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(178, '🇵🇳', 'Pitcairn', 'Pitcairn', '+872', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(180, '🇵🇸', 'Palestinian Territory, Occupied', 'Palestinian Territory, Occupied', '+970', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(181, '🇵🇹', 'Portugal', 'Portugal', '+351', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(182, '🇵🇼', 'Palau', 'Palau', '+680', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(183, '🇵🇾', 'Paraguay', 'Paraguay', '+595', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(184, '🇶🇦', 'Qatar', 'Qatar', '+974', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(185, '🇷🇪', 'Reunion', 'Reunion', '+262', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(186, '🇷🇴', 'Romania', 'Romania', '+40', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(187, '🇷🇸', 'Serbia', 'Serbia', '+381', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(188, '🇷🇺', 'Russian Federation', 'Russian Federation', '+7', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(189, '🇷🇼', 'Rwanda', 'Rwanda', '+250', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(190, '🇸🇦', 'Saudi Arabia', 'Saudi Arabia', '+966', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(191, '🇸🇧', 'Solomon Islands', 'Solomon Islands', '+677', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(192, '🇸🇨', 'Seychelles', 'Seychelles', '+248', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(193, '🇸🇩', 'Sudan', 'Sudan', '+249', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(194, '🇸🇪', 'Sweden', 'Sweden', '+46', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(195, '🇸🇬', 'Singapore', 'Singapore', '+65', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(196, '🇸🇭', 'Saint Helena, Ascension And Tristan Da Cunha', 'Saint Helena, Ascension And Tristan Da Cunha', '+290', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(197, '🇸🇮', 'Slovenia', 'Slovenia', '+386', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(198, '🇸🇯', 'Svalbard And Jan Mayen', 'Svalbard And Jan Mayen', '+47', 1, '2025-04-18 15:07:56', '2025-04-18 15:07:56'),
(199, '🇸🇰', 'Slovakia', 'Slovakia', '+421', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(200, '🇸🇱', 'Sierra Leone', 'Sierra Leone', '+232', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(201, '🇸🇲', 'San Marino', 'San Marino', '+378', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(202, '🇸🇳', 'Senegal', 'Senegal', '+221', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(203, '🇸🇴', 'Somalia', 'Somalia', '+252', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(204, '🇸🇷', 'Suriname', 'Suriname', '+597', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(205, '🇸🇸', 'South Sudan', 'South Sudan', '+211', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(206, '🇸🇹', 'Sao Tome and Principe', 'Sao Tome and Principe', '+239', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(207, '🇸🇻', 'El Salvador', 'El Salvador', '+503', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(209, '🇸🇾', 'Syrian Arab Republic', 'Syrian Arab Republic', '+963', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(210, '🇸🇿', 'Swaziland', 'Swaziland', '+268', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(212, '🇹🇩', 'Chad', 'Chad', '+235', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(213, '🇹🇬', 'Togo', 'Togo', '+228', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(214, '🇹🇭', 'Thailand', 'Thailand', '+66', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(215, '🇹🇯', 'Tajikistan', 'Tajikistan', '+992', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(216, '🇹🇰', 'Tokelau', 'Tokelau', '+690', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(217, '🇹🇱', 'Timor-Leste, Democratic Republic of', 'Timor-Leste, Democratic Republic of', '+670', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(218, '🇹🇲', 'Turkmenistan', 'Turkmenistan', '+993', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(219, '🇹🇳', 'Tunisia', 'Tunisia', '+216', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(220, '🇹🇴', 'Tonga', 'Tonga', '+676', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(221, '🇹🇷', 'Turkey', 'Turkey', '+90', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(223, '🇹🇻', 'Tuvalu', 'Tuvalu', '+688', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(224, '🇹🇼', 'Taiwan', 'Taiwan', '+886', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(225, '🇹🇿', 'Tanzania, United Republic Of', 'Tanzania, United Republic Of', '+255', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(226, '🇺🇦', 'Ukraine', 'Ukraine', '+380', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(227, '🇺🇬', 'Uganda', 'Uganda', '+256', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(228, '🇺🇲', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', '+1', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(229, '🇺🇸', 'United States', 'United States', '+1', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(230, '🇺🇾', 'Uruguay', 'Uruguay', '+598', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(231, '🇺🇿', 'Uzbekistan', 'Uzbekistan', '+998', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(232, '🇻🇦', 'Vatican City State', 'Vatican City State', '+379', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(234, '🇻🇪', 'Venezuela, Bolivarian Republic Of', 'Venezuela, Bolivarian Republic Of', '+58', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(237, '🇻🇳', 'Viet Nam', 'Viet Nam', '+84', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(238, '🇻🇺', 'Vanuatu', 'Vanuatu', '+678', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(239, '🇼🇫', 'Wallis And Futuna', 'Wallis And Futuna', '+681', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(240, '🇼🇸', 'Samoa', 'Samoa', '+685', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(241, '🇾🇪', 'Yemen', 'Yemen', '+967', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(242, '🇾🇹', 'Mayotte', 'Mayotte', '+262', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(243, '🇿🇦', 'South Africa', 'South Africa', '+27', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(244, '🇿🇲', 'Zambia', 'Zambia', '+260', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(245, '🇿🇼', 'Zimbabwe', 'Zimbabwe', '+263', 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57');

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

--
-- 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 `friendly_logs`
--

CREATE TABLE `friendly_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `sim_card_id` bigint(20) UNSIGNED NOT NULL,
  `social_id` bigint(20) UNSIGNED NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `text` varchar(255) NOT NULL,
  `status` int(11) 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 `friendly_numbers`
--

CREATE TABLE `friendly_numbers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `phone` 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 `friendly_texts`
--

CREATE TABLE `friendly_texts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `text` 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 `gift_codes`
--

CREATE TABLE `gift_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `type` enum('percent','amount') NOT NULL,
  `value` int(11) NOT NULL,
  `expires_at` datetime NOT NULL,
  `usage_limit` int(11) NOT NULL DEFAULT 1,
  `is_active` 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;

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

--
-- Table structure for table `gift_code_plan`
--

CREATE TABLE `gift_code_plan` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `gift_code_id` bigint(20) UNSIGNED NOT NULL,
  `plan_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 `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;

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

--
-- 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 `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, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_02_26_161755_create_socials_table', 1),
(5, '2025_02_27_154147_create_otp_login_table', 1),
(6, '2025_02_27_154712_create_sim_card_groups_table', 1),
(7, '2025_02_27_154748_create_sim_cards_table', 1),
(8, '2025_02_27_154819_create_sim_sessions_table', 1),
(9, '2025_02_27_154848_create_contact_lists_table', 1),
(10, '2025_02_27_154947_create_programs_table', 1),
(11, '2025_03_16_194023_create_report_sends_table', 1),
(12, '2025_03_19_155745_create_servers_table', 1),
(13, '2025_03_19_163231_create_socail_servers_table', 1),
(14, '2025_03_28_215959_create_plans_table', 1),
(15, '2025_03_28_215959_create_wallet_transactions_table', 1),
(16, '2025_03_28_220000_create_gift_codes_table', 1),
(17, '2025_03_28_220000_create_plan_payments_table', 1),
(18, '2025_03_28_220000_create_user_plans_table', 1),
(19, '2025_03_29_015012_create_gift_code_plan_table', 1),
(20, '2025_04_10_124003_create_countries_table', 1),
(21, '2025_04_10_124451_add_phone_code_to_table_sim_card', 1),
(22, '2025_04_12_204612_create_friendly_numbers_table', 1),
(23, '2025_04_12_204812_create_friendly_texts_table', 1),
(24, '2025_04_13_212448_create_friendly_logs_table', 1),
(25, '2025_06_27_160658_create_permission_tables', 2),
(26, '2025_06_27_165819_add_label_to_roles_and_permissions_tables', 2),
(27, '2025_06_27_172705_create_settings_table', 2),
(28, '2025_06_29_182036_add_name_to_srver_table', 3),
(29, '2025_07_17_202558_add_password_to_user', 4),
(30, '2025_07_18_140102_create_transactions_table', 5);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `guard_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 `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `label`, `guard_name`, `created_at`, `updated_at`) VALUES
(2, 'admin', 'مدیر سایت', 'web', NULL, NULL),
(4, 'permissionManager', 'مدیریت نقش‌ها و دسترسی‌ها', 'web', '2025-06-27 10:07:14', '2025-06-27 10:07:14'),
(8, 'SettingManager', 'مدیریت تنظیمات سامانه', 'web', '2025-06-27 10:38:19', '2025-06-27 10:38:19'),
(11, 'SimCardGroupList', 'گروه‌های سیم‌کارت', 'web', '2025-06-29 10:04:31', '2025-06-29 10:04:31'),
(12, 'UserList', 'لیست کاربران', 'web', '2025-06-29 10:05:02', '2025-06-29 10:05:02'),
(13, 'SimCardList', 'لیست سیم‌کارت‌ها', 'web', '2025-06-29 10:25:16', '2025-06-29 10:25:16'),
(14, 'SimCardSessionList', 'نشست‌های سیم‌کارت', 'web', '2025-06-29 14:53:21', '2025-06-29 14:53:21'),
(15, 'ServerList', 'لیست سرورها', 'web', '2025-06-29 18:47:55', '2025-06-29 18:47:55'),
(16, 'ContactList', 'لیست مخاطبین', 'web', '2025-07-10 16:09:00', '2025-07-10 16:09:00'),
(17, 'FriendlyList', 'مخاطبین دوستانه', 'web', '2025-07-10 16:34:35', '2025-07-10 16:34:35'),
(18, 'GiftCodeManage', 'مدیریت کد هدیه', 'web', '2025-07-10 16:57:38', '2025-07-10 16:57:38'),
(19, 'PlanManage', 'مدیریت پلن‌ها', 'web', '2025-07-10 17:36:59', '2025-07-10 17:36:59'),
(20, 'PlanPaymentManage', 'مدیریت پرداخت پلن‌ها', 'web', '2025-07-10 17:54:28', '2025-07-10 17:54:28'),
(21, 'WalletManage', 'مدیریت کیف پول', 'web', '2025-07-10 18:03:26', '2025-07-10 18:03:26'),
(22, 'ProgramManage', 'مدیریت برنامه‌ها', 'web', '2025-07-10 18:12:10', '2025-07-10 18:12:10'),
(23, 'ReportSendManage', 'مدیریت گزارش ارسال', 'web', '2025-07-10 18:29:30', '2025-07-10 18:29:30');

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

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

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `icon_url` varchar(255) DEFAULT NULL,
  `price` int(11) NOT NULL,
  `subscription_days` int(11) NOT NULL,
  `simcard_limit` int(11) NOT NULL DEFAULT 1,
  `badge` int(11) DEFAULT NULL,
  `is_active` 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 `plans`
--

INSERT INTO `plans` (`id`, `uuid`, `name`, `icon_url`, `price`, `subscription_days`, `simcard_limit`, `badge`, `is_active`, `created_at`, `updated_at`) VALUES
(7, '47103807-1d2f-11f0-8663-00163e7978e9', 'عطارد', 'https://jetchat.ir/img/plans/mercury.png', 0, 3, 1, NULL, 1, '2025-04-19 15:02:14', '2025-07-17 17:11:31'),
(8, '47103dcc-1d2f-11f0-8663-00163e7978e9', 'زمین', 'https://jetchat.ir/img/plans/earth.png', 99000, 7, 1, NULL, 1, '2025-04-19 15:02:14', '2025-04-19 15:02:14'),
(9, '47103ec5-1d2f-11f0-8663-00163e7978e9', 'اریس', 'https://jetchat.ir/img/plans/eris.png', 210000, 15, 1, NULL, 1, '2025-04-19 15:02:14', '2025-04-19 15:02:14'),
(10, '47103f25-1d2f-11f0-8663-00163e7978e9', 'مریخ', 'https://jetchat.ir/img/plans/mars.png', 400000, 30, 1, NULL, 1, '2025-04-19 15:02:14', '2025-04-19 15:02:14'),
(11, '47103f72-1d2f-11f0-8663-00163e7978e9', 'مشتری', 'https://jetchat.ir/img/plans/jupiter.png', 2000000, 30, 5, NULL, 1, '2025-04-19 15:02:14', '2025-04-19 15:02:14'),
(12, '47103fc2-1d2f-11f0-8663-00163e7978e9', 'زحل', 'https://jetchat.ir/img/plans/saturn.png', 1350000, 30, 3, NULL, 1, '2025-04-19 15:02:14', '2025-04-19 15:02:14'),
(13, '4710400b-1d2f-11f0-8663-00163e7978e9', 'نپتون', 'https://jetchat.ir/img/plans/neptune.png', 26000000, 365, 5, NULL, 1, '2025-04-19 15:02:14', '2025-04-19 15:02:14'),
(14, '4710409d-1d2f-11f0-8663-00163e7978e9', 'پلوتون', 'https://jetchat.ir/img/plans/pluton.png', 5000000, 30, 10, NULL, 1, '2025-04-19 15:02:14', '2025-04-19 15:02:14'),
(15, '47104050-1d2f-11f0-8663-00163e7978e9', 'اورانوس', 'https://jetchat.ir/img/plans/uranus.png', 50000000, 365, 10, NULL, 1, '2025-04-19 15:02:14', '2025-07-10 17:37:40');

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

--
-- Table structure for table `plan_payments`
--

CREATE TABLE `plan_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `gift_code_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_amount` int(11) NOT NULL,
  `discount_amount` int(11) NOT NULL,
  `wallet_amount` int(11) NOT NULL,
  `paid_amount` int(11) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending',
  `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;

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

--
-- Table structure for table `programs`
--

CREATE TABLE `programs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `contact_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sim_card_group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `social_id` bigint(20) UNSIGNED DEFAULT NULL,
  `messages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`messages`)),
  `send_time` varchar(255) DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  `send_date` varchar(255) DEFAULT NULL,
  `end_date` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `status_send` varchar(255) 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 `report_sends`
--

CREATE TABLE `report_sends` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `send_type` enum('otp','fast','program','program_dynamic') NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `program_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sim_card_id` bigint(20) UNSIGNED DEFAULT NULL,
  `social_id` bigint(20) UNSIGNED NOT NULL,
  `phone` varchar(255) NOT NULL,
  `messages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`messages`)),
  `status` varchar(255) NOT NULL DEFAULT 'in_send',
  `desc` 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;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `guard_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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `label`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'مدیر سایت', 'web', '2025-06-27 09:18:54', '2025-06-27 10:07:55');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(2, 1),
(4, 1),
(8, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1);

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

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `all_cards_count` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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,
  `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;

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

INSERT INTO `settings` (`id`, `data`, `created_at`, `updated_at`) VALUES
(1, '{\"footer_text\":\"\\u0627\\u0631\\u0627\\u0626\\u0647 \\u0634\\u062f\\u0647 \\u062a\\u0648\\u0633\\u0637 \\u0631\\u0627\\u0633\\u062a\\u0686\\u06cc\\u0646\",\"support_phone\":\"09121111111\",\"site_name\":\"\\u062c\\u062a \\u0686\\u062a\",\"icon\":\"https:\\/\\/jetchat-data.storage.iran.liara.space\\/icons\\/KnM9Z63vwZ7aAmUOXXORapWLYMRczTO233D2X2Pc.png\",\"zarinpal_token\":\"1\",\"GOFTINO_KEY\":\"2\"}', '2025-06-29 15:12:52', '2025-07-18 17:39:12');

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

--
-- Table structure for table `sim_cards`
--

CREATE TABLE `sim_cards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `phone_number` varchar(255) NOT NULL,
  `sim_card_group_id` bigint(20) UNSIGNED NOT NULL,
  `work_status` int(11) NOT NULL DEFAULT 0,
  `server_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `socials`
--

CREATE TABLE `socials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_fa` varchar(255) NOT NULL,
  `sleep_time` int(11) NOT NULL DEFAULT 0 COMMENT 'as second',
  `day_send_count` int(11) NOT NULL DEFAULT 100,
  `qr_type` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `socials`
--

INSERT INTO `socials` (`id`, `name`, `name_fa`, `sleep_time`, `day_send_count`, `qr_type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'bale', 'بله', 700, 100, 0, 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(2, 'eitaa', 'ایتا', 700, 100, 0, 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(3, 'splus', 'سروش', 700, 100, 0, 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(4, 'rubika', 'روبیکا', 700, 100, 0, 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57'),
(5, 'whatsapp', 'واتساپ', 700, 100, 1, 1, '2025-04-18 15:07:57', '2025-04-18 15:07:57');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid_user` char(36) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `api_url` varchar(255) NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payload`)),
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `callback_url` text 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 `user_plans`
--

CREATE TABLE `user_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `started_at` datetime NOT NULL,
  `expires_at` datetime NOT NULL,
  `is_active` 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 `user_plans`
--

INSERT INTO `user_plans` (`id`, `user_id`, `plan_id`, `started_at`, `expires_at`, `is_active`, `created_at`, `updated_at`) VALUES
(2, 1, 15, '2025-04-19 18:43:51', '2035-04-12 18:43:51', 1, '2025-04-19 15:13:51', '2025-07-17 17:29:39');

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

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE `wallet_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('charge','debit','refund') NOT NULL,
  `method` enum('manual','gateway','used_for_plan') NOT NULL,
  `amount` int(11) NOT NULL,
  `reference_type` varchar(255) DEFAULT NULL,
  `reference_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` enum('pending','completed','failed') NOT NULL DEFAULT 'completed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  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 `friendly_logs`
--
ALTER TABLE `friendly_logs`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `gift_codes`
--
ALTER TABLE `gift_codes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gift_codes_code_unique` (`code`);

--
-- Indexes for table `gift_code_plan`
--
ALTER TABLE `gift_code_plan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gift_code_plan_gift_code_id_foreign` (`gift_code_id`),
  ADD KEY `gift_code_plan_plan_id_foreign` (`plan_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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

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

--
-- Indexes for table `plan_payments`
--
ALTER TABLE `plan_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `plan_payments_user_id_foreign` (`user_id`),
  ADD KEY `plan_payments_plan_id_foreign` (`plan_id`),
  ADD KEY `plan_payments_gift_code_id_foreign` (`gift_code_id`);

--
-- Indexes for table `programs`
--
ALTER TABLE `programs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `programs_user_id_foreign` (`user_id`),
  ADD KEY `programs_contact_list_id_foreign` (`contact_list_id`),
  ADD KEY `programs_sim_card_group_id_foreign` (`sim_card_group_id`),
  ADD KEY `programs_social_id_foreign` (`social_id`);

--
-- Indexes for table `report_sends`
--
ALTER TABLE `report_sends`
  ADD PRIMARY KEY (`id`),
  ADD KEY `report_sends_user_id_foreign` (`user_id`),
  ADD KEY `report_sends_program_id_foreign` (`program_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `servers`
--
ALTER TABLE `servers`
  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 `sim_cards`
--
ALTER TABLE `sim_cards`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sim_cards_phone_number_unique` (`phone_number`),
  ADD KEY `sim_cards_user_id_foreign` (`user_id`),
  ADD KEY `sim_cards_sim_card_group_id_foreign` (`sim_card_group_id`),
  ADD KEY `sim_cards_country_id_foreign` (`country_id`);

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_transaction_id_unique` (`transaction_id`);

--
-- Indexes for table `user_plans`
--
ALTER TABLE `user_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_plans_user_id_foreign` (`user_id`),
  ADD KEY `user_plans_plan_id_foreign` (`plan_id`);

--
-- Indexes for table `wallet_transactions`
--
ALTER TABLE `wallet_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wallet_transactions_user_id_foreign` (`user_id`),
  ADD KEY `wallet_transactions_reference_type_reference_id_index` (`reference_type`,`reference_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `gift_code_plan`
--
ALTER TABLE `gift_code_plan`
  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 for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

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

--
-- Constraints for table `friendly_numbers`
--
ALTER TABLE `friendly_numbers`
  ADD CONSTRAINT `friendly_numbers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `friendly_texts`
--
ALTER TABLE `friendly_texts`
  ADD CONSTRAINT `friendly_texts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `gift_code_plan`
--
ALTER TABLE `gift_code_plan`
  ADD CONSTRAINT `gift_code_plan_gift_code_id_foreign` FOREIGN KEY (`gift_code_id`) REFERENCES `gift_codes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `gift_code_plan_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `plan_payments`
--
ALTER TABLE `plan_payments`
  ADD CONSTRAINT `plan_payments_gift_code_id_foreign` FOREIGN KEY (`gift_code_id`) REFERENCES `gift_codes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `plan_payments_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `plan_payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `programs`
--
ALTER TABLE `programs`
  ADD CONSTRAINT `programs_contact_list_id_foreign` FOREIGN KEY (`contact_list_id`) REFERENCES `contact_lists` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `programs_sim_card_group_id_foreign` FOREIGN KEY (`sim_card_group_id`) REFERENCES `sim_card_groups` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `programs_social_id_foreign` FOREIGN KEY (`social_id`) REFERENCES `socials` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `programs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `report_sends`
--
ALTER TABLE `report_sends`
  ADD CONSTRAINT `report_sends_program_id_foreign` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `report_sends_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sim_cards`
--
ALTER TABLE `sim_cards`
  ADD CONSTRAINT `sim_cards_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `sim_cards_sim_card_group_id_foreign` FOREIGN KEY (`sim_card_group_id`) REFERENCES `sim_card_groups` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sim_cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_plans`
--
ALTER TABLE `user_plans`
  ADD CONSTRAINT `user_plans_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_plans_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

