drop table restrant;

CREATE TABLE restrant(rid int4,rname text,rurl text);

insert into restrant(rid,rname,rurl)
values(1,'デニーズ','http://www.dennys.jp/dny/index.html');

insert into restrant(rid,rname,rurl)
values(2,'サイゼリア','http://www.saizeriya.co.jp/');

insert into restrant(rid,rname,rurl)
values(3,'ガスト','http://www.skylark.co.jp/gusto/');


drop table menu;

CREATE TABLE menu(mid int4,mname text,money int4,kcal int4);

insert into menu(mid,mname,money,kcal)
values(1,'まぜまぜビビンバーグ','880','994l');
insert into menu(mid,mname,money,kcal)
values(2,'ミラノ風ドリア','299','519');
insert into menu(mid,mname,money,kcal)
values(3,'タラコソース　シシリー風','399','523');
insert into menu(mid,mname,money,kcal)
values(4,'とろーり卵とチーズのオムライス','880','1022');
insert into menu(mid,mname,money,kcal)
values(5,'目玉焼きハンバーグ','418','606');
insert into menu(mid,mname,money,kcal)
values(6,'アメリカンクラブハウスサンド','980','1086');
insert into menu(mid,mname,money,kcal)
values(7,'小エビのカクテルサラダ','459','247');
insert into menu(mid,mname,money,kcal)
values(8,'まぐろのたたきご飯','838','513');
insert into menu(mid,mname,money,kcal)
values(9,'山盛りポテトフライ','313','813');

drop table mhold;

CREATE TABLE mhold(rid int4,mid int4);

insert into mhold(rid,mid)
values(1,1);
insert into mhold(rid,mid)
values(2,2);
insert into mhold(rid,mid)
values(2,3);
insert into mhold(rid,mid)
values(1,4);
insert into mhold(rid,mid)
values(3,5);
insert into mhold(rid,mid)
values(1,6);
insert into mhold(rid,mid)
values(2,7);
insert into mhold(rid,mid)
values(3,8);
insert into mhold(rid,mid)
values(8,9);
