CREATE DATABASE db_nilai;
USE db_nilai;

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50),
  password VARCHAR(255)
);

CREATE TABLE nilai (
  id INT AUTO_INCREMENT PRIMARY KEY,
  nama_siswa VARCHAR(100),
  mata_pelajaran VARCHAR(100),
  guru VARCHAR(50),
  nilai INT
);

INSERT INTO users (username, password)
VALUES ('admin', MD5('admin123'));