PRIMARY KEY (id)
);
");
- pg_query("
- CREATE TABLE jeux (
- id serial NOT NULL,
- nom varchar(200) NOT NULL,
- PRIMARY KEY (id),
- UNIQUE (nom)
- );
- ");
+ // participants.password est un hash calculé à l'aide de sha1().
pg_query("
CREATE TABLE participants (
id int NOT NULL,
pseudo varchar(50) DEFAULT NULL,
clan_nom varchar(30) DEFAULT NULL,
clan_tag varchar(10) DEFAULT NULL,
- password varchar(10) DEFAULT NULL,
+ password char(40) DEFAULT NULL,
nom varchar(30) DEFAULT NULL,
prenom varchar(30) DEFAULT NULL,
age varchar(30) DEFAULT NULL,
FOREIGN KEY (pizza) REFERENCES pizzas (id) ON DELETE SET NULL ON UPDATE SET NULL
);
");
+ pg_query("
+ CREATE TABLE jeux (
+ id serial NOT NULL,
+ participant_id int default NULL,
+ nom varchar(200) NOT NULL,
+ type varchar(100) DEFAULT NULL,
+ url varchar(200) DEFAULT NULL,
+ PRIMARY KEY (id),
+ UNIQUE (nom),
+ FOREIGN KEY (participant_id) REFERENCES participants (id) ON DELETE SET NULL ON UPDATE SET NULL
+ );
+ ");
pg_query("
CREATE TABLE jeux_choisis (
participant_id int NOT NULL,