ADD informations concernant les jours pendant lesquels les participants sont présent...

[cl7.git] / update_db.php

diff --git a/update_db.php b/update_db.php
index 3cce184..5ff5904 100644 (file)
--- a/update_db.php
+++ b/update_db.php
@@ -55,8 +55,8 @@ function creer_db()
    ");
    mysql_query("
       CREATE TABLE IF NOT EXISTS jeux_choisis (
-        participant_id mediumint(3) unsigned NOT NULL default '0',
-        jeu_id mediumint(3) unsigned NOT NULL default '0',
+        participant_id mediumint(3) unsigned NOT NULL,
+        jeu_id mediumint(3) unsigned NOT NULL,
         PRIMARY KEY USING BTREE (participant_id,jeu_id),
         KEY FK_jeu (jeu_id),
         CONSTRAINT FK_participant FOREIGN KEY (participant_id) REFERENCES participants (id) ON DELETE CASCADE ON UPDATE CASCADE,
@@ -74,7 +74,7 @@ function update_db()
 {
    # si la table 'config' n'existe pas alors on suppose qu'aucune table n'existe
    $version = 0;
-   if(!$version = @mysql_fetch_object(mysql_query("SELECT valeur FROM config WHERE nom = 'version'")))
+   if(!$version = (int)@mysql_fetch_object(mysql_query("SELECT valeur FROM config WHERE nom = 'version'")))
    {
       mysql_query("BEGIN TRANSACTION");
       creer_db();
@@ -82,6 +82,34 @@ function update_db()
       mysql_query("COMMIT");
       $version = 1;
    }
+   
+   # version 1 -> 2
+   if ($version == 1)
+   {
+      mysql_query("BEGIN TRANSACTION");
+      mysql_query("
+         CREATE TABLE IF NOT EXISTS periodes (
+           id mediumint(3) unsigned NOT NULL auto_increment,
+           nom varchar(200) NOT NULL,
+           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("
+         CREATE TABLE IF NOT EXISTS participations (
+           participant_id mediumint(3) unsigned NOT NULL,
+           periode_id mediumint(3) unsigned NOT NULL,
+           PRIMARY KEY USING BTREE (participant_id, periode_id),
+           KEY FK_periode (periode_id),
+           CONSTRAINT FK_participant_participations FOREIGN KEY (participant_id) REFERENCES participants (id) ON DELETE CASCADE ON UPDATE CASCADE,
+           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')");
+      mysql_query("COMMIT");
+   }
 }
 
 update_db();