Server IP : 101.255.104.117 / Your IP : 101.255.104.117 Web Server : Apache/2.4.34 (Win32) OpenSSL/1.0.2o PHP/5.6.38 System : Windows NT DESKTOP-5B8S0D4 6.2 build 9200 (Windows 8 Professional Edition) i586 User : user ( 0) PHP Version : 5.6.38 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/xampp182/htdocs/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Waktu pembuatan: 14 Jan 2025 pada 05.59 -- Versi server: 10.4.32-MariaDB -- Versi PHP: 8.0.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `siami` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `ami_form14` -- CREATE TABLE `ami_form14` ( `id_file` int(11) NOT NULL, `id_siklus` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `file` varchar(200) NOT NULL, `tgl` datetime NOT NULL, `id_admin` int(11) NOT NULL, `sesuai` int(11) NOT NULL, `standar` text NOT NULL, `area_audit` text NOT NULL, `auditee` varchar(255) NOT NULL, `tipe_audit` varchar(255) NOT NULL, `kode` varchar(255) NOT NULL, `id_fakultas` int(11) NOT NULL, `id_prodi` int(11) NOT NULL, `id_auditor_ketua` int(11) NOT NULL, `id_anggota1` int(11) NOT NULL, `id_anggota2` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data untuk tabel `ami_form14` -- INSERT INTO `ami_form14` (`id_file`, `id_siklus`, `judul`, `file`, `tgl`, `id_admin`, `sesuai`, `standar`, `area_audit`, `auditee`, `tipe_audit`, `kode`, `id_fakultas`, `id_prodi`, `id_auditor_ketua`, `id_anggota1`, `id_anggota2`) VALUES (2, 3, 'tes', '6784930240210.pdf', '2025-01-13 12:13:14', 0, 0, 'CEKLIST RUANGAN 101', 'asdf', 'asdf', 'asdf', '123', 1, 1, 1, 2, 3), (3, 3, 'aaaaa', '6784c1bc202bc.pdf', '2025-01-13 15:51:12', 0, 0, 'CEKLIST RUANGAN 102', 'qwerty', 'qwerty', 'asdf', '123', 1, 1, 1, 2, 3); -- -------------------------------------------------------- -- -- Struktur dari tabel `ami_form15` -- CREATE TABLE `ami_form15` ( `id_file` int(11) NOT NULL, `id_siklus` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `file` varchar(200) NOT NULL, `tgl` datetime NOT NULL, `id_admin` int(11) NOT NULL, `sesuai` int(11) NOT NULL, `standar` text NOT NULL, `area_audit` text NOT NULL, `auditee` varchar(255) NOT NULL, `tipe_audit` varchar(255) NOT NULL, `kode` varchar(255) NOT NULL, `id_fakultas` int(11) NOT NULL, `id_prodi` int(11) NOT NULL, `id_auditor_ketua` int(11) NOT NULL, `id_anggota1` int(11) NOT NULL, `id_anggota2` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `ami_form16` -- CREATE TABLE `ami_form16` ( `id_file` int(11) NOT NULL, `id_siklus` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `file` varchar(200) NOT NULL, `tgl` datetime NOT NULL, `id_admin` int(11) NOT NULL, `sesuai` int(11) NOT NULL, `standar` text NOT NULL, `area_audit` text NOT NULL, `auditee` varchar(255) NOT NULL, `tipe_audit` varchar(255) NOT NULL, `kode` varchar(255) NOT NULL, `id_fakultas` int(11) NOT NULL, `id_prodi` int(11) NOT NULL, `id_auditor_ketua` int(11) NOT NULL, `id_anggota1` int(11) NOT NULL, `id_anggota2` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `ami_form17` -- CREATE TABLE `ami_form17` ( `id_file` int(11) NOT NULL, `id_siklus` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `file` varchar(200) NOT NULL, `tgl` datetime NOT NULL, `id_admin` int(11) NOT NULL, `sesuai` int(11) NOT NULL, `standar` text NOT NULL, `area_audit` text NOT NULL, `auditee` varchar(255) NOT NULL, `tipe_audit` varchar(255) NOT NULL, `kode` varchar(255) NOT NULL, `id_fakultas` int(11) NOT NULL, `id_prodi` int(11) NOT NULL, `id_auditor_ketua` int(11) NOT NULL, `id_anggota1` int(11) NOT NULL, `id_anggota2` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `ami_form18` -- CREATE TABLE `ami_form18` ( `id_file` int(11) NOT NULL, `id_siklus` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `file` varchar(200) NOT NULL, `tgl` datetime NOT NULL, `id_admin` int(11) NOT NULL, `sesuai` int(11) NOT NULL, `standar` text NOT NULL, `area_audit` text NOT NULL, `auditee` varchar(255) NOT NULL, `tipe_audit` varchar(255) NOT NULL, `kode` varchar(255) NOT NULL, `id_fakultas` int(11) NOT NULL, `id_prodi` int(11) NOT NULL, `id_auditor_ketua` int(11) NOT NULL, `id_anggota1` int(11) NOT NULL, `id_anggota2` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `ami_form19` -- CREATE TABLE `ami_form19` ( `id_file` int(11) NOT NULL, `id_siklus` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `file` varchar(200) NOT NULL, `tgl` datetime NOT NULL, `id_admin` int(11) NOT NULL, `sesuai` int(11) NOT NULL, `standar` text NOT NULL, `area_audit` text NOT NULL, `auditee` varchar(255) NOT NULL, `tipe_audit` varchar(255) NOT NULL, `kode` varchar(255) NOT NULL, `id_fakultas` int(11) NOT NULL, `id_prodi` int(11) NOT NULL, `id_auditor_ketua` int(11) NOT NULL, `id_anggota1` int(11) NOT NULL, `id_anggota2` int(11) NOT NULL, `kat_temuan` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `ami_form20` -- CREATE TABLE `ami_form20` ( `id_file` int(11) NOT NULL, `id_siklus` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `file` varchar(200) NOT NULL, `tgl` datetime NOT NULL, `id_admin` int(11) NOT NULL, `sesuai` int(11) NOT NULL, `standar` text NOT NULL, `area_audit` text NOT NULL, `auditee` varchar(255) NOT NULL, `tipe_audit` varchar(255) NOT NULL, `kode` varchar(255) NOT NULL, `id_fakultas` int(11) NOT NULL, `id_prodi` int(11) NOT NULL, `id_auditor_ketua` int(11) NOT NULL, `id_anggota1` int(11) NOT NULL, `id_anggota2` int(11) NOT NULL, `kat_temuan` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `ami_form14` -- ALTER TABLE `ami_form14` ADD PRIMARY KEY (`id_file`); -- -- Indeks untuk tabel `ami_form15` -- ALTER TABLE `ami_form15` ADD PRIMARY KEY (`id_file`); -- -- Indeks untuk tabel `ami_form16` -- ALTER TABLE `ami_form16` ADD PRIMARY KEY (`id_file`); -- -- Indeks untuk tabel `ami_form17` -- ALTER TABLE `ami_form17` ADD PRIMARY KEY (`id_file`); -- -- Indeks untuk tabel `ami_form18` -- ALTER TABLE `ami_form18` ADD PRIMARY KEY (`id_file`); -- -- Indeks untuk tabel `ami_form19` -- ALTER TABLE `ami_form19` ADD PRIMARY KEY (`id_file`); -- -- Indeks untuk tabel `ami_form20` -- ALTER TABLE `ami_form20` ADD PRIMARY KEY (`id_file`); -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `ami_form14` -- ALTER TABLE `ami_form14` MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `ami_form15` -- ALTER TABLE `ami_form15` MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `ami_form16` -- ALTER TABLE `ami_form16` MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `ami_form17` -- ALTER TABLE `ami_form17` MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `ami_form18` -- ALTER TABLE `ami_form18` MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `ami_form19` -- ALTER TABLE `ami_form19` MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `ami_form20` -- ALTER TABLE `ami_form20` MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;