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


-- ----------------------------
-- Table structure for 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
-- ----------------------------
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) <br><br>\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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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
-- ----------------------------
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);

-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------

-- ----------------------------
-- Table structure for 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 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) <br> 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) <br> 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
-- ----------------------------
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 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 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);

