Differential D9145 Diff 21847 resources/sql/autopatches/20140514.pholiomockclose.sql

Changeset View

Standalone View

				ALTER TABLE {$NAMESPACE}_pholio.pholio_mock
				ADD COLUMN status VARCHAR(12) NOT NULL COLLATE utf8_bin;

				UPDATE {$NAMESPACE}_pholio.pholio_mock
				SET status = "open" WHERE status = "";