X-Git-Url: https://projects.mako.cc/source/selectricity/blobdiff_plain/afa6b59aed60497d059af87c049c0b4f1a6c8b6c..6fdb49ee0dfc76980bcefb18968d1e1c55c8149c:/db/create.sql diff --git a/db/create.sql b/db/create.sql old mode 100755 new mode 100644 index 0a2f4b5..a5a2e0a --- a/db/create.sql +++ b/db/create.sql @@ -3,7 +3,7 @@ drop table if exists elections; create table elections ( - id int NOT NULL auto_increment, + id int NOT NULL auto_increment, name varchar(100) NOT NULL, description TEXT NOT NULL, anonymous tinyint NOT NULL DEFAULT 1, @@ -11,6 +11,8 @@ create table elections ( enddate datetime NOT NULL, active tinyint NOT NULL DEFAULT 0, user_id int NULL, + quickuser varchar(255) NULL, #stores session_id for quickvote creators + election_method varchar(100) DEFAULT 'ssd', `type` varchar(100) NOT NULL, primary key (id), constraint fk_user_election foreign key (user_id) references users(id)