X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/ad5ca8bbfbef358919aa877e78dceb27fdc6387a..6fdb49ee0dfc76980bcefb18968d1e1c55c8149c:/db/create.sql?ds=sidebyside diff --git a/db/create.sql b/db/create.sql index 7b3fef5..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,7 @@ 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),