스프링 데이터베이스, H2실습1
코드내용
create table users(
ID VARCHAR2(8) PRIMARY KEY,
PASSWORD VARCHAR2(8),
NAME VARCHAR2(20),
ROLE VARCHAR2(5)
);
INSERT INTO USERS VALUES('test','test123','관리자','Admin');
INSERT INTO USERS VALUES('user1','user1','홍길동','User');
create table board(
seq number(5) primary key,
title varchar2(200),
writer varchar2(20),
content varchar2(2000),
regdate date default sysdate,
cnt number(5) default 0
);
insert into board(seq, title, writer, content) values(1,'가입인사','관리자','잘 부탁드립니다....');
댓글