Differential D8344 Diff 19854 resources/sql/patches/phamepolicy.sql

Changeset View

Standalone View

	Show All 9 Lines
	UPDATE `{$NAMESPACE}_phame`.`phame_blog` SET editPolicy = 'users'			UPDATE `{$NAMESPACE}_phame`.`phame_blog` SET editPolicy = 'users'
	WHERE editPolicy IS NULL;			WHERE editPolicy IS NULL;

	ALTER TABLE `{$NAMESPACE}_phame`.`phame_blog`			ALTER TABLE `{$NAMESPACE}_phame`.`phame_blog`
	ADD `joinPolicy` varchar(64) COLLATE utf8_bin;			ADD `joinPolicy` varchar(64) COLLATE utf8_bin;

	UPDATE `{$NAMESPACE}_phame`.`phame_blog` SET joinPolicy = 'users'			UPDATE `{$NAMESPACE}_phame`.`phame_blog` SET joinPolicy = 'users'
	WHERE joinPolicy IS NULL;			WHERE joinPolicy IS NULL;