create table roles (
id INTEGER primary key autoincrement,
- name TEXT
+ name TEXT,
+ system INTEGER default 0 not null
);
create table votes (
-- Test data
insert into users (email, password, name, organization, is_admin, key) values ("admin@admin.fr", "admin", "Toto (admin) Tata", "World corp", 1, "test");
-insert into roles (id, name) values (1, "Tous");
+insert into roles (id, name, system) values (1, "Tous", 1);
insert into roles (name) values ("CA");
insert into roles (name) values ("Members");