member.sql

来自「php开发实例完全剖析」· SQL 代码 · 共 26 行

drop database if exists member;
create database member;
use member;

create table member (
	id varchar(20) not null,
	name varchar(10) not null,
	password varchar(50) not null,
	sex varchar(4) not null,
	email varchar(50) not null,
	oicq varchar(20),
	homepage varchar(50),
	city varchar(14),
	address varchar(80),
	zip varchar(10),
	tel varchar(14),
	edu varchar(10),
	introduction varchar(250),
	interest varchar(100),
	birthday date,
	photo longblob,
	regtime datetime NOT NULL default '0000-00-00 00:00:00',	
	regip varchar(100) NOT NULL default '',
	primary key (id)
);