Differential D8344 Diff 19854 resources/sql/patches/20131030.repostatusmessage.sql

Changeset View

Standalone View

	CREATE TABLE {$NAMESPACE}_repository.repository_statusmessage (			CREATE TABLE {$NAMESPACE}_repository.repository_statusmessage (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,			id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	repositoryID INT UNSIGNED NOT NULL,			repositoryID INT UNSIGNED NOT NULL,
	statusType VARCHAR(32) NOT NULL COLLATE utf8_bin,			statusType VARCHAR(32) NOT NULL COLLATE utf8_bin,
	statusCode VARCHAR(32) NOT NULL COLLATE utf8_bin,			statusCode VARCHAR(32) NOT NULL COLLATE utf8_bin,
	parameters LONGTEXT NOT NULL,			parameters LONGTEXT NOT NULL,
	epoch INT UNSIGNED NOT NULL,			epoch INT UNSIGNED NOT NULL,
	UNIQUE KEY (repositoryID, statusType)			UNIQUE KEY (repositoryID, statusType)
	) ENGINE=InnoDB, CHARSET utf8;			) ENGINE=InnoDB, CHARSET utf8;