4 lines
333 B
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);
|