X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=schema.sql;h=c2d5d2522ef8b221e9f1c5dc806d58b6633b4d3b;hb=ea164cc2f337b06970a83a55af9b8a384bd34a7c;hp=67475def2d4d40a702582cd5cb54d3294506f3c0;hpb=afd25590c57cd685b4636a28bac0bf53456ee861;p=cavote.git

diff --git a/schema.sql b/schema.sql
index 67475de..c2d5d25 100644
--- a/schema.sql
+++ b/schema.sql
@@ -122,6 +122,7 @@ create table user_vote (
     date INTEGER DEFAULT CURRENT_TIMESTAMP NOT NULL,
     id_user INTEGER NOT NULL,
     id_vote INTEGER NOT NULL,
+    comment TEXT,
     FOREIGN KEY(id_user) REFERENCES users (id) ON DELETE CASCADE,
     FOREIGN KEY(id_vote) REFERENCES votes (id) ON DELETE CASCADE,
     PRIMARY KEY(id_user, id_vote)