hogehoge.sql

/home/inoue/PycharmProjects/auto-update-reservation/venv/bin/python /home/inoue/PycharmProjects/auto-update-reservation/main.py
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
80
80
80
80
80
80
80
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
81
81
81
81
81
81
81
81
81
81
81
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
120
120
120
120
120
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
173
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='6', `charge`='23480' WHERE `reservation_id`='145793';
173
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='6', `charge`='23480' WHERE `reservation_id`='145794';
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145813';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145814';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145815';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145816';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145817';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145818';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145819';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145820';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145821';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145822';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145823';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145824';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145825';
179
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='5', `charge`='19740' WHERE `reservation_id`='145826';
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
---
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146095';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146096';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146097';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146098';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146099';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146100';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146101';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146102';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146103';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146104';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146105';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146106';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146107';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146108';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146109';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146110';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146111';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146112';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146113';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146114';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146115';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146116';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146117';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146118';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146119';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146120';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146121';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146122';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146123';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146124';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146125';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146126';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146127';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146128';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146129';
113
UPDATE `pms`.`charge_setting` SET `room_type_id`='7', `plan_id`='2', `charge`='12920' WHERE `reservation_id`='146130';
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146157';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146158';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146159';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146160';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146161';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146162';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146163';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146164';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146165';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146166';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146167';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146168';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146169';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146170';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146171';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146172';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146173';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146174';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146175';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146176';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146177';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146178';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146179';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146180';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='68640' WHERE `reservation_id`='146181';
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
101
101
101
101
101
101
101
101
101
101
101
101
101
80
101
101
101
101
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
90
90
90
90
90
90
90
90
90
90
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146503';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146504';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146505';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146506';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146507';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146508';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146509';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146510';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146511';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146512';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146513';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146514';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146515';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146516';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146517';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146518';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146519';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146520';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146521';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146522';
176
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='7', `charge`='17380' WHERE `reservation_id`='146523';
100
100
100
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='21940' WHERE `reservation_id`='146532';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='21940' WHERE `reservation_id`='146533';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='21940' WHERE `reservation_id`='146534';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='21940' WHERE `reservation_id`='146535';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='21940' WHERE `reservation_id`='146536';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='21940' WHERE `reservation_id`='146537';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='21940' WHERE `reservation_id`='146538';
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146562';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146563';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146564';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146565';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146566';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146567';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146568';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146569';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146570';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146571';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146572';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146573';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146574';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146575';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146576';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146577';
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='24520' WHERE `reservation_id`='146578';
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146645';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146646';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146647';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146648';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146649';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146650';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146651';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146652';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146653';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146654';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146655';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146656';
92
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='1', `charge`='54756' WHERE `reservation_id`='146657';
100
100
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
131
70
70
70
70
70
70
70
70
86
86
86
86
86
86
86
86
86
86
86
86
86
86
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
100
100
100
100
100
100
100
100
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146919';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146920';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146921';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146922';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146923';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146924';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146925';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146926';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146927';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146928';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146929';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146930';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146931';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146932';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146933';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146934';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146935';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146936';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146937';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146938';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146939';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146940';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146941';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146942';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146943';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146944';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146945';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146946';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146947';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146948';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146949';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146950';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146951';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146952';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146953';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146954';
94
UPDATE `pms`.`charge_setting` SET `room_type_id`='5', `plan_id`='9', `charge`='22080' WHERE `reservation_id`='146955';
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
90
90
90
90
90
90
80
80
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
120
120
120
101
101
101
101
101
101
101
101
101
101
101
101
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
194
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
80
80
80
80
80
80
80
80
80
80
80
80
80
110
110
110
110
110
110
110
110
110
110
110
110
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
80
80
80
80
80
80
80
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147512';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147513';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147514';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147515';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147516';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147517';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147518';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147519';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147520';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147521';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147522';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147523';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147524';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147525';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147526';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147527';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147528';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147529';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147530';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147531';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147532';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147533';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147534';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147535';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147536';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147537';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147538';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147539';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147540';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147541';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147542';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147543';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147544';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147545';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147546';
180
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='6', `charge`='12800' WHERE `reservation_id`='147547';
100
100
100
81
81
81
81
81
81
81
81
81
81
81
81
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
110
110
110
110
110
110
110
110
110
110
110
110
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
70
70
70
70
70
70
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
125
UPDATE `pms`.`charge_setting` SET `room_type_id`='8', `plan_id`='4', `charge`='48520' WHERE `reservation_id`='147762';
125
UPDATE `pms`.`charge_setting` SET `room_type_id`='8', `plan_id`='4', `charge`='48520' WHERE `reservation_id`='147763';
125
UPDATE `pms`.`charge_setting` SET `room_type_id`='8', `plan_id`='4', `charge`='48520' WHERE `reservation_id`='147764';
80
80
80
80
80
80
80
80
80
80
80
80
118
118
108
108
108
108
108
108
108
108
108
108
108
108
108
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
70
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
121
106
106
106
106
106
106
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
86
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
86
121
121
121
121
121
121
121
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='174680' WHERE `reservation_id`='148211';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='174680' WHERE `reservation_id`='148212';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='174680' WHERE `reservation_id`='148213';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='174680' WHERE `reservation_id`='148214';
143
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='8', `charge`='174680' WHERE `reservation_id`='148215';
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
90
101
101
101
101
101
101
101
101
101
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
106
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148280';
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148281';
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148282';
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148283';
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148284';
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148285';
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148286';
83
UPDATE `pms`.`charge_setting` SET `room_type_id`='2', `plan_id`='2', `charge`='11260' WHERE `reservation_id`='148287';
80
80
121
121
121
121
121
121
121
121
121
121
121
121
121
121
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
80
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
120
100
100
100
100
100
100
100
100
100
100
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
80
80
80
80
80
80
80
80
80
80
100
100
100
100
100
100
100
100
100
90
90
90
90
90
90
90
90
90
90
90
90
100
100
100
100
100
100
100
100
100
100
100
100
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
91
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
81
86
86
100
100
100
100
100
100
111
111
111
111
111
111
111
111
111
90
90
103
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='2', `charge`='8960' WHERE `reservation_id`='148584';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='27600' WHERE `reservation_id`='148585';
178
UPDATE `pms`.`charge_setting` SET `room_type_id`='6', `plan_id`='7', `charge`='27600' WHERE `reservation_id`='148586';
100
100
90
100
100
100
80
101

Process finished with exit code 0