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

diff --git a/php/update_db.php b/php/update_db.php
index be2c041..a2d9ffe 100644
--- a/php/update_db.php
+++ b/php/update_db.php
@@ -34,13 +34,14 @@ function creer_db()
         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,