X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/4e41e4ab171d4d47cdac0f8676bf78d36e6eb007..c5a7b7b17d7e2586a6234d1622e7babd3c0d99e0:/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,