dépôts
/
cavote.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Attachments
[cavote.git]
/
schema.sql
diff --git
a/schema.sql
b/schema.sql
index
f03e176
..
20ddccb
100644
(file)
--- a/
schema.sql
+++ b/
schema.sql
@@
-48,10
+48,10
@@
create table votes (
);
create table attachments (
);
create table attachments (
+ id INTEGER primary key autoincrement,
url TEXT not null,
id_vote INTEGER not null,
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 (
);
create table choices (