X-Git-Url: http://git.euphorik.ch/?a=blobdiff_plain;f=php%2Fupdate_db.php;h=969f8a14ab425b67c826ac6ff44a1a165d1c8801;hb=424a8f0a34fc72fe64daaac4686f991a298933a3;hp=be2c041dc9645816d01af15766914a2eebcef062;hpb=23bc2016d5fbd8f7daa9b7ba5c7fa862709ff7a7;p=cl7.git

diff --git a/php/update_db.php b/php/update_db.php
index be2c041..969f8a1 100644
--- a/php/update_db.php
+++ b/php/update_db.php
@@ -26,21 +26,14 @@ function creer_db()
         PRIMARY KEY  (id)
       );
    ");
-   pg_query("
-      CREATE TABLE jeux (
-        id serial NOT NULL,
-        nom varchar(200) NOT NULL,
-        PRIMARY KEY (id),
-        UNIQUE (nom)
-      );
-   ");
+   // participants.password est un hash calculé à l'aide de sha1().
    pg_query("
       CREATE TABLE participants (
         id int NOT NULL,
         pseudo varchar(50) DEFAULT NULL,
         clan_nom varchar(30) DEFAULT NULL,
         clan_tag varchar(10) DEFAULT NULL,
-        password varchar(10) DEFAULT NULL,
+        password char(40) DEFAULT NULL,
         nom varchar(30) DEFAULT NULL,
         prenom varchar(30) DEFAULT NULL,
         age varchar(30) DEFAULT NULL,
@@ -55,6 +48,18 @@ function creer_db()
         FOREIGN KEY (pizza) REFERENCES pizzas (id) ON DELETE SET NULL ON UPDATE SET NULL
       );
    ");
+   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
+      );
+   ");
    pg_query("
       CREATE TABLE jeux_choisis (
         participant_id int NOT NULL,