Ggames.sql

-- This is the SQL for the database structure from the GGames website --

DROP DATABASE IF EXISTS GGames;
CREATE DATABASE GGames;
USE GGames;

CREATE TABLE users (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    email VARCHAR(100) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
	username VARCHAR(255) NOT NULL,
	istAdmin TINYINT(1) NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE video_game (
	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	name VARCHAR(100) NOT NULL,
	entwickler VARCHAR(100) NOT NULL,
	img VARCHAR(100) NOT NULL,
	price VARCHAR(100) NOT NULL
);

CREATE TABLE kaeufe (
	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fk_usersId INT NOT NULL,
	fk_video_gameId INT NOT NULL,
	FOREIGN KEY (fk_usersId) REFERENCES users(id),
	FOREIGN KEY (fk_video_gameId) REFERENCES video_game(id)
);