/**预置控制记录表字段 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGCONTROLRECORD' AND KSQL_COL_NAME ='FOCCTYPE') 
 ALTER TABLE T_EB_BGCONTROLRECORD ADD (FOCCTYPE nvarchar(80) not null default ' ');

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGCONTROLRECORD' AND KSQL_COL_NAME ='FBGMEMBERJSON') 
 ALTER TABLE T_EB_BGCONTROLRECORD ADD (FBGMEMBERJSON NVARCHAR(1000) not null default ' ');