Ok, how about 512 :) ? I'm ok to increase length but as needed only. The reason being that the column length becomes a problem on certain database types if/when we use that column in certain constraints (ex: unique constraint).
On Thu, Dec 1, 2016 at 4:50 PM, Lakmali Baminiwatta <[email protected]> wrote: > Blocking condition values will include the tenant domain for API context > blocking(/t/${tenantDomain}/${context}) and tenant qualified username for > Application blocking (${userName}:${applicationName}). Especially if > email username based tenant users are there, value can grow more. > Hence suggesting a higher value. > > On 1 December 2016 at 16:43, Nuwan Dias <[email protected]> wrote: > >> Isn't 256 enough? Since the application or api name length is 200? >> >> On Thu, Dec 1, 2016 at 3:45 PM, Lakmali Baminiwatta <[email protected]> >> wrote: >> >>> Shall we do the $subject? >>> >>> Currently the 'value' column size is varchar(45), which is not >>> sufficient for most possible combinations, given that we allow API name and >>> Application name themselves 200/100 chars. >>> >>> So I think we can increase 'value' cloumn size to 1024. >>> We can include an alter query for 2.1.0 default script for migration. >>> >>> Any concerns? >>> >>> Thanks, >>> Lakmali >>> -- >>> Lakmali Baminiwatta >>> Associate Technical Lead >>> WSO2, Inc.: http://wso2.com >>> lean.enterprise.middleware >>> mobile: +94 71 2335936 >>> blog : lakmali.com >>> >>> >> >> >> -- >> Nuwan Dias >> >> Software Architect - WSO2, Inc. http://wso2.com >> email : [email protected] >> Phone : +94 777 775 729 <+94%2077%20777%205729> >> > > > > -- > Lakmali Baminiwatta > Associate Technical Lead > WSO2, Inc.: http://wso2.com > lean.enterprise.middleware > mobile: +94 71 2335936 > blog : lakmali.com > > -- Nuwan Dias Software Architect - WSO2, Inc. http://wso2.com email : [email protected] Phone : +94 777 775 729
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
