projects
/
selectricity
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added a series of files so that elections can be created and edited and
[selectricity]
/
db
/
create.sql
diff --git
a/db/create.sql
b/db/create.sql
index e6013cfaf4a62876bc203b606142015bde80d1cf..b7b50bfa70320f61ee9d4b74c79ecd8119abd9f2 100644
(file)
--- a/
db/create.sql
+++ b/
db/create.sql
@@
-22,6
+22,8
@@
create table elections (
name varchar(100) NOT NULL,
description TEXT NOT NULL,
anonymous tinyint NOT NULL DEFAULT 0,
name varchar(100) NOT NULL,
description TEXT NOT NULL,
anonymous tinyint NOT NULL DEFAULT 0,
+ startdate datetime NOT NULL,
+ enddate datetime,
primary key (id)
);
primary key (id)
);
@@
-43,8
+45,11
@@
create table candidates (
drop table if exists voters;
create table voters (
id int NOT NULL auto_increment,
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,
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)
);
primary key (id)
);
Benjamin Mako Hill
||
Want to submit a patch?