wdbccc/Asset-Map — pull request #40 by sacparker (2012-08-24 06:07:41+00:00)
Title: boolean fields to replace asset type column

now assets could be in multiple places and a little easier to manage in
database

should we delete the old field in the database or leave there for the next data import?

UPDATE asset SET type_advice = true WHERE type = 'Advice';
UPDATE asset SET type_financial = true WHERE type = 'Financial';
UPDATE asset SET type_employer_incentives = true WHERE type = 'Workforce';
UPDATE asset SET type_green_business = true WHERE type = 'Green Business';
UPDATE asset SET type_networking = true WHERE type = 'Networking';