I CAN READ Series の再設定

I CAN READ seriesの　ＹＬ　を再設定しました。

＃個別にＹＬを設定してあったものについて
　データの個別チェックが必要

＃次回からは、where節に
[url:http://www.seg.co.jp/cgi-bin/kb7.cgi?b=sss-admin&c=e&id=431]
と
[url:http://www.seg.co.jp/cgi-bin/kb7.cgi?b=sss-admin&c=e&id=428]
のチェックもいれるべき

-----------------------------------------------
update m_syuppan
set cd_series_gr = '0069',
nm_level_gr =0,
nm_yle=0.3,
nm_yls=0.3,
nm_yl_a=0.3,
dt_size= 'A5',
nm_vert= 215,
nm_horz= 139
where
cd_series_gr is null
and (dt_series ~ 'I Can Read' or dt_series ~ 'I Can Read' )
and ( dt_series ~ 'Level 0' or dt_series ~ 'Level0'
or dt_syuppan ~ 'Level 0' or dt_syuppan ~ 'Level0'
or dt_series ~ 'My First' or dt_series ~ 'MY FIRST')
20行処理されました。(797 msec.)
--------------------------------------------------------------------------------

/* ICR Level 0 */
update m_syuppan
set cd_series_gr = '0069',
nm_level_gr =0,
nm_yle=0.3,
nm_yls=0.3,
nm_yl_a=0.3,
dt_size= 'A5',
nm_vert= 215,
nm_horz= 139
where
cd_series_gr is null
and
(dt_series ~ 'I Can Read' or dt_series ~ 'I Can Read' )
and
( dt_series ~ 'Level 0' or dt_series ~ 'Level0'
or dt_syuppan ~ 'Level 0' or dt_syuppan ~ 'Level0'
or dt_series ~ 'My First' or dt_series ~ 'MY FIRST')
0行処理されました。(31 msec.)
--------------------------------------------------------------------------------
/* ICR Level 1 with YL */
update m_syuppan
set cd_series_gr = '0070',
nm_level_gr =1,
dt_size= 'A5',
nm_vert= 215,
nm_horz= 139
where
cd_series_gr is null
and (dt_series ~ 'I Can Read' or dt_series ~ 'I Can Read' )
and ( dt_series ~ 'Level 1' or dt_series ~ 'Level1'
or dt_syuppan ~ 'Level 1' or dt_syuppan ~ 'Level1'
)
and (nm_yle is not null and nm_yle <= 10 )
42行処理されました。(110 msec.)
--------------------------------------------------------------------------------
/* ICR Level 1 without YL */
update m_syuppan
set cd_series_gr = '0070',
nm_level_gr =1,
nm_yle=0.4,
nm_yls=0.6,
nm_yl_a=0.5,
dt_size= 'A5',
nm_vert= 215,
nm_horz= 139
where
cd_series_gr is null
and (dt_series ~ 'I Can Read' or dt_series ~ 'I Can Read' )
and ( dt_series ~ 'Level 1' or dt_series ~ 'Level1'
or dt_syuppan ~ 'Level 1' or dt_syuppan ~ 'Level1'
)
and (nm_yle is null or nm_yle= 99)
0行処理されました。(32 msec.)

/* I CAN Read Level 2 */

update m_syuppan
set cd_series_gr = '0071',
nm_level_gr =2,
nm_yle=1.2,
nm_yls=1.6,
nm_yl_a=1.4,
dt_size= 'A5',
nm_vert= 215,
nm_horz= 139
where

(dt_series ~ 'I Can Read' or dt_series ~ 'I Can Read' )
and ( dt_series ~ 'Level 2' or dt_series ~ 'Level2'
or dt_syuppan ~ 'Level 2' or dt_syuppan ~ 'Level2'
)

80行処理されました。(140 msec.)

---------------------------------------------------------------
/* ICR Level 3 with/without YL
YL は移行されていないデータの方が圧倒的に多いので
　ここは、一律に一度設定しなおすことにする　*/
update m_syuppan
set cd_series_gr = '0072',
nm_level_gr =3,
nm_yle=1.6,
nm_yls=2.0,
nm_yl_a=1.8,
dt_size= 'A5',
nm_vert= 215,
nm_horz= 139
where
/* cd_series_gr is null and */
(dt_series ~ 'I Can Read' or dt_series ~ 'I Can Read' )
and ( dt_series ~ 'Level 3' or dt_series ~ 'Level3'
or dt_syuppan ~ 'Level 3' or dt_syuppan ~ 'Level3'
)

34行処理されました。(94 msec.)