Gecko [ elibrary.unsap.ac.id ]

Name	Size	Permission	Date
$RECYCLE.BIN	[ DIR ]	drwxrwxrwx	2022-02-07 02:49
Downloads	[ DIR ]	drwxrwxrwx	2025-04-29 08:03
Lisense	[ DIR ]	drwxrwxrwx	2022-03-21 13:05
Microsoft	[ DIR ]	drwxrwxrwx	2024-03-20 22:46
Neo Feeder	[ DIR ]	drwxrwxrwx	2022-03-01 23:41
Neo Feeder v.2.1.2	[ DIR ]	drwxrwxrwx	2023-09-09 07:13
New folder	[ DIR ]	drwxrwxrwx	2022-02-19 12:03
NewGoal	[ DIR ]	drwxrwxrwx	2024-07-16 17:14
PATCH	[ DIR ]	drwxrwxrwx	2023-05-15 16:51
PDdikti	[ DIR ]	drwxrwxrwx	2022-02-17 12:02
SISTER-INSTALLER-Virtualbox-04AGUSTUS2021	[ DIR ]	drwxrwxrwx	2023-02-02 12:53
Suteki	[ DIR ]	drwxrwxrwx	2024-01-24 11:53
System Volume Information	[ DIR ]	drwxrwxrwx	2024-12-15 22:43
UNSAP	[ DIR ]	drwxrwxrwx	2024-07-09 00:59
Users	[ DIR ]	drwxrwxrwx	2022-11-01 15:50
backup	[ DIR ]	drwxrwxrwx	2025-03-05 20:02
drive-download-20231017T065049Z-001	[ DIR ]	drwxrwxrwx	2023-10-17 14:25
elearning-stmik	[ DIR ]	drwxrwxrwx	2022-07-26 15:16
localhost	[ DIR ]	drwxrwxrwx	2025-04-27 13:10
php-7.4.33-nts-Win32-vc15-x64	[ DIR ]	drwxrwxrwx	2023-06-09 00:43
php_imagick-3.7.0-7.4-ts-vc15-x64	[ DIR ]	drwxrwxrwx	2023-12-14 11:51
win-acme.v2.2.9.1701.x64.pluggable	[ DIR ]	drwxrwxrwx	2024-09-06 16:04
wwwroot	[ DIR ]	drwxrwxrwx	2025-04-04 00:03
130-Article Text-444-1-10-20220705.pdf	2.52 MB	-rw-rw-rw-	2023-03-28 19:16
16-07-2024-fkip.sql	27.82 MB	-rw-rw-rw-	2024-07-16 02:33
168d56bdfb8cf3507d1a02aafc3f43e9.prf	89.8 MB	-rw-rw-rw-	2023-12-12 13:35
2.JPG	5.12 MB	-rw-rw-rw-	2023-09-27 17:51
82100.pdf	1008.88 KB	-rw-rw-rw-	2024-01-22 19:06
82101.pdf	255.73 KB	-rw-rw-rw-	2024-01-22 19:07
82102.pdf	1.22 MB	-rw-rw-rw-	2024-01-22 19:18
8dj89wcmlsouu12k.zip	103.47 MB	-rw-rw-rw-	2025-03-27 03:12
DSCF6339-1024x577.jpg	112.85 KB	-rw-rw-rw-	2023-08-23 19:37
Neo Feeder v.2.1.2.zip	127.71 MB	-rw-rw-rw-	2023-09-09 06:34
Neo Feeder v.2.2.0 (1).zip	126.66 MB	-rw-rw-rw-	2023-11-15 17:46
Neo Feeder v.2.2.0.zip	126.66 MB	-rw-rw-rw-	2023-11-15 17:46
Neo Feeder v.2.3.0.zip	128.25 MB	-rw-rw-rw-	2024-02-08 15:05
Neo Feeder v.2.4.0.zip	128.67 MB	-rw-rw-rw-	2024-07-27 16:40
PATCH.zip	41.67 MB	-rw-rw-rw-	2023-05-15 16:51
REQ.txt	127 B	-rw-rw-rw-	2024-11-08 22:18
SISTER-INSTALLER-64Bit (17-03-2022).zip.rar	5.62 GB	-rw-rw-rw-	2022-06-17 00:11
Subang.png	98.99 KB	-rw-rw-rw-	2023-09-27 17:51
TeamViewer_Setup_x64.exe	49.34 MB	-rwxrwxrwx	2023-03-23 17:44
[PATCH]NEO FEEDER v2.1.1 (64 bit).exe	26.91 MB	-rwxrwxrwx	2023-07-07 12:45
admin.zip	56.92 MB	-rw-rw-rw-	2024-10-22 00:32
admission_fix_update.zip	283.33 MB	-rw-rw-rw-	2025-03-25 22:25
cropped-logo-FTI.png	137.71 KB	-rw-rw-rw-	2022-02-11 14:12
db_diksatrasia.sql	70.52 KB	-rw-rw-rw-	2024-11-08 22:05
db_fo.sql	13.99 KB	-rw-rw-rw-	2022-11-19 00:03
diksatrasia_unsap.zip	82.88 MB	-rw-rw-rw-	2024-11-08 22:14
doka.zip	23.23 MB	-rw-rw-rw-	2024-07-09 00:54
drive-download-20230927T134214Z-001.zip	18.5 MB	-rw-rw-rw-	2023-09-27 20:43
drive-download-20231017T065049Z-001.zip	215.22 MB	-rw-rw-rw-	2023-10-17 14:25
global-admin-icon-color-outline-vector.jpg	19.02 KB	-rw-rw-rw-	2025-03-29 00:08
job.xml	210.22 KB	-rw-rw-rw-	2024-02-14 01:06
job2.xml	210.22 KB	-rw-rw-rw-	2024-02-14 01:17
konfirmasi_pembayarans.sql	1.25 KB	-rw-rw-rw-	2023-02-19 23:44
libsys.zip	50.27 MB	-rw-rw-rw-	2024-06-28 13:18
libsys_new.sql	31.94 MB	-rw-rw-rw-	2024-06-28 13:08
logomajalengka.png	514.23 KB	-rw-rw-rw-	2023-09-27 17:51
mariadb-10.6.7-winx64.zip	78.36 MB	-rw-rw-rw-	2022-02-11 05:15
microsoft.jpg	39.04 KB	-rw-rw-rw-	2022-02-21 15:25
neomahasiswas.sql	2.62 KB	-rw-rw-rw-	2023-02-19 23:44
pas-hediSQL.txt	295 B	-rw-rw-rw-	2022-10-20 15:18
persyaratans.sql	1.67 KB	-rw-rw-rw-	2023-02-19 23:44
php-7.4.33-nts-Win32-vc15-x64.zip	24.92 MB	-rw-rw-rw-	2022-11-03 03:46
phpMyAdmin-5.2.1-all-languages.zip	14.4 MB	-rw-rw-rw-	2023-02-08 09:58
php_imagick-3.7.0-7.4-ts-vc15-x64.zip	25.32 MB	-rw-rw-rw-	2022-01-12 02:19
pmb_unsap.sql	38.45 KB	-rw-rw-rw-	2023-02-15 21:24
pmbunsap.sql	10.18 MB	-rw-rw-rw-	2023-09-15 22:38
ppp.sql	12.64 KB	-rw-rw-rw-	2023-07-21 22:11
quarantine.zip	227.28 MB	-rw-rw-rw-	2023-07-21 14:37
sekolah.sql	54.47 MB	-rw-rw-rw-	2023-02-19 23:45
spmb_2025-02-26.sql	12.03 MB	-rw-rw-rw-	2025-02-27 15:23
u7998733_stmikjurnal.sql	10.84 MB	-rw-rw-rw-	2023-03-28 17:42
u8620162_ppp.sql	14.69 MB	-rw-rw-rw-	2023-07-21 15:33
u8620162_s1sdm.sql	30.91 KB	-rw-rw-rw-	2024-10-22 00:22
unsap.tar	40.59 MB	-rw-rw-rw-	2024-10-22 00:23
unsap_fkip.sql	27.79 MB	-rw-rw-rw-	2024-04-04 02:21
unsap_fti.sql	130.88 MB	-rw-rw-rw-	2023-12-24 00:09
wilayah.sql	532.27 KB	-rw-rw-rw-	2023-02-19 23:45
win-acme.v2.2.9.1701.x64.pluggable.zip	35.58 MB	-rw-rw-rw-	2024-05-26 01:56
wordpress-6.4.1-id_ID.zip	25.54 MB	-rw-rw-rw-	2023-11-12 00:00
wordpress-6.6.2-id_ID.zip	25.98 MB	-rw-rw-rw-	2024-09-11 00:06
wordpress-6.7.2.zip	27.09 MB	-rw-rw-rw-	2025-02-11 23:16

Rename

/*
 Navicat Premium Data Transfer

Source Server         : mampp
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : db_fo

Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

Date: 19/11/2022 00:09:05
*/

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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci 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;

-- ----------------------------
-- Table structure for master_penerimaans
-- ----------------------------
DROP TABLE IF EXISTS `master_penerimaans`;
CREATE TABLE `master_penerimaans` (
  `id_penerimaan` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_pemasukan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penjelasan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_penerimaan`),
  UNIQUE KEY `master_penerimaans_kode_unique` (`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of master_penerimaans
-- ----------------------------
BEGIN;
INSERT INTO `master_penerimaans` VALUES ('18957c6a-52d9-4e73-a48c-1a6400353301', 'A', 'Transfer Yayasan/Rektorat', 'Semua penerimaan yang bersumber dari Yayasan/Rektorat', '2022-10-30 12:51:42', '2022-10-30 12:51:42');
INSERT INTO `master_penerimaans` VALUES ('cd9012d2-3a16-4055-b027-9082b583fd49', 'B', 'Bantuan/Subsidi/Donatur', 'Semua penerimaan yang bersumber dari bantuan pemerintah/pihak ke 3', '2022-10-30 12:52:30', '2022-10-30 12:52:30');
COMMIT;

-- ----------------------------
-- Table structure for master_pengeluarans
-- ----------------------------
DROP TABLE IF EXISTS `master_pengeluarans`;
CREATE TABLE `master_pengeluarans` (
  `id_pengeluaran` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_pengeluaran` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penjelasan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_pengeluaran`),
  UNIQUE KEY `master_pengeluarans_kode_unique` (`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of master_pengeluarans
-- ----------------------------
BEGIN;
INSERT INTO `master_pengeluarans` VALUES ('70d1eae3-6e35-4dca-98a0-27ac97d95834', '04', 'Transport', 'Transport (DTY, Pimpinan Struktural, Staff, DPK, dan DLB) sesuai perhitungan riil atas beban yang harus dibayarkan YPSA sesuai dengan standar harga YPSA', '2022-10-31 15:33:16', '2022-10-31 15:33:16');
INSERT INTO `master_pengeluarans` VALUES ('a8485ab8-140d-4d0b-bc39-e7f251261687', '01', 'Honor Pimpinan dan Staf', 'Honor Pimpinan dan Staf sesuai perhitungan riil atas beban yang harus dibayarkan yang sesuai dengan standar harga YPSA', '2022-10-31 15:28:17', '2022-10-31 15:28:17');
INSERT INTO `master_pengeluarans` VALUES ('b82154eb-8dae-4d2b-8d57-bfe033bb8bc3', '03', 'Honor DLB', 'Honor DLB sesuai perhitungan riil atas beban yang harus dibayarkan yang sesuai dengan standar harga YPSA', '2022-10-31 15:30:11', '2022-10-31 15:30:11');
INSERT INTO `master_pengeluarans` VALUES ('c365a5a7-2cc8-43dd-891c-7a62bd7d8647', '02', 'Honor DTY', 'Honor DTY sesuai perhitungan riil atas beban yang harus dibayarkan yang sesuai dengan standar harga YPSA', '2022-10-31 15:29:18', '2022-10-31 15:29:18');
COMMIT;

-- ----------------------------
-- Table structure for master_units
-- ----------------------------
DROP TABLE IF EXISTS `master_units`;
CREATE TABLE `master_units` (
  `id_unit` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_unit` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat_unit` text COLLATE utf8mb4_unicode_ci,
  `jabatan_tanda_wadek` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_tanda_wadek` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jabatan_tanda_kepala` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_tanda_kepala` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kop_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no_kop.png',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_unit`),
  UNIQUE KEY `master_units_kode_unit_unique` (`kode_unit`),
  UNIQUE KEY `master_units_nama_unit_unique` (`nama_unit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of master_units
-- ----------------------------
BEGIN;
INSERT INTO `master_units` VALUES ('0b706e2b-2348-4fad-8eef-c87061904ae3', '11', 'asasa', 'asasa', 'asasa', 'asas', 'asas', 'asas', '6374ef50edea8_sun_ight.jpg', '2022-11-16 15:31:20', '2022-11-16 21:10:28');
INSERT INTO `master_units` VALUES ('953631a7-9b7c-4de1-b2dc-ca42a92c315d', '01', 'Yayasan Pendidikan Sebelas April', 'Jl. Angkrek Situ No. 19', 'a', 'b', 'c', 'd', 'no_gambar.png', '2022-10-22 06:24:34', '2022-10-22 06:24:34');
INSERT INTO `master_units` VALUES ('9c192e30-c36f-4f08-bc7a-4f3b6633e2f8', '03', 'Fakultas Ekonomi dan Bisnis', 'Jl. Angkrek Situ No. 19 Sumedang', 'Wakil Dekan II', 'Asep Saeppani, M.Kom.', 'Kepala Bagian Umum', 'Sara Saraswati, S.Sos.', 'no_gambar.png', '2022-10-22 06:25:27', '2022-10-22 06:25:27');
INSERT INTO `master_units` VALUES ('df122919-1634-4814-a094-60180110908f', '02', 'Fakultas Keguruan dan Ilmu Pendidikan', 'Jl. Angkrek Situ No. 19', 'a', 'b', 'c', 'd', 'no_gambar.png', '2022-10-22 06:24:58', '2022-10-22 06:24:58');
COMMIT;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of migrations
-- ----------------------------
BEGIN;
INSERT INTO `migrations` VALUES (71, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (72, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (73, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1);
INSERT INTO `migrations` VALUES (74, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (75, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` VALUES (76, '2022_10_19_002625_create_master_penerimaans_table', 1);
INSERT INTO `migrations` VALUES (77, '2022_10_19_002659_create_master_pengeluarans_table', 1);
INSERT INTO `migrations` VALUES (78, '2022_10_19_040435_create_master_units_table', 1);
INSERT INTO `migrations` VALUES (79, '2022_10_19_041020_create_transaksi_penerimaans_table', 1);
INSERT INTO `migrations` VALUES (80, '2022_10_19_042300_create_transaksi_pengeluarans_table', 1);
COMMIT;

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci 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 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `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`),
  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 transaksi_penerimaans
-- ----------------------------
DROP TABLE IF EXISTS `transaksi_penerimaans`;
CREATE TABLE `transaksi_penerimaans` (
  `id_transaksi_penerimaan` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_penerimaan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_transaksi_masuk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_penerimaan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah_penerimaan` int(11) NOT NULL,
  `kode_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `validasi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eviden` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_transaksi_penerimaan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of transaksi_penerimaans
-- ----------------------------
BEGIN;
INSERT INTO `transaksi_penerimaans` VALUES ('9387b2bc-a214-46ae-94bf-4e4e1a41512c', 'A', '111', 'lima juta', 5000000, '1', '0', 'no_image.png', '0', '2022-10-30 21:57:19', '2022-10-30 21:57:19');
INSERT INTO `transaksi_penerimaans` VALUES ('9b7417cd-0ed7-4446-a5f6-c08fdfac7bc7', 'A', '111', 'seratus lima puluh juta', 150000000, '1', '0', 'no_image.png', '0', '2022-10-30 22:06:47', '2022-10-30 22:06:47');
INSERT INTO `transaksi_penerimaans` VALUES ('c830cb30-1d3a-4b30-b8ea-9cf0846cc34b', 'B', '111', 'test', 5000000, '1', '0', 'no_image.png', '0', '2022-11-12 13:19:58', '2022-11-12 13:19:58');
INSERT INTO `transaksi_penerimaans` VALUES ('cc23f54e-147c-4d53-bc70-b1f738630f7a', 'A', '111', 'rettr', 2000000, '1', '0', 'no_image.png', '0', '2022-10-30 14:28:42', '2022-10-30 14:28:42');
COMMIT;

-- ----------------------------
-- Table structure for transaksi_pengeluarans
-- ----------------------------
DROP TABLE IF EXISTS `transaksi_pengeluarans`;
CREATE TABLE `transaksi_pengeluarans` (
  `id_transaksi_pengeluaran` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_pengeluaran` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_transaksi_keluar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_pengeluaran` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah_pengeluaran` int(11) NOT NULL,
  `kode_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `validasi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eviden` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_transaksi_pengeluaran`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of transaksi_pengeluarans
-- ----------------------------
BEGIN;
INSERT INTO `transaksi_pengeluarans` VALUES ('781f046a-80ef-4a77-9a65-facd5c0ec54b', '03', '111', 'Dua Puluh Juta Rupiah', 20000000, '1', '0', 'no_image.png', '0', '2022-10-31 15:39:25', '2022-10-31 15:39:25');
INSERT INTO `transaksi_pengeluarans` VALUES ('ef7a6168-718c-4924-b284-81e07fbdbdc2', '02', '111', 'Admin', 100000000, '1', '0', 'no_image.png', '0', '2022-10-31 16:05:13', '2022-10-31 16:05:13');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `two_factor_secret` text COLLATE utf8mb4_unicode_ci,
  `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci,
  `two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (3, 'Irfan Fadil', 'fadilirfan@unsap.ac.id', NULL, '$2y$10$fR85CRbIApSRNC9UvY6wxOJvO6rZoPfmYuHKLDpf4E5Qxx7PsyLMG', NULL, NULL, NULL, 'pengguna', 'df122919-1634-4814-a094-60180110908f', 'zhyt2uKa3TdPHON3YbP6eqoJ4zlqlq6GCNw9VQyfD44KLouGiDuKrKZpJ59P', '2022-11-12 20:29:28', '2022-11-15 11:44:38');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;