/
[unit configs] Keep unit configs clean

[unit configs] Keep unit configs clean

We've developed unit config validator some time ago and it seems, that we have some unresolved issues found by it:

Config Error: for prefix email-queue (EmailQueue) in unit config:
   Field LogData exists in the database, but is not defined in config
Config Error: for prefix lang (Languages) in unit config:
   Field Charset exists in the database, but is not defined in config
Config Errors: for prefix system-log (SystemLog) in unit config:
   Default value for field LogLevel not sync. to db (in config = 6 of integer, in db = 7 of integer)
   Field LogType is NOT NULL in the database, but is not configured as not_null
   Field LogInterface is described as NOT NULL in config, but is NULL in db
Config Error: for prefix permission-type (CategoryPermissionsConfig) in unit config:
   Default value for field ModuleId not sync. to db (in config = '' of string, in db = 0 of integer)
Config Errors: for prefix phrases (LanguageLabels) in unit config:
   Default value for field PhraseType not sync. to db (in config = 2 of integer, in db = 0 of integer)
   Default value for field Module not sync. to db (in config = 'Custom' of string, in db = 'In-Portal' of string)
Config Error: for prefix promo-block (PromoBlocks) in unit config:
   Field CSSClassName exists in the database, but is not defined in config
Config Errors: for prefix scheduled-task (ScheduledTasks) in unit config:
   Field RunTime must be NULL in config and database, since it contains date
   Field Timeout is described as NOT NULL in config, but is NULL in db
   Default value for field Timeout not sync. to db (in config = NULL of NULL, in db = 0 of integer)
Config Warning: Table 53x_StylesheetSelectors missing, but prefix selectors requires it!
Config Errors: for prefix st (Categories) in unit config:
   Field PromoBlockGroupId exists in the database, but is not defined in config
   Field RequireSSL exists in the database, but is not defined in config
   Field RequireLogin exists in the database, but is not defined in config
Config Warning: Table 53x_Stylesheets missing, but prefix css requires it!
Config Errors: for prefix system-event-subscription (SystemEventSubscriptions) in unit config:
   Calculated field BindToSystemEvent is missing corresponding virtual field
   Calculated field ItemName is missing corresponding virtual field
   Calculated field ParentItemName is missing corresponding virtual field
Config Error: for prefix ug (UserGroupRelations) in unit config:
   Virtual field PrimaryGroup cannot be not null, since it doesn't exist in database
Config Errors: for prefix u (Users) in unit config:
   Default value for field PortalUserId not set in config
   Field PortalUserId is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Username not set in config
   Field Username is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Password not set in config
   Default value for field PasswordHashingMethod not set in config
   Field PasswordHashingMethod is NOT NULL in the database, but is not configured as not_null
   Default value for field FirstName not set in config
   Field FirstName is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field LastName not set in config
   Field LastName is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Company not set in config
   Field Company is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Email not set in config
   Field Email is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field PrevEmails not set in config
   Default value for field CreatedOn not set in config
   Default value for field Phone not set in config
   Field Phone is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Fax not set in config
   Field Fax is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Street not set in config
   Field Street is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Street2 not set in config
   Field Street2 is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field City not set in config
   Field City is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field State not set in config
   Field State is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Zip not set in config
   Field Zip is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Country not set in config
   Field Country is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field ResourceId not set in config
   Field ResourceId is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Status not set in config
   Field Status is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field EmailVerified not set in config
   Field EmailVerified is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field Modified not set in config
   Default value for field dob not set in config
   Default value for field TimeZone not set in config
   Field TimeZone is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field IPAddress not set in config
   Field IPAddress is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field IsBanned not set in config
   Field IsBanned is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field PwResetConfirm not set in config
   Field PwResetConfirm is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field PwRequestTime not set in config
   Default value for field FrontLanguage not set in config
   Default value for field AdminLanguage not set in config
   Default value for field DisplayToPublic not set in config
   Default value for field UserType not set in config
   Field UserType is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field PrimaryGroupId not set in config
   Default value for field OldStyleLogin not set in config
   Field OldStyleLogin is described as NOT NULL in config, but does not have DEFAULT value
   Default value for field IPRestrictions not set in config
   Field EbayLogin exists in the database, but is not defined in config
   Field EbayEIASToken exists in the database, but is not defined in config
   Default value for virtual field PrimaryGroup not set in config
   Default value for virtual field RootPassword not set in config
   Default value for virtual field EmailPassword not set in config
   Default value for virtual field FullName not set in config
   Default value for virtual field AltName not set in config
   Default value for virtual field SameImages not set in config
   Default value for virtual field LocalThumb not set in config
   Default value for virtual field ThumbPath not set in config
   Default value for virtual field ThumbUrl not set in config
   Default value for virtual field LocalImage not set in config
   Default value for virtual field LocalPath not set in config
   Default value for virtual field FullUrl not set in config
   Default value for virtual field SubscribeToMailing not set in config
Config Error: for prefix addr (Addresses) in unit config:
   Default value for field Country not sync. to db (in config = 'USA' of string, in db = '' of string)
Config Errors: for prefix p (Products) in unit config:
   Field LastListingId exists in the database, but is not defined in config
   Field ScheduleId exists in the database, but is not defined in config
Config Warning: Table 53x_StylesheetSelectors missing, but prefix selectorsbase requires it!
Config Warning: Table 53x_StylesheetSelectors missing, but prefix selectorsblock requires it!
Config Error: for prefix g-ug (UserGroupRelations) in unit config:
   Virtual field PrimaryGroup cannot be not null, since it doesn't exist in database
Config Error: for prefix u-ug (UserGroupRelations) in unit config:
   Virtual field PrimaryGroup cannot be not null, since it doesn't exist in database

I've executed it on In-Portal 5.3.x installation.