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.
