-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 8.0.30 - MySQL Community Server - GPL -- Server OS: Win64 -- HeidiSQL Version: 12.1.0.6537 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Dumping structure for table erp_furniture_4.komentar_tasks CREATE TABLE IF NOT EXISTS `komentar_tasks` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL, `task_lapangans_id` int unsigned NOT NULL, `deskripsi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `url_gambar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `induk_komentar_id` int DEFAULT NULL, `sub_komentar_level` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table erp_furniture_4.komentar_tasks: ~13 rows (approximately) INSERT INTO `komentar_tasks` (`id`, `user_id`, `task_lapangans_id`, `deskripsi`, `url_gambar`, `induk_komentar_id`, `sub_komentar_level`, `created_at`, `updated_at`) VALUES (4, 1, 1, 'gsegseg', NULL, NULL, 1, '2024-11-22 07:18:11', '2024-11-22 07:18:11'), (5, 1, 1, 'semangat sekali dengan karamansan ', NULL, 4, 2, '2024-11-22 07:19:45', '2024-11-22 07:19:45'), (6, 1, 1, 'aegegegewgege', NULL, NULL, 1, '2024-11-22 07:20:00', '2024-11-22 07:20:00'), (7, 1, 7, 'ah ah ah ah ah ah ah ah a h a ha ha ha ha ha ha ha ha', NULL, NULL, 1, '2024-11-22 07:41:35', '2024-11-22 07:41:35'), (8, 1, 1, 'rgwwe', NULL, 4, 2, '2024-11-22 08:10:52', '2024-11-22 08:10:52'), (9, 1, 1, 'gegwe', NULL, NULL, 1, '2024-11-22 08:11:33', '2024-11-22 08:11:33'), (10, 1, 1, 'gegegege', NULL, NULL, 1, '2024-11-22 08:11:39', '2024-11-22 08:11:39'), (11, 1, 1, 'gegegege', NULL, 10, 2, '2024-11-22 08:11:48', '2024-11-22 08:11:48'), (12, 1, 1, 'gegewgawegwegwe', NULL, 10, 2, '2024-11-22 08:11:52', '2024-11-22 08:11:52'), (13, 1, 16, 'Oke gaes', NULL, NULL, 1, '2024-11-22 09:48:36', '2024-11-22 09:48:36'), (14, 1, 13, 'Bahaba sd', NULL, NULL, 1, '2024-11-22 09:49:10', '2024-11-22 09:49:10'), (15, 1, 16, 'Oka oke Oka oke ndasem', NULL, 13, 2, '2024-11-22 10:02:10', '2024-11-22 10:02:10'), (16, 1, 12, 'Shshsjsjs', NULL, NULL, 1, '2024-11-22 10:03:33', '2024-11-22 10:03:33'); -- Dumping structure for table erp_furniture_4.task_lapangans CREATE TABLE IF NOT EXISTS `task_lapangans` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `kanban_lapangans_id` bigint unsigned NOT NULL, `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `deskripsi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `urutan` int NOT NULL, `url_gambar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `induk_taks_id` int DEFAULT NULL, `taks_level` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table erp_furniture_4.task_lapangans: ~14 rows (approximately) INSERT INTO `task_lapangans` (`id`, `user_id`, `kanban_lapangans_id`, `judul`, `deskripsi`, `status`, `urutan`, `url_gambar`, `induk_taks_id`, `taks_level`, `created_at`, `updated_at`) VALUES (1, 1, 3, 'Task pertama', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Normal', 3, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (5, 2, 3, 'Task kedua', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Normal', 5, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (6, 2, 3, 'Task ketiga', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Urgen', 4, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (7, 2, 3, 'Task keempat', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Warning', 1, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (8, 2, 3, 'Task keempat', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Warning', 6, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (9, 2, 3, 'Task keempat', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Low', 7, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (10, 2, 3, 'Task keempat', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Low', 8, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (11, 2, 2, 'Task keempat', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Low', 1, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:36'), (12, 2, 3, 'Task keempat', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Normal', 2, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:28'), (13, 2, 1, 'Task keempat', ' a goigegiegjeikg wegwe goeigjweog wagoiawejg aeignaeogn agoawengoea ngawe gnaeoignae', 'Normal', 1, NULL, NULL, 1, '2024-11-22 06:59:16', '2024-11-22 18:24:36'), (14, 1, 3, 'Kadung menambah delima', 'semarak seruduk kadung salaklisa', 'Normal', 10, NULL, NULL, 1, '2024-11-22 07:42:23', '2024-11-22 18:24:28'), (15, 1, 3, 'mempercepat semangat dan bantab', 'ksdf jsdklf klasd mklasdfj msedkldf asdklfjksd klwd fj sklf ', 'Low', 9, 'taks/Lb3OZLWTjxvVtdwqwmIEfCT0CywlQuwJUiyu89WJ.jpg', NULL, 1, '2024-11-22 08:18:39', '2024-11-22 18:24:28'), (16, 1, 4, 'INSTALASI LAMPU GUDANG BAWU', 'Cari tukang listrik / wong harian / kerjakan sendiri yg penting maximal 2 hari lagi Jadi', 'Warning', 2, NULL, NULL, 1, '2024-11-22 08:53:26', '2024-11-22 18:22:12'), (17, 1, 4, 'WANITA BERJILBAB ABU ABU', 'Oke, ini hanya contoh saja dan akan tampil di thumbnail cuma 70 karakter pertama', 'Low', 1, 'taks/ryCve5JDLVhyv2PYjA6ceUqGB2as6ejdJe1S8kKC.jpg', NULL, 1, '2024-11-22 09:55:22', '2024-11-22 18:22:12'); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;