create table `certificates`(
`id` INT NOT NULL AUTO_INCREMENT,
`common_name` VARCHAR(100) NOT NULL,
`csr` LONGTEXT NOT NULL,
`type` VARCHAR(100) NOT NULL,
`certificate` VARCHAR(100) NOT NULL,
`user` VARCHAR(100 NOT NULL,
`creation_date` DATE,
PRIMARY KEY ( id )
);

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL,
`creation_date` DATE,
PRIMARY KEY ( id )
)' at line 7