20130214.token.sql
No OneTemporary
Actions

Size

743 B

Referenced Files

None

Subscribers

None

20130214.token.sql
View Options

	CREATE TABLE {$NAMESPACE}_token.token_given (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	tokenPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_all` (objectPHID, authorPHID),
	KEY `key_author` (authorPHID),
	KEY `key_token` (tokenPHID)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

	CREATE TABLE {$NAMESPACE}_token.token_count (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	tokenCount INT NOT NULL,
	UNIQUE KEY `key_objectPHID` (objectPHID)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

File Metadata

Mime Type: text/plain
Expires: Thu, Jan 15, 2:02 AM (1 d, 6 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 622555
Default Alt Text: 20130214.token.sql (743 B)

Event Timeline