startdate datetime,
enddate datetime NOT NULL,
active tinyint NOT NULL DEFAULT 0,
- user_id int NOT NULL,
+ user_id int NULL,
+ quickvote tinyint NOT NULL DEFAULT 0,
primary key (id),
constraint fk_user_election foreign key (user_id) references users(id)
);
drop table if exists voters;
create table voters (
id int NOT NULL auto_increment,
- email varchar(100) NOT NULL,
- password varchar(100) NOT NULL,
+ email varchar(100) NULL,
+ password varchar(100) NULL,
contacted tinyint NOT NULL DEFAULT 0,
election_id int NOT NULL,
+ session_id varchar(32) DEFAULT NULL,
constraint fk_election_voter foreign key (election_id) references election(id),
primary key (id)
);
+
# CREATE tokens TABLE
#####################################