X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/a6c1e9a2e0cb4243fd48b83af0281eccef408b04..3b0796e07c96f807b53fd54fed0ae021273120f5:/db/create.sql?ds=sidebyside diff --git a/db/create.sql b/db/create.sql index c28dd36..2acf948 100644 --- a/db/create.sql +++ b/db/create.sql @@ -114,32 +114,6 @@ create table sessions ( index session_index (sessid) ); -# 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 drop table if exists users; create table users ( id int not null auto_increment,