- mysql_query("
- CREATE TABLE IF NOT EXISTS participants (
- id mediumint(3) unsigned NOT NULL auto_increment,
- pseudo varchar(50) default NULL,
- clan_nom varchar(30) default NULL,
- clan_tag varchar(10) default NULL,
- password varchar(10) default NULL,
- nom varchar(30) default NULL,
- prenom varchar(30) default NULL,
- age varchar(30) default NULL,
- e_mail varchar(50) default NULL,
- remarques varchar(255) default NULL,
- admin tinyint(1) unsigned NOT NULL default '0',
- a_paye tinyint(1) unsigned NOT NULL default '0',
- pizza mediumint(3) unsigned default NULL,
- pizza_paye tinyint(1) NOT NULL default '0',
- PRIMARY KEY (id),
- KEY FK_pizza (pizza),
- CONSTRAINT FK_pizza FOREIGN KEY (pizza) REFERENCES pizzas (id) ON DELETE SET NULL ON UPDATE SET NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
+ pg_query("
+ CREATE TABLE jeux_choisis (
+ participant_id int NOT NULL,
+ jeu_id int NOT NULL,
+ PRIMARY KEY (participant_id, jeu_id),
+ FOREIGN KEY (participant_id) REFERENCES participants (id) ON DELETE CASCADE ON UPDATE CASCADE,
+ FOREIGN KEY (jeu_id) REFERENCES jeux (id) ON DELETE CASCADE ON UPDATE CASCADE
+ );
+ ");
+ pg_query("
+ CREATE TABLE periodes (
+ id serial NOT NULL,
+ nom varchar(200) NOT NULL,
+ nom_abrege varchar(20) NOT NULL DEFAULT '',
+ PRIMARY KEY (id)
+ );