User:MrCalifornia/tvolt roadmap
From Wikipedia, the free encyclopedia
Contents |
[edit] user
- need email verification stuff
- verify_email table
[edit] database tables
[edit] 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"
[edit] views
[edit] 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 (?)
[edit] login
Form Fields:
- E-Mail Address or Username
- Password