{
# si la table 'config' n'existe pas alors on suppose qu'aucune table n'existe
$version = 0;
- if(!$version = (int)@mysql_fetch_object(mysql_query("SELECT valeur FROM config WHERE nom = 'version'")))
+ $res = @mysql_fetch_object(mysql_query("SELECT valeur FROM config WHERE nom = 'version'"));
+ if (!mysql_error())
+ $version = $res->valeur;
+
+ if($version == 0)
{
mysql_query("BEGIN TRANSACTION");
creer_db();
CREATE TABLE IF NOT EXISTS periodes (
id mediumint(3) unsigned NOT NULL auto_increment,
nom varchar(200) NOT NULL,
+ nom_abrege varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
");
- mysql_query("INSERT INTO periodes (nom) VALUES ('Vendredi soir à samedi')");
- mysql_query("INSERT INTO periodes (nom) VALUES ('Samedi à dimanche')");
- mysql_query("INSERT INTO periodes (nom) VALUES ('Dimanche à lundi')");
+ mysql_query("INSERT INTO periodes (nom, nom_abrege) VALUES ('vendredi soir à samedi', 'v->s')");
+ mysql_query("INSERT INTO periodes (nom, nom_abrege) VALUES ('samedi à dimanche', 's->d')");
+ mysql_query("INSERT INTO periodes (nom, nom_abrege) VALUES ('dimanche à lundi', 'd->l')");
mysql_query("
CREATE TABLE IF NOT EXISTS participations (
participant_id mediumint(3) unsigned NOT NULL,
CONSTRAINT FK_periode_participations FOREIGN KEY (periode_id) REFERENCES periodes (id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
");
- mysql_query("UPDATE config SET valeur = '2' WHERE nom = 'version')");
+ $participations = mysql_query("SELECT participants.id as participant_id, periodes.id as periode_id FROM participants, periodes");
+ while ($participation = mysql_fetch_object($participations))
+ {
+ mysql_query("
+ INSERT INTO participations (participant_id, periode_id)
+ VALUES (".$participation->participant_id.",".$participation->periode_id.")"
+ );
+ }
+ mysql_query("UPDATE config SET valeur = '2' WHERE nom = 'version'");
+
+ mysql_query("INSERT INTO config (nom, valeur) VALUES ('cout_periode', '15')");
+ mysql_query("INSERT INTO config (nom, valeur) VALUES ('cout_total', '40')");
+ mysql_query("INSERT INTO config (nom, valeur) VALUES ('nb_max_participant', '25')");
+ mysql_query("INSERT INTO config (nom, valeur) VALUES ('nb_votes_jeux', '3')");
+ mysql_query("INSERT INTO config (nom, valeur) VALUES ('inscription_terminees', 'FALSE')");
+ mysql_query("INSERT INTO config (nom, valeur) VALUES ('pizza_visible', 'FALSE')");
+ mysql_query("INSERT INTO config (nom, valeur) VALUES ('pizza_peut_commander', 'TRUE')");
+
mysql_query("COMMIT");
}
}