CREATE DATABASE IF NOT EXISTS bagtime_db;

USE bagtime_db;

-- Create users table
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL
);

CREATE TABLE IF NOT EXISTS agenda (
    id INT AUTO_INCREMENT PRIMARY KEY,
    no VARCHAR(50) NOT NULL,
    agenda VARCHAR(255) NOT NULL,
    hari VARCHAR(20) NOT NULL,
    tanggal DATE NOT NULL
);

-- Insert sample data
INSERT INTO agenda (no, agenda, hari, tanggal) VALUES
('001', 'Rapat Tim', 'Senin', '2025-12-16'),
('002', 'Presentasi Proyek', 'Selasa', '2025-12-17'),
('003', 'Meeting dengan Client', 'Rabu', '2025-12-18'),
('004', 'Review Kode', 'Kamis', '2025-12-19'),
('005', 'Workshop Internal', 'Jumat', '2025-12-20');
