1
2
3
4
5
6
7

CREATE TABLE `ServiceNodeCache` (
  `serviceNodeId` int(10) unsigned NOT NULL,
  `pathId` varchar(255) CHARACTER SET ascii NOT NULL,
  `path` text CHARACTER SET ascii COLLATE ascii_bin,
  `cache` text CHARACTER SET ascii COLLATE ascii_bin,
  PRIMARY KEY (`serviceNodeId`,`pathId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `ServiceNodeCache` ( `serviceNodeId` int(10) unsigned NOT NULL, `pathId` varchar(255) CHARACTER SET ascii NOT NULL, `path` text CHARACTER SET ascii COLLATE ascii_bin, `cache` text CHARACTER SET ascii COLLATE ascii_bin, PRIMARY KEY (`serviceNodeId`,`pathId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1