You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
43 lines
1014 B
Plaintext
43 lines
1014 B
Plaintext
|
|
|
|
insert t_sys_parameters
|
|
(PA_ID,参数类别,说明)
|
|
values(22,'海运费方案设置','海运费方案设置')
|
|
|
|
insert t_sys_parameters_value
|
|
(VL_ID,PA_ID,参数名称,参数值)
|
|
values(2201,22,'是否生成多条费用','FALSE')
|
|
|
|
insert t_sys_parameters_value
|
|
(VL_ID,PA_ID,参数名称,参数值)
|
|
values(2202,22,'佣金1费用名称','')
|
|
|
|
insert t_sys_parameters_value
|
|
(VL_ID,PA_ID,参数名称,参数值)
|
|
values(2203,22,'佣金2费用名称','')
|
|
|
|
insert t_sys_parameters_value
|
|
(VL_ID,PA_ID,参数名称,参数值)
|
|
values(2204,22,'佣金3费用名称','')
|
|
|
|
insert t_sys_parameters_value
|
|
(VL_ID,PA_ID,参数名称,参数值)
|
|
values(2205,22,'佣金4费用名称','')
|
|
|
|
insert t_sys_parameters_value
|
|
(VL_ID,PA_ID,参数名称,参数值)
|
|
values(2206,22,'佣金5费用名称','')
|
|
|
|
insert t_sys_parameters_value
|
|
(VL_ID,PA_ID,参数名称,参数值)
|
|
values(2207,22,'佣金6费用名称','')
|
|
|
|
|
|
ALTER TABLE T_CH_FEE
|
|
ADD 方案费用名称 varchar(50)
|
|
|
|
|
|
ALTER TABLE [dbo].[t_ch_fee] ADD CONSTRAINT [DF__ch_fee__famc] DEFAULT ('') FOR [方案费用名称]
|
|
GO
|
|
|
|
update t_ch_fee set 方案费用名称='' where 方案费用名称 is null |