/*==============================================================*/
/* Table: T_EB_ADJUSTPROJECT      调整方案增加自定义维度        */
/*==============================================================*/

 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM21') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM21 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM22') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM22 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM23') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM23 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM24') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM24 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM25') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM25 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM26') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM26 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM27') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM27 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM28') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM28 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM29') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM29 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM30') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM30 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM31') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM31 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM32') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM32 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM33') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM33 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM34') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM34 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM35') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM35 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM36') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM36 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM37') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM37 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM38') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM38 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM39') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM39 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM40') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM40 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM41') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM41 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM42') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM42 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM43') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM43 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM44') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM44 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM45') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM45 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM46') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM46 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM47') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM47 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM48') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM48 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM49') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM49 BIGINT DEFAULT 0 NOT NULL);
 
   IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ADJUSTPROJECT' AND KSQL_COL_NAME ='FADJCUSTOMDIM50') 
 ALTER TABLE T_EB_ADJUSTPROJECT ADD (FADJCUSTOMDIM50 BIGINT DEFAULT 0 NOT NULL);
 
