-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Waktu pembuatan: 17 Bulan Mei 2026 pada 13.27
-- Versi server: 12.2.2-MariaDB
-- Versi PHP: 8.4.21

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 */;

--
-- Basis data: `olt`
--

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

--
-- Struktur dari tabel `acs_profiles`
--

CREATE TABLE `acs_profiles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `acs_profiles`
--

INSERT INTO `acs_profiles` (`id`, `name`, `url`, `username`, `password`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'GenieACS', 'http://IP:7547', 'acs', 'acspassword', 1, '2026-05-16 17:40:29', '2026-05-16 17:40:29');

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

--
-- Struktur dari tabel `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` varchar(255) NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Struktur dari tabel `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_05_16_162922_create_olts_table', 2),
(5, '2026_05_16_162929_create_onus_table', 2),
(6, '2026_05_17_003754_create_acs_profiles_table', 3),
(7, '2026_05_17_005835_create_script_templates_table', 4);

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

--
-- Struktur dari tabel `olts`
--

CREATE TABLE `olts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `ip` varchar(255) NOT NULL,
  `telnet_username` varchar(255) DEFAULT NULL,
  `telnet_password` varchar(255) DEFAULT NULL,
  `telnet_port` int(11) NOT NULL DEFAULT 23162,
  `snmp_username` varchar(255) DEFAULT NULL,
  `snmp_password` varchar(255) DEFAULT NULL,
  `snmp_port` int(11) NOT NULL DEFAULT 23161,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `onus`
--

CREATE TABLE `onus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `olt_id` bigint(20) UNSIGNED NOT NULL,
  `board` varchar(255) NOT NULL DEFAULT '1',
  `slot` varchar(255) NOT NULL DEFAULT '1',
  `port` varchar(255) NOT NULL,
  `onu_index` varchar(255) NOT NULL,
  `sn` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'ZTE-F609',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `password_reset_tokens`
--

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

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

--
-- Struktur dari tabel `script_templates`
--

CREATE TABLE `script_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `merk` varchar(255) NOT NULL,
  `gpon_onu_script` text NOT NULL,
  `pon_onu_mng_script` text NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `script_templates`
--

INSERT INTO `script_templates` (`id`, `merk`, `gpon_onu_script`, `pon_onu_mng_script`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'Fiberhome', 'tcont 1 name TR069 profile {UP_PROFILE}\r\ntcont 2 name PPPoE profile {UP_PROFILE}\r\ntcont 3 name HOSTPOT profile {UP_PROFILE}\r\ngemport 1 tcont 1\r\ngemport 1 traffic-limit downstream {DOWN_PROFILE}\r\ngemport 2 tcont 2\r\ngemport 2 traffic-limit downstream {DOWN_PROFILE}\r\ngemport 3 tcont 3\r\ngemport 3 traffic-limit downstream {DOWN_PROFILE}\r\nservice-port 1 vport 1 user-vlan 100 vlan 100\r\nservice-port 2 vport 2 user-vlan 301 vlan 301\r\nservice-port 3 vport 3 user-vlan 302 vlan 302', 'service TR069 gemport 1 vlan 100\r\nservice PPPoE gemport 2 vlan 301\r\nservice HOSTPOT gemport 3 vlan 302\r\nvlan port veip_1 mode hybrid def-vlan 100\r\nvlan port veip_1 vlan 100,301,302\r\ntr069-mgmt 1 state unlock\r\ntr069-mgmt 1 acs {ACS_URL} validate basic username {ACS_USER} password {ACS_PASS}', 0, '2026-05-16 18:02:14', '2026-05-17 04:56:44'),
(2, 'Huawei', 'tcont 1 name TR069 {UP_PROFILE}\r\ntcont 2 name PPPoE {UP_PROFILE}\r\ntcont 3 name HOSTPOT {UP_PROFILE}\r\ngemport 1 tcont 1\r\ngemport 1 traffic-limit downstream {DOWN_PROFILE}\r\ngemport 2 tcont 2\r\ngemport 2 traffic-limit downstream {DOWN_PROFILE}\r\ngemport 3 tcont 3\r\ngemport 3 traffic-limit downstream {DOWN_PROFILE}\r\nservice-port 1 vport 1 user-vlan 100 vlan 100\r\nservice-port 2 vport 2 user-vlan 301 vlan 301\r\nservice-port 3 vport 3 user-vlan 302 vlan 302', 'service TR069 gemport 1 vlan 100\r\nservice PPPoE gemport 2 vlan 301\r\nservice HOSTPOT gemport 3 vlan 302\r\ntr069-mgmt 1 state unlock\r\ntr069-mgmt 1 acs {ACS_URL} validate basic username {ACS_USER} password {ACS_PASS}', 0, '2026-05-16 18:36:27', '2026-05-17 05:09:20'),
(3, 'ZTE', 'tcont 1 name TR069 profile {UP_PROFILE}\r\ntcont 2 name PPPoE profile {UP_PROFILE}\r\ntcont 3 name HOSTPOT profile {UP_PROFILE}\r\ngemport 1 tcont 1\r\ngemport 1 traffic-limit downstream {DOWN_PROFILE}\r\ngemport 2 tcont 2\r\ngemport 2 traffic-limit downstream {DOWN_PROFILE}\r\ngemport 3 tcont 3\r\ngemport 3 traffic-limit downstream {DOWN_PROFILE}\r\nservice-port 1 vport 1 user-vlan 100 vlan 100\r\nservice-port 2 vport 2 user-vlan 301 vlan 301\r\nservice-port 3 vport 3 user-vlan 302 vlan 302', 'service TR069 gemport 1 vlan 100\r\nservice PPPoE gemport 2 vlan 301\r\nservice HOSTPOT gemport 3 vlan 302\r\nwan-ip 1 service TR069\r\ntr069-mgmt 1 state unlock\r\ntr069-mgmt 1 acs {ACS_URL} validate basic username {ACS_USER} password {ACS_PASS}', 0, '2026-05-16 18:39:50', '2026-05-17 05:09:42');

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

--
-- Struktur dari tabel `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('SAyRnM7gQNfGqeKbSRq0TdCqye0md5j0GIKLIF6f', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJrNlF4MTQ0eEd0Z1lYT1VYQ1ZFazdFeUNaMzNVM3dlaWRrWnZmaEVyIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvb2x0LnRlc3RcL3NjcmlwdC10ZW1wbGF0ZXMiLCJyb3V0ZSI6InNjcmlwdC10ZW1wbGF0ZXMuaW5kZXgifSwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvb2x0LnRlc3RcL2Rhc2hib2FyZCJ9LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MX0=', 1779024450);

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

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Bery Indo', 'admin@gmail.com', NULL, '$2y$12$ixtuRgq34uEQmJR7xpwE.Ooa7jVHSBWNVzP/gPqSddyi1pZ/y40Lu', NULL, '2026-05-17 06:27:19', '2026-05-17 06:27:19');

--
-- Indeks untuk tabel yang dibuang
--

--
-- Indeks untuk tabel `acs_profiles`
--
ALTER TABLE `acs_profiles`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indeks untuk tabel `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  ADD KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indeks untuk tabel `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `olts`
--
ALTER TABLE `olts`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `onus`
--
ALTER TABLE `onus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `onus_olt_id_foreign` (`olt_id`);

--
-- Indeks untuk tabel `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indeks untuk tabel `script_templates`
--
ALTER TABLE `script_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `acs_profiles`
--
ALTER TABLE `acs_profiles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `olts`
--
ALTER TABLE `olts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `onus`
--
ALTER TABLE `onus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `script_templates`
--
ALTER TABLE `script_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `onus`
--
ALTER TABLE `onus`
  ADD CONSTRAINT `onus_olt_id_foreign` FOREIGN KEY (`olt_id`) REFERENCES `olts` (`id`) ON DELETE CASCADE;
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 */;
