[ PHP] 게시판

mysql

DB생성
create database comdoctor;

회원 테이블 생성
create table user(email varchar(50), pass varchar(100), nick varchar(20), primary key(email) )Engine='InnoDB' default charset='utf8';

create table membership(email varchar(50) not null, grade int unsigned, rank int unsigned, point int unsigned, primary key(email) )Engine='InnoDB' default charset='utf8';

insert into user values('sangoochoi@gmail.com','111111','Comdoctor');

insert into membership values('sangoochoi@gmail.com',1,0,9999);

================================================
php source