);
create table attachments (
+ id INTEGER primary key autoincrement,
url TEXT not null,
id_vote INTEGER not null,
- FOREIGN KEY(id_vote) REFERENCES vote(id),
- PRIMARY KEY(url, id_vote)
+ FOREIGN KEY(id_vote) REFERENCES vote(id)
);
create table choices (