User:MrCalifornia/tvolt roadmap

user

• need email verification stuff
  • verify_email table

database tables

users

drop table if exists users;
create table users (
	id			int		not null auto_increment,
	email			varchar(255)	not null,
	username		varchar(50)	not null,
	hashed_password	        char(40)	null,
	primary key (id)
);

• Add "active"

views

register

Form Fields:

• E-Mail Address
• Username
• Password

Validate:

• E-Mail Address
  • Unique
• Username
  • Unique
  • != E-Mail Address
  • != Any E-Mail Address in DB
  • Letters and Numbers Only
  • 4-30 Characters (?)
• Password
  • 4-30 Characters (?)

login

Form Fields:

• E-Mail Address or Username
• Password