
CREATE DATABASE laporan;

USE laporan;

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

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

CREATE TABLE laporan (
id INT AUTO_INCREMENT PRIMARY KEY,
tanggal DATETIME,
bidang VARCHAR(100),
aktivitas TEXT,
status VARCHAR(20)
);
