Raspsnir/db/init.sql

4 lines
333 B
SQL

CREATE TABLE IF NOT EXISTS login (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, pseudo TEXT NOT NULL, prenom TEXT NOT NULL, nom TEXT NOT NULL, mdp TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS tetris (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, date DATETIME NOT NULL, pseudo TEXT NOT NULL, score TEXT NOT NULL, ip TEXT NOT NULL);