Location: PHPKode > scripts > phpEmailUser > readme_login_reg_installation.txt
phpemailuser v.0.1
by georgfly
https://sourceforge.net/projects/phpemailuser

installation:
- create a database and execute the sql text at the bottom of this file
- specify database credentials and other settings in config.inc.php
- call login_reg.php in browser
- log in as admin (User Email = admin, Password = admin) and change admin username and password
- try to register a new user and check if registration confirmation email is sent correctly

remarks:
- i haven't implemented a setting for session timeout


DROP TABLE IF EXISTS user;
CREATE TABLE user (uid MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
user_email VARCHAR(50) NOT NULL UNIQUE,
create_date DATETIME NOT NULL,
password VARCHAR(255) NOT NULL,
first_name VARCHAR(50),
last_name VARCHAR(50),
activated TINYINT(1) NOT NULL,
actkey VARCHAR(50) NOT NULL,
actkey_date DATETIME NOT NULL,
prevemail VARCHAR(50),
actkeyprev VARCHAR(50),
blocked TINYINT(1) NOT NULL,
userlevel INT UNSIGNED NOT NULL,
loginattempts INT UNSIGNED NOT NULL,
lastlogin_date DATETIME NOT NULL,
PRIMARY KEY(uid) );

DROP TABLE IF EXISTS userdata;
CREATE TABLE userdata (udid MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
ship_first_name VARCHAR (50),
ship_last_name VARCHAR (50),
institution VARCHAR(50),
street VARCHAR(50),
street2 VARCHAR(50),
city VARCHAR(50),
state VARCHAR(50),
zip CHAR(10),
country VARCHAR(50),
phone CHAR(15),
fax CHAR(15),
uid MEDIUMINT UNSIGNED NOT NULL,
PRIMARY KEY(udid) );

DROP TABLE IF EXISTS useradmin;
CREATE TABLE useradmin (uaid MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
adname VARCHAR(50) not null unique,
password varchar(255) not null,
PRIMARY KEY(uaid) );
insert into useradmin (adname,password) values ('admin',md5('admin'));
Return current item: phpEmailUser