/**Begin D:\PDM_UPGRADE\PDM1\FPM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_REPORTPREPARATION' AND KSQL_COL_NAME IN ('FFIXEDFREQUENCY'))
ALTER TABLE T_FPM_REPORTPREPARATION ADD (FFIXEDFREQUENCY CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_REPORTPREPARATION' AND KSQL_COL_NAME IN ('FFIXEDFREQUENCYSTARTTYPE'))
ALTER TABLE T_FPM_REPORTPREPARATION ADD (FFIXEDFREQUENCYSTARTTYPE NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_REPORTPREPARATION' AND KSQL_COL_NAME IN ('FFIXEDFREQUENCYSTARTDATE'))
ALTER TABLE T_FPM_REPORTPREPARATION ADD (FFIXEDFREQUENCYSTARTDATE NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_REPORTPREPARATION' AND KSQL_COL_NAME IN ('FFIXEDFREQUENCYENDTYPE'))
ALTER TABLE T_FPM_REPORTPREPARATION ADD (FFIXEDFREQUENCYENDTYPE NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_REPORTPREPARATION' AND KSQL_COL_NAME IN ('FFIXEDFREQUENCYENDDATE'))
ALTER TABLE T_FPM_REPORTPREPARATION ADD (FFIXEDFREQUENCYENDDATE NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_REPORTPREPARATION' AND KSQL_COL_NAME IN ('FFIXEDFREQUENCYENDTIME'))
ALTER TABLE T_FPM_REPORTPREPARATION ADD (FFIXEDFREQUENCYENDTIME INT DEFAULT -1 NOT NULL );

/**End D:\PDM_UPGRADE\PDM1\FPM_table.sql **/
