www

commit 1a6704004744ce580468f253f1efd149bf0b70bf
parent ec92e4078af8cd9eec041422e5c595d1a4b03721
Author: Yoann Bonavero <yoann.b87@voila.fr>
Date:   Thu,  3 Feb 2011 10:50:19 +0100

Modification de la base de données.

Diffstat:
M
code/serveur/dump2sqlite.sh
 | 
2
+-
M
code/serveur/php/pticlic.php
 | 
3
+--

2 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/code/serveur/dump2sqlite.sh b/code/serveur/dump2sqlite.sh
@@ -15,7 +15,7 @@ create table node(eid integer primary key autoincrement, name, type, weight);
 create table relation(rid integer primary key autoincrement, start, end, type, weight);
 create table type_node(name, num);
 create table type_relation(name, num, extended_name, info);
-create table user(login primary key, mail, hash_passwd);
+create table user(login primary key, mail, hash_passwd, score);
 create table game(gid integer primary key autoincrement, eid_central_word, relation_1, relation_2, difficulty);
 create table game_cloud(gid, num, difficulty, eid_word, totalWeight, probaR1, probaR2, probaR0, probaTrash);
 create table played_game(pgid integer primary key autoincrement, gid, login);
diff --git a/code/serveur/php/pticlic.php b/code/serveur/php/pticlic.php
@@ -18,8 +18,7 @@ if (!$db = new SQlite3($SQL_DBNAME)) {
 
 function initdb() {
 	global $db;
-	$db->exec("insert into user(login, mail, hash_passwd) values('foo', 'foo@isp.com', '".md5('bar')."');");
-	echo "INIT DB";
+	$db->exec("insert into user(login, mail, hash_passwd, score) values('foo', 'foo@isp.com', '".md5('bar')."', 0);");
 }
 
 if ($do_initdb) { initdb(); }