DB 저장용
create table info(
idx int(4) not null auto_increment,
rno int(4) not null,
name varchar(50) not null,
role enum('암살자','전사','원거리','마법사','탱커','서포터') not null,
liner1 varchar(200) not null,
liner2 varchar(200) null,
liner3 varchar(200) null,
liner4 varchar(200) null,
rdate date not null default '0001/01/01',
primary key (idx,name,rno),
unique key(name,rno)
);
insert into info values ('0','50','가렌','전사','탑','','','','2010/04/27');
insert into info values ('0','57','갈리오','탱커','미드','','','','2010/08/10');
insert into info values ('0','30','갱플랭크','전사','탑','','','','2009/08/19');
insert into info values ('0','44','그라가스','전사','탑','정글','미드','서포터','2010/02/02');
insert into info values ('0','85','그레이브즈','원거리','정글','','','','2011/10/19');
insert into info values ('0','155','그웬','전사','탑','','','','2021/04/16');
insert into info values ('0','120','나르','전사','탑','','','','2014/08/14');
insert into info values ('0','108','나미','전사','서포터','','','','2012/12/07');
insert into info values ('0','38','나서스','전사','탑','','','','2009/10/01');
insert into info values ('0','93','노틸러스','탱커','서포터','','','','2012/02/14');
insert into info values ('0','72','녹턴','암살자','정글','','','','2011/03/15');
insert into info values ('0','17','누누와윌럼프','탱커','정글','미드','','','2009/02/21');
insert into info values ('0','42','니달리','암살자','정글','','','','2009/12/17');
insert into info values ('0','142','니코','마법사','미드','','','','2018/12/05');
insert into info values ('0','98','다리우스','전사','탑','','','','2012/05/23');
인덱스 이름 아이템명 매매시간 매매
create table play (
idx int(4) not null auto_increment,
name varchar(50) not null,
item varchar(100) not null,
itemdate datetime not null default '0001-01-01 01:00:00',
shop enum('buy','sell'),
primary key(idx)
);
insert into play values ('0','가렌','삼위일체','2022-01-28 12:11:43','buy');
insert into play values ('0','갈리오','밤의끝자락','2022-01-29 12:11:43','sell');
insert into play values ('0','갱플랭크','존야의모래시계','2022-01-30 12:11:43','buy');
insert into play values ('0','그라가스','라바돈의죽음모자','2022-01-31 12:11:43','buy');
insert into play values ('0','노틸러스','기동력장화','2022-02-01 12:11:43','buy');
insert into play values ('0','나서스','충전형물약','2022-02-02 12:11:43','buy');
insert into play values ('0','그웬','모렐로노미콘','2022-02-03 12:11:43','buy');
insert into play values ('0','그레이브즈','고속연사포','2022-02-04 12:11:43','buy');
insert into play values ('0','그레이브즈','신속의장화','2022-02-05 12:11:43','sell');
insert into play values ('0','나르','부패물약','2022-02-06 12:11:43','buy');
insert into play values ('0','갱플랭크','어둠의인장','2022-02-07 12:11:43','sell');
insert into play values ('0','그웬','충전형물약','2022-02-08 12:11:43','buy');
insert into play values ('0','나미','헤르메스의발걸음','2022-02-09 12:11:43','buy');
insert into play values ('0','나르','도란의반지','2022-02-10 12:11:43','sell');
insert into play values ('0','녹턴','도란의반지','2022-02-11 12:11:43','buy');
insert into play values ('0','나미','부패물약','2022-02-12 12:11:43','buy');
insert into play values ('0','녹턴','도란의검','2022-02-13 12:11:43','sell');
insert into play values ('0','나서스','자객의발톱','2022-02-14 12:11:43','buy');
insert into play values ('0','다리우스','도란의검','2022-02-15 12:11:43','sell');
insert into play values ('0','노틸러스','존야의모래시계','2022-02-16 12:11:43','buy');
insert into play values ('0','나서스','만년서리','2022-02-17 12:11:43','buy');
insert into play values ('0','녹턴','어둠의인장','2022-02-18 12:11:43','sell');
insert into play values ('0','니코','여신의눈물','2022-02-19 12:11:43','buy');
insert into play values ('0','누누와윌럼프','그림자검','2022-02-20 12:11:43','sell');
insert into play values ('0','다리우스','고속연사포','2022-02-21 12:11:43','buy');
insert into play values ('0','그웬','독사의송곳니','2022-02-22 12:11:43','sell');
insert into play values ('0','니달리','처형인의대검','2022-02-23 12:11:43','buy');
insert into play values ('0','가렌','만년서리','2022-02-24 12:11:43','sell');
insert into play values ('0','니코','독사의송곳니','2022-02-25 12:11:43','buy');
insert into play values ('0','갱플랭크','벤시의장막','2022-02-26 12:11:43','buy');
insert into play values ('0','니달리','만년서리','2022-02-27 12:11:43','sell');
insert into play values ('0','니코','삼위일체','2022-02-28 12:11:43','buy');
insert into play values ('0','가렌','벤시의장막','2022-03-01 12:11:43','sell');
insert into play values ('0','누누와윌럼프','헤르메스의발걸음','2022-03-02 12:11:43','buy');
insert into play values ('0','갱플랭크','처형인의대검','2022-03-01 12:11:43','sell');
insert into play values ('0','그라가스','모렐로노미콘','2022-03-01 12:11:43','sell');
insert into play values ('0','나미','신속의장화','2022-03-01 12:11:43','sell');
insert into play values ('0','나서스','기동력장화','2022-03-01 12:11:43','sell');
insert into play values ('0','노틸러스','라바돈의죽음모자','2022-03-01 12:11:43','sell');
insert into play values ('0','니코','밤의끝자락','2022-03-01 12:11:43','sell');
insert into play values ('0','갈리오','그림자검','2022-03-01 12:11:43','buy');
인덱스 아이템명 아이템가격 신화유무
create table item (
idx int(4) not null auto_increment,
item varchar(100) not null,
price int(4) not null,
god enum('Y','N'),
primary key(idx)
);
insert into item values ('0','삼위일체','3333','N');
insert into item values ('0','밤의끝자락','3100','N');
insert into item values ('0','존야의모래시계','3100','N');
insert into item values ('0','라바돈의죽음모자','3400','N');
insert into item values ('0','기동력장화','1100','N');
insert into item values ('0','만년서리','3200','Y');
insert into item values ('0','모렐로노미콘','2700','N');
insert into item values ('0','고속연사포','2800','N');
insert into item values ('0','신속의장화','900','N');
insert into item values ('0','부패물약','500','N');
insert into item values ('0','어둠의인장','500','N');
insert into item values ('0','충전형물약','500','N');
insert into item values ('0','헤르메스의발걸음','1100','N');
insert into item values ('0','도란의반지','400','N');
insert into item values ('0','도란의검','500','N');
insert into item values ('0','자객의발톱','3100','Y');
insert into item values ('0','여신의눈물','650','N');
insert into item values ('0','그림자검','2800','Y');
insert into item values ('0','독사의송곳니','2100','N');
insert into item values ('0','처형인의대검','1500','N');
insert into item values ('0','벤시의장막','2600','N');
============================================================
인덱스.이름,아이디,출생연도,전화번호1,전화번호2,이메일, 통신사
insert into korean values ('0','안중근','ahn','1879','01012634678','01023404489','ahn@gmail.com','SKT');
insert into korean values ('0','김구','kim9','1876','01012125678','','kim9@gmail.com','알뜰폰');
insert into korean values ('0','윤동주','ydj','1917','01016553458','','ydj@nate.com','SKT');
insert into korean values ('0','유관순','yoo','1902','01017345678','','yoo@naver.com','KT');
insert into korean values ('0','윤봉길','ybg','1908','01012347778','0114930685','yhg@nate.com','LGT');
insert into korean values ('0','안창호','chanho','1878','01012222678','','chanho@gmail.com','SKT');
insert into korean values ('0','박열','parkfire','1902','01012569878','','parkfire@naver.com','KT');
insert into korean values ('0','김좌진','kimjj','1889','01012323458','0173498880','kimjj@nate.com','SKT');
insert into korean values ('0','지청천','earthbluesky','1888','01010005678','','earthbluesky@naver.com','알뜰폰');
insert into korean values ('0','신채호','shinho','1880','01012346548','','shinho@naver.com','SKT');
insert into korean values ('0','방정환','bjh0505','1899','01012368278','','bjh0505@nate.com','KT');
insert into korean values ('0','권기옥','kiok','1901','01012005478','01049326995','kiok@naver.com','LGT');
insert into korean values ('0','서재필','jpseo','1864','01012123458','01088882203','jpseo@nate.com','KT');
insert into korean values ('0','손병희','son','1861','01012345668','','son@nate.com','LGT');
insert into korean values ('0','이봉창','bongchang','1900','01012009878','','bongchang@gmail.com','알뜰폰');
인덱스,아이디, 상품코드 상품명 상품가격 구매시간
insert into korean values ('0','ahn','10385014','무한의대검','3200','2022-03-12 12:46:55');
insert into korean values ('0','kim9','01784234','바미의불꽃','1100','2022-03-13 12:44:55');
insert into korean values ('0','bjh0505','10486038','스태틱단검','2800','2022-03-13 12:34:57');
insert into korean values ('0','ydj','10586394','그림자불꽃','3100','2022-03-14 12:44:57');
insert into korean values ('0','yoo','10385014','무한의대검','3200','2022-03-15 12:34:55');
insert into korean values ('0','ybg','01784234','바미의불꽃','1100','2022-03-16 12:44:55');
insert into korean values ('0','chanho','01784234','바미의불꽃','1100','2022-03-16 12:44:55');
insert into korean values ('0','chanho','01937593','삼위일체','3333','2022-03-16 13:40:55');
insert into korean values ('0','parkfire','10048293','돌풍','3200','2022-03-17 12:44:57');
insert into korean values ('0','ahn','10385014','무한의대검','3200','2022-03-18 14:44:65');
insert into korean values ('0','kimjj','23866958','드락사르의황혼검','3100','2022-03-19 12:34:55');
insert into korean values ('0','earthbluesky','42246999','시야석','800','2022-03-22 12:44:52');
insert into korean values ('0','shinho','33763456','우르프황금뒤집개','8000','2022-03-26 12:46:55');
insert into korean values ('0','bongchang','23866958','드락사르의황혼검','3100','2022-03-28 12:40:55');
insert into korean values ('0','bjh0505','10385014','무한의대검','3200','2022-03-30 12:44:55');
insert into korean values ('0','parkfire','33763456','우르프황금뒤집개','8000','2022-04-02 12:41:55');
insert into korean values ('0','jpseo','33754283','라바돈의죽음모자','3600','2022-04-12 12:41:15');
insert into korean values ('0','earthbluesky','10048293','돌풍','3200','2022-04-28 12:11:54');
insert into korean values ('0','kiok','01784234','바미의불꽃','1100','2022-05-18 20:47:55');
insert into korean values ('0','jpseo','42246999','시야석','800','2022-05-22 23:44:58');
insert into korean values ('0','son','10486038','스태틱단검','2800','2022-05-29 17:44:55');
insert into korean values ('0','bongchang','42246999','시야석','800','2022-06-12 22:47:55');