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 [email protected].
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.
