20160330.badges.migratequality.sql
00425cac94d5master

20160330.badges.migratequality.sql
View Options

			/* Change quality from color to int */

			UPDATE {$NAMESPACE}_badges.badges_badge
			SET quality = 140
			WHERE quality = 'grey';

			UPDATE {$NAMESPACE}_badges.badges_badge
			SET quality = 120
			WHERE quality = 'white';

			UPDATE {$NAMESPACE}_badges.badges_badge
			SET quality = 100
			WHERE quality = 'green';

			UPDATE {$NAMESPACE}_badges.badges_badge
			SET quality = 80
			WHERE quality = 'blue';

			UPDATE {$NAMESPACE}_badges.badges_badge
			SET quality = 60
			WHERE quality = 'indigo';

			UPDATE {$NAMESPACE}_badges.badges_badge
			SET quality = 40
			WHERE quality = 'orange';

			UPDATE {$NAMESPACE}_badges.badges_badge
			SET quality = 20
			WHERE quality = 'yellow';

			ALTER TABLE {$NAMESPACE}_badges.badges_badge
			MODIFY quality INT UNSIGNED NOT NULL;