Install XML di Laptop Jumat 21 November 2025

 $ sudo cat /var/www/html/moodle/local/jurnalmengajar/db/install.xml
<?xml version="1.0" encoding="UTF-8" ?>
<XMLDB PATH="local/jurnalmengajar/db" VERSION="2025102907" COMMENT="XMLDB file for jurnal mengajar plugin"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd">
  <TABLES>

    <!-- ===================== INTI: Jurnal Mengajar ===================== -->
    <TABLE NAME="local_jurnalmengajar" COMMENT="Tabel jurnal mengajar guru">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="nomor" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="kelas" TYPE="char" LENGTH="20" NOTNULL="true"/>
        <FIELD NAME="jamke" TYPE="int" LENGTH="2" NOTNULL="true"/>
        <FIELD NAME="matapelajaran" TYPE="char" LENGTH="100" NOTNULL="true"/>
        <FIELD NAME="materi" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="kegiatan" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="absen" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="keterangan" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
        <KEY NAME="userid_fk" TYPE="foreign" FIELDS="userid" REFTABLE="user" REFFIELDS="id"/>
      </KEYS>
    </TABLE>

    <!-- ===================== Surat Izin Siswa ===================== -->
    <TABLE NAME="local_jurnalmengajar_suratizin" COMMENT="Data surat izin siswa">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true"/>
        <FIELD NAME="kelasid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true"/>
        <FIELD NAME="guru_pengajar" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true"/>
        <FIELD NAME="alasan" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="keperluan" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="penginput" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true"/>
        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
        <KEY NAME="userid_fk" TYPE="foreign" FIELDS="userid" REFTABLE="user" REFFIELDS="id"/>
        <KEY NAME="penginput_fk" TYPE="foreign" FIELDS="penginput" REFTABLE="user" REFFIELDS="id"/>
        <KEY NAME="guru_pengajar_fk" TYPE="foreign" FIELDS="guru_pengajar" REFTABLE="user" REFFIELDS="id"/>
      </KEYS>
    </TABLE>

    <!-- ===================== Layanan BK ===================== -->
    <TABLE NAME="local_jurnallayananbk" COMMENT="Jurnal layanan BK">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true" COMMENT="Primary key"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" COMMENT="ID guru BK"/>
        <FIELD NAME="kelas" TYPE="char" LENGTH="20" NOTNULL="true" COMMENT="Nama kelas"/>
        <FIELD NAME="jenislayanan" TYPE="char" LENGTH="20" NOTNULL="true" COMMENT="Jenis layanan"/>
        <FIELD NAME="topik" TYPE="char" LENGTH="255" NOTNULL="false" COMMENT="Topik atau masalah"/>
        <FIELD NAME="peserta" TYPE="text" NOTNULL="false" COMMENT="JSON daftar siswa"/>
        <FIELD NAME="tindaklanjut" TYPE="text" NOTNULL="false" COMMENT="Tindak lanjut"/>
        <FIELD NAME="catatan" TYPE="text" NOTNULL="false" COMMENT="Catatan tambahan"/>
        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" COMMENT="Waktu input"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
        <KEY NAME="userid_fk" TYPE="foreign" FIELDS="userid" REFTABLE="user" REFFIELDS="id"/>
      </KEYS>
    </TABLE>

    <!-- ===================== Beban Mengajar per Minggu ===================== -->
    <TABLE NAME="local_jurnalmengajar_beban" COMMENT="Beban jam mengajar per minggu">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true" UNSIGNED="true"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="jam_perminggu" TYPE="int" LENGTH="11" NOTNULL="true"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
      </KEYS>
    </TABLE>

    <!-- ===================== Surat Izin oleh Guru ===================== -->
    <TABLE NAME="local_jurnalmengajar_suratizinguru" COMMENT="Surat izin oleh guru">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="alasan" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="keperluan" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="waktuinput" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="nip" TYPE="char" LENGTH="50" NOTNULL="false"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
      </KEYS>
    </TABLE>

    <!-- ===================== Pramuka ===================== -->
    <TABLE NAME="local_jurnalpramuka" COMMENT="Jurnal pramuka">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="kelas" TYPE="char" LENGTH="50" NOTNULL="true"/>
        <FIELD NAME="materi" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="absen" TYPE="text" NOTNULL="true"/>
        <FIELD NAME="catatan" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
      </KEYS>
    </TABLE>

    <!-- ===================== Guru Wali ===================== -->
    <TABLE NAME="local_jurnalguruwali" COMMENT="Jurnal guru wali kelas">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
        <FIELD NAME="guruid" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="muridid" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="topik" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="tindaklanjut" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="keterangan" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
      </KEYS>
      <INDEXES>
        <INDEX NAME="mdl_locajurn_tim_ix" UNIQUE="false" FIELDS="timecreated"/>
        <INDEX NAME="mdl_locajurn_gur_ix" UNIQUE="false" FIELDS="guruid"/>
        <INDEX NAME="mdl_locajurn_mur_ix" UNIQUE="false" FIELDS="muridid"/>
      </INDEXES>
    </TABLE>

    <!-- ===================== Pembinaan ===================== -->
    <TABLE NAME="local_jurnalpembinaan" COMMENT="Jurnal pembinaan siswa">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true"/>
        <FIELD NAME="kelas" TYPE="char" LENGTH="20" NOTNULL="true" DEFAULT=""/>
        <FIELD NAME="peserta" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="permasalahan" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="tindakan" TYPE="text" NOTNULL="false"/>
        <FIELD NAME="tempat" TYPE="char" LENGTH="255" NOTNULL="false"/>
        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
      </KEYS>
      <INDEXES>
        <INDEX NAME="mdl_locajurn_use_ix" UNIQUE="false" FIELDS="userid"/>
      </INDEXES>
    </TABLE>

    <!-- ===================== Nilai Harian ===================== -->
    <TABLE NAME="local_jm_nilaiharian" COMMENT="Nilai harian (rekap import dari quiz)">
      <FIELDS>
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
        <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0"/>
        <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0"/>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0"/>
        <FIELD NAME="mapel" TYPE="char" LENGTH="100" NOTNULL="true" DEFAULT=""/>
        <FIELD NAME="cohortid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0"/>
        <FIELD NAME="kelas" TYPE="char" LENGTH="100" NOTNULL="true" DEFAULT=""/>
        <FIELD NAME="tanggal" TYPE="char" LENGTH="10" NOTNULL="true" DEFAULT=""/>
        <FIELD NAME="nilaijson" TYPE="text" NOTNULL="false"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
      </KEYS>
      <INDEXES>
        <INDEX NAME="mdl_locajmnila_coh_ix" UNIQUE="false" FIELDS="cohortid"/>
        <INDEX NAME="mdl_locajmnila_tan_ix" UNIQUE="false" FIELDS="tanggal"/>
        <INDEX NAME="mdl_locajmnila_use_ix" UNIQUE="false" FIELDS="userid"/>
      </INDEXES>
    </TABLE>

  </TABLES>
</XMLDB>