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 <maxwel...@fortlewis.edu>: > Ok I just wanted to make sure. Thanks! > > > > *From:* cas-user@apereo.org [mailto:cas-user@apereo.org] *On Behalf Of *Man > H > *Sent:* Friday, December 15, 2017 9:39 AM > *To:* cas-user@apereo.org > *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 <maxwel...@fortlewis.edu>: > > 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/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 cas-user+unsubscr...@apereo.org. > 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 cas-user+unsubscr...@apereo.org. > 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 cas-user+unsubscr...@apereo.org. 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.
