테이블 생성

create table shop(
shopnum smallint auto_increment primary key,
category varchar(30),
sangpum varchar(30),
photo varchar(50),
price int,
ipgoday varchar(20)
);

create table cart(
idx smallint auto_increment primary key,
shopnum smallint,
num smallint,
cnt int,
cartday date,
foreign key(shopnum) references shop(shopnum) on delete cascade,
foreign key(num) references member(num) on delete cascade
);

• addform
• addaction
• shopdao(insert select)
• shoplist