Differential D8344 Diff 19854 resources/sql/patches/20130519.diviner.sql

Changeset View

Standalone View

	Show All 28 Lines

	CREATE TABLE {$NAMESPACE}_diviner.diviner_liveatom (			CREATE TABLE {$NAMESPACE}_diviner.diviner_liveatom (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,			id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	symbolPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,			symbolPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	content LONGTEXT NOT NULL COLLATE utf8_bin,			content LONGTEXT NOT NULL COLLATE utf8_bin,
	atomData LONGTEXT NOT NULL COLLATE utf8_bin,			atomData LONGTEXT NOT NULL COLLATE utf8_bin,
	UNIQUE KEY (symbolPHID)			UNIQUE KEY (symbolPHID)
	) ENGINE=InnoDB, DEFAULT CHARSET = utf8;			) ENGINE=InnoDB, DEFAULT CHARSET = utf8;