Differential D16621 Diff 40016 resources/sql/autopatches/20160928.tokentoken.sql

Changeset View

Standalone View

				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),
				epriestleyUnsubmitted Done Inline Actions This should maybe be nullable since I think builtin tokens probably won't use an actual File for their data (we can just read it directly off disk) but we can fix that easily later and I'm not 100% sure it will actually be how things turn out. epriestley: This should maybe be nullable since I think builtin tokens probably won't use an actual File…
				UNIQUE KEY `key_builtin` (builtinKey),
				KEY `key_creator` (creatorPHID, dateModified)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};