www

commit bdcb11db42cb9739cb8741c61b4870f696532d76
parent 4d079c4974e42f1aabf93547e32ac29c26d3fd4d
Author: Bertrand BRUN <bertrand0brun@gmail.com>
Date:   Thu, 20 Jan 2011 15:14:56 +0100

Merge branch 'master' of https://github.com/jsmaniac/2011-m1s2-ter

Diffstat:
M
code/serveur/dump2sql.sh
 | 
15
++++++++++++++-

1 file changed, 14 insertions(+), 1 deletion(-)
diff --git a/code/serveur/dump2sql.sh b/code/serveur/dump2sql.sh
@@ -11,6 +11,11 @@ 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(nom, num);
 create table type_relation(nom, num, nom_etendu, info);
+create table user(login primary key, mail, hash_mdp);
+create table sessid(login, sid);
+create table partie(pid, eid_mot_central, relation_1, relation_2, relation_3, relation_4);
+create table partie_nuage(pid, num, eid_mod);
+create table partie_reference(pid, num, relation, poids);
 EOF
 
 # tr : pour virer le CRLF qui traîne
@@ -28,4 +33,12 @@ cat "$1" \
 | grep -v '^//' \
 | grep -v '^$'
 
-echo "commit;"
+cat <<EOF
+create index i_relation_start on relation(start);
+create index i_relation_end on relation(end);
+create index i_relation_type on relation(type);
+create index i_relation_end_type on relation(end,type);
+create index i_sessid_login on sessid(login);
+create index i_sessid_sid on sessid(sid);
+commit;
+EOF