Import ezmlm-idx 0.40

[ezmlm] / sub_mysql / to40x

diff --git a/sub_mysql/to40x b/sub_mysql/to40x
new file mode 100755 (executable)
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;
+