목차
insert into common_code (code, name, type,type_name)
values
('101','빨강','100','래밸'),
('102','주황','100','래밸'),
('103','노랑','100','래밸'),
('104','초록','100','래밸'),
('105','파랑','100','래밸'),
('106','남색','100','래밸'),
('107','보라','100','래밸'),
('108','회색','100','래밸'),
('109','갈색','100','래밸'),
('110','검정','100','래밸'),
('111','연두','100','래밸'),
('112','핑크','100','래밸'),
('113','흰색','100','래밸'),
('114','P','100','래밸'),
('115','A','100','래밸'),
('116','B','100','래밸'),
('117','C','100','래밸'),
('118','D','100','래밸'),
('119','E','100','래밸'),
('120','F','100','래밸'),
('121','G','100','래밸');
insert into common_code (code, name, tier_exp,type,type_name,solution_exp)
values
('201','Bronze4','50','200','티어','10'),
('202','Bronze3','140','200','티어','15'),
('203','Bronze2','302','200','티어','23'),
('204','Bronze1','594','200','티어','34'),
('205','Silver4','1118','200','티어','51'),
('206','Silver3','2063','200','티어','76'),
('207','Silver2','3764','200','티어','114'),
('208','Silver1','6825','200','티어','171'),
('209','Gold4','12335','200','티어','256'),
('210','Gold3','22253','200','티어','384'),
('211','Gold2','40105','200','티어','577'),
('212','Gold1','72239','200','티어','865'),
('213','Platinum4','130081','200','티어','1297'),
('214','Platinum3','234196','200','티어','1946'),
('215','Platinum2','421603','200','티어','2919'),
('216','Platinum1','758935','200','티어','4379'),
('217','Diamond4','1340832','200','티어','6568'),
('218','Diamond3','2344606','200','티어','9853'),
('219','Diamond2','4076115','200','티어','14779'),
('220','Diamond1','7062969','200','티어','22168'),
('221','Master4','12215292','200','티어','33253'),
('222','Master3','21103049','200','티어','49879'),
('223','Master2','36434430','200','티어','74818'),
('224','Master1','62881063','200','티어','112227');
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (1,'22:00:00','12:00:00',1,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (2,'22:00:00','12:00:00',2,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (3,'22:00:00','12:00:00',3,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (4,'22:00:00','12:00:00',4,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (5,'22:00:00','12:00:00',5,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (6,'19:00:00','10:00:00',6,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (7,'19:00:00','10:00:00',7,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (8,'19:00:00','10:00:00',8,1);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (9,'22:00:00','10:00:00',1,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (10,'22:00:00','10:00:00',2,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (11,'22:00:00','10:00:00',3,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (12,'22:00:00','10:00:00',4,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (13,'22:00:00','10:00:00',5,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (14,'22:00:00','10:00:00',6,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (15,'20:00:00','10:00:00',7,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (16,'20:00:00','10:00:00',8,2);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (17,'22:00:00','10:00:00',1,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (18,'22:00:00','10:00:00',2,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (19,'22:00:00','10:00:00',3,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (20,'22:00:00','10:00:00',4,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (21,'22:00:00','10:00:00',5,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (22,'20:00:00','10:00:00',6,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (23,'20:00:00','10:00:00',7,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (24,'20:00:00','10:00:00',8,3);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (25,'22:00:00','10:00:00',1,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (26,'22:00:00','10:00:00',2,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (27,'22:00:00','10:00:00',3,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (28,'22:00:00','10:00:00',4,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (29,'22:00:00','10:00:00',5,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (30,'22:00:00','10:00:00',6,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (31,'20:00:00','10:00:00',7,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (32,'20:00:00','10:00:00',8,4);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (33,'22:00:00','10:00:00',1,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (34,'22:00:00','10:00:00',2,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (35,'22:00:00','10:00:00',3,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (36,'22:00:00','10:00:00',4,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (37,'22:00:00','10:00:00',5,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (38,'20:00:00','10:00:00',6,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (39,'20:00:00','10:00:00',7,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (40,'20:00:00','10:00:00',8,5);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (41,'22:00:00','10:00:00',1,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (42,'22:00:00','10:00:00',2,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (43,'22:00:00','10:00:00',3,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (44,'22:00:00','10:00:00',4,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (45,'22:00:00','10:00:00',5,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (46,'20:00:00','10:00:00',6,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (47,'20:00:00','10:00:00',7,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (48,'20:00:00','10:00:00',8,6);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (49,'23:00:00','15:00:00',1,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (50,'23:00:00','14:00:00',2,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (51,'23:00:00','14:00:00',3,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (52,'23:00:00','14:00:00',4,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (53,'23:00:00','14:00:00',5,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (54,'19:00:00','12:00:00',6,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (55,'19:00:00','12:00:00',7,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (56,'19:00:00','12:00:00',8,7);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (57,'23:00:00','15:00:00',1,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (58,'23:00:00','14:00:00',2,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (59,'23:00:00','14:00:00',3,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (60,'23:00:00','14:00:00',4,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (61,'23:00:00','14:00:00',5,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (62,'19:00:00','12:00:00',6,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (63,'19:00:00','12:00:00',7,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (64,'19:00:00','12:00:00',8,8);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (65,'22:30:00','10:00:00',1,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (66,'22:30:00','10:00:00',2,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (67,'22:30:00','10:00:00',3,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (68,'22:30:00','10:00:00',4,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (69,'22:30:00','10:00:00',5,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (70,'18:30:00','10:00:00',6,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (71,'18:30:00','10:00:00',7,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (72,'18:30:00','10:00:00',8,9);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (73,'22:00:00','12:00:00',1,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (74,'22:00:00','12:00:00',2,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (75,'22:00:00','12:00:00',3,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (76,'22:00:00','12:00:00',4,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (77,'22:00:00','12:00:00',5,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (78,'20:00:00','12:00:00',6,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (79,'20:00:00','12:00:00',7,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (80,'20:00:00','12:00:00',8,10);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (81,'22:00:00','10:00:00',1,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (82,'22:00:00','10:00:00',2,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (83,'22:00:00','10:00:00',3,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (84,'22:00:00','10:00:00',4,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (85,'22:00:00','10:00:00',5,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (86,'20:00:00','10:00:00',6,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (87,'20:00:00','10:00:00',7,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (88,'20:00:00','10:00:00',8,11);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (89,'23:00:00','11:00:00',1,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (90,'23:00:00','11:00:00',2,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (91,'23:00:00','11:00:00',3,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (92,'23:00:00','11:00:00',4,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (93,'23:00:00','11:00:00',5,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (94,'18:00:00','11:00:00',6,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (95,'18:00:00','11:00:00',7,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (96,'18:00:00','11:00:00',8,12);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (97,'23:00:00','11:00:00',1,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (98,'23:00:00','11:00:00',2,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (99,'23:00:00','11:00:00',3,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (100,'23:00:00','11:00:00',4,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (101,'23:00:00','11:00:00',5,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (102,'20:00:00','12:00:00',6,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (103,'20:00:00','12:00:00',7,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (104,'20:00:00','12:00:00',8,13);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (105,'23:00:00','14:00:00',1,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (106,'23:00:00','14:00:00',2,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (107,'23:00:00','14:00:00',3,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (108,'23:00:00','14:00:00',4,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (109,'23:00:00','17:00:00',5,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (110,'19:00:00','11:00:00',6,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (111,'19:00:00','11:00:00',7,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (112,'00:00:00','00:00:00',8,14);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (113,'23:00:00','11:00:00',1,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (114,'23:00:00','11:00:00',2,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (115,'23:00:00','11:00:00',3,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (116,'23:00:00','11:00:00',4,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (117,'23:00:00','11:00:00',5,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (118,'20:00:00','12:00:00',6,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (119,'20:00:00','12:00:00',7,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (120,'20:00:00','12:00:00',8,15);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (121,'22:30:00','11:00:00',1,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (122,'22:30:00','11:00:00',2,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (123,'22:30:00','11:00:00',3,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (124,'22:30:00','11:00:00',4,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (125,'22:30:00','11:00:00',5,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (126,'19:00:00','11:00:00',6,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (127,'19:00:00','11:00:00',7,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (128,'19:00:00','11:00:00',8,16);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (129,'23:00:00','10:00:00',1,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (130,'23:00:00','10:00:00',2,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (131,'23:00:00','10:00:00',3,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (132,'23:00:00','10:00:00',4,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (133,'23:00:00','10:00:00',5,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (134,'19:00:00','10:00:00',6,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (135,'19:00:00','10:00:00',7,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (136,'19:00:00','10:00:00',8,17);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (137,'22:00:00','10:00:00',1,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (138,'22:00:00','10:00:00',2,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (139,'22:00:00','10:00:00',3,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (140,'22:00:00','10:00:00',4,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (141,'22:00:00','10:00:00',5,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (142,'18:00:00','10:00:00',6,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (143,'18:00:00','10:00:00',7,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (144,'18:00:00','10:00:00',8,18);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (145,'22:00:00','11:00:00',1,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (146,'22:00:00','11:00:00',2,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (147,'22:00:00','11:00:00',3,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (148,'22:00:00','11:00:00',4,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (149,'22:00:00','11:00:00',5,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (150,'19:00:00','11:00:00',6,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (151,'19:00:00','11:00:00',7,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (152,'19:00:00','11:00:00',8,19);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (153,'22:00:00','10:00:00',1,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (154,'22:00:00','10:00:00',2,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (155,'22:00:00','10:00:00',3,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (156,'22:00:00','10:00:00',4,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (157,'22:00:00','10:00:00',5,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (158,'20:00:00','11:00:00',6,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (159,'20:00:00','11:00:00',7,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (160,'20:00:00','11:00:00',8,20);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (161,'23:00:00','11:00:00',1,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (162,'23:00:00','11:00:00',2,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (163,'23:00:00','11:00:00',3,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (164,'23:00:00','11:00:00',4,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (165,'23:00:00','12:00:00',5,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (166,'20:00:00','12:00:00',6,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (167,'20:00:00','12:00:00',7,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (168,'20:00:00','12:00:00',8,21);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (169,'23:00:00','11:00:00',1,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (170,'23:00:00','11:00:00',2,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (171,'23:00:00','11:00:00',3,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (172,'23:00:00','11:00:00',4,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (173,'23:00:00','11:00:00',5,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (174,'20:00:00','10:00:00',6,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (175,'20:00:00','10:00:00',7,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (176,'20:00:00','10:00:00',8,22);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (177,'23:30:00','11:00:00',1,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (178,'23:30:00','11:00:00',2,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (179,'23:30:00','11:00:00',3,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (180,'23:30:00','11:00:00',4,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (181,'21:00:00','11:00:00',5,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (182,'20:00:00','11:00:00',6,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (183,'20:00:00','11:00:00',7,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (184,'20:00:00','11:00:00',8,23);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (185,'23:00:00','11:00:00',1,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (186,'23:00:00','11:00:00',2,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (187,'23:00:00','11:00:00',3,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (188,'23:00:00','11:00:00',4,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (189,'23:00:00','11:00:00',5,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (190,'19:00:00','11:00:00',6,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (191,'19:00:00','11:00:00',7,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (192,'00:00:00','00:00:00',8,24);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (193,'23:00:00','12:00:00',1,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (194,'23:00:00','12:00:00',2,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (195,'23:00:00','12:00:00',3,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (196,'23:00:00','12:00:00',4,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (197,'23:00:00','16:00:00',5,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (198,'20:00:00','12:00:00',6,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (199,'20:00:00','12:00:00',7,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (200,'20:00:00','12:00:00',8,25);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (201,'23:00:00','10:00:00',1,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (202,'23:00:00','10:00:00',2,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (203,'23:00:00','10:00:00',3,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (204,'23:00:00','10:00:00',4,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (205,'23:00:00','10:00:00',5,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (206,'18:00:00','10:00:00',6,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (207,'00:00:00','00:00:00',7,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (208,'00:00:00','00:00:00',8,26);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (209,'22:00:00','10:00:00',1,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (210,'22:00:00','10:00:00',2,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (211,'22:00:00','10:00:00',3,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (212,'22:00:00','10:00:00',4,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (213,'22:00:00','10:00:00',5,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (214,'20:00:00','10:00:00',6,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (215,'20:00:00','10:00:00',7,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (216,'20:00:00','10:00:00',8,27);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (217,'23:00:00','13:00:00',1,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (218,'23:00:00','13:00:00',2,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (219,'23:00:00','13:00:00',3,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (220,'23:00:00','13:00:00',4,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (221,'23:00:00','13:00:00',5,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (222,'19:00:00','11:00:00',6,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (223,'19:00:00','11:00:00',7,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (224,'19:00:00','11:00:00',8,28);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (225,'23:00:00','11:00:00',1,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (226,'23:00:00','11:00:00',2,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (227,'23:00:00','11:00:00',3,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (228,'23:00:00','11:00:00',4,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (229,'23:00:00','11:00:00',5,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (230,'20:00:00','14:00:00',6,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (231,'20:00:00','14:00:00',7,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (232,'20:00:00','14:00:00',8,29);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (233,'22:00:00','10:00:00',1,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (234,'22:00:00','10:00:00',2,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (235,'22:00:00','10:00:00',3,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (236,'22:00:00','10:00:00',4,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (237,'22:00:00','10:00:00',5,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (238,'22:00:00','10:00:00',6,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (239,'22:00:00','10:00:00',7,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (240,'22:00:00','10:00:00',8,30);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (241,'23:00:00','10:00:00',1,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (242,'23:00:00','10:00:00',2,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (243,'23:00:00','10:00:00',3,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (244,'23:00:00','10:00:00',4,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (245,'23:00:00','10:00:00',5,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (246,'20:00:00','10:00:00',6,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (247,'20:00:00','10:00:00',7,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (248,'20:00:00','10:00:00',8,31);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (249,'23:00:00','07:00:00',1,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (250,'23:00:00','07:00:00',2,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (251,'23:00:00','07:00:00',3,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (252,'23:00:00','07:00:00',4,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (253,'23:00:00','07:00:00',5,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (254,'20:00:00','10:00:00',6,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (255,'20:00:00','10:00:00',7,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (256,'20:00:00','10:00:00',8,32);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (257,'23:00:00','12:00:00',1,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (258,'23:00:00','12:00:00',2,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (259,'23:00:00','12:00:00',3,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (260,'23:00:00','12:00:00',4,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (261,'23:00:00','12:00:00',5,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (262,'20:00:00','11:00:00',6,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (263,'20:00:00','11:00:00',7,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (264,'20:00:00','11:00:00',8,33);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (265,'23:00:00','11:30:00',1,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (266,'23:00:00','11:30:00',2,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (267,'23:00:00','11:30:00',3,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (268,'23:00:00','11:30:00',4,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (269,'22:00:00','15:00:00',5,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (270,'19:00:00','12:00:00',6,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (271,'00:00:00','00:00:00',7,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (272,'19:00:00','12:00:00',8,34);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (273,'22:00:00','12:00:00',1,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (274,'22:00:00','12:00:00',2,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (275,'22:00:00','12:00:00',3,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (276,'22:00:00','12:00:00',4,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (277,'22:00:00','12:00:00',5,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (278,'22:00:00','10:00:00',6,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (279,'22:00:00','10:00:00',7,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (280,'22:00:00','10:00:00',8,36);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (281,'23:00:00','10:00:00',1,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (282,'23:00:00','10:00:00',2,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (283,'23:00:00','10:00:00',3,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (284,'23:00:00','10:00:00',4,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (285,'23:00:00','10:00:00',5,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (286,'20:00:00','13:00:00',6,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (287,'20:00:00','13:00:00',7,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (288,'20:00:00','13:00:00',8,37);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (289,'22:00:00','12:00:00',1,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (290,'22:00:00','12:00:00',2,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (291,'22:00:00','12:00:00',3,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (292,'22:00:00','12:00:00',4,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (293,'22:00:00','12:00:00',5,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (294,'19:00:00','10:00:00',6,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (295,'19:00:00','10:00:00',7,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (296,'19:00:00','10:00:00',8,35);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (297,'22:00:00','10:00:00',1,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (298,'22:00:00','10:00:00',2,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (299,'22:00:00','10:00:00',3,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (300,'22:00:00','10:00:00',4,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (301,'21:45:00','15:00:00',5,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (302,'18:45:00','10:00:00',6,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (303,'18:45:00','10:00:00',7,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (304,'18:45:00','10:00:00',8,38);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (305,'22:30:00','11:00:00',1,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (306,'22:30:00','11:00:00',2,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (307,'22:30:00','11:00:00',3,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (308,'22:30:00','11:00:00',4,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (309,'22:35:00','11:00:00',5,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (310,'19:00:00','10:30:00',6,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (311,'19:00:00','10:30:00',7,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (312,'19:00:00','10:30:00',8,39);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (313,'23:00:00','14:00:00',1,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (314,'23:00:00','14:00:00',2,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (315,'23:00:00','14:00:00',3,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (316,'23:00:00','14:00:00',4,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (317,'23:00:00','14:00:00',5,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (318,'18:00:00','11:00:00',6,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (319,'00:00:00','00:00:00',7,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (320,'00:00:00','00:00:00',8,40);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (321,'23:00:00','10:00:00',1,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (322,'23:00:00','10:00:00',2,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (323,'23:00:00','10:00:00',3,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (324,'23:00:00','10:00:00',4,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (325,'23:00:00','10:00:00',5,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (326,'20:00:00','10:00:00',6,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (327,'20:00:00','10:00:00',7,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (328,'20:00:00','10:00:00',8,41);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (329,'23:00:00','11:00:00',1,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (330,'23:00:00','11:00:00',2,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (331,'23:00:00','11:00:00',3,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (332,'23:00:00','11:00:00',4,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (333,'23:00:00','11:00:00',5,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (334,'20:00:00','11:00:00',6,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (335,'20:00:00','11:00:00',7,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (336,'20:00:00','11:00:00',8,42);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (337,'23:00:00','11:00:00',1,43);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (338,'23:00:00','11:00:00',2,43);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (339,'23:00:00','11:00:00',3,43);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (340,'23:00:00','11:00:00',4,43);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (341,'23:00:00','11:00:00',5,43);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (342,'20:00:00','12:00:00',6,43);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (343,'20:00:00','12:00:00',7,43);
INSERT INTO hours(hours_id,end_time,start_time,type,climbing_id) VALUES (344,'20:00:00','12:00:00',8,43);
use gumison;
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'서울숲 클라이밍'
, '서울 성동구 성수일로 19 지하2층'
, '010-4372-1116'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'더클라임 홍대점'
, '서울 마포구 양화로 125 경남관광빌딩'
, '02-332-5014'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'더클라임 마곡점', '서울 강서구 마곡동로 62 마곡사이언스타워 7층', '02-2668-5014'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'더클라임 일산점', '경기 고양시 일산동구 중앙로 1160 5층 더클라임', '031-905-5014'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'더클라임 서울대점', '서울 관악구 남부순환로 1801 지하1층','02-888-8821'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'더클라임 양재점', '서울 강남구 남부순환로 2615 지하1층 ','02-576-8821'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'알레 클라이밍', '서울 영등포구 영등포로33길 14', '070-8862-2018'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'알레 클라이밍 혜화', '서울 종로구 창경궁로34길 18-5 토가빌딩 B2', '070-8886-2018'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'더코아 클라이밍 센터', '서울 종로구 삼일대로 386', '02-2269-5659'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'훅클라이밍 성수점', '서울 성동구 성수일로12길 34 3층', '02-6082-4739'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'훅클라이밍 왕십리점', '서울 성동구 고산자로6길 40 2층', '02-2282-4739'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'버티고 클라이밍짐','서울 광진구 천호대로 611', '02-446-6111'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'V10 클라이밍 장한평점', '서울 동대문구 장한로2길 63 호정빌딩 2F','0507-1313-4171'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'V10 클라이밍 천호본점', '서울 강동구 올림픽로 588 귀뚜라미빌딩 B1','02-482-2015'
);
insert into climbing (
climbing_name,
address,
phone_number
)
values (
'V10 클라이밍 하남미사점','경기 하남시 미사강변동로 81 13층','031-794-5045'
);
insert into climbing (climbing_name, address, phone_number)
values (
'산타클라이밍', '서울 동대문구 난계로30길 23','0507-1425-5157'
);
insert into climbing (climbing_name, address, phone_number)
values (
'강서클라이밍 센터', '서울 강서구 공항대로 284 동서빌딩 4층','02-3662-0138'
);
insert into climbing (climbing_name, address, phone_number)
values (
'코알라클라이밍', '서울 마포구 월드컵북로 396 누리꿈스퀘어 비즈니스타워 B1001호','070-7733-4768'
);
insert into climbing (climbing_name, address, phone_number)
values (
'어거스트 클라이밍', '서울 금천구 디지털로 121 20층 2009호','02-3016-7964'
);
insert into climbing (climbing_name, address, phone_number)
values (
'정지현클라이밍짐', '서울특별시 관악구 봉천로 462 은일빌딩 7층','02-883-5014'
);
insert into climbing (climbing_name, address, phone_number)
values (
'게이트원 클라이밍', '서울특별시 서초구 서초대로26길 3','070-8883-8850'
);
insert into climbing (climbing_name, address, phone_number)
values (
'비블럭 클라이밍 강남점','서울특별시 강남구 논현로 563 언주타워 지하 1층','02-547-5939'
);
insert into climbing (climbing_name, address, phone_number)
values (
'비블럭 클라이밍 송도점','인천 연수구 아트센터대로 149','032-723-6430'
);
insert into climbing (climbing_name, address, phone_number)
values (
'타잔101 클라이밍 압구정점','서울특별시 강남구 압구정로28길 11 B1','02-511-1013'
);
insert into climbing (climbing_name, address, phone_number)
values (
'락트리클라이밍 강남','서울특별시 강남구 강남대로118길 12 B2','070-7802-8889'
);
insert into climbing (climbing_name, address, phone_number)
values (
'볼더 클라이밍 짐','서울 노원구 동일로241길 53 202~209호','070-4696-3270'
);
insert into climbing (climbing_name, address, phone_number)
values (
'드림캐처클라이밍짐','서울 노원구 상계로5길 32 7층','02-6080-1229'
);
insert into climbing (climbing_name, address, phone_number)
values (
'비숍 클라이밍','서울 노원구 동일로 1393 지하1층','02-936-0515'
);
insert into climbing (climbing_name, address, phone_number)
values (
'맑음클라임','서울 은평구 통일로 1020 은평뉴타운 신한헤센스마트 M203호','0507-1418-8377'
);
insert into climbing (climbing_name, address, phone_number)
values (
'볼더프렌즈 클라이밍','서울 마포구 홍익로 25','02-332-7738'
);
insert into climbing (climbing_name, address, phone_number)
values (
'클라이밍파크 한티점','서울특별시 강남구 선릉로 324 SH타워 지하3층','050-71340-4662'
);
insert into climbing (climbing_name, address, phone_number)
values (
'클라이밍 파크','서울특별시 강남구 강남대로 468 지하3층','02-555-4662'
);
insert into climbing (climbing_name, address, phone_number)
values (
'닷클라이밍짐','서울 송파구 법원로8길 9 청림타워 2층','070-7700-0120'
);
insert into climbing (climbing_name, address, phone_number)
values (
'역삼 클라이밍 랩','서울특별시 강남구 테헤란로30길 49 지하1층','010-9115-6911'
);
insert into climbing (climbing_name, address, phone_number)
values (
'서울 볼더스 클라이밍 컴퍼니','서울특별시 영등포구 양평로28마길 7 3층','02-2632-4478'
);
insert into climbing (climbing_name, address, phone_number)
values (
'더 플라스틱 클라이밍','서울 영등포구 도림로 423','02-6406-8890'
);
insert into climbing (climbing_name, address, phone_number)
values (
'서종국 클라이밍','서울 영등포구 선유로53길 6','02-2676-1932'
);
insert into climbing (climbing_name, address, phone_number)
values (
'손상원 클라이밍짐 잠실점','서울특별시 송파구 백제고분로 224 창대빌딩 지하1층','02-423-5015'
);
insert into climbing (climbing_name, address, phone_number)
values (
'에어즈락 클라이밍','서울 송파구 위례광장로 188 아이온스퀘어 12층','02-400-3845'
);
insert into climbing (climbing_name, address, phone_number)
values (
'강동클라이밍짐','서울 강동구 천호대로 1178 알레소 빌딩 지하','0507-1438-8849'
);
insert into climbing (climbing_name, address, phone_number)
values (
'에이스클라이밍센터', '서울특별시 구로구 가마산로27길 14','02-836-8848'
);
insert into climbing (climbing_name, address, phone_number)
values (
'락스타클라이밍','서울특별시 송파구 백제고분로 435 예스빌딩 B1','02-418-8848'
);
insert into climbing (climbing_name, address, phone_number)
values (
'비스트클라이밍짐','서울특별시 서초구 등산로 84','02-2058-1423'
);
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '201', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '203', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '205', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '210', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '214', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '223', '1');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '210', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '213', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '216', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '219', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '221', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '2');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '210', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '213', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '216', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '219', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '221', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '3');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '210', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '213', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '216', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '219', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '221', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '4');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '210', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '213', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '216', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '219', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '221', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '5');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '210', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '213', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '216', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '219', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '221', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '6');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('111', '205', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '207', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '209', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '211', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '214', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '219', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '223', '7');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('111', '205', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '207', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '209', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '211', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '214', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '219', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '223', '8');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '203', '9');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '206', '9');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '211', '9');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '214', '9');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '219', '9');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '222', '9');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '202', '10');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '10');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '206', '10');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '10');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '10');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '215', '10');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '220', '10');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '202', '11');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '11');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '206', '11');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '11');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '11');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '215', '11');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '220', '11');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '12');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('111', '207', '12');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '210', '12');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '213', '12');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '216', '12');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '220', '12');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '202', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '206', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '211', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '216', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '220', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '223', '13');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '202', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '206', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '211', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '216', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '220', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '223', '14');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '202', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '206', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '211', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '216', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '220', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '223', '15');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '201', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '202', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '204', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '207', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '214', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '218', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '223', '16');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '202', '17');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '206', '17');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '17');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '213', '17');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '218', '17');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '221', '17');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '202', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '204', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('111', '207', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '209', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '212', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '216', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '18');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('121', '201', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('120', '204', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('119', '208', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('118', '211', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('117', '213', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('116', '216', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('115', '219', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('114', '223', '19');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '201', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '203', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '204', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '206', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '208', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '211', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '213', '20');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '204', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '207', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '209', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '212', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '215', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '219', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '223', '21');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '204', '22');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '206', '22');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '209', '22');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '22');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '214', '22');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '219', '22');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '223', '22');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '204', '23');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '206', '23');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '209', '23');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '23');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '214', '23');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '219', '23');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '223', '23');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '202', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '205', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '208', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '210', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '212', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '215', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '219', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '223', '24');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '204', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '206', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '208', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '215', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '218', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '222', '25');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '202', '26');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '26');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '208', '26');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '211', '26');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '215', '26');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '220', '26');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '201', '27');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '27');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '27');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '27');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '27');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '215', '27');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '27');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '201', '28');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '28');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '28');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '28');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '28');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '214', '28');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '28');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '204', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '207', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('111', '209', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '212', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '216', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '223', '29');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '203', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '216', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '223', '30');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '201', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '204', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '206', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '209', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '212', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '214', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '218', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '223', '31');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '201', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('112', '204', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '206', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '209', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '212', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '214', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '218', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '223', '32');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '202', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '206', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '216', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '219', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '222', '33');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '202', '34');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '204', '34');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '207', '34');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '34');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '216', '34');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '220', '34');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '202', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '216', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '220', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '35');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '202', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '214', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '222', '36');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '203', '37');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('111', '208', '37');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '37');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '215', '37');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '218', '37');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '220', '37');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '224', '37');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '204', '38');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '207', '38');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '209', '38');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '212', '38');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '216', '38');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '220', '38');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '201', '39');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '39');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '39');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '39');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '39');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '215', '39');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '220', '39');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '201', '40');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('111', '202', '40');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '204', '40');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '208', '40');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '212', '40');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('108', '216', '40');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('113', '201', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '203', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '205', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '209', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '215', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '219', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '223', '41');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '202', '42');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('102', '204', '42');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '207', '42');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '210', '42');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '214', '42');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('106', '217', '42');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '222', '42');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('103', '201', '43');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('104', '204', '43');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('107', '207', '43');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('109', '209', '43');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('105', '212', '43');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('101', '216', '43');
INSERT INTO `gumison`.`level_tier` (`level_code`, `tier_code`, `climbing_id`) VALUES ('110', '219', '43');
## user Data ##
insert into user (nickname, user_id,accumulate_exp, accumulate_video,oauth_id, oauth_type, description,tier_code)
values
('dummy1','0','0','0','','','반갑습니다 dummy1 입니다.','201'),
('dummy2','1','1120','5','','','반갑습니다 dummy2 입니다.','205'),
('dummy3','2','6830','0','','','반갑습니다 dummy3 입니다.','207');
## solution Data ##
insert into solution (solution_id, accumulate_report, count, date, climbing_id, level_tier_id, user_id)
values
('0','0','1','2021-09-24 018:00:00.007','1','1','1'),
('1','0','2','2021-09-25 018:00:00.007','1','1','1'),
('2','0','3','2021-09-26 018:00:00.007','1','2','1'),
('3','0','2','2021-09-20 018:00:00.007','1','2','2'),
('4','0','2','2021-09-23 018:00:00.007','1','2','2'),
('5','0','2','2021-09-25 018:00:00.007','2','10','2'),
('6','0','3','2021-09-26 018:00:00.000','2','11','2'),
('7','0','2','2021-09-26 018:00:00.007','2','9','2');