스프링 데이터베이스, H2실습1

스프링 데이터베이스, 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,'가입인사','관리자','잘 부탁드립니다....');