CREATE DATABASE kantin_sekolah;
USE kantin_sekolah;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50),
    password VARCHAR(50),
    role ENUM('penjual','pembeli')
);

INSERT INTO users (username,password,role) VALUES
('penjual1','123','penjual'),
('pembeli1','123','pembeli');

CREATE TABLE menu (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nama_menu VARCHAR(100),
    harga INT
);

INSERT INTO menu (nama_menu,harga) VALUES
('Nasi Goreng',15000),
('Mie Ayam',12000),
('Es Teh',5000);