Skip to content

Instantly share code, notes, and snippets.

@notserk
Last active May 11, 2016 14:50
Show Gist options
  • Save notserk/f6ef2480b117f6ee601e25de226d480e to your computer and use it in GitHub Desktop.
Save notserk/f6ef2480b117f6ee601e25de226d480e to your computer and use it in GitHub Desktop.
Create Cache Table for Drupal 7.
CREATE TABLE `cache_path` (
`cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
`data` longblob COMMENT 'A collection of data to cache.',
`expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
`created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
`serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).',
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment