20160601.user.01.cache.sql
No OneTemporary
Actions

Size

503 B

Referenced Files

None

Subscribers

None

20160601.user.01.cache.sql
View Options

	CREATE TABLE {$NAMESPACE}_user.user_cache (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	userPHID VARBINARY(64) NOT NULL,
	cacheIndex BINARY(12) NOT NULL,
	cacheKey VARCHAR(255) NOT NULL COLLATE {$COLLATE_TEXT},
	cacheData LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
	cacheType VARCHAR(32) NOT NULL COLLATE {$COLLATE_TEXT},
	UNIQUE KEY `key_usercache` (userPHID, cacheIndex),
	KEY `key_cachekey` (cacheIndex),
	KEY `key_cachetype` (cacheType)
	) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};