Re: ORT　Stage 2 -9　の一部復活

/* ORT Stage 1+ */
update m_syuppan
set cd_series_gr = '0032',
nm_level_gr =1,
nm_yle=0.1,
nm_yls=0.1,
nm_yl_a=0.1,
dt_size= 'ORT-M',
nm_vert= 192,
nm_horz= 168
where
cd_series_gr is null
and (dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage 1+' or dt_series ~ 'Stage1+'
or dt_syuppan ~ 'Stage1+' or dt_syuppan ~ 'Stage 1+')
;

/* ORT Stage 1 */
update m_syuppan
set cd_series_gr = '0031',
nm_level_gr =1,
nm_yle=0.1,
nm_yls=0.1,
nm_yl_a=0.1,
dt_size= 'ORT-M',
nm_vert= 192,
nm_horz= 168
where
cd_series_gr is null
and (dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage1' or dt_series ~ 'Stage 1'
or dt_syuppan ~ 'Stage1' or dt_syuppan ~ 'Stage 1')

/* ORT Stage 2 */
update m_syuppan
set cd_series_gr = '0033',
nm_level_gr =2,
nm_yle=0.2,
nm_yls=0.2,
nm_yl_a=0.2,
dt_size= 'ORT-M',
nm_vert= 192,
nm_horz= 168
where
cd_series_gr is null
and (dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage2' or dt_series ~ 'Stage 2'
or dt_syuppan ~ 'Stage2' or dt_syuppan ~ 'Stage 2')
;
/* ORT Stage 3 */
update m_syuppan
set cd_series_gr = '0034',
nm_level_gr =3,
nm_yle=0.3,
nm_yls=0.3,
nm_yl_a=0.3,
dt_size= 'ORT-M',
nm_vert= 192,
nm_horz= 168
where
cd_series_gr is null
and (dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage3' or dt_series ~ 'Stage 3'
or dt_syuppan ~ 'Stage3' or dt_syuppan ~ 'Stage 3')
;

/* ORT Stage 4 */
update m_syuppan
set cd_series_gr = '0035',
nm_level_gr =4,
nm_yle=0.4,
nm_yls=0.4,
nm_yl_a=0.4,
dt_size= 'ORT-M',
nm_vert= 192,
nm_horz= 168
where
cd_series_gr is null
and (dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage4' or dt_series ~ 'Stage 4'
or dt_syuppan ~ 'Stage4' or dt_syuppan ~ 'Stage 4')

;

/* ORT Stage 5 */
update m_syuppan
set cd_series_gr = '0036',
nm_level_gr =5,
nm_yle=0.5,
nm_yls=0.5,
nm_yl_a=0.5,
dt_size= 'ORT-M',
nm_vert= 192,
nm_horz= 168
where
cd_series_gr is null and
(dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage5' or dt_series ~ 'Stage 5'
or dt_syuppan ~ 'Stage5' or dt_syuppan ~ 'Stage 5'
or dt_syuppan ~ 'stage 5' )
;

/* ORT Stage 6 */
update m_syuppan
set cd_series_gr = '0037',
nm_level_gr =6,
nm_yle=0.6,
nm_yls=0.6,
nm_yl_a=0.6,
dt_size= 'ORT-L',
nm_vert= 216,
nm_horz= 165
where
cd_series_gr is null and
(dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage6' or dt_series ~ 'Stage 6'
or dt_syuppan ~ 'Stage6' or dt_syuppan ~ 'Stage 6')
;

/* ORT Stage 7 */
update m_syuppan
set cd_series_gr = '0038',
nm_level_gr =7,
nm_yle=0.7,
nm_yls=0.7,
nm_yl_a=0.7,
dt_size= 'ORT-L',
nm_vert= 216,
nm_horz= 165
where
cd_series_gr is null and
(dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage7' or dt_series ~ 'Stage 7'
or dt_syuppan ~ 'Stage7' or dt_syuppan ~ 'Stage 7')
;

/* ORT Stage 8 */
update m_syuppan
set cd_series_gr = '0039',
nm_level_gr =8,
nm_yle=0.9,
nm_yls=0.9,
nm_yl_a=0.9,
dt_size= 'ORT-L',
nm_vert= 216,
nm_horz= 165
where
cd_series_gr is null and
(dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage8' or dt_series ~ 'Stage 8'
or dt_syuppan ~ 'Stage8' or dt_syuppan ~ 'Stage 8')
;

/* ORT Stage 9 */
update m_syuppan
set cd_series_gr = '0040',
nm_level_gr =9,
nm_yle=1,
nm_yls=1,
nm_yl_a=1,
dt_size= 'ORT-L',
nm_vert= 216,
nm_horz= 165
where
cd_series_gr is null and
(dt_series ~ 'Oxford Reading' or dt_syuppan ~ 'Oxford Reading' )
and
( dt_series ~ 'Stage9' or dt_series ~ 'Stage 9'
or dt_syuppan ~ 'Stage9' or dt_syuppan ~ 'Stage 9')