name varchar(100) NOT NULL,
description TEXT NOT NULL,
anonymous tinyint NOT NULL DEFAULT 0,
+ startdate datetime NOT NULL,
+ enddate datetime,
primary key (id)
);
drop table if exists voters;
create table voters (
id int NOT NULL auto_increment,
- username varchar(100) NOT NULL,
+ email varchar(100) NOT NULL,
password varchar(100) NOT NULL,
+ contacted tinyint NOT NULL DEFAULT 0,
+ election_id int NOT NULL,
+ constraint fk_election_voter foreign key (election_id) references election(id),
primary key (id)
);