CREATE DATABASE db_ppl_uny;
USE db_ppl_uny;

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

INSERT INTO users VALUES(NULL,'bilhaqi28',MD5('12345678'),'Bilhaqi');

CREATE TABLE laporan(
id INT AUTO_INCREMENT PRIMARY KEY,
judul VARCHAR(200),
isi TEXT,
tanggal DATE,
penulis VARCHAR(100)
);
