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