z0qWn5LX

1USE mysql;
2DROP USER IF EXISTS 'shodan_username'@'localhost';
3CREATE USER 'shodan_username'@'localhost' IDENTIFIED BY 'shodan_password';
4DROP DATABASE IF EXISTS shodan;
5CREATE DATABASE shodan;
6GRANT ALL ON shodan.* TO 'shodan_username'@'localhost';
7SET SQL_SAFE_UPDATES = 0;
8USE shodan;
9
10DROP TABLE IF EXISTS users;
11CREATE TABLE users(
12	user_id int NOT NULL AUTO_INCREMENT,
13	user_name varchar(16) NOT NULL,
14    user_password varchar(16) NOT NULL,
15    user_avatar varchar(16),
16    user_email varchar(16),
17    
18    PRIMARY KEY(user_id)
19);
20
21DROP TABLE IF EXISTS games;
22CREATE TABLE games(
23	game_id int NOT NULL AUTO_INCREMENT,
24	game_name varchar(16) NOT NULL,
25    game_image varchar(16) NOT NULL,
26    game_description varchar(32),
27    game_price int,
28    game_release date,
29    
30    PRIMARY KEY(game_id)
31);
32
33DROP TABLE IF EXISTS has_game;
34CREATE TABLE has_game(
35	user_id int NOT NULL,
36	game_id int NOT NULL,
37    
38    PRIMARY KEY(user_id, game_id)
39)