X-Git-Url: https://projects.mako.cc/source/selectricity/blobdiff_plain/7b649ccad8804580632c255b9f451482fdbbe32d..947bdc28cd01bc025ffde2af3472b38e5d30f9d1:/db/create.sql diff --git a/db/create.sql b/db/create.sql index 298b99a..2acf948 100644 --- a/db/create.sql +++ b/db/create.sql @@ -10,6 +10,8 @@ create table elections ( startdate datetime, enddate datetime NOT NULL, active tinyint NOT NULL DEFAULT 0, + viewable tinyint NOT NULL DEFAULT 1, + notices 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', @@ -56,6 +58,7 @@ create table voters ( election_id int NOT NULL, session_id varchar(32) DEFAULT NULL, ipaddress varchar(32) DEFAULT NULL, + `type` varchar(100) NOT NULL, constraint fk_election_voter foreign key (election_id) references election(id), primary key (id) ); @@ -98,32 +101,19 @@ create table rankings ( primary key (id) ); -# CREATE users TABLE -##################################### -#DROP TABLE IF EXISTS `users`; -#CREATE TABLE `users` ( -# `id` int(11) NOT NULL auto_increment, -# `login` varchar(80) NOT NULL default '', -# `salted_password` varchar(40) NOT NULL default '', -# `email` varchar(60) NOT NULL default '', -# `firstname` varchar(40) default NULL, -# `lastname` varchar(40) default NULL, -# `salt` varchar(40) NOT NULL default '', -# `verified` int(11) default '0', -# `role` varchar(40) default NULL, -# `security_token` varchar(40) default NULL, -# `token_expiry` datetime default NULL, -# `created_at` datetime default NULL, -# `updated_at` datetime default NULL, -# `logged_in_at` datetime default NULL, -# `deleted` int(11) default '0', -# `delete_after` datetime default NULL, -# PRIMARY KEY (`id`) -#) ENGINE=InnoDB DEFAULT CHARSET=latin1; - -#Following is the new users table that goes with acts_as_authenticated -#Is simpler for now, saving the old table while in transition between -#the two for ideas on what attributes may be helpful/necessary +# CREATE sessions TABLE +###################################### + +drop table if exists sessions; +create table sessions ( + id int(11) NOT NULL auto_increment, + sessid varchar(255), + data text, + updated_at datetime DEFAULT NULL, + primary key (id), + index session_index (sessid) +); + drop table if exists users; create table users ( id int not null auto_increment,