-- Table: användare
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
role ENUM('user','admin') NOT NULL DEFAULT 'user'
);
-- Optional: add an initial admin user
INSERT INTO users (username, password, role)
VALUES ('admin', '<hashed_password_here>', 'admin');
-- Table: trasaktioner
CREATE TABLE trasaktioner (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
amount DECIMAL(10,2) NOT NULL,
type ENUM('credit','debit') NOT NULL,
FOREIGN KEY (username) REFERENCES users(username) ON DELETE CASCADE
);
-- Example: optional initial transaction for a user
INSERT INTO trasaktioner (username, amount, type)
VALUES ('admin', 1000.00, 'credit');