1
2
3
4
5
6
7
8
9
10
11

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=3 DEFAULT CHARSET=latin1

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=3 DEFAULT CHARSET=latin1