CREATE COLUMN TABLE "SBODEMODE"."AUSR" ("USERID" SMALLINT CS_INT NOT NULL , "PASSWORD" NVARCHAR(254) DEFAULT '0', "PASSWORD1" NVARCHAR(8), "PASSWORD2" NVARCHAR(8), "INTERNAL_K" SMALLINT CS_INT, "USER_CODE" NVARCHAR(25), "U_NAME" NVARCHAR(155), "GROUPS" SMALLINT CS_INT DEFAULT 0, "PASSWORD4" NVARCHAR(254), "ALLOWENCES" NCLOB MEMORY THRESHOLD 1000, "SUPERUSER" NVARCHAR(1) DEFAULT 'N', "DISCOUNT" DECIMAL(21,6) CS_FIXED, "PASSWORD3" NVARCHAR(8), "Info1File" NVARCHAR(4), "Info1Field" SMALLINT CS_INT, "Info2File" NVARCHAR(4), "Info2Field" SMALLINT CS_INT, "Info3File" NVARCHAR(4), "Info3Field" SMALLINT CS_INT, "Info4File" NVARCHAR(4), "Info4Field" SMALLINT CS_INT, "dType" NVARCHAR(1) DEFAULT 'S', "E_Mail" NVARCHAR(100), "PortNum" NVARCHAR(50), "OutOfOffic" NVARCHAR(1) DEFAULT 'N', "SendEMail" NVARCHAR(1) DEFAULT 'N', "SendSMS" NVARCHAR(1) DEFAULT 'N', "DfltsGroup" NVARCHAR(8), "CashLimit" NVARCHAR(1) DEFAULT 'N', "MaxCashSum" DECIMAL(21,6) CS_FIXED, "Fax" NVARCHAR(50), "SendFax" NVARCHAR(1) DEFAULT 'N', "Locked" NVARCHAR(1) DEFAULT 'N', "Department" SMALLINT CS_INT DEFAULT -2, "Branch" SMALLINT CS_INT DEFAULT -2, "UserPrefs" BLOB MEMORY THRESHOLD 1000, "Language" INTEGER CS_INT, "Charset" SMALLINT CS_INT, "OpenCdt" NVARCHAR(1) DEFAULT 'N', "CdtPrvDays" INTEGER CS_INT DEFAULT 1, "DsplyRates" NVARCHAR(1) DEFAULT 'N', "AuImpRates" NVARCHAR(1) DEFAULT 'N', "OpenDps" NVARCHAR(1) DEFAULT 'N', "RcrFlag" NVARCHAR(1) DEFAULT 'N', "CheckFiles" NVARCHAR(1) DEFAULT 'N', "OpenCredit" NVARCHAR(1) DEFAULT 'N', "CreditDay1" SMALLINT CS_INT DEFAULT 1, "CreditDay2" SMALLINT CS_INT DEFAULT 15, "WallPaper" NCLOB MEMORY THRESHOLD 1000, "WllPprDsp" SMALLINT CS_INT DEFAULT 1, "AdvImagePr" NVARCHAR(1) DEFAULT 'N', "ContactLog" NVARCHAR(1) DEFAULT 'N', "LastWarned" LONGDATE CS_LONGDATE, "AlertPolFr" SMALLINT CS_INT DEFAULT 5, "ScreenLock" SMALLINT CS_INT DEFAULT 30, "ShowNewMsg" NVARCHAR(1) DEFAULT 'Y', "Picture" NVARCHAR(200), "Position" NVARCHAR(90), "Address" NVARCHAR(254), "Country" NVARCHAR(3), "Tel1" NVARCHAR(50), "Tel2" NVARCHAR(50), "GENDER" NVARCHAR(1) DEFAULT 'F', "Birthday" LONGDATE CS_LONGDATE, "EnbMenuFlt" NVARCHAR(1) DEFAULT 'N', "objType" NVARCHAR(20) DEFAULT '12', "logInstanc" INTEGER CS_INT NOT NULL , "userSign" SMALLINT CS_INT, "createDate" LONGDATE CS_LONGDATE, "userSign2" SMALLINT CS_INT, "updateDate" LONGDATE CS_LONGDATE, "OneLogPwd" NVARCHAR(1) DEFAULT 'N', "lastLogin" LONGDATE CS_LONGDATE, "LastPwds" NCLOB MEMORY THRESHOLD 1000, "LastPwds2" NVARCHAR(254) DEFAULT '0', "LastPwdSet" LONGDATE CS_LONGDATE, "FailedLog" INTEGER CS_INT DEFAULT 0, "PwdNeverEx" NVARCHAR(1) DEFAULT 'N', "SalesDisc" DECIMAL(21,6) CS_FIXED, "PurchDisc" DECIMAL(21,6) CS_FIXED, "LstLogoutD" LONGDATE CS_LONGDATE, "LstLoginT" INTEGER CS_INT, "LstLogoutT" INTEGER CS_INT, "LstPwdChT" INTEGER CS_INT, "LstPwdChB" NVARCHAR(25), "RclFlag" NVARCHAR(1), "MobileUser" NVARCHAR(1) DEFAULT 'N', "MobileIMEI" NVARCHAR(64), "PrsWkCntEb" NVARCHAR(1) DEFAULT 'N', "SnapShotId" INTEGER CS_INT DEFAULT 0, "STData" NVARCHAR(40), "SupportUsr" NVARCHAR(1) DEFAULT 'N', "NoSTPwdNum" SMALLINT CS_INT DEFAULT 0, "DomainUser" NVARCHAR(50), "CUSAgree" NVARCHAR(1), "EmailSig" NCLOB MEMORY THRESHOLD 1000, "TPLId" SMALLINT CS_INT, "DigCrtPath" NCLOB MEMORY THRESHOLD 1000, "ShowNewTsk" NVARCHAR(1) DEFAULT 'Y', "IntgrtEb" NVARCHAR(1) DEFAULT 'N', "AllBrnchF" NVARCHAR(1) DEFAULT 'Y', "EvtNotify" NVARCHAR(1) DEFAULT 'Y', "IgnDtOwn" NVARCHAR(1) DEFAULT 'N', "EnterAsTab" NVARCHAR(1) DEFAULT 'N', "DotAsSep" NVARCHAR(1) DEFAULT 'N', "MouseOnly" NVARCHAR(1) DEFAULT 'N', "Color" SMALLINT CS_INT, "SkinType" NVARCHAR(254), "Font" NVARCHAR(50), "FontSize" INTEGER CS_INT, "NaturalPer" NVARCHAR(1) DEFAULT 'N', "DPPStatus" NVARCHAR(1) DEFAULT 'N', "AutoAsnBPL" NVARCHAR(1) DEFAULT 'N', "EncryptIV" NVARCHAR(100), "HandleEDoc" NVARCHAR(1) DEFAULT 'Y', "ShowLicBal" NVARCHAR(1) DEFAULT 'Y', "LicBaHDate" LONGDATE CS_LONGDATE, "ShowFstMsg" NVARCHAR(1) DEFAULT 'N', "ShowMsgNum" INTEGER CS_INT DEFAULT 100, "LastClean" LONGDATE CS_LONGDATE, "CleanChb" NVARCHAR(1) DEFAULT 'N', "CleanIbx" NVARCHAR(1) DEFAULT 'N', "CleanObx" NVARCHAR(1) DEFAULT 'N', "CleanSnt" NVARCHAR(1) DEFAULT 'N', "validFor" NVARCHAR(1) DEFAULT 'N', "validFrom" LONGDATE CS_LONGDATE, "validTo" LONGDATE CS_LONGDATE, "frozenFor" NVARCHAR(1) DEFAULT 'N', "frozenFrom" LONGDATE CS_LONGDATE, "frozenTo" LONGDATE CS_LONGDATE, "ValidComm" NVARCHAR(30), "FrozenComm" NVARCHAR(30), PRIMARY KEY ("USERID", "logInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 