4b2393440d0dfa53db5e8a714d4ed18865ccfaec
1 drop table if exists votes
;
3 id INTEGER primary key autoincrement
,
7 date_begin
INTEGER default CURRENT_TIMESTAMP not null,
8 date_end
INTEGER not null,
9 is_transparent
INTEGER default 1 not null,
10 is_public
INTEGER default 1 not null,
11 is_multiplechoice
INTEGER default 1 not null,
12 is_weighted
INTEGER default 0 not null,
13 is_closed
INTEGER default 0 not null
14 --id_author INTEGER not null,
16 --FOREIGN KEY(id_author) REFERENCES user(id),
17 --FOREIGN KEY(id_role) REFERENCES role(id)