As described in this Blog http://mablomy.blogspot.dk/2016/04/check-constraint-for-mysql-not-null-on.html. A very nice hack/trick IMO.

However it is not working with MariaDB as VC's cannot be declared NOT NULL.  What prevents that? 

-- Peter
-- Webyog