-- 회원기본 CREATE TABLE MEMBERS ( MNO INTEGER NOT NULL COMMENT '회원일련번호', -- 회원일련번호 EMAIL VARCHAR(40) NOT NULL COMMENT '이메일', -- 이메일 PWD VARCHAR(100) NOT NULL COMMENT '암호', -- 암호 MNAME VARCHAR(50) NOT NULL COMMENT '이름', -- 이름 CRE_DATE DATETIME NOT NULL COMMENT '가입일', -- 가입일 MOD_DATE DATETIME NOT NULL COMMENT '마지막암호변경일' -- 마지막암호변경일 ) COMMENT '회원기본'; -- 회원기본 ALTER TABLE MEMBERS ADD CONSTRAINT PK_MEMBERS -- 회원기본 기본키 PRIMARY KEY ( MNO -- 회원일련번호 ); -- 회원기본 유니크 인덱스 CREATE UNIQUE INDEX UIX_MEMBERS ON MEMBERS ( -- 회원기본 EMAIL ASC -- 이메일 ); ALTER TABLE MEMBERS MODIFY COLUMN MNO INTEGER NOT NULL AUTO_INCREMENT COMMENT '회원일련번호'; INSERT INTO MEMBERS(EMAIL,PWD,MNAME,CRE_DATE,MOD_DATE) VALUES ('[email protected]','1111','홍길동',NOW(),NOW()); INSERT INTO MEMBERS(EMAIL,PWD,MNAME,CRE_DATE,MOD_DATE) VALUES ('[email protected]','1111','임꺽정',NOW(),NOW()); INSERT INTO MEMBERS(EMAIL,PWD,MNAME,CRE_DATE,MOD_DATE) VALUES ('[email protected]','1111','일지매',NOW(),NOW()); INSERT INTO MEMBERS(EMAIL,PWD,MNAME,CRE_DATE,MOD_DATE) VALUES ('[email protected]','1111','이몽룡',NOW(),NOW()); INSERT INTO MEMBERS(EMAIL,PWD,MNAME,CRE_DATE,MOD_DATE) VALUES ('[email protected]','1111','성춘향',NOW(),NOW()); SELECT * FROM MEMBERS;