Hi again David I have to complement my previous answer.
Previous table attributes are create by cas-server, but if you install cas-management following table is created, which is also read by cas server. Regards CREATE TABLE `RegexRegisteredService` ( `expression_type` varchar(50) NOT NULL DEFAULT 'regex', `id` bigint(20) NOT NULL AUTO_INCREMENT, `access_strategy` longblob, `attribute_release` longblob, `description` varchar(255) DEFAULT NULL, `evaluation_order` int(11) NOT NULL, `expiration_policy` longblob, `informationUrl` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `logout_type` int(11) DEFAULT NULL, `logout_url` varchar(255) DEFAULT NULL, `mfa_policy` longblob, `name` varchar(255) NOT NULL, `privacyUrl` varchar(255) DEFAULT NULL, `proxy_policy` longblob, `public_key` longblob, `required_handlers` longblob, `serviceId` varchar(255) NOT NULL, `theme` varchar(255) DEFAULT NULL, `username_attr` longblob, `bypassApprovalPrompt` bit(1) DEFAULT NULL, `clientId` varchar(255) DEFAULT NULL, `clientSecret` varchar(255) DEFAULT NULL, `generateRefreshToken` bit(1) DEFAULT NULL, `jsonFormat` bit(1) DEFAULT NULL, `supported_grants` longblob, `supported_responses` longblob, `DYNAMIC_REG_TIME` datetime DEFAULT NULL, `dynamicallyRegistered` bit(1) DEFAULT NULL, `encryptIdToken` bit(1) DEFAULT NULL, `idTokenEncryptionAlg` varchar(255) DEFAULT NULL, `idTokenEncryptionEncoding` varchar(255) DEFAULT NULL, `implicit` bit(1) DEFAULT NULL, `jwks` varchar(255) DEFAULT NULL, `scopes` longblob, `sectorIdentifierUri` varchar(255) DEFAULT NULL, `signIdToken` bit(1) DEFAULT NULL, `subjectType` varchar(255) DEFAULT NULL, `addressingNamespace` varchar(255) DEFAULT NULL, `appliesTo` varchar(255) DEFAULT NULL, `namespace` varchar(255) DEFAULT NULL, `policyNamespace` varchar(255) DEFAULT NULL, `protocol` varchar(255) DEFAULT NULL, `realm` varchar(255) DEFAULT NULL, `tokenType` varchar(255) DEFAULT NULL, `wsdlEndpoint` varchar(255) DEFAULT NULL, `wsdlLocation` varchar(255) DEFAULT NULL, `wsdlService` varchar(255) DEFAULT NULL, `encryptAssertions` bit(1) DEFAULT NULL, `metadataCriteriaDirection` varchar(255) DEFAULT NULL, `metadataCriteriaPattern` varchar(255) DEFAULT NULL, `metadataCriteriaRemoveEmptyEntitiesDescriptors` bit(1) DEFAULT NULL, `metadataCriteriaRemoveRolelessEntityDescriptors` bit(1) DEFAULT NULL, `metadataCriteriaRoles` varchar(255) DEFAULT NULL, `metadataExpirationDuration` varchar(255) DEFAULT NULL, `metadataLocation` varchar(255) DEFAULT NULL, `metadataMaxValidity` bigint(20) DEFAULT NULL, `metadataSignatureLocation` varchar(255) DEFAULT NULL, `nameIdQualifier` varchar(255) DEFAULT NULL, `requiredAuthenticationContextClass` varchar(255) DEFAULT NULL, `requiredNameIdFormat` varchar(255) DEFAULT NULL, `serviceProviderNameIdQualifier` varchar(255) DEFAULT NULL, `signAssertions` bit(1) DEFAULT NULL, `signResponses` bit(1) DEFAULT NULL, `signingCredentialType` varchar(255) DEFAULT NULL, `skipGeneratingAssertionNameId` bit(1) DEFAULT NULL, `skipGeneratingSubjectConfirmationInResponseTo` bit(1) DEFAULT NULL, `skipGeneratingSubjectConfirmationNotBefore` bit(1) DEFAULT NULL, `skipGeneratingSubjectConfirmationNotOnOrAfter` bit(1) DEFAULT NULL, `skipGeneratingSubjectConfirmationRecipient` bit(1) DEFAULT NULL, PRIMARY KEY (`id`) ) 2017-12-15 17:45 GMT-03:00 Maxwell, Gary <[email protected]>: > Ok I just wanted to make sure. Thanks! > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Man > H > *Sent:* Friday, December 15, 2017 9:39 AM > *To:* [email protected] > *Subject:* Re: [cas-user] 5.1.2 to 5.2 CAS migration > > > > this is what I have in 5.2.0 > > CREATE TABLE `RegexRegisteredService` ( > `expression_type` varchar(50) NOT NULL DEFAULT 'regex', > `id` bigint(20) NOT NULL AUTO_INCREMENT, > `access_strategy` longblob, > `attribute_release` longblob, > `description` varchar(255) DEFAULT NULL, > `evaluation_order` int(11) NOT NULL, > `expiration_policy` longblob, > `informationUrl` varchar(255) DEFAULT NULL, > `logo` varchar(255) DEFAULT NULL, > `logout_type` int(11) DEFAULT NULL, > `logout_url` varchar(255) DEFAULT NULL, > `mfa_policy` longblob, > `name` varchar(255) NOT NULL, > `privacyUrl` varchar(255) DEFAULT NULL, > `proxy_policy` longblob, > `public_key` longblob, > `required_handlers` longblob, > `serviceId` varchar(255) NOT NULL, > `theme` varchar(255) DEFAULT NULL, > `username_attr` longblob, > PRIMARY KEY (`id`) > ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; > > > > 2017-12-14 20:28 GMT-03:00 Maxwell, Gary <[email protected]>: > > 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/CY4PR03MB30145F7FA1552FD561DB9 > 48D950A0%40CY4PR03MB3014.namprd03.prod.outlook.com > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR03MB30145F7FA1552FD561DB948D950A0%40CY4PR03MB3014.namprd03.prod.outlook.com?utm_medium=email&utm_source=footer> > . > > > > -- > - 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/CAMY5mid_%2BHeV-p%2BZHdWzXd70ywpxV43DwZNBNkVT% > 2BMGVp3VjqQ%40mail.gmail.com > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mid_%2BHeV-p%2BZHdWzXd70ywpxV43DwZNBNkVT%2BMGVp3VjqQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > -- > - 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/CY4PR03MB3014E20AB11AA25E6E9F4 > F33950B0%40CY4PR03MB3014.namprd03.prod.outlook.com > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR03MB3014E20AB11AA25E6E9F4F33950B0%40CY4PR03MB3014.namprd03.prod.outlook.com?utm_medium=email&utm_source=footer> > . > -- - 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/CAMY5mie8JzqFqe6tpSYuRBE_adcPKhop%3DP2kT_PejQtv8qnM3Q%40mail.gmail.com.
