SkillsGames-server/sql/create.sql

12 lines
360 B
SQL

CREATE TABLE games (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
publishedLink VARCHAR(255) NOT NULL,
year INT NOT NULL,
state VARCHAR(255) NOT NULL,
education VARCHAR(255) NOT NULL,
level VARCHAR(255) NOT NULL,
place VARCHAR(255) NOT NULL,
name1 VARCHAR(255) NOT NULL,
name2 VARCHAR(255) NOT NULL
);