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

START TRANSACTION;



--
-- Database: `gasd3326_qr`
--

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

--
-- Table structure for table `barcodes`
--

CREATE TABLE `barcodes` (
  `barcode_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(64) NOT NULL,
  `type` varchar(32) DEFAULT NULL,
  `value` varchar(64) DEFAULT NULL,
  `barcode` varchar(40) NOT NULL,
  `settings` text DEFAULT NULL,
  `embedded_data` text DEFAULT NULL,
  `datetime` datetime NOT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `blog_post_id` bigint(20) UNSIGNED NOT NULL,
  `blog_posts_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `url` varchar(256) NOT NULL,
  `title` varchar(256) NOT NULL DEFAULT '',
  `description` varchar(256) DEFAULT NULL,
  `keywords` varchar(256) DEFAULT NULL,
  `image` varchar(40) DEFAULT NULL,
  `image_description` varchar(256) DEFAULT NULL,
  `editor` varchar(16) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language` varchar(32) DEFAULT NULL,
  `total_views` bigint(20) UNSIGNED DEFAULT 0,
  `is_published` tinyint(4) DEFAULT 1,
  `datetime` datetime DEFAULT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog_posts_categories`
--

CREATE TABLE `blog_posts_categories` (
  `blog_posts_category_id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(256) NOT NULL,
  `title` varchar(256) NOT NULL DEFAULT '',
  `description` varchar(256) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `language` varchar(32) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `broadcasts`
--

CREATE TABLE `broadcasts` (
  `broadcast_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `subject` varchar(128) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `segment` varchar(64) DEFAULT NULL,
  `settings` text DEFAULT NULL,
  `users_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sent_users_ids` longtext DEFAULT NULL,
  `sent_emails` int(10) UNSIGNED DEFAULT 0,
  `total_emails` int(10) UNSIGNED DEFAULT 0,
  `status` varchar(16) DEFAULT NULL,
  `views` bigint(20) UNSIGNED DEFAULT 0,
  `clicks` bigint(20) UNSIGNED DEFAULT 0,
  `last_sent_email_datetime` datetime DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `broadcasts_statistics`
--

CREATE TABLE `broadcasts_statistics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `broadcast_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(16) DEFAULT NULL,
  `target` varchar(2048) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `domains` (
  `domain_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `scheme` varchar(8) NOT NULL DEFAULT '',
  `host` varchar(128) NOT NULL DEFAULT '',
  `custom_index_url` varchar(256) DEFAULT NULL,
  `custom_not_found_url` varchar(256) DEFAULT NULL,
  `type` tinyint(4) DEFAULT 1,
  `is_enabled` tinyint(4) DEFAULT 0,
  `datetime` datetime DEFAULT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `domains`
--

INSERT INTO `domains` (`domain_id`, `user_id`, `scheme`, `host`, `custom_index_url`, `custom_not_found_url`, `type`, `is_enabled`, `datetime`, `last_datetime`) VALUES
(1, 1, 'https://', 'gatot.tech', 'https://gatot.tech', '', 0, 0, '2024-10-12 13:15:52', NULL);

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

--
-- Table structure for table `internal_notifications`
--

CREATE TABLE `internal_notifications` (
  `internal_notification_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `for_who` varchar(16) DEFAULT NULL,
  `from_who` varchar(16) DEFAULT NULL,
  `icon` varchar(64) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `description` varchar(1024) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `is_read` tinyint(3) UNSIGNED DEFAULT 0,
  `datetime` datetime DEFAULT NULL,
  `read_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `links` (
  `link_id` bigint(20) UNSIGNED NOT NULL,
  `domain_id` bigint(20) UNSIGNED DEFAULT NULL,
  `project_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `pixels_ids` text DEFAULT NULL,
  `url` varchar(128) DEFAULT NULL,
  `location_url` varchar(2048) DEFAULT NULL,
  `settings` text DEFAULT NULL,
  `pageviews` bigint(20) UNSIGNED DEFAULT 0,
  `is_enabled` tinyint(3) UNSIGNED DEFAULT 1,
  `last_datetime` datetime DEFAULT NULL,
  `datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `links`
--

INSERT INTO `links` (`link_id`, `domain_id`, `project_id`, `user_id`, `pixels_ids`, `url`, `location_url`, `settings`, `pageviews`, `is_enabled`, `last_datetime`, `datetime`) VALUES
(3, NULL, NULL, 1, '[]', 'xampp', 'https://drive.google.com/drive/folders/1keSAZ78wyR8cn9IeNOhFQieUwm5HryLY?usp=sharing', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 69, 1, NULL, '2024-11-19 23:03:59'),
(4, NULL, NULL, 1, '[]', 'pertamax', 'https://drive.google.com/file/d/1-eEkn24WFchxy12sTO1SQfncLUVRvML3/view?usp=drivesdk', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 9, 1, NULL, '2024-11-23 11:53:18'),
(5, NULL, NULL, 1, '[]', 'skripsi', 'https://drive.google.com/drive/folders/1bWrHXA4rgB-mYJ8XIeqZV7Ct1cCkKEeC?usp=sharing', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 58, 1, NULL, '2024-11-25 08:44:27'),
(6, NULL, NULL, 1, '[]', 'bpjs', 'https://drive.google.com/drive/folders/1XVhb39b8UX_6_3Rpwc7ONBYWYxn86AyB?usp=sharing', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 1, 1, NULL, '2024-11-28 03:05:10'),
(7, NULL, NULL, 1, '[]', 'data_keluarga', 'https://drive.google.com/drive/folders/1MGXRlo9clFg3Mew72_dlfd6158scRnb-?usp=sharing', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 7, 1, NULL, '2024-11-28 03:08:45'),
(8, NULL, NULL, 1, '[]', 'penelitian_baru', 'https://drive.google.com/drive/folders/1ipPHwpirExnM9ZmeZCyiokf-QsCtsN4Y?usp=sharing', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 52, 1, NULL, '2024-12-02 00:04:38'),
(9, NULL, NULL, 1, '[]', 'view_detail', 'https://drive.google.com/drive/folders/1QgmHYT126xxyBjauCf36VgB3ogzmP25a?usp=sharing', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 30, 1, NULL, '2024-12-18 02:28:03'),
(10, NULL, NULL, 1, '[]', 'bkd_gatot', 'https://drive.google.com/drive/folders/1iKp22BcLPLTQeOEqYxE_bgvnzouubPg5?usp=sharing', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 5, 1, NULL, '2025-02-04 23:37:00'),
(11, NULL, NULL, 1, '[]', 'qr_excel', 'https://docs.google.com/spreadsheets/d/1TZTOYpv4ObIPXwv6Zi_NnPf5wEqIZQgg/edit?usp=sharing&ouid=103166945903351492436&rtpof=true&sd=true', '{\"app_linking_is_enabled\":false,\"app_linking\":[],\"cloaking_is_enabled\":false,\"cloaking_title\":null,\"cloaking_favicon\":null,\"cloaking_opengraph\":null,\"http_status_code\":301,\"schedule\":null,\"start_date\":null,\"end_date\":null,\"pageviews_limit\":null,\"expiration_url\":null,\"password\":null,\"targeting_type\":null,\"forward_query_parameters_is_enabled\":null}', 11, 1, NULL, '2025-02-07 00:06:41');

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

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

CREATE TABLE `pages` (
  `page_id` bigint(20) UNSIGNED NOT NULL,
  `pages_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `url` varchar(256) NOT NULL,
  `title` varchar(256) NOT NULL DEFAULT '',
  `description` varchar(256) DEFAULT NULL,
  `icon` varchar(32) DEFAULT NULL,
  `keywords` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `editor` varchar(16) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `type` varchar(16) DEFAULT '',
  `position` varchar(16) NOT NULL DEFAULT '',
  `language` varchar(32) DEFAULT NULL,
  `open_in_new_tab` tinyint(4) DEFAULT 1,
  `order` int(11) DEFAULT 0,
  `total_views` bigint(20) UNSIGNED DEFAULT 0,
  `is_published` tinyint(4) DEFAULT 1,
  `datetime` datetime DEFAULT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pages_categories`
--

CREATE TABLE `pages_categories` (
  `pages_category_id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(256) NOT NULL,
  `title` varchar(256) NOT NULL DEFAULT '',
  `description` varchar(256) DEFAULT NULL,
  `icon` varchar(32) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `language` varchar(32) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `pixels`
--

CREATE TABLE `pixels` (
  `pixel_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(64) NOT NULL,
  `name` varchar(64) NOT NULL,
  `pixel` varchar(64) NOT NULL,
  `last_datetime` datetime DEFAULT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `plans` (
  `plan_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `description` varchar(256) NOT NULL DEFAULT '',
  `translations` text NOT NULL,
  `prices` text NOT NULL,
  `trial_days` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `settings` longtext NOT NULL,
  `taxes_ids` text DEFAULT NULL,
  `color` varchar(16) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `order` int(10) UNSIGNED DEFAULT 0,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `plans` (`plan_id`, `name`, `description`, `translations`, `prices`, `trial_days`, `settings`, `taxes_ids`, `color`, `status`, `order`, `datetime`) VALUES
(1, 'Karyawan', '', '{\"english\":{\"name\":\"\",\"description\":\"\"}}', '{\"monthly\":{\"USD\":0},\"annual\":{\"USD\":0},\"lifetime\":{\"USD\":0}}', 0, '{\"url_minimum_characters\":1,\"url_maximum_characters\":64,\"qr_codes_limit\":1,\"qr_codes_bulk_limit\":0,\"barcodes_limit\":1,\"barcodes_bulk_limit\":0,\"links_limit\":1,\"projects_limit\":1,\"pixels_limit\":1,\"domains_limit\":0,\"teams_limit\":0,\"team_members_limit\":0,\"statistics_retention\":0,\"additional_domains\":[],\"analytics_is_enabled\":false,\"custom_url_is_enabled\":false,\"utm_parameters_is_enabled\":false,\"password_protection_is_enabled\":false,\"sensitive_content_is_enabled\":false,\"cloaking_is_enabled\":false,\"app_linking_is_enabled\":false,\"api_is_enabled\":false,\"affiliate_commission_percentage\":0,\"no_ads\":false,\"removable_branding\":false,\"qr_reader_is_enabled\":false,\"barcode_reader_is_enabled\":false,\"enabled_qr_codes\":{\"text\":true,\"url\":true,\"phone\":false,\"sms\":false,\"email\":false,\"whatsapp\":false,\"facetime\":false,\"location\":false,\"wifi\":false,\"event\":false,\"vcard\":false,\"crypto\":false,\"paypal\":false,\"upi\":false,\"epc\":false,\"pix\":false},\"enabled_barcodes\":{\"C32\":false,\"C39\":false,\"C39+\":false,\"C39E\":false,\"C39E+\":false,\"C93\":false,\"S25\":false,\"S25+\":false,\"I25\":false,\"I25+\":false,\"ITF14\":false,\"C128\":false,\"C128A\":false,\"C128B\":false,\"C128C\":false,\"EAN2\":false,\"EAN5\":false,\"EAN8\":false,\"EAN13\":false,\"UPCA\":false,\"UPCE\":false,\"MSI\":false,\"MSI+\":false,\"POSTNET\":false,\"PLANET\":false,\"TELEPENALPHA\":false,\"TELEPENNUMERIC\":false,\"RMS4CC\":false,\"KIX\":false,\"IMB\":false,\"CODABAR\":false,\"CODE11\":false,\"PHARMA\":false,\"PHARMA2T\":false}}', '[]', NULL, 1, 0, '2024-10-11 21:30:25');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `color` varchar(16) DEFAULT '#000',
  `last_datetime` datetime DEFAULT NULL,
  `datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`project_id`, `user_id`, `name`, `color`, `last_datetime`, `datetime`) VALUES
(1, 1, 'Surat-Menyurat', '#0810B3', NULL, '2024-10-11 02:04:00'),
(2, 1, 'Soal UTS', '#E14E0F', NULL, '2024-10-12 13:18:41'),
(3, 1, 'Soal UAS', '#28BF16', NULL, '2024-10-12 13:18:59'),
(4, 1, 'Surat Penting', '#CD219D', NULL, '2024-10-12 13:19:27'),
(5, 2, 'Surat', '#1258C3', NULL, '2024-11-01 15:16:53'),
(6, 4, 'Surat', '#0C0AB6', NULL, '2024-11-05 03:36:46'),
(7, 3, 'Surat', '#0F1EC8', NULL, '2024-11-05 03:37:37'),
(8, 5, 'Surat', '#1258C3', NULL, '2024-10-11 02:04:00'),
(9, 6, 'Surat', '#1258C3', NULL, '2024-10-12 13:18:41'),
(10, 7, 'Surat', '#1258C3', NULL, '2024-10-12 13:18:59'),
(11, 8, 'Surat', '#1258C3', NULL, '2024-10-12 13:19:27'),
(12, 9, 'Surat', '#1258C3', NULL, '2024-11-01 15:16:53'),
(13, 10, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(14, 11, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(15, 12, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(16, 13, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(17, 14, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(18, 15, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(19, 16, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(20, 17, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(21, 18, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(22, 19, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(23, 20, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(24, 21, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(25, 22, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(26, 23, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(27, 24, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(28, 25, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(29, 26, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(30, 27, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(31, 28, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(32, 29, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(33, 30, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(34, 31, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(35, 32, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46'),
(36, 33, 'Surat', '#1258C3', NULL, '2024-11-05 03:37:37'),
(37, 34, 'Surat', '#1258C3', NULL, '2024-11-05 03:36:46');

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

--
-- Table structure for table `qr_codes`
--

CREATE TABLE `qr_codes` (
  `qr_code_id` bigint(20) UNSIGNED NOT NULL,
  `link_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(64) NOT NULL,
  `type` varchar(32) DEFAULT NULL,
  `qr_code_logo` varchar(40) DEFAULT NULL,
  `qr_code_background` varchar(40) DEFAULT NULL,
  `qr_code_foreground` varchar(40) DEFAULT NULL,
  `qr_code` varchar(40) NOT NULL,
  `settings` text DEFAULT NULL,
  `embedded_data` text DEFAULT NULL,
  `datetime` datetime NOT NULL,
  `last_datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qr_codes`
--

INSERT INTO `qr_codes` (`qr_code_id`, `link_id`, `user_id`, `project_id`, `name`, `type`, `qr_code_logo`, `qr_code_background`, `qr_code_foreground`, `qr_code`, `settings`, `embedded_data`, `datetime`, `last_datetime`) VALUES
(5, NULL, 1, 1, 'Lldikti', 'url', NULL, NULL, NULL, '8670977f5f9309d236f043ec2f185a4d.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"https:\\/\\/layanan-empat.lldikti4.id\\/public\\/esign\\/detail\\/12901\"}', 'https://layanan-empat.lldikti4.id/public/esign/detail/12901', '2024-10-24 10:59:10', NULL),
(6, NULL, 2, 5, 'Gatot', 'url', NULL, NULL, NULL, 'bcaf27b3f7defecb43b11209c74a0a95.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"https:\\/\\/arsip.gasa.blog\\/index.php\\/home\\/view\\/159\"}', 'https://arsip.gasa.blog/index.php/home/view/159', '2024-11-01 15:28:28', NULL),
(8, NULL, 2, 5, 'Gatot', 'url', NULL, NULL, NULL, 'a129f498cd36543af740a5eb06ccc01c.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"https:\\/\\/arsip.gasa.blog\\/index.php\\/home\\/view\\/168\"}', 'https://arsip.gasa.blog/index.php/home/view/168', '2024-11-02 04:03:54', NULL),
(9, NULL, 2, 5, 'Gatot', 'url', NULL, NULL, NULL, '5700610fca203dad3011e11148afa3db.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"https:\\/\\/publikasi.dinus.ac.id\\/index.php\\/jais\\/article\\/view\\/11027\"}', 'https://publikasi.dinus.ac.id/index.php/jais/article/view/11027', '2024-11-02 04:57:45', NULL),
(11, NULL, 2, 5, 'PAK Gatot', 'url', NULL, NULL, NULL, '6003ece8eb7a544ac5a584273a9b7388.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"https:\\/\\/arsip.gasa.blog\\/index.php\\/home\\/view\\/169\"}', 'https://arsip.gasa.blog/index.php/home/view/169', '2024-11-05 06:52:28', NULL),
(12, NULL, 3, 7, 'Surat Undangan', 'url', NULL, NULL, NULL, 'be6aad4d508fb6027b686d2348caafa5.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"https:\\/\\/arsip.gasa.blog\\/index.php\\/home\\/view\\/170\"}', 'https://arsip.gasa.blog/index.php/home/view/170', '2024-11-06 03:19:20', NULL),
(13, NULL, 18, 21, 'gadagjkdgjkd', 'url', NULL, NULL, NULL, 'b3f2c38e5a22687963ee096abb9b35ce.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"https:\\/\\/arsip.gasa.blog\\/index.php\\/home\\/view\\/171\"}', 'https://arsip.gasa.blog/index.php/home/view/171', '2024-11-06 04:01:51', NULL),
(14, NULL, 7, 10, 'Kemahasiswaan', 'url', NULL, NULL, NULL, 'c32086fab17accbd2cd79f20598610f8.svg', '{\"style\":\"square\",\"inner_eye_style\":\"square\",\"outer_eye_style\":\"square\",\"foreground_type\":\"color\",\"qr_code_background_transparency\":0,\"qr_code_foreground_transparency\":0,\"frame\":null,\"frame_text\":\"\",\"frame_text_size\":0,\"frame_text_font\":\"times_new_roman\",\"frame_custom_colors\":0,\"frame_color\":\"#000000\",\"frame_text_color\":\"#ffffff\",\"foreground_color\":\"#00008B\",\"background_color\":\"#ffffff\",\"background_color_transparency\":0,\"custom_eyes_color\":0,\"qr_code_logo_size\":25,\"size\":500,\"margin\":0,\"ecc\":\"M\",\"encoding\":\"UTF-8\",\"is_readable\":1,\"url\":\"http:\\/\\/arsip.gasa.blog\\/index.php\\/home\\/view\\/172\"}', 'http://arsip.gasa.blog/index.php/home/view/172', '2024-11-07 00:51:33', NULL);

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

--
-- Table structure for table `statistics`
--

CREATE TABLE `statistics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `link_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `country_code` varchar(8) DEFAULT NULL,
  `os_name` varchar(16) DEFAULT NULL,
  `city_name` varchar(128) DEFAULT NULL,
  `browser_name` varchar(32) DEFAULT NULL,
  `referrer_host` varchar(256) DEFAULT NULL,
  `referrer_path` varchar(1024) DEFAULT NULL,
  `device_type` varchar(16) DEFAULT NULL,
  `browser_language` varchar(16) DEFAULT NULL,
  `utm_source` varchar(128) DEFAULT NULL,
  `utm_medium` varchar(128) DEFAULT NULL,
  `utm_campaign` varchar(128) DEFAULT NULL,
  `is_unique` tinyint(4) DEFAULT 0,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statistics`
--

INSERT INTO `statistics` (`id`, `link_id`, `user_id`, `country_code`, `os_name`, `city_name`, `browser_name`, `referrer_host`, `referrer_path`, `device_type`, `browser_language`, `utm_source`, `utm_medium`, `utm_campaign`, `is_unique`, `datetime`) VALUES
(3, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', 'qr.gasa.blog', '/link-update/3', 'desktop', 'en', '', '', '', 1, '2024-11-19 23:04:15'),
(4, 3, 1, 'ID', 'Android', 'Depok', 'Vivo Browser', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-11-19 23:31:50'),
(5, 3, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-11-19 23:52:23'),
(6, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-19 23:54:10'),
(7, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 00:37:24'),
(8, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 00:50:28'),
(9, 3, 1, 'ID', 'Android', 'Bekasi', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-11-20 00:51:40'),
(10, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 00:51:50'),
(11, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 00:55:27'),
(12, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 00:56:20'),
(13, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 01:03:19'),
(14, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2024-11-20 01:04:21'),
(15, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2024-11-20 01:07:00'),
(16, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:07:10'),
(17, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 01:08:27'),
(18, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2024-11-20 01:08:28'),
(19, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:08:30'),
(20, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2024-11-20 01:08:39'),
(21, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 01:09:47'),
(22, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 01:10:13'),
(23, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:10:19'),
(24, 3, 1, 'ID', 'Windows', 'Jakarta', 'Firefox', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 01:10:28'),
(25, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:11'),
(26, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:11'),
(27, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:11'),
(28, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:11'),
(29, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:11'),
(30, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:11'),
(31, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:11'),
(32, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:12'),
(33, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:12'),
(34, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:12'),
(35, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:12'),
(36, 3, 1, 'ID', 'Windows', 'Bekasi', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:11:13'),
(37, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 01:11:34'),
(38, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 01:11:34'),
(39, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 01:12:38'),
(40, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 01:12:38'),
(41, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 01:14:39'),
(42, 3, 1, 'ID', 'Android', 'Jakarta', 'Vivo Browser', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-11-20 01:19:50'),
(43, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 01:20:40'),
(44, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-11-20 01:21:02'),
(45, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-20 01:30:56'),
(46, 3, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-20 01:31:11'),
(47, 3, 1, 'ID', 'Windows', 'Bogor', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-23 00:19:36'),
(48, 3, 1, 'ID', 'OS X', 'Bogor', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-23 01:03:19'),
(49, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-23 01:11:29'),
(50, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-23 01:26:43'),
(51, 4, 1, 'ID', 'Android', 'Bogor', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-11-23 11:56:33'),
(52, 4, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', 'qr.gasa.blog', '/link-statistics/4', 'mobile', 'id', '', '', '', 1, '2024-11-25 01:35:32'),
(53, 5, 1, 'ID', NULL, 'Jakarta', 'WhatsApp', NULL, NULL, 'desktop', 'in', '', '', '', 1, '2024-11-25 08:44:48'),
(54, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-11-25 09:18:41'),
(55, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2024-11-26 02:00:18'),
(56, 3, 1, 'ID', 'Windows', NULL, 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-11-28 03:05:25'),
(57, 6, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-11-28 03:09:40'),
(58, 7, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-11-28 03:10:05'),
(59, 5, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-11-30 08:04:24'),
(60, 5, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2024-11-30 08:06:17'),
(61, 5, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2024-11-30 08:10:07'),
(62, 4, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-01 00:13:19'),
(63, 8, 1, 'ID', NULL, 'Jakarta', 'WhatsApp', NULL, NULL, 'desktop', 'in', '', '', '', 1, '2024-12-02 00:05:39'),
(64, 8, 1, 'US', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-02 00:32:37'),
(65, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-02 01:01:21'),
(66, 5, 1, 'ID', 'Android', 'Jakarta', 'MIUI Browser', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-02 02:25:53'),
(67, 8, 1, 'ID', 'Android', 'Jakarta', 'MIUI Browser', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-02 02:26:09'),
(68, 8, 1, 'ID', 'Linux', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-02 04:01:41'),
(69, 5, 1, 'ID', 'Linux', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-02 04:05:40'),
(70, 8, 1, 'ID', 'Windows', NULL, 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-02 06:22:08'),
(71, 3, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-04 08:28:35'),
(72, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-04 09:04:18'),
(73, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-04 09:04:36'),
(74, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2024-12-04 09:26:46'),
(75, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-08 11:28:57'),
(76, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-09 14:31:42'),
(77, 3, 1, 'ID', 'OS X', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-11 02:20:05'),
(78, 9, 1, 'ID', NULL, 'Pecenongan', 'WhatsApp', NULL, NULL, 'desktop', 'in', '', '', '', 1, '2024-12-18 02:29:24'),
(79, 9, 1, 'ID', 'iOS', 'Jakarta', 'Safari', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:29:38'),
(80, 9, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-18 02:29:40'),
(81, 9, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:29:42'),
(82, 9, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-18 02:29:42'),
(83, 9, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:29:43'),
(84, 9, 1, 'ID', 'Android', 'Bekasi', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:29:48'),
(85, 9, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-18 02:30:05'),
(86, 9, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-18 02:30:22'),
(87, 9, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-18 02:30:31'),
(88, 9, 1, 'ID', 'Android', 'Bekasi', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:30:33'),
(89, 9, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-12-18 02:31:07'),
(90, 9, 1, 'ID', 'Android', 'Bekasi', 'Vivo Browser', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:33:04'),
(91, 9, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-18 02:36:06'),
(92, 9, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:37:07'),
(93, 9, 1, 'ID', 'Android', 'Palembang', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 02:40:30'),
(94, 9, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-18 02:43:21'),
(95, 9, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 0, '2024-12-18 02:43:42'),
(96, 9, 1, 'ID', 'iOS', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 03:01:25'),
(97, 5, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-18 03:15:31'),
(98, 9, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-18 05:51:41'),
(99, 8, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-18 07:50:11'),
(100, 8, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2024-12-18 07:50:17'),
(101, 8, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2024-12-18 08:20:27'),
(102, 5, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2024-12-18 08:21:19'),
(103, 8, 1, 'ID', 'Android', 'Jakarta', 'Samsung Internet', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-18 10:54:37'),
(104, 8, 1, 'ID', 'Android', 'Jakarta', 'Samsung Internet', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2024-12-18 10:58:53'),
(105, 9, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-19 05:53:26'),
(106, 9, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-19 10:47:21'),
(107, 9, 1, 'ID', 'Windows', 'Bandung', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-20 02:27:21'),
(108, 3, 1, 'ID', 'Windows', 'Bandung', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-20 02:39:47'),
(109, 8, 1, 'ID', 'Android', 'Jakarta', 'MIUI Browser', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2024-12-20 16:36:56'),
(110, 3, 1, 'ID', 'Windows', NULL, 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-21 05:16:49'),
(111, 3, 1, 'ID', 'Windows', NULL, 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-12-21 05:16:50'),
(112, 9, 1, 'ID', 'Windows', NULL, 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-21 05:35:15'),
(113, 3, 1, 'ID', 'Windows', 'South Tangerang', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-21 10:42:16'),
(114, 9, 1, 'ID', 'Android', 'Bogor', 'Samsung Internet', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-23 13:31:37'),
(115, 9, 1, 'ID', 'Windows', 'Bogor', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-23 13:38:12'),
(116, 4, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2024-12-24 23:49:11'),
(117, 3, 1, 'ID', 'Windows', 'Depok', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-25 04:31:06'),
(118, 3, 1, 'ID', 'Windows', 'Depok', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2024-12-25 04:33:14'),
(119, 3, 1, 'ID', 'Windows', 'South Tangerang', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2024-12-26 06:59:38'),
(120, 3, 1, 'ID', 'Windows', 'Palembang', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-27 03:06:33'),
(121, 9, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2024-12-30 12:16:41'),
(122, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-02 07:52:17'),
(123, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-02 07:54:03'),
(124, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-05 09:17:09'),
(125, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-07 03:17:07'),
(126, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-07 03:17:15'),
(127, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-07 03:33:27'),
(128, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-07 04:45:51'),
(129, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-07 04:51:24'),
(130, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-07 04:51:39'),
(131, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-07 04:51:50'),
(132, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-07 06:06:56'),
(133, 9, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-01-07 13:55:28'),
(134, 9, 1, 'ID', 'iOS', NULL, 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-01-08 00:36:57'),
(135, 5, 1, 'ID', 'Android', 'Bekasi', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-01-08 04:25:04'),
(136, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-08 04:43:43'),
(137, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-08 04:56:09'),
(138, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-08 04:56:28'),
(139, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-08 04:58:45'),
(140, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-08 04:58:46'),
(141, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-08 04:59:10'),
(142, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-08 04:59:22'),
(143, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-08 05:54:45'),
(144, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-08 06:08:31'),
(145, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-08 06:15:51'),
(146, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-08 06:15:56'),
(147, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-01-08 06:27:12'),
(148, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-01-08 06:35:35'),
(149, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-08 06:42:34'),
(150, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-08 08:35:24'),
(151, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-01-08 08:53:39'),
(152, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2025-01-08 08:54:22'),
(153, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-08 10:51:14'),
(154, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-08 13:38:47'),
(155, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-08 13:57:40'),
(156, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-08 14:14:04'),
(157, 8, 1, 'ID', 'Android', 'Jakarta', 'Samsung Internet', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-01-08 23:22:44'),
(158, 8, 1, 'ID', 'Windows', NULL, 'Edge', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-09 01:22:46'),
(159, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-10 06:08:34'),
(160, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-10 06:21:41'),
(161, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-10 08:58:25'),
(162, 3, 1, 'ID', NULL, 'Jakarta', 'WhatsApp', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-11 04:10:31'),
(163, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-11 04:10:39'),
(164, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-11 04:41:23'),
(165, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-01-11 06:49:52'),
(166, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-01-11 06:56:06'),
(167, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2025-01-11 07:04:02'),
(168, 3, 1, 'ID', 'OS X', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-11 07:05:50'),
(169, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-12 14:11:54'),
(170, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-12 15:14:50'),
(171, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-13 08:02:12'),
(172, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-01-13 13:39:57'),
(173, 3, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-01-13 13:44:36'),
(174, 3, 1, 'ID', 'Windows', 'Jakarta', 'Firefox', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-14 14:51:38'),
(175, 7, 1, 'ID', NULL, 'Jakarta', 'WhatsApp', NULL, NULL, 'desktop', 'in', '', '', '', 1, '2025-01-17 05:36:19'),
(176, 7, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-01-17 05:36:26'),
(177, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-01-23 16:33:20'),
(178, 9, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-04 23:35:43'),
(179, 10, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-04 23:37:18'),
(180, 10, 1, 'ID', 'Android', 'Bekasi', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-02-04 23:57:52'),
(181, 11, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-07 00:06:52'),
(182, 11, 1, 'ID', NULL, 'Bekasi', 'WhatsApp', NULL, NULL, 'desktop', 'in', '', '', '', 1, '2025-02-07 00:07:44'),
(183, 11, 1, 'ID', 'iOS', 'Bekasi', 'Safari', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-02-07 00:38:58'),
(184, 11, 1, 'ID', 'iOS', 'Bekasi', 'Safari', NULL, NULL, 'mobile', 'id', '', '', '', 0, '2025-02-07 01:06:29'),
(185, 11, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-02-07 01:17:12'),
(186, 11, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2025-02-07 01:17:59'),
(187, 11, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-07 01:18:18'),
(188, 11, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-02-10 03:50:24'),
(189, 11, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-11 02:59:30'),
(190, 10, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-02-11 03:41:07'),
(191, 7, 1, 'ID', 'Android', NULL, 'MIUI Browser', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-02-16 07:20:21'),
(192, 4, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-02-16 07:23:49'),
(193, 4, 1, 'ID', 'Android', NULL, 'MIUI Browser', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-02-16 07:31:37'),
(194, 7, 1, 'ID', 'Android', NULL, 'MIUI Browser', NULL, NULL, 'mobile', 'id', '', '', '', 0, '2025-02-16 07:31:37'),
(195, 7, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-02-16 20:53:54'),
(196, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-02-18 05:21:35'),
(197, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-02-18 05:22:06'),
(198, 5, 1, 'ID', 'Windows', 'Jakarta', 'Edge', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-18 07:11:08'),
(199, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2025-02-18 07:12:30'),
(200, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2025-02-18 07:12:52'),
(201, 5, 1, 'ID', 'Windows', 'Jakarta', 'Edge', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-02-18 07:12:54'),
(202, 8, 1, 'ID', 'Windows', 'Jakarta', 'Edge', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-18 07:15:17'),
(203, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-02-18 07:25:16'),
(204, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-02-19 05:37:19'),
(205, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-02-19 05:38:59'),
(206, 5, 1, 'ID', 'Windows', 'Jakarta', 'Edge', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-02-19 07:08:08'),
(207, 8, 1, 'ID', 'Windows', 'Jakarta', 'Edge', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-19 13:50:34'),
(208, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-24 08:53:31'),
(209, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-02-24 08:53:55'),
(210, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-02-25 07:14:01'),
(211, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-02-25 07:14:10'),
(212, 5, 1, 'ID', 'Android', 'Jakarta', 'MIUI Browser', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-02-25 08:18:30'),
(213, 5, 1, 'ID', 'Android', 'Pecenongan', 'MIUI Browser', NULL, NULL, 'mobile', 'id', '', '', '', 0, '2025-02-25 08:19:16'),
(214, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-02-26 14:16:41'),
(215, 8, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2025-02-26 14:17:14'),
(216, 4, 1, 'ID', 'Android', 'Depok', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-03-03 23:15:20'),
(217, 5, 1, 'ID', 'Android', 'Jakarta', 'Samsung Internet', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-03-04 14:30:36'),
(218, 8, 1, 'ID', 'Android', 'Jakarta', 'Samsung Internet', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-03-04 14:30:43'),
(219, 8, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-03-05 03:03:34'),
(220, 8, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 0, '2025-03-05 03:06:21'),
(221, 8, 1, 'ID', 'Android', NULL, 'Chrome', NULL, NULL, 'mobile', 'en', '', '', '', 1, '2025-03-07 03:47:49'),
(222, 4, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-03-23 00:36:15'),
(223, 7, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', 'qr.gasa.blog', '/link-update/7', 'desktop', 'id', '', '', '', 1, '2025-04-10 06:44:31'),
(224, 10, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-04-11 02:12:10'),
(225, 10, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-04-11 07:35:05'),
(226, 4, 1, 'ID', 'Android', 'Pecenongan', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-04-13 00:47:45'),
(227, 11, 1, 'ID', NULL, 'Jakarta', 'WhatsApp', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-04-17 05:13:39'),
(228, 11, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-04-17 05:16:36'),
(229, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 1, '2025-04-23 03:57:25'),
(230, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 0, '2025-04-23 03:57:37'),
(231, 5, 1, 'ID', 'Android', 'Jakarta', 'Chrome', NULL, NULL, 'mobile', 'id', '', '', '', 0, '2025-04-23 03:57:37'),
(232, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-04-23 04:00:13'),
(233, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-04-23 04:00:13'),
(234, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-04-23 04:01:05'),
(235, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-04-23 04:01:06'),
(236, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-04-23 04:07:07'),
(237, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-04-23 04:07:26'),
(238, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 0, '2025-04-23 04:15:28'),
(239, 8, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-04-23 04:22:50'),
(240, 5, 1, 'ID', 'Windows', 'Jakarta', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-04-23 04:23:01'),
(241, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 0, '2025-04-23 07:59:41'),
(242, 5, 1, 'ID', 'Windows', NULL, 'Chrome', NULL, NULL, 'desktop', 'id', '', '', '', 1, '2025-04-24 03:54:48'),
(243, 5, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-04-28 03:00:12'),
(244, 8, 1, 'ID', 'Windows', 'Bekasi', 'Chrome', NULL, NULL, 'desktop', 'en', '', '', '', 1, '2025-04-28 03:00:13');

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

--
-- Table structure for table `users_logs`
--

CREATE TABLE `users_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `ip` varchar(64) DEFAULT NULL,
  `device_type` varchar(16) DEFAULT NULL,
  `os_name` varchar(16) DEFAULT NULL,
  `continent_code` varchar(8) DEFAULT NULL,
  `country_code` varchar(8) DEFAULT NULL,
  `city_name` varchar(32) DEFAULT NULL,
  `browser_language` varchar(32) DEFAULT NULL,
  `browser_name` varchar(32) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users_logs`
--

INSERT INTO `users_logs` (`id`, `user_id`, `type`, `ip`, `device_type`, `os_name`, `continent_code`, `country_code`, `city_name`, `browser_language`, `browser_name`, `datetime`) VALUES
(1, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 01:49:16'),
(2, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 02:01:56'),
(3, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 02:03:20'),
(4, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 02:13:43'),
(5, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 06:17:26'),
(6, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 07:24:49'),
(7, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 07:36:11'),
(8, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 08:15:23'),
(9, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 08:17:35'),
(10, 1, 'login.wrong_password', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 08:18:08'),
(11, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 08:18:14'),
(12, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 08:31:53'),
(13, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-11 08:35:44'),
(14, 1, 'login.wrong_password', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:26:59'),
(15, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:27:11'),
(16, 2, 'register.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:29:26'),
(17, 2, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:30:16'),
(18, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:30:53'),
(19, 2, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:33:29'),
(20, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:34:55'),
(21, 2, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:37:15'),
(22, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:37:52'),
(23, 2, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:42:11'),
(24, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:44:00'),
(25, 2, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:46:47'),
(26, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:47:29'),
(27, 2, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:47:57'),
(28, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:49:43'),
(29, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:56:57'),
(30, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:58:33'),
(31, 2, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 20:59:25'),
(32, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 21:19:57'),
(33, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-11 21:21:43'),
(34, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Windows', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-12 01:37:42'),
(35, 1, 'login.default.success', '180.252.80.99', 'desktop', 'Windows', 'AS', 'ID', 'Depok', NULL, NULL, '2024-10-12 01:46:27'),
(36, 2, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 04:04:40'),
(37, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 04:05:34'),
(38, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 05:24:14'),
(39, 1, 'login.wrong_password', '180.252.218.114', 'mobile', 'Android', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 05:30:00'),
(40, 1, 'login.default.success', '180.252.218.114', 'mobile', 'Android', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 05:30:09'),
(41, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 05:46:43'),
(42, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 07:05:15'),
(43, 1, 'login.default.success', '180.252.218.114', 'mobile', 'Android', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 07:06:52'),
(44, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Linux', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 07:26:02'),
(45, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 08:29:00'),
(46, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Linux', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 13:10:47'),
(47, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Linux', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 13:12:03'),
(48, 2, 'login.default.success', '180.252.218.114', 'desktop', 'Linux', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 13:12:48'),
(49, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Linux', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 13:14:56'),
(50, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Linux', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-12 13:24:48'),
(51, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-15 03:13:40'),
(52, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Linux', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-15 03:19:14'),
(53, 1, 'login.default.success', '2400:9800:131:570b:1:0:5494:a19e', 'mobile', 'Android', 'AS', 'ID', 'Pecenongan', NULL, NULL, '2024-10-17 05:27:38'),
(54, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-17 08:58:41'),
(55, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-19 00:31:38'),
(56, 2, 'login.default.success', '180.252.218.114', 'desktop', 'Linux', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-19 05:16:16'),
(57, 1, 'login.default.success', '2400:9800:4d1:9f32:1:0:81e4:4726', 'mobile', 'Android', 'AS', 'ID', NULL, NULL, NULL, '2024-10-20 05:06:19'),
(58, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-20 09:38:47'),
(59, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-20 10:08:17'),
(60, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-20 10:09:11'),
(61, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-20 10:14:50'),
(62, 1, 'login.default.success', '180.252.218.114', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-10-20 10:30:47'),
(63, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-22 07:32:37'),
(64, 2, 'login.wrong_password', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-22 07:35:55'),
(65, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-22 07:36:05'),
(66, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-22 10:10:34'),
(67, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-22 10:26:43'),
(68, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-22 10:32:51'),
(69, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-22 10:47:05'),
(70, 1, 'login.default.success', '2400:9800:1c1:3675:1:0:cfab:bf84', 'mobile', 'Android', 'AS', 'ID', 'Pecenongan', NULL, NULL, '2024-10-24 02:09:26'),
(71, 1, 'login.default.success', '2400:9800:111:eebe:1:0:93b5:6b47', 'mobile', 'Android', 'AS', 'ID', 'Pecenongan', NULL, NULL, '2024-10-24 10:58:34'),
(72, 1, 'login.default.success', '2400:9800:111:eebe:1:0:93b5:6b47', 'mobile', 'Android', 'AS', 'ID', 'Pecenongan', NULL, NULL, '2024-10-24 11:54:35'),
(73, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Linux', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-30 03:54:56'),
(74, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-10-31 03:53:49'),
(75, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Linux', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-01 03:15:04'),
(76, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 13:29:34'),
(77, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 14:46:42'),
(78, 1, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:06:48'),
(79, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:08:32'),
(80, 1, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:09:08'),
(81, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:15:59'),
(82, 1, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:17:20'),
(83, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:18:27'),
(84, 1, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:20:32'),
(85, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Linux', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-01 15:23:01'),
(86, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Windows', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 04:03:18'),
(87, 1, 'login.default.success', '180.252.90.69', 'mobile', 'Android', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 04:54:59'),
(88, 2, 'login.wrong_password', '180.252.90.69', 'mobile', 'Android', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 04:55:49'),
(89, 2, 'login.default.success', '180.252.90.69', 'mobile', 'Android', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 04:55:57'),
(90, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Windows', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 05:47:15'),
(91, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Windows', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 05:49:03'),
(92, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Windows', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 05:51:00'),
(93, 2, 'login.default.success', '180.252.90.69', 'desktop', 'Windows', 'AS', 'ID', 'Depok', NULL, NULL, '2024-11-02 05:56:28'),
(94, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 02:28:55'),
(95, 3, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 02:32:00'),
(96, 4, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 02:33:10'),
(97, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:16:57'),
(98, 5, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:17:44'),
(99, 6, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:18:12'),
(100, 7, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:18:44'),
(101, 8, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:19:11'),
(102, 9, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:20:37'),
(103, 10, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:20:59'),
(104, 11, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:21:29'),
(105, 12, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:21:55'),
(106, 13, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:22:19'),
(107, 14, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:22:46'),
(108, 15, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:23:09'),
(109, 16, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:23:35'),
(110, 17, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:23:56'),
(111, 18, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:24:19'),
(112, 19, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:24:48'),
(113, 20, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:25:11'),
(114, 21, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:25:35'),
(115, 22, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:26:03'),
(116, 23, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:26:40'),
(117, 24, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:27:04'),
(118, 25, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:27:29'),
(119, 26, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:27:54'),
(120, 27, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:28:17'),
(121, 28, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:28:39'),
(122, 29, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:29:04'),
(123, 30, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:29:26'),
(124, 31, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:29:48'),
(125, 32, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:30:13'),
(126, 33, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:30:38'),
(127, 34, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:31:01'),
(128, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:33:32'),
(129, 4, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:34:04'),
(130, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:34:56'),
(131, 4, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:36:28'),
(132, 3, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:37:13'),
(133, 5, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:38:30'),
(134, 5, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:50:45'),
(135, 13, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 03:51:27'),
(136, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 06:41:01'),
(137, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 23:36:54'),
(138, 35, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 23:38:01'),
(139, 36, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 23:38:45'),
(140, 37, 'register.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-05 23:39:18'),
(141, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-06 00:39:07'),
(142, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-06 02:58:20'),
(143, 3, 'login.default.success', '101.255.123.106', 'desktop', 'OS X', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-06 03:15:33'),
(144, 18, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-06 04:01:25'),
(145, 7, 'login.default.success', '182.0.139.206', 'mobile', 'iOS', 'AS', 'ID', 'Jakarta', NULL, NULL, '2024-11-07 00:50:54'),
(146, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-19 23:03:17'),
(147, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-19 23:03:39'),
(148, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-20 06:13:43'),
(149, 2, 'login.default.success', '180.251.181.102', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-11-21 23:50:37'),
(150, 1, 'login.default.success', '180.251.181.102', 'mobile', 'Android', 'AS', 'ID', 'Bogor', NULL, NULL, '2024-11-23 11:52:40'),
(151, 1, 'login.default.success', '2400:9800:100:65f2:1:0:5582:fa26', 'mobile', 'Android', 'AS', 'ID', 'Pecenongan', NULL, NULL, '2024-11-25 01:34:11'),
(152, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-25 08:43:58'),
(153, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-11-28 03:04:24'),
(154, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-12-02 00:04:03'),
(155, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Linux', 'AS', 'ID', 'Bekasi', NULL, NULL, '2024-12-18 02:27:35'),
(156, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2025-02-04 23:31:59'),
(157, 2, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2025-02-04 23:32:49'),
(158, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2025-02-04 23:34:09'),
(159, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2025-02-05 00:31:39'),
(160, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2025-02-07 00:06:07'),
(161, 1, 'login.default.success', '180.251.181.26', 'desktop', 'Windows', 'AS', 'ID', 'Bogor', NULL, NULL, '2025-03-24 06:56:53'),
(162, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2025-04-10 06:30:47'),
(163, 1, 'login.default.success', '101.255.123.106', 'desktop', 'Windows', 'AS', 'ID', 'Bekasi', NULL, NULL, '2025-04-16 23:53:15');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `barcodes`
--
ALTER TABLE `barcodes`
  ADD PRIMARY KEY (`barcode_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`blog_post_id`),
  ADD KEY `blog_post_id_index` (`blog_post_id`),
  ADD KEY `blog_post_url_index` (`url`),
  ADD KEY `blog_posts_category_id` (`blog_posts_category_id`),
  ADD KEY `blog_posts_is_published_index` (`is_published`),
  ADD KEY `blog_posts_language_index` (`language`);

--
-- Indexes for table `blog_posts_categories`
--
ALTER TABLE `blog_posts_categories`
  ADD PRIMARY KEY (`blog_posts_category_id`),
  ADD KEY `url` (`url`),
  ADD KEY `blog_posts_categories_url_language_index` (`url`,`language`);

--
-- Indexes for table `broadcasts`
--
ALTER TABLE `broadcasts`
  ADD PRIMARY KEY (`broadcast_id`);

--
-- Indexes for table `broadcasts_statistics`
--
ALTER TABLE `broadcasts_statistics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `broadcast_id` (`broadcast_id`),
  ADD KEY `broadcasts_statistics_user_id_broadcast_id_type_index` (`broadcast_id`,`user_id`,`type`),
  ADD KEY `broadcasts_statistics_ibfk_1` (`user_id`);

--
-- Indexes for table `domains`
--
ALTER TABLE `domains`
  ADD PRIMARY KEY (`domain_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `domains_host_index` (`host`),
  ADD KEY `domains_type_index` (`type`);

--
-- Indexes for table `internal_notifications`
--
ALTER TABLE `internal_notifications`
  ADD PRIMARY KEY (`internal_notification_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `users_notifications_for_who_idx` (`for_who`) USING BTREE;

--
-- Indexes for table `links`
--
ALTER TABLE `links`
  ADD PRIMARY KEY (`link_id`),
  ADD UNIQUE KEY `link_id` (`link_id`) USING BTREE,
  ADD KEY `user_id` (`user_id`),
  ADD KEY `domain_id` (`domain_id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`),
  ADD KEY `pages_pages_category_id_index` (`pages_category_id`),
  ADD KEY `pages_url_index` (`url`),
  ADD KEY `pages_is_published_index` (`is_published`),
  ADD KEY `pages_language_index` (`language`);

--
-- Indexes for table `pages_categories`
--
ALTER TABLE `pages_categories`
  ADD PRIMARY KEY (`pages_category_id`),
  ADD KEY `url` (`url`),
  ADD KEY `pages_categories_url_language_index` (`url`,`language`);

--
-- Indexes for table `pixels`
--
ALTER TABLE `pixels`
  ADD PRIMARY KEY (`pixel_id`),
  ADD KEY `user_id` (`user_id`);

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

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`project_id`),
  ADD UNIQUE KEY `project_id` (`project_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `qr_codes`
--
ALTER TABLE `qr_codes`
  ADD PRIMARY KEY (`qr_code_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `link_id` (`link_id`);

--
-- Indexes for table `statistics`
--
ALTER TABLE `statistics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `datetime` (`datetime`),
  ADD KEY `link_id` (`link_id`) USING BTREE,
  ADD KEY `statistics_users_user_id_fk` (`user_id`);

--
-- Indexes for table `users_logs`
--
ALTER TABLE `users_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_logs_user_id` (`user_id`),
  ADD KEY `users_logs_ip_type_datetime_index` (`ip`,`type`,`datetime`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `links`
--
ALTER TABLE `links`
  MODIFY `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

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

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

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `plan_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `project_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `qr_codes`
--
ALTER TABLE `qr_codes`
  MODIFY `qr_code_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `barcodes`
--
ALTER TABLE `barcodes`
  ADD CONSTRAINT `barcodes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `barcodes_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD CONSTRAINT `blog_posts_ibfk_1` FOREIGN KEY (`blog_posts_category_id`) REFERENCES `blog_posts_categories` (`blog_posts_category_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `broadcasts_statistics`
--
ALTER TABLE `broadcasts_statistics`
  ADD CONSTRAINT `broadcasts_statistics_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `broadcasts_statistics_ibfk_2` FOREIGN KEY (`broadcast_id`) REFERENCES `broadcasts` (`broadcast_id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

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

--
-- Constraints for table `links`
--
ALTER TABLE `links`
  ADD CONSTRAINT `links_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `links_ibfk_2` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`domain_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `links_ibfk_3` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `pages`
--
ALTER TABLE `pages`
  ADD CONSTRAINT `pages_ibfk_1` FOREIGN KEY (`pages_category_id`) REFERENCES `pages_categories` (`pages_category_id`) ON DELETE SET NULL ON UPDATE CASCADE;

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

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

--
-- Constraints for table `qr_codes`
--
ALTER TABLE `qr_codes`
  ADD CONSTRAINT `qr_codes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `qr_codes_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `qr_codes_ibfk_3` FOREIGN KEY (`link_id`) REFERENCES `links` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `statistics`
--
ALTER TABLE `statistics`
  ADD CONSTRAINT `statistics_ibfk_1` FOREIGN KEY (`link_id`) REFERENCES `links` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `statistics_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

