/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 100413 Source Host : localhost:3306 Source Schema : mpt Target Server Type : MySQL Target Server Version : 100413 File Encoding : 65001 Date: 29/12/2020 10:29:17 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for failed_jobs -- ---------------------------- DROP TABLE IF EXISTS `failed_jobs`; CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0), PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of failed_jobs -- ---------------------------- -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of migrations -- ---------------------------- INSERT INTO `migrations` VALUES (1, '2014_10_12_100000_create_password_resets_table', 1); INSERT INTO `migrations` VALUES (2, '2019_08_19_000000_create_failed_jobs_table', 1); INSERT INTO `migrations` VALUES (3, '2020_11_07_171253_create_permits_table', 1); INSERT INTO `migrations` VALUES (4, '2020_12_07_112404_create_reference_tables_table', 1); INSERT INTO `migrations` VALUES (5, '2020_12_19_021349_create_user_group_mappings_table', 1); INSERT INTO `migrations` VALUES (6, '2020_12_19_132602_create_user_groups_table', 1); INSERT INTO `migrations` VALUES (7, '2014_10_12_000000_create_users_table', 2); INSERT INTO `migrations` VALUES (8, '2020_12_05_135713_add_pengguna_detail', 2); INSERT INTO `migrations` VALUES (9, '2020_12_20_053105_change_email_nullable', 2); INSERT INTO `migrations` VALUES (10, '2020_12_28_014347_change_status_length', 3); -- ---------------------------- -- Table structure for password_resets -- ---------------------------- DROP TABLE IF EXISTS `password_resets`; CREATE TABLE `password_resets` ( `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, INDEX `password_resets_email_index`(`email`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of password_resets -- ---------------------------- -- ---------------------------- -- Table structure for permits -- ---------------------------- DROP TABLE IF EXISTS `permits`; CREATE TABLE `permits` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `jenis` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `no_kp` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `alamat_pemohon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `no_telefon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `tarikh_permohonan` date NULL DEFAULT NULL, `tujuan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `alamat_tempat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `tarikh_mula` date NULL DEFAULT NULL, `jam_mula` time(0) NULL DEFAULT NULL, `tarikh_tamat` date NULL DEFAULT NULL, `jam_tamat` time(0) NULL DEFAULT NULL, `bayaran` double(7, 2) NULL DEFAULT NULL, `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `userid` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) 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 permits -- ---------------------------- INSERT INTO `permits` VALUES (2, 'PETAK', 'Haizal', '789789789789', 'NO 1 JALAN ALAM SURIA 16/30 BANDAR PUNCAK ALAM KUALA SELANGOR', '7978978', '2020-12-26', 'KENDURI AQIQAH ANAK', 'uiii', '2020-12-07', '13:00:12', '2020-12-15', '14:00:12', 10.00, 'LULUS', '1', '2020-12-26 04:07:03', '2020-12-28 16:26:19'); INSERT INTO `permits` VALUES (4, 'TUTUP', 'GJHJ', '678786786786', 'YTYUTYU', '567567', '2020-12-26', 'TYUT', 'IUIUI', '2020-12-28', '12:00:12', '2020-12-30', '13:00:12', 25.00, 'PROSES', '3', '2020-12-26 05:11:38', '2020-12-26 05:11:38'); -- ---------------------------- -- Table structure for reference_tables -- ---------------------------- DROP TABLE IF EXISTS `reference_tables`; CREATE TABLE `reference_tables` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ranking` int(10) UNSIGNED NULL DEFAULT NULL, `mastercode` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `referencecode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `description1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `groupcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 124 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of reference_tables -- ---------------------------- INSERT INTO `reference_tables` VALUES (1, NULL, 'XXX', '10001', 'BANGSA', NULL, '2020-12-26 02:18:18', '2020-12-26 02:18:18'); INSERT INTO `reference_tables` VALUES (2, 1, '10001', 'MELAYU', 'MELAYU', NULL, '2020-12-26 02:20:21', NULL); INSERT INTO `reference_tables` VALUES (3, 2, '10001', 'CINA', 'CINA', NULL, '2020-12-26 02:20:28', NULL); INSERT INTO `reference_tables` VALUES (4, 3, '10001', 'INDIA', 'INDIA', NULL, '2020-12-26 02:20:33', NULL); INSERT INTO `reference_tables` VALUES (5, 4, '10001', 'LAIN-LAIN', 'LAIN-LAIN', NULL, '2020-12-26 02:20:40', NULL); INSERT INTO `reference_tables` VALUES (6, NULL, 'XXX', '10002', 'TARAF PERKAHWINAN', NULL, '2020-12-26 02:20:59', '2020-12-26 02:20:59'); INSERT INTO `reference_tables` VALUES (7, 1, '10002', 'KAHWIN', 'KAHWIN', NULL, '2020-12-26 02:21:17', NULL); INSERT INTO `reference_tables` VALUES (8, 2, '10002', 'TIDAK BERKAHWIN', 'TIDAK BERKAHWIN', NULL, '2020-12-26 02:21:26', NULL); INSERT INTO `reference_tables` VALUES (9, 3, '10002', 'BUJANG', 'BUJANG', NULL, '2020-12-26 02:21:33', NULL); INSERT INTO `reference_tables` VALUES (10, 4, '10002', 'DUDA', 'DUDA', NULL, '2020-12-26 02:21:40', NULL); INSERT INTO `reference_tables` VALUES (11, 5, '10002', 'JANDA', 'JANDA', NULL, '2020-12-26 02:21:49', NULL); INSERT INTO `reference_tables` VALUES (12, NULL, 'XXX', '10003', 'JABATAN', NULL, '2020-12-26 02:23:04', '2020-12-26 02:23:04'); INSERT INTO `reference_tables` VALUES (13, 1, '10003', 'N54', 'N54', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:23:28', NULL); INSERT INTO `reference_tables` VALUES (14, 2, '10003', 'N52', 'N52', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:23:37', NULL); INSERT INTO `reference_tables` VALUES (15, 3, '10003', 'M52', 'M52', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:23:45', NULL); INSERT INTO `reference_tables` VALUES (16, 4, '10003', 'L52', 'L52', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:23:52', NULL); INSERT INTO `reference_tables` VALUES (17, 5, '10003', 'U52', 'U52', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:24:02', NULL); INSERT INTO `reference_tables` VALUES (18, 6, '10003', 'J52', 'J52', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:24:11', NULL); INSERT INTO `reference_tables` VALUES (19, 7, '10003', 'W51', 'W51', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:24:18', NULL); INSERT INTO `reference_tables` VALUES (20, 8, '10003', 'W52', 'W52', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:24:25', NULL); INSERT INTO `reference_tables` VALUES (21, 9, '10003', 'GV52', 'GV52', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:24:33', NULL); INSERT INTO `reference_tables` VALUES (22, 10, '10003', 'U48', 'U48', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:24:45', NULL); INSERT INTO `reference_tables` VALUES (23, 11, '10003', 'N48', 'N48', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:24:54', NULL); INSERT INTO `reference_tables` VALUES (24, 12, '10003', 'J48', 'J48', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:25:41', NULL); INSERT INTO `reference_tables` VALUES (25, 13, '10003', 'GV48', 'GV48', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:25:55', NULL); INSERT INTO `reference_tables` VALUES (26, 14, '10003', 'WA48', 'WA48', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:26:07', NULL); INSERT INTO `reference_tables` VALUES (27, 15, '10003', 'W48', 'W48', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:26:15', NULL); INSERT INTO `reference_tables` VALUES (28, 16, '10003', 'J44', 'J44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:26:22', NULL); INSERT INTO `reference_tables` VALUES (29, 17, '10003', 'N44', 'N44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:26:29', NULL); INSERT INTO `reference_tables` VALUES (30, 18, '10003', 'WA44', 'WA44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:26:38', NULL); INSERT INTO `reference_tables` VALUES (31, 19, '10003', 'U44', 'U44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:26:48', NULL); INSERT INTO `reference_tables` VALUES (32, 20, '10003', 'GV44', 'GV44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:26:56', NULL); INSERT INTO `reference_tables` VALUES (33, 21, '10003', 'L44', 'L44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:04', NULL); INSERT INTO `reference_tables` VALUES (34, 22, '10003', 'S44', 'S44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:12', NULL); INSERT INTO `reference_tables` VALUES (35, 23, '10003', 'J44', 'J44', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:22', NULL); INSERT INTO `reference_tables` VALUES (36, 24, '10003', 'U42', 'U42', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:28', NULL); INSERT INTO `reference_tables` VALUES (37, 25, '10003', 'J41', 'J41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:35', NULL); INSERT INTO `reference_tables` VALUES (38, 26, '10003', 'N41', 'N41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:40', NULL); INSERT INTO `reference_tables` VALUES (39, 27, '10003', 'S41', 'S41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:46', NULL); INSERT INTO `reference_tables` VALUES (40, 28, '10003', 'WA41', 'WA41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:52', NULL); INSERT INTO `reference_tables` VALUES (41, 29, '10003', 'W41', 'W41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:27:59', NULL); INSERT INTO `reference_tables` VALUES (42, 30, '10003', 'U41', 'U41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:28:05', NULL); INSERT INTO `reference_tables` VALUES (43, 31, '10003', 'GV41', 'GV41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:28:13', NULL); INSERT INTO `reference_tables` VALUES (44, 32, '10003', 'L41', 'L41', 'PENGURUSAN DAN PROFESIONAL (A)', '2020-12-26 02:28:20', NULL); INSERT INTO `reference_tables` VALUES (45, 33, '10003', 'JA36', 'JA36', 'SOKONGAN 1 (B)', '2020-12-26 02:28:46', NULL); INSERT INTO `reference_tables` VALUES (46, 34, '10003', 'W36', 'W36', 'SOKONGAN 1 (B)', '2020-12-26 02:29:01', NULL); INSERT INTO `reference_tables` VALUES (47, 35, '10003', 'G36', 'G36', 'SOKONGAN 1 (B)', '2020-12-26 02:29:09', NULL); INSERT INTO `reference_tables` VALUES (48, 36, '10003', 'N36', 'N36', 'SOKONGAN 1 (B)', '2020-12-26 02:29:14', NULL); INSERT INTO `reference_tables` VALUES (49, 37, '10003', 'U36', 'U36', 'SOKONGAN 1 (B)', '2020-12-26 02:29:21', NULL); INSERT INTO `reference_tables` VALUES (50, 38, '10003', 'W36', 'W36', 'SOKONGAN 1 (B)', '2020-12-26 02:29:27', NULL); INSERT INTO `reference_tables` VALUES (51, 39, '10003', 'W32', 'W32', 'SOKONGAN 1 (B)', '2020-12-26 02:29:34', NULL); INSERT INTO `reference_tables` VALUES (52, 40, '10003', 'G32', 'G32', 'SOKONGAN 1 (B)', '2020-12-26 02:29:39', NULL); INSERT INTO `reference_tables` VALUES (53, 41, '10003', 'N32', 'N32', 'SOKONGAN 1 (B)', '2020-12-26 02:29:44', NULL); INSERT INTO `reference_tables` VALUES (54, 42, '10003', 'L32', 'L32', 'SOKONGAN 1 (B)', '2020-12-26 02:29:50', NULL); INSERT INTO `reference_tables` VALUES (55, 43, '10003', 'U32', 'U32', 'SOKONGAN 1 (B)', '2020-12-26 02:29:55', NULL); INSERT INTO `reference_tables` VALUES (56, 44, '10003', 'KP32', 'KP32', 'SOKONGAN 1 (B)', '2020-12-26 02:30:00', NULL); INSERT INTO `reference_tables` VALUES (57, 45, '10003', 'FA32', 'FA32', 'SOKONGAN 1 (B)', '2020-12-26 02:30:07', NULL); INSERT INTO `reference_tables` VALUES (58, 46, '10003', 'JA29', 'JA29', 'SOKONGAN 1 (B)', '2020-12-26 02:30:13', NULL); INSERT INTO `reference_tables` VALUES (59, 47, '10003', 'U29', 'U29', 'SOKONGAN 1 (B)', '2020-12-26 02:30:23', NULL); INSERT INTO `reference_tables` VALUES (60, 48, '10003', 'L29', 'L29', 'SOKONGAN 1 (B)', '2020-12-26 02:30:28', NULL); INSERT INTO `reference_tables` VALUES (61, 49, '10003', 'FA29', 'FA29', 'SOKONGAN 1 (B)', '2020-12-26 02:30:34', NULL); INSERT INTO `reference_tables` VALUES (62, 50, '10003', 'W29', 'W29', 'SOKONGAN 1 (B)', '2020-12-26 02:30:41', NULL); INSERT INTO `reference_tables` VALUES (63, 51, '10003', 'G29', 'G29', 'SOKONGAN 1 (B)', '2020-12-26 02:30:48', NULL); INSERT INTO `reference_tables` VALUES (64, 52, '10003', 'N29', 'N29', 'SOKONGAN 1 (B)', '2020-12-26 02:30:54', NULL); INSERT INTO `reference_tables` VALUES (65, 53, '10003', 'KP29', 'KP29', 'SOKONGAN 1 (B)', '2020-12-26 02:31:00', NULL); INSERT INTO `reference_tables` VALUES (66, 54, '10003', 'JA30', 'JA30', 'SOKONGAN 1 (B)', '2020-12-26 02:31:05', NULL); INSERT INTO `reference_tables` VALUES (67, 55, '10003', 'N26', 'N26', 'SOKONGAN 1 (C)', '2020-12-26 02:31:15', NULL); INSERT INTO `reference_tables` VALUES (68, 56, '10003', 'G22', 'G22', 'SOKONGAN 1 (C)', '2020-12-26 02:31:23', NULL); INSERT INTO `reference_tables` VALUES (69, 57, '10003', 'W22', 'W22', 'SOKONGAN 1 (C)', '2020-12-26 02:31:34', NULL); INSERT INTO `reference_tables` VALUES (70, 58, '10003', 'J22', 'J22', 'SOKONGAN 1 (C)', '2020-12-26 02:31:39', NULL); INSERT INTO `reference_tables` VALUES (71, 59, '10003', 'N22', 'N22', 'SOKONGAN 1 (C)', '2020-12-26 02:31:44', NULL); INSERT INTO `reference_tables` VALUES (72, 60, '10003', 'JA22', 'JA22', 'SOKONGAN 1 (C)', '2020-12-26 02:31:50', NULL); INSERT INTO `reference_tables` VALUES (73, 61, '10003', 'H22', 'H22', 'SOKONGAN 1 (C)', '2020-12-26 02:31:55', NULL); INSERT INTO `reference_tables` VALUES (74, 62, '10003', 'U22', 'U22', 'SOKONGAN 1 (C)', '2020-12-26 02:32:00', NULL); INSERT INTO `reference_tables` VALUES (75, 63, '10003', 'KP22', 'KP22', 'SOKONGAN 1 (C)', '2020-12-26 02:32:05', NULL); INSERT INTO `reference_tables` VALUES (76, 64, '10003', 'C22', 'C22', 'SOKONGAN 1 (C)', '2020-12-26 02:32:10', NULL); INSERT INTO `reference_tables` VALUES (77, 65, '10003', 'J22', 'J22', 'SOKONGAN 1 (C)', '2020-12-26 02:32:15', NULL); INSERT INTO `reference_tables` VALUES (78, 66, '10003', 'JA19', 'JA19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:21', NULL); INSERT INTO `reference_tables` VALUES (79, 67, '10003', 'W19', 'W19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:26', NULL); INSERT INTO `reference_tables` VALUES (80, 68, '10003', 'N19', 'N19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:31', NULL); INSERT INTO `reference_tables` VALUES (81, 69, '10003', 'C19', 'C19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:37', NULL); INSERT INTO `reference_tables` VALUES (82, 70, '10003', 'G19', 'G19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:43', NULL); INSERT INTO `reference_tables` VALUES (83, 71, '10003', 'J19', 'J19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:48', NULL); INSERT INTO `reference_tables` VALUES (84, 72, '10003', 'H19', 'H19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:53', NULL); INSERT INTO `reference_tables` VALUES (85, 73, '10003', 'U19', 'U19', 'SOKONGAN 1 (C)', '2020-12-26 02:32:57', NULL); INSERT INTO `reference_tables` VALUES (86, 74, '10003', 'KP19', 'KP19', 'SOKONGAN 1 (C)', '2020-12-26 02:33:03', NULL); INSERT INTO `reference_tables` VALUES (87, 75, '10003', 'H14', 'H14', 'SOKONGAN 2 (D)', '2020-12-26 02:33:18', NULL); INSERT INTO `reference_tables` VALUES (88, 76, '10003', 'N14', 'N14', 'SOKONGAN 2 (D)', '2020-12-26 02:33:24', NULL); INSERT INTO `reference_tables` VALUES (89, 77, '10003', 'KP14', 'KP14', 'SOKONGAN 2 (D)', '2020-12-26 02:33:30', NULL); INSERT INTO `reference_tables` VALUES (90, 78, '10003', 'N11', 'N11', 'SOKONGAN 2 (D)', '2020-12-26 02:33:38', NULL); INSERT INTO `reference_tables` VALUES (91, 79, '10003', 'H11', 'H11', 'SOKONGAN 2 (D)', '2020-12-26 02:33:44', NULL); INSERT INTO `reference_tables` VALUES (92, 80, '10003', 'KP11', 'KP11', 'SOKONGAN 2 (D)', '2020-12-26 02:33:49', NULL); INSERT INTO `reference_tables` VALUES (93, 81, '10003', 'KP22', 'KP22', NULL, '2020-12-26 02:34:00', NULL); INSERT INTO `reference_tables` VALUES (94, 82, '10003', 'N22', 'N22', NULL, '2020-12-26 02:34:07', NULL); INSERT INTO `reference_tables` VALUES (95, 83, '10003', 'U24', 'U24', NULL, '2020-12-26 02:34:13', NULL); INSERT INTO `reference_tables` VALUES (96, 84, '10003', 'JA 38', 'JA 38', NULL, '2020-12-26 02:34:20', NULL); INSERT INTO `reference_tables` VALUES (97, NULL, 'XXX', '10004', 'JABATAN', NULL, '2020-12-26 02:35:01', '2020-12-26 02:35:01'); INSERT INTO `reference_tables` VALUES (98, 1, '10004', '010000', 'JABATAN YANG DIPERTUA', NULL, '2020-12-26 02:35:17', NULL); INSERT INTO `reference_tables` VALUES (99, 2, '10004', '010100', 'S/U PERBANDARAN', NULL, '2020-12-26 02:35:26', NULL); INSERT INTO `reference_tables` VALUES (100, 3, '10004', '010200', 'K/U AUDIT DALAMAN & KUALITI', NULL, '2020-12-26 02:35:52', NULL); INSERT INTO `reference_tables` VALUES (101, 4, '10004', '010300', 'P/UNDANG-UNDANG', NULL, '2020-12-26 02:36:03', NULL); INSERT INTO `reference_tables` VALUES (102, 5, '10004', '020000', 'P/KHIDMAT PENGURUSAN', NULL, '2020-12-26 02:36:17', NULL); INSERT INTO `reference_tables` VALUES (103, 6, '10004', '020200', 'K/U PENGUATKUASA', NULL, '2020-12-26 02:36:33', NULL); INSERT INTO `reference_tables` VALUES (104, 7, '10004', '020300', 'K/BHK SOSIAL (KPAP)', NULL, '2020-12-26 02:36:51', NULL); INSERT INTO `reference_tables` VALUES (105, 8, '10004', '020400', 'PPKP(IT)', NULL, '2020-12-26 02:37:03', NULL); INSERT INTO `reference_tables` VALUES (106, 9, '10004', '020500', 'K/B OSC', NULL, '2020-12-26 02:37:13', NULL); INSERT INTO `reference_tables` VALUES (107, 10, '10004', '030000', 'P/KEWANGAN', NULL, '2020-12-26 02:37:21', NULL); INSERT INTO `reference_tables` VALUES (108, 11, '10004', '040000', 'P/PENILAIAN DAN HARTA', NULL, '2020-12-26 02:37:32', NULL); INSERT INTO `reference_tables` VALUES (109, 12, '10004', '050000', 'P/BANGUNAN', NULL, '2020-12-26 02:37:41', NULL); INSERT INTO `reference_tables` VALUES (110, 13, '10004', '060000', 'P/KEJURUTERAAN', NULL, '2020-12-26 02:37:50', NULL); INSERT INTO `reference_tables` VALUES (111, 14, '10004', '070000', 'PPB KESIHATAN', NULL, '2020-12-26 02:38:01', NULL); INSERT INTO `reference_tables` VALUES (112, 15, '10004', '090000', 'PPP BANDAR', NULL, '2020-12-26 02:38:08', NULL); INSERT INTO `reference_tables` VALUES (113, 16, '10004', '120000', 'P/ZOO', NULL, '2020-12-26 02:38:15', NULL); INSERT INTO `reference_tables` VALUES (114, NULL, 'XXX', '10005', 'TARAF JAWATAN', NULL, '2020-12-26 02:38:55', '2020-12-26 02:38:55'); INSERT INTO `reference_tables` VALUES (115, 1, '10005', 'PEKERJA SAMBILAN HARIAN', 'PEKERJA SAMBILAN HARIAN', NULL, '2020-12-26 02:39:10', NULL); INSERT INTO `reference_tables` VALUES (116, 2, '10005', 'KONTRAK', 'KONTRAK', NULL, '2020-12-26 02:39:16', NULL); INSERT INTO `reference_tables` VALUES (117, 3, '10005', 'TETAP', 'TETAP', NULL, '2020-12-26 02:39:24', NULL); INSERT INTO `reference_tables` VALUES (118, NULL, 'XXX', '10006', 'JENIS KURSUS', NULL, '2020-12-26 02:39:56', '2020-12-26 02:39:56'); INSERT INTO `reference_tables` VALUES (119, 1, '10006', 'KURSUS', 'KURSUS', NULL, '2020-12-26 02:40:02', NULL); INSERT INTO `reference_tables` VALUES (120, 2, '10006', 'BENGKEL', 'BENGKEL', NULL, '2020-12-26 02:40:09', NULL); INSERT INTO `reference_tables` VALUES (121, 3, '10006', 'SEMINAR', 'SEMINAR', NULL, '2020-12-26 02:40:15', NULL); INSERT INTO `reference_tables` VALUES (122, 4, '10006', 'SIMPOSIUM', 'SIMPOSIUM', NULL, '2020-12-26 02:40:24', NULL); INSERT INTO `reference_tables` VALUES (123, 5, '10006', 'LAIN-LAIN', 'LAIN-LAIN', NULL, '2020-12-26 02:40:30', NULL); -- ---------------------------- -- Table structure for user_group_mappings -- ---------------------------- DROP TABLE IF EXISTS `user_group_mappings`; CREATE TABLE `user_group_mappings` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `group_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `userid` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) 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 user_group_mappings -- ---------------------------- INSERT INTO `user_group_mappings` VALUES (1, '1', '1', NULL, NULL); INSERT INTO `user_group_mappings` VALUES (2, '2', '2', '2020-12-26 02:43:46', '2020-12-26 02:46:34'); INSERT INTO `user_group_mappings` VALUES (3, '2', '3', '2020-12-26 02:48:37', '2020-12-26 02:48:37'); INSERT INTO `user_group_mappings` VALUES (4, '3', '4', '2020-12-28 01:14:03', '2020-12-28 01:14:03'); -- ---------------------------- -- Table structure for user_groups -- ---------------------------- DROP TABLE IF EXISTS `user_groups`; CREATE TABLE `user_groups` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `group_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `group_code_module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) 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 user_groups -- ---------------------------- INSERT INTO `user_groups` VALUES (1, 'ADMIN', NULL, 'ADMIN', NULL, NULL); INSERT INTO `user_groups` VALUES (2, 'STAF', NULL, 'STAF', NULL, NULL); INSERT INTO `user_groups` VALUES (3, 'PENGARAH', NULL, 'PENGARAH', NULL, NULL); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, `no_pekerja` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `no_mykad` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `tarikh_lahir` date NULL DEFAULT NULL, `jantina` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `bangsa` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `alamat_pengguna` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `tarikh_bersara` date NULL DEFAULT NULL, `taraf_perkahwinan` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `no_telefon_bimbit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `no_telefon_rumah` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `jabatan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `gred` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `warganegara` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `jawatan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `taraf_jawatan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `tarikh_mula_berkhidmat` date NULL DEFAULT NULL, `status_aktif` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 users -- ---------------------------- INSERT INTO `users` VALUES (1, 'admin', NULL, '$2y$10$z2CVI.UD6zgZSIJ8R6LhLu4NzWSiCQVVy66TvLYbSTmjXisQrdozG', NULL, '2020-12-26 02:11:11', '2020-12-26 02:11:11', NULL, 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `users` VALUES (3, 'AMIRUL FITRI', NULL, '$2y$10$V6frqy/6PEVFtsTxgTlr6.oW/FsOTSNSPiMxW0ACsq1V9W.2H.kD2', NULL, '2020-12-26 02:48:37', '2020-12-26 02:48:37', 'MPT-123', '950522085793', '1995-05-22', 'LELAKI', 'MELAYU', 'NO 1 JALAN ALAM SURIA', '2020-12-07', 'BUJANG', '0192712442', '054485555', '020400', 'L52', 'MALAYSIA', 'IT ASSISTANT', 'KONTRAK', '2020-12-30', 'Aktif'); INSERT INTO `users` VALUES (4, 'Dato Pengarah', NULL, '$2y$10$kXHXKgjkJOGCpv1TI4f6POnjdwVC.akIDyiOrzTf7mUOJTPj4SrmW', NULL, '2020-12-28 01:14:03', '2020-12-28 01:14:03', 'mpt-333', '711102085444', '1971-11-02', 'LELAKI', 'MELAYU', 'gmhjg', '2020-12-22', 'KAHWIN', '0215555', '05222222', '010200', 'N52', 'malaysia', 'pengarah', 'TETAP', '2020-12-14', 'Aktif'); SET FOREIGN_KEY_CHECKS = 1;