|
Server IP : 103.11.96.170 / Your IP : 18.218.83.143 Web Server : Microsoft-IIS/10.0 System : Windows NT WIN-F6SLGVICLOP 10.0 build 17763 (Windows Server 2016) AMD64 User : elibrary.unsap.ac.id ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : D:/localhost/../backup/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
/*
Navicat Premium Data Transfer
Source Server : maria db
Source Server Type : MySQL
Source Server Version : 101002
Source Host : localhost:3306
Source Schema : pmb_unsap
Target Server Type : MySQL
Target Server Version : 101002
File Encoding : 65001
Date: 15/02/2023 21:24:08
*/
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) NOT NULL,
`connection` text NOT NULL,
`queue` text NOT NULL,
`payload` longtext NOT NULL,
`exception` longtext NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of failed_jobs
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for konfirmasi_pembayarans
-- ----------------------------
DROP TABLE IF EXISTS `konfirmasi_pembayarans`;
CREATE TABLE `konfirmasi_pembayarans` (
`transaksi_id` char(36) NOT NULL,
`id_channel` tinyint(4) DEFAULT NULL,
`total_bayar` decimal(15,2) NOT NULL DEFAULT 0.00,
`nomor_rekening_pengirim` varchar(255) DEFAULT NULL,
`nama_rekening_pengirim` varchar(255) DEFAULT NULL,
`nama_bank_pengirim` varchar(255) DEFAULT NULL,
`desc` varchar(255) DEFAULT NULL,
`tanggal_bayar` date DEFAULT NULL,
`bukti_bayar` varchar(255) NOT NULL DEFAULT 'storage/images/users/no_photo.png',
`verified` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`transaksi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of konfirmasi_pembayarans
-- ----------------------------
BEGIN;
INSERT INTO `konfirmasi_pembayarans` VALUES ('1771f257-8fbd-4323-ab5c-48ad4693228f', NULL, 250000.00, NULL, NULL, NULL, 'Pendaftaran Online', NULL, 'storage/images/users/no_photo.png', 0, '2023-02-12 22:02:27', '2023-02-12 22:02:27');
INSERT INTO `konfirmasi_pembayarans` VALUES ('db1e8940-b606-4c7d-be21-850dde9a9dbc', NULL, 250000.00, NULL, NULL, NULL, 'Pendaftaran Online', NULL, 'storage/images/users/no_photo.png', 0, '2023-02-12 22:01:53', '2023-02-12 22:01:53');
COMMIT;
-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of migrations
-- ----------------------------
BEGIN;
INSERT INTO `migrations` VALUES (8, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (9, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1);
INSERT INTO `migrations` VALUES (10, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (11, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` VALUES (12, '2022_12_03_003035_create_user_siuters_table', 1);
INSERT INTO `migrations` VALUES (14, '2023_02_10_222436_create_transaksis_table', 3);
INSERT INTO `migrations` VALUES (19, '2022_10_16_133330_create_neomahasiswas_table', 5);
INSERT INTO `migrations` VALUES (20, '2023_02_10_223007_create_konfirmasi_pembayarans_table', 6);
INSERT INTO `migrations` VALUES (23, '2014_10_12_000000_create_users_table', 7);
INSERT INTO `migrations` VALUES (25, '2023_02_13_115041_create_persyaratans_table', 8);
COMMIT;
-- ----------------------------
-- Table structure for neomahasiswas
-- ----------------------------
DROP TABLE IF EXISTS `neomahasiswas`;
CREATE TABLE `neomahasiswas` (
`id` char(36) NOT NULL,
`id_operator` varchar(255) DEFAULT NULL,
`nim` varchar(255) DEFAULT NULL,
`id_reg_mahasiswa` varchar(255) DEFAULT NULL,
`nomor_pendaftaran` varchar(255) DEFAULT NULL,
`pin` varchar(255) DEFAULT NULL,
`is_aktif` int(11) DEFAULT NULL,
`nama_mahasiswa` varchar(255) NOT NULL,
`nisn` varchar(255) DEFAULT NULL,
`nik` varchar(255) NOT NULL,
`tempat_lahir` varchar(255) DEFAULT NULL,
`tanggal_lahir` date DEFAULT NULL,
`jenis_kelamin` varchar(255) NOT NULL,
`handphone` varchar(255) NOT NULL,
`agama` int(11) DEFAULT NULL,
`kelurahan` varchar(255) DEFAULT NULL,
`kodewilayah` varchar(255) DEFAULT NULL,
`alamat_rumah` tinytext DEFAULT NULL,
`nama_ibu_kandung` varchar(255) DEFAULT NULL,
`kodeprodi_satu` varchar(255) DEFAULT NULL,
`kodeprodi_dua` varchar(255) DEFAULT NULL,
`tanggal_masuk` date DEFAULT NULL,
`semester_masuk` varchar(255) DEFAULT NULL,
`jenis_daftar` int(11) DEFAULT NULL,
`sks_diakui` int(11) DEFAULT NULL,
`asal_sekolah` varchar(255) DEFAULT NULL,
`nomor_ijasah` varchar(255) DEFAULT NULL,
`tahun_lulus` varchar(255) DEFAULT NULL,
`jenis_pmb_daftar` int(11) DEFAULT NULL,
`kode_pt_asal` varchar(255) DEFAULT NULL,
`kode_prodi_asal` varchar(255) DEFAULT NULL,
`biaya_awal_masuk` int(11) DEFAULT NULL,
`konfirmasi` int(11) DEFAULT NULL,
`negara` varchar(255) DEFAULT NULL,
`provinsi` varchar(255) DEFAULT NULL,
`kota` varchar(255) DEFAULT NULL,
`kecamatan` varchar(255) DEFAULT NULL,
`tahun_masuk` int(11) DEFAULT NULL,
`kewarganegaraan` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `neomahasiswas_handphone_unique` (`handphone`),
UNIQUE KEY `neomahasiswas_nim_unique` (`nim`),
UNIQUE KEY `neomahasiswas_id_reg_mahasiswa_unique` (`id_reg_mahasiswa`),
UNIQUE KEY `neomahasiswas_nomor_pendaftaran_unique` (`nomor_pendaftaran`),
UNIQUE KEY `neomahasiswas_pin_unique` (`pin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of neomahasiswas
-- ----------------------------
BEGIN;
INSERT INTO `neomahasiswas` VALUES ('82af02fd-0473-493f-8b63-c34446d79503', NULL, NULL, NULL, '2023A000001', '19627928', 0, 'Irfan Fadil', NULL, '121313', NULL, NULL, 'L', '85220717928', NULL, NULL, NULL, NULL, NULL, 'eca49026-745e-451c-8121-bfc81d4e9fe4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-02-12 22:01:53', '2023-02-12 22:01:53');
INSERT INTO `neomahasiswas` VALUES ('a2eab6d1-7aea-4892-8606-3feb4ee121df', NULL, NULL, NULL, '2023A000002', '99458878', NULL, 'Irfan Fadil', NULL, '1233', NULL, NULL, 'L', '878878', NULL, NULL, NULL, NULL, NULL, '1daad851-b93f-4860-b37d-ddae33f1b860', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-02-12 22:02:27', '2023-02-12 22:02:27');
COMMIT;
-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
`email` varchar(255) NOT NULL,
`token` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of password_resets
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for pe3_channel_pembayaran
-- ----------------------------
DROP TABLE IF EXISTS `pe3_channel_pembayaran`;
CREATE TABLE `pe3_channel_pembayaran` (
`id_channel` tinyint(4) NOT NULL,
`nama_channel` varchar(191) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id_channel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of pe3_channel_pembayaran
-- ----------------------------
BEGIN;
INSERT INTO `pe3_channel_pembayaran` VALUES (1, 'TELLER BANK', '2022-01-21 07:47:15', '2022-01-21 07:47:15');
INSERT INTO `pe3_channel_pembayaran` VALUES (2, 'MOBILE BANKING', '2022-01-21 07:47:15', '2022-01-21 07:47:15');
INSERT INTO `pe3_channel_pembayaran` VALUES (3, 'TRANSFER ATM', '2022-01-21 07:47:15', '2022-01-21 07:47:15');
INSERT INTO `pe3_channel_pembayaran` VALUES (4, 'TIM PMB', '2022-01-21 07:47:15', '2022-01-21 07:47:15');
COMMIT;
-- ----------------------------
-- Table structure for pe3_fakultas
-- ----------------------------
DROP TABLE IF EXISTS `pe3_fakultas`;
CREATE TABLE `pe3_fakultas` (
`kode_fakultas` varchar(10) NOT NULL,
`nama_fakultas` varchar(100) NOT NULL,
`urut` int(11) NOT NULL,
`nim_kode` varchar(10) NOT NULL,
PRIMARY KEY (`kode_fakultas`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of pe3_fakultas
-- ----------------------------
BEGIN;
INSERT INTO `pe3_fakultas` VALUES ('10', 'Fakultas Keguruan dan Ilmu Pendidikan', 1, '01');
INSERT INTO `pe3_fakultas` VALUES ('11', 'Fakultas Ekonomi Bisnis', 3, '03');
INSERT INTO `pe3_fakultas` VALUES ('12', 'Fakultas Ilmu Sosial dan Ilmu Politik', 4, '04');
INSERT INTO `pe3_fakultas` VALUES ('13', 'Fakultas Ilmu Kesehatan', 5, '05');
INSERT INTO `pe3_fakultas` VALUES ('14', 'Fakultas Teknologi Informasi', 6, '06');
INSERT INTO `pe3_fakultas` VALUES ('15', 'Fakultas Ilmu Budaya', 2, '02');
INSERT INTO `pe3_fakultas` VALUES ('16', 'Sekolah Tinggi Agama Islam (Dalam Proses Penyatuan)', 7, '07');
COMMIT;
-- ----------------------------
-- Table structure for pe3_prodi
-- ----------------------------
DROP TABLE IF EXISTS `pe3_prodi`;
CREATE TABLE `pe3_prodi` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`kode_prodi` varchar(5) NOT NULL,
`kode_fakultas` varchar(10) DEFAULT NULL,
`nama_prodi` varchar(50) NOT NULL,
`nama_prodi_alias` varchar(50) NOT NULL,
`kode_jenjang` varchar(1) NOT NULL,
`nama_jenjang` varchar(15) NOT NULL,
`config` text DEFAULT NULL,
`nim_kode` varchar(3) NOT NULL,
`nim_jenjang` varchar(1) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `pe3_prodi_kode_prodi_unique` (`kode_prodi`) USING BTREE,
KEY `pe3_prodi_kode_fakultas_index` (`kode_fakultas`) USING BTREE,
KEY `pe3_prodi_kode_jenjang_index` (`kode_jenjang`) USING BTREE,
CONSTRAINT `pe3_prodi_ibfk_1` FOREIGN KEY (`kode_fakultas`) REFERENCES `pe3_fakultas` (`kode_fakultas`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `pe3_prodi_ibfk_2` FOREIGN KEY (`kode_jenjang`) REFERENCES `pe3_jenjang_studi` (`kode_jenjang`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of pe3_prodi
-- ----------------------------
BEGIN;
INSERT INTO `pe3_prodi` VALUES (7, '61101', '11', 'Manajemen', 'MM', 'B', 'S-2', '1ff84166-cc64-48aa-a38e-3c6a952a8b90', '303', '3');
INSERT INTO `pe3_prodi` VALUES (8, '14201', '13', 'Ilmu Keperawatan', 'IKP', 'C', 'S-1', '303e6a30-c87a-4f70-8431-8ccc03b058f4', '502', '2');
INSERT INTO `pe3_prodi` VALUES (9, '13201', '13', 'Kesehatan Masyarakat', 'Kesmas', 'C', 'S-1', 'b41b8150-b1e6-4c63-9455-26f91174933c', '501', '2');
INSERT INTO `pe3_prodi` VALUES (10, '63101', '12', 'Ilmu Administrasi', 'ADM', 'B', 'S-2', 'd778be91-7bc7-4757-bd22-9038fa8adeb4', '402', '3');
INSERT INTO `pe3_prodi` VALUES (11, '14901', '13', 'Profesi Ners', 'Profesi Ners', 'J', 'PROFESI', '93366fa0-45df-457c-a723-01b78226ad34', '503', '5');
INSERT INTO `pe3_prodi` VALUES (12, '62201', '11', 'Akuntansi', 'Akuntansi', 'C', 'S-1', '08b181bc-1860-4c7e-8bda-ef4fbd59d869', '302', '2');
INSERT INTO `pe3_prodi` VALUES (13, '63201', '12', 'Ilmu Administrasi Negara', 'IAN', 'C', 'S-1', 'e992676b-23e6-49e1-a2f6-81f90876b7da', '401', '2');
INSERT INTO `pe3_prodi` VALUES (14, '61201', '11', 'Manajemen Sarjana', 'Manajemen', 'C', 'S-1', '8c56f8a8-8f27-4e2f-8376-a433b2862f36', '301', '2');
INSERT INTO `pe3_prodi` VALUES (15, '88201', '10', 'Pendidikan Bahasa dan Sastra Indonesia', 'PBSI', 'C', 'S-1', '5b3ff355-1e20-4c1d-8b47-e559b6991036', '101', '2');
INSERT INTO `pe3_prodi` VALUES (16, '86207', '10', 'Pendidikan Guru Pendidikan Anak Usia Dini', 'PGPAUD', 'C', 'S-1', 'f48cbc83-b3c6-4e66-9e68-209b52a275e4', '104', '2');
INSERT INTO `pe3_prodi` VALUES (17, '86206', '10', 'Pendidikan Guru Sekolah Dasar', 'PGSD', 'C', 'S-1', 'eca49026-745e-451c-8121-bfc81d4e9fe4', '105', '2');
INSERT INTO `pe3_prodi` VALUES (18, '85201', '10', 'Pendidikan Jasmani Kesehatan dan Rekreasi', 'PJKR', 'C', 'S-1', 'adc77657-6904-4aa3-bc6e-40565bdc27bf', '103', '2');
INSERT INTO `pe3_prodi` VALUES (19, '84202', '10', 'Pendidikan Matematika', 'PENMAT', 'C', 'S-1', '5f69f4f0-ebbb-4638-8df1-4632b05326de', '102', '2');
INSERT INTO `pe3_prodi` VALUES (20, '83203', '10', 'Pendidikan Teknik Mesin', 'PTM', 'C', 'S-1', '2cadf663-1d4c-4fd4-9457-6fc2b50bd1b3', '106', '2');
INSERT INTO `pe3_prodi` VALUES (21, '79213', '15', 'Sastra Inggris', 'Sastra', 'C', 'S-1', '1daad851-b93f-4860-b37d-ddae33f1b860', '201', '2');
INSERT INTO `pe3_prodi` VALUES (22, '57201', '14', 'Sistem Informasi', 'SISFO', 'C', 'S-1', 'aaf15037-cd57-4743-a5f8-fd30840f221e', '602', '2');
INSERT INTO `pe3_prodi` VALUES (23, '55202', '14', 'Teknik Informatika', 'IF', 'C', 'S-1', 'a74fffa1-43f1-4ab5-baca-dfbd08b22d20', '601', '2');
INSERT INTO `pe3_prodi` VALUES (24, '57401', '14', 'Manajemen Informatika', 'MI', 'E', 'D-III', 'e0b1aad6-0be9-4647-bc08-f46754a4a1e4', '603', '1');
INSERT INTO `pe3_prodi` VALUES (25, '11223', '16', 'Pendidikan Agama Islam', 'PAI', 'C', 'S-1', NULL, '701', '2');
INSERT INTO `pe3_prodi` VALUES (26, '22334', '16', 'Ekonomi Syariah', 'ESY', 'C', 'S-1', NULL, '702', '2');
COMMIT;
-- ----------------------------
-- Table structure for pe3_soal
-- ----------------------------
DROP TABLE IF EXISTS `pe3_soal`;
CREATE TABLE `pe3_soal` (
`id` char(36) NOT NULL,
`soal` text NOT NULL,
`gambar` varchar(60) DEFAULT NULL,
`prodi_id` int(10) unsigned DEFAULT NULL,
`ta` year(4) NOT NULL,
`semester` tinyint(4) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pe3_soal_prodi_id_index` (`prodi_id`),
CONSTRAINT `pe3_soal_ibfk_1` FOREIGN KEY (`prodi_id`) REFERENCES `pe3_prodi` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of pe3_soal
-- ----------------------------
BEGIN;
INSERT INTO `pe3_soal` VALUES ('0f785b53-5781-4e55-a67e-34b8eaf361f3', '(PEMAHAMAN WACANA) Ketua Pusat Studi Lingkungan (PSL) Univer-sitas Haheoleo, Kendari Ir. Abdul Manan, M. Sc. mengatakan dalam setiap program pengelolaan dan penyehatan lingkungan perlu ditanamkan pendidikan lingkungan sejak dini. ”Baik pendidikan formal maupun nonformal sangat berpengaruh besar dalam pengelolaan lingku- ngan karena hanya dengan masyarakat ter- pelajar, masalah lingkungan dapat dipecahkan dengan masyarakat terpelajar, masalah lingku- ngan dapat dipecahkan dengan bijaksana.” katanya kepada Antara di Kendari.Gagasan pokok paragraf di atas adalah ...', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('1611ea0a-8eee-4eff-aebc-8345448ca61c', 'Renovasi, Padanan Kata ( Sinonim)', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('327a69c0-ac75-4cf1-9cb8-98fdb512808a', 'I quickly ______ my boss’ meeting invite to let him know I would be there.\"Which words best complete the blank in the sentence above?(Select all acceptable answers.) *', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('36c69188-eb55-46f3-8963-d94034cbf103', 'Nadia hendak membeli sepatu dan gaun dengan membawa uang sebesar Rp 363.000,-. Harga sepatu di toko A adalah Rp. 210.000,- dengan diskon 35 % dan harga celana adalah Rp. 85.000,- dengan diskon 15 %. Uang sisa pembelian sepatu dan celana adalah ...', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('3ec43f16-567f-454e-9a42-253c2f03a866', '(PEMAHAMAN WACANA) Green House, sebuah tempat tinggal di kawasan hijau Jakarta. Kawasan ini memiliki daya tarik khusus bagi penggemar seni. Mereka yang menyukai kehidupan alami dan seni, inilah tempatnya. Banyak seniman yang tampak di rumah mereka menggelar kemampuan seni seperti melukis, latihan drama di kebun, bahkan menari di panggung rumah. Justru inilah daya tarik yang muncul. Setiap orang ingin melihat keunikan ini.Unsur intrinsik yang menonjol dalam penggalan cerpen ini adalah....', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('3f821731-3a6a-482c-987f-543967caea8d', '(PEMAHAMAN WACANA) Dengan tambahan medali emas dari Taufik, Indonesia untuk sementara mengoleksi dua emas. Bahkan emas Taufik mungkin emas terakhir kontingen RI di Asian Games kali ini. Dari tahun ke tahun atau dari waktu ke waktu prestasi olah raga di Indonesia di berbagai kejuaraan seperti Asian Games tetap berada di urutan kelas kambing. Tidak sebanding dengan jumlah penduduk yang berjumlah lebih dari 200 juta jiwa.Kalimat kritikan untuk ilustrasi di atas adalah ....', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('4398d42d-a371-4662-ac82-a468fe50682a', 'For many years people believed that cleverest animal after man were the chimpanzees. Now, however, there is no proof that dolphin may be evencleverer than these big apes.Although a dolphin lives in the sea it is not a fish. It is a mammal. It is in many ways, therefore, like a human being.Dolphins have a simple language. They are able to talk to one another. It may be possible for man to learn how to talk to them. But this will bedifficult because dolphins can’t hear the kind of sounds man can make. If man wants to talk to dolphin, therefore, he will have to make a thirdlanguage which both he and the dolphins can understand.Dolphins are also very friendly toward man. They often follow ships. There are many stories about dolphins guiding ships through difficult anddangerous water. The text above is in the form of . . . . *', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('49a798fc-fe63-4bf0-8cd1-2bf66f24d27e', 'Your boss told you that you need to project more in meetings so that people standing in the back don\'t miss anything.What does project mean in this sentence? *', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('5842f785-5083-4283-9e3b-3e6a4a126448', '(Padanan) Air : Es = Uap : …', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('5df57dde-10a0-4c5e-ade6-dd7608d6ecfd', 'Jika x = 156788 – 156788/2, dan y = 156788/2, maka…', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('62068069-c54a-4ef8-8af5-3758a2c00d9f', 'Paradoksal, Lawan Kata (Antonim)', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('734d2ad6-59d1-4e12-b4d9-eb97e15a8977', 'Sebuah persegi panjang memiliki luas 588 cm² dengan panjang : lebar = 4 : 3. Jika sebuah tabung dengan tinggi 7 cm mempunyai jari-jari yang sama dengan lebar persegi panjang tersebut, maka volume tabung adalah… *', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('740bd2d4-cfd9-4385-af0d-aaf0d55239c7', 'Virtual, Padanan Kata ( Sinonim)', '', NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('7b069d77-58c3-4a4a-b485-5e97fffbe7fa', 'Carilah hubungan antara kelompok kata di bawah ini dan pilihlah diagram Venn yang mewakili hubungan antara ketiga kata di bawah ini!', 'storage/images/37.png', NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('86ffd5c3-251a-4af2-b500-6cfe00ef1828', '(Padanan) Hewan : Senapan : Berburu = ... : ... : ...', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('87d08579-99c5-49f2-989c-cc6f4bf4c8a9', '(Tes Penalaran Logis) Tidak ada dua perhiasan berlian yang mempu- nyai kilau yang sama.Cincin X dan Y terbuat dari berlian. Kesimpulan : *', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('8b672555-0d66-4161-9210-e0574f568a55', '(Padanan) Pakaian : Lemari = … : …', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('979a86f5-e91b-458b-94dd-c6536a7c2ca8', 'Soal di bawah ini terdiri dari lima buah gambar yang memiliki kesamaan atau citra cermin, dan perputaran. Tetapi hanya ada satu gambar yang tidak sama atau tidak sekelompok dengan gambar lainnya. Pilihlah salah satu gambar yang tidak sama antara kelima gambar lainnya', 'storage/images/35.png', NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('995e8f66-5fdb-43cc-a242-645d213275e8', 'Absurd, Lawan Kata (Antonim)', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('ab18eb51-2f1a-4acd-aaf0-67cc3544a1a2', 'Today the CEO announced that the company will ______ into Europe next year.\"Which words best complete the blank in the sentence above? *', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('ace8e885-412c-4ab2-b237-8201db16b03a', 'Soal di bawah ini terdiri dari lima buah gambar yang memiliki kesamaan atau citra cermin, dan perputaran. Tetapi hanya ada satu gambar yang tidak sama atau tidak sekelompok dengan gambar lainnya. Pilihlah salah satu gambar yang tidak sama antara kelima gambar lainnya', 'storage/images/36.png', NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('e3c89ccb-d27f-4722-84dd-0828d46d7ebd', '(Tes Penalaran Analitis) Lima orang pedagang asongan menghitung hasil penjualan dalam satu hari. Pedagang III lebih banyak menjual dari pedagang IV, tetapi tidak melebihi pedagang I. Penjualan pedagang II tidak melebihi pedagang V dan melebihi pedagang I. Pedagang mana yang hasil penjualannya paling banyak?', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('e3f8724f-2ccf-4a56-9151-af727c4a3fdd', '(Test Deret Seri) Seri bilangan 31 – 55 – 61 – 34 – 56 – 59 – 37 –57 – 57 – 40 – 58 – ….', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('f062c130-7ddb-4a21-8007-4778c24ec100', '(Tes Penalaran Logis) Olah raga adalah aktivitas yang selalu dilakukan Badu setiap hari. Hari ini Badu sakit kepala. Kesimpulan :', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
INSERT INTO `pe3_soal` VALUES ('fbda9af4-4b37-45d3-b9a1-a1930930caed', '(Test Deret Seri) Seri bilangan 5 – 10 – 8 – 24 – 21 – 84 ….', NULL, NULL, 2022, 1, 1, '2022-03-01 00:36:09', '2022-03-01 00:36:09');
COMMIT;
-- ----------------------------
-- Table structure for pe3_status_transaksi
-- ----------------------------
DROP TABLE IF EXISTS `pe3_status_transaksi`;
CREATE TABLE `pe3_status_transaksi` (
`id_status` tinyint(4) NOT NULL,
`nama_status` varchar(191) NOT NULL,
`style` varchar(191) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of pe3_status_transaksi
-- ----------------------------
BEGIN;
INSERT INTO `pe3_status_transaksi` VALUES (0, 'Belum Bayar', 'yellow darken-3', '2022-01-21 07:47:15', '2022-01-21 07:47:15');
INSERT INTO `pe3_status_transaksi` VALUES (1, 'Sudah Bayar', 'light-green lighten-1', '2022-01-21 07:47:15', '2022-01-21 07:47:15');
INSERT INTO `pe3_status_transaksi` VALUES (2, 'Batal', 'red darken-2', '2022-01-21 07:47:15', '2022-01-21 07:47:15');
COMMIT;
-- ----------------------------
-- Table structure for personal_access_tokens
-- ----------------------------
DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(255) NOT NULL,
`tokenable_id` bigint(20) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`token` varchar(64) NOT NULL,
`abilities` text DEFAULT NULL,
`last_used_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for persyaratans
-- ----------------------------
DROP TABLE IF EXISTS `persyaratans`;
CREATE TABLE `persyaratans` (
`id` char(36) NOT NULL,
`id_user` varchar(255) NOT NULL,
`ijasah` varchar(255) DEFAULT NULL,
`is_ijasah` int(11) NOT NULL DEFAULT 0,
`ktp_kk` varchar(255) DEFAULT NULL,
`is_ktp` int(11) NOT NULL DEFAULT 0,
`foto` varchar(255) DEFAULT NULL,
`is_foto` int(11) NOT NULL DEFAULT 0,
`ket_sehat` varchar(255) DEFAULT NULL,
`is_ket_sehat` int(11) NOT NULL DEFAULT 0,
`khs` varchar(255) DEFAULT NULL,
`is_khs` int(11) NOT NULL DEFAULT 0,
`ktm` varchar(255) DEFAULT NULL,
`is_ktm` int(11) NOT NULL DEFAULT 0,
`surat_pindah` varchar(255) DEFAULT NULL,
`is_surat_pindah` int(11) NOT NULL DEFAULT 0,
`screen_pddikti` varchar(255) DEFAULT NULL,
`is_screen_pddikti` int(11) NOT NULL DEFAULT 0,
`ijasah_lanjutan` varchar(255) DEFAULT NULL,
`is_ijasah_lanjutan` int(11) NOT NULL DEFAULT 0,
`transkrip_nilai` varchar(255) DEFAULT NULL,
`is_transkrip_nilai` int(11) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of persyaratans
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for soal_h_ujian
-- ----------------------------
DROP TABLE IF EXISTS `soal_h_ujian`;
CREATE TABLE `soal_h_ujian` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ujian_id` int(11) NOT NULL,
`mahasiswa_id` int(11) NOT NULL,
`list_soal` longtext NOT NULL,
`list_jawaban` longtext NOT NULL,
`jml_benar` int(11) NOT NULL,
`nilai` decimal(10,2) NOT NULL,
`nilai_bobot` decimal(10,2) NOT NULL,
`tgl_mulai` datetime NOT NULL,
`tgl_selesai` datetime NOT NULL,
`status` enum('Y','N') NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `ujian_id` (`ujian_id`) USING BTREE,
KEY `mahasiswa_id` (`mahasiswa_id`) USING BTREE,
CONSTRAINT `soal_h_ujian_ibfk_1` FOREIGN KEY (`ujian_id`) REFERENCES `soal_m_ujian` (`id_ujian`),
CONSTRAINT `soal_h_ujian_ibfk_2` FOREIGN KEY (`mahasiswa_id`) REFERENCES `mahasiswa` (`id_mahasiswa`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
-- ----------------------------
-- Records of soal_h_ujian
-- ----------------------------
BEGIN;
COMMIT;
-- ----------------------------
-- Table structure for soal_m_ujian
-- ----------------------------
DROP TABLE IF EXISTS `soal_m_ujian`;
CREATE TABLE `soal_m_ujian` (
`id_ujian` int(11) NOT NULL AUTO_INCREMENT,
`dosen_id` int(11) NOT NULL,
`matkul_id` int(11) NOT NULL,
`nama_ujian` varchar(200) NOT NULL,
`jumlah_soal` int(11) NOT NULL,
`waktu` int(11) NOT NULL,
`jenis` enum('acak','urut') NOT NULL,
`tgl_mulai` datetime NOT NULL,
`terlambat` datetime NOT NULL,
`token` varchar(5) NOT NULL,
PRIMARY KEY (`id_ujian`) USING BTREE,
KEY `matkul_id` (`matkul_id`) USING BTREE,
KEY `dosen_id` (`dosen_id`) USING BTREE,
CONSTRAINT `soal_m_ujian_ibfk_1` FOREIGN KEY (`dosen_id`) REFERENCES `dosen` (`id_dosen`),
CONSTRAINT `soal_m_ujian_ibfk_2` FOREIGN KEY (`matkul_id`) REFERENCES `matkul` (`id_matkul`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
-- ----------------------------
-- Records of soal_m_ujian
-- ----------------------------
BEGIN;
INSERT INTO `soal_m_ujian` VALUES (1, 1, 1, 'First Test', 3, 1, 'acak', '2019-02-15 17:25:40', '2019-02-20 17:25:44', 'DPEHL');
INSERT INTO `soal_m_ujian` VALUES (2, 1, 1, 'Second Test', 3, 1, 'acak', '2019-02-16 10:05:08', '2019-02-17 10:05:10', 'GOEMB');
INSERT INTO `soal_m_ujian` VALUES (3, 3, 5, 'Try Out 01', 2, 1, 'acak', '2019-02-16 07:00:00', '2019-02-28 14:00:00', 'IFSDH');
COMMIT;
-- ----------------------------
-- Table structure for soal_soal
-- ----------------------------
DROP TABLE IF EXISTS `soal_soal`;
CREATE TABLE `soal_soal` (
`id_soal` int(11) NOT NULL AUTO_INCREMENT,
`dosen_id` int(11) NOT NULL,
`matkul_id` int(11) NOT NULL,
`bobot` int(11) NOT NULL,
`file` varchar(255) NOT NULL,
`tipe_file` varchar(50) NOT NULL,
`soal` longtext NOT NULL,
`opsi_a` longtext NOT NULL,
`opsi_b` longtext NOT NULL,
`opsi_c` longtext NOT NULL,
`opsi_d` longtext NOT NULL,
`opsi_e` longtext NOT NULL,
`file_a` varchar(255) NOT NULL,
`file_b` varchar(255) NOT NULL,
`file_c` varchar(255) NOT NULL,
`file_d` varchar(255) NOT NULL,
`file_e` varchar(255) NOT NULL,
`jawaban` varchar(5) NOT NULL,
`created_on` int(11) NOT NULL,
`updated_on` int(11) DEFAULT NULL,
PRIMARY KEY (`id_soal`) USING BTREE,
KEY `matkul_id` (`matkul_id`) USING BTREE,
KEY `dosen_id` (`dosen_id`) USING BTREE,
CONSTRAINT `soal_soal_ibfk_1` FOREIGN KEY (`matkul_id`) REFERENCES `matkul` (`id_matkul`),
CONSTRAINT `soal_soal_ibfk_2` FOREIGN KEY (`dosen_id`) REFERENCES `dosen` (`id_dosen`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
-- ----------------------------
-- Records of soal_soal
-- ----------------------------
BEGIN;
INSERT INTO `soal_soal` VALUES (1, 1, 1, 1, '', '', '<p>Dian : The cake is scrumptious! I love i<br>Joni : … another piece?<br>Dian : Thank you. You should tell me the recipe.<br>Joni : I will.</p><p>Which of the following offering expressions best fill the blank?</p>', '<p>Do you mind if you have</p>', '<p>Would you like</p>', '<p>Shall you hav</p>', '<p>Can I have you</p>', '<p>I will bring you</p>', '', '', '', '', '', 'B', 1550225760, 1550225760);
INSERT INTO `soal_soal` VALUES (2, 1, 1, 1, '', '', '<p>Fitri : The French homework is really hard. I don’t feel like to do it.<br>Rahmat : … to help you?<br>Fitri : It sounds great. Thanks, Rahmat!</p><p><br></p><p>Which of the following offering expressions best fill the blank?</p>', '<p>Would you like me</p>', '<p>Do you mind if I</p>', '<p>Shall I</p>', '<p>Can I</p>', '<p>I will</p>', '', '', '', '', '', 'A', 1550225952, 1550225952);
INSERT INTO `soal_soal` VALUES (3, 1, 1, 1, 'd166959dabe9a81e4567dc44021ea503.jpg', 'image/jpeg', '<p>What is the picture describing?</p><p><small class=\"text-muted\">Sumber gambar: meros.jp</small></p>', '<p>The students are arguing with their lecturer.</p>', '<p>The students are watching their preacher.</p>', '<p>The teacher is angry with their students.</p>', '<p>The students are listening to their lecturer.</p>', '<p>The students detest the preacher.</p>', '', '', '', '', '', 'D', 1550226174, 1550226174);
INSERT INTO `soal_soal` VALUES (5, 3, 5, 1, '', '', '<p>(2000 x 3) : 4 x 0 = ...</p>', '<p>NULL</p>', '<p>NaN</p>', '<p>0</p>', '<p>1</p>', '<p>-1</p>', '', '', '', '', '', 'C', 1550289702, 1550289724);
INSERT INTO `soal_soal` VALUES (6, 3, 5, 1, '98a79c067fefca323c56ed0f8d1cac5f.png', 'image/png', '<p>Nomor berapakah ini?</p>', '<p>Sembilan</p>', '<p>Sepuluh</p>', '<p>Satu</p>', '<p>Tujuh</p>', '<p>Tiga</p>', '', '', '', '', '', 'D', 1550289774, 1550289774);
COMMIT;
-- ----------------------------
-- Table structure for transaksis
-- ----------------------------
DROP TABLE IF EXISTS `transaksis`;
CREATE TABLE `transaksis` (
`id` char(36) NOT NULL,
`pin` varchar(255) NOT NULL,
`no_transaksi` varchar(20) NOT NULL,
`nomor_rekening` varchar(20) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT 0,
`total` decimal(15,2) NOT NULL DEFAULT 0.00,
`tanggal` date NOT NULL,
`desc` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `transaksis_no_transaksi_unique` (`no_transaksi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of transaksis
-- ----------------------------
BEGIN;
INSERT INTO `transaksis` VALUES ('1771f257-8fbd-4323-ab5c-48ad4693228f', '99458878', '10120230212220227', '101', 10, 250000.00, '2023-02-12', 'Pendaftaran Online', '2023-02-12 22:02:27', '2023-02-12 22:02:27');
INSERT INTO `transaksis` VALUES ('db1e8940-b606-4c7d-be21-850dde9a9dbc', '19627928', '10120230212220253', '101', 10, 250000.00, '2023-02-12', 'Pendaftaran Online', '2023-02-12 22:01:53', '2023-02-12 22:01:53');
COMMIT;
-- ----------------------------
-- Table structure for user_siuters
-- ----------------------------
DROP TABLE IF EXISTS `user_siuters`;
CREATE TABLE `user_siuters` (
`id` char(36) NOT NULL,
`nidn` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`google_id` varchar(255) DEFAULT NULL,
`kodeprodi` varchar(255) DEFAULT NULL,
`role` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_siuters_nidn_unique` (`nidn`),
UNIQUE KEY `user_siuters_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of user_siuters
-- ----------------------------
BEGIN;
INSERT INTO `user_siuters` VALUES ('09ef6855-1894-466a-84f5-1d3705ddcce4', '85201', 'pjkr_fkip@unsap.ac.id', '1', 'adc77657-6904-4aa3-bc6e-40565bdc27bf', 'prodi', '2023-01-06 22:05:06', '2023-01-06 22:05:06');
INSERT INTO `user_siuters` VALUES ('3eb4bc84-e2ea-4a71-9907-9f46f835a3c8', '1234', 'deden@unsap.ac.id', '1', 'a74fffa1-43f1-4ab5-baca-dfbd08b22d20', 'prodi', '2023-01-17 20:31:50', '2023-01-17 20:31:50');
INSERT INTO `user_siuters` VALUES ('4153aa6c-150c-4ca2-a31b-55b47df267f5', '1010', 'eka@unsap.ac.id', '1', NULL, 'akademik', '2023-01-06 21:04:42', '2023-01-06 21:04:42');
INSERT INTO `user_siuters` VALUES ('4f4c1322-17c2-4ed1-8f3a-3e5062381eea', '79213', 'fib@unsap.ac.id', '1', '1daad851-b93f-4860-b37d-ddae33f1b860', 'prodi', '2023-01-06 22:08:12', '2023-01-06 22:08:12');
INSERT INTO `user_siuters` VALUES ('50adb09c-2939-4bb6-afd8-55b6928eeda0', '86206', 'pgsd_fkip@unsap.ac.id', '1', 'eca49026-745e-451c-8121-bfc81d4e9fe4', 'prodi', '2023-01-06 22:04:44', '2023-01-06 22:04:44');
INSERT INTO `user_siuters` VALUES ('56b20495-a2cc-4b94-a6e8-6d24c783df11', '62201', 'akuntansi.feb@unsap.ac.id', '1', '08b181bc-1860-4c7e-8bda-ef4fbd59d869', 'prodi', '2023-01-06 22:09:03', '2023-01-06 22:09:03');
INSERT INTO `user_siuters` VALUES ('5c9f0a4d-617b-4a13-b877-8a40abe5d18c', '86207', 'pgpaud_fkip@unsap.ac.id', '1', 'f48cbc83-b3c6-4e66-9e68-209b52a275e4', 'prodi', '2023-01-06 22:04:19', '2023-01-06 22:04:19');
INSERT INTO `user_siuters` VALUES ('829bf6b3-f8fb-4563-b53f-65d1f1a373a5', '84202', 'penmat_fkip@unsap.ac.id', '1', '5f69f4f0-ebbb-4638-8df1-4632b05326de', 'prodi', '2023-01-06 22:07:00', '2023-01-06 22:07:00');
INSERT INTO `user_siuters` VALUES ('91081f45-1d9b-4621-8183-93649851eebb', '14201', 'prodikeperawatan@unsap.ac.id', '1', '303e6a30-c87a-4f70-8431-8ccc03b058f4', 'prodi', '2023-01-06 22:01:42', '2023-01-06 22:01:42');
INSERT INTO `user_siuters` VALUES ('a7214354-4203-48b7-8c09-d867a9fdb775', '13201', 'prodikesmas@unsap.ac.id', '1', 'b41b8150-b1e6-4c63-9455-26f91174933c', 'prodi', '2023-01-06 22:02:06', '2023-01-06 22:02:06');
INSERT INTO `user_siuters` VALUES ('cfde372e-c295-4bac-992e-0253be5072dc', '12122', 'manajemen.feb@unsap.ac.id', '1', '8c56f8a8-8f27-4e2f-8376-a433b2862f36', 'prodi', '2023-01-24 18:10:08', '2023-01-24 18:10:08');
INSERT INTO `user_siuters` VALUES ('d0ec4ed8-db89-47da-9bb4-4776cd42396b', '3333', 'magister.feb@unsap.ac.id', '1', '1ff84166-cc64-48aa-a38e-3c6a952a8b90', 'prodi', '2023-01-24 20:40:46', '2023-01-24 20:40:46');
INSERT INTO `user_siuters` VALUES ('d7fa2380-42c9-4296-8ec4-8f2ce47ad4dd', '88201', 'diksatrasia_fkip@unsap.ac.id', '1', '5b3ff355-1e20-4c1d-8b47-e559b6991036', 'prodi', '2023-01-06 22:05:58', '2023-01-06 22:05:58');
INSERT INTO `user_siuters` VALUES ('e9559ce1-53db-4c6a-ab93-bf1842dc218a', '0284e490-f5e9-48c0-b5af-e5b3314bbf80', 'yysofiyan@unsap.ac.id', '1', 'aaf15037-cd57-4743-a5f8-fd30840f221e', 'dosen', '2023-01-24 17:42:57', '2023-01-24 17:42:57');
INSERT INTO `user_siuters` VALUES ('f2cf9f2c-99e9-40a4-8a50-55ef39af054b', '1111', 'mi.fti@unsap.ac.id', '1', 'e0b1aad6-0be9-4647-bc08-f46754a4a1e4', 'prodi', '2023-01-18 20:48:29', '2023-01-18 20:48:29');
INSERT INTO `user_siuters` VALUES ('f87a4bcf-48db-4b31-bfbf-839f39ffd232', '22222', 'fadilirfan@unsap.ac.id', '1', 'aaf15037-cd57-4743-a5f8-fd30840f221e', 'prodi', '2023-01-24 16:34:34', '2023-01-24 16:34:34');
INSERT INTO `user_siuters` VALUES ('ff3074ea-0aca-4aaa-a9b1-0de770528a40', '83203', 'ptm_fkip@unsap.ac.id', '1', '2cadf663-1d4c-4fd4-9457-6fc2b50bd1b3', 'prodi', '2023-01-06 22:05:35', '2023-01-06 22:05:35');
COMMIT;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`handphone` varchar(255) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) NOT NULL,
`role` varchar(255) NOT NULL,
`is_aktif` int(11) NOT NULL DEFAULT 0,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (1, 'Irfan Fadil', 'fadilirfan@unsap.ac.id', '085220717928', NULL, '$2y$10$/SsTG17h6OgOaN9h5eS/2OOEzg42W1PNgqohypyMK7fnv7D4QzSlK', 'PMB', 0, NULL, '2023-02-13 10:28:47', '2023-02-13 10:28:47');
INSERT INTO `users` VALUES (2, 'Bagian Keuangan Yayasan', 'irfan@admin.com', '7887908800', NULL, '$2y$10$EeS3QMVDoIlNqqizXRjkm.rcx1J5OO9NLN6qrmwDmx0Z./aI9UXcu', 'YPSA', 0, NULL, '2023-02-13 13:24:50', '2023-02-13 13:24:50');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;