 
 DROP TABLE IF EXISTS `response`;
 CREATE TABLE IF NOT EXISTS `response` (
-  `statusCode` char(3) NOT NULL,
-  `mimeType` varchar(255) NOT NULL DEFAULT '<?xml version=''1.0'' standalone=''yes''?>',
+  `resourceId` char(36) NOT NULL,
+  `statusCode` int(11) NOT NULL,
+  `docType` text,
   `defaultHeaders` text,
-  `body` text,
-  PRIMARY KEY (`statusCode`)
+  `responseClassName` varchar(255) NOT NULL,
+  `templateFullPath` varchar(255) DEFAULT NULL,
+  `lastModifiedTime` int(11) NOT NULL,
+  UNIQUE KEY `responseKey` (`resourceId`,`statusCode`),
+  KEY `responseClassName` (`responseClassName`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------

  `resourceId` char(36) DEFAULT NULL,
  `resourceClassName` varchar(255) NOT NULL,
  `resourceAuthorityClassName` varchar(255) DEFAULT NULL,
  `resourceDenyCode` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`resourceName`),
  UNIQUE KEY `resourceId` (`resourceId`),
  KEY `resourceClassName` (`resourceClassName`),

  `savepointName` varchar(255) NOT NULL,
  PRIMARY KEY (`savepointId`),
  KEY `transactionId` (`transactionId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------
