
CREATE DATABASE kirim_tugas;
USE kirim_tugas;
CREATE TABLE users(id INT AUTO_INCREMENT PRIMARY KEY,nama VARCHAR(100),username VARCHAR(50),password VARCHAR(255),role ENUM('admin','siswa'));
CREATE TABLE tugas(id INT AUTO_INCREMENT PRIMARY KEY,judul VARCHAR(100),deskripsi TEXT,deadline DATE);
CREATE TABLE pengumpulan(id INT AUTO_INCREMENT PRIMARY KEY,user_id INT,tugas_id INT,file VARCHAR(255),tanggal DATE,nilai INT);
