From 2256e1b43b9d9b30fd0ce5ba906eda0336d0f764 Mon Sep 17 00:00:00 2001
From: x2003bruneau <x2003bruneau@839d8a87-29fc-0310-9880-83ba4fa771e5>
Date: Mon, 26 Mar 2007 16:51:30 +0000
Subject: [PATCH] Add upgrade script for 0.9.14 (just hope it will be ok :)

git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1615 839d8a87-29fc-0310-9880-83ba4fa771e5
---
 upgrade/0.9.14/update.sh    | 64 +++++++++++++++++++++++++++++++++++++++++++++
 upgrade/0.9.14/wiki.utf8.sh |  2 ++
 2 files changed, 66 insertions(+)
 create mode 100755 upgrade/0.9.14/update.sh

diff --git a/upgrade/0.9.14/update.sh b/upgrade/0.9.14/update.sh
new file mode 100755
index 0000000..81d34d6
--- /dev/null
+++ b/upgrade/0.9.14/update.sh
@@ -0,0 +1,64 @@
+#!/bin/bash
+
+. ../inc/pervasive.sh
+
+mailman_stop
+mailman_templates
+mailman_start
+
+###########################################################
+
+echo "we will now convert the wiki spool to UTF8. This may cause page corruption."
+
+./wiki.utf8.php
+
+###########################################################
+
+echo "fix geoloc table charset
+
+please hit ^D to continue"
+
+cat
+
+./geoloc.utf8.php
+
+###########################################################
+
+echo "upgrading database"
+
+for sql in *.sql
+do
+    echo -n $sql
+    $MYSQL x4dat < $sql &>/dev/null || echo -n " ERROR"
+    echo .
+done
+
+###########################################################
+
+echo "we will now upgrade the search table (this may be a long operation)
+
+please hit ^D to continue
+"
+
+cat
+
+pushd ../../bin
+./search.rebuild_db.php
+popd
+
+###########################################################
+
+echo "we will now upgrade the banana spool
+
+please hit ^D to continue
+"
+
+cat
+
+pushd ../../bin
+rm -rf /var/spool/banana/MLArchive
+rm -f /var/spool/banana/templates_c/*
+./banana.spoolgen.php
+popd
+
+############################################################
diff --git a/upgrade/0.9.14/wiki.utf8.sh b/upgrade/0.9.14/wiki.utf8.sh
index 4e62d0f..e469bb3 100644
--- a/upgrade/0.9.14/wiki.utf8.sh
+++ b/upgrade/0.9.14/wiki.utf8.sh
@@ -14,3 +14,5 @@ echo "Verifie que tout c'est bien passe en presse ^D"
 cat
 
 find $WIKISPOOLDIR -name '*.latin1' -exec rm {} ";"
+chown -R www-data:www-data $WIKISPOOLDIR
+
-- 
2.1.4