/**Begin C:\Users\RD_geores_li\Desktop\开发工具箱\PDM_UPGRADE\PDMNEW\FPM_table.sql **/

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_MEMBER' AND KSQL_COL_NAME IN ('FSOURCEID')) 
 ALTER TABLE T_FPM_MEMBER ADD (FSOURCEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_MEMBER' AND KSQL_COL_NAME IN ('FSOURCEPARENTID')) 
 ALTER TABLE T_FPM_MEMBER ADD (FSOURCEPARENTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_MEMBER' AND KSQL_COL_NAME IN ('FSERIAL')) 
 ALTER TABLE T_FPM_MEMBER ADD (FSERIAL BIGINT DEFAULT 0 NOT NULL );

/**End C:\Users\RD_geores_li\Desktop\开发工具箱\PDM_UPGRADE\PDMNEW\FPM_table.sql **/
