20160928.tokentoken.sql
No OneTemporary
Actions

Size

654 B

Referenced Files

None

Subscribers

None

20160928.tokentoken.sql
View Options

	CREATE TABLE {$NAMESPACE}_token.token_token (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARBINARY(64) NOT NULL,
	name VARCHAR(64) NOT NULL COLLATE {$COLLATE_TEXT},
	flavor VARCHAR(128) NOT NULL COLLATE {$COLLATE_TEXT},
	status VARCHAR(32) NOT NULL COLLATE {$COLLATE_TEXT},
	builtinKey VARCHAR(32) COLLATE {$COLLATE_TEXT},
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	creatorPHID VARBINARY(64) NOT NULL,
	tokenImagePHID VARBINARY(64),
	UNIQUE KEY `key_phid` (phid),
	UNIQUE KEY `key_builtin` (builtinKey),
	KEY `key_creator` (creatorPHID, dateModified)
	) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

File Metadata

Mime Type: text/plain
Expires: Thu, Dec 19, 18:30 (1 d, 2 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1014908
Default Alt Text: 20160928.tokentoken.sql (654 B)

Event Timeline