/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGCONTROLBIZREG' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_BGCONTROLBIZREG ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BIZRULECATALOG' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_BIZRULECATALOG ADD (FFULLNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BIZRULECATALOG' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_BIZRULECATALOG ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BIZRULEGROUP' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_BIZRULEGROUP ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BIZRULEVERSION' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_BIZRULEVERSION ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BIZRULEVERSION' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_BIZRULEVERSION ADD (FDESCRIPTION NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DATASETCATALOG' AND KSQL_COL_NAME IN('FNAME1')) ALTER TABLE T_EB_DATASETCATALOG ADD (FNAME1 NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DATASETCATALOG' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_DATASETCATALOG ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSIONBASETEST' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_DIMENSIONBASETEST ADD (FSIMPLENAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSIONBASETEST' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_DIMENSIONBASETEST ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSIONBASETEST' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_DIMENSIONBASETEST ADD (FDESCRIPTION NVARCHAR(1020) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSIONTEST' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_DIMENSIONTEST ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSIONTEST' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_DIMENSIONTEST ADD (FDESCRIPTION NVARCHAR(1020) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSIONTEST' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_DIMENSIONTEST ADD (FSIMPLENAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSION' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_DIMENSION ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMENSION' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_DIMENSION ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMMEMBERCATA' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_DIMMEMBERCATA ADD (FDESCRIPTION NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMMEMBERMAPPING' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_DIMMEMBERMAPPING ADD (FNAME NVARCHAR(400) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DIMMEMBERMAPPING' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_DIMMEMBERMAPPING ADD (FFULLNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ENTITYNAMERECORD' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_ENTITYNAMERECORD ADD (FNAME NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_ENTITYNAMERECORD' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_ENTITYNAMERECORD ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_MEMBERPERM' AND KSQL_COL_NAME IN('FMEMBERNAME')) ALTER TABLE T_EB_MEMBERPERM ADD (FMEMBERNAME NVARCHAR(400) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_MEMBERPERM' AND KSQL_COL_NAME IN('FUSERNAME')) ALTER TABLE T_EB_MEMBERPERM ADD (FUSERNAME NVARCHAR(400) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_MODELPERM' AND KSQL_COL_NAME IN('FUSERNAME')) ALTER TABLE T_EB_MODELPERM ADD (FUSERNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_MODEL' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_MODEL ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_MODEL' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_MODEL ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_OFFSETRULECATALOG' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_OFFSETRULECATALOG ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_OFFSETRULECATALOG' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_OFFSETRULECATALOG ADD (FFULLNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_OFFSETRULE' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_OFFSETRULE ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_OFFSETRULE' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_OFFSETRULE ADD (FDESCRIPTION NVARCHAR(400) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_PJOTEMPLATECATA' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_PJOTEMPLATECATA ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_PJOTEMPLATECATA' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_PJOTEMPLATECATA ADD (FDESCRIPTION NVARCHAR(500) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_REPORTCATALOG' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_REPORTCATALOG ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_REPORTCATALOG' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_REPORTCATALOG ADD (FFULLNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_REPORTSHARE' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_REPORTSHARE ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_SCHEMECATALOG' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_SCHEMECATALOG ADD (FNAME NVARCHAR(510) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_SCHEMECATALOG' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_SCHEMECATALOG ADD (FFULLNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_SCHEMEENTRY' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_SCHEMEENTRY ADD (FNAME NVARCHAR(510) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_SCHEMEENTRY' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_SCHEMEENTRY ADD (FFULLNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFACCOUNT' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFACCOUNT ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFACCOUNT' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFACCOUNT ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFACCOUNT' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFACCOUNT ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFAUDITTRIAL' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFAUDITTRIAL ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFAUDITTRIAL' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFAUDITTRIAL ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFAUDITTRIAL' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFAUDITTRIAL ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFBILL' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_STRUCTOFBILL ADD (FFULLNAME NVARCHAR(510) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFBILL' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFBILL ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFBPERIOD' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFBPERIOD ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFBPERIOD' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFBPERIOD ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFBPERIOD' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFBPERIOD ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCHANGETYPE' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFCHANGETYPE ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCHANGETYPE' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFCHANGETYPE ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCHANGETYPE' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFCHANGETYPE ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCURRENCY' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFCURRENCY ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCURRENCY' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFCURRENCY ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCURRENCY' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFCURRENCY ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDATETYPE' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFDATETYPE ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDATETYPE' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFDATETYPE ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDATETYPE' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFDATETYPE ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDEFINED' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFDEFINED ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDEFINED' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFDEFINED ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDEFINED' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFDEFINED ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFENT' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFENT ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFENT' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFENT ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFENT' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFENT ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFFY' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFFY ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFFY' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFFY ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFFY' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFFY ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFICENTITY' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFICENTITY ADD (FNAME NVARCHAR(400) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFICENTITY' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFICENTITY ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFICENTITY' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFICENTITY ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFMETRIC' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFMETRIC ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFMETRIC' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFMETRIC ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFMETRIC' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFMETRIC ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPERIOD' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFPERIOD ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPERIOD' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFPERIOD ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPERIOD' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFPERIOD ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPROCESS' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFPROCESS ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPROCESS' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFPROCESS ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPROCESS' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFPROCESS ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFSCENE' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFSCENE ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFSCENE' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFSCENE ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFSCENE' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFSCENE ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFVERSION' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_STRUCTOFVERSION ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFVERSION' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_STRUCTOFVERSION ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
-- IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFVERSION' AND KSQL_COL_NAME IN('FSIMPLENAME')) ALTER TABLE T_EB_STRUCTOFVERSION ADD (FSIMPLENAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TASKLISTGROUP' AND KSQL_COL_NAME IN('FMULILANGTEXTFIELD')) ALTER TABLE T_EB_TASKLISTGROUP ADD (FMULILANGTEXTFIELD NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TASKLISTGROUP' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_TASKLISTGROUP ADD (FNAME NVARCHAR(200) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TASKLIST' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_TASKLIST ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TASKLIST' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_TASKLIST ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TASK' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_TASK ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TASK' AND KSQL_COL_NAME IN('FDESCRIPTION')) ALTER TABLE T_EB_TASK ADD (FDESCRIPTION NVARCHAR(510) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TEMPLATECATALOG' AND KSQL_COL_NAME IN('FNAME')) ALTER TABLE T_EB_TEMPLATECATALOG ADD (FNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_TEMPLATECATALOG' AND KSQL_COL_NAME IN('FFULLNAME')) ALTER TABLE T_EB_TEMPLATECATALOG ADD (FFULLNAME NVARCHAR(100) DEFAULT ' ' NOT NULL);
/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/