schema.sql

   1 drop table if exists votes;
   2 create table votes (
   3     id INTEGER primary key autoincrement,
   4     title TEXT not null,
   5     description TEXT,
   6     category TEXT,
   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,
  15     --id_role INTEGER,
  16     --FOREIGN KEY(id_author) REFERENCES user(id),
  17     --FOREIGN KEY(id_role) REFERENCES role(id)
  18 );
  19
  20