migrate column content to jsonb

[stevenhao]

a follow-up to https://github.com/downforacross/downforacross.com/pull/148

• [x] ran with psql < migrate_puzzles_content_1_24_21.sql
• [x] ran with PGDATABASE=production psql < migrate_puzzles_content_1_24_21.sql

psql -c '\d puzzles' 
                           Table "public.puzzles"
   Column    |            Type             | Collation | Nullable | Default 
-------------+-----------------------------+-----------+----------+---------
 uid         | text                        |           |          | 
 pid         | text                        |           | not null | 
 is_public   | boolean                     |           |          | 
 uploaded_at | timestamp without time zone |           |          | 
 content     | jsonb                       |           |          | 
Indexes:
    "puzzles_pkey" PRIMARY KEY, btree (pid)

PGDATABASE=production psql -c '\d puzzles'
                           Table "public.puzzles"
   Column    |            Type             | Collation | Nullable | Default 
-------------+-----------------------------+-----------+----------+---------
 uid         | text                        |           |          | 
 pid         | text                        |           | not null | 
 is_public   | boolean                     |           |          | 
 uploaded_at | timestamp without time zone |           |          | 
 content     | jsonb                       |           |          | 
Indexes:
    "puzzles_pkey" PRIMARY KEY, btree (pid)

[vercel[bot]]

This pull request is being automatically deployed with Vercel (learn more).
To see the status of your deployment, click below or on the icon next to each commit.

🔍 Inspect: https://vercel.com/downforacross/downforacrosscom/e5dutfq9h
✅ Preview: https://downforacrosscom-git-sql-migrate-puzzles-content.downforacross1.now.sh