X-Git-Url: http://git.euphorik.ch/index.cgi?a=blobdiff_plain;f=php%2Fupdate_db.php;h=356ba676b95c7d850db20fe6c8f9ed6b10a227b5;hb=eb13d74a54796fabaa4034eeb2e803f41c7424ab;hp=c094a9e1e983f34309e65c9d6b078b01d53714b1;hpb=9f4608bb190f3cd49c45aefbb4076182a1449cf8;p=cl7.git

diff --git a/php/update_db.php b/php/update_db.php
index c094a9e..356ba67 100644
--- a/php/update_db.php
+++ b/php/update_db.php
@@ -92,12 +92,13 @@ function update_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,
@@ -108,7 +109,24 @@ function update_db()
            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");
    }
 }