| 1 |
|
| 2 |
ALTER TABLE projects ADD COLUMN features TEXT[] NOT NULL DEFAULT '{}'; |
| 3 |
|
| 4 |
|
| 5 |
UPDATE projects SET features = CASE project_type |
| 6 |
WHEN 'music' THEN ARRAY['audio', 'blog'] |
| 7 |
WHEN 'podcast' THEN ARRAY['audio', 'blog'] |
| 8 |
WHEN 'blog' THEN ARRAY['text', 'blog'] |
| 9 |
WHEN 'book' THEN ARRAY['text'] |
| 10 |
WHEN 'course' THEN ARRAY['downloads', 'text'] |
| 11 |
WHEN 'software' THEN ARRAY['downloads', 'blog'] |
| 12 |
WHEN 'art' THEN ARRAY['downloads'] |
| 13 |
WHEN 'writing' THEN ARRAY['text', 'blog'] |
| 14 |
ELSE ARRAY['downloads'] |
| 15 |
END; |
| 16 |
|