drop table if exists choices;
drop table if exists attachments;
drop table if exists votes;
+drop table if exists user_role;
drop table if exists roles;
drop table if exists users;
-drop table if exists user_role;
create table users (
id INTEGER primary key autoincrement,
);
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 (