/* Navicat Premium Data Transfer Source Server : MySQL Local Source Server Type : MySQL Source Server Version : 100139 (10.1.39-MariaDB) Source Host : localhost:3306 Source Schema : korem073 Target Server Type : MySQL Target Server Version : 100139 (10.1.39-MariaDB) File Encoding : 65001 Date: 18/06/2024 16:31:34 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for activities -- ---------------------------- DROP TABLE IF EXISTS `activities`; CREATE TABLE `activities` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content_short` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `content_long` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `date` date NULL DEFAULT NULL, `count_view` int NOT NULL DEFAULT 0, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of activities -- ---------------------------- INSERT INTO `activities` VALUES (1, 'Survei Persepsi Kepuasan Pelayanan (SPKP)', 'survei-kepuasan', 'uploads/xxx/kegiatan6.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 1, NULL, 1, '2024-06-14 10:58:57', '2024-06-14 11:01:25', 1, NULL); INSERT INTO `activities` VALUES (2, 'SURVEI PERSEPSI KUALITAS PELAYANAN (SPKP)', 'survei-kualitas', 'uploads/xxx/kegiatan5.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 0, NULL, 1, '2024-06-14 10:58:57', NULL, 1, NULL); INSERT INTO `activities` VALUES (3, 'SURVEI PERSEPSI ANTI KORUPSI', 'survei-anti-korupsi', 'uploads/xxx/kegiatan4.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 1, NULL, 1, '2024-06-14 10:58:57', '2024-06-14 11:01:42', 1, NULL); INSERT INTO `activities` VALUES (4, 'KEGIATAN BIMBINGAN ZONA INTEGRITAS KOREM 073/MAKUTARAMA', 'kegiatan-bimbingan', 'uploads/xxx/kegiatan3.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 0, NULL, 1, '2024-06-14 10:58:57', NULL, 1, NULL); INSERT INTO `activities` VALUES (5, 'Prajurit Korem 073/MKT Terima Bimbingan Teknis Pembangunan Zona Integritas', 'prajurit-korem', 'uploads/xxx/kegiatan2.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 0, NULL, 1, '2024-06-14 10:58:57', NULL, 1, NULL); INSERT INTO `activities` VALUES (6, 'MAKLUMAT PELAYANAN', 'maklumat-pelayanan', 'uploads/xxx/kegiatan1.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 0, NULL, 1, '2024-06-14 10:58:57', NULL, 1, NULL); -- ---------------------------- -- Table structure for articles -- ---------------------------- DROP TABLE IF EXISTS `articles`; CREATE TABLE `articles` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content_short` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `content_long` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `date` date NULL DEFAULT NULL, `count_view` int NULL DEFAULT 0, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of articles -- ---------------------------- INSERT INTO `articles` VALUES (1, 'Upacara Peringatan Hari Bela Negara', 'upacara-peringatan-hari-bela-negara', 'uploads/xxx/news5.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-04-09', 0, NULL, 1, '2024-06-09 21:18:29', NULL, 1, NULL); INSERT INTO `articles` VALUES (2, 'Upacara, TMMD Sengkuyung Tahap II Kodim 0716/Demak Resmi dibuka', 'upacara-tmmd-sengkuyung-tahap-ii', 'uploads/xxx/news4.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-05-10', 0, NULL, 1, '2024-06-09 21:18:29', NULL, 1, NULL); INSERT INTO `articles` VALUES (3, 'Danrem 073/Mkt : 30 Menit Dalam Satu Hari Menuju Sehat', 'danrem-073-30-menit-dalam-satu-hari', 'uploads/xxx/news3.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-05-17', 0, NULL, 1, '2024-06-09 21:18:29', NULL, 1, NULL); INSERT INTO `articles` VALUES (4, 'Lompat - Lompat ditempat, Kaki Buka Tutup Tangan Bertepuk diatas Kepala', 'lompat-lompat-ditempat', 'uploads/xxx/news2.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-05-29', 2, NULL, 1, '2024-06-09 21:18:29', '2024-06-14 10:33:22', 1, NULL); INSERT INTO `articles` VALUES (5, 'Kapolres Datangi Makorem 073/ MAKUTARAMA Ada Apa ??', 'kapolres-datangi-makorem-073', 'uploads/xxx/news1.jpg', 'Salatiga - Kapolres Kota Salatiga AKBP Aryuni Novitasari, M.Psi., M.Si., Psi.,\r\n beserta beberapa stafnya mendatangi Makorem 073/Makutarama di Jalan Diponegoro No.\r\n 28 Salatiga Jawa Tengah. Rabu (15/5/2024) ', 'Salatiga - Kapolres Kota Salatiga AKBP Aryuni Novitasari, M.Psi., M.Si., Psi.,\r\n beserta beberapa stafnya mendatangi Makorem 073/Makutarama di Jalan Diponegoro No.\r\n 28 Salatiga Jawa Tengah. Rabu (15/5/2024)

\r\n Maksud kedatangan Kapolres beserta anggotanya tersebut tidak lain tidak bukan untuk\r\n bersilaturahmi kepada Komandan Korem 073/Makutarama Kolonel Inf Ari Prasetya, S.E.,\r\n M.Han. yang kurang dari satu bulan menjabat sebagai Danrem. Kedatangan Kapolres\r\n beserta rombongan disambut hangat oleh Danrem, para Kasi dan Pasi serta Kabalakrem.\r\n Dalam sambutanya Danrem menyampaikan ucapan terimakasih dan harapannya.', '2024-06-01', 21, NULL, 1, '2024-06-09 21:18:29', '2024-06-13 13:52:20', 1, NULL); -- ---------------------------- -- Table structure for declarations -- ---------------------------- DROP TABLE IF EXISTS `declarations`; CREATE TABLE `declarations` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content_short` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `content_long` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `date` date NULL DEFAULT NULL, `count_view` int NOT NULL DEFAULT 0, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of declarations -- ---------------------------- INSERT INTO `declarations` VALUES (1, 'MAKLUMAT PELAYANAN 1', 'maklumat-1', 'uploads/xxx/kegiatan1.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 0, NULL, 1, '2024-06-14 10:58:57', NULL, 1, NULL); INSERT INTO `declarations` VALUES (2, 'MAKLUMAT PELAYANAN 2', 'maklumat-2', 'uploads/xxx/kegiatan1.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 2, NULL, 1, '2024-06-14 10:58:57', '2024-06-14 13:04:31', 1, NULL); INSERT INTO `declarations` VALUES (3, 'MAKLUMAT PELAYANAN 3', 'maklumat-3', 'uploads/xxx/kegiatan1.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-06-14', 1, NULL, 1, '2024-06-14 10:58:57', '2024-06-18 14:26:00', 1, NULL); -- ---------------------------- -- Table structure for form_comments -- ---------------------------- DROP TABLE IF EXISTS `form_comments`; CREATE TABLE `form_comments` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of form_comments -- ---------------------------- INSERT INTO `form_comments` VALUES (1, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'komentar 1', NULL, 1, '2024-06-14 13:50:22', '2024-06-14 13:50:22', NULL, NULL); INSERT INTO `form_comments` VALUES (2, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'komentar 2', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `form_comments` VALUES (3, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'komentar 3', NULL, 0, '2024-06-14 13:53:31', '2024-06-14 13:53:31', NULL, NULL); INSERT INTO `form_comments` VALUES (4, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'komentar 4', NULL, 0, '2024-06-14 13:53:40', '2024-06-14 13:53:40', NULL, NULL); INSERT INTO `form_comments` VALUES (5, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'asd', NULL, 0, '2024-06-14 13:53:53', '2024-06-14 13:53:53', NULL, NULL); -- ---------------------------- -- Table structure for form_complaint_publics -- ---------------------------- DROP TABLE IF EXISTS `form_complaint_publics`; CREATE TABLE `form_complaint_publics` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `complaint` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `person` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of form_complaint_publics -- ---------------------------- INSERT INTO `form_complaint_publics` VALUES (1, 'Gelar', NULL, NULL, NULL, NULL, NULL, NULL, 0, '2024-06-14 13:43:49', '2024-06-14 13:43:49', NULL, NULL); INSERT INTO `form_complaint_publics` VALUES (2, 'Gelar Aditya', 'akatgelar@gmail.com', '085721028015', 'ada masalah', 'dia', 'di sini', NULL, 0, '2024-06-14 13:44:09', '2024-06-14 13:44:09', NULL, NULL); -- ---------------------------- -- Table structure for form_complaint_wbs -- ---------------------------- DROP TABLE IF EXISTS `form_complaint_wbs`; CREATE TABLE `form_complaint_wbs` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `complaint` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `person` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `loss_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of form_complaint_wbs -- ---------------------------- INSERT INTO `form_complaint_wbs` VALUES (1, 'Gelar', NULL, NULL, NULL, NULL, NULL, 'sa', NULL, 0, '2024-06-14 13:43:40', '2024-06-14 13:43:40', NULL, NULL); INSERT INTO `form_complaint_wbs` VALUES (2, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'ada masalah', 'dua orang', 'di sana', 'asd', NULL, 0, '2024-06-14 13:43:52', '2024-06-14 13:43:52', NULL, NULL); INSERT INTO `form_complaint_wbs` VALUES (4, 'Gelar Aditya Pratama 2', 'akatgelar@gmail.com 2', '085721028015 2', 'pengaduan 2', 'dua orang 2', 'di sini 2', 'banyak 2', '2', 1, '2024-06-18 15:14:39', '2024-06-18 15:15:00', NULL, 1); -- ---------------------------- -- Table structure for form_information -- ---------------------------- DROP TABLE IF EXISTS `form_information`; CREATE TABLE `form_information` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `information` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of form_information -- ---------------------------- INSERT INTO `form_information` VALUES (1, 'Gelar', NULL, NULL, NULL, NULL, 0, '2024-06-14 13:26:28', '2024-06-14 13:26:28', NULL, NULL); INSERT INTO `form_information` VALUES (2, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'asd', NULL, 0, '2024-06-14 13:26:32', '2024-06-14 13:26:32', NULL, NULL); INSERT INTO `form_information` VALUES (3, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'asd', NULL, 0, '2024-06-14 13:26:51', '2024-06-14 13:26:51', NULL, NULL); INSERT INTO `form_information` VALUES (4, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'asd', NULL, 0, '2024-06-14 13:27:03', '2024-06-14 13:27:03', NULL, NULL); INSERT INTO `form_information` VALUES (5, 'Gelar Aditya Pratama', 'akatgelar@gmail.com', '085721028015', 'asd', NULL, 0, '2024-06-14 13:27:57', '2024-06-14 13:27:57', NULL, NULL); INSERT INTO `form_information` VALUES (6, 'Gelar Aditya', 'akatgelar@gmail.com', '085721028015', NULL, NULL, 0, '2024-06-14 13:49:24', '2024-06-14 13:49:24', NULL, NULL); INSERT INTO `form_information` VALUES (7, 'Gelar Aditya', 'akatgelar@gmail.com', '085721028015', NULL, NULL, 0, '2024-06-14 13:49:38', '2024-06-14 13:49:38', NULL, NULL); -- ---------------------------- -- Table structure for informations -- ---------------------------- DROP TABLE IF EXISTS `informations`; CREATE TABLE `informations` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content_short` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `content_long` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `date` date NULL DEFAULT NULL, `count_view` int NOT NULL DEFAULT 0, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of informations -- ---------------------------- INSERT INTO `informations` VALUES (1, 'Netralitas TNI AD Pada Pemili 2024', 'netralitas-tni', 'uploads/xxx/penerangan1.jpeg', 'NETRALITAS TNI AD PADA PEMILI 2024', 'NETRALITAS TNI AD PADA PEMILI 2024', '2024-06-14', 7, NULL, 1, '2024-06-14 10:07:52', '2024-06-14 10:19:54', 1, NULL); INSERT INTO `informations` VALUES (2, 'Upacara, TMMD Sengkuyung Tahap II Kodim 0716/Demak Resmi dibuka', 'upacara-tmmd-sengkuyung-tahap-ii', 'uploads/xxx/news4.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-05-10', 1, NULL, 1, '2024-06-09 21:18:29', '2024-06-14 10:21:10', 1, NULL); -- ---------------------------- -- Table structure for institutions -- ---------------------------- DROP TABLE IF EXISTS `institutions`; CREATE TABLE `institutions` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of institutions -- ---------------------------- INSERT INTO `institutions` VALUES (1, 'Kemenhan', 'uploads/xxx/institution-5.png', 'https://www.kemhan.go.id/', NULL, NULL, 1, '2024-06-09 21:45:17', NULL, 1, NULL); INSERT INTO `institutions` VALUES (2, 'TNI AU', 'uploads/xxx/institution-4.png', 'https://tni-au.mil.id/', NULL, NULL, 1, '2024-06-09 21:45:17', NULL, 1, NULL); INSERT INTO `institutions` VALUES (3, 'TNI AL', 'uploads/xxx/institution-3.png', 'https://tnial.mil.id/', NULL, NULL, 1, '2024-06-09 21:45:17', NULL, 1, NULL); INSERT INTO `institutions` VALUES (4, 'TNI AD', 'uploads/xxx/institution-2.png', 'https://tniad.mil.id/', NULL, NULL, 1, '2024-06-09 21:45:17', NULL, 1, NULL); INSERT INTO `institutions` VALUES (5, 'TNI', 'uploads/xxx/institution-1.png', 'https://tni.mil.id/', NULL, NULL, 1, '2024-06-09 21:45:17', NULL, 1, NULL); -- ---------------------------- -- Table structure for logs -- ---------------------------- DROP TABLE IF EXISTS `logs`; CREATE TABLE `logs` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `fingerprint` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `fullurl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `os` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `os_version` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `browser` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `browser_version` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `device` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `is_desktop` tinyint(1) NOT NULL DEFAULT 0, `is_mobile` tinyint(1) NOT NULL DEFAULT 0, `is_tablet` tinyint(1) NOT NULL DEFAULT 0, `ip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `country_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `country_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `region_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `region_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `city_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `city_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `zip_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `latitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `longitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1359 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = COMPRESSED ; -- ---------------------------- -- Records of logs -- ---------------------------- -- ---------------------------- -- Table structure for magazines -- ---------------------------- DROP TABLE IF EXISTS `magazines`; CREATE TABLE `magazines` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content_short` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `content_long` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `date` date NULL DEFAULT NULL, `count_view` int NOT NULL DEFAULT 0, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of magazines -- ---------------------------- INSERT INTO `magazines` VALUES (1, 'Netralitas TNI AD Pada Pemili 2024', 'netralitas-tni', 'uploads/xxx/penerangan1.jpeg', 'NETRALITAS TNI AD PADA PEMILI 2024', 'NETRALITAS TNI AD PADA PEMILI 2024', '2024-06-14', 1, NULL, 1, '2024-06-14 10:07:52', '2024-06-14 10:24:12', 1, NULL); INSERT INTO `magazines` VALUES (3, 'Danrem 073/Mkt : 30 Menit Dalam Satu Hari Menuju Sehat', 'danrem-073-30-menit-dalam-satu-hari', 'uploads/xxx/news3.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-05-17', 1, NULL, 1, '2024-06-09 21:18:29', '2024-06-14 10:24:16', 1, NULL); -- ---------------------------- -- Table structure for mandates -- ---------------------------- DROP TABLE IF EXISTS `mandates`; CREATE TABLE `mandates` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content_short` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `content_long` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `date` date NULL DEFAULT NULL, `count_view` int NOT NULL DEFAULT 0, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of mandates -- ---------------------------- INSERT INTO `mandates` VALUES (1, 'Netralitas TNI AD Pada Pemili 2024', 'netralitas-tni', 'uploads/xxx/penerangan1.jpeg', 'NETRALITAS TNI AD PADA PEMILI 2024', 'NETRALITAS TNI AD PADA PEMILI 2024', '2024-06-14', 2, NULL, 1, '2024-06-14 10:07:52', '2024-06-14 10:33:19', 1, NULL); INSERT INTO `mandates` VALUES (4, 'Lompat - Lompat ditempat, Kaki Buka Tutup Tangan Bertepuk diatas Kepala', 'lompat-lompat-ditempat', 'uploads/xxx/news2.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum quis nisi aliquam dictum ac imperdiet sapien. Fusce feugiat sodales velit, at sagittis elit varius eget. Nulla convallis porta ex non ultricies.', '2024-05-29', 3, NULL, 1, '2024-06-09 21:18:29', '2024-06-18 14:02:09', 1, NULL); -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of migrations -- ---------------------------- INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1); INSERT INTO `migrations` VALUES (2, '2019_02_08_105647_create_blocks_contents_tables', 1); INSERT INTO `migrations` VALUES (3, '2019_12_14_000001_create_personal_access_tokens_table', 1); INSERT INTO `migrations` VALUES (4, '2021_11_12_153947_remove_blocks_contents_tables', 1); INSERT INTO `migrations` VALUES (5, '2024_03_16_043823_create_user_levels_table', 1); INSERT INTO `migrations` VALUES (6, '2024_03_17_044652_create_settings_table', 1); INSERT INTO `migrations` VALUES (7, '2024_03_22_044048_create_sliders_table', 1); INSERT INTO `migrations` VALUES (9, '2024_03_31_165519_create_sessions_table', 1); INSERT INTO `migrations` VALUES (10, '2024_04_01_120310_create_uploads_table', 1); INSERT INTO `migrations` VALUES (11, '2024_04_13_105020_create_logs_table', 1); INSERT INTO `migrations` VALUES (12, '2024_05_26_094639_add_alamat_to_users_table', 1); INSERT INTO `migrations` VALUES (13, '2024_06_09_150532_create_territories_table', 2); INSERT INTO `migrations` VALUES (14, '2024_06_09_205756_create_visions_table', 3); INSERT INTO `migrations` VALUES (15, '2024_06_09_210947_create_articles_table', 4); INSERT INTO `migrations` VALUES (16, '2024_06_09_214004_create_institutions_table', 5); INSERT INTO `migrations` VALUES (17, '2024_06_14_100150_create_information_table', 6); INSERT INTO `migrations` VALUES (18, '2024_06_14_100207_create_magazines_table', 6); INSERT INTO `migrations` VALUES (19, '2024_06_14_100222_create_mandates_table', 6); INSERT INTO `migrations` VALUES (20, '2024_06_14_104443_create_activities_table', 7); INSERT INTO `migrations` VALUES (21, '2024_06_14_111507_create_declarations_table', 8); INSERT INTO `migrations` VALUES (22, '2024_06_14_111628_create_form_information_table', 8); INSERT INTO `migrations` VALUES (23, '2024_06_14_111739_create_form_complaint_wbs_table', 8); INSERT INTO `migrations` VALUES (24, '2024_06_14_111743_create_form_complaint_publics_table', 8); INSERT INTO `migrations` VALUES (25, '2024_06_14_111800_create_form_comments_table', 8); -- ---------------------------- -- Table structure for personal_access_tokens -- ---------------------------- DROP TABLE IF EXISTS `personal_access_tokens`; CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `personal_access_tokens_token_unique`(`token` ASC) USING BTREE, INDEX `personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type` ASC, `tokenable_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of personal_access_tokens -- ---------------------------- -- ---------------------------- -- Table structure for sessions -- ---------------------------- DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint UNSIGNED NULL DEFAULT NULL, `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `sessions_user_id_index`(`user_id` ASC) USING BTREE, INDEX `sessions_last_activity_index`(`last_activity` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of sessions -- ---------------------------- INSERT INTO `sessions` VALUES ('JaP5ADUn46GAe2c2svohclyohdmYhlKuqEC4LW6x', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'YToxMDp7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9hZG1pbi9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjY6Il90b2tlbiI7czo0MDoiTWt2RGZScXYyUDhFNjlaM2JTMFdJNVhENmQybHdTMG1EcVBGSDd4cyI7czo3OiJ1c2VyX2lkIjtpOjE7czoxMzoidXNlcl9sZXZlbF9pZCI7aToxO3M6MTU6InVzZXJfbGV2ZWxfbmFtZSI7czoxMToiU3VwZXIgQWRtaW4iO3M6OToidXNlcl9uYW1lIjtzOjU6IkFkbWluIjtzOjEwOiJ1c2VyX2VtYWlsIjtzOjE1OiJhZG1pbkBnbWFpbC5jb20iO3M6MTI6InVzZXJfcGljdHVyZSI7czo1NDoidXBsb2Fkcy8zMDAvMjAyNDA2MThfMTYxMjA0LWdvb2dsZS1jbG91ZC1pY29uLTQwMHcucG5nIjtzOjU6InRva2VuIjtzOjMzNToiZXlKMGVYQWlPaUpLVjFRaUxDSmhiR2NpT2lKSVV6STFOaUo5LmV5SnBjM01pT2lKb2RIUndPaTh2Ykc5allXeG9iM04wT2pnd01EQXZZV1J0YVc0dllYVjBhQzloWTNScGIyNWZiRzluYVc0aUxDSnBZWFFpT2pFM01UZzNNREU1TXpZc0ltVjRjQ0k2TVRjeE9EYzRPRE16Tml3aWJtSm1Jam94TnpFNE56QXhPVE0yTENKcWRHa2lPaUpqUldVeldIUjFhMDlzYnpVMmVqVnJJaXdpYzNWaUlqb2lNU0lzSW5CeWRpSTZJakl6WW1RMVl6ZzVORGxtTmpBd1lXUmlNemxsTnpBeFl6UXdNRGczTW1SaU4yRTFPVGMyWmpjaWZRLjNzblI3VF9zbGJfMFBEY0ZtR0xyLV9lSmJ6YWN4cURHLWd3MTluZXN6S0kiO30=', 1718703012); -- ---------------------------- -- Table structure for settings -- ---------------------------- DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `settings_key_unique`(`key` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 96 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of settings -- ---------------------------- INSERT INTO `settings` VALUES (1, 'text', 'name', 'KOREM 073 MAKUTARAMA', NULL, 1, '2024-06-09 11:19:40', '2024-06-09 11:19:40', NULL, NULL); INSERT INTO `settings` VALUES (2, 'text', 'tagline', 'PEMBANGUNAN ZONA INTEGRITAS KOREM 073/MAKUTARAMA', NULL, 1, '2024-06-09 11:19:40', '2024-06-09 11:19:40', NULL, NULL); INSERT INTO `settings` VALUES (3, 'image', 'icon', 'uploads/xxx/icon.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (4, 'image', 'logo', 'uploads/xxx/logo.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (5, 'image', 'logo-text-white', 'uploads/xxx/logo-title-white.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (6, 'image', 'logo-text-color', 'uploads/xxx/logo-title-color.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (7, 'text', 'copyright', 'Copyright © 2024 KOREM 073/MAKUTARAMA', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (8, 'longtext', 'map-iframe', 'https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d15829.109042401453!2d110.5018182!3d-7.3227218!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e7a786c0396d53d%3A0x6da375586a35723e!2sKorem%20073%2FMakutarama!5e0!3m2!1sen!2sid!4v1716284528890!5m2!1sen!2sid', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (9, 'longtext', 'address', 'Jl. Diponegoro No. 28, Sidorejo Lor, Kec. Sidorejo, Kota Salatiga - Jawa Tengah 50714', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (10, 'text', 'phone', '(0298) 326 213', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (11, 'text', 'email', 'korem073mkt@tni-ad.mil.id', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (21, 'text', 'media-facebook', 'https://www.facebook.com/makutarama.penerangan.9', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (22, 'text', 'media-twitter', 'https://twitter.com/koremmakutarama', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (23, 'text', 'media-instagram', 'https://instagram.com/korem_073_makutarama', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (24, 'text', 'media-youtube', 'https://www.youtube.com/channel/UCT7hLiqdIp6KAjfauSV4eAg', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (31, 'longtext', 'seo-description', 'korem adalah', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (32, 'longtext', 'seo-keywords', 'korem, tni, ', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (33, 'longtext', 'seo-author', 'koren 073', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (34, 'longtext', 'seo-keyphrases', 'korem', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (35, 'longtext', 'seo-mytopic', 'korem', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (36, 'longtext', 'seo-classification', 'public', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (37, 'longtext', 'seo-robots', 'index, follow', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (41, 'text', 'home-komandan-name', 'Kolonel Inf Ari Prasetya, S.E , M.Han.', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (42, 'image', 'home-komandan-photo', 'uploads/xxx/kolonel2.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (43, 'wysiwyg', 'home-komandan-deskripsi', 'Komandan KOREM 073/MAKUTARAMA ke - 42
Periode 2024 sampai sekarang', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (44, 'image', 'home-lambang-image', 'uploads/xxx/makutarama.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (45, 'wysiwyg', 'home-lambang-deskripsi', '

\r\n Makutarama adalah mahkota raja sri ramawijaya (ramayana) seorang raja yang termasyur dan\r\n bijaksana. “Makutarama” merupakan suatu kalimat kramat, wahyu, wewengsang, pedoman hidup\r\n ke arah kesempurnaan dinamakan hastha brata yang mengandung arti suatu kebaktian yang wajar dan\r\n usaha mencapai gerbang kemuliaan.\r\n

\r\n

\r\n “Hasta” artinya delapan dan “Brata” artinya laku/sila. Hasta Brata\r\n melambangkan kesucian dan kemurnian dari benda - benda alam dalam cosmos besar, mencerminkan\r\n kesucian sifat dan watak setiap pribadi manusia sebagai cosmos kecil. Makutarama adalah\r\n mahkota milik sri ramawijaya, dalam tata warna hitam (Langgeng).\r\n

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (51, 'image', 'profil-lambang-image', 'uploads/xxx/makutarama.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (52, 'wysiwyg', 'profil-lambang-deskripsi', '

Makutarama adalah mahkota raja sri ramawijaya (ramayana) seorang raja yang\r\n termasyur dan bijaksana. “Makutarama” merupakan suatu kalimat kramat, wahyu,\r\n wewengsang, pedoman hidup ke arah kesempurnaan dinamakan hastha brata yang\r\n mengandung arti suatu kebaktian yang wajar dan usaha mencapai gerbang kemuliaan.\r\n

\r\n “Hasta” artinya delapan dan “Brata” artinya laku/sila. Hasta\r\n Brata melambangkan kesucian dan kemurnian dari benda - benda alam dalam\r\n cosmos besar, mencerminkan kesucian sifat dan watak setiap pribadi manusia sebagai\r\n cosmos kecil. Makutarama adalah mahkota milik sri ramawijaya, dalam tata\r\n warna hitam (Langgeng).\r\n

\r\n Dimana dilukiskan bulatan - bulatan kecil sejumlah delapan (Hasta Brata), demikian\r\n pula cunduk - cunduk mahkota yang berjumlah delapan (Hasta Brata). Dibelakangnya\r\n terdapat lukisan awan dibawahnya terdapat lukisan api (merah) bumi (hitam) dan laut\r\n (biru tua) lingkaran yang terdiri dari : Padi - Kapas - Bintang dan Pita Bakti. Alas\r\n dibawahnya dituliskan kalimat Surya Sangkala yang berbunyi :\r\n
\r\n

“Bekti Tata Gapuraning Buana“

\r\n
\r\n Bekti mempunyai watak 2 (dua), Tata mempunyai watak 5 (lima),\r\n Gapura mempunyai watak 9 (sembilan), Buana mempunyai watak 1 (satu)\r\n Keseluruhannya menunjukkan tahun masehi 1952.\r\n

\r\n\r\n Benda - benda alam pada Mahkota Makutarama terdiri dari :\r\n \r\n\r\n Makutarama merupakan penyuluh dasar - dasar jiwa dan dapat menjiwai pribadi bagi\r\n individu maupun korps.\r\n

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (53, 'image', 'profil-sejarah-image-1', 'uploads/xxx/kodam.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (54, 'image', 'profil-sejarah-image-2', 'uploads/xxx/makutarama.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (55, 'wysiwyg', 'profil-sejarah-deskripsi', '

Perjuangan membela Tanah Air dan mempertahankan kemerdekaan Republik Indonesia\r\n merebak diseluruh nusantara, begitu disadari ancaman dan dorongan berulang dari\r\n pihak penjajah. Setiap putera bangsa terpanggil untuk mengambil andil menegakan arti\r\n dan makna Proklamasi Kemerdekaan Republik 17 Agustus 1945, Situasi dan kondisi\r\n wilayah Indonesia khususnya geografis Indonesia yang terdiri beribu pulau besar dan\r\n kecil dengan keanekaragaman sosial, budaya, menyebabkan terjadinya perbedaan gerak\r\n dan corak perjuangan rakyat di setiap wilayah.\r\n

\r\n KOREM 073/Makutarama dalam perkembanganya mempunyai corak yang erat\r\n hubungannya dengan kejadian sehari - hari, keadaan organisasi satuan, keadaan\r\n daerah, keadaan lingkungan serta bentuk - bentuk kejadian diluar satuan.\r\n

\r\n Pada tahun 1950 sampai tahun 1961 merupakan periode penampakan dan pembangunan bagi\r\n Korps Diponegoro. Tantangan - tantangan yang berupa pengacauan - pengacauan\r\n bersenjata dapat diatasi oleh Divisi Diponeoro, bahkan menjadikan Kesatuan Divisi\r\n Diponegoro yang berada di Komando Tentara & Teritorium IV Jawa Tengah ini semakin\r\n kokoh dan dewasa dalam orgaisasi serta mutu keprajuritannya.\r\n

\r\n Pembangunan dari Angkatan Darat khususnya berjalan terus disamping menunaikan\r\n tugasnya yang berat, melakukan operasi - operasi keamanan dalam negeri. Demikian\r\n pula Divisi Diponegoro dengan seluruh kesatuannya. Pengalaman - pengalaman operasi\r\n dan hasil - hasil pendidikan dan latihan yang dijalankan secara berencana membawa\r\n kemajuan secara cepat. Divisi Diponegoro membentuk pasukan Raiders yang terkenal\r\n dengan nama Banteng Raiders juga tak dapat dikesampingkan pada tahun 1957, penugasan\r\n Kompi -kompi dari Divisi Diponegoro dalam Kontingen Batalyon Garuda I yang\r\n menjalankan tugas PBB (Perserikatan Bangsa - Bangsa) ke Mesir. Sedangkan regrouping\r\n ke dalam juga berjalan terus menyesuaikan perkembangan pertahanan negara yang menuju\r\n pada organisasi Angkatan Darat secara reguler dan pembinaan peran wilayah.\r\n

\r\n Komando Resor Militer 073/Makutarama, disingkat (Korem 073/MK) adalah\r\n bandan pelaksana pusat Kodam IV/Diponegoro sebagai subkompatermen matra darat\r\n yang bersifat kewilayahan dan berkedudukan di bawah kendali Pangdam\r\n IV/Diponegoro. Dislokasi Makorem berada di Kota Salatiga, wilayah tanggung\r\n jawab Korem 073/MK berada di eks Karesidenan Semarang dan Karesidenan Pati\r\n yang teridiri dari 9 Kabupaten dan 1 Kota. meliputi wilayah eks Karesidenan\r\n Salatiga, Karesidenan Semarang dan Karesidenan Pati. Korem ini berada di bawah\r\n Kodam IV/Diponegoro.\r\n

\r\n Korem 073/Makutarama bermarkas di Jl. Diponegoro No. 28, Sidorejo, Kota\r\n Salatiga, Jawa Tengah (50714).\r\n

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (56, 'wysiwyg', 'profil-kode-etik', '
\r\n

SAPTA MARGA

\r\n
    \r\n
  1. KAMI WARGA NEGARA KESATUAN REPUBLIK INDONESIA YANG BERSENDIKAN PANCASILA
    2. \r\n
  2. ΚΑΜΙ PATRIOT INDONESIA, PENDUKUNG SERTA PEMBELA IDEOLOGI NEGARA YANG BERTANGGUNG\r\n JAWAB DAN TIDAK MENGENAL MENYERAH.
    3. \r\n
  3. KAMI KESATRIA INDONESIA, YANG BERTAQWA KEPADA TUHAN YANG MAHA ESA, SERTA MEMBELA\r\n KEJUJURAN, KEBENARAN DAN KEADILAN.
    4. \r\n
  4. KAMI PRAJURIT TENTARA NASIONAL INDONESIA, ADALAH BHAYANGKARI NEGARA DAN BANGSA\r\n INDONESIA.
    5. \r\n
  5. KAMI PRAJURIT TENTARA NASIONAL INDONESIA, MEMEGANG TEGUH DISIPLIN, PATUH DAN\r\n TAAT KEPADA PIMPINAN SERTA MENJUNJUNG TINGGI SIKAP DAN KEHORMATAN PRAJURIT.\r\n
    6. \r\n
  6. KAMI PRAJURIT TENTARA NASIONAL INDONESIA, MENGUTAMAKAN KEPERWIRAAN DI DALAM\r\n MELAKSANAKAN TUGAS, SERTA SENANTIASA SIAP SEDIA BERBAKTI KEPADA NEGARA DAN\r\n BANGSA.
    7. \r\n
  7. KAMI PRAJURIT TENTARA NASIONAL INDONESIA, SETIA DAN MENEPATI JANJI SERTA SUMPAH\r\n PRAJURIT.
    8. \r\n
\r\n\r\n

SUMPAH PRAJURIT

\r\n
    \r\n
  1. SETIA KEPADA NEGARA KESATUAN REPUBLIK INDONESIA YANG BERDASARKAN PANCASILA DAN\r\n UNDANG-UNDANG DASAR 1945.
    2. \r\n
  2. TUNDUK KEPADA HUKUM DAN MEMEGANG TEGUH DISIPLIN KEPRAJURITAN.
    3. \r\n
  3. TAAT KEPADA ATASAN DENGAN TIDAK MEMBANTAH PERINTAH ATAU PUTUSAN.
    4. \r\n
  4. MENJALANKAN SEGALA KEWAJIBAN DENGAN PENUH RASA TANGGUNG JAWAB KEPADA TENTARA DAN\r\n NEGARA REPUBLIK INDONESIA.
    5. \r\n
  5. MEMEGANG SEGALA RAHASIA TENTARA SEKERAS-KERASNYA.
    6. \r\n
\r\n\r\n

8 WAJIB TNI

\r\n
    \r\n
  1. BERSIKAP RAMАН ТАМAH TERHADAP RAKYAT.
    2. \r\n
  2. BERSIKAP SOPAN SANTUN TERHADAP RAKYAT.
    3. \r\n
  3. MENJUNJUNG TINGGI KEHORMATAN WANITA.
    4. \r\n
  4. MENJAGA KEHORMATAN DIRI DI MUKA UMUM.
    5. \r\n
  5. SENANTIASA MENJADI CONTOH DALAM SIKAP DAN KESEDERHANAANNYA.
    6. \r\n
  6. TIDAK SEKALI-KALI MERUGIKAN RAKYAT.
    7. \r\n
  7. TIDAK SEKALI-KALI MENAKUTI DAN MENYAKITI HATI RAKYAT.
    8. \r\n
  8. MENJADI CONTOH DAN MEMPELOPORI USAHA- USAHA UNTUK MENGATASI KESULITAN RAKYAT\r\n SEKELILINGNYA.
    9. \r\n
', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (57, 'wysiwyg', 'profil-tugas', 'Sebagai bagian dari Kodam IV/Diponegoro tugas pokok Korem\r\n 073/Makutarama menyelenggarakan pertempuran dan pembinaan teritorial dalam rangka\r\n mendukung tugas pokok Kodam IV/Diponegoro dalam menjalankan fungsi TNI AD sebagai\r\n penangkal, penindak dan pemulih di wilayah Eks Karesidenan Semarang dan Pati.', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (58, 'image', 'profil-organisasi-image', 'uploads/xxx/organisasi.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (59, 'wysiwyg', 'profil-organisasi-deskripsi', 'Korem 073/Makutarama adalah Badan Pelaksana Kodam IV/Dip sebagai Sub Kompartemen\r\n Strategis matra darat yang bersifat kewilayahan dan berkedudukan langsung dibawah\r\n Pangdam IV/Dip. Dislokasi Makorem 073/Mkt berada di Salatiga, wilayah tanggung jawab\r\n Korem 073/Makutarama meliputi eks wilayah Karesidenan Semarang dan Karesidenan Pati\r\n yang terdiri dari 9 Kabupaten dan 1 Kota.', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (60, 'image', 'profil-duaja-image', 'uploads/xxx/makutarama.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (61, 'wysiwyg', 'profil-duaja-deskripsi', '

MAKNA DAN ARTI MAHKOTA MAKUTARAMA

\r\n

MAKUTARAMA ADALAH MAHKOTA RAJA SRI RAMAWIJAYA (RAMAYANA)\r\n SEORANG RAJA YANG TERMASYUR DAN BIJAKSANA. ” MAKUTARAMA ” MERUPAKAN SUATU KALIMAT\r\n KRAMAT, WAHYU, WEWENGSANG, PEDOMAN HIDUP KE ARAH KESEMPURNAAN DINAMAKAN HASTHA BRATA\r\n YANG MENGANDUNG ARTI SUATU KEBAKTIAN YANG WAJAR DAN USAHA MENCAPAI GERBANG\r\n KEMULIAAN.

\r\n

”HASTA” ARTINYA DELAPAN DAN ”BRATA” ARTINYA LAKU/SILA.\r\n HASTA BRATA MELAMBANGKAN KESUCIAN DAN KEMURNIAN DARI BENDA – BENDA ALAM DALAM COSMOS\r\n BESAR, MENCERMINKAN KESUCIAN SIFAT DAN WATAK SETIAP PRIBADI MANUSIA SEBAGAI COSMOS\r\n KECIL.

\r\n

MAKUTARAMA ADALAH MAHKOTA MILIK SRI RAMAWIJAYA, DALAM\r\n TATA WARNA HITAM (LANGGENG). DIMANA DILUKISKAN BULATAN-BULATAN KECIL SEJUMLAH\r\n DELAPAN (HASTHA BRATA), DEMIKIAN PULA CUNDUK-CUNDUK MAHKOTA YANG BERJUMLAH DELAPAN\r\n (HASTA BRATA).

\r\n

DIBELAKANGNYA TERDAPAT LUKISAN AWAN DIBAWAHNYA TERDAPAT\r\n LUKISAN API (MERAH) BUMI (HITAM) DAN LAUT ( BIRU TUA) LINGKARAN YANG TERDIRI DARI :\r\n PADI – KAPAS - BINTANG DAN PITA BAKTI. ALAS DIBAWAHNYA DITULISKAN KALIMAT SURYA\r\n SANGKALA YANG BERBUNYI :

\r\n

” BEKTI TATA GAPURANING BUANA ”

\r\n

BEKTI MEMPUNYAI WATAK 2 (DUA)\r\n
\r\n TATA MEMPUNYAI WATAK 5 (LIMA)\r\n
\r\n GAPURA MEMPUNYAI WATAK 9 (SEMBILAN)\r\n
\r\n BUANA MEMPUNYAI WATAK 1 (SATU)\r\n

\r\n

KESELURUHANNYA MENUNJUKKAN TAHUN MASEHI 1952.

\r\n\r\n

BENDA - BENDA ALAM PADA MAHKOTA MAKUTARAMA TERDIRI DARI :

\r\n
    \r\n
  1. SANG SURYA (MATAHARI) : MEMBERI PENERANGAN DAN DAYA PANAS KEPADA SELURUH DUNIA\r\n RAYA, YANG ARTINYA MEMBERI KEHIDUPAN KEPADA SEGENAP MAKHLUK.
    2. \r\n\r\n
  2. SANG CANDRA (BULAN) : MENJADI PENYULUH YANG MEBERIKAN KESAN RASA RESAP DAN\r\n TENTRAM KEPADA SEGENAP MAKHLUK.
    3. \r\n\r\n
  3. SANG KARTIKA (BINTANG) : MENGHIAS RUANG - RUANG ANGKASA RAYA, MEMBUAT KEINDAHAN\r\n DAN KEASRIAN DUNIA RAYA DAN MENJADI PETUNJUK IKLIM.
    4. \r\n\r\n
  4. SANG HIMA (AWAN) : SEBAGAI WUJUD YANG BERGERAK (HANGGEDANU) DIANGKASA, MEMBERI\r\n DAYA KEHIDUPAN KEPADA SEGENAP MAKHLUK DAN TUMBUH – TUMBUHAN.
    5. \r\n\r\n
  5. SANG MARUTA SAMIRONO (ANGIN) : MERANTAI SELURUH DUNIA RAYA, BAHKAN YANG\r\n TERSEMBUNYI SEKALIPUN DIRANTAI OLEH SANG MARUTA.
    6. \r\n\r\n
  6. SANG SAMUDRA (LAUT) : MENGELILINGI SELURUH PERMUKAAN BUMI.
    7. \r\n\r\n
  7. SANG PRATALA (BUMI) : MEMPUNYAI SIFAT YANG SUCI DAN SENTAUSA.
    8. \r\n\r\n
  8. SANG AGNI ATAU DAHANA (API) : MENGHANCURKAN, MELUNAKKAN SETIAP BENDA YANG\r\n NAMPAK, TIDAK PANDANG PILIH, TIDAK BERAT SEBELAH, SEMUA DAPAT DIMUSNAHKAN OLEH\r\n DAYA PENGUASA API.
    9. \r\n
\r\n\r\n

\r\n MAKUTARAMA MERUPAKAN PENYULUH DASAR - DASAR JIWA DAN DAPAT MENJIWAI PRIBADI BAGI\r\n INDIVIDU MAUPUN KORPS ”

\r\n\r\n

DEMIKIAN MAKNA DAN ARTI MAHKOTA MAKUTARAMA LAMBANG KOREM 073/MAKUTARAMA.

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (71, 'wysiwyg', 'personel-pendidikan', '

Persyaratan DIKBANGUM

\r\n
\r\n

Persyaratan DIKBANGSPES

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (72, 'wysiwyg', 'personel-karir', '

Pangkat

\r\n
\r\n

Mutasi

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (73, 'wysiwyg', 'personel-kesejahteraan', '

TAHORNEG

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (74, 'wysiwyg', 'personel-abituren', '

AKMIL

\r\n
\r\n

SEPA PK

\r\n
\r\n

SECAPA

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (75, 'wysiwyg', 'personel-pusdalinfopers', '-', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (81, 'wysiwyg', 'zonaintegritas-dasar', '
\r\n
    \r\n
  1. Undang undang Nomor 34 Tahun 2004 tentang Tentara Nasional Indonesia.
    2. \r\n
  2. Peraturan Presiden RI Nomor 10 Tahun 2010 tanggal 28 Januari 2010 tentang\r\n susunan organisasi TNI.
    3. \r\n
  3. Permenpan Nomor Per/15/M.Pan/7/2008 tanggal 10 Juli 2008 tentang buku pandian\r\n pelaksanakaan Reformasi Birokrasi.
    4. \r\n
  4. Permenpan Nomor Per/4/M.Pan/4/2009 tanggal 7 April 2008 tentang pengajuan\r\n dokumen usulan Reformasi Birokrasi di lingkungan Kementrian/Lembaga/Pemerintah\r\n Daerah.
    5. \r\n
  5. Surat Panglima TNI Nomor B/3038-03/02/66/Sru tanggal 17 September 2009 tentang\r\n Laporan Pelaksanaan Reformasi Birokrasi TNI.
    6. \r\n
  6. Keputusan Panglima TNI Nomo Kep/692/IX/2011 tanggal 17 September 2011 tentang\r\n Organisasi Pelaksana Reformasi Birokrasi TNI.
    7. \r\n
  7. Surat Kasad Nomor B/538/III/2011 tanggal 16 Maret 2011 tentang perintah membuat\r\n laporan Reformasi Birokrasi setiap 6 bulan dan Rencana Aksi Pembangunan Zona\r\n Integritas setiap awal tahun.
    8. \r\n
  8. Keputusan Pandam IV/Diponegoro Nomor Kep/162/VI/2017 tanggal 28 Juni 2017\r\n tentang Road Map Reformasi Birokrasi Kodam IV/Diponegoro tahun 2015-2019.
    9. \r\n
  9. Surat Pangdam IV/Diponegoro Nomo B/2849/XI/2018 tanggal 16 November 2018 tentang\r\n mekanisme pembangunan Zona Integritas (ZI) di lingkungan Kodam IV/Diponegoro.\r\n
    10. \r\n
  10. Nota dinas Kepala Seksi Perencanaan Korem 073/Makutarama Nomor B/ND-30/XII/2018\r\n tanggal 31 Desember 2018 tentang Rencana Pencanangan Zona Integritas menuju\r\n WBK/WBBM Korem 073/Makutarama.
    11. \r\n
', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (82, 'image', 'zonaintegritas-organisasi', 'uploads/xxx/organisasi3.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (83, 'longtext', 'zonaintegritas-profil', '\r\n', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (84, 'wysiwyg', 'zonaintegritas-lain', '

AKMIL

\r\n
\r\n

SEPA PK

\r\n
\r\n

SECAPA

\r\n
.', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (91, 'image', 'ppid-struktur', 'uploads/xxx/organisasi2.png', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (92, 'image', 'ppid-visimisi-image', 'uploads/xxx/visi.jpeg', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (93, 'wysiwyg', 'ppid-visimisi-deskripsi', '

VISI PPID :

\r\n

\"Menjadikan Satuan Korem 073/Makutarama sbg Pusat Pengelola Informasi dan Dokumentasi\r\n yg Informatif dan Profesional\"

\r\n

MISI PPID :

\r\n
    \r\n
  1. Meningkatkan pelayanan dan pengelolaan informasi dan dokumentasi publik baik\r\n
    2. \r\n
  2. Meningkatkan sistem pelayanan informasi publik yg Transparan, Aktual, Faktual,\r\n Profesional dan Akuntabel.
    3. \r\n
  3. Menjadi sarana penghubung antara Satuan Korem 073/Makutarama dengan masyarakat.\r\n
    4. \r\n
\r\n

Transparan, Aktual, Faktual, Profesional dan Akuntabel.

', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (94, 'wysiwyg', 'ppid-sop', '
\r\n

STANDART OPERASIONAL PELAYANAN PUBLIK PPID TNI AD\r\n

\r\n STANDART OPERASIONAL PELAYANAN PUBLIK
\r\n PEJABAT PENGELOLA INFORMASI DAN DOKUMENTASI
\r\n
\r\n TENTARA NASIONAL INDONESIA - ANGKATAN DARAT
\r\n (PPID TNI-AD)\r\n

\r\n
\r\n A. LATAR BELAKANG
\r\n Informasi merupakan kebutuhan pokok setiap orang bagi pengembangan pribadi dan\r\n lingkungan sosialnya serta merupakan bagian penting bagi pertahanan nasional. Hak\r\n memperoleh informasi merupakan hak asasi manusia dan keterbukaan informasi publik.\r\n Merupakan salah satu ciri penting Negara demokratis yang menjunjung tinggi kedaulatan\r\n rakyat untuk mewujudkan penyelenggaraan Negara yang baik. Pemberlakuan Undang-undang\r\n nomor 14 tahun 2008 tentang keterbukaan informasi Publik (UU KIP) Pada 30 April 2010\r\n merupakan momentum penting dalam mendorong Keterbukaan di Indonesia, khususnya di\r\n Tentara Nasional Indonesia Angkatan Darat (TNI-AD). UU ini telah memberikan landasan\r\n hukum terhadap hak setiap orang untuk memperoleh Informasi Publik. Dimana, setiap badan\r\n Publik mempunyai kewajiban dalam menyediakan dan melayani permohonan Informasi Publik\r\n secara cepat, tepat waktu , biaya ringan dan cara sederhana.\r\n

\r\n Salah satu tugas Pejabat anggota Pengelola Informasi dan Dokumentasi TNI-AD (PPID\r\n TNI-AD) menyediakan akses informasi publik bagi pemohon informasi. Terkait dengan tugas\r\n tersebut PPID TNI-AD menetapkan standart layanan informasi di lingkungan PPID Tentara\r\n Nasional Indonesia Angkatan Darat (TNI-AD), dengan adanya standart Operasional Pelayanan\r\n Informasi Publik ini, diharapkan implementasi UU KIP dapat berjalan efektif dan hak hak\r\n publik terhadap informasi yang berkualitas dapat secara nyata terpenuhi.\r\n

\r\n B. LANDASAN HUKUM
\r\n
    \r\n
  1. Undang-undang Nomor 14 tahun 2008 tentang Keterbukaan Informasi Publik.
    2. \r\n
  2. Undang-Undang nomor 25 Tahun 2009 temtang pelayanan publik.
    3. \r\n
  3. Undang-Undang nomor 43 tahun 2009 tentang kearsipan.
    4. \r\n
\r\n C. MAKSUD DAN TUJUAN\r\n
    \r\n
  1. Maksud.
    \r\n Pedoman ini sebagai acuan mengenai ruang lingkup, tanggung jawab dan wewenang\r\n pejabat pengelola Informasi dan dokumentasi atau PPID TNI-AD dalam menyediakan\r\n Informasi tertentu melalui mekanisme pelaksanaan kegiatan pelayanan kegiatan\r\n Pelayanan informasi Publik.
    2. \r\n
  2. Tujuan.
    \r\n
      \r\n
    1. Mendorong terwujudnya implementasi UU KIP secara efektif dan hak-hak\r\n publik terhadap informasi yang berkualitas dapat terpenuhi.
      2. \r\n
    2. Memberikan standart bagi pejabat PPID TNI-AD dalam melaksanakan\r\n pelayanan informasi publik.
      3. \r\n
    3. Meningkatkan pelayanan informasi publik di lingkungan organisasi /\r\n Lembaga publik untuk menghasilkan layanan Informasi publik yang\r\n berkualitas
      4. \r\n
    \r\n
    3. \r\n
', NULL, 1, NULL, NULL, NULL, NULL); INSERT INTO `settings` VALUES (95, 'wysiwyg', 'ppid-payunghukum', '
\r\n DASAR HUKUM
\r\n STANDAR BIAYA PEROLEHAN SALINAN INFORMASI TNI-AD DI LINGKUNGAN TENTARA NASIONAL\r\n INDONESIA ANGKATAN DARAT\r\n
\r\n
\r\n
    \r\n
  1. UNDANG-UNDANG REPUBLIK INDONESIA NOMOR 14 TAHUN 2008 TENTANG KETERBUKAAN\r\n INFORMASI PUBLIK [Silahkan\r\n Unduh]
    2. \r\n
  2. KEPUTUSAN PANGLIMA TENTARA NASIONAL INDONESIA NOMOR 2 KEP/611/VII/2011 TENTANG\r\n PENGANGKATAN KEPALA PEJABAT PENGELOLA INFORMASI DAN DOKUMENTASI (PPID) DI\r\n LINGKUNGAN TNI [Silahkan\r\n Unduh]
    3. \r\n
  3. KEPUTUSAN KASAD NOMOR KEP/692/IX/2020 TANGGAL 8 SEPTEMBER 2020 TENTANG\r\n PENGANGKATAN KEPALA PEJABAT PENGELOLA INFORMASI DAN DOKUMENTASI (PPID) DI\r\n LINGKUNGAN TNI AD [Silahkan\r\n Unduh]
    4. \r\n
  4. SURAT PERINTAH KASAD NOMOR SPRIN/2992/IX/2020 TANGGAL 14 SEPTEMBER 2020 TENTANG\r\n ORGANISASI PELAKSANA REFORMASI BIROKRASI TNI AD [Silahkan\r\n Unduh]
    5. \r\n
', NULL, 1, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for sliders -- ---------------------------- DROP TABLE IF EXISTS `sliders`; CREATE TABLE `sliders` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `subtitle` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `image_background` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `image_front` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of sliders -- ---------------------------- INSERT INTO `sliders` VALUES (1, 'PEMBANGUNAN ZONA INTEGRITAS KOREM 073/MAKUTARAMA-', 'Wilayah Bebas dari Korupsi (WBK)
Wilayah Birokrasi Bersih dan Melayani (WBBM)', 'Bekti Tata Gapuraning Buwana', 'uploads/xxx/slider1.jpg', 'uploads/xxx/kolonel.png', NULL, 1, '2024-06-09 18:22:02', NULL, 1, NULL); INSERT INTO `sliders` VALUES (2, 'PEMBANGUNAN ZONA INTEGRITAS KOREM 073/MAKUTARAMA--', 'Wilayah Bebas dari Korupsi (WBK)
Wilayah Birokrasi Bersih dan Melayani (WBBM)', 'Bekti Tata Gapuraning Buwana', 'uploads/xxx/slider1.jpg', 'uploads/xxx/kolonel.png', NULL, 1, '2024-06-09 18:22:02', NULL, 1, NULL); -- ---------------------------- -- Table structure for territories -- ---------------------------- DROP TABLE IF EXISTS `territories`; CREATE TABLE `territories` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of territories -- ---------------------------- INSERT INTO `territories` VALUES (1, 'KOMANDO KEWILAYAHAN', 'KODIM 0714/Salatiga', 'https://www.instagram.com/pendim_0714/', 'uploads/xxx/komando4.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (2, 'KOMANDO KEWILAYAHAN', 'KODIM 0715/Kendal', 'https://0715kodimkendal.blogspot.com/', 'uploads/xxx/komando3.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (3, 'KOMANDO KEWILAYAHAN', 'KODIM 0716/Demak', 'https://www.kodim0716demak.id/', 'uploads/xxx/komando2.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (4, 'KOMANDO KEWILAYAHAN', 'KODIM 0717/Grobogan', 'https://pendim0717.blogspot.com/', 'uploads/xxx/komando1.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (5, 'KOMANDO KEWILAYAHAN', 'KODIM 0718/Pati', 'https://kodim0718.tni-ad.mil.id/', 'uploads/xxx/komando5.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (6, 'KOMANDO KEWILAYAHAN', 'KODIM 0719/Jepara', 'https://pendim0719jepara.blogspot.com/', 'uploads/xxx/komando6.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (7, 'KOMANDO KEWILAYAHAN', 'KODIM 0720/Rembang', 'https://www.facebook.com/people/Kodim-Rembang/100083622542697/?mibextid=ZbWKwL', 'uploads/xxx/komando7.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (8, 'KOMANDO KEWILAYAHAN', 'KODIM 0721/Blora', 'https://www.facebook.com/kodim0721blora?mibextid=ZbWKwL', 'uploads/xxx/komando8.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (9, 'KOMANDO KEWILAYAHAN', 'KODIM 0722/Kudus', 'https://kodimkudus.blogspot.com/', 'uploads/xxx/komando9.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (10, 'DINAS JAWATAN', 'DENKESYAH 04.04.03', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (11, 'DINAS JAWATAN', 'DENHUB REM 073', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (12, 'DINAS JAWATAN', 'DENPOM IV/3', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (13, 'DINAS JAWATAN', 'DENZIBANG 3/IV', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (14, 'DINAS JAWATAN', 'DENPAL A.04.12.03', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (15, 'DINAS JAWATAN', 'DENBEKANG IV.44.03', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (16, 'DINAS JAWATAN', 'AJENREM 73/MAKUTARAMA', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (17, 'DINAS JAWATAN', 'RUMKIT DKT SALATIGA', '#', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); INSERT INTO `territories` VALUES (18, 'BATALYON', 'INFANTERI 410/Alugoro', 'https://www.instagram.com/yonif410_alugoro?igshid=Yzg5MTU1MDY%3D', 'uploads/xxx/komando0.jpg', NULL, NULL, 1, '2024-06-09 15:18:35', NULL, NULL, NULL); -- ---------------------------- -- Table structure for uploads -- ---------------------------- DROP TABLE IF EXISTS `uploads`; CREATE TABLE `uploads` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `ext` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `size` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of uploads -- ---------------------------- INSERT INTO `uploads` VALUES (1, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_141124-google-cloud-icon-400w.png', 'uploads/xxx/20240618_141124-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 14:11:25', '2024-06-18 14:11:25', 1, 1); INSERT INTO `uploads` VALUES (2, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_141359-citiasia_background.jpg', 'uploads/xxx/20240618_141359-citiasia_background.jpg', NULL, 0, '2024-06-18 14:13:59', '2024-06-18 14:13:59', 1, 1); INSERT INTO `uploads` VALUES (3, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_141623-google-cloud-icon-400w.png', 'uploads/xxx/20240618_141623-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 14:16:23', '2024-06-18 14:16:23', 1, 1); INSERT INTO `uploads` VALUES (4, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_141947-google-cloud-icon-400w.png', 'uploads/xxx/20240618_141947-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 14:19:48', '2024-06-18 14:19:48', 1, 1); INSERT INTO `uploads` VALUES (5, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_142033-citiasia_background.jpg', 'uploads/xxx/20240618_142033-citiasia_background.jpg', NULL, 0, '2024-06-18 14:20:33', '2024-06-18 14:20:33', 1, 1); INSERT INTO `uploads` VALUES (6, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_142638-google-cloud-icon-400w.png', 'uploads/xxx/20240618_142638-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 14:26:38', '2024-06-18 14:26:38', 1, 1); INSERT INTO `uploads` VALUES (7, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_142702-citiasia_background.jpg', 'uploads/xxx/20240618_142702-citiasia_background.jpg', NULL, 0, '2024-06-18 14:27:02', '2024-06-18 14:27:02', 1, 1); INSERT INTO `uploads` VALUES (8, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_144153-google-cloud-icon-400w.png', 'uploads/xxx/20240618_144153-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 14:41:53', '2024-06-18 14:41:53', 1, 1); INSERT INTO `uploads` VALUES (9, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_144212-citiasia_background.jpg', 'uploads/xxx/20240618_144212-citiasia_background.jpg', NULL, 0, '2024-06-18 14:42:12', '2024-06-18 14:42:12', 1, 1); INSERT INTO `uploads` VALUES (10, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_152209-google-cloud-icon-400w.png', 'uploads/xxx/20240618_152209-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 15:22:09', '2024-06-18 15:22:09', 1, 1); INSERT INTO `uploads` VALUES (11, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_152235-citiasia_background.jpg', 'uploads/xxx/20240618_152235-citiasia_background.jpg', NULL, 0, '2024-06-18 15:22:35', '2024-06-18 15:22:35', 1, 1); INSERT INTO `uploads` VALUES (12, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_153052-google-cloud-icon-400w.png', 'uploads/xxx/20240618_153052-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 15:30:52', '2024-06-18 15:30:52', 1, 1); INSERT INTO `uploads` VALUES (13, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_153106-citiasia_background.jpg', 'uploads/xxx/20240618_153106-citiasia_background.jpg', NULL, 0, '2024-06-18 15:31:06', '2024-06-18 15:31:06', 1, 1); INSERT INTO `uploads` VALUES (14, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_153652-google-cloud-icon-400w.png', 'uploads/xxx/20240618_153652-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 15:36:52', '2024-06-18 15:36:52', 1, 1); INSERT INTO `uploads` VALUES (15, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_153717-citiasia_background.jpg', 'uploads/xxx/20240618_153717-citiasia_background.jpg', NULL, 0, '2024-06-18 15:37:18', '2024-06-18 15:37:18', 1, 1); INSERT INTO `uploads` VALUES (16, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_154817-google-cloud-icon-400w.png', 'uploads/xxx/20240618_154817-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 15:48:18', '2024-06-18 15:48:18', 1, 1); INSERT INTO `uploads` VALUES (17, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_154832-citiasia_background.jpg', 'uploads/xxx/20240618_154832-citiasia_background.jpg', NULL, 0, '2024-06-18 15:48:32', '2024-06-18 15:48:32', 1, 1); INSERT INTO `uploads` VALUES (18, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_155414-google-cloud-icon-400w.png', 'uploads/xxx/20240618_155414-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 15:54:14', '2024-06-18 15:54:14', 1, 1); INSERT INTO `uploads` VALUES (19, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_155439-citiasia_background.jpg', 'uploads/xxx/20240618_155439-citiasia_background.jpg', NULL, 0, '2024-06-18 15:54:40', '2024-06-18 15:54:40', 1, 1); INSERT INTO `uploads` VALUES (20, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_160201-citiasia_background.jpg', 'uploads/xxx/20240618_160201-citiasia_background.jpg', NULL, 0, '2024-06-18 16:02:02', '2024-06-18 16:02:02', 1, 1); INSERT INTO `uploads` VALUES (21, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_160204-google-cloud-icon-400w.png', 'uploads/xxx/20240618_160204-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:02:04', '2024-06-18 16:02:04', 1, 1); INSERT INTO `uploads` VALUES (22, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_160407-google-cloud-icon-400w.png', 'uploads/xxx/20240618_160407-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:04:07', '2024-06-18 16:04:07', 1, 1); INSERT INTO `uploads` VALUES (23, 'citiasia background', 'jpg', '.jpg', '54426', '20240618_160413-citiasia_background.jpg', 'uploads/xxx/20240618_160413-citiasia_background.jpg', NULL, 0, '2024-06-18 16:04:13', '2024-06-18 16:04:13', 1, 1); INSERT INTO `uploads` VALUES (24, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_161204-google-cloud-icon-400w.png', 'uploads/xxx/20240618_161204-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:12:04', '2024-06-18 16:12:04', 1, 1); INSERT INTO `uploads` VALUES (25, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_161558-google-cloud-icon-400w.png', 'uploads/xxx/20240618_161558-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:15:58', '2024-06-18 16:15:58', 1, 1); INSERT INTO `uploads` VALUES (26, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_161925-google-cloud-icon-400w.png', 'uploads/xxx/20240618_161925-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:19:25', '2024-06-18 16:19:25', 1, 1); INSERT INTO `uploads` VALUES (27, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_161931-google-cloud-icon-400w.png', 'uploads/xxx/20240618_161931-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:19:31', '2024-06-18 16:19:31', 1, 1); INSERT INTO `uploads` VALUES (28, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_162048-google-cloud-icon-400w.png', 'uploads/xxx/20240618_162048-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:20:48', '2024-06-18 16:20:48', 1, 1); INSERT INTO `uploads` VALUES (29, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_162111-google-cloud-icon-400w.png', 'uploads/xxx/20240618_162111-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:21:11', '2024-06-18 16:21:11', 1, 1); INSERT INTO `uploads` VALUES (30, 'google-cloud-icon-400w', 'png', '.png', '10024', '20240618_162124-google-cloud-icon-400w.png', 'uploads/xxx/20240618_162124-google-cloud-icon-400w.png', NULL, 0, '2024-06-18 16:21:25', '2024-06-18 16:21:25', 1, 1); -- ---------------------------- -- Table structure for user_levels -- ---------------------------- DROP TABLE IF EXISTS `user_levels`; CREATE TABLE `user_levels` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of user_levels -- ---------------------------- INSERT INTO `user_levels` VALUES (1, 'Super Admin', NULL, 0, '2024-06-09 11:19:40', '2024-06-09 11:19:40', NULL, NULL); INSERT INTO `user_levels` VALUES (2, 'User', NULL, 0, '2024-06-09 11:19:40', '2024-06-09 11:19:40', NULL, NULL); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `level_id` int NOT NULL, `username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `picture` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `last_login` timestamp NULL DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, `dob` date NULL DEFAULT NULL, `gender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `religion` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `education` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `nip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `nik` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `division_id` int NULL DEFAULT NULL, `role_id` int NULL DEFAULT NULL, `department_id` int NULL DEFAULT NULL, `contract_date` date NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `users_username_unique`(`username` ASC) USING BTREE, UNIQUE INDEX `users_email_unique`(`email` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, 1, 'admin', '$2y$12$tVtzrEGkLbZZqs1qfNOIj.ZJTV2WV5YsR0Exl5qQzRLtkkRDA1U2C', 'Admin', 'admin@gmail.com', 'uploads/xxx/noimage.jpg', '2024-06-18 16:12:16', '2024-06-09 11:19:40', 'pwCOz4kIQf', NULL, 0, '2024-06-09 11:19:40', '2024-06-18 16:12:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for visions -- ---------------------------- DROP TABLE IF EXISTS `visions`; CREATE TABLE `visions` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NULL DEFAULT NULL, `updated_by` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC ; -- ---------------------------- -- Records of visions -- ---------------------------- INSERT INTO `visions` VALUES (1, 'SEMANGAT', 'uploads/xxx/visi-misi-1.png', 'Prajurit KOREM 073/Makutarama memiliki keinginan yang sangat kuat,\r\n sebagai suatu perasaan yang sangat mendasar dari suatu cita - cita yang luhur, dari hal\r\n tersebut maka akan menimbulkan tingkat keinginan yang tinggi untuk selalu belajar dan\r\n berlatih guna menjadi prajurit yang profesional.', NULL, 1, '2024-06-09 21:02:08', NULL, 1, NULL); INSERT INTO `visions` VALUES (2, 'EMPATI', 'uploads/xxx/visi-misi-2.png', 'Prajurit KOREM 073/makutarama dalam menjalankan tugas dan tanggung\r\n jawabnya memiliki kepedulian yang tinggi yang timbul dari keinginan untuk selalu hadir\r\n saat masyarakat disekitarnya mengalami musibah, sehingga dari keinginan ini timbul\r\n kesadaran dalam diri pribadi prajurit untuk melayani dengan sepenuh hati apa yang\r\n menjadi hak dan kepentingan dari masyarakat serta sesama prajurit lain di sekitarnya.', NULL, 1, '2024-06-09 21:02:08', NULL, 1, NULL); INSERT INTO `visions` VALUES (3, 'JUJUR', 'uploads/xxx/visi-misi-3.png', 'Prajurit KOREM 073/Makutarama mengutamakan kejujuran sebagai pedoman\r\n dalam melaksanakan tugasnya, Jujur artinya dapat dipercaya baik dari tindakan maupun\r\n perkataan sehingga dalam segala tindakan dan perbuatannya potensi untuk berbuat\r\n kecurangan tidak akan pernah terjadi.', NULL, 1, '2024-06-09 21:02:08', NULL, 1, NULL); INSERT INTO `visions` VALUES (4, 'ADAPTIF', 'uploads/xxx/visi-misi-4.png', 'Prajurit KOREM 073/Makutarama memiliki kemampuan untuk selalu\r\n bersinergi dan selalu menyesuaikan dengan kepentingan dari seluruh masyarakat diwilayah\r\n dalam setiap pelaksanaan tugasnya sehingga akan menimbulkan persamaan visi dan misi\r\n dalam mencapai satu tujuan kearah yang lebih baik.', NULL, 1, '2024-06-09 21:02:08', NULL, 1, NULL); INSERT INTO `visions` VALUES (5, 'TRANSPARAN', 'uploads/xxx/visi-misi-5.png', 'Prajurit KOREM 073/Makutarama memiliki sikap terbuka dan mau menerima\r\n kekurangannya untuk segera melaksanakan perbaikan - perbaikan dalam rangka meningkatkan\r\n pelayanan kepada publik diwilayah tugas dan tanggung jawabnya.', NULL, 1, '2024-06-09 21:02:08', NULL, 1, NULL); INSERT INTO `visions` VALUES (6, 'INOVATIF', 'uploads/xxx/visi-misi-6.png', 'Prajurit KOREM 073/Makutarama selalu memiliki keinginan untuk\r\n mengembangkan segala usaha dengan mendayagunakan pemikiran serta kemampuannya dalam\r\n berbuat untuk menghasilkan sesuatu yang baru dan bermanfaat baik bagi dirinya sendiri\r\n ataupun masyarakat dilingkungannya.', NULL, 1, '2024-06-09 21:02:08', NULL, 1, NULL); SET FOREIGN_KEY_CHECKS = 1;