+ 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
+ );
+ ");