-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 12, 2026 at 09:54 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `sistem_fail_mainpp`
--

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

--
-- Table structure for table `push_devices`
--

CREATE TABLE `push_devices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `token` varchar(512) NOT NULL,
  `platform` varchar(20) NOT NULL DEFAULT 'unknown',
  `device_name` varchar(120) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `last_seen_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `push_devices`
--

INSERT INTO `push_devices` (`id`, `user_id`, `token`, `platform`, `device_name`, `enabled`, `last_seen_at`, `created_at`, `updated_at`) VALUES
(2, 11, 'c46crE2NTKm4f58dORK3Ey:APA91bGx9UUEWKJ1WJfnfdMNnP2ZU_wfr2oaBrwBsSeSeBRRRFa2vy9d43d9EjbQP53qE3BbJu66k1gpJe1W4GmTGgFFenRzoDrdU-_580MPIaQ3KkxmkkZCo', 'android', 'sdk gphone16k emulator', 0, '2026-08-03 14:34:38', '2026-08-03 14:34:38', '2026-08-03 14:38:54'),
(3, 12, 'c46crE2NTKm4f58dORK3Ey:APA91bGx9UEWKJ1WJfnfdMNnP2ZU_wfr2oaBrwBsSeSeBRRRFa2vy9d43d9EjbQP53qE3BbJu66k1gpJe1W4GmTGgFenRzoDrdU-_580MPIaQ3KkxmkkZCo', 'android', 'android', 1, '2026-08-11 11:40:57', '2026-08-03 14:36:52', '2026-08-11 11:40:57'),
(4, 12, 'eyCijERtSCyiAbSFTL3gNq:APA91bFohxkN1YZim_1sC--E4PBGZw9ksnIqNp_n5BpJmVPZHxtEnXHusPxDEF8ncOJnLZcZfGwJD37tqvwzPLxVAlOFefuIIfTEZPd5VZfK8ktuImBRtnE', 'android', 'android', 0, '2026-08-03 16:43:52', '2026-08-03 15:33:38', '2026-08-11 09:51:50'),
(22, 12, 'eMazgPlVSoa7yhp84bq2dg:APA91bFFgAEgpNc0HeKElANKvXiEYWeVxZk__XeggyQww7Iwu0IRprqUXHnjJAiCHraArE_YwzVg-1wv-YZM3K2-Hjc1jiCDwWZcl69J_maatVMu8vTJIMw', 'android', 'android', 1, '2026-08-10 09:11:08', '2026-08-04 10:51:39', '2026-08-10 09:11:08'),
(38, 12, 'elkCpDIcTpeiOuFqAP5nFs:APA91bF0wjEtqjCwHJvm6bUSCe1Xk37U_1Upgj63tLSnSdC-pGiPwaT2sa307RcKR_sFiXGfwcCIssi-JXmefnOMzj1bQog2DJpby6hyJbFDzeiUi_FsW14', 'android', 'android', 0, '2026-08-04 12:18:06', '2026-08-04 12:05:30', '2026-08-04 12:18:53'),
(155, 1, 'e9b8QNM1RCuxaGhsBLvzB0:APA91bHy_Qh6hFDbwhuhR4M83DFX7fkJ-4_I7hGvsrdRsj2kHG5j6EhfR2AZ3DILYmKwL9pDTaB5NkfBULfwuIhRT4S39gZ4Syq-GuU-yB49ALUlQppdMTk', 'android', 'android', 0, '2026-08-11 09:54:57', '2026-08-11 09:47:46', '2026-08-11 10:13:20'),
(161, 12, 'eUKJIdLFTmKx0ULYWxg8VC:APA91bFgLzZnHG858Z-ZfcwI67LuDBcvjBWlB06_Ho05QRzOrFGY6c3IwbaEndIAYtpNQqWByuOSH937XGsxGgc6VzQOttE4uJ9oecBQk8-AVyi8js0lH-o', 'android', 'android', 0, '2026-08-11 10:30:46', '2026-08-11 10:06:40', '2026-08-12 15:00:59'),
(176, 12, 'eVjZQ7ExTuiLL9I8M_D7eY:APA91bHJf4jccXQsuf-ZVkbctLyg8NkYApYS8C63yTtjAv1N1th5AFSv_Uc6Q6ZCnbKGdxkkl1QFby6Tr53IzkdtURq1o1ZxVZJzithIn0HyiMfNn6drkgg', 'android', 'android', 0, '2026-08-11 10:46:21', '2026-08-11 10:39:09', '2026-08-12 15:01:00'),
(181, 2, 'cJgB8TwVTpuTM6MDYcBvMN:APA91bHOtQdglUUD_O9Ki-xRaJdiS-RvOAejuVgDY3hlHyt9JjkLpd0LxGTxVTLiSqeMohUHX3Tk2q0AYYSE4XbMMwQnvYoqdX1YwjjvAMWgHfpwJ5Zj2QE', 'android', 'android', 0, '2026-08-11 16:21:06', '2026-08-11 11:39:12', '2026-08-12 14:20:34'),
(193, 1, 'fWnb2OTmTDOM58j9pWaONp:APA91bFAwn_dg4vRd8GlzgT8G66-uaGwfYSl_xHkllpteFa2qwIKaorS6yDyyZc7_KTWB5fKD1BbHN7KobhQeZpX-iEVLioNSwKP-t7D5QKVfbVHr3AaPZk', 'android', 'android', 0, '2026-08-11 17:05:08', '2026-08-11 16:53:31', '2026-08-12 14:18:58'),
(199, 1, 'f3beaYcfQwm8tq7pKgjc56:APA91bHggaGMRQ9qQu_W7Jk5bgauQ_ls3-t5Yb8OFzzsK59xVk6ivKHFlYmy6p3e6uTgqrQuxK4MBbqxnht6rbOYcOgKMeyftZVTAlKeIpUmtqROjWhGYYg', 'android', 'android', 0, '2026-08-12 09:53:31', '2026-08-12 09:27:46', '2026-08-12 14:18:59'),
(206, 1, 'dHKhBtiATgiXtn9lx2d2o-:APA91bGiUB9JDYSYnMohpeZvu50WIlqzHitwlI4rOAVvQ3zgMnc9AOAOWt66tBR4pIJBwfxn3ffidqvh94sWEcnc1GvXt-_WJP9492PWuQ33paGDkldxvDM', 'android', 'android', 0, '2026-08-12 10:44:55', '2026-08-12 10:24:48', '2026-08-12 14:19:00'),
(215, 1, 'eQUQPH3ARsGk1VNwO9qtP2:APA91bFGMF1cnBGYwxxNtNq46tuMt8TymHxfHAkZDwrupKEwZiPo17szV43jMq0Hj34dpxf7fMGJ4lhtFwEmlteHAWwJ-HvismG9DpJAmbcACcgJy8sf1hg', 'android', 'android', 0, '2026-08-12 11:02:34', '2026-08-12 10:59:22', '2026-08-12 14:19:01'),
(225, 2, 'elLq_ceTT4a1SVQMadbpzT:APA91bEQOzrhNfcqH_pJse4ZWkHXYnps_CQC1KFIRR3zzbgNB4LRiVs6SLM0bqBxyLa4RJNXm-W_9pqM8fI__zb4W57QrJzLlELsqHrplrhLSpJAytPEoYI', 'android', 'android', 0, '2026-08-12 11:18:05', '2026-08-12 11:12:02', '2026-08-12 14:20:35'),
(233, 1, 'eiSEEnGcQrqWaPq3bOrMed:APA91bF0DIOURA-IP5PjEJk-8Rh-Mbsxflgw-29R4d4Dpx4FsuOfepuGxu9zh1i7VvX7SG9bGJpiGtpM7OMTc4toZXKdeM4WyNqxtLyEO7REex16_nFJKrA', 'android', 'android', 0, '2026-08-12 11:34:09', '2026-08-12 11:32:15', '2026-08-12 14:19:02'),
(237, 1, 'eZ88Ye58RIiZlkyimhl1F1:APA91bHREBkRsF_lvnX1PPAGbO19UWtFFPrqvtP_WOlZNrHA9JIopIFXk9ynFfk-p1cDH2NAlYkr52-sd5xMJBGVTf1bqx4lEwfnvDWpuG8tiyE_prKjQJg', 'android', 'android', 0, '2026-08-12 11:52:52', '2026-08-12 11:50:08', '2026-08-12 14:19:03'),
(245, 2, 'dXpQqfttQf6Zh15zgQzxsj:APA91bEkIZDArN2ViGtTDiJWNgEBrPdzBCK43JrE3edIWjpReIPeI_FqStq9p4xNSJS5jraJJyGsbwR8R5CtvMR0-Wx1rGj1NL70TC69b7CvrRn8AJCRBUg', 'android', 'android', 0, '2026-08-12 12:14:14', '2026-08-12 12:04:50', '2026-08-12 14:20:36'),
(255, 2, 'drncUtlfRPywTpxcuCH62Y:APA91bHT5tvojJLK4foXZjZ8dnjNRNAkj-VDnYcL7R8mRISAmxveaIUqFAetoCWCaT_3irR-JrznrwNVuY858Yj-eXkI5UiZil1xcXkDFbS05zSnK61Yd90', 'android', 'android', 0, '2026-08-12 12:18:06', '2026-08-12 12:18:04', '2026-08-12 14:20:37'),
(257, 2, 'en60bj43T8CfFQKSv4FhWW:APA91bEQwC1-wDsB664jrYNq_u9vBaNRP1IhCxrqGnSztj3ctAZeK46jDgWg1KCBYHNTlGybrNc3aeYd51fgshBFu_FLc3rbC60pIOFBdowavL5mJmAWBlQ', 'android', 'android', 0, '2026-08-12 14:21:11', '2026-08-12 14:18:36', '2026-08-12 15:27:32'),
(263, 1, 'cjZji77lSPeIjswB6W4Nhd:APA91bFK-cqx_tGj6gJAyOfjyd_lh8fP8wWn5r1BuNWNaE2_PMKP_ScujCFNpIT24oxw3KIw-HiXV_S8qaerlmayGawKVrdG3aAP5cmSpDPbtDqc1cApz0c', 'android', 'android', 1, '2026-08-12 15:12:07', '2026-08-12 14:56:36', '2026-08-12 15:12:07'),
(278, 1, 'test_fcm_token_user_1_1786519647', 'android', '', 1, '2026-08-12 15:27:29', '2026-08-12 15:27:29', '2026-08-12 15:27:29'),
(279, 1, 'test_fcm_token_user_1_1786519683', 'android', '', 1, '2026-08-12 15:28:05', '2026-08-12 15:28:05', '2026-08-12 15:28:05');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `push_devices`
--
ALTER TABLE `push_devices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_push_device_token` (`token`),
  ADD KEY `idx_push_devices_user_enabled` (`user_id`,`enabled`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `push_devices`
--
ALTER TABLE `push_devices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=280;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
