fixup! Fix pgcrypto bug in migration 59

ammario · ammario · commit 8d92c22f2448 · 2022-10-16T21:04:43.000Z
diff --git a/coderd/database/migrations/000059_file_id.up.sql b/coderd/database/migrations/000059_file_id.up.sql
@@ -15,7 +15,7 @@ BEGIN;
 ALTER TABLE files DROP CONSTRAINT files_pkey;
 
 -- This extension is required by gen_random_uuid
-CREATE EXTENSION pgcrypto;
+CREATE EXTENSION IF NOT EXISTS pgcrypto;
 
 -- Add an 'id' column and designate it the primary key.
 ALTER TABLE files ADD COLUMN
