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 (
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,