www

commit 3379b3208e643f69b482cccec5256762c140a9e7
parent e0665b6dcb4b789bc2569d3fff3d4ae09ebadcbb
Author: Georges Dupéron <jahvascriptmaniac+github@free.fr>
Date:   Thu, 20 Jan 2011 14:40:03 +0100

Ajout de quelques tables.

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