게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍5분안에 읽기 (약 807 단어)

Chap.06. Join

CoLab

https://colab.research.google.com/drive/1aqv9cOIrGKFEkXrRhS2XiFuXLBBwp-wi

https://bit.ly/3i25Mia

Schema 1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
drop database if exists joindb;
create database joindb
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

use joindb;
create table movie (
    mname varchar(20),
    aname varchar(20),
    PRIMARY KEY(mname)
) ENGINE=INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

create table actor (
    aname varchar(20),
    birthdate date,
    PRIMARY KEY(aname)
) ENGINE = INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;
 
insert into movie values ('남산의 부장들', '이병헌');
insert into movie values ('다만 악에서 구하소서', '황정민');
insert into movie values ('반도', '강동원');
insert into movie values ('히트맨','권상우');
insert into movie values ('테넷', null);

insert into actor values ('이병헌', '1970-07-12');
insert into actor values ('황정민', '1970-09-01');
insert into actor values ('강동원', '1981-01-18');
insert into actor values ('권상우', '1976-08-05');
insert into actor values ('유아인', '1986-10-06');

Schema 2

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
drop database if exists joindb;
create database joindb
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

use joindb;
create table movie (
    mname varchar(20),
    aname varchar(20),
    PRIMARY KEY(mname)
) ENGINE=INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

create table actor (
    aname varchar(20),
    birthdate date
) ENGINE = INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

insert into movie values ('남산의 부장들', '이병헌');
insert into movie values ('다만 악에서 구하소서', '황정민');
insert into movie values ('반도', '강동원');
insert into movie values ('히트맨','권상우');
insert into movie values ('테넷', null);

insert into actor values ('이병헌', '1970-07-12');
insert into actor values ('이병헌', null);
insert into actor values ('황정민', '1970-09-01');
insert into actor values ('강동원', '1981-01-18');
insert into actor values ('권상우', '1976-08-05');
insert into actor values ('유아인', '1986-10-06');

Schema 3

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
drop database if exists joindb;
create database joindb
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

use joindb;

create table actor (
    id int not null AUTO_INCREMENT,
    name varchar(20),
    birthdate date,
    PRIMARY KEY(id)
) ENGINE = INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;
 
create table movie (
    id int not null AUTO_INCREMENT,
    name varchar(20),
    aid int,
    PRIMARY KEY(id),
    FOREIGN KEY(aid) REFERENCES actor(id)
) ENGINE=INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;
 
insert into actor values (1, '이병헌', '1970-07-12');
insert into actor values (2, '황정민', '1970-09-01');
insert into actor values (3, '강동원', '1981-01-18');
insert into actor values (4, '권상우', '1976-08-05');
insert into actor values (5, '유아인', '1986-10-06');

insert into movie values (null, '남산의 부장들', 1);
insert into movie values (null, '다만 악에서 구하소서', 2);
insert into movie values (null, '반도', 3);
insert into movie values (null, '히트맨', 4);
insert into movie values (null, '테넷', null);

Schema 4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
drop database if exists joindb;
create database joindb
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

use joindb;

create table movie (
    id int not null AUTO_INCREMENT,
    name varchar(20),
    PRIMARY KEY(id)
) ENGINE=INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

create table actor (
    id int not null AUTO_INCREMENT,
    name varchar(20),
    birthdate date,
    PRIMARY KEY(id)
) ENGINE = INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;
 
create table starring (
    mid int not null,
    aid int not null,
    FOREIGN KEY(mid) REFERENCES movie(id),
    FOREIGN KEY(aid) REFERENCES actor(id)
) ENGINE = INNODB
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;

#####################################################

insert into movie values (1, '남산의 부장들');
insert into movie values (2, '다만 악에서 구하소서');
insert into movie values (3, '반도');
insert into movie values (4, '히트맨');
insert into movie values (5, '테넷');

insert into actor values (1, '이병헌', '1970-07-12');
insert into actor values (2, '황정민', '1970-09-01');
insert into actor values (3, '강동원', '1981-01-18');
insert into actor values (4, '권상우', '1976-08-05');
insert into actor values (5, '유아인', '1986-10-06');

insert into starring (mid, aid) values (1, 1);
insert into starring (mid, aid) values (2, 2);
insert into starring (mid, aid) values (3, 3);
insert into starring (mid, aid) values (4, 4);

데이터 추가

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
# 데이터 추가
insert into actor values (6, '곽도원', '1973-05-17');
insert into actor values (7, '이성민', '1968-12-04');

insert into starring (mid, aid) values (1, 6);
insert into starring (mid, aid) values (1, 7);

#####################################################

select name, id from movie;
select * from starring order by mid;
select * from actor;

# Left Outer Join
select * from movie 
    left outer join starring on movie.id = starring.mid
    left outer join actor on starring.aid = actor.id;
    
select movie.name, actor.name from movie 
    left outer join starring on movie.id = starring.mid
    left outer join actor on starring.aid = actor.id;

Chap 4의 Schema

https://colab.research.google.com/drive/1hOrefbnFaQTHijuI7lN49tuISirxD4Ot

 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍5분안에 읽기 (약 771 단어)

Chap.07. Trigger

CoLab

https://colab.research.google.com/drive/1oUVvhVjnMuTTfi9RJnU3wIHLEsAjDl_7

https://bit.ly/3idcYrR

Stored Procedure

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
DROP DATABASE IF EXISTS songdb;
CREATE DATABASE songdb
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;
	
use songdb;

CREATE TABLE song (
	singer varchar(20),
	title varchar(20),
	PRIMARY KEY(singer, title)
) ENGINE=INNODB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;
	
################################

INSERT INTO song VALUES ('나훈아', '테스형');
SELECT * FROM song;


################################
# 오류 발생
################################
/*
CREATE PROCEDURE DeleteSong()
BEGIN
	TRUNCATE TABLE song;
END;
*/

################################
DELIMITER $
CREATE PROCEDURE DeleteSong()
BEGIN
	TRUNCATE TABLE song;
END$
DELIMITER ;

call DeleteSong();
SELECT * FROM song;
################################


DELIMITER $
CREATE PROCEDURE InsertSong()
BEGIN
	INSERT INTO song VALUES ('장범준', '잠이 오질 않네요');
	INSERT INTO song VALUES ('방탄소년단', 'Life Goes On');
	INSERT INTO song VALUES ('지코', '아무노래');
END$
DELIMITER ;

CALL InsertSong();
SELECT * FROM song;

################################
show procedure status like '%song%';
################################
DROP PROCEDURE DeleteSong;
################################

Trigger 1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
DROP DATABASE IF EXISTS songdb;
CREATE DATABASE songdb
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;
	
use songdb;

CREATE TABLE song (
	singer varchar(20),
	title varchar(20),
	PRIMARY KEY(singer, title)
) ENGINE=INNODB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;
	
################################

INSERT INTO song VALUES ('나훈아', '테스형');
SELECT * FROM song;

################################
DELIMITER $
CREATE TRIGGER InsertSong
BEFORE INSERT
ON song for each row
BEGIN
	set new.singer = concat(new.singer, " 가수");
END$
DELIMITER ;
################################
INSERT INTO song VALUES ('장범준', '잠이 오질 않네요');
INSERT INTO song VALUES ('방탄소년단', 'Life Goes On');
INSERT INTO song VALUES ('지코', '아무노래');
SELECT * FROM song;
################################
SHOW TRIGGERS;

Trigger 2

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
drop database if exists reviewdb;

create database reviewdb
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

use reviewdb;

create table review (
    id int not null AUTO_INCREMENT,
    memo varchar(20),
    primary key (id)
) engine=InnoDB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

create table user (
    id int not null AUTO_INCREMENT,
    name varchar(20),
    primary key (id)
) engine=InnoDB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

create table likes (
    rid int,
    uid int,
    primary key(rid, uid),
    foreign key(rid) references review(id),
    foreign key(uid) references user(id)
) engine=InnoDB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

#######
insert into review values (1, '양고기 맛있네요');
insert into review values (2, '아귀포 최고');
insert into review values (3, '동네 맛집');
insert into review values (4, '역시 삼겹살!');

insert into user values (1, '홍길동');
insert into user values (2, '임꺽정');
insert into user values (3, '장길산');

insert into likes values (3, 1);
insert into likes values (3, 2);
insert into likes values (1, 3);
select * from review r 
    left join likes l on r.id = l.rid
    left join user u on l.uid = u.id;
    
#######
select r.memo, count(distinct l.uid) as likes from review r 
    left join likes l on r.id = l.rid
    left join user u on l.uid = u.id
    group by r.id
    order by count(distinct l.uid) desc;
#######
alter table review add total_likes int unsigned default 0;
desc review;

truncate table likes;
select r.memo, count(distinct l.uid) as likes from review r 
    left join likes l on r.id = l.rid
    left join user u on l.uid = u.id
    group by r.id
    order by count(distinct l.uid) desc;

select review.memo, review.total_likes
    from review
    order by review.total_likes desc;
#######  
delimiter $
create trigger insert_likes
after insert
on likes for each row
begin
    update review set total_likes = total_likes + 1
    where review.id = new.rid;
end$
delimiter ;
#######  
# delimiter $
# create trigger insert_delete_likes
# after insert, delete
# on likes for each row
# begin
#     update review set total_likes = 
#         (select count(*) from likes 
#          where likes.rid = new.rid)
#     where review.id = new.rid;
# end$
# delimiter ;
####### 
insert into likes values (3, 1);
insert into likes values (3, 2);
insert into likes values (1, 3);

select id, memo, total_likes
    from review
    order by total_likes desc;

####### 
delimiter $
create trigger delete_likes
after delete
on likes for each row
begin
    update review set total_likes = total_likes - 1
        where review.id = old.rid;
end$
delimiter ;
####### 
delete from likes where rid = 3 and uid = 1;

select id, memo, total_likes
    from review
    order by total_likes desc;

####### 
delimiter $
create trigger update_likes
after update
on likes for each row
begin
    update review set total_likes = total_likes - 1
        where review.id = old.rid;
    update review set total_likes = total_likes + 1
        where review.id = new.rid;
end$
delimiter ;
####### 
update likes set rid = 4 where rid = 3 and uid = 2;

select id, memo, total_likes
    from review
    order by total_likes desc;
####### 
show triggers;
 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍4분안에 읽기 (약 526 단어)

Chap.08. DCL and TCL

CoLab

https://colab.research.google.com/drive/1wts3NIBojdz2mBUfBott6vAA0kqfsMq2

https://bit.ly/3qoXrs3

DCL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
show grants;

# MySQL Workbench에서 실행하면 보기 편함
select * from mysql.user;

select host, user from mysql.user;

select host, user, select_priv from mysql.user;

select host, user, create_user_priv from mysql.user;
select host, user, super_priv, create_user_priv, grant_priv, show_view_priv from mysql.user;

#########################
create user backend identified by 'mysql3456';
show grants for backend;
select host, user, super_priv, create_user_priv, grant_priv, show_view_priv from mysql.user;



drop user backend;

select host, user, super_priv, create_user_priv, grant_priv, show_view_priv from mysql.user;

show grants for backend;
#########################

# create user backend@localhost identified by 'mysql3456';

# select host, user, super_priv, create_user_priv, grant_priv, show_view_priv from mysql.user;

# show grants for backend;
# show grants for backend@*;

# drop user backend@localhost;

#########################

quit

# Shell에서 실행
# mysql -u backend -p

show grants;

#########################

grant all privileges on  *.* to root@'%' identified by 'mysql1234';
#delete from mysql.user where host="localhost" and user="root";
flush privileges;
select host, user, super_priv, create_user_priv, grant_priv, show_view_priv from mysql.user;
quit
# open /etc/mysql/my.cnf
# 이 파일이 다른 파일 include

# vim /etc/mysql/mysql.conf.d/mysqld.cnf

#########################

rename user backend to webroot;
select host, user, super_priv, create_user_priv, grant_priv, show_view_priv from mysql.user;


drop user webroot;
select host, user, super_priv, create_user_priv, grant_priv, show_view_priv from mysql.user;


grant all privileges on  *.* to root@localhost identified by 'mysql1234';

show databases;
grant select on songdb.song to backend;

#################

show databases;
use songdb;
select * from song;

INSERT INTO song VALUES ('임창정', '소주한잔');
select * from song;

grant insert on songdb.song to backend;
show grants for backend;


use songdb;
select * from song;
INSERT INTO song VALUES ('임창정', '소주한잔');
select * from song;

### 
revoke all privileges, grant option from backend;
show grants for backend;

TCL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
DROP DATABASE IF EXISTS songdb;
CREATE DATABASE songdb
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;
	
use songdb;

CREATE TABLE song (
	singer varchar(20),
	title varchar(20),
	PRIMARY KEY(singer, title)
) ENGINE=INNODB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;
	
################################

INSERT INTO song VALUES ('나훈아', '테스형');
INSERT INTO song VALUES ('장범준', '잠이 오질 않네요');
INSERT INTO song VALUES ('방탄소년단', 'Life Goes On');
INSERT INTO song VALUES ('지코', '아무노래');
SELECT * FROM song;
################################

select * from song;

start transaction;
INSERT INTO song VALUES ('임재현', '사랑에 연습이 있었다면');
select * from song;

savepoint Ins1;

update song set title = '조금 취했어' where singer = '임재현';
select * from song;

savepoint Upd1;

delete from song where singer = '나훈아';
select * from song;

savepoint Del1;

INSERT INTO song VALUES ('임창정', '힘든 건 사랑이 아니다');
select * from song;

savepoint Ins2;

rollback;
select * from song;
 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍3분안에 읽기 (약 451 단어)

Chap.09. Integrity

CoLab

https://colab.research.google.com/drive/1e6u7XBSc7MDiPl7znczNN3DE8UibXFAa

https://bit.ly/3qiR2hL

Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
drop database if exists gamedb;

create database gamedb
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

use gamedb;

create table game (
    title varchar(20),
    developer varchar(20),
    primary key (title)
) engine=InnoDB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

create table user (
    id int not null AUTO_INCREMENT,
    name varchar(20),
    primary key (id)
) engine=InnoDB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

create table review (
    uid int,
    title varchar(20),
    memo varchar(50),
    primary key(uid, title),
    foreign key(uid) references user(id),
    foreign key(title) references game(title)
) engine=InnoDB
	DEFAULT CHARACTER SET utf8
	DEFAULT COLLATE utf8_general_ci;

#######
insert into game values ('리그 오브 레전드', '라이엇 게임즈');
insert into game values ('배틀 그라운드', '펍지');
insert into game values ('젤다의 전설: 야생의 숨결', '닌텐도');
insert into game values ('호라이즌 제로 던', '게릴라 게임스');
insert into game values ('몬스터 헌터 월드', '캡콤');
insert into game values ('데스 스트랜딩', '코지마 프로덕션');
insert into game values ('어쌔신 크리드: 발할라', '유비소프트 몬트리올');
insert into game values ('사이버펑크 2077', 'CD PROJEKT RED');

insert into user values (1, '홍길동');
insert into user values (2, '임꺽정');
insert into user values (3, '장길산');

insert into review values (1, '배틀 그라운드', '오늘 저녁은 치킨이닭!');
insert into review values (2, '리그 오브 레전드', '적을 죽이는 것보다 안죽는 것이 더 중요하다.');
insert into review values (3, '젤다의 전설: 야생의 숨결', '아름다운 카툰 렌더링. 분위기에 맞는 음악');
insert into review values (1, '호라이즌 제로 던', '멋진 세계관과 매력적인 기계 동물들');
insert into review values (1, '몬스터 헌터 월드', '안쟈나프 선생님');
insert into review values (2, '데스 스트랜딩', '택배의 즐거움');
insert into review values (3, '데스 스트랜딩', '스토리는 모르겠지만 그래픽 좋음');
insert into review values (3, '사이버펑크 2077', '기대가 크면 실망도 큰 법');

 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍17분안에 읽기 (약 2590 단어)

Chap.10. CSV

CoLab

https://colab.research.google.com/drive/1x4yPO21kx1PwNECjQhNj91lhgU6_vAY7

https://bit.ly/2KDiBTQ

Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
DROP DATABASE IF EXISTS `gunpladb` ;

CREATE DATABASE IF NOT EXISTS `gunpladb` 
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

USE `gunpladb` ;

CREATE TABLE `mechanic` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `model` VARCHAR(100) NOT NULL,
  `manufacturer` VARCHAR(255) NULL,
  `armor` VARCHAR(255) NULL,
  `height` DECIMAL(7,2) NULL,
  `weight` DECIMAL(7,2) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `gunpla` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `mechanic_id` INT NOT NULL,
  `grade` VARCHAR(45) NOT NULL,
  `date` DATE NULL,
  `price` INT(11) NULL,
  `title` VARCHAR(255) NULL,
  `boxart` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`),
  INDEX (`mechanic_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `image` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `gunpla_id` INT NOT NULL,
  `filename` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX (`gunpla_id`),
  FOREIGN KEY (`gunpla_id`) REFERENCES `gunpla` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `armament` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `description` TEXT NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `equipment` (
  `mechanic_id` INT NOT NULL,
  `armaments_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `armaments_id`),
  INDEX (`armaments_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`armaments_id`) REFERENCES `armament` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `pilot` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NULL,
  `type` VARCHAR(100) NULL,
  `nationality` VARCHAR(100) NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `boarding` (
  `mechanic_id` INT NOT NULL,
  `pilot_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `pilot_id`),
  INDEX (`pilot_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`pilot_id`) REFERENCES `pilot` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;


###############################################

INSERT INTO mechanic (id, name, model, manufacturer, armor, height, weight) VALUES
  (1, '건담', 'RX-78-2', 'Earth Federation', 'Luna Titanium', 18.0, 43.4),
  (2, '건캐논', 'RX-77-2', 'Earth Federation', 'Luna Titanium', 17.5, 51.0),
  (3, '건탱크', 'RX-75', 'Earth Federation', 'Luna Titanium', 15.0, 56.0),
  (4, '짐', 'RGM-79', 'Earth Federation Forces', 'Titanium Alloy', 18.0, 41.2),
  (5, '자쿠 II', 'MS-06F', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 58.1),
  (6, '샤아 전용 자쿠 II', 'MS-06S', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 56.5),
  (7, '돔', 'MS-09B', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 62.6),
  (8, '릭 돔', 'MS-09R', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 43.8),
  (9, '즈고크 E', 'MSM-07E', 'MIP Company', 'Titanium Alloy Ceramic Composite', 18.4, 69.5),
  (10, '씨그', 'ZGMF-515', 'Zodiac Alliance of Freedom Treaty', null, 21.43, 80.22),
  (11, '거너 자쿠 워리어', 'ZGMF-1000/A1', 'Integrated Design Bureau', null, 20.50, 91.11),
  (12, '건담 5호기', 'RX-78-5', 'Earth Federation', 'Luna Titanium', 18.0, 42.9),
  (13, '건담 Mk-II', 'RX-178', 'Titans', 'Titanium Alloy Ceramic Composite', 18.5, 33.4),
  (14, '겔구그', 'MS-14A/C', 'Zeonic Company', 'Super Hard Steel Alloy', 19.2, 42.1),
  (15, '겔구그 예거', 'MS-14Jg', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 19.2, 40.5),
  (16, '고그', 'MSM-03', 'Zimmad Company', 'Super High Tensile Steel', 18.3, 82.4),
  (17, '네모', 'MSA-003', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (18, '뉴건담', 'RX-93', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (19, '레전드 건담', 'ZGMF-X666S', 'Zodiac Alliance of Freedom Treaty', 'Variable Phase Shift armor', 18.66, 86.02),
  (20, '릭디아스', 'RMS-099', 'Anaheim Electronics', 'Gundarium γ Alloy', 18.0, 32.2),
  (21, '마라사이', 'RMS-108', 'Anaheim Electronics', 'Gundarium Alloy', 17.5, 33.1),
  (22, '베르데 버스터 건담', 'GAT-X103AP', 'Actaeon Industries', 'Variable Phase Shift Armor', 18.46, 99.36),
  (23, '블레이즈 자쿠 팬텀', 'ZGMF-1001/M', 'Integrated Design Bureau', null, 20.4, 91.2),
  (24, '스트라이크 건담', 'GAT-X105', 'Earth Alliance', 'Phase Shift Armor', 17.72, 64.8),
  (25, '건담 아스트레이 레드 프레임', 'MBF-P02', 'Morgenroete, Inc.', 'Foaming metal', 17.53, 49.8),
  (26, '알렉스', 'RX-78NT-1', 'Earth Federation', 'Luna Titanium', 18.0, 40.0),
  (27, '주다', 'EMS-10', 'Zimmad Company', 'Hardened Steel', 17.3, 61.0),
  (28, '캠퍼', 'MS-18E', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 17.7, 43.5),
  (29, '파워드 짐', 'RGM-79', 'Earth Federation', 'Titanium Ceramic Composite', 18.0, 46.6),
  (30, '프리덤 건담', 'ZGMF-X10A', 'Integrated Design Bureau', 'Phase Shift Armor', 18.03, 71.5);
  
INSERT INTO gunpla (id, mechanic_id, grade, date, price, title, boxart) VALUES
  (1, 1, 'MG', '2005-03-01', 3200, 'RX-78-2 Gundam ver. O.Y.W 0079 (PS2 soft)', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78-2%20Gundam%7Cver.%20O.Y.W%200079%7C(PS2%20soft)'),
  (2, 2, 'SD', '2001-11-01', 500, 'Gun Cannon', 'http://ipsumimage.appspot.com/200x150,ffff3f?s=24&l=Gun%20Cannon'),
  (3, 3, 'SD', '2001-08-01', 500, 'Gun Tank', 'http://ipsumimage.appspot.com/200x150,ffff72?s=24&l=Gun%20Tank'),
  (4, 4, 'SD', '2001-04-01', 700, 'GM', 'http://ipsumimage.appspot.com/200x150,ffffd7?s=24&l=GM'),
  (5, 5, 'MG', '2002-09-01', 3000, 'MS-06F2	Zaku II F2 : EFSF 연방군형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06F2%7CZaku%20II%20F2%7CEFSF%20%EC%97%B0%EB%B0%A9%EA%B5%B0%ED%98%95'),
  (6, 6, 'RG', '2010-11-01', 2500, "MS-06S Char's Zaku II", 'http://ipsumimage.appspot.com/200x150,7f7fff?s=24&l=MS-06S%7CChar%27s%20Zaku%20II'),
  (7, 7, 'HGUC', '2006-01-01', 1700, 'MS-09/MS-09R Dom/Rick-Dom', 'http://ipsumimage.appspot.com/200x150,9f7fd2?s=24&l=MS-09%7CMS-09R%20Dom%7CRick-Dom'),
  (8, 8, 'MG', '1999-10-01', 4000, 'MS-09R Rick-Dom', 'http://ipsumimage.appspot.com/200x150,ff7fd2?s=24&l=MS-09R%7CRick-Dom'),
  (9, 9, 'HGUC', '2003-08-01', 1200, "MSM-07E Z'gok Experiment", 'http://ipsumimage.appspot.com/200x150,6f7fff?s=24&l=MSM-07E%7CZ%27gok%20Experiment'),
  (10, 10, 'SEED HG', '2004-04-01', 1200, 'ZGMF-515 Mobile Cgue', 'http://ipsumimage.appspot.com/200x150,afafaf?s=24&l=ZGMF-515%7CMobile%20Cgue'),   
  (11, 11, 'SEED 1/100', '2005-03-01', 2300, 'ZGMF-1000/A1 Gunner Zaku Warrior - 루나마리아 전용', 'http://ipsumimage.appspot.com/200x150,ff4f4f?s=24&l=ZGMF-1000/A1%7CGunner%20Zaku%7CWarrior%7C%EB%A3%A8%EB%82%98%EB%A7%88%EB%A6%AC%EC%95%84%7C%EC%A0%84%EC%9A%A9'),   
  (12, 12, 'MG', '2003-08-01', 2800, 'RX-78-5 Gundam 5호기', 'http://ipsumimage.appspot.com/200x150,ffff4f?s=24&l=RX-78-5%7CGundam%205%ED%98%B8%EA%B8%B0'),  
  (13, 13, 'MG', '2005-10-01', 4000, 'RX-178 Gundam Mk-II v2.0', 'http://ipsumimage.appspot.com/200x150,8f8fff?s=24&l=RX-178%7CGundam%20Mk-II%7Cv2.0'),  
  (14, 14, 'HGUC', '2007-03-01', 1600, 'MS-14A/C Gelgoog/Gelgoog Cannon', 'http://ipsumimage.appspot.com/200x150,8f8f2f?s=24&l=MS-14A/C%7CGelgoog/%7CGelgoog%20Cannon'),  
  (15, 15, 'HGUC', '2004-04-01', 1200, 'MS-14JG	Gelgoog J', 'http://ipsumimage.appspot.com/200x150,ff8f2f?s=24&l=MS-14JG%7CGelgoog%20J'),
  (16, 16, 'SD', '2000-02-01', 500, 'Gogg/Acguy/Zock', 'http://ipsumimage.appspot.com/200x150,8f7fff?s=24&l=Gogg%7CAcguy%7CZock'),
  (17, 17, 'MG', '2006-02-01', 2800, 'MSA-003 Nemo', 'http://ipsumimage.appspot.com/200x150,7fff8f?s=24&l=MSA-003%20Nemo'),
  (18, 18, 'SD', '2000-08-01', 500, 'Nu Gundam', 'http://ipsumimage.appspot.com/200x150,ffffaf?s=24&l=Nu%20Gundam'),
  (19, 19, 'SEED 1/100', '2006-06-01', 2600, 'ZGMF-X666S Legend Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfef?s=24&l=ZGMF-X666S%7CLegend%20Gundam'),
  (20, 20, 'HGUC', '2002-08-01', 1200, 'RMS-099 Rick Dias - 샤아전용', 'http://ipsumimage.appspot.com/200x150,df2f3f?s=24&l=RMS-099%7CRick%20Dias%20%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (21, 21, 'HGUC', '2005-01-01', 1400, 'RMS-108 Marasai', 'http://ipsumimage.appspot.com/200x150,ff5f5f?s=24&l=RMS-108%7CMarasai'),
  (22, 22, 'SEED HG', '2006-08-01', 1600, 'GAT-X103AP Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fffaf?s=24&l=GAT-X103AP%7CVerde%20Buster%7CGundam'),
  (23, 23, 'SEED 1/100', '2005-06-01', 2600, 'ZGMF-1001/M Blaze Zaku Phantom - 하이네 전용기', 'http://ipsumimage.appspot.com/200x150,dfdf3f?s=24&l=%7CZGMF-1001/M%7CBlaze%20Zaku%7CPhantom%7C%ED%95%98%EC%9D%B4%EB%84%A4%20%EC%A0%84%EC%9A%A9%EA%B8%B0'),
  (24, 24, 'SD', '2003-02-01', 500, 'Strike Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=Strike%20Gundam'),
  (25, 25, 'SD', '2003-04-01', 500, 'Gundam Astray - Red Frame', 'http://ipsumimage.appspot.com/200x150,df6f4f?s=24&l=Gundam%20Astray%7CRed%20Frame'),
  (26, 26, 'SD', '2004-11-01', 500, 'Gundam NT-1', 'http://ipsumimage.appspot.com/200x150,4f4fdf?s=24&l=Gundam%20NT-1'),
  (27, 27, 'HGUC', '2006-06-01', 1400, 'EMS-10 Zudah', 'http://ipsumimage.appspot.com/200x150,bfbfef?s=24&l=EMS-10%7CZudah'),
  (28, 28, 'MG', '2001-01-01', 4000, 'MS-18E Kämpfer', 'http://ipsumimage.appspot.com/200x150,3f3fef?s=24&l=EMS-18E%7CK%C3%A4mpfer'),
  (29, 29, 'HGUC', '2006-08-01', 1200, 'RGM-79 Powered GM', 'http://ipsumimage.appspot.com/200x150,ff8f4f?s=24&l=RGM-79%7CPowered%20GM'),
  (30, 30, 'SD', '2003-11-01', 500, 'Freedom Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfff?s=24&l=Freedom%20Gundam'),
  
  (31, 1, 'SD', '1999-10-01', 500, 'RX-78 Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78%7CGundam'),
  (32, 5, 'HGUC', '2003-09-01', 1000, 'MS-06 Zaku II - 양산형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06%7CZaku%20II%7C%EC%96%91%EC%82%B0%ED%98%95g'),
  (33, 5, 'SD', '2001-07-01', 500, 'MS-06F Zaku II', 'http://ipsumimage.appspot.com/200x150,2fff2f?s=24&l=MS-06F%7CZaku%20II'),
  (34, 6, 'SD', '2002-03-01', 500, 'MS-06S Zaku II 샤아전용', 'http://ipsumimage.appspot.com/200x150,ff2f2f?s=24&l=%7CMS-06S%7CZaku%20II%7C%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (35, 7, 'SD', '2000-05-01', 400, 'Dom', 'http://ipsumimage.appspot.com/200x150,3f3f3f?s=24&l=Dom'),
  (36, 11, 'SD', '2005-07-01', 600, 'Gunner Zaku Warrior', 'http://ipsumimage.appspot.com/200x150,ff3f3f?s=24&l=Gunner%20Zaku%7CWarrior'),
  (37, 13, 'SD', '2001-06-01', 500, 'Gundam Mk-II Titans', 'http://ipsumimage.appspot.com/200x150,3f3fff?s=24&l=Gundam%20Mk-II%7CTitans'),
  (38, 18, 'HGUC', '2008-03-01', 2500, 'RX-93 υ Gundam', 'http://ipsumimage.appspot.com/200x150,dfdf33?s=24&l=RX-93%7C%CF%85%20Gundam'),
  (39, 22, 'SD', '2007-04-01', 600, 'Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fff6f?s=24&l=Verde%20Buster%7CGundam'),
  (40, 23, 'SD', '2007-07-01', 600, 'Blaze Zaku Phantom (Heine Custom)', 'http://ipsumimage.appspot.com/200x150,ffff2f?s=24&l=Blaze%20Zaku%7CPhantom%7C(Heine%20Custom)'),
  (41, 25, 'SEED HG', '2003-11-01', 1200, 'MBF-P02 Gundam Astray Red Frame', 'http://ipsumimage.appspot.com/200x150,ff4f2f?s=24&l=MBF-P02%7CGundam%20Astray%7CRed%20Frame');
  
  
INSERT INTO image (id, gunpla_id, filename, description) VALUES
  (null, 1, 'gundam.png', '세로로 긴 이미지'),
  (null, 31, '건담.jpg', '귀여운 SD'),
  (null, 1, '건담mg.jpg', '파스텔 톤 좋아'),
  (null, 1, '건담mg2.jpg', '옆 모습도 멋지군'),
  (null, 1, '건담mg3.jpg', '멋있는 MG'),
  (null, 1, '건담mg4.jpg', 'mg3 파일을 세로로 길게 crop'),
  (null, 2, '건캐논.jpg', 'SD의 위용'),
  (null, 2, '건캐논2.jpg', '앙증맞은 SD'),
  (null, 3, '건탱크.jpg', 'SD에 투명 파츠까지'),
  (null, 3, '건탱크2.jpg', 'SD 위화감이 없어'),
  (null, 4, '짐mini.jpg', '어 이거 SD 아닌데'),
  (null, 5, '자쿠IImg.jpg', '육중한 위압감'),
  (null, 5, '자쿠IImg2.jpg', '구 버전이라도 멋지다'),
  (null, 5, '자쿠IImg3.jpg', '역시 모노아이'),
  (null, 32, '자쿠II.jpg', 'HGUC 자쿠II'),
  (null, 33, '자쿠IIsd.jpg', 'SD지만 육중함은 그대로'),
  (null, 6, '자쿠II샤아전용.jpg', '3배 빠른 자쿠'),
  (null, 34, '자쿠II샤아전용sd.jpg', '귀엽고 3배 빠른 자쿠'),
  (null, 7, '돔.jpg', '튼튼한 돔'),
  (null, 35, '릭돔sd.jpg', '이거 릭돔이 아니고 돔이었구나'),
  (null, 8, '릭돔.jpg', '릭돔은 볼륨감이 좋아서 전체 샷이 멋진데'),
  (null, 9, '즈고크E.jpg', '카리스마 짱'),
  (null, 9, '즈고크E.jpg', '숨겨진 보물같은 킷'),
  (null, 10, '모빌씨그.jpg', '전설의 야수와 같은 모습'),
  (null, 11, '건너자쿠워리어.jpg', '독일군 헬멧'),
  (null, 36, '건너자쿠워리어sd.jpg', 'SD가 더 근엄한 듯'),
  (null, 36, '건너자쿠워리어sd2.jpg', 'SD지만 전투력이 높을 듯'),
  (null, 36, '건너자쿠워리어sd3.jpg', '의기 양양'),
  (null, 12, '건담5호기.jpg', '알록달록 이쁘다'),
  (null, 12, '건담5호기2.jpg', '기대하지 않았는데 만족도가 높았던 킷'),
  (null, 12, '건담5호기3.jpg', '얼굴도 알록달록'),
  (null, 12, '건담5호기4.jpg', '너무 멋져~'),
  (null, 13, '건담Mk-II에우고.jpg', '강렬한 눈빛'),
  (null, 13, '건담Mk-II에우고2.jpg', '헤드폰 착용샷'),
  (null, 37, '건담Mk-II티탄즈.jpg', 'SD에서 박력이 느껴져'),
  (null, 37, '건담Mk-II티탄즈2.jpg', '흔치 않은 컬러'),
  (null, 37, '건담Mk-II티탄즈미니.jpg', '이건 SD 아닌데'),
  (null, 14, '겔구그.jpg', '멧돼지'),
  (null, 15, '겔구그예거.jpg', '울퉁불퉁 멋진 킷'),
  (null, 15, '겔구그예거2.jpg', '전투력 높을 것 같아'),
  (null, 16, '고그.jpg', '해산물 3종 세트 중 하나. 너무 귀여워'),
  (null, 17, '네모.jpg', '만족도 엄청 높았던 킷. 또 하나의 숨겨진 보물'),
  (null, 18, '뉴건담sd.jpg', '인기 높은 뉴건담. 뉴건담이야 누 건담이야'),
  (null, 18, '뉴건담sd2.jpg', '체구에 비해 큰 백팩'),
  (null, 38, '뉴건담.jpg', '먹선을 너무 흐리게 넣었나'),
  (null, 19, '레전드건담.jpg', '무등급이지만 박력있는 백팩'),
  (null, 20, '릭디아스샤아전용.jpg', '사진빨 안받네'),
  (null, 21, '마라사이.jpg', '이 킷도 좋았음'),
  (null, 22, '베르데버스터건담.jpg', '그저 그런'),
  (null, 39, '베르데버스터건담sd.jpg', 'SD가 HGUC보다 박력있다'),
  (null, 23, '블레이즈자쿠팬텀.jpg', '무등급이지만 좋다'),
  (null, 40, '블레이즈자쿠팬텀sd.jpg', '먹선 안 넣어도 멋져'),
  (null, 40, '블레이즈자쿠팬텀sd2.jpg', '쌍도끼. 어쎄신 크리드 발할라 찍냐'),
  (null, 24, '스트라이크건담.jpg', '스트라이크 건담은 모든 등급이 다 잘 뽑힌듯'),
  (null, 24, '스트라이크건담2.jpg', '너무 가까워'),
  (null, 24, '스트라이크건담3.jpg', 'SD치고는 롱다리'),
  (null, 25, '아스트레이레드sd.jpg', 'SD 얼굴 귀여워'),
  (null, 41, '아스트레이레드.jpg', '독특한 근육 몸매. 가동률 좋음'),
  (null, 26, '알렉스.jpg', '주머니 속의 전쟁 주인공 기체'),
  (null, 26, '알렉스2.jpg', '개틀링 건도 장착 가능'),
  (null, 27, '주다.jpg', '개성 만점. 강추'),
  (null, 28, '캠퍼.jpg', '건담이 아닌 다른 애니메이션에 등장할 법한 특이한 외형이지만 좋다. 버니어 색분할 압권'),
  (null, 29, '파워드짐.jpg', '폭죽이라 놀리지 마라'),
  (null, 29, '파워드짐2.jpg', '심플한 매력'),
  (null, 30, '프리덤건담.jpg', '인기 많은 기체'),
  (null, 30, '프리덤건담2.jpg', 'MG의 화려함을 따라가기엔 부족'),
  (null, 30, '프리덤건담3.jpg', '인기 많은 기체 답게 뭐가 많이 달려있다');
 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍17분안에 읽기 (약 2597 단어)

Chap.11. PHP

CoLab

https://colab.research.google.com/drive/1uRPwEjcABy2uYWAyuSKL2JhFtZ4OkfAV

https://bit.ly/39K4wMV

Github

https://github.com/devbwoh/list-php-mysql

Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
DROP DATABASE IF EXISTS `gunpladb` ;

CREATE DATABASE IF NOT EXISTS `gunpladb` 
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

USE `gunpladb` ;

CREATE TABLE `mechanic` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `model` VARCHAR(100) NOT NULL,
  `manufacturer` VARCHAR(255) NULL,
  `armor` VARCHAR(255) NULL,
  `height` DECIMAL(7,2) NULL,
  `weight` DECIMAL(7,2) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `gunpla` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `mechanic_id` INT NOT NULL,
  `grade` VARCHAR(45) NOT NULL,
  `date` DATE NULL,
  `price` INT(11) NULL,
  `title` VARCHAR(255) NULL,
  `boxart` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`),
  INDEX (`mechanic_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `image` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `gunpla_id` INT NOT NULL,
  `filename` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX (`gunpla_id`),
  FOREIGN KEY (`gunpla_id`) REFERENCES `gunpla` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `armament` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `description` TEXT NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `equipment` (
  `mechanic_id` INT NOT NULL,
  `armaments_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `armaments_id`),
  INDEX (`armaments_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`armaments_id`) REFERENCES `armament` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `pilot` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NULL,
  `type` VARCHAR(100) NULL,
  `nationality` VARCHAR(100) NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `boarding` (
  `mechanic_id` INT NOT NULL,
  `pilot_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `pilot_id`),
  INDEX (`pilot_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`pilot_id`) REFERENCES `pilot` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;


###############################################

INSERT INTO mechanic (id, name, model, manufacturer, armor, height, weight) VALUES
  (1, '건담', 'RX-78-2', 'Earth Federation', 'Luna Titanium', 18.0, 43.4),
  (2, '건캐논', 'RX-77-2', 'Earth Federation', 'Luna Titanium', 17.5, 51.0),
  (3, '건탱크', 'RX-75', 'Earth Federation', 'Luna Titanium', 15.0, 56.0),
  (4, '짐', 'RGM-79', 'Earth Federation Forces', 'Titanium Alloy', 18.0, 41.2),
  (5, '자쿠 II', 'MS-06F', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 58.1),
  (6, '샤아 전용 자쿠 II', 'MS-06S', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 56.5),
  (7, '돔', 'MS-09B', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 62.6),
  (8, '릭 돔', 'MS-09R', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 43.8),
  (9, '즈고크 E', 'MSM-07E', 'MIP Company', 'Titanium Alloy Ceramic Composite', 18.4, 69.5),
  (10, '씨그', 'ZGMF-515', 'Zodiac Alliance of Freedom Treaty', null, 21.43, 80.22),
  (11, '거너 자쿠 워리어', 'ZGMF-1000/A1', 'Integrated Design Bureau', null, 20.50, 91.11),
  (12, '건담 5호기', 'RX-78-5', 'Earth Federation', 'Luna Titanium', 18.0, 42.9),
  (13, '건담 Mk-II', 'RX-178', 'Titans', 'Titanium Alloy Ceramic Composite', 18.5, 33.4),
  (14, '겔구그', 'MS-14A/C', 'Zeonic Company', 'Super Hard Steel Alloy', 19.2, 42.1),
  (15, '겔구그 예거', 'MS-14Jg', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 19.2, 40.5),
  (16, '고그', 'MSM-03', 'Zimmad Company', 'Super High Tensile Steel', 18.3, 82.4),
  (17, '네모', 'MSA-003', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (18, '뉴건담', 'RX-93', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (19, '레전드 건담', 'ZGMF-X666S', 'Zodiac Alliance of Freedom Treaty', 'Variable Phase Shift armor', 18.66, 86.02),
  (20, '릭디아스', 'RMS-099', 'Anaheim Electronics', 'Gundarium γ Alloy', 18.0, 32.2),
  (21, '마라사이', 'RMS-108', 'Anaheim Electronics', 'Gundarium Alloy', 17.5, 33.1),
  (22, '베르데 버스터 건담', 'GAT-X103AP', 'Actaeon Industries', 'Variable Phase Shift Armor', 18.46, 99.36),
  (23, '블레이즈 자쿠 팬텀', 'ZGMF-1001/M', 'Integrated Design Bureau', null, 20.4, 91.2),
  (24, '스트라이크 건담', 'GAT-X105', 'Earth Alliance', 'Phase Shift Armor', 17.72, 64.8),
  (25, '건담 아스트레이 레드 프레임', 'MBF-P02', 'Morgenroete, Inc.', 'Foaming metal', 17.53, 49.8),
  (26, '알렉스', 'RX-78NT-1', 'Earth Federation', 'Luna Titanium', 18.0, 40.0),
  (27, '주다', 'EMS-10', 'Zimmad Company', 'Hardened Steel', 17.3, 61.0),
  (28, '캠퍼', 'MS-18E', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 17.7, 43.5),
  (29, '파워드 짐', 'RGM-79', 'Earth Federation', 'Titanium Ceramic Composite', 18.0, 46.6),
  (30, '프리덤 건담', 'ZGMF-X10A', 'Integrated Design Bureau', 'Phase Shift Armor', 18.03, 71.5);
  
INSERT INTO gunpla (id, mechanic_id, grade, date, price, title, boxart) VALUES
  (1, 1, 'MG', '2005-03-01', 3200, 'RX-78-2 Gundam ver. O.Y.W 0079 (PS2 soft)', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78-2%20Gundam%7Cver.%20O.Y.W%200079%7C(PS2%20soft)'),
  (2, 2, 'SD', '2001-11-01', 500, 'Gun Cannon', 'http://ipsumimage.appspot.com/200x150,ffff3f?s=24&l=Gun%20Cannon'),
  (3, 3, 'SD', '2001-08-01', 500, 'Gun Tank', 'http://ipsumimage.appspot.com/200x150,ffff72?s=24&l=Gun%20Tank'),
  (4, 4, 'SD', '2001-04-01', 700, 'GM', 'http://ipsumimage.appspot.com/200x150,ffffd7?s=24&l=GM'),
  (5, 5, 'MG', '2002-09-01', 3000, 'MS-06F2	Zaku II F2 : EFSF 연방군형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06F2%7CZaku%20II%20F2%7CEFSF%20%EC%97%B0%EB%B0%A9%EA%B5%B0%ED%98%95'),
  (6, 6, 'RG', '2010-11-01', 2500, "MS-06S Char's Zaku II", 'http://ipsumimage.appspot.com/200x150,7f7fff?s=24&l=MS-06S%7CChar%27s%20Zaku%20II'),
  (7, 7, 'HGUC', '2006-01-01', 1700, 'MS-09/MS-09R Dom/Rick-Dom', 'http://ipsumimage.appspot.com/200x150,9f7fd2?s=24&l=MS-09%7CMS-09R%20Dom%7CRick-Dom'),
  (8, 8, 'MG', '1999-10-01', 4000, 'MS-09R Rick-Dom', 'http://ipsumimage.appspot.com/200x150,ff7fd2?s=24&l=MS-09R%7CRick-Dom'),
  (9, 9, 'HGUC', '2003-08-01', 1200, "MSM-07E Z'gok Experiment", 'http://ipsumimage.appspot.com/200x150,6f7fff?s=24&l=MSM-07E%7CZ%27gok%20Experiment'),
  (10, 10, 'SEED HG', '2004-04-01', 1200, 'ZGMF-515 Mobile Cgue', 'http://ipsumimage.appspot.com/200x150,afafaf?s=24&l=ZGMF-515%7CMobile%20Cgue'),   
  (11, 11, 'SEED 1/100', '2005-03-01', 2300, 'ZGMF-1000/A1 Gunner Zaku Warrior - 루나마리아 전용', 'http://ipsumimage.appspot.com/200x150,ff4f4f?s=24&l=ZGMF-1000/A1%7CGunner%20Zaku%7CWarrior%7C%EB%A3%A8%EB%82%98%EB%A7%88%EB%A6%AC%EC%95%84%7C%EC%A0%84%EC%9A%A9'),   
  (12, 12, 'MG', '2003-08-01', 2800, 'RX-78-5 Gundam 5호기', 'http://ipsumimage.appspot.com/200x150,ffff4f?s=24&l=RX-78-5%7CGundam%205%ED%98%B8%EA%B8%B0'),  
  (13, 13, 'MG', '2005-10-01', 4000, 'RX-178 Gundam Mk-II v2.0', 'http://ipsumimage.appspot.com/200x150,8f8fff?s=24&l=RX-178%7CGundam%20Mk-II%7Cv2.0'),  
  (14, 14, 'HGUC', '2007-03-01', 1600, 'MS-14A/C Gelgoog/Gelgoog Cannon', 'http://ipsumimage.appspot.com/200x150,8f8f2f?s=24&l=MS-14A/C%7CGelgoog/%7CGelgoog%20Cannon'),  
  (15, 15, 'HGUC', '2004-04-01', 1200, 'MS-14JG	Gelgoog J', 'http://ipsumimage.appspot.com/200x150,ff8f2f?s=24&l=MS-14JG%7CGelgoog%20J'),
  (16, 16, 'SD', '2000-02-01', 500, 'Gogg/Acguy/Zock', 'http://ipsumimage.appspot.com/200x150,8f7fff?s=24&l=Gogg%7CAcguy%7CZock'),
  (17, 17, 'MG', '2006-02-01', 2800, 'MSA-003 Nemo', 'http://ipsumimage.appspot.com/200x150,7fff8f?s=24&l=MSA-003%20Nemo'),
  (18, 18, 'SD', '2000-08-01', 500, 'Nu Gundam', 'http://ipsumimage.appspot.com/200x150,ffffaf?s=24&l=Nu%20Gundam'),
  (19, 19, 'SEED 1/100', '2006-06-01', 2600, 'ZGMF-X666S Legend Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfef?s=24&l=ZGMF-X666S%7CLegend%20Gundam'),
  (20, 20, 'HGUC', '2002-08-01', 1200, 'RMS-099 Rick Dias - 샤아전용', 'http://ipsumimage.appspot.com/200x150,df2f3f?s=24&l=RMS-099%7CRick%20Dias%20%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (21, 21, 'HGUC', '2005-01-01', 1400, 'RMS-108 Marasai', 'http://ipsumimage.appspot.com/200x150,ff5f5f?s=24&l=RMS-108%7CMarasai'),
  (22, 22, 'SEED HG', '2006-08-01', 1600, 'GAT-X103AP Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fffaf?s=24&l=GAT-X103AP%7CVerde%20Buster%7CGundam'),
  (23, 23, 'SEED 1/100', '2005-06-01', 2600, 'ZGMF-1001/M Blaze Zaku Phantom - 하이네 전용기', 'http://ipsumimage.appspot.com/200x150,dfdf3f?s=24&l=%7CZGMF-1001/M%7CBlaze%20Zaku%7CPhantom%7C%ED%95%98%EC%9D%B4%EB%84%A4%20%EC%A0%84%EC%9A%A9%EA%B8%B0'),
  (24, 24, 'SD', '2003-02-01', 500, 'Strike Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=Strike%20Gundam'),
  (25, 25, 'SD', '2003-04-01', 500, 'Gundam Astray - Red Frame', 'http://ipsumimage.appspot.com/200x150,df6f4f?s=24&l=Gundam%20Astray%7CRed%20Frame'),
  (26, 26, 'SD', '2004-11-01', 500, 'Gundam NT-1', 'http://ipsumimage.appspot.com/200x150,4f4fdf?s=24&l=Gundam%20NT-1'),
  (27, 27, 'HGUC', '2006-06-01', 1400, 'EMS-10 Zudah', 'http://ipsumimage.appspot.com/200x150,bfbfef?s=24&l=EMS-10%7CZudah'),
  (28, 28, 'MG', '2001-01-01', 4000, 'MS-18E Kämpfer', 'http://ipsumimage.appspot.com/200x150,3f3fef?s=24&l=EMS-18E%7CK%C3%A4mpfer'),
  (29, 29, 'HGUC', '2006-08-01', 1200, 'RGM-79 Powered GM', 'http://ipsumimage.appspot.com/200x150,ff8f4f?s=24&l=RGM-79%7CPowered%20GM'),
  (30, 30, 'SD', '2003-11-01', 500, 'Freedom Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfff?s=24&l=Freedom%20Gundam'),
  
  (31, 1, 'SD', '1999-10-01', 500, 'RX-78 Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78%7CGundam'),
  (32, 5, 'HGUC', '2003-09-01', 1000, 'MS-06 Zaku II - 양산형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06%7CZaku%20II%7C%EC%96%91%EC%82%B0%ED%98%95g'),
  (33, 5, 'SD', '2001-07-01', 500, 'MS-06F Zaku II', 'http://ipsumimage.appspot.com/200x150,2fff2f?s=24&l=MS-06F%7CZaku%20II'),
  (34, 6, 'SD', '2002-03-01', 500, 'MS-06S Zaku II 샤아전용', 'http://ipsumimage.appspot.com/200x150,ff2f2f?s=24&l=%7CMS-06S%7CZaku%20II%7C%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (35, 7, 'SD', '2000-05-01', 400, 'Dom', 'http://ipsumimage.appspot.com/200x150,3f3f3f?s=24&l=Dom'),
  (36, 11, 'SD', '2005-07-01', 600, 'Gunner Zaku Warrior', 'http://ipsumimage.appspot.com/200x150,ff3f3f?s=24&l=Gunner%20Zaku%7CWarrior'),
  (37, 13, 'SD', '2001-06-01', 500, 'Gundam Mk-II Titans', 'http://ipsumimage.appspot.com/200x150,3f3fff?s=24&l=Gundam%20Mk-II%7CTitans'),
  (38, 18, 'HGUC', '2008-03-01', 2500, 'RX-93 υ Gundam', 'http://ipsumimage.appspot.com/200x150,dfdf33?s=24&l=RX-93%7C%CF%85%20Gundam'),
  (39, 22, 'SD', '2007-04-01', 600, 'Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fff6f?s=24&l=Verde%20Buster%7CGundam'),
  (40, 23, 'SD', '2007-07-01', 600, 'Blaze Zaku Phantom (Heine Custom)', 'http://ipsumimage.appspot.com/200x150,ffff2f?s=24&l=Blaze%20Zaku%7CPhantom%7C(Heine%20Custom)'),
  (41, 25, 'SEED HG', '2003-11-01', 1200, 'MBF-P02 Gundam Astray Red Frame', 'http://ipsumimage.appspot.com/200x150,ff4f2f?s=24&l=MBF-P02%7CGundam%20Astray%7CRed%20Frame');
  
  
INSERT INTO image (id, gunpla_id, filename, description) VALUES
  (null, 1, 'gundam.png', '세로로 긴 이미지'),
  (null, 31, '건담.jpg', '귀여운 SD'),
  (null, 1, '건담mg.jpg', '파스텔 톤 좋아'),
  (null, 1, '건담mg2.jpg', '옆 모습도 멋지군'),
  (null, 1, '건담mg3.jpg', '멋있는 MG'),
  (null, 1, '건담mg4.jpg', 'mg3 파일을 세로로 길게 crop'),
  (null, 2, '건캐논.jpg', 'SD의 위용'),
  (null, 2, '건캐논2.jpg', '앙증맞은 SD'),
  (null, 3, '건탱크.jpg', 'SD에 투명 파츠까지'),
  (null, 3, '건탱크2.jpg', 'SD 위화감이 없어'),
  (null, 4, '짐mini.jpg', '어 이거 SD 아닌데'),
  (null, 5, '자쿠IImg.jpg', '육중한 위압감'),
  (null, 5, '자쿠IImg2.jpg', '구 버전이라도 멋지다'),
  (null, 5, '자쿠IImg3.jpg', '역시 모노아이'),
  (null, 32, '자쿠II.jpg', 'HGUC 자쿠II'),
  (null, 33, '자쿠IIsd.jpg', 'SD지만 육중함은 그대로'),
  (null, 6, '자쿠II샤아전용.jpg', '3배 빠른 자쿠'),
  (null, 34, '자쿠II샤아전용sd.jpg', '귀엽고 3배 빠른 자쿠'),
  (null, 7, '돔.jpg', '튼튼한 돔'),
  (null, 35, '릭돔sd.jpg', '이거 릭돔이 아니고 돔이었구나'),
  (null, 8, '릭돔.jpg', '릭돔은 볼륨감이 좋아서 전체 샷이 멋진데'),
  (null, 9, '즈고크E.jpg', '카리스마 짱'),
  (null, 9, '즈고크E.jpg', '숨겨진 보물같은 킷'),
  (null, 10, '모빌씨그.jpg', '전설의 야수와 같은 모습'),
  (null, 11, '건너자쿠워리어.jpg', '독일군 헬멧'),
  (null, 36, '건너자쿠워리어sd.jpg', 'SD가 더 근엄한 듯'),
  (null, 36, '건너자쿠워리어sd2.jpg', 'SD지만 전투력이 높을 듯'),
  (null, 36, '건너자쿠워리어sd3.jpg', '의기 양양'),
  (null, 12, '건담5호기.jpg', '알록달록 이쁘다'),
  (null, 12, '건담5호기2.jpg', '기대하지 않았는데 만족도가 높았던 킷'),
  (null, 12, '건담5호기3.jpg', '얼굴도 알록달록'),
  (null, 12, '건담5호기4.jpg', '너무 멋져~'),
  (null, 13, '건담Mk-II에우고.jpg', '강렬한 눈빛'),
  (null, 13, '건담Mk-II에우고2.jpg', '헤드폰 착용샷'),
  (null, 37, '건담Mk-II티탄즈.jpg', 'SD에서 박력이 느껴져'),
  (null, 37, '건담Mk-II티탄즈2.jpg', '흔치 않은 컬러'),
  (null, 37, '건담Mk-II티탄즈미니.jpg', '이건 SD 아닌데'),
  (null, 14, '겔구그.jpg', '멧돼지'),
  (null, 15, '겔구그예거.jpg', '울퉁불퉁 멋진 킷'),
  (null, 15, '겔구그예거2.jpg', '전투력 높을 것 같아'),
  (null, 16, '고그.jpg', '해산물 3종 세트 중 하나. 너무 귀여워'),
  (null, 17, '네모.jpg', '만족도 엄청 높았던 킷. 또 하나의 숨겨진 보물'),
  (null, 18, '뉴건담sd.jpg', '인기 높은 뉴건담. 뉴건담이야 누 건담이야'),
  (null, 18, '뉴건담sd2.jpg', '체구에 비해 큰 백팩'),
  (null, 38, '뉴건담.jpg', '먹선을 너무 흐리게 넣었나'),
  (null, 19, '레전드건담.jpg', '무등급이지만 박력있는 백팩'),
  (null, 20, '릭디아스샤아전용.jpg', '사진빨 안받네'),
  (null, 21, '마라사이.jpg', '이 킷도 좋았음'),
  (null, 22, '베르데버스터건담.jpg', '그저 그런'),
  (null, 39, '베르데버스터건담sd.jpg', 'SD가 HGUC보다 박력있다'),
  (null, 23, '블레이즈자쿠팬텀.jpg', '무등급이지만 좋다'),
  (null, 40, '블레이즈자쿠팬텀sd.jpg', '먹선 안 넣어도 멋져'),
  (null, 40, '블레이즈자쿠팬텀sd2.jpg', '쌍도끼. 어쎄신 크리드 발할라 찍냐'),
  (null, 24, '스트라이크건담.jpg', '스트라이크 건담은 모든 등급이 다 잘 뽑힌듯'),
  (null, 24, '스트라이크건담2.jpg', '너무 가까워'),
  (null, 24, '스트라이크건담3.jpg', 'SD치고는 롱다리'),
  (null, 25, '아스트레이레드sd.jpg', 'SD 얼굴 귀여워'),
  (null, 41, '아스트레이레드.jpg', '독특한 근육 몸매. 가동률 좋음'),
  (null, 26, '알렉스.jpg', '주머니 속의 전쟁 주인공 기체'),
  (null, 26, '알렉스2.jpg', '개틀링 건도 장착 가능'),
  (null, 27, '주다.jpg', '개성 만점. 강추'),
  (null, 28, '캠퍼.jpg', '건담이 아닌 다른 애니메이션에 등장할 법한 특이한 외형이지만 좋다. 버니어 색분할 압권'),
  (null, 29, '파워드짐.jpg', '폭죽이라 놀리지 마라'),
  (null, 29, '파워드짐2.jpg', '심플한 매력'),
  (null, 30, '프리덤건담.jpg', '인기 많은 기체'),
  (null, 30, '프리덤건담2.jpg', 'MG의 화려함을 따라가기엔 부족'),
  (null, 30, '프리덤건담3.jpg', '인기 많은 기체 답게 뭐가 많이 달려있다');
 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍18분안에 읽기 (약 2639 단어)

Chap.12. Express

CoLab

https://colab.research.google.com/drive/1BAbJdJ8O5LH9EIFf9qjf2brTpaPn5iv-

https://bit.ly/3c1cwfa

Github

https://github.com/devbwoh/express-gunpladb

Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
# 권한 설정
# 필요 없으면 Skip!
grant all privileges on  *.* to 'root'@'%' identified by 'mysql1234';
delete from mysql.user where host="localhost" and user="root";
flush privileges;
select host,user,plugin,authentication_string from mysql.user;

#####
DROP DATABASE IF EXISTS `gunpladb` ;

CREATE DATABASE IF NOT EXISTS `gunpladb` 
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

USE `gunpladb` ;

CREATE TABLE `mechanic` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `model` VARCHAR(100) NOT NULL,
  `manufacturer` VARCHAR(255) NULL,
  `armor` VARCHAR(255) NULL,
  `height` DECIMAL(7,2) NULL,
  `weight` DECIMAL(7,2) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `gunpla` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `mechanic_id` INT NOT NULL,
  `grade` VARCHAR(45) NOT NULL,
  `date` DATE NULL,
  `price` INT(11) NULL,
  `title` VARCHAR(255) NULL,
  `boxart` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`),
  INDEX (`mechanic_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `image` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `gunpla_id` INT NOT NULL,
  `filename` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX (`gunpla_id`),
  FOREIGN KEY (`gunpla_id`) REFERENCES `gunpla` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `armament` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `description` TEXT NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `equipment` (
  `mechanic_id` INT NOT NULL,
  `armaments_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `armaments_id`),
  INDEX (`armaments_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`armaments_id`) REFERENCES `armament` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `pilot` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NULL,
  `type` VARCHAR(100) NULL,
  `nationality` VARCHAR(100) NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `boarding` (
  `mechanic_id` INT NOT NULL,
  `pilot_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `pilot_id`),
  INDEX (`pilot_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`pilot_id`) REFERENCES `pilot` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;


###############################################

INSERT INTO mechanic (id, name, model, manufacturer, armor, height, weight) VALUES
  (1, '건담', 'RX-78-2', 'Earth Federation', 'Luna Titanium', 18.0, 43.4),
  (2, '건캐논', 'RX-77-2', 'Earth Federation', 'Luna Titanium', 17.5, 51.0),
  (3, '건탱크', 'RX-75', 'Earth Federation', 'Luna Titanium', 15.0, 56.0),
  (4, '짐', 'RGM-79', 'Earth Federation Forces', 'Titanium Alloy', 18.0, 41.2),
  (5, '자쿠 II', 'MS-06F', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 58.1),
  (6, '샤아 전용 자쿠 II', 'MS-06S', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 56.5),
  (7, '돔', 'MS-09B', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 62.6),
  (8, '릭 돔', 'MS-09R', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 43.8),
  (9, '즈고크 E', 'MSM-07E', 'MIP Company', 'Titanium Alloy Ceramic Composite', 18.4, 69.5),
  (10, '씨그', 'ZGMF-515', 'Zodiac Alliance of Freedom Treaty', null, 21.43, 80.22),
  (11, '거너 자쿠 워리어', 'ZGMF-1000/A1', 'Integrated Design Bureau', null, 20.50, 91.11),
  (12, '건담 5호기', 'RX-78-5', 'Earth Federation', 'Luna Titanium', 18.0, 42.9),
  (13, '건담 Mk-II', 'RX-178', 'Titans', 'Titanium Alloy Ceramic Composite', 18.5, 33.4),
  (14, '겔구그', 'MS-14A/C', 'Zeonic Company', 'Super Hard Steel Alloy', 19.2, 42.1),
  (15, '겔구그 예거', 'MS-14Jg', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 19.2, 40.5),
  (16, '고그', 'MSM-03', 'Zimmad Company', 'Super High Tensile Steel', 18.3, 82.4),
  (17, '네모', 'MSA-003', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (18, '뉴건담', 'RX-93', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (19, '레전드 건담', 'ZGMF-X666S', 'Zodiac Alliance of Freedom Treaty', 'Variable Phase Shift armor', 18.66, 86.02),
  (20, '릭디아스', 'RMS-099', 'Anaheim Electronics', 'Gundarium γ Alloy', 18.0, 32.2),
  (21, '마라사이', 'RMS-108', 'Anaheim Electronics', 'Gundarium Alloy', 17.5, 33.1),
  (22, '베르데 버스터 건담', 'GAT-X103AP', 'Actaeon Industries', 'Variable Phase Shift Armor', 18.46, 99.36),
  (23, '블레이즈 자쿠 팬텀', 'ZGMF-1001/M', 'Integrated Design Bureau', null, 20.4, 91.2),
  (24, '스트라이크 건담', 'GAT-X105', 'Earth Alliance', 'Phase Shift Armor', 17.72, 64.8),
  (25, '건담 아스트레이 레드 프레임', 'MBF-P02', 'Morgenroete, Inc.', 'Foaming metal', 17.53, 49.8),
  (26, '알렉스', 'RX-78NT-1', 'Earth Federation', 'Luna Titanium', 18.0, 40.0),
  (27, '주다', 'EMS-10', 'Zimmad Company', 'Hardened Steel', 17.3, 61.0),
  (28, '캠퍼', 'MS-18E', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 17.7, 43.5),
  (29, '파워드 짐', 'RGM-79', 'Earth Federation', 'Titanium Ceramic Composite', 18.0, 46.6),
  (30, '프리덤 건담', 'ZGMF-X10A', 'Integrated Design Bureau', 'Phase Shift Armor', 18.03, 71.5);
  
INSERT INTO gunpla (id, mechanic_id, grade, date, price, title, boxart) VALUES
  (1, 1, 'MG', '2005-03-01', 3200, 'RX-78-2 Gundam ver. O.Y.W 0079 (PS2 soft)', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78-2%20Gundam%7Cver.%20O.Y.W%200079%7C(PS2%20soft)'),
  (2, 2, 'SD', '2001-11-01', 500, 'Gun Cannon', 'http://ipsumimage.appspot.com/200x150,ffff3f?s=24&l=Gun%20Cannon'),
  (3, 3, 'SD', '2001-08-01', 500, 'Gun Tank', 'http://ipsumimage.appspot.com/200x150,ffff72?s=24&l=Gun%20Tank'),
  (4, 4, 'SD', '2001-04-01', 700, 'GM', 'http://ipsumimage.appspot.com/200x150,ffffd7?s=24&l=GM'),
  (5, 5, 'MG', '2002-09-01', 3000, 'MS-06F2	Zaku II F2 : EFSF 연방군형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06F2%7CZaku%20II%20F2%7CEFSF%20%EC%97%B0%EB%B0%A9%EA%B5%B0%ED%98%95'),
  (6, 6, 'RG', '2010-11-01', 2500, "MS-06S Char's Zaku II", 'http://ipsumimage.appspot.com/200x150,7f7fff?s=24&l=MS-06S%7CChar%27s%20Zaku%20II'),
  (7, 7, 'HGUC', '2006-01-01', 1700, 'MS-09/MS-09R Dom/Rick-Dom', 'http://ipsumimage.appspot.com/200x150,9f7fd2?s=24&l=MS-09%7CMS-09R%20Dom%7CRick-Dom'),
  (8, 8, 'MG', '1999-10-01', 4000, 'MS-09R Rick-Dom', 'http://ipsumimage.appspot.com/200x150,ff7fd2?s=24&l=MS-09R%7CRick-Dom'),
  (9, 9, 'HGUC', '2003-08-01', 1200, "MSM-07E Z'gok Experiment", 'http://ipsumimage.appspot.com/200x150,6f7fff?s=24&l=MSM-07E%7CZ%27gok%20Experiment'),
  (10, 10, 'SEED HG', '2004-04-01', 1200, 'ZGMF-515 Mobile Cgue', 'http://ipsumimage.appspot.com/200x150,afafaf?s=24&l=ZGMF-515%7CMobile%20Cgue'),   
  (11, 11, 'SEED 1/100', '2005-03-01', 2300, 'ZGMF-1000/A1 Gunner Zaku Warrior - 루나마리아 전용', 'http://ipsumimage.appspot.com/200x150,ff4f4f?s=24&l=ZGMF-1000/A1%7CGunner%20Zaku%7CWarrior%7C%EB%A3%A8%EB%82%98%EB%A7%88%EB%A6%AC%EC%95%84%7C%EC%A0%84%EC%9A%A9'),   
  (12, 12, 'MG', '2003-08-01', 2800, 'RX-78-5 Gundam 5호기', 'http://ipsumimage.appspot.com/200x150,ffff4f?s=24&l=RX-78-5%7CGundam%205%ED%98%B8%EA%B8%B0'),  
  (13, 13, 'MG', '2005-10-01', 4000, 'RX-178 Gundam Mk-II v2.0', 'http://ipsumimage.appspot.com/200x150,8f8fff?s=24&l=RX-178%7CGundam%20Mk-II%7Cv2.0'),  
  (14, 14, 'HGUC', '2007-03-01', 1600, 'MS-14A/C Gelgoog/Gelgoog Cannon', 'http://ipsumimage.appspot.com/200x150,8f8f2f?s=24&l=MS-14A/C%7CGelgoog/%7CGelgoog%20Cannon'),  
  (15, 15, 'HGUC', '2004-04-01', 1200, 'MS-14JG	Gelgoog J', 'http://ipsumimage.appspot.com/200x150,ff8f2f?s=24&l=MS-14JG%7CGelgoog%20J'),
  (16, 16, 'SD', '2000-02-01', 500, 'Gogg/Acguy/Zock', 'http://ipsumimage.appspot.com/200x150,8f7fff?s=24&l=Gogg%7CAcguy%7CZock'),
  (17, 17, 'MG', '2006-02-01', 2800, 'MSA-003 Nemo', 'http://ipsumimage.appspot.com/200x150,7fff8f?s=24&l=MSA-003%20Nemo'),
  (18, 18, 'SD', '2000-08-01', 500, 'Nu Gundam', 'http://ipsumimage.appspot.com/200x150,ffffaf?s=24&l=Nu%20Gundam'),
  (19, 19, 'SEED 1/100', '2006-06-01', 2600, 'ZGMF-X666S Legend Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfef?s=24&l=ZGMF-X666S%7CLegend%20Gundam'),
  (20, 20, 'HGUC', '2002-08-01', 1200, 'RMS-099 Rick Dias - 샤아전용', 'http://ipsumimage.appspot.com/200x150,df2f3f?s=24&l=RMS-099%7CRick%20Dias%20%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (21, 21, 'HGUC', '2005-01-01', 1400, 'RMS-108 Marasai', 'http://ipsumimage.appspot.com/200x150,ff5f5f?s=24&l=RMS-108%7CMarasai'),
  (22, 22, 'SEED HG', '2006-08-01', 1600, 'GAT-X103AP Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fffaf?s=24&l=GAT-X103AP%7CVerde%20Buster%7CGundam'),
  (23, 23, 'SEED 1/100', '2005-06-01', 2600, 'ZGMF-1001/M Blaze Zaku Phantom - 하이네 전용기', 'http://ipsumimage.appspot.com/200x150,dfdf3f?s=24&l=%7CZGMF-1001/M%7CBlaze%20Zaku%7CPhantom%7C%ED%95%98%EC%9D%B4%EB%84%A4%20%EC%A0%84%EC%9A%A9%EA%B8%B0'),
  (24, 24, 'SD', '2003-02-01', 500, 'Strike Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=Strike%20Gundam'),
  (25, 25, 'SD', '2003-04-01', 500, 'Gundam Astray - Red Frame', 'http://ipsumimage.appspot.com/200x150,df6f4f?s=24&l=Gundam%20Astray%7CRed%20Frame'),
  (26, 26, 'SD', '2004-11-01', 500, 'Gundam NT-1', 'http://ipsumimage.appspot.com/200x150,4f4fdf?s=24&l=Gundam%20NT-1'),
  (27, 27, 'HGUC', '2006-06-01', 1400, 'EMS-10 Zudah', 'http://ipsumimage.appspot.com/200x150,bfbfef?s=24&l=EMS-10%7CZudah'),
  (28, 28, 'MG', '2001-01-01', 4000, 'MS-18E Kämpfer', 'http://ipsumimage.appspot.com/200x150,3f3fef?s=24&l=EMS-18E%7CK%C3%A4mpfer'),
  (29, 29, 'HGUC', '2006-08-01', 1200, 'RGM-79 Powered GM', 'http://ipsumimage.appspot.com/200x150,ff8f4f?s=24&l=RGM-79%7CPowered%20GM'),
  (30, 30, 'SD', '2003-11-01', 500, 'Freedom Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfff?s=24&l=Freedom%20Gundam'),
  
  (31, 1, 'SD', '1999-10-01', 500, 'RX-78 Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78%7CGundam'),
  (32, 5, 'HGUC', '2003-09-01', 1000, 'MS-06 Zaku II - 양산형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06%7CZaku%20II%7C%EC%96%91%EC%82%B0%ED%98%95g'),
  (33, 5, 'SD', '2001-07-01', 500, 'MS-06F Zaku II', 'http://ipsumimage.appspot.com/200x150,2fff2f?s=24&l=MS-06F%7CZaku%20II'),
  (34, 6, 'SD', '2002-03-01', 500, 'MS-06S Zaku II 샤아전용', 'http://ipsumimage.appspot.com/200x150,ff2f2f?s=24&l=%7CMS-06S%7CZaku%20II%7C%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (35, 7, 'SD', '2000-05-01', 400, 'Dom', 'http://ipsumimage.appspot.com/200x150,3f3f3f?s=24&l=Dom'),
  (36, 11, 'SD', '2005-07-01', 600, 'Gunner Zaku Warrior', 'http://ipsumimage.appspot.com/200x150,ff3f3f?s=24&l=Gunner%20Zaku%7CWarrior'),
  (37, 13, 'SD', '2001-06-01', 500, 'Gundam Mk-II Titans', 'http://ipsumimage.appspot.com/200x150,3f3fff?s=24&l=Gundam%20Mk-II%7CTitans'),
  (38, 18, 'HGUC', '2008-03-01', 2500, 'RX-93 υ Gundam', 'http://ipsumimage.appspot.com/200x150,dfdf33?s=24&l=RX-93%7C%CF%85%20Gundam'),
  (39, 22, 'SD', '2007-04-01', 600, 'Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fff6f?s=24&l=Verde%20Buster%7CGundam'),
  (40, 23, 'SD', '2007-07-01', 600, 'Blaze Zaku Phantom (Heine Custom)', 'http://ipsumimage.appspot.com/200x150,ffff2f?s=24&l=Blaze%20Zaku%7CPhantom%7C(Heine%20Custom)'),
  (41, 25, 'SEED HG', '2003-11-01', 1200, 'MBF-P02 Gundam Astray Red Frame', 'http://ipsumimage.appspot.com/200x150,ff4f2f?s=24&l=MBF-P02%7CGundam%20Astray%7CRed%20Frame');
  
  
INSERT INTO image (id, gunpla_id, filename, description) VALUES
  (null, 1, 'gundam.png', '세로로 긴 이미지'),
  (null, 31, '건담.jpg', '귀여운 SD'),
  (null, 1, '건담mg.jpg', '파스텔 톤 좋아'),
  (null, 1, '건담mg2.jpg', '옆 모습도 멋지군'),
  (null, 1, '건담mg3.jpg', '멋있는 MG'),
  (null, 1, '건담mg4.jpg', 'mg3 파일을 세로로 길게 crop'),
  (null, 2, '건캐논.jpg', 'SD의 위용'),
  (null, 2, '건캐논2.jpg', '앙증맞은 SD'),
  (null, 3, '건탱크.jpg', 'SD에 투명 파츠까지'),
  (null, 3, '건탱크2.jpg', 'SD 위화감이 없어'),
  (null, 4, '짐mini.jpg', '어 이거 SD 아닌데'),
  (null, 5, '자쿠IImg.jpg', '육중한 위압감'),
  (null, 5, '자쿠IImg2.jpg', '구 버전이라도 멋지다'),
  (null, 5, '자쿠IImg3.jpg', '역시 모노아이'),
  (null, 32, '자쿠II.jpg', 'HGUC 자쿠II'),
  (null, 33, '자쿠IIsd.jpg', 'SD지만 육중함은 그대로'),
  (null, 6, '자쿠II샤아전용.jpg', '3배 빠른 자쿠'),
  (null, 34, '자쿠II샤아전용sd.jpg', '귀엽고 3배 빠른 자쿠'),
  (null, 7, '돔.jpg', '튼튼한 돔'),
  (null, 35, '릭돔sd.jpg', '이거 릭돔이 아니고 돔이었구나'),
  (null, 8, '릭돔.jpg', '릭돔은 볼륨감이 좋아서 전체 샷이 멋진데'),
  (null, 9, '즈고크E.jpg', '카리스마 짱'),
  (null, 9, '즈고크E.jpg', '숨겨진 보물같은 킷'),
  (null, 10, '모빌씨그.jpg', '전설의 야수와 같은 모습'),
  (null, 11, '건너자쿠워리어.jpg', '독일군 헬멧'),
  (null, 36, '건너자쿠워리어sd.jpg', 'SD가 더 근엄한 듯'),
  (null, 36, '건너자쿠워리어sd2.jpg', 'SD지만 전투력이 높을 듯'),
  (null, 36, '건너자쿠워리어sd3.jpg', '의기 양양'),
  (null, 12, '건담5호기.jpg', '알록달록 이쁘다'),
  (null, 12, '건담5호기2.jpg', '기대하지 않았는데 만족도가 높았던 킷'),
  (null, 12, '건담5호기3.jpg', '얼굴도 알록달록'),
  (null, 12, '건담5호기4.jpg', '너무 멋져~'),
  (null, 13, '건담Mk-II에우고.jpg', '강렬한 눈빛'),
  (null, 13, '건담Mk-II에우고2.jpg', '헤드폰 착용샷'),
  (null, 37, '건담Mk-II티탄즈.jpg', 'SD에서 박력이 느껴져'),
  (null, 37, '건담Mk-II티탄즈2.jpg', '흔치 않은 컬러'),
  (null, 37, '건담Mk-II티탄즈미니.jpg', '이건 SD 아닌데'),
  (null, 14, '겔구그.jpg', '멧돼지'),
  (null, 15, '겔구그예거.jpg', '울퉁불퉁 멋진 킷'),
  (null, 15, '겔구그예거2.jpg', '전투력 높을 것 같아'),
  (null, 16, '고그.jpg', '해산물 3종 세트 중 하나. 너무 귀여워'),
  (null, 17, '네모.jpg', '만족도 엄청 높았던 킷. 또 하나의 숨겨진 보물'),
  (null, 18, '뉴건담sd.jpg', '인기 높은 뉴건담. 뉴건담이야 누 건담이야'),
  (null, 18, '뉴건담sd2.jpg', '체구에 비해 큰 백팩'),
  (null, 38, '뉴건담.jpg', '먹선을 너무 흐리게 넣었나'),
  (null, 19, '레전드건담.jpg', '무등급이지만 박력있는 백팩'),
  (null, 20, '릭디아스샤아전용.jpg', '사진빨 안받네'),
  (null, 21, '마라사이.jpg', '이 킷도 좋았음'),
  (null, 22, '베르데버스터건담.jpg', '그저 그런'),
  (null, 39, '베르데버스터건담sd.jpg', 'SD가 HGUC보다 박력있다'),
  (null, 23, '블레이즈자쿠팬텀.jpg', '무등급이지만 좋다'),
  (null, 40, '블레이즈자쿠팬텀sd.jpg', '먹선 안 넣어도 멋져'),
  (null, 40, '블레이즈자쿠팬텀sd2.jpg', '쌍도끼. 어쎄신 크리드 발할라 찍냐'),
  (null, 24, '스트라이크건담.jpg', '스트라이크 건담은 모든 등급이 다 잘 뽑힌듯'),
  (null, 24, '스트라이크건담2.jpg', '너무 가까워'),
  (null, 24, '스트라이크건담3.jpg', 'SD치고는 롱다리'),
  (null, 25, '아스트레이레드sd.jpg', 'SD 얼굴 귀여워'),
  (null, 41, '아스트레이레드.jpg', '독특한 근육 몸매. 가동률 좋음'),
  (null, 26, '알렉스.jpg', '주머니 속의 전쟁 주인공 기체'),
  (null, 26, '알렉스2.jpg', '개틀링 건도 장착 가능'),
  (null, 27, '주다.jpg', '개성 만점. 강추'),
  (null, 28, '캠퍼.jpg', '건담이 아닌 다른 애니메이션에 등장할 법한 특이한 외형이지만 좋다. 버니어 색분할 압권'),
  (null, 29, '파워드짐.jpg', '폭죽이라 놀리지 마라'),
  (null, 29, '파워드짐2.jpg', '심플한 매력'),
  (null, 30, '프리덤건담.jpg', '인기 많은 기체'),
  (null, 30, '프리덤건담2.jpg', 'MG의 화려함을 따라가기엔 부족'),
  (null, 30, '프리덤건담3.jpg', '인기 많은 기체 답게 뭐가 많이 달려있다');
 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍17분안에 읽기 (약 2599 단어)

Chap.13. Flask

CoLab

https://colab.research.google.com/drive/1NEqIJ54UndmGzv8FLNItcKv3s50TBn2R
https://bit.ly/2Y5xH7P

Github

https://github.com/devbwoh/flask-gunpladb

Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
DROP DATABASE IF EXISTS `gunpladb` ;

CREATE DATABASE IF NOT EXISTS `gunpladb` 
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

USE `gunpladb` ;

CREATE TABLE `mechanic` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `model` VARCHAR(100) NOT NULL,
  `manufacturer` VARCHAR(255) NULL,
  `armor` VARCHAR(255) NULL,
  `height` DECIMAL(7,2) NULL,
  `weight` DECIMAL(7,2) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `gunpla` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `mechanic_id` INT NOT NULL,
  `grade` VARCHAR(45) NOT NULL,
  `date` DATE NULL,
  `price` INT(11) NULL,
  `title` VARCHAR(255) NULL,
  `boxart` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`),
  INDEX (`mechanic_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `image` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `gunpla_id` INT NOT NULL,
  `filename` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX (`gunpla_id`),
  FOREIGN KEY (`gunpla_id`) REFERENCES `gunpla` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `armament` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `description` TEXT NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `equipment` (
  `mechanic_id` INT NOT NULL,
  `armaments_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `armaments_id`),
  INDEX (`armaments_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`armaments_id`) REFERENCES `armament` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `pilot` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NULL,
  `type` VARCHAR(100) NULL,
  `nationality` VARCHAR(100) NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `boarding` (
  `mechanic_id` INT NOT NULL,
  `pilot_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `pilot_id`),
  INDEX (`pilot_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`pilot_id`) REFERENCES `pilot` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;


###############################################

INSERT INTO mechanic (id, name, model, manufacturer, armor, height, weight) VALUES
  (1, '건담', 'RX-78-2', 'Earth Federation', 'Luna Titanium', 18.0, 43.4),
  (2, '건캐논', 'RX-77-2', 'Earth Federation', 'Luna Titanium', 17.5, 51.0),
  (3, '건탱크', 'RX-75', 'Earth Federation', 'Luna Titanium', 15.0, 56.0),
  (4, '짐', 'RGM-79', 'Earth Federation Forces', 'Titanium Alloy', 18.0, 41.2),
  (5, '자쿠 II', 'MS-06F', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 58.1),
  (6, '샤아 전용 자쿠 II', 'MS-06S', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 56.5),
  (7, '돔', 'MS-09B', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 62.6),
  (8, '릭 돔', 'MS-09R', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 43.8),
  (9, '즈고크 E', 'MSM-07E', 'MIP Company', 'Titanium Alloy Ceramic Composite', 18.4, 69.5),
  (10, '씨그', 'ZGMF-515', 'Zodiac Alliance of Freedom Treaty', null, 21.43, 80.22),
  (11, '거너 자쿠 워리어', 'ZGMF-1000/A1', 'Integrated Design Bureau', null, 20.50, 91.11),
  (12, '건담 5호기', 'RX-78-5', 'Earth Federation', 'Luna Titanium', 18.0, 42.9),
  (13, '건담 Mk-II', 'RX-178', 'Titans', 'Titanium Alloy Ceramic Composite', 18.5, 33.4),
  (14, '겔구그', 'MS-14A/C', 'Zeonic Company', 'Super Hard Steel Alloy', 19.2, 42.1),
  (15, '겔구그 예거', 'MS-14Jg', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 19.2, 40.5),
  (16, '고그', 'MSM-03', 'Zimmad Company', 'Super High Tensile Steel', 18.3, 82.4),
  (17, '네모', 'MSA-003', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (18, '뉴건담', 'RX-93', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (19, '레전드 건담', 'ZGMF-X666S', 'Zodiac Alliance of Freedom Treaty', 'Variable Phase Shift armor', 18.66, 86.02),
  (20, '릭디아스', 'RMS-099', 'Anaheim Electronics', 'Gundarium γ Alloy', 18.0, 32.2),
  (21, '마라사이', 'RMS-108', 'Anaheim Electronics', 'Gundarium Alloy', 17.5, 33.1),
  (22, '베르데 버스터 건담', 'GAT-X103AP', 'Actaeon Industries', 'Variable Phase Shift Armor', 18.46, 99.36),
  (23, '블레이즈 자쿠 팬텀', 'ZGMF-1001/M', 'Integrated Design Bureau', null, 20.4, 91.2),
  (24, '스트라이크 건담', 'GAT-X105', 'Earth Alliance', 'Phase Shift Armor', 17.72, 64.8),
  (25, '건담 아스트레이 레드 프레임', 'MBF-P02', 'Morgenroete, Inc.', 'Foaming metal', 17.53, 49.8),
  (26, '알렉스', 'RX-78NT-1', 'Earth Federation', 'Luna Titanium', 18.0, 40.0),
  (27, '주다', 'EMS-10', 'Zimmad Company', 'Hardened Steel', 17.3, 61.0),
  (28, '캠퍼', 'MS-18E', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 17.7, 43.5),
  (29, '파워드 짐', 'RGM-79', 'Earth Federation', 'Titanium Ceramic Composite', 18.0, 46.6),
  (30, '프리덤 건담', 'ZGMF-X10A', 'Integrated Design Bureau', 'Phase Shift Armor', 18.03, 71.5);
  
INSERT INTO gunpla (id, mechanic_id, grade, date, price, title, boxart) VALUES
  (1, 1, 'MG', '2005-03-01', 3200, 'RX-78-2 Gundam ver. O.Y.W 0079 (PS2 soft)', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78-2%20Gundam%7Cver.%20O.Y.W%200079%7C(PS2%20soft)'),
  (2, 2, 'SD', '2001-11-01', 500, 'Gun Cannon', 'http://ipsumimage.appspot.com/200x150,ffff3f?s=24&l=Gun%20Cannon'),
  (3, 3, 'SD', '2001-08-01', 500, 'Gun Tank', 'http://ipsumimage.appspot.com/200x150,ffff72?s=24&l=Gun%20Tank'),
  (4, 4, 'SD', '2001-04-01', 700, 'GM', 'http://ipsumimage.appspot.com/200x150,ffffd7?s=24&l=GM'),
  (5, 5, 'MG', '2002-09-01', 3000, 'MS-06F2	Zaku II F2 : EFSF 연방군형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06F2%7CZaku%20II%20F2%7CEFSF%20%EC%97%B0%EB%B0%A9%EA%B5%B0%ED%98%95'),
  (6, 6, 'RG', '2010-11-01', 2500, "MS-06S Char's Zaku II", 'http://ipsumimage.appspot.com/200x150,7f7fff?s=24&l=MS-06S%7CChar%27s%20Zaku%20II'),
  (7, 7, 'HGUC', '2006-01-01', 1700, 'MS-09/MS-09R Dom/Rick-Dom', 'http://ipsumimage.appspot.com/200x150,9f7fd2?s=24&l=MS-09%7CMS-09R%20Dom%7CRick-Dom'),
  (8, 8, 'MG', '1999-10-01', 4000, 'MS-09R Rick-Dom', 'http://ipsumimage.appspot.com/200x150,ff7fd2?s=24&l=MS-09R%7CRick-Dom'),
  (9, 9, 'HGUC', '2003-08-01', 1200, "MSM-07E Z'gok Experiment", 'http://ipsumimage.appspot.com/200x150,6f7fff?s=24&l=MSM-07E%7CZ%27gok%20Experiment'),
  (10, 10, 'SEED HG', '2004-04-01', 1200, 'ZGMF-515 Mobile Cgue', 'http://ipsumimage.appspot.com/200x150,afafaf?s=24&l=ZGMF-515%7CMobile%20Cgue'),   
  (11, 11, 'SEED 1/100', '2005-03-01', 2300, 'ZGMF-1000/A1 Gunner Zaku Warrior - 루나마리아 전용', 'http://ipsumimage.appspot.com/200x150,ff4f4f?s=24&l=ZGMF-1000/A1%7CGunner%20Zaku%7CWarrior%7C%EB%A3%A8%EB%82%98%EB%A7%88%EB%A6%AC%EC%95%84%7C%EC%A0%84%EC%9A%A9'),   
  (12, 12, 'MG', '2003-08-01', 2800, 'RX-78-5 Gundam 5호기', 'http://ipsumimage.appspot.com/200x150,ffff4f?s=24&l=RX-78-5%7CGundam%205%ED%98%B8%EA%B8%B0'),  
  (13, 13, 'MG', '2005-10-01', 4000, 'RX-178 Gundam Mk-II v2.0', 'http://ipsumimage.appspot.com/200x150,8f8fff?s=24&l=RX-178%7CGundam%20Mk-II%7Cv2.0'),  
  (14, 14, 'HGUC', '2007-03-01', 1600, 'MS-14A/C Gelgoog/Gelgoog Cannon', 'http://ipsumimage.appspot.com/200x150,8f8f2f?s=24&l=MS-14A/C%7CGelgoog/%7CGelgoog%20Cannon'),  
  (15, 15, 'HGUC', '2004-04-01', 1200, 'MS-14JG	Gelgoog J', 'http://ipsumimage.appspot.com/200x150,ff8f2f?s=24&l=MS-14JG%7CGelgoog%20J'),
  (16, 16, 'SD', '2000-02-01', 500, 'Gogg/Acguy/Zock', 'http://ipsumimage.appspot.com/200x150,8f7fff?s=24&l=Gogg%7CAcguy%7CZock'),
  (17, 17, 'MG', '2006-02-01', 2800, 'MSA-003 Nemo', 'http://ipsumimage.appspot.com/200x150,7fff8f?s=24&l=MSA-003%20Nemo'),
  (18, 18, 'SD', '2000-08-01', 500, 'Nu Gundam', 'http://ipsumimage.appspot.com/200x150,ffffaf?s=24&l=Nu%20Gundam'),
  (19, 19, 'SEED 1/100', '2006-06-01', 2600, 'ZGMF-X666S Legend Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfef?s=24&l=ZGMF-X666S%7CLegend%20Gundam'),
  (20, 20, 'HGUC', '2002-08-01', 1200, 'RMS-099 Rick Dias - 샤아전용', 'http://ipsumimage.appspot.com/200x150,df2f3f?s=24&l=RMS-099%7CRick%20Dias%20%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (21, 21, 'HGUC', '2005-01-01', 1400, 'RMS-108 Marasai', 'http://ipsumimage.appspot.com/200x150,ff5f5f?s=24&l=RMS-108%7CMarasai'),
  (22, 22, 'SEED HG', '2006-08-01', 1600, 'GAT-X103AP Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fffaf?s=24&l=GAT-X103AP%7CVerde%20Buster%7CGundam'),
  (23, 23, 'SEED 1/100', '2005-06-01', 2600, 'ZGMF-1001/M Blaze Zaku Phantom - 하이네 전용기', 'http://ipsumimage.appspot.com/200x150,dfdf3f?s=24&l=%7CZGMF-1001/M%7CBlaze%20Zaku%7CPhantom%7C%ED%95%98%EC%9D%B4%EB%84%A4%20%EC%A0%84%EC%9A%A9%EA%B8%B0'),
  (24, 24, 'SD', '2003-02-01', 500, 'Strike Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=Strike%20Gundam'),
  (25, 25, 'SD', '2003-04-01', 500, 'Gundam Astray - Red Frame', 'http://ipsumimage.appspot.com/200x150,df6f4f?s=24&l=Gundam%20Astray%7CRed%20Frame'),
  (26, 26, 'SD', '2004-11-01', 500, 'Gundam NT-1', 'http://ipsumimage.appspot.com/200x150,4f4fdf?s=24&l=Gundam%20NT-1'),
  (27, 27, 'HGUC', '2006-06-01', 1400, 'EMS-10 Zudah', 'http://ipsumimage.appspot.com/200x150,bfbfef?s=24&l=EMS-10%7CZudah'),
  (28, 28, 'MG', '2001-01-01', 4000, 'MS-18E Kämpfer', 'http://ipsumimage.appspot.com/200x150,3f3fef?s=24&l=EMS-18E%7CK%C3%A4mpfer'),
  (29, 29, 'HGUC', '2006-08-01', 1200, 'RGM-79 Powered GM', 'http://ipsumimage.appspot.com/200x150,ff8f4f?s=24&l=RGM-79%7CPowered%20GM'),
  (30, 30, 'SD', '2003-11-01', 500, 'Freedom Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfff?s=24&l=Freedom%20Gundam'),
  
  (31, 1, 'SD', '1999-10-01', 500, 'RX-78 Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78%7CGundam'),
  (32, 5, 'HGUC', '2003-09-01', 1000, 'MS-06 Zaku II - 양산형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06%7CZaku%20II%7C%EC%96%91%EC%82%B0%ED%98%95g'),
  (33, 5, 'SD', '2001-07-01', 500, 'MS-06F Zaku II', 'http://ipsumimage.appspot.com/200x150,2fff2f?s=24&l=MS-06F%7CZaku%20II'),
  (34, 6, 'SD', '2002-03-01', 500, 'MS-06S Zaku II 샤아전용', 'http://ipsumimage.appspot.com/200x150,ff2f2f?s=24&l=%7CMS-06S%7CZaku%20II%7C%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (35, 7, 'SD', '2000-05-01', 400, 'Dom', 'http://ipsumimage.appspot.com/200x150,3f3f3f?s=24&l=Dom'),
  (36, 11, 'SD', '2005-07-01', 600, 'Gunner Zaku Warrior', 'http://ipsumimage.appspot.com/200x150,ff3f3f?s=24&l=Gunner%20Zaku%7CWarrior'),
  (37, 13, 'SD', '2001-06-01', 500, 'Gundam Mk-II Titans', 'http://ipsumimage.appspot.com/200x150,3f3fff?s=24&l=Gundam%20Mk-II%7CTitans'),
  (38, 18, 'HGUC', '2008-03-01', 2500, 'RX-93 υ Gundam', 'http://ipsumimage.appspot.com/200x150,dfdf33?s=24&l=RX-93%7C%CF%85%20Gundam'),
  (39, 22, 'SD', '2007-04-01', 600, 'Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fff6f?s=24&l=Verde%20Buster%7CGundam'),
  (40, 23, 'SD', '2007-07-01', 600, 'Blaze Zaku Phantom (Heine Custom)', 'http://ipsumimage.appspot.com/200x150,ffff2f?s=24&l=Blaze%20Zaku%7CPhantom%7C(Heine%20Custom)'),
  (41, 25, 'SEED HG', '2003-11-01', 1200, 'MBF-P02 Gundam Astray Red Frame', 'http://ipsumimage.appspot.com/200x150,ff4f2f?s=24&l=MBF-P02%7CGundam%20Astray%7CRed%20Frame');
  
  
INSERT INTO image (id, gunpla_id, filename, description) VALUES
  (null, 1, 'gundam.png', '세로로 긴 이미지'),
  (null, 31, '건담.jpg', '귀여운 SD'),
  (null, 1, '건담mg.jpg', '파스텔 톤 좋아'),
  (null, 1, '건담mg2.jpg', '옆 모습도 멋지군'),
  (null, 1, '건담mg3.jpg', '멋있는 MG'),
  (null, 1, '건담mg4.jpg', 'mg3 파일을 세로로 길게 crop'),
  (null, 2, '건캐논.jpg', 'SD의 위용'),
  (null, 2, '건캐논2.jpg', '앙증맞은 SD'),
  (null, 3, '건탱크.jpg', 'SD에 투명 파츠까지'),
  (null, 3, '건탱크2.jpg', 'SD 위화감이 없어'),
  (null, 4, '짐mini.jpg', '어 이거 SD 아닌데'),
  (null, 5, '자쿠IImg.jpg', '육중한 위압감'),
  (null, 5, '자쿠IImg2.jpg', '구 버전이라도 멋지다'),
  (null, 5, '자쿠IImg3.jpg', '역시 모노아이'),
  (null, 32, '자쿠II.jpg', 'HGUC 자쿠II'),
  (null, 33, '자쿠IIsd.jpg', 'SD지만 육중함은 그대로'),
  (null, 6, '자쿠II샤아전용.jpg', '3배 빠른 자쿠'),
  (null, 34, '자쿠II샤아전용sd.jpg', '귀엽고 3배 빠른 자쿠'),
  (null, 7, '돔.jpg', '튼튼한 돔'),
  (null, 35, '릭돔sd.jpg', '이거 릭돔이 아니고 돔이었구나'),
  (null, 8, '릭돔.jpg', '릭돔은 볼륨감이 좋아서 전체 샷이 멋진데'),
  (null, 9, '즈고크E.jpg', '카리스마 짱'),
  (null, 9, '즈고크E.jpg', '숨겨진 보물같은 킷'),
  (null, 10, '모빌씨그.jpg', '전설의 야수와 같은 모습'),
  (null, 11, '건너자쿠워리어.jpg', '독일군 헬멧'),
  (null, 36, '건너자쿠워리어sd.jpg', 'SD가 더 근엄한 듯'),
  (null, 36, '건너자쿠워리어sd2.jpg', 'SD지만 전투력이 높을 듯'),
  (null, 36, '건너자쿠워리어sd3.jpg', '의기 양양'),
  (null, 12, '건담5호기.jpg', '알록달록 이쁘다'),
  (null, 12, '건담5호기2.jpg', '기대하지 않았는데 만족도가 높았던 킷'),
  (null, 12, '건담5호기3.jpg', '얼굴도 알록달록'),
  (null, 12, '건담5호기4.jpg', '너무 멋져~'),
  (null, 13, '건담Mk-II에우고.jpg', '강렬한 눈빛'),
  (null, 13, '건담Mk-II에우고2.jpg', '헤드폰 착용샷'),
  (null, 37, '건담Mk-II티탄즈.jpg', 'SD에서 박력이 느껴져'),
  (null, 37, '건담Mk-II티탄즈2.jpg', '흔치 않은 컬러'),
  (null, 37, '건담Mk-II티탄즈미니.jpg', '이건 SD 아닌데'),
  (null, 14, '겔구그.jpg', '멧돼지'),
  (null, 15, '겔구그예거.jpg', '울퉁불퉁 멋진 킷'),
  (null, 15, '겔구그예거2.jpg', '전투력 높을 것 같아'),
  (null, 16, '고그.jpg', '해산물 3종 세트 중 하나. 너무 귀여워'),
  (null, 17, '네모.jpg', '만족도 엄청 높았던 킷. 또 하나의 숨겨진 보물'),
  (null, 18, '뉴건담sd.jpg', '인기 높은 뉴건담. 뉴건담이야 누 건담이야'),
  (null, 18, '뉴건담sd2.jpg', '체구에 비해 큰 백팩'),
  (null, 38, '뉴건담.jpg', '먹선을 너무 흐리게 넣었나'),
  (null, 19, '레전드건담.jpg', '무등급이지만 박력있는 백팩'),
  (null, 20, '릭디아스샤아전용.jpg', '사진빨 안받네'),
  (null, 21, '마라사이.jpg', '이 킷도 좋았음'),
  (null, 22, '베르데버스터건담.jpg', '그저 그런'),
  (null, 39, '베르데버스터건담sd.jpg', 'SD가 HGUC보다 박력있다'),
  (null, 23, '블레이즈자쿠팬텀.jpg', '무등급이지만 좋다'),
  (null, 40, '블레이즈자쿠팬텀sd.jpg', '먹선 안 넣어도 멋져'),
  (null, 40, '블레이즈자쿠팬텀sd2.jpg', '쌍도끼. 어쎄신 크리드 발할라 찍냐'),
  (null, 24, '스트라이크건담.jpg', '스트라이크 건담은 모든 등급이 다 잘 뽑힌듯'),
  (null, 24, '스트라이크건담2.jpg', '너무 가까워'),
  (null, 24, '스트라이크건담3.jpg', 'SD치고는 롱다리'),
  (null, 25, '아스트레이레드sd.jpg', 'SD 얼굴 귀여워'),
  (null, 41, '아스트레이레드.jpg', '독특한 근육 몸매. 가동률 좋음'),
  (null, 26, '알렉스.jpg', '주머니 속의 전쟁 주인공 기체'),
  (null, 26, '알렉스2.jpg', '개틀링 건도 장착 가능'),
  (null, 27, '주다.jpg', '개성 만점. 강추'),
  (null, 28, '캠퍼.jpg', '건담이 아닌 다른 애니메이션에 등장할 법한 특이한 외형이지만 좋다. 버니어 색분할 압권'),
  (null, 29, '파워드짐.jpg', '폭죽이라 놀리지 마라'),
  (null, 29, '파워드짐2.jpg', '심플한 매력'),
  (null, 30, '프리덤건담.jpg', '인기 많은 기체'),
  (null, 30, '프리덤건담2.jpg', 'MG의 화려함을 따라가기엔 부족'),
  (null, 30, '프리덤건담3.jpg', '인기 많은 기체 답게 뭐가 많이 달려있다');
 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍17분안에 읽기 (약 2596 단어)

Chap.14. jQuery

CoLab

https://colab.research.google.com/drive/1bVuGWCuYRNDelfft4wfKo2lFiPIctw_m

https://bit.ly/3o9FUCF

Github

https://github.com/devbwoh/jquery-gunpladb

Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
DROP DATABASE IF EXISTS `gunpladb` ;

CREATE DATABASE IF NOT EXISTS `gunpladb` 
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

USE `gunpladb` ;

CREATE TABLE `mechanic` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `model` VARCHAR(100) NOT NULL,
  `manufacturer` VARCHAR(255) NULL,
  `armor` VARCHAR(255) NULL,
  `height` DECIMAL(7,2) NULL,
  `weight` DECIMAL(7,2) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `gunpla` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `mechanic_id` INT NOT NULL,
  `grade` VARCHAR(45) NOT NULL,
  `date` DATE NULL,
  `price` INT(11) NULL,
  `title` VARCHAR(255) NULL,
  `boxart` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`),
  INDEX (`mechanic_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `image` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `gunpla_id` INT NOT NULL,
  `filename` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX (`gunpla_id`),
  FOREIGN KEY (`gunpla_id`) REFERENCES `gunpla` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `armament` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `description` TEXT NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `equipment` (
  `mechanic_id` INT NOT NULL,
  `armaments_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `armaments_id`),
  INDEX (`armaments_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`armaments_id`) REFERENCES `armament` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `pilot` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NULL,
  `type` VARCHAR(100) NULL,
  `nationality` VARCHAR(100) NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `boarding` (
  `mechanic_id` INT NOT NULL,
  `pilot_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `pilot_id`),
  INDEX (`pilot_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`pilot_id`) REFERENCES `pilot` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;


###############################################

INSERT INTO mechanic (id, name, model, manufacturer, armor, height, weight) VALUES
  (1, '건담', 'RX-78-2', 'Earth Federation', 'Luna Titanium', 18.0, 43.4),
  (2, '건캐논', 'RX-77-2', 'Earth Federation', 'Luna Titanium', 17.5, 51.0),
  (3, '건탱크', 'RX-75', 'Earth Federation', 'Luna Titanium', 15.0, 56.0),
  (4, '짐', 'RGM-79', 'Earth Federation Forces', 'Titanium Alloy', 18.0, 41.2),
  (5, '자쿠 II', 'MS-06F', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 58.1),
  (6, '샤아 전용 자쿠 II', 'MS-06S', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 56.5),
  (7, '돔', 'MS-09B', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 62.6),
  (8, '릭 돔', 'MS-09R', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 43.8),
  (9, '즈고크 E', 'MSM-07E', 'MIP Company', 'Titanium Alloy Ceramic Composite', 18.4, 69.5),
  (10, '씨그', 'ZGMF-515', 'Zodiac Alliance of Freedom Treaty', null, 21.43, 80.22),
  (11, '거너 자쿠 워리어', 'ZGMF-1000/A1', 'Integrated Design Bureau', null, 20.50, 91.11),
  (12, '건담 5호기', 'RX-78-5', 'Earth Federation', 'Luna Titanium', 18.0, 42.9),
  (13, '건담 Mk-II', 'RX-178', 'Titans', 'Titanium Alloy Ceramic Composite', 18.5, 33.4),
  (14, '겔구그', 'MS-14A/C', 'Zeonic Company', 'Super Hard Steel Alloy', 19.2, 42.1),
  (15, '겔구그 예거', 'MS-14Jg', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 19.2, 40.5),
  (16, '고그', 'MSM-03', 'Zimmad Company', 'Super High Tensile Steel', 18.3, 82.4),
  (17, '네모', 'MSA-003', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (18, '뉴건담', 'RX-93', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (19, '레전드 건담', 'ZGMF-X666S', 'Zodiac Alliance of Freedom Treaty', 'Variable Phase Shift armor', 18.66, 86.02),
  (20, '릭디아스', 'RMS-099', 'Anaheim Electronics', 'Gundarium γ Alloy', 18.0, 32.2),
  (21, '마라사이', 'RMS-108', 'Anaheim Electronics', 'Gundarium Alloy', 17.5, 33.1),
  (22, '베르데 버스터 건담', 'GAT-X103AP', 'Actaeon Industries', 'Variable Phase Shift Armor', 18.46, 99.36),
  (23, '블레이즈 자쿠 팬텀', 'ZGMF-1001/M', 'Integrated Design Bureau', null, 20.4, 91.2),
  (24, '스트라이크 건담', 'GAT-X105', 'Earth Alliance', 'Phase Shift Armor', 17.72, 64.8),
  (25, '건담 아스트레이 레드 프레임', 'MBF-P02', 'Morgenroete, Inc.', 'Foaming metal', 17.53, 49.8),
  (26, '알렉스', 'RX-78NT-1', 'Earth Federation', 'Luna Titanium', 18.0, 40.0),
  (27, '주다', 'EMS-10', 'Zimmad Company', 'Hardened Steel', 17.3, 61.0),
  (28, '캠퍼', 'MS-18E', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 17.7, 43.5),
  (29, '파워드 짐', 'RGM-79', 'Earth Federation', 'Titanium Ceramic Composite', 18.0, 46.6),
  (30, '프리덤 건담', 'ZGMF-X10A', 'Integrated Design Bureau', 'Phase Shift Armor', 18.03, 71.5);
  
INSERT INTO gunpla (id, mechanic_id, grade, date, price, title, boxart) VALUES
  (1, 1, 'MG', '2005-03-01', 3200, 'RX-78-2 Gundam ver. O.Y.W 0079 (PS2 soft)', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78-2%20Gundam%7Cver.%20O.Y.W%200079%7C(PS2%20soft)'),
  (2, 2, 'SD', '2001-11-01', 500, 'Gun Cannon', 'http://ipsumimage.appspot.com/200x150,ffff3f?s=24&l=Gun%20Cannon'),
  (3, 3, 'SD', '2001-08-01', 500, 'Gun Tank', 'http://ipsumimage.appspot.com/200x150,ffff72?s=24&l=Gun%20Tank'),
  (4, 4, 'SD', '2001-04-01', 700, 'GM', 'http://ipsumimage.appspot.com/200x150,ffffd7?s=24&l=GM'),
  (5, 5, 'MG', '2002-09-01', 3000, 'MS-06F2	Zaku II F2 : EFSF 연방군형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06F2%7CZaku%20II%20F2%7CEFSF%20%EC%97%B0%EB%B0%A9%EA%B5%B0%ED%98%95'),
  (6, 6, 'RG', '2010-11-01', 2500, "MS-06S Char's Zaku II", 'http://ipsumimage.appspot.com/200x150,7f7fff?s=24&l=MS-06S%7CChar%27s%20Zaku%20II'),
  (7, 7, 'HGUC', '2006-01-01', 1700, 'MS-09/MS-09R Dom/Rick-Dom', 'http://ipsumimage.appspot.com/200x150,9f7fd2?s=24&l=MS-09%7CMS-09R%20Dom%7CRick-Dom'),
  (8, 8, 'MG', '1999-10-01', 4000, 'MS-09R Rick-Dom', 'http://ipsumimage.appspot.com/200x150,ff7fd2?s=24&l=MS-09R%7CRick-Dom'),
  (9, 9, 'HGUC', '2003-08-01', 1200, "MSM-07E Z'gok Experiment", 'http://ipsumimage.appspot.com/200x150,6f7fff?s=24&l=MSM-07E%7CZ%27gok%20Experiment'),
  (10, 10, 'SEED HG', '2004-04-01', 1200, 'ZGMF-515 Mobile Cgue', 'http://ipsumimage.appspot.com/200x150,afafaf?s=24&l=ZGMF-515%7CMobile%20Cgue'),   
  (11, 11, 'SEED 1/100', '2005-03-01', 2300, 'ZGMF-1000/A1 Gunner Zaku Warrior - 루나마리아 전용', 'http://ipsumimage.appspot.com/200x150,ff4f4f?s=24&l=ZGMF-1000/A1%7CGunner%20Zaku%7CWarrior%7C%EB%A3%A8%EB%82%98%EB%A7%88%EB%A6%AC%EC%95%84%7C%EC%A0%84%EC%9A%A9'),   
  (12, 12, 'MG', '2003-08-01', 2800, 'RX-78-5 Gundam 5호기', 'http://ipsumimage.appspot.com/200x150,ffff4f?s=24&l=RX-78-5%7CGundam%205%ED%98%B8%EA%B8%B0'),  
  (13, 13, 'MG', '2005-10-01', 4000, 'RX-178 Gundam Mk-II v2.0', 'http://ipsumimage.appspot.com/200x150,8f8fff?s=24&l=RX-178%7CGundam%20Mk-II%7Cv2.0'),  
  (14, 14, 'HGUC', '2007-03-01', 1600, 'MS-14A/C Gelgoog/Gelgoog Cannon', 'http://ipsumimage.appspot.com/200x150,8f8f2f?s=24&l=MS-14A/C%7CGelgoog/%7CGelgoog%20Cannon'),  
  (15, 15, 'HGUC', '2004-04-01', 1200, 'MS-14JG	Gelgoog J', 'http://ipsumimage.appspot.com/200x150,ff8f2f?s=24&l=MS-14JG%7CGelgoog%20J'),
  (16, 16, 'SD', '2000-02-01', 500, 'Gogg/Acguy/Zock', 'http://ipsumimage.appspot.com/200x150,8f7fff?s=24&l=Gogg%7CAcguy%7CZock'),
  (17, 17, 'MG', '2006-02-01', 2800, 'MSA-003 Nemo', 'http://ipsumimage.appspot.com/200x150,7fff8f?s=24&l=MSA-003%20Nemo'),
  (18, 18, 'SD', '2000-08-01', 500, 'Nu Gundam', 'http://ipsumimage.appspot.com/200x150,ffffaf?s=24&l=Nu%20Gundam'),
  (19, 19, 'SEED 1/100', '2006-06-01', 2600, 'ZGMF-X666S Legend Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfef?s=24&l=ZGMF-X666S%7CLegend%20Gundam'),
  (20, 20, 'HGUC', '2002-08-01', 1200, 'RMS-099 Rick Dias - 샤아전용', 'http://ipsumimage.appspot.com/200x150,df2f3f?s=24&l=RMS-099%7CRick%20Dias%20%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (21, 21, 'HGUC', '2005-01-01', 1400, 'RMS-108 Marasai', 'http://ipsumimage.appspot.com/200x150,ff5f5f?s=24&l=RMS-108%7CMarasai'),
  (22, 22, 'SEED HG', '2006-08-01', 1600, 'GAT-X103AP Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fffaf?s=24&l=GAT-X103AP%7CVerde%20Buster%7CGundam'),
  (23, 23, 'SEED 1/100', '2005-06-01', 2600, 'ZGMF-1001/M Blaze Zaku Phantom - 하이네 전용기', 'http://ipsumimage.appspot.com/200x150,dfdf3f?s=24&l=%7CZGMF-1001/M%7CBlaze%20Zaku%7CPhantom%7C%ED%95%98%EC%9D%B4%EB%84%A4%20%EC%A0%84%EC%9A%A9%EA%B8%B0'),
  (24, 24, 'SD', '2003-02-01', 500, 'Strike Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=Strike%20Gundam'),
  (25, 25, 'SD', '2003-04-01', 500, 'Gundam Astray - Red Frame', 'http://ipsumimage.appspot.com/200x150,df6f4f?s=24&l=Gundam%20Astray%7CRed%20Frame'),
  (26, 26, 'SD', '2004-11-01', 500, 'Gundam NT-1', 'http://ipsumimage.appspot.com/200x150,4f4fdf?s=24&l=Gundam%20NT-1'),
  (27, 27, 'HGUC', '2006-06-01', 1400, 'EMS-10 Zudah', 'http://ipsumimage.appspot.com/200x150,bfbfef?s=24&l=EMS-10%7CZudah'),
  (28, 28, 'MG', '2001-01-01', 4000, 'MS-18E Kämpfer', 'http://ipsumimage.appspot.com/200x150,3f3fef?s=24&l=EMS-18E%7CK%C3%A4mpfer'),
  (29, 29, 'HGUC', '2006-08-01', 1200, 'RGM-79 Powered GM', 'http://ipsumimage.appspot.com/200x150,ff8f4f?s=24&l=RGM-79%7CPowered%20GM'),
  (30, 30, 'SD', '2003-11-01', 500, 'Freedom Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfff?s=24&l=Freedom%20Gundam'),
  
  (31, 1, 'SD', '1999-10-01', 500, 'RX-78 Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78%7CGundam'),
  (32, 5, 'HGUC', '2003-09-01', 1000, 'MS-06 Zaku II - 양산형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06%7CZaku%20II%7C%EC%96%91%EC%82%B0%ED%98%95g'),
  (33, 5, 'SD', '2001-07-01', 500, 'MS-06F Zaku II', 'http://ipsumimage.appspot.com/200x150,2fff2f?s=24&l=MS-06F%7CZaku%20II'),
  (34, 6, 'SD', '2002-03-01', 500, 'MS-06S Zaku II 샤아전용', 'http://ipsumimage.appspot.com/200x150,ff2f2f?s=24&l=%7CMS-06S%7CZaku%20II%7C%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (35, 7, 'SD', '2000-05-01', 400, 'Dom', 'http://ipsumimage.appspot.com/200x150,3f3f3f?s=24&l=Dom'),
  (36, 11, 'SD', '2005-07-01', 600, 'Gunner Zaku Warrior', 'http://ipsumimage.appspot.com/200x150,ff3f3f?s=24&l=Gunner%20Zaku%7CWarrior'),
  (37, 13, 'SD', '2001-06-01', 500, 'Gundam Mk-II Titans', 'http://ipsumimage.appspot.com/200x150,3f3fff?s=24&l=Gundam%20Mk-II%7CTitans'),
  (38, 18, 'HGUC', '2008-03-01', 2500, 'RX-93 υ Gundam', 'http://ipsumimage.appspot.com/200x150,dfdf33?s=24&l=RX-93%7C%CF%85%20Gundam'),
  (39, 22, 'SD', '2007-04-01', 600, 'Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fff6f?s=24&l=Verde%20Buster%7CGundam'),
  (40, 23, 'SD', '2007-07-01', 600, 'Blaze Zaku Phantom (Heine Custom)', 'http://ipsumimage.appspot.com/200x150,ffff2f?s=24&l=Blaze%20Zaku%7CPhantom%7C(Heine%20Custom)'),
  (41, 25, 'SEED HG', '2003-11-01', 1200, 'MBF-P02 Gundam Astray Red Frame', 'http://ipsumimage.appspot.com/200x150,ff4f2f?s=24&l=MBF-P02%7CGundam%20Astray%7CRed%20Frame');
  
  
INSERT INTO image (id, gunpla_id, filename, description) VALUES
  (null, 1, 'gundam.png', '세로로 긴 이미지'),
  (null, 31, '건담.jpg', '귀여운 SD'),
  (null, 1, '건담mg.jpg', '파스텔 톤 좋아'),
  (null, 1, '건담mg2.jpg', '옆 모습도 멋지군'),
  (null, 1, '건담mg3.jpg', '멋있는 MG'),
  (null, 1, '건담mg4.jpg', 'mg3 파일을 세로로 길게 crop'),
  (null, 2, '건캐논.jpg', 'SD의 위용'),
  (null, 2, '건캐논2.jpg', '앙증맞은 SD'),
  (null, 3, '건탱크.jpg', 'SD에 투명 파츠까지'),
  (null, 3, '건탱크2.jpg', 'SD 위화감이 없어'),
  (null, 4, '짐mini.jpg', '어 이거 SD 아닌데'),
  (null, 5, '자쿠IImg.jpg', '육중한 위압감'),
  (null, 5, '자쿠IImg2.jpg', '구 버전이라도 멋지다'),
  (null, 5, '자쿠IImg3.jpg', '역시 모노아이'),
  (null, 32, '자쿠II.jpg', 'HGUC 자쿠II'),
  (null, 33, '자쿠IIsd.jpg', 'SD지만 육중함은 그대로'),
  (null, 6, '자쿠II샤아전용.jpg', '3배 빠른 자쿠'),
  (null, 34, '자쿠II샤아전용sd.jpg', '귀엽고 3배 빠른 자쿠'),
  (null, 7, '돔.jpg', '튼튼한 돔'),
  (null, 35, '릭돔sd.jpg', '이거 릭돔이 아니고 돔이었구나'),
  (null, 8, '릭돔.jpg', '릭돔은 볼륨감이 좋아서 전체 샷이 멋진데'),
  (null, 9, '즈고크E.jpg', '카리스마 짱'),
  (null, 9, '즈고크E.jpg', '숨겨진 보물같은 킷'),
  (null, 10, '모빌씨그.jpg', '전설의 야수와 같은 모습'),
  (null, 11, '건너자쿠워리어.jpg', '독일군 헬멧'),
  (null, 36, '건너자쿠워리어sd.jpg', 'SD가 더 근엄한 듯'),
  (null, 36, '건너자쿠워리어sd2.jpg', 'SD지만 전투력이 높을 듯'),
  (null, 36, '건너자쿠워리어sd3.jpg', '의기 양양'),
  (null, 12, '건담5호기.jpg', '알록달록 이쁘다'),
  (null, 12, '건담5호기2.jpg', '기대하지 않았는데 만족도가 높았던 킷'),
  (null, 12, '건담5호기3.jpg', '얼굴도 알록달록'),
  (null, 12, '건담5호기4.jpg', '너무 멋져~'),
  (null, 13, '건담Mk-II에우고.jpg', '강렬한 눈빛'),
  (null, 13, '건담Mk-II에우고2.jpg', '헤드폰 착용샷'),
  (null, 37, '건담Mk-II티탄즈.jpg', 'SD에서 박력이 느껴져'),
  (null, 37, '건담Mk-II티탄즈2.jpg', '흔치 않은 컬러'),
  (null, 37, '건담Mk-II티탄즈미니.jpg', '이건 SD 아닌데'),
  (null, 14, '겔구그.jpg', '멧돼지'),
  (null, 15, '겔구그예거.jpg', '울퉁불퉁 멋진 킷'),
  (null, 15, '겔구그예거2.jpg', '전투력 높을 것 같아'),
  (null, 16, '고그.jpg', '해산물 3종 세트 중 하나. 너무 귀여워'),
  (null, 17, '네모.jpg', '만족도 엄청 높았던 킷. 또 하나의 숨겨진 보물'),
  (null, 18, '뉴건담sd.jpg', '인기 높은 뉴건담. 뉴건담이야 누 건담이야'),
  (null, 18, '뉴건담sd2.jpg', '체구에 비해 큰 백팩'),
  (null, 38, '뉴건담.jpg', '먹선을 너무 흐리게 넣었나'),
  (null, 19, '레전드건담.jpg', '무등급이지만 박력있는 백팩'),
  (null, 20, '릭디아스샤아전용.jpg', '사진빨 안받네'),
  (null, 21, '마라사이.jpg', '이 킷도 좋았음'),
  (null, 22, '베르데버스터건담.jpg', '그저 그런'),
  (null, 39, '베르데버스터건담sd.jpg', 'SD가 HGUC보다 박력있다'),
  (null, 23, '블레이즈자쿠팬텀.jpg', '무등급이지만 좋다'),
  (null, 40, '블레이즈자쿠팬텀sd.jpg', '먹선 안 넣어도 멋져'),
  (null, 40, '블레이즈자쿠팬텀sd2.jpg', '쌍도끼. 어쎄신 크리드 발할라 찍냐'),
  (null, 24, '스트라이크건담.jpg', '스트라이크 건담은 모든 등급이 다 잘 뽑힌듯'),
  (null, 24, '스트라이크건담2.jpg', '너무 가까워'),
  (null, 24, '스트라이크건담3.jpg', 'SD치고는 롱다리'),
  (null, 25, '아스트레이레드sd.jpg', 'SD 얼굴 귀여워'),
  (null, 41, '아스트레이레드.jpg', '독특한 근육 몸매. 가동률 좋음'),
  (null, 26, '알렉스.jpg', '주머니 속의 전쟁 주인공 기체'),
  (null, 26, '알렉스2.jpg', '개틀링 건도 장착 가능'),
  (null, 27, '주다.jpg', '개성 만점. 강추'),
  (null, 28, '캠퍼.jpg', '건담이 아닌 다른 애니메이션에 등장할 법한 특이한 외형이지만 좋다. 버니어 색분할 압권'),
  (null, 29, '파워드짐.jpg', '폭죽이라 놀리지 마라'),
  (null, 29, '파워드짐2.jpg', '심플한 매력'),
  (null, 30, '프리덤건담.jpg', '인기 많은 기체'),
  (null, 30, '프리덤건담2.jpg', 'MG의 화려함을 따라가기엔 부족'),
  (null, 30, '프리덤건담3.jpg', '인기 많은 기체 답게 뭐가 많이 달려있다');
 게시 됨 업데이트 됨Database / 동영상 강의 / 데이터베이스 예제 프로그래밍17분안에 읽기 (약 2594 단어)

Chap.15. React

CoLab

https://colab.research.google.com/drive/172jCC2oPaz9a7w7_kUbK_sqiZFp6KNdh

Github

https://github.com/devbwoh/react-gunpladb

Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
DROP DATABASE IF EXISTS `gunpladb` ;

CREATE DATABASE IF NOT EXISTS `gunpladb` 
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

USE `gunpladb` ;

CREATE TABLE `mechanic` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `model` VARCHAR(100) NOT NULL,
  `manufacturer` VARCHAR(255) NULL,
  `armor` VARCHAR(255) NULL,
  `height` DECIMAL(7,2) NULL,
  `weight` DECIMAL(7,2) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `gunpla` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `mechanic_id` INT NOT NULL,
  `grade` VARCHAR(45) NOT NULL,
  `date` DATE NULL,
  `price` INT(11) NULL,
  `title` VARCHAR(255) NULL,
  `boxart` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`),
  INDEX (`mechanic_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `image` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `gunpla_id` INT NOT NULL,
  `filename` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX (`gunpla_id`),
  FOREIGN KEY (`gunpla_id`) REFERENCES `gunpla` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `armament` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `description` TEXT NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `equipment` (
  `mechanic_id` INT NOT NULL,
  `armaments_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `armaments_id`),
  INDEX (`armaments_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`armaments_id`) REFERENCES `armament` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `pilot` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NULL,
  `type` VARCHAR(100) NULL,
  `nationality` VARCHAR(100) NULL,
  `image` VARCHAR(2083) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `boarding` (
  `mechanic_id` INT NOT NULL,
  `pilot_id` INT NOT NULL,
  PRIMARY KEY (`mechanic_id`, `pilot_id`),
  INDEX (`pilot_id`),
  FOREIGN KEY (`mechanic_id`) REFERENCES `mechanic` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (`pilot_id`) REFERENCES `pilot` (`id`)
    ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB
  DEFAULT CHARACTER SET utf8 
  DEFAULT COLLATE utf8_general_ci;


###############################################

INSERT INTO mechanic (id, name, model, manufacturer, armor, height, weight) VALUES
  (1, '건담', 'RX-78-2', 'Earth Federation', 'Luna Titanium', 18.0, 43.4),
  (2, '건캐논', 'RX-77-2', 'Earth Federation', 'Luna Titanium', 17.5, 51.0),
  (3, '건탱크', 'RX-75', 'Earth Federation', 'Luna Titanium', 15.0, 56.0),
  (4, '짐', 'RGM-79', 'Earth Federation Forces', 'Titanium Alloy', 18.0, 41.2),
  (5, '자쿠 II', 'MS-06F', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 58.1),
  (6, '샤아 전용 자쿠 II', 'MS-06S', 'Zeonic Company', 'Super Hard Steel Alloy', 17.5, 56.5),
  (7, '돔', 'MS-09B', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 62.6),
  (8, '릭 돔', 'MS-09R', 'Zimmad Company', 'Super Hard Steel Alloy', 18.6, 43.8),
  (9, '즈고크 E', 'MSM-07E', 'MIP Company', 'Titanium Alloy Ceramic Composite', 18.4, 69.5),
  (10, '씨그', 'ZGMF-515', 'Zodiac Alliance of Freedom Treaty', null, 21.43, 80.22),
  (11, '거너 자쿠 워리어', 'ZGMF-1000/A1', 'Integrated Design Bureau', null, 20.50, 91.11),
  (12, '건담 5호기', 'RX-78-5', 'Earth Federation', 'Luna Titanium', 18.0, 42.9),
  (13, '건담 Mk-II', 'RX-178', 'Titans', 'Titanium Alloy Ceramic Composite', 18.5, 33.4),
  (14, '겔구그', 'MS-14A/C', 'Zeonic Company', 'Super Hard Steel Alloy', 19.2, 42.1),
  (15, '겔구그 예거', 'MS-14Jg', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 19.2, 40.5),
  (16, '고그', 'MSM-03', 'Zimmad Company', 'Super High Tensile Steel', 18.3, 82.4),
  (17, '네모', 'MSA-003', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (18, '뉴건담', 'RX-93', 'Anaheim Electronics', 'Gundarium α Alloy', 18.5, 36.2),
  (19, '레전드 건담', 'ZGMF-X666S', 'Zodiac Alliance of Freedom Treaty', 'Variable Phase Shift armor', 18.66, 86.02),
  (20, '릭디아스', 'RMS-099', 'Anaheim Electronics', 'Gundarium γ Alloy', 18.0, 32.2),
  (21, '마라사이', 'RMS-108', 'Anaheim Electronics', 'Gundarium Alloy', 17.5, 33.1),
  (22, '베르데 버스터 건담', 'GAT-X103AP', 'Actaeon Industries', 'Variable Phase Shift Armor', 18.46, 99.36),
  (23, '블레이즈 자쿠 팬텀', 'ZGMF-1001/M', 'Integrated Design Bureau', null, 20.4, 91.2),
  (24, '스트라이크 건담', 'GAT-X105', 'Earth Alliance', 'Phase Shift Armor', 17.72, 64.8),
  (25, '건담 아스트레이 레드 프레임', 'MBF-P02', 'Morgenroete, Inc.', 'Foaming metal', 17.53, 49.8),
  (26, '알렉스', 'RX-78NT-1', 'Earth Federation', 'Luna Titanium', 18.0, 40.0),
  (27, '주다', 'EMS-10', 'Zimmad Company', 'Hardened Steel', 17.3, 61.0),
  (28, '캠퍼', 'MS-18E', 'Zeonic Company', 'Titanium Alloy Ceramic Composite', 17.7, 43.5),
  (29, '파워드 짐', 'RGM-79', 'Earth Federation', 'Titanium Ceramic Composite', 18.0, 46.6),
  (30, '프리덤 건담', 'ZGMF-X10A', 'Integrated Design Bureau', 'Phase Shift Armor', 18.03, 71.5);
  
INSERT INTO gunpla (id, mechanic_id, grade, date, price, title, boxart) VALUES
  (1, 1, 'MG', '2005-03-01', 3200, 'RX-78-2 Gundam ver. O.Y.W 0079 (PS2 soft)', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78-2%20Gundam%7Cver.%20O.Y.W%200079%7C(PS2%20soft)'),
  (2, 2, 'SD', '2001-11-01', 500, 'Gun Cannon', 'http://ipsumimage.appspot.com/200x150,ffff3f?s=24&l=Gun%20Cannon'),
  (3, 3, 'SD', '2001-08-01', 500, 'Gun Tank', 'http://ipsumimage.appspot.com/200x150,ffff72?s=24&l=Gun%20Tank'),
  (4, 4, 'SD', '2001-04-01', 700, 'GM', 'http://ipsumimage.appspot.com/200x150,ffffd7?s=24&l=GM'),
  (5, 5, 'MG', '2002-09-01', 3000, 'MS-06F2	Zaku II F2 : EFSF 연방군형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06F2%7CZaku%20II%20F2%7CEFSF%20%EC%97%B0%EB%B0%A9%EA%B5%B0%ED%98%95'),
  (6, 6, 'RG', '2010-11-01', 2500, "MS-06S Char's Zaku II", 'http://ipsumimage.appspot.com/200x150,7f7fff?s=24&l=MS-06S%7CChar%27s%20Zaku%20II'),
  (7, 7, 'HGUC', '2006-01-01', 1700, 'MS-09/MS-09R Dom/Rick-Dom', 'http://ipsumimage.appspot.com/200x150,9f7fd2?s=24&l=MS-09%7CMS-09R%20Dom%7CRick-Dom'),
  (8, 8, 'MG', '1999-10-01', 4000, 'MS-09R Rick-Dom', 'http://ipsumimage.appspot.com/200x150,ff7fd2?s=24&l=MS-09R%7CRick-Dom'),
  (9, 9, 'HGUC', '2003-08-01', 1200, "MSM-07E Z'gok Experiment", 'http://ipsumimage.appspot.com/200x150,6f7fff?s=24&l=MSM-07E%7CZ%27gok%20Experiment'),
  (10, 10, 'SEED HG', '2004-04-01', 1200, 'ZGMF-515 Mobile Cgue', 'http://ipsumimage.appspot.com/200x150,afafaf?s=24&l=ZGMF-515%7CMobile%20Cgue'),   
  (11, 11, 'SEED 1/100', '2005-03-01', 2300, 'ZGMF-1000/A1 Gunner Zaku Warrior - 루나마리아 전용', 'http://ipsumimage.appspot.com/200x150,ff4f4f?s=24&l=ZGMF-1000/A1%7CGunner%20Zaku%7CWarrior%7C%EB%A3%A8%EB%82%98%EB%A7%88%EB%A6%AC%EC%95%84%7C%EC%A0%84%EC%9A%A9'),   
  (12, 12, 'MG', '2003-08-01', 2800, 'RX-78-5 Gundam 5호기', 'http://ipsumimage.appspot.com/200x150,ffff4f?s=24&l=RX-78-5%7CGundam%205%ED%98%B8%EA%B8%B0'),  
  (13, 13, 'MG', '2005-10-01', 4000, 'RX-178 Gundam Mk-II v2.0', 'http://ipsumimage.appspot.com/200x150,8f8fff?s=24&l=RX-178%7CGundam%20Mk-II%7Cv2.0'),  
  (14, 14, 'HGUC', '2007-03-01', 1600, 'MS-14A/C Gelgoog/Gelgoog Cannon', 'http://ipsumimage.appspot.com/200x150,8f8f2f?s=24&l=MS-14A/C%7CGelgoog/%7CGelgoog%20Cannon'),  
  (15, 15, 'HGUC', '2004-04-01', 1200, 'MS-14JG	Gelgoog J', 'http://ipsumimage.appspot.com/200x150,ff8f2f?s=24&l=MS-14JG%7CGelgoog%20J'),
  (16, 16, 'SD', '2000-02-01', 500, 'Gogg/Acguy/Zock', 'http://ipsumimage.appspot.com/200x150,8f7fff?s=24&l=Gogg%7CAcguy%7CZock'),
  (17, 17, 'MG', '2006-02-01', 2800, 'MSA-003 Nemo', 'http://ipsumimage.appspot.com/200x150,7fff8f?s=24&l=MSA-003%20Nemo'),
  (18, 18, 'SD', '2000-08-01', 500, 'Nu Gundam', 'http://ipsumimage.appspot.com/200x150,ffffaf?s=24&l=Nu%20Gundam'),
  (19, 19, 'SEED 1/100', '2006-06-01', 2600, 'ZGMF-X666S Legend Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfef?s=24&l=ZGMF-X666S%7CLegend%20Gundam'),
  (20, 20, 'HGUC', '2002-08-01', 1200, 'RMS-099 Rick Dias - 샤아전용', 'http://ipsumimage.appspot.com/200x150,df2f3f?s=24&l=RMS-099%7CRick%20Dias%20%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (21, 21, 'HGUC', '2005-01-01', 1400, 'RMS-108 Marasai', 'http://ipsumimage.appspot.com/200x150,ff5f5f?s=24&l=RMS-108%7CMarasai'),
  (22, 22, 'SEED HG', '2006-08-01', 1600, 'GAT-X103AP Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fffaf?s=24&l=GAT-X103AP%7CVerde%20Buster%7CGundam'),
  (23, 23, 'SEED 1/100', '2005-06-01', 2600, 'ZGMF-1001/M Blaze Zaku Phantom - 하이네 전용기', 'http://ipsumimage.appspot.com/200x150,dfdf3f?s=24&l=%7CZGMF-1001/M%7CBlaze%20Zaku%7CPhantom%7C%ED%95%98%EC%9D%B4%EB%84%A4%20%EC%A0%84%EC%9A%A9%EA%B8%B0'),
  (24, 24, 'SD', '2003-02-01', 500, 'Strike Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=Strike%20Gundam'),
  (25, 25, 'SD', '2003-04-01', 500, 'Gundam Astray - Red Frame', 'http://ipsumimage.appspot.com/200x150,df6f4f?s=24&l=Gundam%20Astray%7CRed%20Frame'),
  (26, 26, 'SD', '2004-11-01', 500, 'Gundam NT-1', 'http://ipsumimage.appspot.com/200x150,4f4fdf?s=24&l=Gundam%20NT-1'),
  (27, 27, 'HGUC', '2006-06-01', 1400, 'EMS-10 Zudah', 'http://ipsumimage.appspot.com/200x150,bfbfef?s=24&l=EMS-10%7CZudah'),
  (28, 28, 'MG', '2001-01-01', 4000, 'MS-18E Kämpfer', 'http://ipsumimage.appspot.com/200x150,3f3fef?s=24&l=EMS-18E%7CK%C3%A4mpfer'),
  (29, 29, 'HGUC', '2006-08-01', 1200, 'RGM-79 Powered GM', 'http://ipsumimage.appspot.com/200x150,ff8f4f?s=24&l=RGM-79%7CPowered%20GM'),
  (30, 30, 'SD', '2003-11-01', 500, 'Freedom Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfff?s=24&l=Freedom%20Gundam'),
  
  (31, 1, 'SD', '1999-10-01', 500, 'RX-78 Gundam', 'http://ipsumimage.appspot.com/200x150,dfdfdf?s=24&l=RX-78%7CGundam'),
  (32, 5, 'HGUC', '2003-09-01', 1000, 'MS-06 Zaku II - 양산형', 'http://ipsumimage.appspot.com/200x150,3fef3f?s=24&l=%7CMS-06%7CZaku%20II%7C%EC%96%91%EC%82%B0%ED%98%95g'),
  (33, 5, 'SD', '2001-07-01', 500, 'MS-06F Zaku II', 'http://ipsumimage.appspot.com/200x150,2fff2f?s=24&l=MS-06F%7CZaku%20II'),
  (34, 6, 'SD', '2002-03-01', 500, 'MS-06S Zaku II 샤아전용', 'http://ipsumimage.appspot.com/200x150,ff2f2f?s=24&l=%7CMS-06S%7CZaku%20II%7C%EC%83%A4%EC%95%84%EC%A0%84%EC%9A%A9'),
  (35, 7, 'SD', '2000-05-01', 400, 'Dom', 'http://ipsumimage.appspot.com/200x150,3f3f3f?s=24&l=Dom'),
  (36, 11, 'SD', '2005-07-01', 600, 'Gunner Zaku Warrior', 'http://ipsumimage.appspot.com/200x150,ff3f3f?s=24&l=Gunner%20Zaku%7CWarrior'),
  (37, 13, 'SD', '2001-06-01', 500, 'Gundam Mk-II Titans', 'http://ipsumimage.appspot.com/200x150,3f3fff?s=24&l=Gundam%20Mk-II%7CTitans'),
  (38, 18, 'HGUC', '2008-03-01', 2500, 'RX-93 υ Gundam', 'http://ipsumimage.appspot.com/200x150,dfdf33?s=24&l=RX-93%7C%CF%85%20Gundam'),
  (39, 22, 'SD', '2007-04-01', 600, 'Verde Buster Gundam', 'http://ipsumimage.appspot.com/200x150,7fff6f?s=24&l=Verde%20Buster%7CGundam'),
  (40, 23, 'SD', '2007-07-01', 600, 'Blaze Zaku Phantom (Heine Custom)', 'http://ipsumimage.appspot.com/200x150,ffff2f?s=24&l=Blaze%20Zaku%7CPhantom%7C(Heine%20Custom)'),
  (41, 25, 'SEED HG', '2003-11-01', 1200, 'MBF-P02 Gundam Astray Red Frame', 'http://ipsumimage.appspot.com/200x150,ff4f2f?s=24&l=MBF-P02%7CGundam%20Astray%7CRed%20Frame');
  
  
INSERT INTO image (id, gunpla_id, filename, description) VALUES
  (null, 1, 'gundam.png', '세로로 긴 이미지'),
  (null, 31, '건담.jpg', '귀여운 SD'),
  (null, 1, '건담mg.jpg', '파스텔 톤 좋아'),
  (null, 1, '건담mg2.jpg', '옆 모습도 멋지군'),
  (null, 1, '건담mg3.jpg', '멋있는 MG'),
  (null, 1, '건담mg4.jpg', 'mg3 파일을 세로로 길게 crop'),
  (null, 2, '건캐논.jpg', 'SD의 위용'),
  (null, 2, '건캐논2.jpg', '앙증맞은 SD'),
  (null, 3, '건탱크.jpg', 'SD에 투명 파츠까지'),
  (null, 3, '건탱크2.jpg', 'SD 위화감이 없어'),
  (null, 4, '짐mini.jpg', '어 이거 SD 아닌데'),
  (null, 5, '자쿠IImg.jpg', '육중한 위압감'),
  (null, 5, '자쿠IImg2.jpg', '구 버전이라도 멋지다'),
  (null, 5, '자쿠IImg3.jpg', '역시 모노아이'),
  (null, 32, '자쿠II.jpg', 'HGUC 자쿠II'),
  (null, 33, '자쿠IIsd.jpg', 'SD지만 육중함은 그대로'),
  (null, 6, '자쿠II샤아전용.jpg', '3배 빠른 자쿠'),
  (null, 34, '자쿠II샤아전용sd.jpg', '귀엽고 3배 빠른 자쿠'),
  (null, 7, '돔.jpg', '튼튼한 돔'),
  (null, 35, '릭돔sd.jpg', '이거 릭돔이 아니고 돔이었구나'),
  (null, 8, '릭돔.jpg', '릭돔은 볼륨감이 좋아서 전체 샷이 멋진데'),
  (null, 9, '즈고크E.jpg', '카리스마 짱'),
  (null, 9, '즈고크E.jpg', '숨겨진 보물같은 킷'),
  (null, 10, '모빌씨그.jpg', '전설의 야수와 같은 모습'),
  (null, 11, '건너자쿠워리어.jpg', '독일군 헬멧'),
  (null, 36, '건너자쿠워리어sd.jpg', 'SD가 더 근엄한 듯'),
  (null, 36, '건너자쿠워리어sd2.jpg', 'SD지만 전투력이 높을 듯'),
  (null, 36, '건너자쿠워리어sd3.jpg', '의기 양양'),
  (null, 12, '건담5호기.jpg', '알록달록 이쁘다'),
  (null, 12, '건담5호기2.jpg', '기대하지 않았는데 만족도가 높았던 킷'),
  (null, 12, '건담5호기3.jpg', '얼굴도 알록달록'),
  (null, 12, '건담5호기4.jpg', '너무 멋져~'),
  (null, 13, '건담Mk-II에우고.jpg', '강렬한 눈빛'),
  (null, 13, '건담Mk-II에우고2.jpg', '헤드폰 착용샷'),
  (null, 37, '건담Mk-II티탄즈.jpg', 'SD에서 박력이 느껴져'),
  (null, 37, '건담Mk-II티탄즈2.jpg', '흔치 않은 컬러'),
  (null, 37, '건담Mk-II티탄즈미니.jpg', '이건 SD 아닌데'),
  (null, 14, '겔구그.jpg', '멧돼지'),
  (null, 15, '겔구그예거.jpg', '울퉁불퉁 멋진 킷'),
  (null, 15, '겔구그예거2.jpg', '전투력 높을 것 같아'),
  (null, 16, '고그.jpg', '해산물 3종 세트 중 하나. 너무 귀여워'),
  (null, 17, '네모.jpg', '만족도 엄청 높았던 킷. 또 하나의 숨겨진 보물'),
  (null, 18, '뉴건담sd.jpg', '인기 높은 뉴건담. 뉴건담이야 누 건담이야'),
  (null, 18, '뉴건담sd2.jpg', '체구에 비해 큰 백팩'),
  (null, 38, '뉴건담.jpg', '먹선을 너무 흐리게 넣었나'),
  (null, 19, '레전드건담.jpg', '무등급이지만 박력있는 백팩'),
  (null, 20, '릭디아스샤아전용.jpg', '사진빨 안받네'),
  (null, 21, '마라사이.jpg', '이 킷도 좋았음'),
  (null, 22, '베르데버스터건담.jpg', '그저 그런'),
  (null, 39, '베르데버스터건담sd.jpg', 'SD가 HGUC보다 박력있다'),
  (null, 23, '블레이즈자쿠팬텀.jpg', '무등급이지만 좋다'),
  (null, 40, '블레이즈자쿠팬텀sd.jpg', '먹선 안 넣어도 멋져'),
  (null, 40, '블레이즈자쿠팬텀sd2.jpg', '쌍도끼. 어쎄신 크리드 발할라 찍냐'),
  (null, 24, '스트라이크건담.jpg', '스트라이크 건담은 모든 등급이 다 잘 뽑힌듯'),
  (null, 24, '스트라이크건담2.jpg', '너무 가까워'),
  (null, 24, '스트라이크건담3.jpg', 'SD치고는 롱다리'),
  (null, 25, '아스트레이레드sd.jpg', 'SD 얼굴 귀여워'),
  (null, 41, '아스트레이레드.jpg', '독특한 근육 몸매. 가동률 좋음'),
  (null, 26, '알렉스.jpg', '주머니 속의 전쟁 주인공 기체'),
  (null, 26, '알렉스2.jpg', '개틀링 건도 장착 가능'),
  (null, 27, '주다.jpg', '개성 만점. 강추'),
  (null, 28, '캠퍼.jpg', '건담이 아닌 다른 애니메이션에 등장할 법한 특이한 외형이지만 좋다. 버니어 색분할 압권'),
  (null, 29, '파워드짐.jpg', '폭죽이라 놀리지 마라'),
  (null, 29, '파워드짐2.jpg', '심플한 매력'),
  (null, 30, '프리덤건담.jpg', '인기 많은 기체'),
  (null, 30, '프리덤건담2.jpg', 'MG의 화려함을 따라가기엔 부족'),
  (null, 30, '프리덤건담3.jpg', '인기 많은 기체 답게 뭐가 많이 달려있다');

카테고리

최근 글

아카이브

태그

CSV1
DCL1
DML1
JSON1
Normalization1
PHP1
SQL1
TCL1
aac1
alter1
android1
blog3
category1
cortana1
create1
database22
dbms1
ddl1
django1
docker1
docker-compose1
drop1
express1
favicon1
flask2
font1
free1
goorm1
hexo4
http2
integrity1
jQuery1
join1
json1
mongodb1
mysql23
openapi1
react1
room1
select1
spring1
sql1
sqlite1
table1
telemetry1
transaction1
trigger1
visual c#2
volley1
web2
web programming2
winforms1
workbench1
wpf1
국기1
데이터베이스21
메모리1
무결성1
무료1
성능1
웹프로그래밍2
윈도우즈1
유용한 사이트2
저하1
정규화1
트랜잭션1
파이썬1
파일1
포토샵1
폰트1
피드백1
한글2

링크

×