1
2
3
4
5
6
7

CREATE TABLE `ServiceNodeCertificates` (
  `serviceNodeId` int(10) unsigned NOT NULL,
  `certificateId` int(10) unsigned NOT NULL,
  `certFile` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  `caFile` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`serviceNodeId`,`certificateId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `ServiceNodeCertificates` ( `serviceNodeId` int(10) unsigned NOT NULL, `certificateId` int(10) unsigned NOT NULL, `certFile` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '', `caFile` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '', PRIMARY KEY (`serviceNodeId`,`certificateId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1