20130711.pholioimageobsolete.sql
df264d85484amaster

20130711.pholioimageobsolete.sql
View Options

			ALTER TABLE {$NAMESPACE}_pholio.pholio_image
			ADD `isObsolete` TINYINT(1) NOT NULL DEFAULT '0';

			ALTER TABLE {$NAMESPACE}_pholio.pholio_image
			DROP KEY `mockID`;

			ALTER TABLE {$NAMESPACE}_pholio.pholio_image
			ADD KEY `mockID` (`mockID`, `isObsolete`, `sequence`);

			ALTER TABLE {$NAMESPACE}_pholio.pholio_image
			ADD `phid` VARCHAR(64) NOT NULL COLLATE utf8_bin AFTER `id`;

			ALTER TABLE {$NAMESPACE}_pholio.pholio_image
			CHANGE `mockID` `mockID` INT(10) UNSIGNED;