X-Git-Url: https://git.distorted.org.uk/~mdw/ezmlm/blobdiff_plain/5b62e993b0af39700031c2875d7f6654e6a02850..f8beb284087c279acfb30506f5bb32baa4949b44:/sub_mysql/to40x

diff --git a/sub_mysql/to40x b/sub_mysql/to40x
new file mode 100755
index 0000000..5f6f872
--- /dev/null
+++ b/sub_mysql/to40x
@@ -0,0 +1,15 @@
+#!/bin/sh
+cat <<EOF
+ALTER TABLE ${1}_cookie
+	 ADD COLUMN chunk TINYINT NOT NULL DEFAULT 0;
+ALTER TABLE ${1}_cookie
+	 ADD COLUMN bodysize INTEGER NOT NULL DEFAULT 0;
+ALTER TABLE ${1}_mlog
+	 ADD COLUMN subs INTEGER NOT NULL DEFAULT 0;
+ALTER TABLE ${1}_digest_cookie
+	 ADD COLUMN chunk TINYINT NOT NULL DEFAULT 0;
+ALTER TABLE ${1}_digest_cookie
+	 ADD COLUMN bodysize INTEGER NOT NULL DEFAULT 0;
+ALTER TABLE ${1}_digest_mlog
+	 ADD COLUMN subs INTEGER NOT NULL DEFAULT 0;
+