-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------



-- Dumping database structure for router-os
CREATE DATABASE IF NOT EXISTS `router-os` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `router-os`;

-- Dumping structure for table router-os.mikrotik
CREATE TABLE IF NOT EXISTS `mikrotik` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mikrotik_id` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `profile` varchar(100) DEFAULT NULL,
  `service` varchar(100) DEFAULT NULL,
  `disabled` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table router-os.mikrotik: ~9 rows (approximately)
REPLACE INTO `mikrotik` (`id`, `mikrotik_id`, `name`, `password`, `profile`, `service`, `disabled`, `created_at`) VALUES
	(1, '*53', 'Gibran Satritama', 'Dev1232024', '30 Mbps', 'pppoe', NULL, '2024-11-28 17:50:49'),
	(2, '*54', 'Malvirino Hardian', '!2@3$%^&', '30 Mbps', 'pppoe', NULL, '2024-11-28 17:50:49'),
	(3, '*55', 'Gibran Satritama', 'Dev!@#2024', '30 Mbps', 'pppoe', NULL, '2024-11-29 01:09:41'),
	(4, '*56', 'Fauzi Septiansyah', 'Dev!@#2024', '30 Mbps', 'pppoe', NULL, '2024-11-29 01:09:41'),
	(5, '*57', 'Malvrino', 'Dev!@#2024', '30 Mbps', 'pppoe', NULL, '2024-11-29 01:09:41'),
	(6, '*58', 'Rafli', '!@##$%', '30 Mbps', 'pppoe', NULL, '2024-11-29 01:09:41'),
	(7, '*5B', 'sholeh', '!@#$%', '20 Mbps', 'pppoe', NULL, '2024-11-29 01:09:41'),
	(8, '*5C', 'fauzi', '!@#$%^', '30 Mbps', 'pppoe', NULL, '2024-11-29 01:09:41'),
	(9, '*5E', 'nocadmin', '!@#$%', '20 Mbps', 'pppoe', NULL, '2024-11-29 01:09:41');

-- Dumping structure for table router-os.pop
CREATE TABLE IF NOT EXISTS `pop` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pop_name` varchar(255) DEFAULT NULL,
  `router_ip` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table router-os.pop: ~2 rows (approximately)
REPLACE INTO `pop` (`id`, `pop_name`, `router_ip`, `username`, `password`) VALUES
	(1, 'Cloudlink', '103.113.170.51', 'dev1', 'Dev!@#2024'),
	(2, 'FIBREE', '103.113.170.53', 'dev1', 'Dev!@#2024');

