The mailing list for listmasters using Sympa

[Phil Stracchino <address@concealed>]

On 11/6/20 3:12 PM, Phil Stracchino wrote:
> On 11/6/20 3:07 PM, TK CHEN wrote:
>> Is there anyone using MySQL version 8 for Sympa? I am not able to create
>> the database schema for sympa server. 
> 
> 
> I don't see any reason why it *wouldn't* be.


Oh, wait, I take that back.  I read too quickly.  I just went to
double-check and looked at the schemas, and there are numerous VARCHAR
columns declared NOT NULL with no DEFAULT.  This is explicitly illegal
in MySQL 8.  You are not in general permitted to declare a column NOT
NULL without stipulating a valid DEFAULT.  (A few data types are
exceptions, but VARCHAR is not one of them.)


All of these VARCHAR(...) NOT NULL columns need a DEFAULT in MySQL 8.



-- 
  Phil Stracchino
  Babylon Communications
  address@concealed
  address@concealed
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958