Differential D16178 Diff 38923 resources/sql/autopatches/20160625.tokens.1.sql

Changeset View

Standalone View

resources/sql/autopatches/20160625.tokens.1.sql

This file was added.

				CREATE TABLE {$NAMESPACE}_tokens.tokens_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},
				epriestleyUnsubmitted Not Done Inline Actions Maybe just LONGTEXT? We can always summarize in the UI... epriestley: Maybe just LONGTEXT? We can always summarize in the UI...
				dateCreated INT UNSIGNED NOT NULL,
				dateModified INT UNSIGNED NOT NULL,
				editPolicy VARBINARY(64) NOT NULL,
				creatorPHID VARBINARY(64) NOT NULL,
				tokenImagePHID VARBINARY(64) NOT NULL,
				mailKey BINARY(20) NOT NULL,
				UNIQUE KEY `key_phid` (phid),
				KEY `key_creator` (creatorPHID, dateModified)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_tokens.tokens_transaction (
				id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
				phid VARBINARY(64) NOT NULL,
				authorPHID VARBINARY(64) NOT NULL,
				objectPHID VARBINARY(64) NOT NULL,
				viewPolicy VARBINARY(64) NOT NULL,
				editPolicy VARBINARY(64) NOT NULL,
				commentPHID VARBINARY(64),
				commentVersion INT UNSIGNED NOT NULL,
				transactionType VARCHAR(32) NOT NULL COLLATE {$COLLATE_TEXT},
				oldValue LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				newValue LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				contentSource LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				metadata LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				dateCreated INT UNSIGNED NOT NULL,
				dateModified INT UNSIGNED NOT NULL,
				UNIQUE KEY `key_phid` (phid),
				KEY `key_object` (objectPHID)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_tokens.edge (
				src VARBINARY(64) NOT NULL,
				type INT UNSIGNED NOT NULL,
				dst VARBINARY(64) NOT NULL,
				dateCreated INT UNSIGNED NOT NULL,
				seq INT UNSIGNED NOT NULL,
				dataID INT UNSIGNED,
				PRIMARY KEY (src, type, dst),
				KEY `src` (src, type, dateCreated, seq),
				UNIQUE KEY `key_dst` (dst, type, src)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_tokens.edgedata (
				id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
				data LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT}
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_tokens.tokens_transaction_comment (
				id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
				phid VARBINARY(64) NOT NULL,
				transactionPHID VARBINARY(64),
				authorPHID VARBINARY(64) NOT NULL,
				viewPolicy VARBINARY(64) NOT NULL,
				editPolicy VARBINARY(64) NOT NULL,
				commentVersion INT UNSIGNED NOT NULL,
				content LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				contentSource LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				isDeleted BOOL NOT NULL,
				dateCreated INT UNSIGNED NOT NULL,
				dateModified INT UNSIGNED NOT NULL,

				UNIQUE KEY `key_phid` (phid),
				UNIQUE KEY `key_version` (transactionPHID, commentVersion)

				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};