add comments support

[cavote.git] / schema.sql

diff --git a/schema.sql b/schema.sql
index 67475de..c2d5d25 100644 (file)
--- 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)