science-ation/db/db.update.166.sql
dave 89547f902a Some fairs did a rollvoer before the NULL was fixed (I think it was
fixed), and reset some award sources to 0 instead of NULL.
award_source_fairs_id can never be 0 anyway (unless someone edits the DB
manually), so just set them back to NULL so the existing code works.
2010-02-22 18:45:57 +00:00

3 lines
83 B
SQL

UPDATE award_awards SET award_source_fairs_id=NULL WHERE award_source_fairs_id=0;