
CREATE DATABASE IF NOT EXISTS bultmeyer_ffn;
USE bultmeyer_ffn;

CREATE TABLE users (
 id INT AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(255),
 email VARCHAR(255),
 password VARCHAR(255),
 role VARCHAR(50)
);

INSERT INTO users(name,email,password,role)
VALUES
('Admin','admin@bultmeyer.local','admin123','admin'),
('Max Kunde','kunde@bultmeyer.local','kunde123','customer');
