/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : codeigniter4_db

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2024-10-13 16:25:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `mahasiswa`
-- ----------------------------
DROP TABLE IF EXISTS `mahasiswa`;
CREATE TABLE `mahasiswa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nim` varchar(20) DEFAULT NULL,
  `nama` varchar(50) DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `telepon` varchar(25) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of mahasiswa
-- ----------------------------
INSERT INTO `mahasiswa` VALUES ('1', '1234', 'agus suparno', 'Purwokerto', '0812832', 'agussuparno@gmail.com', '2024-01-27 20:04:38', '2024-01-27 20:04:38');
INSERT INTO `mahasiswa` VALUES ('3', '20210203', 'Nabila putri', 'Palimanan', '081081832', 'nabilaputri@gmail.com', '2024-01-28 05:44:33', '2024-05-31 03:56:29');
INSERT INTO `mahasiswa` VALUES ('5', '20240107', 'Dinda Hamida', 'Purwokerto', '081548205522', 'dinda2@gmail.com', '2024-02-03 16:30:57', '2024-02-03 16:46:40');
INSERT INTO `mahasiswa` VALUES ('6', '20210207', 'Fajar Purwandanu', 'Indramayu', '08122222', 'fajar_p@gmail.com', '2024-02-03 16:50:24', '2024-02-03 16:51:56');
INSERT INTO `mahasiswa` VALUES ('7', '20210188', 'Azhiim', 'Cilacap', '0813203282', 'azhiim@gmail.com', '2024-05-29 10:24:41', '2024-05-29 10:24:41');
INSERT INTO `mahasiswa` VALUES ('8', '2025007', 'Choirul Sani C', 'Banyumas', '0817777222', 'choirul@gmail.com', '2024-05-30 10:26:50', '2024-06-12 09:48:40');
INSERT INTO `mahasiswa` VALUES ('10', '202403232', 'Doni', 'Purwokerto', '0812992', 'doni@gmail.com', '2024-07-02 03:47:47', '2024-07-02 03:47:47');
