Index: debian_installer/lams2/2.3.0to2.3.1.sql
===================================================================
RCS file: /usr/local/cvsroot/debian_installer/lams2/2.3.0to2.3.1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ debian_installer/lams2/2.3.0to2.3.1.sql	10 Jul 2009 08:05:38 -0000	1.1
@@ -0,0 +1,4 @@
+-- Version strings
+update lams_configuration set config_value='2.3.1' where config_key='Version';
+update lams_configuration set config_value='2.3.1.200906190000' where config_key='AuthoringClientVersion' or config_key='MonitorClientVersion' or config_key="LearnerClientVersion" or config_key='ServerVersionNumber';
+update lams_configuration set config_value='2009-06-19' where config_key='DictionaryDateCreated';
\ No newline at end of file
Index: debian_installer/lams2/configure2.3.0.sql
===================================================================
RCS file: /usr/local/cvsroot/debian_installer/lams2/configure2.3.0.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ debian_installer/lams2/configure2.3.0.sql	10 Jul 2009 08:05:38 -0000	1.1
@@ -0,0 +1,2 @@
+-- disable videorecorder tool
+update lams_learning_library set valid_flag=0 where title='VideoRecorder';
Index: debian_installer/lams2/debian/changelog
===================================================================
RCS file: /usr/local/cvsroot/debian_installer/lams2/debian/changelog,v
diff -u -r1.4 -r1.5
--- debian_installer/lams2/debian/changelog	7 May 2009 17:47:43 -0000	1.4
+++ debian_installer/lams2/debian/changelog	10 Jul 2009 08:05:38 -0000	1.5
@@ -1,3 +1,9 @@
+lams2 (2.3.1-1) unstable; urgency=low
+
+  * update to 2.3.1
+  
+ -- LAMS Development Team <lamsdev@melcoe.mq.edu.au>  Fri, 10 Jul 2009 14:00:00 +1000
+
 lams2 (2.3.0-1) unstable; urgency=low
 
   * update to 2.3
Index: debian_installer/lams2/debian/lams2.install
===================================================================
RCS file: /usr/local/cvsroot/debian_installer/lams2/debian/lams2.install,v
diff -u -r1.5 -r1.6
--- debian_installer/lams2/debian/lams2.install	11 May 2009 15:13:11 -0000	1.5
+++ debian_installer/lams2/debian/lams2.install	10 Jul 2009 08:05:38 -0000	1.6
@@ -28,8 +28,10 @@
 lams_tool_spreadsheet	/usr/share/lams2/
 lams_tool_wiki	/usr/share/lams2/
 2.2.0to2.3.0.sql	/usr/share/lams2/
+configure2.3.0.sql	/usr/share/lams2/
 lams_tool_assessment	/usr/share/lams2/
 lams_tool_images	/usr/share/lams2/
 lams_tool_mindmap	/usr/share/lams2/
 lams_tool_pixlr	/usr/share/lams2/
 lams_tool_videorecorder	/usr/share/lams2/
+2.3.0to2.3.1.sql	/usr/share/lams2/
Index: debian_installer/lams2/debian/postinst
===================================================================
RCS file: /usr/local/cvsroot/debian_installer/lams2/debian/postinst,v
diff -u -r1.7 -r1.8
--- debian_installer/lams2/debian/postinst	2 Jun 2009 05:01:52 -0000	1.7
+++ debian_installer/lams2/debian/postinst	10 Jul 2009 08:05:38 -0000	1.8
@@ -17,6 +17,24 @@
 # for details, see http://www.debian.org/doc/debian-policy/ or
 # the debian-policy package
 
+update230to231 () {
+    # Update 2.3.0 database to 2.3.1
+    if [ "$db_root_pass" != "" ] ; then
+        mysql $db_name < /usr/share/lams2/2.3.0to2.3.1.sql -u root -p$db_root_pass || true
+    else
+        mysql $db_name < /usr/share/lams2/2.3.0to2.3.1.sql -u root || true
+    fi
+}
+
+configure230 () {
+    # Configure 2.3 tools; need to run after above tools have been deployed
+    if [ "$db_root_pass" != "" ] ; then
+        mysql $db_name < /usr/share/lams2/configure2.3.0.sql -u root -p$db_root_pass || true
+    else
+        mysql $db_name < /usr/share/lams2/configure2.3.0.sql -u root || true
+    fi
+}
+
 update220to230 () {
     # Update 2.2.0 database to 2.3
     if [ "$db_root_pass" != "" ] ; then
@@ -194,16 +212,25 @@
         sed -i -e "s/port=\"8080\"/port=\"$server_port\"/" server.xml
 
         case "$2" in
+            2.3.0*)
+                update;
+                update230to231;
+            ;;
+            
             2.2.0*)
                 update;
                 update220to230;
+                configure230;
+                update230to231;
             ;;
 
             2.1.1*)
                 update;
                 update211to220;
                 configure220;
                 update220to230;
+                configure230;
+                update230to231;
             ;;
 
             2.1.0*)
@@ -212,6 +239,8 @@
                 update211to220;
                 configure220;
                 update220to230;
+                configure230;
+                update230to231;
             ;;
 
             2.1rc1*)
@@ -221,6 +250,8 @@
                 update211to220;
                 configure220;
                 update220to230;
+                configure230;
+                update230to231;
             ;;
 
             *)
@@ -323,6 +354,7 @@
                 cp -rp /usr/share/lams2/repository/ /var/lib/lams/
 
                 configure220;
+                configure230;
 
                 # Add user and group
                 adduser --system --group --no-create-home lams 2> /dev/null
@@ -394,11 +426,13 @@
         rm -rf /usr/share/lams2/lams_tool_wiki
         rm -rf /usr/share/lams2/repository
         rm -f /usr/share/lams2/2.2.0to2.3.0.sql
+        rm -f /usr/share/lams2/configure2.3.0.sql
         rm -rf /usr/share/lams2/lams_tool_assessment
         rm -rf /usr/share/lams2/lams_tool_images
         rm -rf /usr/share/lams2/lams_tool_mindmap
         rm -rf /usr/share/lams2/lams_tool_pixlr
         rm -rf /usr/share/lams2/lams_tool_videorecorder
+        rm -f /usr/share/lams2/2.3.0to2.3.1.sql
 
         # Delete default ROOT.war/index.html (replaced with redirecting index.jsp)
         rm -f /usr/share/jboss-4.0.2/server/default/deploy/jbossweb-tomcat55.sar/ROOT.war/index.html