
--
-- Table structure for table `alumnus`
--

CREATE TABLE `alumnus` (
                           `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                           `tenant_id` bigint unsigned DEFAULT NULL,
                           `user_id` bigint unsigned NOT NULL,
                           `batch_id` bigint unsigned DEFAULT NULL,
                           `department_id` bigint unsigned DEFAULT NULL,
                           `passing_year_id` bigint unsigned DEFAULT NULL,
                           `id_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `company_designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `company_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `blood_group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `date_of_birth` date DEFAULT NULL,
                           `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `about_me` text COLLATE utf8mb4_unicode_ci,
                           `linkedin_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `facebook_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `twitter_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `instagram_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `zip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                           `address` mediumtext COLLATE utf8mb4_unicode_ci,
                           `custom_fields` longtext COLLATE utf8mb4_unicode_ci,
                           `created_at` timestamp NULL DEFAULT NULL,
                           `updated_at` timestamp NULL DEFAULT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `authentication_log`
--

CREATE TABLE `authentication_log` (
                                      `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                      `authenticatable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                      `authenticatable_id` bigint unsigned NOT NULL,
                                      `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                      `user_agent` text COLLATE utf8mb4_unicode_ci,
                                      `login_at` timestamp NULL DEFAULT NULL,
                                      `login_successful` tinyint(1) NOT NULL DEFAULT '0',
                                      `logout_at` timestamp NULL DEFAULT NULL,
                                      `cleared_by_user` tinyint(1) NOT NULL DEFAULT '0',
                                      `location` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
                                      PRIMARY KEY (`id`),
                                      KEY `authentication_log_authenticatable_type_authenticatable_id_index` (`authenticatable_type`,`authenticatable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
                         `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                         `tenant_id` bigint unsigned DEFAULT NULL,
                         `gateway_id` bigint unsigned NOT NULL,
                         `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                         `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
                         `status` tinyint NOT NULL DEFAULT '0',
                         `created_at` timestamp NULL DEFAULT NULL,
                         `updated_at` timestamp NULL DEFAULT NULL,
                         `deleted_at` timestamp NULL DEFAULT NULL,
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `batches`
--

CREATE TABLE `batches` (
                           `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                           `tenant_id` bigint unsigned DEFAULT NULL,
                           `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `created_at` timestamp NULL DEFAULT NULL,
                           `updated_at` timestamp NULL DEFAULT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `chat_media`
--

CREATE TABLE `chat_media` (
                              `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                              `chat_id` bigint unsigned NOT NULL,
                              `file` int NOT NULL,
                              `created_at` timestamp NULL DEFAULT NULL,
                              `updated_at` timestamp NULL DEFAULT NULL,
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
                         `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                         `tenant_id` bigint unsigned DEFAULT NULL,
                         `sender_id` int NOT NULL DEFAULT '0',
                         `receiver_id` int NOT NULL DEFAULT '0',
                         `message` longtext COLLATE utf8mb4_unicode_ci,
                         `is_seen` int NOT NULL DEFAULT '0',
                         `deleted_at` timestamp NULL DEFAULT NULL,
                         `created_at` timestamp NULL DEFAULT NULL,
                         `updated_at` timestamp NULL DEFAULT NULL,
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
                                    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `created_at` timestamp NULL DEFAULT NULL,
                                    `updated_at` timestamp NULL DEFAULT NULL,
                                    `deleted_at` timestamp NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
                              `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                              `tenant_id` bigint unsigned DEFAULT NULL,
                              `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                              `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                              `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
                              `issue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                              `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                              `deleted_at` timestamp NULL DEFAULT NULL,
                              `created_at` timestamp NULL DEFAULT NULL,
                              `updated_at` timestamp NULL DEFAULT NULL,
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `core_pages_settings`
--

CREATE TABLE `core_pages_settings` (
                                       `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                       `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
                                       `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
                                       `description` longtext COLLATE utf8mb4_unicode_ci,
                                       `image` int DEFAULT NULL,
                                       `status` tinyint NOT NULL DEFAULT '1',
                                       `created_at` timestamp NULL DEFAULT NULL,
                                       `updated_at` timestamp NULL DEFAULT NULL,
                                       `deleted_at` timestamp NULL DEFAULT NULL,
                                       PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `countries` (
                             `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                             `short_name` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `country_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `flag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `phonecode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `continent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `status` tinyint NOT NULL DEFAULT '1',
                             `created_at` timestamp NULL DEFAULT NULL,
                             `updated_at` timestamp NULL DEFAULT NULL,
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
                              `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                              `tenant_id` bigint unsigned DEFAULT NULL,
                              `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                              `symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                              `currency_placement` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
                              `current_currency` smallint unsigned DEFAULT '0',
                              `created_at` timestamp NULL DEFAULT NULL,
                              `updated_at` timestamp NULL DEFAULT NULL,
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `custom_domain_requests`
--

CREATE TABLE `custom_domain_requests` (
                                          `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                          `tenant_id` bigint unsigned NOT NULL,
                                          `user_id` bigint unsigned NOT NULL,
                                          `old_domain` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                          `request_domain` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                          `status` tinyint NOT NULL DEFAULT '0',
                                          `created_at` timestamp NULL DEFAULT NULL,
                                          `updated_at` timestamp NULL DEFAULT NULL,
                                          PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `database_backup_cron_settings`
--

CREATE TABLE `database_backup_cron_settings` (
                                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                                 `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL,
                                                 `hour_of_day` time NOT NULL DEFAULT '00:00:00',
                                                 `backup_after_days` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                                 `delete_backup_after_days` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                                 `created_at` timestamp NULL DEFAULT NULL,
                                                 `updated_at` timestamp NULL DEFAULT NULL,
                                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `database_backups`
--

CREATE TABLE `database_backups` (
                                    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                    `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                    `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                    `created_at` timestamp NULL DEFAULT NULL,
                                    `updated_at` timestamp NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
                               `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                               `tenant_id` bigint unsigned DEFAULT NULL,
                               `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                               `short_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                               `created_at` timestamp NULL DEFAULT NULL,
                               `updated_at` timestamp NULL DEFAULT NULL,
                               PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `domains`
--

CREATE TABLE `domains` (
                           `id` int unsigned NOT NULL AUTO_INCREMENT,
                           `domain` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `tenant_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `created_at` timestamp NULL DEFAULT NULL,
                           `updated_at` timestamp NULL DEFAULT NULL,
                           PRIMARY KEY (`id`),
                           UNIQUE KEY `domains_domain_unique` (`domain`),
                           KEY `domains_tenant_id_foreign` (`tenant_id`),
                           CONSTRAINT `domains_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
                                   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                   `tenant_id` bigint unsigned DEFAULT NULL,
                                   `category` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                   `slug` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                   `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                   `body` longtext COLLATE utf8mb4_unicode_ci,
                                   `default` tinyint NOT NULL DEFAULT '0',
                                   `status` tinyint NOT NULL DEFAULT '0',
                                   `deleted_at` timestamp NULL DEFAULT NULL,
                                   `created_at` timestamp NULL DEFAULT NULL,
                                   `updated_at` timestamp NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `event_categories`
--

CREATE TABLE `event_categories` (
                                    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                    `tenant_id` bigint unsigned DEFAULT NULL,
                                    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `created_at` timestamp NULL DEFAULT NULL,
                                    `updated_at` timestamp NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `event_tickets`
--

CREATE TABLE `event_tickets` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `tenant_id` bigint unsigned DEFAULT NULL,
                                 `event_id` bigint unsigned NOT NULL,
                                 `user_id` bigint unsigned NOT NULL,
                                 `ticket_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
                          `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                          `tenant_id` bigint unsigned DEFAULT NULL,
                          `event_category_id` bigint unsigned NOT NULL,
                          `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                          `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                          `thumbnail` int NOT NULL,
                          `ticket_image` int DEFAULT NULL,
                          `date` datetime NOT NULL,
                          `type` tinyint NOT NULL DEFAULT '1',
                          `location` text COLLATE utf8mb4_unicode_ci NOT NULL,
                          `price` decimal(12,2) NOT NULL DEFAULT '0.00',
                          `number_of_ticket` int NOT NULL DEFAULT '0',
                          `number_of_ticket_left` int NOT NULL DEFAULT '0',
                          `description` text COLLATE utf8mb4_unicode_ci,
                          `user_id` bigint unsigned NOT NULL,
                          `status` tinyint NOT NULL DEFAULT '0',
                          `approved_by` bigint unsigned DEFAULT NULL,
                          `deleted_at` timestamp NULL DEFAULT NULL,
                          `created_at` timestamp NULL DEFAULT NULL,
                          `updated_at` timestamp NULL DEFAULT NULL,
                          PRIMARY KEY (`id`),
                          UNIQUE KEY `events_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `failed_jobs` (
                               `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                               `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                               `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
                               `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
                               `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
                               `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
                               `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                               PRIMARY KEY (`id`),
                               UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `faqs` (
                        `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                        `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
                        `description` longtext COLLATE utf8mb4_unicode_ci,
                        `status` tinyint NOT NULL DEFAULT '1',
                        `created_at` timestamp NULL DEFAULT NULL,
                        `updated_at` timestamp NULL DEFAULT NULL,
                        `deleted_at` timestamp NULL DEFAULT NULL,
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `features_settings`
--

CREATE TABLE `features_settings` (
                                     `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                     `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
                                     `description` longtext COLLATE utf8mb4_unicode_ci,
                                     `icon` int DEFAULT NULL,
                                     `status` tinyint NOT NULL DEFAULT '1',
                                     `created_at` timestamp NULL DEFAULT NULL,
                                     `updated_at` timestamp NULL DEFAULT NULL,
                                     `deleted_at` timestamp NULL DEFAULT NULL,
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `file_managers`
--

CREATE TABLE `file_managers` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `tenant_id` bigint unsigned DEFAULT NULL,
                                 `file_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `storage_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `original_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `user_id` bigint unsigned DEFAULT NULL,
                                 `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `external_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `deleted_at` timestamp NULL DEFAULT NULL,
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`),
                                 UNIQUE KEY `file_managers_file_name_unique` (`file_name`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `frontend_sections`
--

CREATE TABLE `frontend_sections` (
                                     `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                     `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                     `page_title` text COLLATE utf8mb4_unicode_ci,
                                     `title` text COLLATE utf8mb4_unicode_ci,
                                     `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                     `has_page_title` tinyint DEFAULT NULL,
                                     `has_banner_image` tinyint NOT NULL DEFAULT '0',
                                     `has_image` tinyint NOT NULL DEFAULT '0',
                                     `has_description` tinyint NOT NULL DEFAULT '0',
                                     `description` longtext COLLATE utf8mb4_unicode_ci,
                                     `banner_image` int DEFAULT NULL,
                                     `image` int DEFAULT NULL,
                                     `status` tinyint NOT NULL DEFAULT '0',
                                     `created_at` timestamp NULL DEFAULT NULL,
                                     `updated_at` timestamp NULL DEFAULT NULL,
                                     `deleted_at` timestamp NULL DEFAULT NULL,
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `gateway_currencies`
--

CREATE TABLE `gateway_currencies` (
                                      `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                      `gateway_id` bigint unsigned NOT NULL,
                                      `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD',
                                      `conversion_rate` decimal(8,2) NOT NULL DEFAULT '1.00',
                                      `created_at` timestamp NULL DEFAULT NULL,
                                      `updated_at` timestamp NULL DEFAULT NULL,
                                      `deleted_at` timestamp NULL DEFAULT NULL,
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `how_its_works`
--

CREATE TABLE `how_its_works` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `description` longtext COLLATE utf8mb4_unicode_ci,
                                 `image` int DEFAULT NULL,
                                 `status` tinyint NOT NULL DEFAULT '1',
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 `deleted_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `job_posts`
--

CREATE TABLE `job_posts` (
                             `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                             `tenant_id` bigint unsigned DEFAULT NULL,
                             `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `compensation_n_benefits` text COLLATE utf8mb4_unicode_ci NOT NULL,
                             `salary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
                             `company_logo` int NOT NULL,
                             `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `post_link` text COLLATE utf8mb4_unicode_ci NOT NULL,
                             `application_deadline` datetime NOT NULL,
                             `job_responsibility` text COLLATE utf8mb4_unicode_ci NOT NULL,
                             `job_context` text COLLATE utf8mb4_unicode_ci NOT NULL,
                             `educational_requirements` text COLLATE utf8mb4_unicode_ci NOT NULL,
                             `additional_requirements` text COLLATE utf8mb4_unicode_ci,
                             `user_id` bigint unsigned NOT NULL,
                             `employee_status` tinyint NOT NULL,
                             `status` tinyint NOT NULL DEFAULT '0',
                             `deleted_at` timestamp NULL DEFAULT NULL,
                             `created_at` timestamp NULL DEFAULT NULL,
                             `updated_at` timestamp NULL DEFAULT NULL,
                             PRIMARY KEY (`id`),
                             UNIQUE KEY `job_posts_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
                             `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                             `language` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `iso_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `flag_id` bigint unsigned DEFAULT NULL,
                             `font` bigint unsigned DEFAULT NULL,
                             `rtl` tinyint DEFAULT '3',
                             `status` tinyint NOT NULL DEFAULT '1',
                             `default` tinyint DEFAULT '0',
                             `created_at` timestamp NULL DEFAULT NULL,
                             `updated_at` timestamp NULL DEFAULT NULL,
                             `deleted_at` timestamp NULL DEFAULT NULL,
                             PRIMARY KEY (`id`),
                             UNIQUE KEY `languages_language_unique` (`language`),
                             UNIQUE KEY `languages_iso_code_unique` (`iso_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `mail_histories`
--

CREATE TABLE `mail_histories` (
                                  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                  `owner_user_id` bigint unsigned NOT NULL,
                                  `host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                  `message` text COLLATE utf8mb4_unicode_ci,
                                  `status` tinyint NOT NULL DEFAULT '1',
                                  `user_id` bigint unsigned DEFAULT NULL,
                                  `date` datetime DEFAULT NULL,
                                  `error` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                  `created_at` timestamp NULL DEFAULT NULL,
                                  `updated_at` timestamp NULL DEFAULT NULL,
                                  `deleted_at` timestamp NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `membership_plans`
--

CREATE TABLE `membership_plans` (
                                    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                    `tenant_id` bigint unsigned DEFAULT NULL,
                                    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `badge` int NOT NULL,
                                    `price` decimal(12,2) NOT NULL,
                                    `duration_type` tinyint NOT NULL DEFAULT '2',
                                    `duration` int NOT NULL,
                                    `status` tinyint NOT NULL DEFAULT '1',
                                    `deleted_at` timestamp NULL DEFAULT NULL,
                                    `created_at` timestamp NULL DEFAULT NULL,
                                    `updated_at` timestamp NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `metas`
--

CREATE TABLE `metas` (
                         `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                         `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
                         `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                         `page_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                         `meta_title` mediumtext COLLATE utf8mb4_unicode_ci,
                         `meta_description` mediumtext COLLATE utf8mb4_unicode_ci,
                         `meta_keyword` mediumtext COLLATE utf8mb4_unicode_ci,
                         `og_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                         `created_at` timestamp NULL DEFAULT NULL,
                         `updated_at` timestamp NULL DEFAULT NULL,
                         PRIMARY KEY (`id`),
                         UNIQUE KEY `metas_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `migrations` (
                              `id` int unsigned NOT NULL AUTO_INCREMENT,
                              `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                              `batch` int NOT NULL,
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
                        `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                        `tenant_id` bigint unsigned DEFAULT NULL,
                        `news_category_id` bigint unsigned NOT NULL,
                        `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                        `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                        `details` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
                        `image` int DEFAULT NULL,
                        `status` tinyint NOT NULL DEFAULT '0',
                        `created_by` bigint unsigned NOT NULL,
                        `created_at` timestamp NULL DEFAULT NULL,
                        `updated_at` timestamp NULL DEFAULT NULL,
                        `deleted_at` timestamp NULL DEFAULT NULL,
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `news_categories`
--

CREATE TABLE `news_categories` (
                                   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                   `tenant_id` bigint unsigned DEFAULT NULL,
                                   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                   `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                   `status` tinyint NOT NULL DEFAULT '0',
                                   `created_at` timestamp NULL DEFAULT NULL,
                                   `updated_at` timestamp NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `news_subscription_letters`
--

CREATE TABLE `news_subscription_letters` (
                                             `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                             `tenant_id` bigint unsigned DEFAULT NULL,
                                             `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
                                             `status` tinyint NOT NULL DEFAULT '0',
                                             `created_at` timestamp NULL DEFAULT NULL,
                                             `updated_at` timestamp NULL DEFAULT NULL,
                                             `deleted_at` timestamp NULL DEFAULT NULL,
                                             PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `news_tag`
--

CREATE TABLE `news_tag` (
                            `news_id` bigint unsigned NOT NULL,
                            `tag_id` bigint unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `news_tags`
--

CREATE TABLE `news_tags` (
                             `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                             `tenant_id` bigint unsigned DEFAULT NULL,
                             `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `created_at` timestamp NULL DEFAULT NULL,
                             `updated_at` timestamp NULL DEFAULT NULL,
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `notice_categories`
--

CREATE TABLE `notice_categories` (
                                     `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                     `tenant_id` bigint unsigned DEFAULT NULL,
                                     `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                     `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                     `status` tinyint NOT NULL DEFAULT '0',
                                     `created_at` timestamp NULL DEFAULT NULL,
                                     `updated_at` timestamp NULL DEFAULT NULL,
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
                           `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                           `tenant_id` bigint unsigned DEFAULT NULL,
                           `notice_category_id` bigint unsigned NOT NULL,
                           `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `details` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
                           `image` int DEFAULT NULL,
                           `status` tinyint NOT NULL DEFAULT '0',
                           `created_by` bigint unsigned NOT NULL,
                           `created_at` timestamp NULL DEFAULT NULL,
                           `updated_at` timestamp NULL DEFAULT NULL,
                           `deleted_at` timestamp NULL DEFAULT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `notification_seens`
--

CREATE TABLE `notification_seens` (
                                      `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                      `tenant_id` bigint unsigned DEFAULT NULL,
                                      `user_id` int DEFAULT NULL,
                                      `notification_id` int DEFAULT NULL,
                                      `created_at` timestamp NULL DEFAULT NULL,
                                      `updated_at` timestamp NULL DEFAULT NULL,
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `tenant_id` bigint unsigned DEFAULT NULL,
                                 `user_id` int DEFAULT NULL,
                                 `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `body` text COLLATE utf8mb4_unicode_ci,
                                 `link` text COLLATE utf8mb4_unicode_ci,
                                 `view_status` tinyint NOT NULL DEFAULT '0',
                                 `status` tinyint NOT NULL DEFAULT '1',
                                 `deleted_at` timestamp NULL DEFAULT NULL,
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
                            `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                            `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                            `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                            `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                            `alumni_limit` int NOT NULL DEFAULT '-1',
                            `custom_domain` tinyint NOT NULL DEFAULT '0',
                            `event_limit` int NOT NULL DEFAULT '-1',
                            `icon_id` int DEFAULT NULL,
                            `others` text COLLATE utf8mb4_unicode_ci,
                            `monthly_price` decimal(12,2) NOT NULL DEFAULT '0.00',
                            `yearly_price` decimal(12,2) NOT NULL DEFAULT '0.00',
                            `status` tinyint NOT NULL DEFAULT '0' COMMENT 'active for 1 , deactivate for 0',
                            `is_default` tinyint NOT NULL DEFAULT '0' COMMENT 'active for 1 , deactivate for 0',
                            `is_trail` tinyint NOT NULL DEFAULT '0' COMMENT 'active for 1 , deactivate for 0',
                            `created_at` timestamp NULL DEFAULT NULL,
                            `updated_at` timestamp NULL DEFAULT NULL,
                            `deleted_at` timestamp NULL DEFAULT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `passing_years`
--

CREATE TABLE `passing_years` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `tenant_id` bigint unsigned DEFAULT NULL,
                                 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
                                         `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                         `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                         `created_at` timestamp NULL DEFAULT NULL,
                                         PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
                                   `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                   `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                   `otp` int DEFAULT NULL,
                                   `otp_expiry` datetime DEFAULT NULL,
                                   `created_at` timestamp NULL DEFAULT NULL,
                                   KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `payments` (
                            `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                            `tenant_id` bigint unsigned DEFAULT NULL,
                            `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
                            `paymentable_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                            `paymentable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                            `gateway_id` bigint unsigned NOT NULL,
                            `paymentId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                            `tnxId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                            `user_id` bigint unsigned NOT NULL,
                            `bank_id` bigint unsigned DEFAULT NULL,
                            `deposit_slip` int DEFAULT NULL,
                            `sub_total` decimal(12,2) NOT NULL DEFAULT '0.00',
                            `tax` decimal(12,2) NOT NULL DEFAULT '0.00',
                            `system_currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                            `payment_currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                            `conversion_rate` decimal(18,8) NOT NULL DEFAULT '0.00000000',
                            `grand_total_with_conversation_rate` decimal(18,8) NOT NULL DEFAULT '0.00000000',
                            `grand_total` decimal(12,2) NOT NULL DEFAULT '0.00',
                            `subscription_type` tinyint DEFAULT NULL,
                            `payment_details` longtext COLLATE utf8mb4_unicode_ci,
                            `gateway_callback_details` longtext COLLATE utf8mb4_unicode_ci,
                            `payment_time` datetime DEFAULT NULL,
                            `payment_status` tinyint NOT NULL DEFAULT '1',
                            `deleted_at` timestamp NULL DEFAULT NULL,
                            `created_at` timestamp NULL DEFAULT NULL,
                            `updated_at` timestamp NULL DEFAULT NULL,
                            PRIMARY KEY (`id`),
                            UNIQUE KEY `payments_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
                                          `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                          `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                          `tokenable_id` bigint unsigned NOT NULL,
                                          `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                          `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
                                          `abilities` text COLLATE utf8mb4_unicode_ci,
                                          `last_used_at` timestamp NULL DEFAULT NULL,
                                          `expires_at` timestamp NULL DEFAULT NULL,
                                          `created_at` timestamp NULL DEFAULT NULL,
                                          `updated_at` timestamp NULL DEFAULT NULL,
                                          PRIMARY KEY (`id`),
                                          UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
                                          KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `photo_galleries`
--

CREATE TABLE `photo_galleries` (
                                   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                   `tenant_id` bigint unsigned DEFAULT NULL,
                                   `caption` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                   `photo` int NOT NULL,
                                   `status` tinyint NOT NULL DEFAULT '1',
                                   `created_at` timestamp NULL DEFAULT NULL,
                                   `updated_at` timestamp NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `post_comments`
--

CREATE TABLE `post_comments` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `tenant_id` bigint unsigned DEFAULT NULL,
                                 `user_id` bigint unsigned NOT NULL,
                                 `post_id` bigint unsigned NOT NULL,
                                 `parent_id` bigint unsigned DEFAULT NULL,
                                 `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `deleted_at` timestamp NULL DEFAULT NULL,
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `post_like`
--

CREATE TABLE `post_like` (
                             `user_id` bigint unsigned NOT NULL,
                             `post_id` bigint unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `post_media`
--

CREATE TABLE `post_media` (
                              `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                              `tenant_id` bigint unsigned DEFAULT NULL,
                              `user_id` bigint unsigned NOT NULL,
                              `post_id` bigint unsigned NOT NULL,
                              `file` int NOT NULL,
                              `created_at` timestamp NULL DEFAULT NULL,
                              `updated_at` timestamp NULL DEFAULT NULL,
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
                         `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                         `tenant_id` bigint unsigned DEFAULT NULL,
                         `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                         `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
                         `status` tinyint NOT NULL DEFAULT '1',
                         `created_by` bigint unsigned NOT NULL,
                         `deleted_at` timestamp NULL DEFAULT NULL,
                         `created_at` timestamp NULL DEFAULT NULL,
                         `updated_at` timestamp NULL DEFAULT NULL,
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `register_forms`
--

CREATE TABLE `register_forms` (
                                  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                  `tenant_id` bigint unsigned DEFAULT NULL,
                                  `enable_batch` tinyint NOT NULL DEFAULT '1',
                                  `enable_department` tinyint NOT NULL DEFAULT '1',
                                  `enable_passing_year` tinyint NOT NULL DEFAULT '1',
                                  `enable_role_number` tinyint NOT NULL DEFAULT '1',
                                  `enable_attachment` tinyint NOT NULL DEFAULT '1',
                                  `enable_date_of_birth` tinyint NOT NULL DEFAULT '1',
                                  `enable_gender` tinyint NOT NULL DEFAULT '1',
                                  `custom_fields` longtext COLLATE utf8mb4_unicode_ci,
                                  `created_at` timestamp NULL DEFAULT NULL,
                                  `updated_at` timestamp NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `settings` (
                            `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                            `tenant_id` bigint unsigned DEFAULT NULL,
                            `option_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                            `option_value` text COLLATE utf8mb4_unicode_ci,
                            `created_at` timestamp NULL DEFAULT NULL,
                            `updated_at` timestamp NULL DEFAULT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `sms_histories`
--

CREATE TABLE `sms_histories` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `owner_user_id` bigint unsigned NOT NULL,
                                 `api` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `status` tinyint NOT NULL DEFAULT '1',
                                 `user_id` bigint unsigned DEFAULT NULL,
                                 `date` datetime DEFAULT NULL,
                                 `error` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 `deleted_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `stories`
--

CREATE TABLE `stories` (
                           `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                           `tenant_id` bigint unsigned DEFAULT NULL,
                           `user_id` bigint unsigned NOT NULL,
                           `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `thumbnail` int NOT NULL,
                           `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
                           `status` tinyint NOT NULL DEFAULT '0',
                           `deleted_at` timestamp NULL DEFAULT NULL,
                           `created_at` timestamp NULL DEFAULT NULL,
                           `updated_at` timestamp NULL DEFAULT NULL,
                           PRIMARY KEY (`id`),
                           UNIQUE KEY `stories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `subscription_email_templates`
--

CREATE TABLE `subscription_email_templates` (
                                                `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                                `tenant_id` bigint unsigned DEFAULT NULL,
                                                `category` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                                `slug` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                                `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                                `body` longtext COLLATE utf8mb4_unicode_ci,
                                                `default` tinyint NOT NULL DEFAULT '0',
                                                `status` tinyint NOT NULL DEFAULT '0',
                                                `deleted_at` timestamp NULL DEFAULT NULL,
                                                `created_at` timestamp NULL DEFAULT NULL,
                                                `updated_at` timestamp NULL DEFAULT NULL,
                                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
                           `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                           `created_at` timestamp NULL DEFAULT NULL,
                           `updated_at` timestamp NULL DEFAULT NULL,
                           `data` text COLLATE utf8mb4_unicode_ci,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `testimonials` (
                                `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                `designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                `comment` longtext COLLATE utf8mb4_unicode_ci,
                                `status` tinyint NOT NULL DEFAULT '0',
                                `created_at` timestamp NULL DEFAULT NULL,
                                `updated_at` timestamp NULL DEFAULT NULL,
                                `deleted_at` timestamp NULL DEFAULT NULL,
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

CREATE TABLE `transactions` (
                                `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                `tenant_id` bigint unsigned DEFAULT NULL,
                                `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
                                `user_id` bigint unsigned NOT NULL,
                                `payment_id` bigint unsigned NOT NULL,
                                `reference_id` bigint unsigned DEFAULT NULL,
                                `type` tinyint NOT NULL,
                                `tnxId` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                `amount` decimal(12,2) NOT NULL,
                                `purpose` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                `payment_time` datetime NOT NULL,
                                `payment_method` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
                                `deleted_at` timestamp NULL DEFAULT NULL,
                                `created_at` timestamp NULL DEFAULT NULL,
                                `updated_at` timestamp NULL DEFAULT NULL,
                                PRIMARY KEY (`id`),
                                UNIQUE KEY `transactions_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `user_institutions`
--

CREATE TABLE `user_institutions` (
                                     `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                     `tenant_id` bigint unsigned DEFAULT NULL,
                                     `user_id` bigint unsigned NOT NULL,
                                     `degree` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                     `passing_year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                     `institute` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
                                     `created_at` timestamp NULL DEFAULT NULL,
                                     `updated_at` timestamp NULL DEFAULT NULL,
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `user_membership_plans`
--

CREATE TABLE `user_membership_plans` (
                                         `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                         `tenant_id` bigint unsigned DEFAULT NULL,
                                         `membership_id` bigint unsigned NOT NULL,
                                         `user_id` bigint unsigned NOT NULL,
                                         `expired_date` datetime NOT NULL,
                                         `status` tinyint NOT NULL DEFAULT '0',
                                         `deleted_at` timestamp NULL DEFAULT NULL,
                                         `created_at` timestamp NULL DEFAULT NULL,
                                         `updated_at` timestamp NULL DEFAULT NULL,
                                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `user_packages`
--

CREATE TABLE `user_packages` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `tenant_id` bigint unsigned DEFAULT NULL,
                                 `user_id` bigint unsigned NOT NULL,
                                 `package_id` bigint unsigned NOT NULL,
                                 `payment_id` bigint unsigned DEFAULT NULL,
                                 `start_date` datetime DEFAULT NULL,
                                 `end_date` datetime DEFAULT NULL,
                                 `subscription_type` tinyint NOT NULL DEFAULT '1',
                                 `status` tinyint NOT NULL DEFAULT '0',
                                 `is_trail` tinyint NOT NULL DEFAULT '0' COMMENT 'active for 1 , deactivate for 0',
                                 `created_at` timestamp NULL DEFAULT NULL,
                                 `updated_at` timestamp NULL DEFAULT NULL,
                                 `deleted_at` timestamp NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--


CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `domains` (id, domain, tenant_id, created_at, updated_at) VALUES  (1,'default','1','2023-11-16 07:37:54','2023-11-16 07:37:54');
INSERT INTO register_forms (tenant_id, enable_batch, enable_department, enable_passing_year, enable_role_number, enable_attachment, enable_date_of_birth, enable_gender, custom_fields, created_at, updated_at) VALUES(1, 1, 1, 1, 1, 1, 1, 1, NULL, '2023-11-16 07:37:54','2023-11-16 07:37:54');

INSERT INTO `file_managers` (id, tenant_id, file_type, storage_type, original_name, file_name, user_id, path, extension, size, external_link, deleted_at, created_at, updated_at) VALUES (1,1,'image/png','public','logo-black.png','6751695564188.png',1,'uploads/Setting/6751695564188.png','png','1422',NULL,NULL,'2023-09-24 08:03:08','2023-11-16 07:37:55'),(2,1,'image/png','public','logo.png','3371695564188.png',1,'uploads/Setting/3371695564188.png','png','3895',NULL,NULL,'2023-09-24 08:03:08','2023-11-16 07:37:55'),(3,1,'image/png','public','favicon.png','5561695564188.png',1,'uploads/Setting/5561695564188.png','png','924',NULL,NULL,'2023-09-24 08:03:08','2023-11-16 07:37:55'),(4,1,'image/jpeg','public','regiser-left-image.jpg','6251695564188.jpg',1,'uploads/Setting/6251695564188.jpg','jpg','86463',NULL,NULL,'2023-09-24 08:03:08','2023-11-16 07:37:55');
INSERT INTO `frontend_sections` (id, name, page_title, title, slug, has_page_title, has_banner_image, has_image, has_description, description, banner_image, image, status, created_at, updated_at, deleted_at) VALUES (1,'Hero Banner','Banner page title','Manage Alumni Related Tasks In One Place.','hero_banner',3,1,1,1,'Create and see all your free and paid events, job post, news, notification, buy ticket with bunch of payment gateway system, find an alumni & chat with them, get membership more & more through zaialumni.',NULL,NULL,1,'2023-11-16 07:39:04','2023-11-16 07:39:04',NULL),(2,'Core Features','Core Features','Bunch Of Features','core_features',3,0,3,3,'2023-11-16 13:39:04',1,NULL,1,NULL,'2023-11-16 07:39:04',NULL),(3,'Explore Core Pages','Explore Core Pages','Zaialumni Made The App Effortless With Some Core Pages','core_pages',1,3,3,1,'Explore some of our core pages that made the app effortless by itself.',NULL,NULL,1,'2023-11-16 07:39:04','2023-11-16 07:39:04',NULL),(4,'Pricing Plan','Pricing Plan','Pick the plan that\'s right for your business.','pricing_plan',1,3,3,3,'Connect alumni with mentors or coaches who can offer them guidance, advice, or feedback on their personal or professional goals, They can also help them',NULL,NULL,1,'2023-11-16 07:39:04','2023-11-16 07:39:04',NULL),(5,'Testimonials','Testimonials','What Our Student Have to Say About Zaialumni.','testimonials_area',1,3,3,1,'Connect alumni with mentors or coaches who can offer them guidance, advice, or feedback on their personal or professional goals, They can also help them',NULL,NULL,1,'2023-11-16 07:39:04','2023-11-16 07:39:04',NULL),(6,'Faq\'s Area','FAQ\'S','Most Common Question About Saas Services.','faqs_area',1,3,3,1,'Connect alumni with mentors or coaches who can offer them guidance, advice, or feedback on their personal or professional goals, They can also help them',NULL,NULL,1,'2023-11-16 07:39:04','2023-11-16 07:39:04',NULL),(7,'How Its Work','How Its Work','Nothing less than excellent','how_its_work_area',1,3,3,1,'Connect alumni with mentors or coaches who can offer them guidance, advice, or feedback on their personal or professional goals, They can also help them',NULL,NULL,1,'2023-11-16 07:39:04','2023-11-16 07:39:04',NULL);
-- Inserting corresponding currencies for all gateways for tenant_id = 1
insert into `gateway_currencies` (id, gateway_id, currency, conversion_rate, created_at, updated_at, deleted_at)
values
    (1, 1, 'USD', 1.00, null, null, null),        -- Paypal (tenant_id = 1)
    (2, 2, 'USD', 1.00, null, null, null),        -- Stripe (tenant_id = 1)
    (3, 3, 'INR', 80.00, null, null, null),       -- Razorpay (tenant_id = 1)
    (4, 4, 'INR', 80.00, null, null, null),       -- Instamojo (tenant_id = 1)
    (5, 5, 'USD', 1.00, null, null, null),        -- Mollie (tenant_id = 1)
    (6, 6, 'NGN', 464.00, null, null, null),      -- Paystack (tenant_id = 1)
    (7, 7, 'BDT', 100.00, null, null, null),      -- Sslcommerz (tenant_id = 1)
    (8, 8, 'NGN', 464.00, null, null, null),      -- Flutterwave (tenant_id = 1)
    (9, 9, 'BRL', 5.00, null, null, null),        -- Mercadopago (tenant_id = 1)
    (10, 10, 'USD', 1.00, null, null, null),      -- Binance (tenant_id = 1)
    (11, 11, 'USD', 1.00, null, null, null),      -- Coinbase (tenant_id = 1)
    (12, 12, 'INR', 80.00, null, null, null),     -- Paytm (tenant_id = 1)
    (13, 13, 'USD', 1.00, null, null, null),      -- Maxicash (tenant_id = 1)
    (14, 14, 'TRY', 27.00, null, null, null),     -- Iyzico (tenant_id = 1)
    (15, 15, 'USD', 1.00, null, null, null),      -- Bitpay (tenant_id = 1)
    (16, 16, 'NGN', 464.00, null, null, null),    -- Zitopay (tenant_id = 1)
    (17, 17, 'LKR', 320.00, null, null, null),    -- Payhere (tenant_id = 1)
    (18, 18, 'XOF', 600.00, null, null, null),    -- Cinetpay (tenant_id = 1)
    (19, 19, 'NGN', 464.00, null, null, null),    -- Voguepay (tenant_id = 1)
    (20, 20, 'MYR', 4.50, null, null, null),      -- Toyyibpay (tenant_id = 1)
    (21, 21, 'EGP', 30.00, null, null, null),     -- Paymob (tenant_id = 1)
    (22, 22, 'USD', 1.00, null, null, null),      -- Authorize (tenant_id = 1)
    (23, 23, 'CNY', 7.00, null, null, null),      -- Alipay (tenant_id = 1)
    (24, 24, 'USD', 1.00, null, null, null),      -- Bank (tenant_id = 1),

-- Inserting corresponding currencies for all gateways for tenant_id = null
    (25, 25, 'USD', 1.00, null, null, null),      -- Paypal (tenant_id = null)
    (26, 26, 'USD', 1.00, null, null, null),      -- Stripe (tenant_id = null)
    (27, 27, 'INR', 80.00, null, null, null),     -- Razorpay (tenant_id = null)
    (28, 28, 'INR', 80.00, null, null, null),     -- Instamojo (tenant_id = null)
    (29, 29, 'USD', 1.00, null, null, null),      -- Mollie (tenant_id = null)
    (30, 30, 'NGN', 464.00, null, null, null),    -- Paystack (tenant_id = null)
    (31, 31, 'BDT', 100.00, null, null, null),    -- Sslcommerz (tenant_id = null)
    (32, 32, 'NGN', 464.00, null, null, null),    -- Flutterwave (tenant_id = null)
    (33, 33, 'BRL', 5.00, null, null, null),      -- Mercadopago (tenant_id = null)
    (34, 34, 'USD', 1.00, null, null, null),      -- Binance (tenant_id = null)
    (35, 35, 'USD', 1.00, null, null, null),      -- Coinbase (tenant_id = null)
    (36, 36, 'INR', 80.00, null, null, null),     -- Paytm (tenant_id = null)
    (37, 37, 'USD', 1.00, null, null, null),      -- Maxicash (tenant_id = null)
    (38, 38, 'TRY', 27.00, null, null, null),     -- Iyzico (tenant_id = null)
    (39, 39, 'USD', 1.00, null, null, null),      -- Bitpay (tenant_id = null)
    (40, 40, 'NGN', 464.00, null, null, null),    -- Zitopay (tenant_id = null)
    (41, 41, 'LKR', 320.00, null, null, null),    -- Payhere (tenant_id = null)
    (42, 42, 'XOF', 600.00, null, null, null),    -- Cinetpay (tenant_id = null)
    (43, 43, 'NGN', 464.00, null, null, null),    -- Voguepay (tenant_id = null)
    (44, 44, 'MYR', 4.50, null, null, null),      -- Toyyibpay (tenant_id = null)
    (45, 45, 'EGP', 30.00, null, null, null),     -- Paymob (tenant_id = null)
    (46, 46, 'USD', 1.00, null, null, null),      -- Authorize (tenant_id = null)
    (47, 47, 'CNY', 7.00, null, null, null),      -- Alipay (tenant_id = null)
    (48, 48, 'USD', 1.00, null, null, null);      -- Bank (tenant_id = null)

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2019_08_19_000000_create_failed_jobs_table',1),(5,'2019_12_14_000001_create_personal_access_tokens_table',1),(6,'2022_06_23_121213_create_settings_table',1),(7,'2022_06_25_104329_create_countries_table',1),(8,'2022_06_25_110824_create_currencies_table',1),(9,'2022_06_25_111037_create_languages_table',1),(10,'2022_06_26_130302_create_alumnis_table',1),(11,'2022_06_27_104144_create_user_institutions_table',1),(12,'2022_11_30_040739_create_gateways_table',1),(13,'2023_01_03_075827_create_gateway_currencies_table',1),(14,'2023_01_05_092212_create_file_managers_table',1),(15,'2023_01_07_120244_create_banks_table',1),(16,'2023_01_30_071830_create_payments_table',1),(17,'2023_05_29_125747_create_contact_messages_table',1),(18,'2023_05_30_123930_create_news_tags_table',1),(19,'2023_05_30_124208_create_news_categories_table',1),(20,'2023_05_31_053037_create_news_table',1),(21,'2023_06_01_124435_create_news_tag',1),(22,'2023_06_11_075340_create_memebrship_plans',1),(23,'2023_06_12_095437_create_sms_histories_table',1),(24,'2023_06_14_062807_create_mail_histories_table',1),(25,'2023_07_09_100721_create_notifications_table',1),(26,'2023_07_20_052653_create_email_templates_table',1),(27,'2023_07_22_111528_database_backups_table',1),(28,'2023_07_22_111738_database_backup_cron_settings_table',1),(29,'2023_08_06_094452_create_event_categories_table',1),(30,'2023_08_06_094458_create_passing_years_table',1),(31,'2023_08_06_094504_create_batches_table',1),(32,'2023_08_06_094512_create_departments_table',1),(33,'2023_08_07_062359_create_authentication_log_table',1),(34,'2023_08_08_095649_create_notice_categories_table',1),(35,'2023_08_08_095707_create_notices_table',1),(36,'2023_08_08_121638_create_user_membership_plans_table',1),(37,'2023_08_08_122610_create_posts_table',1),(38,'2023_08_08_130843_create_events_table',1),(39,'2023_08_08_131212_create_event_tickets_table',1),(40,'2023_08_08_133927_create_post_likes_table',1),(41,'2023_08_08_133946_create_post_comments_table',1),(42,'2023_08_08_135504_create_post_media_table',1),(43,'2023_08_16_074843_create_chats_table',1),(44,'2023_08_26_075204_create_metas_table',1),(45,'2023_09_03_115217_create_job_posts_table',1),(46,'2023_09_05_090819_create_notification_seens_table',1),(47,'2023_09_07_133233_update_password_resets_table',1),(48,'2023_09_10_112408_create_transactions_table',1),(49,'2023_09_14_114317_add_column_in_transactions_table',1),(50,'2023_09_15_114317_add_reference_column_in_transactions_table',1),(51,'2023_09_17_092916_add_timestamps_to_posts_table',1),(52,'2023_09_20_061038_change_migration_in_currencies_table',1),(53,'2023_09_20_061618_add_column_in_events_table',1),(54,'2023_09_21_072359_change_column_in_events_table',1),(55,'2023_09_21_192710_create_chat_media_table',1),(56,'2023_09_23_115114_add_column_in_users_table',1),(58,'2023_10_18_162437_create_stories_table',1),(59,'2023_10_19_193144_create_photo_galleries_table',1),(60,'2023_10_22_142555_create_contact_us_table',1),(61,'2019_09_15_000010_create_tenants_table',2),(62,'2019_09_15_000020_create_domains_table',2),(63,'2023_10_23_093637_create_packages_table',2),(64,'2023_10_23_094232_create_user_packages_table',2),(65,'2023_10_25_075216_create_frontend_sections_table',2),(66,'2023_10_25_125314_create_features_settings_table',2),(67,'2023_10_26_110108_create_core_pages_settings_table',2),(68,'2023_10_26_122659_create_testimonials_table',2),(69,'2023_10_26_124142_create_faqs_table',2),(70,'2023_10_29_190449_add_tenant_id_in_all_tables',2),(71,'2023_11_01_131517_create_custom_domain_requests_table',2),(72,'2023_11_07_131034_add_column_in_payments_table',2),(73,'2023_11_08_151228_create_how_its_works_table',2),(74,'2023_11_09_213219_add_new_field_to_contact_us_table',2),(75,'2023_11_15_121034_remove_gateway_slug_unique_in_gateways_table',2),(76,'2023_11_30_094646_add_column_in_user_packages_table',2),(77,'2024_04_01_115509_create_news_subscription_letters_table',3),(78,'2024_04_02_092743_create_subscription_email_templates_table',3),(79,'2024_04_04_145248_create_register_forms_table',3),(80,'2024_04_04_145958_add_column_in_alumnus_table',3),(81,'2024_04_06_104437_nullable_fileds_in_alumnus_table',3),(82,'2024_04_16_182953_create_campaign_categories_table',4),(83,'2024_04_16_190424_create_campaigns_table',4),(84,'2024_04_16_193105_create_campaign_comments_table',4),(85,'2024_04_16_193124_create_campaign_donations_table',4),(86,'2024_04_16_194836_change_payments_table',4),(87,'2024_04_25_130507_create_committee_elections_table',4),(88,'2024_04_25_130623_create_committee_categories_table',4),(89,'2024_04_25_130637_create_committee_designations_table',4),(90,'2024_04_25_155506_create_committee_board_members_table',4),(91,'2024_04_25_155540_create_committee_nomination_forms_table',4),(92,'2024_04_25_155619_create_committee_candidates_table',4),(93,'2024_04_25_155744_create_committee_votes_table',4),(94,'2024_04_25_155939_create_committee_candidate_comments_table',4),(95,'2024_04_25_160013_create_committees_table',4),(96,'2024_05_06_060110_create_committee_candidate_flags_table',4),(97,'2024_05_08_160154_add_column_in_committee_elections_table',4),(98,'2024_07_14_114302_create_permission_tables',5),(99,'2024_07_14_172531_add_column_in_users_table',5);
INSERT INTO `languages` (id, language, iso_code, flag_id, font, rtl, status, `default`, created_at, updated_at, deleted_at) VALUES (1,'English','en',NULL,NULL,0,1,1,'2023-09-24 02:01:03','2023-09-24 02:01:03',NULL);
INSERT INTO `settings`
(tenant_id, option_key, option_value, created_at, updated_at)
VALUES
    (NULL,'build_version','11','2023-09-24 02:01:03','2023-09-24 02:01:03'),
    (NULL,'current_version','3.6','2023-09-24 02:01:03','2023-09-24 02:01:03'),
    (1,'app_name','Zaialumni','2023-09-24 02:02:45','2023-11-16 07:37:55'),
    (1,'app_email','zaialumni@example.com','2023-09-24 02:02:45','2023-11-16 07:37:55'),
    (1,'app_contact_number','+00000000000','2023-09-24 02:02:45','2023-11-16 07:37:55'),
    (1,'app_location','Khulna, Bangladesh','2023-09-24 02:02:45','2023-11-16 07:37:55'),
    (NULL,'app_copyright','© 2023 Zainik Lab. All Rights Reserved.','2023-09-24 02:02:45','2023-09-24 02:02:45'),
    (NULL,'app_developed','Zainikthemes','2023-09-24 02:02:45','2023-09-24 02:02:45'),
    (1,'app_timezone','Asia/Dhaka','2023-09-24 02:02:45','2023-11-16 07:37:55'),
    (1,'app_color_design_type','1','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_primary_color','#ff671b','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_secondary_color','#111111','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_text_color','#585858','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_section_bg_color','#fffaf7','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_hero_bg_color1','#000000','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_hero_bg_color2','#000000','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_hero_bg_color',NULL,'2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_preloader','1','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_logo','2','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'app_fav_icon','3','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'login_left_image','4','2023-09-24 08:03:08','2023-11-16 07:37:55'),
    (1,'google_login_status','1','2023-09-24 08:03:24','2023-11-16 07:37:55'),
    (1,'facebook_login_status','1','2023-09-24 08:03:25','2023-11-16 07:37:55'),
    (1,'cookie_status','1','2023-09-24 08:03:32','2023-11-16 07:37:55'),
    (1,'register_file_required','1','2023-09-24 08:04:37','2023-11-16 07:37:55'),
    (1,'app_preloader_status','1','2023-09-24 08:04:39','2023-11-16 07:37:55'),
    (1,'registration_approval','1','2023-09-24 08:04:42','2023-11-16 07:37:55'),
    (NULL,'show_language_switcher','1','2023-09-24 08:04:43','2023-09-24 08:04:43'),
    (1,'gateway_settings','{\"paypal\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Client ID\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret\",\"name\":\"secret\",\"is_show\":1}],\"stripe\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Public Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret Key\",\"name\":\"secret\",\"is_show\":0}],\"razorpay\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret\",\"name\":\"secret\",\"is_show\":1}],\"instamojo\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Api Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Auth Token\",\"name\":\"secret\",\"is_show\":1}],\"mollie\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Mollie Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret\",\"name\":\"secret\",\"is_show\":0}],\"paystack\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Public Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret Key\",\"name\":\"secret\",\"is_show\":0}],\"mercadopago\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Client ID\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Client Secret\",\"name\":\"secret\",\"is_show\":1}],\"sslcommerz\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Store ID\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Store Password\",\"name\":\"secret\",\"is_show\":1}],\"flutterwave\":[{\"label\":\"Hash\",\"name\":\"url\",\"is_show\":1},{\"label\":\"Public Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Client Secret\",\"name\":\"secret\",\"is_show\":1}],\"coinbase\":[{\"label\":\"Hash\",\"name\":\"url\",\"is_show\":0},{\"label\":\"API Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Client Secret\",\"name\":\"secret\",\"is_show\":0}],\"binance\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"API Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret Key\",\"name\":\"secret\",\"is_show\":1}]}','2023-06-19 01:35:33','2023-11-16 07:37:55'),
    (NULL,'STORAGE_DRIVER','public','2023-09-24 02:01:03','2023-09-24 02:01:03'),
    (1,'facebook_url','https://www.facebook.com/','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'linkedin_url','https://www.linkedin.com/','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'twitter_url','https://www.google.com/','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'instagram_url','https://www.google.com/','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'sign_up_left_text_title','Welcome Back','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'join_our_community_title','Join Our Community Now','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'sign_up_left_text_subtitle','Register now to see people who have attended or graduated from a particular school, college or university.','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'footer_left_text','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam tempus elementum metus vitae vulputate. Proin mattis ligula a nunc suscipit, sed aliquam mi condimentum. In dictum erat lacus, id iaculis mauris tincidunt quis.','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'page_breadcrumb','245','2023-10-22 13:19:16','2023-11-16 07:37:55'),
    (1,'banner_title','We are the proud student of Zaialumni university forever','2023-10-22 13:22:43','2023-11-16 07:37:55'),
    (1,'banner_description','Zaialumni is a user friendly that helps alumni easily connect and manage their activities. Alumni can sign up and get approved by submitting necessary documents, which allows them to join the alumni community','2023-10-22 13:22:43','2023-11-16 07:37:55'),
    (1,'banner_background_breadcrumb','229','2023-10-22 13:22:43','2023-11-16 07:37:55'),
    (1,'upcoming_events_background','230','2023-10-22 13:22:43','2023-11-16 07:37:55'),
    (1,'app_black_logo','231','2023-10-22 13:28:40','2023-11-16 07:37:55'),
    (1,'about_us_title','About Zaialumni','2023-10-22 13:30:22','2023-11-16 07:37:55'),
    (1,'about_us_description','<ul class=\"list-pb-22\"><li class=\"d-flex align-items-start cg-12\"><div class=\"flex-shrink-0 d-flex pt-5\"><img src=\"/frontend/images/icon/check-circle.svg\" alt=\"\"></div><p class=\"fs-18 fw-400 lh-28 text-color1\">Alumni Association provides and supports alumni programs and services, facilitates communication with alumni, and seeks to strengthen alumni bonds of fellowship, professional association and university affiliation.</p></li><li class=\"d-flex align-items-start cg-12\"><div class=\"flex-shrink-0 d-flex pt-5\"><img src=\"/frontend/images/icon/check-circle.svg\" alt=\"\"></div><p class=\"fs-18 fw-400 lh-28 text-color1\">Connect alumni with mentors or coaches who can offer them guidance, advice, or feedback on their personal or professional goals. They can also help them expand their network, explore new opportunities, or overcome challenges</p></li><li class=\"d-flex align-items-start cg-12\"><div class=\"flex-shrink-0 d-flex pt-5\"><img src=\"/frontend/images/icon/check-circle.svg\" alt=\"\"></div><p class=\"fs-18 fw-400 lh-28 text-color1\">The Alumni Association leverages the resources, talents, and initiatives of alumni and friends to advise, guide, advocate for and support the Association and the university in achieving their respective missions and goals. The Alumni Association provides an alumni network and encourages alumni engagement in the life of the university.</p></li><li class=\"d-flex align-items-start cg-12\"><div class=\"flex-shrink-0 d-flex pt-5\"><img src=\"/frontend/images/icon/check-circle.svg\" alt=\"\"></div><p class=\"fs-18 fw-400 lh-28 text-color1\">Alumni Association provides and supports alumni programs and services, facilitates communication with alumni, and seeks to strengthen alumni bonds of fellowship, professional association and university affiliation.</p></li></ul>','2023-10-22 13:30:22','2023-11-16 07:37:55'),
    (1,'about_us_background_breadcrumb','233','2023-10-22 13:30:22','2023-11-16 07:37:55'),
    (1,'join_us_left_title','Attend Events','2023-10-22 13:38:18','2023-11-16 07:37:55'),
    (1,'join_us_left_description','<p><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam tempus elementum metus vitae vulputate. Proin mattis ligula a nunc suscipit,</span><br></p>','2023-10-22 13:38:18','2023-11-16 07:37:55'),
    (1,'join_us_middle_title','Advance Your Career','2023-10-22 13:38:18','2023-11-16 07:37:55'),
    (1,'join_us_middle_description','<p><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam tempus elementum metus vitae vulputate. Proin mattis ligula a nunc suscipit,</span><br></p>','2023-10-22 13:38:18','2023-11-16 07:37:55'),
    (1,'join_us_right_title','Reconnect your Friend','2023-10-22 13:38:18','2023-11-16 07:37:55'),
    (1,'join_us_right_description','<p><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam tempus elementum metus vitae vulputate. Proin mattis ligula a nunc suscipit,</span><br></p>','2023-10-22 13:38:18','2023-11-16 07:37:55'),
    (1,'join_us_left_icon','255','2023-10-22 13:40:40','2023-11-16 07:37:55'),
    (1,'join_us_middle_icon','256','2023-10-22 13:40:40','2023-11-16 07:37:55'),
    (1,'join_us_right_icon','257','2023-10-22 13:40:40','2023-11-16 07:37:55'),
    (1,'refund_policy_title','Refund Policy Of Our Site','2023-10-22 14:11:13','2023-11-16 07:37:55'),
    (1,'refund_policy_description','Refund Policy','2023-10-22 14:11:13','2023-11-16 07:37:55'),
    (1,'terms_condition_title','Terms & Condition','2023-10-22 14:12:13','2023-11-16 07:37:55'),
    (1,'terms_condition_description','Terms & Condition','2023-10-22 14:12:13','2023-11-16 07:37:55'),
    (1,'cookie_policy_title','Cookie Policy','2023-10-22 14:12:37','2023-11-16 07:37:55'),
    (1,'cookie_policy_description','Cookie Policy','2023-10-22 14:12:37','2023-11-16 07:37:55'),
    (1,'privacy_policy_title','Privacy Policy','2023-10-22 14:12:54','2023-11-16 07:37:55'),
    (1,'privacy_policy_description','Privacy Policy','2023-10-22 14:12:54','2023-11-16 07:37:55');
INSERT INTO `tenants` (id, created_at, updated_at, data) VALUES ('1','2023-11-16 07:37:54','2023-11-16 07:37:54',NULL);
INSERT INTO `currencies` (id, tenant_id, currency_code, symbol, currency_placement, current_currency, created_at, updated_at) VALUES (1,1,'USD','$','before',1,'2023-09-24 02:01:03','2023-11-16 07:37:54'),(2,1,'BDT','৳','before',0,'2023-09-24 02:01:03','2023-11-16 07:37:54'),(3,1,'INR','₹','before',0,'2023-09-24 02:01:03','2023-11-16 07:37:54'),(4,1,'GBP','£','after',0,'2023-09-24 02:01:03','2023-11-16 07:37:54'),(5,1,'MXN','$','before',0,'2023-09-24 02:01:03','2023-11-16 07:37:54'),(6,1,'SAR','SR','before',0,'2023-09-24 02:01:03','2023-11-16 07:37:54'),(7,0,'USD','$','before',1,'2023-11-16 07:37:56','2023-11-16 07:37:56'),(8,0,'BDT','৳','before',0,'2023-11-16 07:37:56','2023-11-16 07:37:56'),(9,0,'INR','₹','before',0,'2023-11-16 07:37:56','2023-11-16 07:37:56'),(10,0,'GBP','£','after',0,'2023-11-16 07:37:56','2023-11-16 07:37:56'),(11,0,'MXN','$','before',0,'2023-11-16 07:37:56','2023-11-16 07:37:56'),(12,0,'SAR','SR','before',0,'2023-11-16 07:37:56','2023-11-16 07:37:56');
INSERT INTO `permissions` VALUES (1,'Manage Event','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(2,'Manage Job Post','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(3,'Manage Story','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(4,'Manage Alumni','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(5,'Manage Membership','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(6,'Manage Notice','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(7,'Manage News','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(8,'Manage Transaction','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(9,'Manage Donation','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(10,'Manage Committee','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(11,'Manage Vote','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(12,'Manage Moderator','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(13,'Manage Website Settings','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(14,'Manage Newsletter','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(15,'Manage Application Setting','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(16,'Manage Subscription','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(17,'Manage Custom Domain','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(18,'Chat','web','2024-08-20 07:52:59','2024-08-20 07:52:59'),(19,'Manage Version Update','web','2024-08-20 07:52:59','2024-08-20 07:52:59');
