-- https://www.phpmyadmin.net/
--
-- Versi Server: 10.1.21-MariaDB




--
-- Database: `qopi_admin`
--

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

--
-- Struktur dari tabel `emails`
--

CREATE TABLE `emails` (
  `id` int(10) UNSIGNED NOT NULL,
  `link_id` int(11) DEFAULT NULL,
  `email` varchar(191) 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;

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

--
-- Struktur dari tabel `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `jobs`
--

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

--
-- Dumping data untuk tabel `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:8:\\\"whatsapp\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";s:9:\\\"hyperlink\\\";N;s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:8:\\\"12345678\\\";s:7:\\\"message\\\";s:16:\\\"asdahdkjadasdsad\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/3e9278\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513489088, 1513489088),
(2, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:8:\\\"whatsapp\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";s:9:\\\"hyperlink\\\";N;s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:8:\\\"12345678\\\";s:7:\\\"message\\\";s:22:\\\"asdahdkjadasdsadzxczxc\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/b7611e\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513497712, 1513497712),
(3, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:8:\\\"whatsapp\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";s:9:\\\"hyperlink\\\";N;s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:8:\\\"12345678\\\";s:7:\\\"message\\\";s:22:\\\"asdahdkjadasdsadzxczxc\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/b74381\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500483, 1513500483),
(4, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:8:\\\"whatsapp\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:26:\\\"nauval.azhar@procyon.co.id\\\";s:9:\\\"hyperlink\\\";N;s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:10:\\\"1231234123\\\";s:7:\\\"message\\\";s:5:\\\"Hello\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/e6a906\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:26:\\\"nauval.azhar@procyon.co.id\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500494, 1513500494),
(5, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:8:\\\"whatsapp\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:26:\\\"frameborder.code@gmail.com\\\";s:9:\\\"hyperlink\\\";N;s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:9:\\\"998273827\\\";s:7:\\\"message\\\";s:4:\\\"Hmmm\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/3951ee\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:26:\\\"frameborder.code@gmail.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500508, 1513500508),
(6, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:5:\\\"short\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:26:\\\"frameborder.code@gmail.com\\\";s:9:\\\"hyperlink\\\";s:20:\\\"http:\\/\\/multinity.com\\\";s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:9:\\\"998273827\\\";s:7:\\\"message\\\";s:4:\\\"Hmmm\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/f37a7e\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:26:\\\"frameborder.code@gmail.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500522, 1513500522),
(7, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:5:\\\"short\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";s:9:\\\"hyperlink\\\";s:17:\\\"http:\\/\\/google.com\\\";s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:9:\\\"998273827\\\";s:7:\\\"message\\\";s:4:\\\"Hmmm\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/5b37c1\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500550, 1513500550),
(8, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:5:\\\"short\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:15:\\\"hi@kodinger.com\\\";s:9:\\\"hyperlink\\\";s:19:\\\"http:\\/\\/kodinger.com\\\";s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:9:\\\"998273827\\\";s:7:\\\"message\\\";s:4:\\\"Hmmm\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/bb4c9c\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:15:\\\"hi@kodinger.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500564, 1513500564),
(9, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:5:\\\"short\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:17:\\\"zuck@facebook.com\\\";s:9:\\\"hyperlink\\\";s:19:\\\"http:\\/\\/facebook.com\\\";s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:9:\\\"998273827\\\";s:7:\\\"message\\\";s:4:\\\"Hmmm\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/cd39ec\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:17:\\\"zuck@facebook.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500583, 1513500583),
(10, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:5:\\\"short\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:17:\\\"zuck@facebook.com\\\";s:9:\\\"hyperlink\\\";s:20:\\\"http:\\/\\/instagram.com\\\";s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:9:\\\"998273827\\\";s:7:\\\"message\\\";s:4:\\\"Hmmm\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/0607ae\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:17:\\\"zuck@facebook.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500606, 1513500606),
(11, 'default', '{\"displayName\":\"App\\\\Mail\\\\NewLink\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"Illuminate\\\\Mail\\\\SendQueuedMailable\",\"command\":\"O:34:\\\"Illuminate\\\\Mail\\\\SendQueuedMailable\\\":3:{s:8:\\\"mailable\\\";O:16:\\\"App\\\\Mail\\\\NewLink\\\":20:{s:4:\\\"data\\\";a:8:{s:4:\\\"type\\\";s:5:\\\"short\\\";s:9:\\\"send_link\\\";s:1:\\\"1\\\";s:5:\\\"email\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";s:9:\\\"hyperlink\\\";s:25:\\\"http:\\/\\/facebook.com\\/int11\\\";s:10:\\\"phone_code\\\";s:3:\\\"+62\\\";s:5:\\\"phone\\\";s:9:\\\"998273827\\\";s:7:\\\"message\\\";s:4:\\\"Hmmm\\\";s:4:\\\"link\\\";s:21:\\\"http:\\/\\/qopi.me\\/c9e428\\\";}s:4:\\\"from\\\";a:0:{}s:2:\\\"to\\\";a:1:{i:0;a:2:{s:4:\\\"name\\\";N;s:7:\\\"address\\\";s:22:\\\"nauvalazhar2@gmail.com\\\";}}s:2:\\\"cc\\\";a:0:{}s:3:\\\"bcc\\\";a:0:{}s:7:\\\"replyTo\\\";a:0:{}s:7:\\\"subject\\\";N;s:11:\\\"\\u0000*\\u0000markdown\\\";N;s:4:\\\"view\\\";N;s:8:\\\"textView\\\";N;s:8:\\\"viewData\\\";a:0:{}s:11:\\\"attachments\\\";a:0:{}s:14:\\\"rawAttachments\\\";a:0:{}s:9:\\\"callbacks\\\";a:0:{}s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;}\"}}', 0, NULL, 1513500632, 1513500632);

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

--
-- Struktur dari tabel `links`
--

CREATE TABLE `links` (
  `id` int(10) UNSIGNED NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hyperlink` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `link_hits`
--

CREATE TABLE `link_hits` (
  `id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktur dari tabel `migrations`
--

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

--
-- Dumping data untuk tabel `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2017_09_20_124155_create_links_table', 1),
(2, '2017_11_27_150913_create_failed_jobs_table', 1),
(3, '2017_11_27_150932_create_jobs_table', 1),
(4, '2017_12_09_023355_create_emails_table', 2);

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

--
-- Struktur dari tabel `pages`
--

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'About Us', 'about-us', '<p>Hello, thank you for purchasing our script!</p>\r\n<p><img src=\"/qopi-admin/web/public/media/Koala.jpg\" alt=\"\" width=\"181\" height=\"136\" /></p>', 'publish', '2017-12-17 01:32:00', '2017-12-17 02:04:58', NULL),
(2, 'Term and Conditions', 'term-and-conditions', '<p>Edit this page!</p>', 'publish', '2017-12-17 09:28:29', '2017-12-17 09:28:29', NULL);

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

--
-- Struktur dari tabel `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `sort` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `settings`
--

INSERT INTO `settings` (`id`, `name`, `display_name`, `description`, `sort`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'general', 'General', NULL, 1, '2017-12-17 02:25:14', '2017-12-17 02:25:14', NULL),
(2, 'options', 'Options', NULL, 2, '2017-12-17 02:34:54', '2017-12-17 02:34:54', NULL),
(3, 'ads', 'Ads', NULL, 3, '2017-12-17 07:18:46', '2017-12-17 07:18:46', NULL);

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

--
-- Struktur dari tabel `setting_items`
--

CREATE TABLE `setting_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `settings_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `sort` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `setting_items`
--
--
-- Dumping data untuk tabel `setting_items`
--

INSERT INTO `setting_items` (`id`, `settings_id`, `name`, `display_name`, `type`, `description`, `sort`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'site_name', 'Site Name', 'text|null|required', NULL, 1, '2017-12-17 02:29:04', '2017-12-17 02:29:04', NULL),
(2, 2, 'option_required_email', 'Is Email Required?', 'select|Yes,No|required', 'If set to \'Yes\' then users will be required to enter their email before creating the link. This feature is perfect for you if as a marketer.', 1, '2017-12-17 02:36:08', '2017-12-20 08:14:25', NULL),
(3, 3, 'option_required_ads', 'Is Ads Required?', 'select|Yes,No|required', 'If set \'yes\' then the user will be required to wait for ads when visiting the results of links that have been generated before.', 1, '2017-12-17 02:36:26', '2017-12-20 08:13:44', NULL),
(4, 3, 'option_ads_wait_time', 'How Long is The Ad Waiting Time?', 'number|null|required', 'In seconds', 1, '2017-12-17 02:37:50', '2017-12-20 08:13:51', NULL),
(5, 3, 'option_ads_auto_continue', 'Ads Auto Continue', 'select|Yes,No|required', 'When the time is up, the page automatically goes to the original link without clicking any button.', 1, '2017-12-17 02:39:18', '2017-12-20 08:13:57', NULL),
(6, 1, 'site_metas', 'Meta Tags', 'code|null|not-required', NULL, 5, '2017-12-17 02:43:20', '2017-12-17 07:01:27', NULL),
(7, 1, 'site_name_front', 'Site Title Front Page', 'text|null|required', NULL, 2, '2017-12-17 07:01:16', '2017-12-17 07:01:16', NULL),
(8, 3, 'ads_iframe', 'Ads Iframe URL', 'text|null|required', NULL, 1, '2017-12-17 07:19:21', '2017-12-17 07:19:21', NULL),
(9, 3, 'ads_image', 'Ads Image', 'image|null|not-required', NULL, 2, '2017-12-17 07:19:51', '2017-12-17 07:19:51', NULL),
(10, 3, 'ads_image_url', 'Ads Image URL', 'text|null|not-required', NULL, 3, '2017-12-17 07:20:08', '2017-12-17 07:20:08', NULL),
(11, 2, 'option_max_custom_link', 'Max. Custom Link Character', 'number|10|required', NULL, 5, '2017-12-17 08:52:50', '2017-12-17 08:52:50', NULL),
(12, 2, 'qrcode_size', 'QR Code Size', 'number|null|required', 'Written in pixels', 6, '2017-12-20 07:07:25', '2017-12-20 07:07:25', NULL),
(13, 2, 'qrcode_margin', 'QR Code Margin', 'number|null|required', NULL, 7, '2017-12-20 07:54:05', '2017-12-20 07:54:05', NULL),
(14, 1, 'site_country_code', 'Country Code (ISO \"ALPHA-2 Code)', 'text|null|required', 'Your country code, you can find it <a href=\"http://www.nationsonline.org/oneworld/country_code_list.htm\" target=\"_blank\">here</a>', 3, '2017-12-20 08:02:09', '2017-12-20 08:21:21', NULL),
(15, 2, 'option_show_all_country', 'Show Phone Code of All Countries', 'select|Yes,No|required', 'If yes, on the homepage then users will be able to choose their phone code. If not, then the system can only create WhatsApp link for the country that has been specified at the setting page', 1, '2017-12-20 08:12:50', '2017-12-20 08:12:50', NULL),
(16, 1, 'site_add_code_head', 'Put the Code in the Head Tag', 'code|null|not-required', 'The code will be placed before the <code>&lt;/head&gt;</code> tag', 6, '2017-12-20 08:16:59', '2017-12-20 08:16:59', NULL);

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

--
-- Struktur dari tabel `setting_stored`
--

CREATE TABLE `setting_stored` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `setting_stored`
--

INSERT INTO `setting_stored` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES
(9, 'site_name', 'Qopi', '2017-12-17 02:30:58', '2017-12-20 08:06:09'),
(12, 'site_metas', '<meta name=\"keyword\" content=\"qopi, whatsapp click to chat, whatsapp api, whatsapp link generator, url shortener\">\r\n<meta name=\"description\" content=\"create your own whatsapp or short link\">', '2017-12-17 02:49:37', '2017-12-20 08:06:10'),
(13, 'site_name_front', 'Create your own WhatsApp link', '2017-12-17 07:06:01', '2017-12-20 08:06:09'),
(14, 'option_required_email', 'No', '2017-12-17 07:11:12', '2017-12-20 08:38:45'),
(15, 'option_required_ads', 'Yes', '2017-12-17 07:11:13', '2017-12-20 07:55:28'),
(16, 'option_ads_wait_time', '10', '2017-12-17 07:11:13', '2017-12-20 07:55:28'),
(17, 'option_ads_auto_continue', 'No', '2017-12-17 07:11:13', '2017-12-20 07:55:28'),
(18, 'ads_iframe', 'http://multinity.com', '2017-12-17 07:21:28', '2017-12-17 07:27:28'),
(19, 'ads_image', 'ads.png', '2017-12-17 07:21:28', '2017-12-17 07:27:29'),
(20, 'ads_image_url', 'http://codecanyon.net/item/qopi-whatsapp-and-short-link-generator/21049465?ref=frameborder', '2017-12-17 07:21:28', '2017-12-17 07:27:29'),
(21, 'option_max_custom_link', '10', '2017-12-17 08:52:58', '2017-12-20 08:38:46'),
(22, 'qrcode_size', '200', '2017-12-20 07:07:37', '2017-12-20 08:38:46'),
(23, 'qrcode_margin', '0', '2017-12-20 07:55:20', '2017-12-20 08:38:46'),
(24, 'site_country_code', 'ID', '2017-12-20 08:03:06', '2017-12-20 08:06:09'),
(25, 'option_show_all_country', 'No', '2017-12-20 08:17:58', '2017-12-20 08:38:46');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_name_unique` (`name`);

--
-- Indexes for table `setting_items`
--
ALTER TABLE `setting_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_items_name_unique` (`name`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `emails`
--
ALTER TABLE `emails`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `links`
--
ALTER TABLE `links`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `link_hits`
--
ALTER TABLE `link_hits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `setting_items`
--
ALTER TABLE `setting_items`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `setting_stored`
--
ALTER TABLE `setting_stored`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
