Differential D8344 Diff 19854 resources/sql/patches/20130131.conpherencepics.sql

Changeset View

Standalone View

	ALTER TABLE {$NAMESPACE}_conpherence.conpherence_thread			ALTER TABLE {$NAMESPACE}_conpherence.conpherence_thread
	DROP imagePHID,			DROP imagePHID,
	ADD imagePHIDs LONGTEXT COLLATE utf8_bin NOT NULL AFTER title;			ADD imagePHIDs LONGTEXT COLLATE utf8_bin NOT NULL AFTER title;

	UPDATE {$NAMESPACE}_conpherence.conpherence_thread			UPDATE {$NAMESPACE}_conpherence.conpherence_thread
	SET imagePHIDs = '{}' WHERE imagePHIDs = '';			SET imagePHIDs = '{}' WHERE imagePHIDs = '';