Use hex strings for hash values

[patchwork] / lib / sql / migration / 001-hex-hash-types.sql

diff --git a/lib/sql/migration/001-hex-hash-types.sql b/lib/sql/migration/001-hex-hash-types.sql
new file mode 100644 (file)
index 0000000..cef6b0b
--- /dev/null
+++ b/lib/sql/migration/001-hex-hash-types.sql
@@ -0,0 +1,8 @@
+BEGIN;
+ALTER TABLE patchwork_patch ALTER COLUMN hash DROP NOT NULL;
+UPDATE patchwork_patch SET hash = NULL;
+COMMIT;
+BEGIN;
+ALTER TABLE patchwork_patch ALTER COLUMN hash TYPE CHAR(40);
+CREATE INDEX "patchwork_patch_hash" ON "patchwork_patch" ("hash");
+COMMIT;