Friday, 21 November 2025

tipe data beda SiM dan Laptop

 di server SiM
MariaDB [moodle2]> SHOW CREATE TABLE mdl_local_jurnalmengajar\G
*************************** 1. row ***************************
       Table: mdl_local_jurnalmengajar
Create Table: CREATE TABLE `mdl_local_jurnalmengajar` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `nomor` bigint(10) NOT NULL DEFAULT 0,
  `kelas` varchar(20) NOT NULL,
  `jamke` varchar(10) DEFAULT NULL,
  `matapelajaran` varchar(100) NOT NULL,
  `materi` longtext NOT NULL,
  `aktivitas` longtext NOT NULL,
  `absen` longtext DEFAULT NULL,
  `keterangan` longtext DEFAULT NULL,
  `pramuka` tinyint(1) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_locajurn_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=6596 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPRESSED COMMENT='Tabel jurnal mengajar guru'
1 row in set (0.000 sec)

di laptop Ubuntu saya
MariaDB [moodle]> SHOW CREATE TABLE mdl_local_jurnalmengajar\G
*************************** 1. row ***************************
       Table: mdl_local_jurnalmengajar
Create Table: CREATE TABLE `mdl_local_jurnalmengajar` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `nomor` bigint(10) NOT NULL,
  `kelas` varchar(20) NOT NULL DEFAULT '',
  `jamke` tinyint(2) NOT NULL,
  `matapelajaran` varchar(100) NOT NULL DEFAULT '',
  `materi` longtext NOT NULL,
  `kegiatan` longtext NOT NULL,
  `absen` longtext DEFAULT NULL,
  `keterangan` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_locajurn_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPRESSED COMMENT='Tabel jurnal mengajar guru'
1 row in set (0.052 sec)

di laptop Ubuntu saya sekarang:
MariaDB [moodle]> SHOW CREATE TABLE mdl_local_jurnalmengajar\G
*************************** 1. row ***************************
       Table: mdl_local_jurnalmengajar
Create Table: CREATE TABLE `mdl_local_jurnalmengajar` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `nomor` bigint(10) NOT NULL,
  `kelas` varchar(20) NOT NULL DEFAULT '',
  `jamke` varchar(10) DEFAULT NULL,
  `matapelajaran` varchar(100) NOT NULL DEFAULT '',
  `materi` longtext NOT NULL,
  `aktivitas` longtext NOT NULL,
  `absen` longtext DEFAULT NULL,
  `keterangan` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_locajurn_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPRESSED COMMENT='Tabel jurnal mengajar guru'
1 row in set (0.003 sec)

Share:

0 comments:

Post a Comment