We initialized our database by setting “cas.serviceRegistry.jpa.ddlAuto=create” in the CAS 5.2 cas.properties file however the following table was created. It appears a lot of columns were removed between 5.1.2 and 5.2. Can this be correct?
CAS 5.2.0 CREATE TABLE [dbo].[RegexRegisteredService]( [expression_type] [varchar](50) NOT NULL, [id] [bigint] IDENTITY(1,1) NOT NULL, [access_strategy] [varbinary](max) NULL, [attribute_release] [varbinary](max) NULL, [description] [varchar](255) NULL, [evaluation_order] [int] NOT NULL, [expiration_policy] [varbinary](max) NULL, [informationUrl] [varchar](255) NULL, [logo] [varchar](255) NULL, [logout_type] [int] NULL, [logout_url] [varchar](255) NULL, [mfa_policy] [varbinary](max) NULL, [name] [varchar](255) NOT NULL, [privacyUrl] [varchar](255) NULL, [proxy_policy] [varbinary](max) NULL, [public_key] [varbinary](max) NULL, [required_handlers] [varbinary](max) NULL, [serviceId] [varchar](255) NOT NULL, [theme] [varchar](255) NULL, [username_attr] [varbinary](max) NULL, CAS 5.1.2 CREATE TABLE [dbo].[RegexRegisteredService]( [expression_type] [varchar](15) NOT NULL, [id] [bigint] NOT NULL, [access_strategy] [varbinary](max) NULL, [attribute_release] [varbinary](max) NULL, [description] [varchar](255) NULL, [evaluation_order] [int] NOT NULL, [informationUrl] [varchar](255) NULL, [logo] [varchar](255) NULL, [logout_type] [int] NULL, [logout_url] [varchar](255) NULL, [mfa_policy] [varbinary](max) NULL, [name] [varchar](255) NOT NULL, [privacyUrl] [varchar](255) NULL, [proxy_policy] [varbinary](max) NULL, [public_key] [varbinary](max) NULL, [required_handlers] [varbinary](max) NULL, [serviceId] [varchar](255) NOT NULL, [theme] [varchar](255) NULL, [username_attr] [varbinary](max) NULL, [bypassApprovalPrompt] [bit] NULL, [clientId] [varchar](255) NULL, [clientSecret] [varchar](255) NULL, [generateRefreshToken] [bit] NULL, [jsonFormat] [bit] NULL, [supported_grants] [varbinary](max) NULL, [supported_responses] [varbinary](max) NULL, [DYNAMIC_REG_TIME] [datetime2](7) NULL, [dynamicallyRegistered] [bit] NULL, [encryptIdToken] [bit] NULL, [idTokenEncryptionAlg] [varchar](255) NULL, [idTokenEncryptionEncoding] [varchar](255) NULL, [implicit] [bit] NULL, [jwks] [varchar](255) NULL, [scopes] [varbinary](max) NULL, [signIdToken] [bit] NULL, [encryptAssertions] [bit] NULL, [metadataCriteriaDirection] [varchar](255) NULL, [metadataCriteriaPattern] [varchar](255) NULL, [metadataCriteriaRemoveEmptyEntitiesDescriptors] [bit] NULL, [metadataCriteriaRemoveRolelessEntityDescriptors] [bit] NULL, [metadataCriteriaRoles] [varchar](255) NULL, [metadataLocation] [varchar](255) NULL, [metadataMaxValidity] [bigint] NULL, [metadataSignatureLocation] [varchar](255) NULL, [nameIdQualifier] [varchar](255) NULL, [requiredAuthenticationContextClass] [varchar](255) NULL, [requiredNameIdFormat] [varchar](255) NULL, [serviceProviderNameIdQualifier] [varchar](255) NULL, [signAssertions] [bit] NULL, [signResponses] [bit] NULL, -Gary -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR03MB30145F7FA1552FD561DB948D950A0%40CY4PR03MB3014.namprd03.prod.outlook.com.