-- Generated by generated_infosql.sh
USE `springtime`;
SET NAMES utf8mb4;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS;
SET FOREIGN_KEY_CHECKS=0;
START TRANSACTION;

-- InfoBanner.xlsx / info_banner
DELETE FROM `info_banner`;
INSERT INTO `info_banner` (`ibsn`,`title`,`bannercode`,`started_at`,`ended_at`,`thumbnail`,`display_order`,`enable_hide_today`,`is_show`) VALUES (1,'기본배너','BANNER_CALENDER','2026-01-01 00:00:00','2027-01-01 00:00:00',NULL,1,'Y','Y');

-- InfoBuilding.xlsx / info_building
DELETE FROM `info_building`;
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (1,'매표소','매표소입니다',1,0,0,1,0,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (2,'출구','출구입니다',1,0,0,1,0,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (3,'출구','출구입니다',1,0,0,1,0,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (1001,'회전 목마','회전 목마 놀이기구 입니다.',1,0,15,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (1002,'미니 열차','미니 열차 놀이기구 입니다.',1,0,30,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (1003,'미니 관람차','미니 관람차 놀이기구 입니다.',1,0,45,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (1004,'롤러코스터','롤러코스터 놀이기구 입니다.',1,0,60,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (2001,'휴게시설',NULL,1,0,0,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (2002,'기프트 샵',NULL,1,0,0,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (3001,'솜사탕 트럭',NULL,1,0,0,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (3002,'레몬 에이드',NULL,1,0,0,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (3003,'화장실',NULL,1,0,0,1,1,10,2,9);
INSERT INTO `info_building` (`ibsn`,`title`,`description`,`issn`,`open_level`,`build_duration_sec`,`build_cost_imsn`,`build_cost_price`,`ride_duration_sec`,`disembark_duration_sec`,`max_queue_capacity`) VALUES (3004,'성',NULL,1,0,0,1,1,10,2,9);

-- InfoBuilding.xlsx / info_building_grade
DELETE FROM `info_building_grade`;
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1,1,1,100,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1001,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1001,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1001,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1001,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1002,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1002,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1002,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1002,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1003,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1003,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1003,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1003,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1004,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1004,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1004,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (1004,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2001,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2001,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2001,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2001,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2002,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2002,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2002,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (2002,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3001,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3001,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3001,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3001,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3002,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3002,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3002,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3002,4,1,1000,75,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3003,1,1,1000,0,25,3);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3003,2,1,1000,25,50,5);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3003,3,1,1000,50,75,9);
INSERT INTO `info_building_grade` (`ibsn`,`next_grade`,`need_imsn`,`need_price`,`buffvalue`,`max_item_level`,`max_ride_capacity`) VALUES (3003,4,1,1000,75,75,9);

-- InfoBuilding.xlsx / info_building_customer
DELETE FROM `info_building_customer`;
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (1,'고객1','고객입니다','CUSTOMER_1','CUSTOMER_1');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (2,'고객2','고객입니다','CUSTOMER_2','CUSTOMER_2');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (3,'고객3','고객입니다','CUSTOMER_3','CUSTOMER_3');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (4,'고객4','고객입니다','CUSTOMER_4','CUSTOMER_4');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (5,'고객5','고객입니다','CUSTOMER_5','CUSTOMER_5');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (6,'고객6','고객입니다','CUSTOMER_6','CUSTOMER_6');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (7,'고객7','고객입니다','CUSTOMER_7','CUSTOMER_7');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (8,'고객8','고객입니다','CUSTOMER_8','CUSTOMER_8');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (9,'고객9','고객입니다','CUSTOMER_9','CUSTOMER_9');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (10,'고객10','고객입니다','CUSTOMER_10','CUSTOMER_10');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (11,'고객11','고객입니다','CUSTOMER_11','CUSTOMER_11');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (12,'고객12','고객입니다','CUSTOMER_12','CUSTOMER_12');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (13,'고객13','고객입니다','CUSTOMER_13','CUSTOMER_13');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (14,'고객14','고객입니다','CUSTOMER_14','CUSTOMER_14');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (15,'고객15','고객입니다','CUSTOMER_15','CUSTOMER_15');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (16,'고객16','고객입니다','CUSTOMER_16','CUSTOMER_16');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (17,'고객17','고객입니다','CUSTOMER_17','CUSTOMER_17');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (18,'고객18','고객입니다','CUSTOMER_18','CUSTOMER_18');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (19,'고객19','고객입니다','CUSTOMER_19','CUSTOMER_19');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (20,'고객20','고객입니다','CUSTOMER_20','CUSTOMER_20');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (21,'고객21','고객입니다','CUSTOMER_21','CUSTOMER_21');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (22,'고객22','고객입니다','CUSTOMER_22','CUSTOMER_22');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (23,'고객23','고객입니다','CUSTOMER_23','CUSTOMER_23');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (24,'고객24','고객입니다','CUSTOMER_24','CUSTOMER_24');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (25,'고객25','고객입니다','CUSTOMER_25','CUSTOMER_25');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (26,'고객26','고객입니다','CUSTOMER_26','CUSTOMER_26');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (27,'고객27','고객입니다','CUSTOMER_27','CUSTOMER_27');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (28,'고객28','고객입니다','CUSTOMER_28','CUSTOMER_28');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (29,'고객29','고객입니다','CUSTOMER_29','CUSTOMER_29');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (30,'고객30','고객입니다','CUSTOMER_30','CUSTOMER_30');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (31,'고객31','고객입니다','CUSTOMER_31','CUSTOMER_31');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (32,'고객32','고객입니다','CUSTOMER_32','CUSTOMER_32');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (33,'고객33','고객입니다','CUSTOMER_33','CUSTOMER_33');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (34,'고객34','고객입니다','CUSTOMER_34','CUSTOMER_34');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (35,'고객35','고객입니다','CUSTOMER_35','CUSTOMER_35');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (36,'고객36','고객입니다','CUSTOMER_36','CUSTOMER_36');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (37,'고객37','고객입니다','CUSTOMER_37','CUSTOMER_37');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (38,'고객38','고객입니다','CUSTOMER_38','CUSTOMER_38');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (39,'고객39','고객입니다','CUSTOMER_39','CUSTOMER_39');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (40,'고객40','고객입니다','CUSTOMER_40','CUSTOMER_40');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (41,'고객41','고객입니다','CUSTOMER_41','CUSTOMER_41');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (42,'고객42','고객입니다','CUSTOMER_42','CUSTOMER_42');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (43,'고객43','고객입니다','CUSTOMER_43','CUSTOMER_43');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (44,'고객44','고객입니다','CUSTOMER_44','CUSTOMER_44');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (45,'고객45','고객입니다','CUSTOMER_45','CUSTOMER_45');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (46,'고객46','고객입니다','CUSTOMER_46','CUSTOMER_46');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (47,'고객47','고객입니다','CUSTOMER_47','CUSTOMER_47');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (48,'고객48','고객입니다','CUSTOMER_48','CUSTOMER_48');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (49,'고객49','고객입니다','CUSTOMER_49','CUSTOMER_49');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (50,'고객50','고객입니다','CUSTOMER_50','CUSTOMER_50');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (51,'고객51','고객입니다','CUSTOMER_51','CUSTOMER_51');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (52,'고객52','고객입니다','CUSTOMER_52','CUSTOMER_52');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (53,'고객53','고객입니다','CUSTOMER_53','CUSTOMER_53');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (54,'고객54','고객입니다','CUSTOMER_54','CUSTOMER_54');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (55,'고객55','고객입니다','CUSTOMER_55','CUSTOMER_55');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (56,'고객56','고객입니다','CUSTOMER_56','CUSTOMER_56');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (57,'고객57','고객입니다','CUSTOMER_57','CUSTOMER_57');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (58,'고객58','고객입니다','CUSTOMER_58','CUSTOMER_58');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (59,'고객59','고객입니다','CUSTOMER_59','CUSTOMER_59');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (60,'고객60','고객입니다','CUSTOMER_60','CUSTOMER_60');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (61,'고객61','고객입니다','CUSTOMER_61','CUSTOMER_61');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (62,'고객62','고객입니다','CUSTOMER_62','CUSTOMER_62');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (63,'고객63','고객입니다','CUSTOMER_63','CUSTOMER_63');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (64,'고객64','고객입니다','CUSTOMER_64','CUSTOMER_64');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (65,'고객65','고객입니다','CUSTOMER_65','CUSTOMER_65');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (66,'고객66','고객입니다','CUSTOMER_66','CUSTOMER_66');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (67,'고객67','고객입니다','CUSTOMER_67','CUSTOMER_67');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (68,'고객68','고객입니다','CUSTOMER_68','CUSTOMER_68');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (69,'고객69','고객입니다','CUSTOMER_69','CUSTOMER_69');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (70,'고객70','고객입니다','CUSTOMER_70','CUSTOMER_70');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (71,'고객71','고객입니다','CUSTOMER_71','CUSTOMER_71');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (72,'고객72','고객입니다','CUSTOMER_72','CUSTOMER_72');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (73,'고객73','고객입니다','CUSTOMER_73','CUSTOMER_73');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (74,'고객74','고객입니다','CUSTOMER_74','CUSTOMER_74');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (75,'고객75','고객입니다','CUSTOMER_75','CUSTOMER_75');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (76,'고객76','고객입니다','CUSTOMER_76','CUSTOMER_76');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (77,'고객77','고객입니다','CUSTOMER_77','CUSTOMER_77');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (78,'고객78','고객입니다','CUSTOMER_78','CUSTOMER_78');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (79,'고객79','고객입니다','CUSTOMER_79','CUSTOMER_79');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (80,'고객80','고객입니다','CUSTOMER_80','CUSTOMER_80');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (81,'고객81','고객입니다','CUSTOMER_81','CUSTOMER_81');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (82,'고객82','고객입니다','CUSTOMER_82','CUSTOMER_82');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (83,'고객83','고객입니다','CUSTOMER_83','CUSTOMER_83');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (84,'고객84','고객입니다','CUSTOMER_84','CUSTOMER_84');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (85,'고객85','고객입니다','CUSTOMER_85','CUSTOMER_85');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (86,'고객86','고객입니다','CUSTOMER_86','CUSTOMER_86');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (87,'고객87','고객입니다','CUSTOMER_87','CUSTOMER_87');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (88,'고객88','고객입니다','CUSTOMER_88','CUSTOMER_88');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (89,'고객89','고객입니다','CUSTOMER_89','CUSTOMER_89');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (90,'고객90','고객입니다','CUSTOMER_90','CUSTOMER_90');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (91,'고객91','고객입니다','CUSTOMER_91','CUSTOMER_91');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (92,'고객92','고객입니다','CUSTOMER_92','CUSTOMER_92');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (93,'고객93','고객입니다','CUSTOMER_93','CUSTOMER_93');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (94,'고객94','고객입니다','CUSTOMER_94','CUSTOMER_94');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (95,'고객95','고객입니다','CUSTOMER_95','CUSTOMER_95');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (96,'고객96','고객입니다','CUSTOMER_96','CUSTOMER_96');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (97,'고객97','고객입니다','CUSTOMER_97','CUSTOMER_97');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (98,'고객98','고객입니다','CUSTOMER_98','CUSTOMER_98');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (99,'고객99','고객입니다','CUSTOMER_99','CUSTOMER_99');
INSERT INTO `info_building_customer` (`ibcsn`,`title`,`description`,`code`,`thumbnail`) VALUES (100,'고객100','고객입니다','CUSTOMER_100','CUSTOMER_100');

-- InfoBuilding.xlsx / info_building_item
DELETE FROM `info_building_item`;
INSERT INTO `info_building_item` (`ibisn`,`ibsn`,`title`,`description`,`thumbnail`,`itemcode`,`open_building_grade`,`imsn`,`price`,`display_order`) VALUES (1,1,'의자1','의자입니다','CHAIR1','CHAIR',0,1,1000,1);
INSERT INTO `info_building_item` (`ibisn`,`ibsn`,`title`,`description`,`thumbnail`,`itemcode`,`open_building_grade`,`imsn`,`price`,`display_order`) VALUES (2,1,'의자2','의자입니다','CHAIR2','CHAIR',0,1,1000,2);
INSERT INTO `info_building_item` (`ibisn`,`ibsn`,`title`,`description`,`thumbnail`,`itemcode`,`open_building_grade`,`imsn`,`price`,`display_order`) VALUES (3,1,'의자3','의자입니다','CHAIR3','CHAIR',0,1,1000,3);
INSERT INTO `info_building_item` (`ibisn`,`ibsn`,`title`,`description`,`thumbnail`,`itemcode`,`open_building_grade`,`imsn`,`price`,`display_order`) VALUES (4,1,'의자4','의자입니다','CHAIR4','CHAIR',0,1,1000,4);

-- InfoBuilding.xlsx / info_building_item_level
DELETE FROM `info_building_item_level`;
INSERT INTO `info_building_item_level` (`ibisn`,`next_level`,`add_buff`,`need_imsn`,`need_price`) VALUES (1,1,0,1,10);
INSERT INTO `info_building_item_level` (`ibisn`,`next_level`,`add_buff`,`need_imsn`,`need_price`) VALUES (1,2,110,1,20);
INSERT INTO `info_building_item_level` (`ibisn`,`next_level`,`add_buff`,`need_imsn`,`need_price`) VALUES (1,3,120,1,30);
INSERT INTO `info_building_item_level` (`ibisn`,`next_level`,`add_buff`,`need_imsn`,`need_price`) VALUES (1,4,130,1,40);
INSERT INTO `info_building_item_level` (`ibisn`,`next_level`,`add_buff`,`need_imsn`,`need_price`) VALUES (1,5,140,1,50);

-- InfoBuilding.xlsx / info_building_manager
DELETE FROM `info_building_manager`;
INSERT INTO `info_building_manager` (`ibmsn`,`ibsn`,`icsn`,`title`,`description`,`thumbnail`,`buffcode`,`buffvalue`,`rarity`,`imsn`,`price`) VALUES (1,1001,1,'사랑 세포','점장 사랑 세포','MANAGER_1','ADDMONEY',20,0,1,0);
INSERT INTO `info_building_manager` (`ibmsn`,`ibsn`,`icsn`,`title`,`description`,`thumbnail`,`buffcode`,`buffvalue`,`rarity`,`imsn`,`price`) VALUES (2,1002,2,'말썽 세포','점장 말썽 세포','MANAGER_2','ADDMONEY',20,0,1,0);
INSERT INTO `info_building_manager` (`ibmsn`,`ibsn`,`icsn`,`title`,`description`,`thumbnail`,`buffcode`,`buffvalue`,`rarity`,`imsn`,`price`) VALUES (3,1003,3,'감정 세포','점장 감정 세포','MANAGER_3','ADDMONEY',20,0,1,0);
INSERT INTO `info_building_manager` (`ibmsn`,`ibsn`,`icsn`,`title`,`description`,`thumbnail`,`buffcode`,`buffvalue`,`rarity`,`imsn`,`price`) VALUES (4,1004,4,'이성 세포','점장 이성 세포','MANAGER_4','ADDMONEY',20,0,1,0);

-- InfoBuilding.xlsx / info_building_manager_level
DELETE FROM `info_building_manager_level`;
INSERT INTO `info_building_manager_level` (`ibmsn`,`next_level`,`add_buff`,`need_imsn_1`,`need_price_1`,`need_imsn_2`,`need_price_2`) VALUES (1,1,0,1,10,2,10);
INSERT INTO `info_building_manager_level` (`ibmsn`,`next_level`,`add_buff`,`need_imsn_1`,`need_price_1`,`need_imsn_2`,`need_price_2`) VALUES (1,2,110,1,20,2,20);
INSERT INTO `info_building_manager_level` (`ibmsn`,`next_level`,`add_buff`,`need_imsn_1`,`need_price_1`,`need_imsn_2`,`need_price_2`) VALUES (1,3,120,1,30,2,30);
INSERT INTO `info_building_manager_level` (`ibmsn`,`next_level`,`add_buff`,`need_imsn_1`,`need_price_1`,`need_imsn_2`,`need_price_2`) VALUES (1,4,130,1,40,2,40);
INSERT INTO `info_building_manager_level` (`ibmsn`,`next_level`,`add_buff`,`need_imsn_1`,`need_price_1`,`need_imsn_2`,`need_price_2`) VALUES (1,5,140,1,50,2,50);

-- InfoCard.xlsx / info_card_base
DELETE FROM `info_card_base`;
INSERT INTO `info_card_base` (`icbsn`,`title`,`description`,`thumbnail`) VALUES (1,'사랑 세포 카드 1','사랑의 세포 베스트 샷','THUMBNAIL1');
INSERT INTO `info_card_base` (`icbsn`,`title`,`description`,`thumbnail`) VALUES (2,'사랑 세포 카드 2','사랑의 세포 베스트 샷','THUMBNAIL2');
INSERT INTO `info_card_base` (`icbsn`,`title`,`description`,`thumbnail`) VALUES (3,'사랑 세포 카드 3','사랑의 세포 베스트 샷','THUMBNAIL3');
INSERT INTO `info_card_base` (`icbsn`,`title`,`description`,`thumbnail`) VALUES (4,'사랑 세포 카드 4','사랑의 세포 베스트 샷','THUMBNAIL4');
INSERT INTO `info_card_base` (`icbsn`,`title`,`description`,`thumbnail`) VALUES (5,'사랑 세포 카드 5','사랑의 세포 베스트 샷','THUMBNAIL5');
INSERT INTO `info_card_base` (`icbsn`,`title`,`description`,`thumbnail`) VALUES (6,'사랑 세포 카드 6','사랑의 세포 베스트 샷','THUMBNAIL6');

-- InfoCard.xlsx / info_card_index
DELETE FROM `info_card_index`;
INSERT INTO `info_card_index` (`icisn`,`title`,`description`,`thumbnail`) VALUES (1,'인덱스 노랑','노랑 인덱스입니다.','THUMBNAIL1');
INSERT INTO `info_card_index` (`icisn`,`title`,`description`,`thumbnail`) VALUES (2,'인덱스 파랑','파랑 인덱스입니다.','THUMBNAIL2');
INSERT INTO `info_card_index` (`icisn`,`title`,`description`,`thumbnail`) VALUES (3,'인덱스 빨강','빨강 인덱스입니다.','THUMBNAIL3');

-- InfoCard.xlsx / info_card_topholder
DELETE FROM `info_card_topholder`;
INSERT INTO `info_card_topholder` (`ictsn`,`title`,`description`,`thumbnail`) VALUES (1,'투명 탑홀더1','투명 탑홀더입니다.','THUMBNAIL1');
INSERT INTO `info_card_topholder` (`ictsn`,`title`,`description`,`thumbnail`) VALUES (2,'투명 탑홀더2','투명 탑홀더입니다.','THUMBNAIL2');
INSERT INTO `info_card_topholder` (`ictsn`,`title`,`description`,`thumbnail`) VALUES (3,'투명 탑홀더3','투명 탑홀더입니다.','THUMBNAIL3');

-- InfoCard.xlsx / info_card_sleeve
DELETE FROM `info_card_sleeve`;
INSERT INTO `info_card_sleeve` (`icssn`,`title`,`description`,`thumbnail`) VALUES (1,'투명 슬리브1','투명 슬리브입니다.','THUMBNAIL1');
INSERT INTO `info_card_sleeve` (`icssn`,`title`,`description`,`thumbnail`) VALUES (2,'투명 슬리브2','투명 슬리브입니다.','THUMBNAIL2');
INSERT INTO `info_card_sleeve` (`icssn`,`title`,`description`,`thumbnail`) VALUES (3,'투명 슬리브3','투명 슬리브입니다.','THUMBNAIL3');

-- InfoCard.xlsx / info_sticker
DELETE FROM `info_sticker`;
INSERT INTO `info_sticker` (`issn`,`title`,`description`,`thumbnail`) VALUES (1,'기본스티커1','기본 스티커입니다.','THUMBNAIL1');
INSERT INTO `info_sticker` (`issn`,`title`,`description`,`thumbnail`) VALUES (2,'기본스티커2','기본 스티커입니다.','THUMBNAIL2');
INSERT INTO `info_sticker` (`issn`,`title`,`description`,`thumbnail`) VALUES (3,'기본스티커3','기본 스티커입니다.','THUMBNAIL3');

-- InfoCashItem.xlsx / info_cash_item
DELETE FROM `info_cash_item`;
INSERT INTO `info_cash_item` (`icisn`,`cash_itemtype`,`title`,`description`,`thumbnail`,`code`,`ios_product_id`,`aos_product_id`) VALUES (1,1,'1000 캐시충전','캐시 1000 충전합니다.',NULL,'CASHCHARGE_1000','com.nwaple.springtime.cashcharge_1000','com.nwaple.springtime.cashcharge_1000');
INSERT INTO `info_cash_item` (`icisn`,`cash_itemtype`,`title`,`description`,`thumbnail`,`code`,`ios_product_id`,`aos_product_id`) VALUES (2,2,'광고제거(30일)','광고제거 아이템입니다.',NULL,'REMOVEAD_30','com.nwaple.springtime.removead_30','com.nwaple.springtime.removead_30');
INSERT INTO `info_cash_item` (`icisn`,`cash_itemtype`,`title`,`description`,`thumbnail`,`code`,`ios_product_id`,`aos_product_id`) VALUES (3,3,'패키지1','패키지 아이템입니다.',NULL,'PACKAGE_1','com.nwaple.springtime.package_1','com.nwaple.springtime.package_1');

-- InfoCashItem.xlsx / info_cash_itemtype
DELETE FROM `info_cash_itemtype`;
INSERT INTO `info_cash_itemtype` (`cash_itemtype`,`title`,`cash_itemtype_code`) VALUES (1,'캐쉬충전','ITEMTYPE_CASHCHARGE');
INSERT INTO `info_cash_itemtype` (`cash_itemtype`,`title`,`cash_itemtype_code`) VALUES (2,'광고제거','ITEMTYPE_REMOVEAD');
INSERT INTO `info_cash_itemtype` (`cash_itemtype`,`title`,`cash_itemtype_code`) VALUES (3,'패키지상품','ITEMTYPE_PACKAGE');

-- InfoCategory.xlsx / info_category
DELETE FROM `info_category`;
INSERT INTO `info_category` (`category`,`title`) VALUES ('ITEM','일반아이템');
INSERT INTO `info_category` (`category`,`title`) VALUES ('SPACE_ITEM','배치아이템');
INSERT INTO `info_category` (`category`,`title`) VALUES ('CASH_ITEM','캐쉬아이템');
INSERT INTO `info_category` (`category`,`title`) VALUES ('CELL','세포');
INSERT INTO `info_category` (`category`,`title`) VALUES ('MONEY','재화');

-- InfoCell.xlsx / info_cell
DELETE FROM `info_cell`;
INSERT INTO `info_cell` (`icsn`,`title`,`description`,`code`) VALUES (1,'사랑 세포','유미 사랑세포입니다.','CELL_LOVE');
INSERT INTO `info_cell` (`icsn`,`title`,`description`,`code`) VALUES (2,'사랑 세포2','유미 사랑세포입니다.','CELL_LOVE2');
INSERT INTO `info_cell` (`icsn`,`title`,`description`,`code`) VALUES (3,'사랑 세포3','유미 사랑세포입니다.','CELL_LOVE3');
INSERT INTO `info_cell` (`icsn`,`title`,`description`,`code`) VALUES (4,'사랑 세포4','유미 사랑세포입니다.','CELL_LOVE4');
INSERT INTO `info_cell` (`icsn`,`title`,`description`,`code`) VALUES (5,'사랑 세포5','유미 사랑세포입니다.','CELL_LOVE5');
INSERT INTO `info_cell` (`icsn`,`title`,`description`,`code`) VALUES (6,'사랑 세포5','유미 사랑세포입니다.','CELL_LOVE6');

-- InfoCell.xlsx / info_welcome_cell
DELETE FROM `info_welcome_cell`;

-- InfoGacha.xlsx / info_gacha
DELETE FROM `info_gacha`;
INSERT INTO `info_gacha` (`igsn`,`gachatype`,`title`,`description`,`thumbnail`,`imsn`,`price`,`display_order`) VALUES (1,1,'기본 가챠','기본 가챠입니다.',NULL,1,1000,1);
INSERT INTO `info_gacha` (`igsn`,`gachatype`,`title`,`description`,`thumbnail`,`imsn`,`price`,`display_order`) VALUES (2,2,'고급 가챠','고급 가챠입니다.',NULL,2,1000,2);

-- InfoGacha.xlsx / info_gachatype
DELETE FROM `info_gachatype`;
INSERT INTO `info_gachatype` (`gachatype`,`title`) VALUES (1,'아이템 가챠');
INSERT INTO `info_gachatype` (`gachatype`,`title`) VALUES (2,'배치아이템 가챠');
INSERT INTO `info_gachatype` (`gachatype`,`title`) VALUES (3,'세포 가챠');

-- InfoGacha.xlsx / info_gacha_item
DELETE FROM `info_gacha_item`;
INSERT INTO `info_gacha_item` (`igisn`,`igsn`,`category`,`gift_sn`,`gift_count`,`ratio`) VALUES (1,1,'ITEM',1,1,250);
INSERT INTO `info_gacha_item` (`igisn`,`igsn`,`category`,`gift_sn`,`gift_count`,`ratio`) VALUES (2,1,'ITEM',2,1,250);
INSERT INTO `info_gacha_item` (`igisn`,`igsn`,`category`,`gift_sn`,`gift_count`,`ratio`) VALUES (3,1,'SPACE_ITEM',1,1,250);
INSERT INTO `info_gacha_item` (`igisn`,`igsn`,`category`,`gift_sn`,`gift_count`,`ratio`) VALUES (4,1,'SPACE_ITEM',2,1,250);
INSERT INTO `info_gacha_item` (`igisn`,`igsn`,`category`,`gift_sn`,`gift_count`,`ratio`) VALUES (5,2,'ITEM',1,1,1000);

-- InfoGame.xlsx / info_game
DELETE FROM `info_game`;
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('INITIAL_BILL',10000);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('INITIAL_GEM',0);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('INITIAL_CELLSNACK',0);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('INITIAL_YUMICOIN',0);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('INITIAL_INVENTORY_MAXSIZE',200);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('INITIAL_CUSTOMER_COUNT',100);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('BILL_CHANGE_CHECK_THRESHOLD',10000);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('INGAME_DAY_DURATION_MINUTES',20);
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('ANDROID_PACKAGE_NAME','com.nwaple.springtime');
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('IOS_BUNDLE_ID','com.nwaple.springtime');
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('FIREBASE_DEV_PROJECT_ID','com-nwaple-springtime-dev');
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('FIREBASE_STAGE_PROJECT_ID','com-nwaple-springtime-dev');
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('FIREBASE_PROD_PROJECT_ID','com-nwaple-springtime-dev');
INSERT INTO `info_game` (`config_name`,`config_value`) VALUES ('MAX_OFFLINE_REWARD_MINUTES',120);

-- InfoItem.xlsx / info_item
DELETE FROM `info_item`;
INSERT INTO `info_item` (`iisn`,`itemtype`,`title`,`description`,`thumbnail`,`can_resell`,`resell_imsn`,`resell_price`,`max_stack_count`) VALUES (1,1,'조각','조각 아이템입니다.',NULL,'Y',1,100,1);
INSERT INTO `info_item` (`iisn`,`itemtype`,`title`,`description`,`thumbnail`,`can_resell`,`resell_imsn`,`resell_price`,`max_stack_count`) VALUES (2,2,'드링크','부스터 아이템입니다.',NULL,'N',1,100,20);

-- InfoItem.xlsx / info_itemtype
DELETE FROM `info_itemtype`;
INSERT INTO `info_itemtype` (`itemtype`,`title`,`itemtype_code`) VALUES (1,'일반','ITEMTYPE_NORMAL');
INSERT INTO `info_itemtype` (`itemtype`,`title`,`itemtype_code`) VALUES (2,'부스터아이템','ITEMTYPE_BUSTER');

-- InfoItem.xlsx / info_welcome_item
DELETE FROM `info_welcome_item`;

-- InfoLanguage.xlsx / info_language
DELETE FROM `info_language`;
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_cash_item','title','icisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_cash_item','description','icisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_category','title','category');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_cell','title','icsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_cell','description','icsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_item','title','iisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_item','description','iisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_itemtype','title','itemtype');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_money','title','imsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_msgcode','message','msgcode');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_msgcode','detail_message','msgcode');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_serverzone','title','servicetype');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_space','title','issn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_space','description','issn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_space_item','title','isisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_space_item','description','isisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_space_item','title','isisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_space_item','description','isisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_space_itemtype','title','space_itemtype');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_gacha','title','igsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_gacha','description','igsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_production','title','ipsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_production','description','ipsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_production_item','title','ipisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_production_item','description','ipisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_base','title','icbsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_base','description','icbsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_index','title','icisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_index','description','icisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_topholder','title','ictsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_topholder','description','ictsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_sleeve','title','icssn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_card_sleeve','description','icssn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_sticker','title','issn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_sticker','description','issn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building','title','ibsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building','description','ibsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building_manager','title','ibmsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building_manager','description','ibmsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_rarity','title','rarity');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building_item','title','ibisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building_item','description','ibisn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building_customer','title','ibcsn');
INSERT INTO `info_language` (`table_name`,`field_name`,`index_field_name`) VALUES ('info_building_customer','description','ibcsn');

-- InfoMoney.xlsx / info_money
DELETE FROM `info_money`;
INSERT INTO `info_money` (`imsn`,`title`,`moneycode`) VALUES (1,'지폐','BILL');
INSERT INTO `info_money` (`imsn`,`title`,`moneycode`) VALUES (2,'보석','GEM');
INSERT INTO `info_money` (`imsn`,`title`,`moneycode`) VALUES (3,'세포깡','CELLSNACK');
INSERT INTO `info_money` (`imsn`,`title`,`moneycode`) VALUES (4,'유미코인','YUMICOIN');

-- InfoMsgcode.xlsx / info_msgcode
DELETE FROM `info_msgcode`;
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_OK','성공',NULL);
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_DB_OK','성공',NULL);
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_DB_ERROR','실패','DB ERROR');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_DB_PARTIAL_ERROR','실패','DB ERROR');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_REQUEST_EMPTY','실패','POST로 전달된 값 중 request값이 빈값임');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_REQUEST_UNDEFINE','실패','POST로 전달된 값 중 request값에 대응되는 서버 로직이 없음.( 즉, 미구현 API )');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_REQUEST_INVALID','실패','data값을 schema.json 정의에 따라 decoding후 파라미터 정보를 확인했을 때 값이 이상한 경우');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_AUTH_FAIL','실패','인증 실패(usn,ts,k값 확인 필요)');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_AUTH_NO_HTTPS','실패','HTTPS로 호출했는지 확인 필요');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_AUTH_INVALID_TOKEN','실패','유니티 검증 실패( playerId, accessToken 확인 필요 )');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_INFO','실패','요청한 이름의 info파일이 서버에 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_DATA_NOT_FOUND','실패','request를 처리하기 위한 관련 데이터를 DB에서 찾을 수 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_LOGIN_ID_NOT_FOUND','실패',NULL);
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_USER_BLOCKED','실패','접속 제한 - block된 유저가 로그인을 시도할 경우');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_SERVICE_MAINTENANCE','실패','서비스 점검시간에는 연결할 수 없습니다');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_FRIEND_INVITE_SELF','실패','친구 - 자기 자신을 초대함');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_FRIEND_INVITE_ALREADY','실패','친구 - 초대한 유저를 또 친구초대함');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_FRIEND_ACCEPT_NOT_FOUND','실패','친구 - 수락하고자 하는 초대 정보가 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_FRIEND_REJECT_NOT_FOUND','실패','친구 - 거절하고자 하는 초대 정보가 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NICKNAME_INVALID','실패','유저 - 바꾸려는 닉네임이 형식에 맞지 않음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NICKNAME_DUPLICATED','실패','유저 - 바꾸려는 닉네임을 이미 쓰고 있음.');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ITEM_NOT_MYITEM','실패','아이템 - 지정된 isn이 해당 유저 소유가 아님');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ITEM_CANNOT_PLACE','실패','아이템 - 배치 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ITEM_LIMIT_MAXCOUNT','실패','아이템 - 지급 불가 / 인벤토리 용량 초과');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ITEM_CANNOT_INVALID_COUNT','실패','아이템 - 구매아이템 개수 오류');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_CELL_INFO','실패','세포 - 세포정보(icsn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_ITEM_INFO','실패','아이템 - 아이템정보(iisn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_MONEY_INFO','실패','재화 - 재화정보(imsn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_SHOP_INFO','실패','상점 - 상점정보(issn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_ITEM_SHOP_INFO','실패','상점 - 아이템상점정보(iisdsn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_SPACE_ITEM_SHOP_INFO','실패','상점 - 배치아이템상점정보(isisdsn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_CELL_SHOP_INFO','실패','상점 - 세포상점(icsdsn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_GACHA_INFO','실패','소환 - 소환정보(igsn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_GACHA_ITEM_INFO','실패','소환 - 소환아이템정보(igisn) 확인 불가');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_SPACEITEM_NOT_MYITEM','실패','공간아이템 - 지정된 sisn이 해당 유저 소유가 아님');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_SPACEITEM_CANNOT_PLACE','실패','공간아이템 - 배치된 아이템만 이동시킬 수 있음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_SPACEITEM_CANNOT_INVEN','실패','공간아이템 - 배치된 아이템만 가방에 다시 넣을 수 있음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_ENOUGH_BILL','실패','아이탬 구매 실패 - 보유한 골드가 부족함.');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_ENOUGH_GEM','실패','아이템 구매 실패 - 보유한 캐시가 부족함.');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_ANDROID_PACKAGE_NAME','실패','Android Package name이 없음.');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_IOS_BUNDLE_ID','실패','iOS Bundle ID가 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_FIREBASE_PROJECT_ID','실패','Firebase Project ID가 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_ANDROID_INVALID_PARAMETER','실패','Android 영수증 검증 - 상품 ID 또는 구매 토큰이 비어 있음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_ANDROID_SERVICE_ACCOUNT_NOT_CONFIGURED','실패','Android 영수증 검증 - Google Play 서비스 계정이 설정되지 않음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_ANDROID_JWT_SIGN_FAILED','실패','Android 영수증 검증 - Google Play JWT 서명 생성 실패');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_ANDROID_ACCESS_TOKEN_REQUEST_FAILED','실패','Android 영수증 검증 - Google OAuth 액세스 토큰 요청 또는 응답 오류');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_ANDROID_PURCHASE_REQUEST_FAILED','실패','Android 영수증 검증 - Google Play 구매 조회 요청 또는 응답 오류');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_ANDROID_TEST_PURCHASE_NOT_ALLOWED','실패','Android 영수증 검증 - 운영 서비스에서 테스트 구매를 허용하지 않음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_ANDROID_PURCHASE_NOT_COMPLETED','실패','Android 영수증 검증 - Google Play 구매가 완료 상태가 아님');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_IOS_INVALID_PARAMETER','실패','iOS 영수증 검증 - 영수증, 상품 ID 또는 거래 ID가 비어 있음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_IOS_PRODUCTION_REQUEST_FAILED','실패','iOS 영수증 검증 - App Store 프로덕션 영수증 검증 요청 또는 응답 오류');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_IOS_SANDBOX_NOT_ALLOWED','실패','iOS 영수증 검증 - 운영 서비스에서 샌드박스 영수증을 허용하지 않음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_IOS_SANDBOX_REQUEST_FAILED','실패','iOS 영수증 검증 - App Store 샌드박스 영수증 검증 요청 또는 응답 오류');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_IOS_INVALID_STATUS','실패','iOS 영수증 검증 - App Store 영수증 검증 상태가 성공이 아님');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_IOS_PURCHASE_MISMATCH','실패','iOS 영수증 검증 - 상품 ID 또는 거래 ID가 영수증과 일치하지 않음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_TOKEN_NOT_FOUND','실패','푸시발송 - 사용자에게 등록된 FCM push token이 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_INVALID_PARAMETER','실패','푸시발송 - FCM push token 또는 push 데이터가 올바르지 않음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_SERVICE_ACCOUNT_NOT_CONFIGURED','실패','푸시발송 - Firebase 서비스 계정이 설정되지 않음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_JWT_SIGN_FAILED','실패','푸시발송 - Firebase OAuth JWT 서명 생성 실패');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_ACCESS_TOKEN_REQUEST_FAILED','실패','푸시발송 - Google OAuth 액세스 토큰 요청 또는 응답 오류');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_PAYLOAD_ENCODE_FAILED','실패','푸시발송 - FCM 메시지 JSON 생성 실패');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_REQUEST_FAILED','실패','푸시발송 - FCM HTTP v1 요청 또는 응답 오류');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ERROR_PUSH_RESPONSE_INVALID','실패','푸시발송 - FCM 성공 응답에 메시지 ID가 없음');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_GACHA_CANNOT_DECIDE','실패','소환 - 소환아이템 확정 실패');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_BUILDING_INFO','실패','빌딩 - 빌딩정보(ibsn)가 없음.');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_BUILDING_ITEM_INFO','실패','빌딩 - 빌딩아이템 정보(ibisn)가 없음.');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_NOT_EXIST_BUILDING_MANAGER_INFO','실패','빌딩 - 빌딩매니져 정보(ibmsn)가 없음.');
INSERT INTO `info_msgcode` (`msgcode`,`message`,`detail_message`) VALUES ('MSGCODE_ITEM_INVALID_PRICE','실패','아이템 - 가격 정보 오류( > 0이어야 함. )');

-- InfoProduction.xlsx / info_production
DELETE FROM `info_production`;
INSERT INTO `info_production` (`ipsn`,`title`,`description`,`productioncode`) VALUES (1,'밭','농지입니다.','PRODUCTION_PARM');

-- InfoProduction.xlsx / info_production_item
DELETE FROM `info_production_item`;
INSERT INTO `info_production_item` (`ipisn`,`ipsn`,`title`,`description`,`thumbnail`,`open_imsn`,`open_price`) VALUES (1,1,'벼','생산입니다.',NULL,1,1000);
INSERT INTO `info_production_item` (`ipisn`,`ipsn`,`title`,`description`,`thumbnail`,`open_imsn`,`open_price`) VALUES (2,1,'쌀','생산입니다.',NULL,1,1000);

-- InfoRarity.xlsx / info_rarity
DELETE FROM `info_rarity`;
INSERT INTO `info_rarity` (`rarity`,`title`,`color`,`code`) VALUES (0,'일반','FFFFFF','COMMON');
INSERT INTO `info_rarity` (`rarity`,`title`,`color`,`code`) VALUES (1,'고급','00FF00','UNCOMMON');
INSERT INTO `info_rarity` (`rarity`,`title`,`color`,`code`) VALUES (2,'희귀','00BFFF','RARE');
INSERT INTO `info_rarity` (`rarity`,`title`,`color`,`code`) VALUES (3,'영웅','FF2400','EPIC');
INSERT INTO `info_rarity` (`rarity`,`title`,`color`,`code`) VALUES (4,'전설','B200FF','LEGENDARY');
INSERT INTO `info_rarity` (`rarity`,`title`,`color`,`code`) VALUES (5,'신화','FFDD00','MYTHIC');
INSERT INTO `info_rarity` (`rarity`,`title`,`color`,`code`) VALUES (6,'유일','00FFFF','UNIQUE');

-- InfoServerzone.xlsx / info_serverzone
DELETE FROM `info_serverzone`;
INSERT INTO `info_serverzone` (`servicetype`,`title`,`timezone_offset`) VALUES (102,'개발서버(한국)',9);

-- InfoShop.xlsx / info_shop
DELETE FROM `info_shop`;
INSERT INTO `info_shop` (`issn`,`shoptype`,`shopcode`,`title`,`description`,`thumbnail`,`is_show`,`display_order`) VALUES (1,1,'SHOP_NORMAL','기본 상점','기본 상점입니다.',NULL,'Y',1);
INSERT INTO `info_shop` (`issn`,`shoptype`,`shopcode`,`title`,`description`,`thumbnail`,`is_show`,`display_order`) VALUES (2,2,'SHOP_CASH','건물 상점','건물 상점입니다.',NULL,'Y',1);
INSERT INTO `info_shop` (`issn`,`shoptype`,`shopcode`,`title`,`description`,`thumbnail`,`is_show`,`display_order`) VALUES (3,1,'SHOP_NORMAL2','기본 상점2','기본 상점입니다.',NULL,'Y',2);
INSERT INTO `info_shop` (`issn`,`shoptype`,`shopcode`,`title`,`description`,`thumbnail`,`is_show`,`display_order`) VALUES (4,3,'SHOP_PLANT','건물 상점','건물 상점입니다.',NULL,'Y',1);

-- InfoShop.xlsx / info_shoptype
DELETE FROM `info_shoptype`;
INSERT INTO `info_shoptype` (`shoptype`,`title`) VALUES (1,'아이템 상점');
INSERT INTO `info_shoptype` (`shoptype`,`title`) VALUES (2,'캐쉬 상점');
INSERT INTO `info_shoptype` (`shoptype`,`title`) VALUES (3,'건물 상점');

-- InfoShop.xlsx / info_item_shop_display
DELETE FROM `info_item_shop_display`;
INSERT INTO `info_item_shop_display` (`iisdsn`,`issn`,`iisn`,`count`,`imsn`,`price`,`display_order`) VALUES (1,1,1,1,1,1000,1);
INSERT INTO `info_item_shop_display` (`iisdsn`,`issn`,`iisn`,`count`,`imsn`,`price`,`display_order`) VALUES (2,1,2,1,1,1000,2);
INSERT INTO `info_item_shop_display` (`iisdsn`,`issn`,`iisn`,`count`,`imsn`,`price`,`display_order`) VALUES (3,1,1,1,1,1000,3);
INSERT INTO `info_item_shop_display` (`iisdsn`,`issn`,`iisn`,`count`,`imsn`,`price`,`display_order`) VALUES (4,1,1,1,1,1000,4);

-- InfoShop.xlsx / info_space_item_shop_display
DELETE FROM `info_space_item_shop_display`;
INSERT INTO `info_space_item_shop_display` (`isisdsn`,`issn`,`isisn`,`imsn`,`price`,`display_order`) VALUES (1,1,1,1,1000,1);
INSERT INTO `info_space_item_shop_display` (`isisdsn`,`issn`,`isisn`,`imsn`,`price`,`display_order`) VALUES (2,1,2,1,1000,2);

-- InfoShop.xlsx / info_cell_shop_display
DELETE FROM `info_cell_shop_display`;
INSERT INTO `info_cell_shop_display` (`icsdsn`,`issn`,`icsn`,`imsn`,`price`,`display_order`) VALUES (1,1,1,1,1000,1);
INSERT INTO `info_cell_shop_display` (`icsdsn`,`issn`,`icsn`,`imsn`,`price`,`display_order`) VALUES (2,1,2,1,1000,2);
INSERT INTO `info_cell_shop_display` (`icsdsn`,`issn`,`icsn`,`imsn`,`price`,`display_order`) VALUES (3,1,3,1,1000,3);
INSERT INTO `info_cell_shop_display` (`icsdsn`,`issn`,`icsn`,`imsn`,`price`,`display_order`) VALUES (4,1,4,1,1000,4);

-- InfoSpace.xlsx / info_space
DELETE FROM `info_space`;
INSERT INTO `info_space` (`issn`,`title`,`description`,`world`) VALUES (1,'기본섬','기본섬 입니다.','DEFAULT');

-- InfoSpaceItem.xlsx / info_space_item
DELETE FROM `info_space_item`;
INSERT INTO `info_space_item` (`isisn`,`space_itemtype`,`title`,`description`,`model`,`thumbnail`,`width`,`height`,`depth`,`rotate_y`,`can_resell`,`resell_imsn`,`resell_price`,`can_place_on_top`) VALUES (1,1,'조각','조각 아이템입니다.','si_1',NULL,1,1,1,0,'Y',1,100,'Y');
INSERT INTO `info_space_item` (`isisn`,`space_itemtype`,`title`,`description`,`model`,`thumbnail`,`width`,`height`,`depth`,`rotate_y`,`can_resell`,`resell_imsn`,`resell_price`,`can_place_on_top`) VALUES (2,2,'발전소','발전소 아이템입니다.','si_2',NULL,2,1,2,0,'N',1,100,'N');

-- InfoSpaceItem.xlsx / info_space_itemtype
DELETE FROM `info_space_itemtype`;
INSERT INTO `info_space_itemtype` (`space_itemtype`,`title`,`space_itemtype_code`) VALUES (1,'일반','ITEMTYPE_NORMAL');
INSERT INTO `info_space_itemtype` (`space_itemtype`,`title`,`space_itemtype_code`) VALUES (2,'발전소','ITEMTYPE_PLANT');

-- InfoSpaceItem.xlsx / info_welcome_space_item
DELETE FROM `info_welcome_space_item`;

-- InfoUserLevel.xlsx / info_user_level
DELETE FROM `info_user_level`;
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (1,0,0);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (2,4,4);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (3,8,12);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (4,16,28);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (5,32,60);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (6,64,124);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (7,128,252);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (8,256,508);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (9,512,1020);
INSERT INTO `info_user_level` (`level`,`required_exp`,`required_total_exp`) VALUES (10,1024,2044);

-- InfoUserLevel.xlsx / info_user_levelup_reward
DELETE FROM `info_user_levelup_reward`;
INSERT INTO `info_user_levelup_reward` (`iulrsn`,`level`,`category`,`gift_sn`,`gift_count`) VALUES (1,2,'ITEM',1,1);
INSERT INTO `info_user_levelup_reward` (`iulrsn`,`level`,`category`,`gift_sn`,`gift_count`) VALUES (2,2,'SPACE_ITEM',1,1);
INSERT INTO `info_user_levelup_reward` (`iulrsn`,`level`,`category`,`gift_sn`,`gift_count`) VALUES (3,2,'CELL',1,1);
INSERT INTO `info_user_levelup_reward` (`iulrsn`,`level`,`category`,`gift_sn`,`gift_count`) VALUES (4,2,'MONEY',1,2000);

COMMIT;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
