X-Git-Url: https://git.distorted.org.uk/~mdw/odin-cgi/blobdiff_plain/497305bd6d365067b8ae327eb81351237227e3fa..c68a55498f50946e8fca9361386e11769c63aa4e:/sql/update-mail-v2.sql

diff --git a/sql/update-mail-v2.sql b/sql/update-mail-v2.sql
new file mode 100644
index 0000000..d771c7a
--- /dev/null
+++ b/sql/update-mail-v2.sql
@@ -0,0 +1,10 @@
+/* -*-sql-*-
+ *
+ * Plain old SQL for setting up the tables for Odin mail redirection.
+ */
+
+begin;
+alter table odin_mailredir add column creator varchar(64);
+update odin_mailredir set creator = owner where creator is null;
+alter table odin_mailredir alter column creator set not null;
+commit;
