   `savepointName` varchar(255) NOT NULL,
   PRIMARY KEY (`savepointId`),
   KEY `transactionId` (`transactionId`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `template`
---
-
-DROP TABLE IF EXISTS `template`;
-CREATE TABLE IF NOT EXISTS `template` (
-  `resourceId` varchar(255) NOT NULL,
-  `description` varchar(255) DEFAULT NULL,
-  `mimeType` varchar(255) NOT NULL DEFAULT 'Content-type: text/xml; charset=utf-8',
-  `defaultHeaders` text,
-  `body` text,
-  PRIMARY KEY (`resourceId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------


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''?>',
  `defaultHeaders` text,
  `body` text,
  PRIMARY KEY (`statusCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Database: `polecat`
--

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

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
CREATE TABLE IF NOT EXISTS `cache` (
  `resourceId` char(36) NOT NULL,
  `statusCode` int(11) NOT NULL,
  `lastModifiedTime` int(11) NOT NULL,
  `cacheData` blob NOT NULL,
  UNIQUE KEY `cacheEntryKey` (`resourceId`,`statusCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

