+drop table if exists choices;
drop table if exists votes;
drop table if exists users;
is_public INTEGER default 1 not null,
is_multiplechoice INTEGER default 1 not null,
is_weighted INTEGER default 0 not null,
- is_closed INTEGER default 0 not null,
+ is_open INTEGER default 0 not null,
id_author INTEGER, -- :COMMENT:maethor:120528: not null ?
--id_role INTEGER,
FOREIGN KEY(id_author) REFERENCES users(id)
--FOREIGN KEY(id_role) REFERENCES role(id)
);
+create table choices (
+ id INTEGER primary key autoincrement,
+ name TEXT not null,
+ id_vote INTEGER not null,
+ FOREIGN KEY(id_vote) REFERENCES vote(id)
+);
+
-- Test data
insert into users (email, password, name, organization, is_admin, key) values ("admin@admin.fr", "admin", "Toto (admin) Tata", "World corp", 1, "test");