-- Create tb_user table if it doesn't exist
CREATE TABLE IF NOT EXISTS tb_user (
    id_user INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL
);

-- Insert default user (username: admin, password: admin)
INSERT INTO tb_user (username, password) VALUES ('admin', 'admin')
ON DUPLICATE KEY UPDATE password = 'admin';
