CREATE DATABASE izin_sekolah;
USE izin_sekolah;

-- TABEL LOGIN
CREATE TABLE users(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50),
password VARCHAR(50),
role VARCHAR(20)
);

INSERT INTO users VALUES
(NULL,'ucup','123','ucup'),
(NULL,'wali','123','wali');


-- TABEL IZIN SEKOLAH
CREATE TABLE izin(
id INT AUTO_INCREMENT PRIMARY KEY,
nama VARCHAR(100),
kelas VARCHAR(20),
keterangan TEXT,
izin_dari DATE,
izin_sampai DATE,
nama_ortu VARCHAR(100),
ttd VARCHAR(200),
status VARCHAR(20) DEFAULT 'Menunggu'
);