userreg.sql

来自「用PHP/MySQL/Apache实现的简单用户注册/登录系统。」· SQL 代码 · 共 15 行

create database UserReg
use UserReg;
create table users(
	user_id int unsigned not null auto_increment,
	first_name varchar(20) not null,
	last_name varchar(40) not null,
	email varchar(80) not null,
	pass char(40) not null,
	user_level tinyint(1) unsigned not null default 0,
	active char(32),
	registration_date DateTime not null,
	primary key(user_id),
	unique key(email),
	index login(eamil,pass)
);