violates not-null constraint auto now add code example

Example: postgresql add not null and not empty constraint

ads character varying(60) NOT NULL CHECK (ads <> '')