name varchar(100) NOT NULL,
description TEXT NOT NULL,
anonymous tinyint NOT NULL DEFAULT 1,
startdate datetime,
enddate datetime NOT NULL,
active tinyint NOT NULL DEFAULT 0,
name varchar(100) NOT NULL,
description TEXT NOT NULL,
anonymous tinyint NOT NULL DEFAULT 1,
startdate datetime,
enddate datetime NOT NULL,
active tinyint NOT NULL DEFAULT 0,
election_method varchar(100) DEFAULT 'ssd',
`type` varchar(100) NOT NULL,
primary key (id),
election_method varchar(100) DEFAULT 'ssd',
`type` varchar(100) NOT NULL,
primary key (id),
election_id int NOT NULL,
name varchar(100) NOT NULL,
description text NULL,
election_id int NOT NULL,
name varchar(100) NOT NULL,
description text NULL,
- picture_filename varchar(200),
- picture_data blob,
- picture_type varchar(100),
+ primary key (id)
+);
+
+# CREATE pictures TABLE
+#####################################
+
+drop table if exists pictures;
+create table pictures (
+ id int NOT NULL auto_increment,
+ filename varchar(200),
+ data blob,
+ filetype varchar(100),
+ candidate_id int NULL,
+ constraint fk_candidate_picture foreign key (candidate_id) references candidates(id),