?@?Beshop?t?C?]eshop5?B???R??a?B?p?H?B?????- ?b?`????z?Z?O-????-????]???????]?m

?G?B?M??t?C??????10?B?M???B?M??0?B??????3?B????????????017??
--??????O????
IF NOT EXISTS (SELECT NULL FROM t_sys_system WHERE sys_var_id = 'kz_version')
INSERT INTO t_sys_system (sys_var_id, sys_var_name, sys_var_value, is_changed, sys_ver_flag, branch_no)
VALUES ('kz_version','????????','2.0','??,'1','000')
ELSE
UPDATE t_sys_system SET sys_var_value = '2.0', branch_no = '000'
WHERE sys_var_id = 'kz_version'


--???????O????
DELETE FROM t_sys_system WHERE sys_var_id = 'kz_version'


?T?B????

--?}?????
If Not Exists(select 1 from t_sys_system where sys_var_id = 'kezhi_version_model')
insert into t_sys_system (sys_var_id,sys_var_name,sys_var_value)
values('kezhi_version_model','???????O????','1')
Else
update t_sys_system set sys_var_value = '1' where sys_var_id = 'kezhi_version_model'

--???????O
delete from t_sys_system where sys_var_id='kezhi_version_model'

???B?????   hbposev9 

--??????O????
IF NOT EXISTS (SELECT NULL FROM t_sys_system WHERE sys_var_id = 'kz_version')
INSERT INTO t_sys_system (sys_var_id, sys_var_name, sys_var_value, is_changed, sys_ver_flag)
VALUES ('kz_version','????????','2.0','??,'1')
ELSE
UPDATE t_sys_system SET sys_var_value = '2.0'
WHERE sys_var_id = 'kz_version'

--???????O????
DELETE FROM t_sys_system WHERE sys_var_id = 'kz_version'

???B????   hbposepro

-- ?}????O?\??
IF NOT EXISTS (SELECT NULL FROM t_sys_system WHERE sys_var_id = 'kz_version')
INSERT INTO t_sys_system (sys_var_id, sys_var_name, sys_var_value, is_changed, sys_ver_flag)
VALUES ('kz_version','????????','2.0','??,'1')
ELSE
UPDATE t_sys_system SET sys_var_value = '2.0'
WHERE sys_var_id = 'kz_version'


--???????O????
DELETE FROM t_sys_system WHERE sys_var_id = 'kz_version'