1
2
3
4
5
6
7
8
9
10

CREATE TABLE `ServiceNodes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `transport` enum('local','remote') NOT NULL,
  `remoteIpAddress` varchar(255) CHARACTER SET ascii DEFAULT NULL,
  `accessKey` text CHARACTER SET ascii COLLATE ascii_bin,
  `externalId` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `ServiceNodes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET ascii NOT NULL, `transport` enum('local','remote') NOT NULL, `remoteIpAddress` varchar(255) CHARACTER SET ascii DEFAULT NULL, `accessKey` text CHARACTER SET ascii COLLATE ascii_bin, `externalId` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1