/* Navicat Premium Data Transfer Source Server : MySQL Local Docker Source Server Type : MySQL Source Server Version : 80402 (8.4.2) Source Host : localhost:3307 Source Schema : elefan_operation Target Server Type : MySQL Target Server Version : 80402 (8.4.2) File Encoding : 65001 Date: 23/10/2024 21:49:50 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for attendances -- ---------------------------- DROP TABLE IF EXISTS `attendances`; CREATE TABLE `attendances` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `checkin` datetime NULL DEFAULT NULL, `checkout` datetime NULL DEFAULT NULL, `checkin_lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `checkin_long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `checkin_distance` double NULL DEFAULT NULL, `checkin_address` 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, `checkout_lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `checkout_long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `checkout_distance` double NULL DEFAULT NULL, `checkout_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for clients -- ---------------------------- DROP TABLE IF EXISTS `clients`; CREATE TABLE `clients` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `province` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pic` 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, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for divisions -- ---------------------------- DROP TABLE IF EXISTS `divisions`; CREATE TABLE `divisions` ( `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 = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for log_actions -- ---------------------------- DROP TABLE IF EXISTS `log_actions`; CREATE TABLE `log_actions` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `datetime` datetime NULL DEFAULT NULL, `table` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `table_id` int NULL DEFAULT NULL, `action` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `data` json NULL, `user_id` int NULL DEFAULT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `created_at` datetime NULL DEFAULT NULL, `updated_at` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 69 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 = 662 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for overtimes -- ---------------------------- DROP TABLE IF EXISTS `overtimes`; CREATE TABLE `overtimes` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `date` date NULL DEFAULT NULL, `hour` int NOT NULL DEFAULT 0, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `status` 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, `description` 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, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for pages -- ---------------------------- DROP TABLE IF EXISTS `pages`; CREATE TABLE `pages` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` 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_short` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `description_long` 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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for permits -- ---------------------------- DROP TABLE IF EXISTS `permits`; CREATE TABLE `permits` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `date` date NOT NULL, `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `status` 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, `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for products -- ---------------------------- DROP TABLE IF EXISTS `products`; CREATE TABLE `products` ( `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, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `price` decimal(15, 2) NOT NULL, `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_by` bigint UNSIGNED NULL DEFAULT NULL, `updated_by` bigint UNSIGNED NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `products_created_by_foreign`(`created_by` ASC) USING BTREE, INDEX `products_updated_by_foreign`(`updated_by` ASC) USING BTREE, CONSTRAINT `products_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `products_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for projects -- ---------------------------- DROP TABLE IF EXISTS `projects`; CREATE TABLE `projects` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` int NOT NULL, `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for roles -- ---------------------------- DROP TABLE IF EXISTS `roles`; CREATE TABLE `roles` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `division_id` int NOT NULL, `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 = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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; -- ---------------------------- -- 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 = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; INSERT INTO `settings` VALUES (1, 'text', 'name', 'Elefan Opearation', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (2, 'text', 'copyright', 'Copyright @2024 Elefan', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (3, 'longtext', 'footer-about', 'Lorem Ipsum', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (4, 'text', 'address', 'Bandung', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (5, 'text', 'phone', '085', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (6, 'text', 'email', 'info@elefan.co.id', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (7, 'text', 'socmed-twitter', 'http://google.com', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (8, 'text', 'socmed-instagram', 'http://google.com', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (9, 'text', 'socmed-linkedin', 'http://google.com', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (10, 'text', 'socmed-facebook', 'http://google.com', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (11, 'wysiwyg', 'faq-description', 'Lorem Ipsum', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (12, 'longtext', 'contact-map', 'https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d123505.75790910245!2d121.05573800000002!3d14.681181!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3397ba0942ef7375%3A0x4a9a32d9fe083d40!2sQuezon%20City%2C%20Metro%20Manila%2C%20Philippines!5e0!3m2!1sen!2sus!4v1676356596840!5m2!1sen!2sus', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (13, 'wysiwyg', 'about-content', '

HTML Ipsum Presents

', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (14, 'image', 'favicon', 'favicon.ico', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (15, 'text', 'name-short', 'Operation', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (16, 'longtext', 'seo-description', 'Elefan adalah', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (17, 'longtext', 'seo-keywords', 'design, blueprint', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (18, 'longtext', 'seo-author', 'Elefan', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (19, 'longtext', 'seo-keyphrases', '', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (20, 'longtext', 'seo-mytopic', 'smartcity', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (21, 'longtext', 'seo-classification', 'public', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (22, 'longtext', 'seo-robots', '', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (23, 'image', 'app-logo', 'favicon.ico', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `settings` VALUES (24, 'image', 'app-logo-footer', 'favicon.ico', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); -- ---------------------------- -- Table structure for tasks -- ---------------------------- DROP TABLE IF EXISTS `tasks`; CREATE TABLE `tasks` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` int NOT NULL, `project_id` int NOT NULL, `user_id` int NOT NULL, `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `due_date` date NULL DEFAULT NULL, `priority` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `tags` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `progress` int NULL DEFAULT NULL, `image` 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 = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; INSERT INTO `user_levels` VALUES (1, 'Super Admin', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `user_levels` VALUES (2, 'Manager', NULL, 1, '2024-09-10 14:32:01', '2024-09-10 14:32:01', NULL, NULL); INSERT INTO `user_levels` VALUES (3, 'Staff', NULL, 1, '2024-09-11 09:16:45', '2024-09-11 09:16:47', NULL, NULL); INSERT INTO `user_levels` VALUES (4, 'BOD', NULL, 1, '2024-09-19 11:16:40', '2024-09-19 11:16:42', 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, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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, `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `picture` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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, `division_id` int NULL DEFAULT NULL, `role_id` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `users_email_unique`(`email` ASC) USING BTREE, UNIQUE INDEX `users_username_unique`(`username` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; INSERT INTO `users` VALUES (1, 1, 'admin@gmail.com', 'admin', '$2y$12$ro85mMCV0J64bHeyyf10Y.riYQQkvAgJncg/tSVBhWYLzl17KZ25a', 'Admin', '081', 'avtar_1.png', 'Bandung', '2024-10-23 21:25:19', '2024-09-10 14:32:00', 'yaQ8uMi4J9', NULL, 1, '2024-09-10 14:32:01', '2024-10-23 21:25:19', 1, NULL, 2, 3); INSERT INTO `users` VALUES (2, 3, 'staff@gmail.com', 'staff', 'as', 'staff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 2); INSERT INTO `users` VALUES (3, 2, 'manager@gmail.com', 'manager', '', 'manager', '081', 'avtar_1.png', NULL, NULL, NULL, NULL, NULL, 1, '2024-09-16 14:11:13', '2024-09-30 10:57:56', 1, NULL, 1, 2); INSERT INTO `users` VALUES (4, 4, 'bod@gmail.com', 'bod', 'as', 'bod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 2); INSERT INTO `users` VALUES (5, 2, 'gelar@gmail.com', 'gelar', '$2y$12$f6LPI9nJSH6CeZz8LI2SAeNcqURHePBwn5HV1u3AMI6nyKihCwdau', 'Gelar Aditya Pratama', '081', 'avtar_1.png', 'bandung', '2024-10-23 20:49:56', NULL, NULL, NULL, 1, '2024-09-16 14:11:13', '2024-10-23 20:49:56', 1, NULL, 1, 2); DROP TABLE IF EXISTS `letters`; CREATE TABLE `letters` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` date NOT NULL, `number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `from` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `to` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `signature` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `content` longtext 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 = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of letters -- ---------------------------- INSERT INTO `letters` VALUES (1, 'Permohonan Presentasi', 'Bandung', '2024-10-01', '521/SPR/DGCR/IX/2024', 'Digicare', 'RSUD Gunung Jati Kota Cirebon', 'Ayu Pramesti\r\nManager Sales', '{\"pic\": \"Kia 083876973707\", \"solution\": \"

1. Artificial Intelligence (AI): Teknologi AI untuk meningkatkan efisiensi operasional dan kualitas layanan kesehatan.

2. Blockchain : Penerapan blockchain untuk keamanan data medis dan ekosistem tertutup.

3. Telemedicine : Solusi ERP/SIMARS untuk mendukung layanan telemedicine yang efisien.

\"}', NULL, 0, '2024-10-24 07:55:25', NULL, 1, NULL); INSERT INTO `letters` VALUES (2, 'Permohonan Presentasi', 'Bandung', '2024-10-01', '521/SPR/DGCR/IX/2024', 'Digicare', 'RSUD Gunung Jati Kota Cirebon', 'Ayu Pramesti\r\nManager Sales', '{\"pic\": \"Kia 083876973707\", \"solution\": \"1. Artificial Intelligence (AI): Teknologi AI untuk meningkatkan efisiensi operasional dan kualitas layanan kesehatan.\\n2. Blockchain : Penerapan blockchain untuk keamanan data medis dan ekosistem tertutup.\\n3. Telemedicine : Solusi ERP/SIMARS untuk mendukung layanan telemedicine yang efisien.\"}', NULL, 0, '2024-10-24 10:13:32', '2024-10-24 10:13:32', 5, 5); INSERT INTO `letters` VALUES (4, 'Permohonan Presentasi', 'bali', '2024-10-24', '123', 'PT. Bentala Bahagia Bersama', 'Pemprov', 'gelar\nEM', '{\"pic\":\"gelar 123\",\"solution\":\"6\"}', NULL, 0, '2024-10-24 15:11:38', '2024-10-24 15:11:38', 5, 5); INSERT INTO `letters` VALUES (5, 'Permohonan Presentasi', 'Bandung', '2024-10-24', 'XYZ-123', 'PT. Elefan Adiwidia Bentala', 'Pemprov Jabar', 'Gelar\nEM', '{\"pic\":\"asd\",\"solution\":\"solusi\\n1.\\n2.\\n3.\\n4.\\n5.\"}', NULL, 0, '2024-10-24 15:13:25', '2024-10-24 15:13:25', 5, 5); SET FOREIGN_KEY_CHECKS = 1;