psa.certificates
Overview
The certificates table contains information about the SSL certificates installed on the server.
Column Descriptions
id - primary key that is automatically incremented
csr - certificate signing request in binary form
pvt_key - private key in binary form
cert - certificate in binary form
cert_file - the filename for the certificate file
ca_cert - CA certificates (intermediate certificates) in binary form
ca_file - the filename for the CA certificate file
name - the friendly name for the SSL certificate in Plesk
Table Structure
CREATE TABLE `certificates` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `csr` BLOB NOT NULL, `pvt_key` BLOB NOT NULL, `cert` BLOB NOT NULL, `cert_file` VARCHAR(255) character SET ASCII COLLATE ascii_bin NOT NULL DEFAULT '', `ca_cert` BLOB NOT NULL, `ca_file` VARCHAR(255) character SET ASCII COLLATE ascii_bin NOT NULL DEFAULT '', `name` VARCHAR(255) character SET utf8 NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1