CREATE TABLE

CREATE TABLE `Member` (
`seq` int(10) NOT NULL auto_increment COMMENT '회원번호',
`id` varchar(20) NOT NULL COMMENT '아이디',
`pwd` varchar(100) NOT NULL COMMENT '비밀번호',
`name` varchar(20) NOT NULL COMMENT '회원이름',
`pic_url` varchar(16) default NULL COMMENT '사진',
`gender` int(1) NOT NULL COMMENT '성별(1:남, 0:여)',
`address` varchar(100) NOT NULL COMMENT '집주소',
`hobby` varchar(40) default NULL COMMENT '취미',
`grade` int(10) default NULL COMMENT '권한',
`video_url` varchar(16) default NULL COMMENT '동영상',
PRIMARY KEY (`seq`),
UNIQUE KEY `id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='회원 테이블';