Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


The JPA storage facility usesĀ Hibernate ORM for searching and persistence using a relational database for storage. The schema we recommend is as follows:Example schemas are shown below.


Whatever you do, you MUST ensure the context and id columns are case-sensitively handled and compared. That is a requirement of the API that will be using the database.

Code Block
CREATE TABLE `StorageRecords` (
  `context` varchar(255) NOT NULL,
  `id` varchar(255) NOT NULL,
  `expires` bigint(20) DEFAULT NULL,
  `value` longtext NOT NULL,
  `version` bigint(20) NOT NULL,
  PRIMARY KEY (`context`,`id`)