X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/c65b1e11059c5cf510b54c785d4a246215058f70..108e13f9199648108e61f282a56f9ab4e7bc5dc6:/db/create.sql diff --git a/db/create.sql b/db/create.sql index 0a2f4b5..a5a2e0a 100644 --- 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)