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

START TRANSACTION;



--
-- Database: `database`
--

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

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

CREATE TABLE `ads` (
  `id` tinyint(3) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ads` (`id`, `title`, `code`, `created_at`, `updated_at`) VALUES
(1, 'below_header', NULL, NULL, '2021-07-29 20:05:52'),
(2, 'above_footer', NULL, NULL, '2022-07-14 12:43:22'),
(3, 'below_left_column', NULL, NULL, '2022-06-02 18:51:08'),
(4, 'above_left_column', NULL, NULL, '2021-08-13 17:57:50'),
(5, 'right_column', NULL, NULL, '2022-07-24 00:50:16'),
(6, 'link_page_left', NULL, NULL, '2021-10-12 18:52:27'),
(7, 'link_page_right', NULL, NULL, '2021-10-12 18:52:37');

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

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(755) COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_views` int(11) NOT NULL DEFAULT 0,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` smallint(5) 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 `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` tinyint(4) NOT NULL,
  `enabled` 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 `categories`
--

CREATE TABLE `categories` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_content` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `item_count` int(11) NOT NULL DEFAULT 0,
  `sort` smallint(5) NOT NULL,
  `home_page` tinyint(1) NOT NULL DEFAULT 0,
  `footer` tinyint(1) NOT NULL DEFAULT 0,
  `language` smallint(5) 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 `coinbase_webhook_calls`
--

CREATE TABLE `coinbase_webhook_calls` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exception` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `link_id` mediumint(9) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` int(11) NOT NULL,
  `approval` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `crypto_payments`
--

CREATE TABLE `crypto_payments` (
  `id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `network` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expire_notifications`
--

CREATE TABLE `expire_notifications` (
  `id` bigint(20) NOT NULL,
  `link_id` bigint(20) NOT NULL,
  `sent_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expire_notifications`
--

INSERT INTO `expire_notifications` (`id`, `link_id`, `sent_at`, `created_at`, `updated_at`) VALUES
(32, 59, '2022-07-13 17:30:59', '2022-07-13 17:30:59', NULL),
(31, 50, '2022-07-13 11:20:40', '2022-07-13 11:20:40', NULL),
(30, 54, '2022-07-13 11:00:27', '2022-07-13 11:00:27', NULL),
(29, 51, '2022-07-13 10:50:29', '2022-07-13 10:50:29', NULL),
(28, 47, '2022-07-13 05:44:27', '2022-07-13 05:44:27', NULL),
(27, 56, '2022-07-13 05:36:49', '2022-07-13 05:36:49', NULL),
(41, 55, '2022-07-13 18:13:55', '2022-07-13 18:13:55', NULL),
(46, 67, '2022-07-15 03:18:00', '2022-07-15 03:18:00', NULL);

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

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(755) COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hidden_content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screenshot` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(755) COLLATE utf8mb4_unicode_ci NOT NULL,
  `visible_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bypass_redirect` tinyint(1) NOT NULL DEFAULT 0,
  `bypass_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bypass_details` tinyint(1) NOT NULL DEFAULT 0,
  `bypass_details_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deep_links` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_views` int(11) NOT NULL DEFAULT 0,
  `clicks` int(11) NOT NULL DEFAULT 0,
  `category` int(11) NOT NULL,
  `phone_number` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_contacts` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_category` tinyint(1) NOT NULL DEFAULT 0,
  `featured_home` tinyint(1) NOT NULL DEFAULT 0,
  `votes` decimal(3,2) NOT NULL DEFAULT 0.00,
  `total_votes` smallint(5) NOT NULL DEFAULT 0,
  `badge` tinyint(1) NOT NULL DEFAULT 0,
  `owner` bigint(20) NOT NULL DEFAULT 1,
  `package` smallint(5) NOT NULL,
  `language` smallint(5) NOT NULL DEFAULT 1,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `submission_id` bigint(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `is_subscription` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expire_at` timestamp NULL 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `notifications` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `action` tinyint(1) NOT NULL,
  `details` varchar(755) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notification_read` tinyint(1) 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 `packages`
--

CREATE TABLE `packages` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(755) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `real_price` decimal(10,2) DEFAULT NULL,
  `available` tinyint(1) NOT NULL DEFAULT 1,
  `featured_category` tinyint(1) NOT NULL DEFAULT 0,
  `featured_home` tinyint(1) NOT NULL DEFAULT 0,
  `deep_links` tinyint(1) NOT NULL DEFAULT 0,
  `deep_links_count` tinyint(1) DEFAULT 0,
  `deep_links_type` tinyint(1) DEFAULT 0,
  `bypass_redirect` tinyint(1) NOT NULL DEFAULT 0,
  `bypass_redirect_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bypass_details` tinyint(1) NOT NULL DEFAULT 0,
  `bypass_details_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visible_url` tinyint(1) NOT NULL DEFAULT 0,
  `reciprocal_link` tinyint(1) NOT NULL DEFAULT 0,
  `phone_number` tinyint(1) NOT NULL DEFAULT 0,
  `email` tinyint(1) NOT NULL DEFAULT 0,
  `address` tinyint(1) NOT NULL DEFAULT 0,
  `other_contacts` tinyint(1) NOT NULL DEFAULT 0,
  `duration` tinyint(1) NOT NULL DEFAULT 0,
  `sort` tinyint(4) 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 `packages`
--

INSERT INTO `packages` (`id`, `title`, `description`, `price`, `real_price`, `available`, `featured_category`, `featured_home`, `deep_links`, `deep_links_count`, `deep_links_type`, `bypass_redirect`, `bypass_redirect_type`, `bypass_details`, `bypass_details_type`, `visible_url`, `reciprocal_link`, `phone_number`, `email`, `address`, `other_contacts`, `duration`, `sort`, `created_at`, `updated_at`) VALUES
(1, 'Free', 'Reciprocal Link Required\r\nPhone Number, Email, and Address ✗\r\nChanging Visible URL is Allowed ✗\r\nBypass Redirection Page ✗\r\nNo Deep Links', '0.00', NULL, 1, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, 1, 0, 0, 0, 0, 0, 0, '2022-07-24 04:15:15', NULL),
(2, 'Regular Link', 'Featured on Category Page ✓\r\nEmail and Address ✓\r\nChanging Visible URL is Allowed ✓\r\nBypass Redirection Page ✓\r\n2 Deep Links', '9.99', NULL, 1, 1, 0, 1, 1, 3, 1, '1', 1, '1', 1, 0, 0, 1, 1, 0, 0, 1, '2022-07-24 04:15:15', NULL),
(3, 'Premium', 'Featured on Home and Category Page ✓\r\nPhone Number, Email, and Address ✓\r\nChanging Visible URL is Allowed ✓\r\nBypass Redirection Page ✓\r\n3 Deep Links', '19.99', NULL, 1, 1, 1, 1, 3, 3, 1, '1', 1, '1', 1, 0, 1, 1, 1, 1, 0, 2, '2022-07-24 04:15:15', NULL);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer` tinyint(1) NOT NULL DEFAULT 0,
  `navbar` tinyint(1) NOT NULL DEFAULT 0,
  `sort` tinyint(4) NOT NULL,
  `page_views` int(11) NOT NULL DEFAULT 0,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` smallint(5) 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 `partners`
--

CREATE TABLE `partners` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` tinyint(4) NOT NULL,
  `options` varchar(755) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer` tinyint(1) NOT NULL DEFAULT 0,
  `navbar` tinyint(1) NOT NULL DEFAULT 0,
  `language` smallint(5) 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 `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `subscription` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `title`, `enabled`, `subscription`, `created_at`, `updated_at`) VALUES
(1, 'paypal_one_time', 1, 0, NULL, NULL),
(2, 'bank_transfer', 1, 0, NULL, NULL),
(3, 'stripe', 1, 0, NULL, NULL),
(4, 'cryptocurrency', 1, 0, NULL, NULL),
(5, 'paypal_subscription', 1, 1, NULL, NULL);

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

--
-- Table structure for table `payment_notifications`
--

CREATE TABLE `payment_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) NOT NULL DEFAULT 0,
  `link_id` bigint(20) DEFAULT NULL,
  `bank_account` smallint(1) NOT NULL DEFAULT 0,
  `sender_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `paypal_webhook_calls`
--

CREATE TABLE `paypal_webhook_calls` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `processed` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `screenshot_queue`
--

CREATE TABLE `screenshot_queue` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `link_id` bigint(20) NOT NULL,
  `as_icon` tinyint(1) 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 `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` smallint(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `name`, `value`, `language`) VALUES
(1, 'site_title', 'Link Directory Pro', 1),
(2, 'facebook_page', 'https://www.facebook.com', NULL),
(3, 'twitter_account', 'https://www.twitter.com', NULL),
(4, 'site_language', 'en', NULL),
(5, 'site_description', 'Site Description', 1),
(6, 'before_head_tag', '', NULL),
(7, 'after_head_tag', '', NULL),
(8, 'before_body_end_tag', '', NULL),
(9, 'admin_email', 'admin@site.com', NULL),
(10, 'show_random_link', '1', NULL),
(11, 'time_before_redirect', '10', NULL),
(13, 'show_cookie_bar', '1', NULL),
(14, 'enable_submission_form', '1', NULL),
(15, 'show_rss_feed', '1', NULL),
(16, 'use_text_logo', '0', NULL),
(17, 'detail_base', 'detail', 1),
(18, 'category_base', 'category', 1),
(19, 'page_base', 'page', 1),
(20, 'redirect_base', 'redirect', 1),
(21, 'breadcrumbs', '1', NULL),
(22, 'ping_google', '1', NULL),
(23, 'count_home', '1', NULL),
(24, 'sub_count_home', '0', NULL),
(25, 'sub_count_category', '0', NULL),
(26, 'category_title_format', '', 1),
(27, 'link_title_format', NULL, 1),
(28, 'home_page_title_format', NULL, 1),
(29, 'custom_page_title_format', '', 1),
(31, 'show_qr_code', '1', NULL),
(32, 'enable_report_form', '1', NULL),
(33, 'links_per_page', '10', NULL),
(34, 'search_page_links_per_page', '10', NULL),
(36, 'enable_cache', '0', NULL),
(37, 'enable_google_recaptcha', '0', NULL),
(38, 'google_recaptcha_site_key', '', NULL),
(39, 'google_recaptcha_secret_key', '', NULL),
(57, 'redirection_page_link_details_mobile', '2', NULL),
(58, 'redirection_title_format', '', 1),
(59, 'redirection_page_noindex', '1', NULL),
(60, 'show_page_views', '1', NULL),
(61, 'show_clicks', '1', NULL),
(62, 'schema_breadcrumbs', '1', NULL),
(63, 'submission_confirmation_mail', '1', NULL),
(64, 'submission_rejection_mail', '0', NULL),
(65, 'submission_notification_mail', '1', NULL),
(67, 'ga_tracking_id', '', NULL),
(68, 'ga_publisher_id', '', NULL),
(69, 'article_base', 'article', 1),
(70, 'custom_article_title_format', '', 1),
(71, 'contact_slug', 'contact-us', 1),
(73, 'latest_links_slug', 'latest-links', 1),
(74, 'popular_links_slug', 'popular-links', 1),
(75, 'all_articles_slug', 'all-articles', 1),
(76, 'articles_per_page', '9', NULL),
(77, 'sticky_ads_right_column', '1', NULL),
(78, 'articles_page_title_format', NULL, 1),
(79, 'articles_page_description', NULL, 1),
(82, 'contact_page_title_format', '', 1),
(83, 'contact_page_description', '', 1),
(84, 'latest_links_page_title_format', '', 1),
(85, 'latest_links_page_description', '', 1),
(86, 'popular_links_page_title_format', '', 1),
(87, 'popular_links_page_description', '', 1),
(89, 'page_view_once', '1', NULL),
(90, 'article_boxes_on_home_page', '1', NULL),
(92, 'show_phone_number_country_code', '1', NULL),
(93, 'show_featured_text', '1', NULL),
(94, 'payment_currency', 'USD', NULL),
(95, 'payment_currency_symbol', '$', NULL),
(96, 'show_featured_links_randomly', '1', NULL),
(97, 'show_articles_in_header', '1', NULL),
(98, 'reciprocal_link_code', '<a href=\"https://www.yoursite.com\" alt=\"Your Site\">Your Site</a>', NULL),
(99, 'search_categories', '1', NULL),
(100, 'show_links_under_subcategories', '1', NULL),
(101, 'image_quality', '65', NULL),
(102, 'save_as_webp', '1', NULL),
(103, 'infinite_scroll', '1', NULL),
(104, 'enable_registration', '1', NULL),
(106, 'thum_io_id', '', NULL),
(107, 'thum_io_url_key', '', NULL),
(109, 'save_screenshot_as_icon', '0', NULL),
(110, 'domain_blacklist', NULL, NULL),
(111, 'category_sort_by', 'NewestFirst', NULL),
(113, 'allow_user_updates', '1', NULL),
(114, 'navbar_type', '2', NULL),
(115, 'scrollable_articles_home_page', '1', NULL),
(116, 'optional_submission_icon', '1', NULL),
(118, 'max_deep_links', '5', NULL),
(119, 'cronjob_code', 'cronjob_code', NULL),
(120, 'allow_widget_embed', '1', NULL),
(121, 'use_text_logo_in_emails', '0', NULL),
(122, 'email_footer_message', 'Link Directory Pro', NULL),
(123, 'popular_links_sort_by', '1', NULL),
(124, 'root_language', '1', NULL),
(217, 'send_expire_notification', '1', NULL),
(218, 'grace_period', '24', NULL),
(220, 'enable_live_ajax_search', '1', NULL),
(271, 'paypal_webhook_code', 'paypal_webhook_code', NULL);

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

--
-- Table structure for table `submissions`
--

CREATE TABLE `submissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(755) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `visible_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bypass_redirect` tinyint(1) NOT NULL DEFAULT 0,
  `bypass_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bypass_details` tinyint(1) NOT NULL DEFAULT 0,
  `bypass_details_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deep_links` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` int(11) NOT NULL,
  `phone_number` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_contacts` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reciprocal_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_category` tinyint(1) NOT NULL DEFAULT 0,
  `featured_home` tinyint(1) NOT NULL DEFAULT 0,
  `user` bigint(20) NOT NULL DEFAULT 1,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` smallint(5) 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 `translations`
--

CREATE TABLE `translations` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `language` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` tinyint(4) 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 `translations`
--

INSERT INTO `translations` (`id`, `language`, `code`, `locale_code`, `icon`, `sort`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'en_US', 'us', 0, NULL, '2022-07-24 17:13:56');

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

--
-- Table structure for table `votes`
--

CREATE TABLE `votes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pid` mediumint(9) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `links`
--
ALTER TABLE `links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slug` (`slug`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ads`
--
ALTER TABLE `ads`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `coinbase_webhook_calls`
--
ALTER TABLE `coinbase_webhook_calls`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `expire_notifications`
--
ALTER TABLE `expire_notifications`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `links`
--
ALTER TABLE `links`
  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 for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `paypal_webhook_calls`
--
ALTER TABLE `paypal_webhook_calls`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `translations`
--
ALTER TABLE `translations`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

