X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=schema.sql;h=c2d5d2522ef8b221e9f1c5dc806d58b6633b4d3b;hb=f2c5f4be15b6225e5e7d9f3c53084424beb32f1b;hp=67475def2d4d40a702582cd5cb54d3294506f3c0;hpb=7ce620993c1f5b89f67affe7619b385d39abed17;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)