Index: lams_build/deploy-tool/lib/lams-tool-deploy.jar =================================================================== RCS file: /usr/local/cvsroot/lams_build/deploy-tool/lib/lams-tool-deploy.jar,v diff -u -r1.20 -r1.21 Binary files differ Index: lams_tool_chat/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/build.xml,v diff -u -r1.22 -r1.23 --- lams_tool_chat/build.xml 10 Jun 2008 06:10:25 -0000 1.22 +++ lams_tool_chat/build.xml 23 Sep 2008 04:21:23 -0000 1.23 @@ -103,6 +103,9 @@ + + + @@ -364,6 +367,16 @@ + + + + + + + + + + @@ -420,6 +433,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" Index: lams_tool_chat/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/conf/xdoclet/web-settings.xml,v diff -u -r1.6 -r1.7 --- lams_tool_chat/conf/xdoclet/web-settings.xml 8 Jun 2006 05:57:31 -0000 1.6 +++ lams_tool_chat/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:23 -0000 1.7 @@ -13,7 +13,8 @@ classpath:/org/lamsfoundation/lams/toolApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml - classpath:/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/chat/dbupdates/autopatchContext.xml Index: lams_tool_chat/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_chat/db/sql/db_version_insert.sql 23 Sep 2008 04:21:23 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:23 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:24 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_daco/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/build.xml,v diff -u -r1.4 -r1.5 --- lams_tool_daco/build.xml 8 Aug 2008 08:10:22 -0000 1.4 +++ lams_tool_daco/build.xml 23 Sep 2008 04:21:20 -0000 1.5 @@ -75,6 +75,8 @@ + + @@ -331,6 +333,16 @@ + + + + + + + + + + @@ -387,8 +399,9 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/daco/dacoApplicationContext.xml" - + lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" Index: lams_tool_daco/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_daco/db/sql/db_version_insert.sql 23 Sep 2008 04:21:20 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:20 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:20 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_daco/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/web/WEB-INF/web.xml,v diff -u -r1.2 -r1.3 --- lams_tool_daco/web/WEB-INF/web.xml 22 Sep 2008 05:29:20 -0000 1.2 +++ lams_tool_daco/web/WEB-INF/web.xml 23 Sep 2008 04:21:20 -0000 1.3 @@ -18,6 +18,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/daco/dacoApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/daco/dbupdates/autopatchContext.xml Index: lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java,v diff -u -r1.21 -r1.22 --- lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java 10 Jun 2008 06:02:42 -0000 1.21 +++ lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/Deploy.java 23 Sep 2008 04:21:26 -0000 1.22 @@ -184,6 +184,7 @@ dbDeployTask.setToolLibraryInsertScriptPath(config.getToolLibraryInsertScriptPath()); dbDeployTask.setToolActivityInsertScriptPath(config.getToolActivityInsertScriptPath()); dbDeployTask.setToolTablesScriptPath(config.getToolTablesScriptPath()); + dbDeployTask.setToolDBVersionScriptPath(config.getToolDBVersionScriptPath()); dbDeployTask.execute(); System.out.println("Deploying files to ear"); Index: lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/DeployToolConfig.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/DeployToolConfig.java,v diff -u -r1.16 -r1.17 --- lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/DeployToolConfig.java 10 Jun 2008 07:48:46 -0000 1.16 +++ lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/DeployToolConfig.java 23 Sep 2008 04:21:26 -0000 1.17 @@ -54,6 +54,7 @@ private static final String TOOL_LIBRARY_INSERT_SCRIPT_PATH = "toolLibraryInsertScriptPath"; private static final String TOOL_TABLES_SCRIPT_PATH = "toolTablesScriptPath"; private static final String TOOL_TABLES_DELETE_SCRIPT_PATH = "toolTablesDeleteScriptPath"; + private static final String TOOL_DB_VERSION_SCRIPT_PATH = "toolDBVersionScriptPath"; private static final String TOOL_APP_CONTEXT_FILE_PATH = "toolApplicationContextPath"; private static final String TOOL_JAR_FILE_NAME = "toolJarFileName"; private static final String DEPLOY_FILES= "deployFiles"; @@ -119,6 +120,11 @@ private String toolTablesDeleteScriptPath; /** + * Holds value of property toolDBVersionScriptPath. + */ + private String toolDBVersionScriptPath; + + /** * Holds value of property toolTablesDeleteScriptPath. */ private String toolApplicationContextPath; @@ -240,6 +246,10 @@ if ( key.equalsIgnoreCase(TOOL_TABLES_DELETE_SCRIPT_PATH) ) { toolTablesDeleteScriptPath = value; } + + if ( key.equalsIgnoreCase(TOOL_DB_VERSION_SCRIPT_PATH) ) { + toolDBVersionScriptPath = value; + } if ( key.equalsIgnoreCase(TOOL_APP_CONTEXT_FILE_PATH) ) { toolApplicationContextPath = value; @@ -301,6 +311,7 @@ valid = valid && validateStringProperty(toolInsertScriptPath, TOOL_INSERT_SCRIPT_PATH); valid = valid && validateStringProperty(toolLibraryInsertScriptPath, TOOL_LIBRARY_INSERT_SCRIPT_PATH); valid = valid && validateStringProperty(toolActivityInsertScriptPath, TOOL_ACTIVITY_INSERT_SCRIPT_PATH); + valid = valid && validateStringProperty(toolDBVersionScriptPath, TOOL_DB_VERSION_SCRIPT_PATH); valid = valid && validateStringProperty(toolWebUri, TOOL_TABLES_SCRIPT_PATH); valid = valid && validateStringProperty(toolApplicationContextPath, TOOL_APP_CONTEXT_FILE_PATH); valid = valid && validateStringProperty(toolJarFileName,TOOL_JAR_FILE_NAME); @@ -345,6 +356,8 @@ this.toolTablesScriptPath = config.getToolTablesScriptPath(); if (config.getToolTablesDeleteScriptPath() != null) this.toolTablesDeleteScriptPath = config.getToolTablesDeleteScriptPath(); + if (config.getToolDBVersionScriptPath() != null) + this.toolDBVersionScriptPath = config.getToolDBVersionScriptPath(); if (config.getToolApplicationContextPath() != null) this.toolApplicationContextPath = config.getToolApplicationContextPath(); if ( config.getToolJarFileName() != null ) @@ -373,6 +386,7 @@ System.out.println("ToolActivityInsertScriptPath: " + this.toolActivityInsertScriptPath); System.out.println("ToolTableScriptPath: " + this.toolTablesScriptPath); System.out.println("ToolTableDeleteScriptPath: " + this.toolTablesDeleteScriptPath); + System.out.println("ToolDBVersionScriptPath: " + this.toolDBVersionScriptPath); System.out.println("ToolApplicationContextPath: " + this.toolApplicationContextPath); System.out.println("ToolJarFileName: "+this.toolJarFileName); System.out.println("MinServerVersionNumber: "+this.minServerVersionNumber); @@ -550,6 +564,18 @@ public ArrayList getLanguageFiles() { return languageFiles; } + /** + * @return Returns the toolDBVersionScriptPath. + */ + public String getToolDBVersionScriptPath() { + return toolDBVersionScriptPath; + } + /** + * @param toolDBVersionScriptPath The toolDBVersionScriptPath to set. + */ + public void setToolDBVersionScriptPath(String toolDBVersionScriptPath) { + this.toolDBVersionScriptPath = toolDBVersionScriptPath; + } @@ -591,6 +617,7 @@ toolActivityInsertScriptPath = stripPath(toolActivityInsertScriptPath, outputPath, lengthOfPath); toolTablesScriptPath = stripPath(toolTablesScriptPath, outputPath, lengthOfPath); toolTablesDeleteScriptPath = stripPath(toolTablesDeleteScriptPath, outputPath, lengthOfPath); + toolDBVersionScriptPath = stripPath(toolDBVersionScriptPath, outputPath, lengthOfPath); ArrayList newLanguageFiles = new ArrayList(languageFiles.size()); for ( String file : languageFiles ) { Index: lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBDeployTask.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBDeployTask.java,v diff -u -r1.13 -r1.14 --- lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBDeployTask.java 15 Feb 2007 04:48:23 -0000 1.13 +++ lams_tool_deploy/src/java/org/lamsfoundation/lams/tool/deploy/ToolDBDeployTask.java 23 Sep 2008 04:21:26 -0000 1.14 @@ -62,6 +62,11 @@ private String toolUpdateScriptPath; /** + * File path to insert autopatch version script + */ + private String toolDBVersionScriptPath; + + /** * Holds value of property toolId. */ private long toolId; @@ -129,12 +134,22 @@ this.toolTablesScriptPath = toolTablesScriptPath; } + /** + * Setter for property toolDBVersionScriptPath. + * @param toolDBVersionScriptPath New value of property toolDBVersionScriptPath. + */ + public void setToolDBVersionScriptPath(String toolDBVersionScriptPath) + { + this.toolDBVersionScriptPath = toolDBVersionScriptPath; + } + public void execute() throws DeployException { toolInsertScript = new File(toolInsertScriptPath); toolLibraryInsertScript = new File(toolLibraryInsertScriptPath); toolActivityInsertScript = new File(toolActivityInsertScriptPath); toolTablesScript = new File(toolTablesScriptPath); + toolDBVersionScript = new File(toolDBVersionScriptPath); //get a connection Connection conn = getConnection(); try @@ -182,6 +197,9 @@ //run the tool table script runScript(toolTablesScriptSQL, conn); + //run the db version script + runScript(readFile(toolDBVersionScript), conn); + //commit transaction conn.commit(); } @@ -427,4 +445,6 @@ private File toolLibraryInsertScript; private File toolTablesScript; + + private File toolDBVersionScript; } Index: lams_tool_dimdim/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_dimdim/build.xml,v diff -u -r1.1 -r1.2 --- lams_tool_dimdim/build.xml 15 Aug 2008 08:42:42 -0000 1.1 +++ lams_tool_dimdim/build.xml 23 Sep 2008 04:21:19 -0000 1.2 @@ -103,6 +103,9 @@ + + + @@ -364,6 +367,16 @@ + + + + + + + + + + @@ -420,6 +433,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/dimdim/dimdimApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" Index: lams_tool_dimdim/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_dimdim/conf/xdoclet/Attic/web-settings.xml,v diff -u -r1.1 -r1.2 --- lams_tool_dimdim/conf/xdoclet/web-settings.xml 15 Aug 2008 08:42:42 -0000 1.1 +++ lams_tool_dimdim/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:19 -0000 1.2 @@ -13,7 +13,8 @@ classpath:/org/lamsfoundation/lams/toolApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml - classpath:/org/lamsfoundation/lams/tool/dimdim/dimdimApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/dimdim/dimdimApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/dimdim/dbupdates/autopatchContext.xml Index: lams_tool_dimdim/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_dimdim/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_dimdim/db/sql/db_version_insert.sql 23 Sep 2008 04:21:19 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:19 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_dimdim/src/java/org/lamsfoundation/lams/tool/dimdim/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_dimdim/src/java/org/lamsfoundation/lams/tool/dimdim/dbupdates/Attic/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_dimdim/src/java/org/lamsfoundation/lams/tool/dimdim/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:19 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_forum/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/build.xml,v diff -u -r1.52 -r1.53 --- lams_tool_forum/build.xml 10 Jun 2008 06:10:52 -0000 1.52 +++ lams_tool_forum/build.xml 23 Sep 2008 04:21:19 -0000 1.53 @@ -75,6 +75,8 @@ + + @@ -334,6 +336,16 @@ + + + + + + + + + + @@ -391,6 +403,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" Index: lams_tool_forum/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/conf/xdoclet/web-settings.xml,v diff -u -r1.10 -r1.11 --- lams_tool_forum/conf/xdoclet/web-settings.xml 22 Sep 2008 06:40:01 -0000 1.10 +++ lams_tool_forum/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:19 -0000 1.11 @@ -18,6 +18,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/forum/dbupdates/autopatchContext.xml Index: lams_tool_forum/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_forum/db/sql/db_version_insert.sql 23 Sep 2008 04:21:19 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:19 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:19 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_gmap/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_gmap/build.xml,v diff -u -r1.3 -r1.4 --- lams_tool_gmap/build.xml 3 Jun 2008 03:53:16 -0000 1.3 +++ lams_tool_gmap/build.xml 23 Sep 2008 04:21:18 -0000 1.4 @@ -103,6 +103,9 @@ + + + @@ -383,6 +386,16 @@ + + + + + + + + + + @@ -438,6 +451,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/gmap/gmapApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" Index: lams_tool_gmap/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_gmap/conf/xdoclet/web-settings.xml,v diff -u -r1.1 -r1.2 --- lams_tool_gmap/conf/xdoclet/web-settings.xml 23 May 2008 06:29:10 -0000 1.1 +++ lams_tool_gmap/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:18 -0000 1.2 @@ -14,6 +14,7 @@ classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml classpath:/org/lamsfoundation/lams/tool/gmap/gmapApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/gmap/dbupdates/autopatchContext.xml Index: lams_tool_gmap/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_gmap/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_gmap/db/sql/db_version_insert.sql 23 Sep 2008 04:21:17 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:17 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:18 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_lamc/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_lamc/build.xml,v diff -u -r1.45 -r1.46 --- lams_tool_lamc/build.xml 10 Jun 2008 06:11:59 -0000 1.45 +++ lams_tool_lamc/build.xml 23 Sep 2008 04:21:20 -0000 1.46 @@ -136,6 +136,9 @@ + + + @@ -344,6 +347,16 @@ + + + + + + + + + + @@ -400,6 +413,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" Index: lams_tool_lamc/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_lamc/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_lamc/db/sql/db_version_insert.sql 23 Sep 2008 04:21:20 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:20 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:20 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_lamc/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_lamc/web/WEB-INF/web.xml,v diff -u -r1.25 -r1.26 --- lams_tool_lamc/web/WEB-INF/web.xml 22 Sep 2008 05:29:24 -0000 1.25 +++ lams_tool_lamc/web/WEB-INF/web.xml 23 Sep 2008 04:21:20 -0000 1.26 @@ -15,6 +15,7 @@ classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/mc/dbupdates/autopatchContext.xml Index: lams_tool_laqa/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/build.xml,v diff -u -r1.44 -r1.45 --- lams_tool_laqa/build.xml 10 Jun 2008 06:13:51 -0000 1.44 +++ lams_tool_laqa/build.xml 23 Sep 2008 04:21:22 -0000 1.45 @@ -122,6 +122,9 @@ + + + @@ -325,6 +328,16 @@ + + + + + + + + + + @@ -381,6 +394,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml" lamsEarPath="${jboss.deploy}" Index: lams_tool_laqa/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/db/sql/db_version_insert.sql 23 Sep 2008 04:21:22 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:22 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:22 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_laqa/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/web.xml,v diff -u -r1.27 -r1.28 --- lams_tool_laqa/web/WEB-INF/web.xml 22 Sep 2008 05:29:22 -0000 1.27 +++ lams_tool_laqa/web/WEB-INF/web.xml 23 Sep 2008 04:21:22 -0000 1.28 @@ -16,6 +16,7 @@ classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml classpath:/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/qa/dbupdates/autopatchContext.xml Index: lams_tool_larsrc/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/build.xml,v diff -u -r1.22 -r1.23 --- lams_tool_larsrc/build.xml 10 Jun 2008 06:14:57 -0000 1.22 +++ lams_tool_larsrc/build.xml 23 Sep 2008 04:21:20 -0000 1.23 @@ -78,6 +78,8 @@ + + @@ -341,6 +343,16 @@ + + + + + + + + + + @@ -398,6 +410,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml" lamsEarPath="${jboss.deploy}" Index: lams_tool_larsrc/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_larsrc/db/sql/db_version_insert.sql 23 Sep 2008 04:21:21 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:21 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:21 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_larsrc/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/web/WEB-INF/web.xml,v diff -u -r1.16 -r1.17 --- lams_tool_larsrc/web/WEB-INF/web.xml 22 Sep 2008 05:29:22 -0000 1.16 +++ lams_tool_larsrc/web/WEB-INF/web.xml 23 Sep 2008 04:21:21 -0000 1.17 @@ -18,6 +18,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/rsrc/dbupdates/autopatchContext.xml Index: lams_tool_nb/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/build.xml,v diff -u -r1.39 -r1.40 --- lams_tool_nb/build.xml 10 Jun 2008 06:16:48 -0000 1.39 +++ lams_tool_nb/build.xml 23 Sep 2008 04:21:19 -0000 1.40 @@ -101,6 +101,9 @@ + + + @@ -417,6 +420,16 @@ + + + + + + + + + + @@ -473,6 +486,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" Index: lams_tool_nb/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/conf/xdoclet/web-settings.xml,v diff -u -r1.6 -r1.7 --- lams_tool_nb/conf/xdoclet/web-settings.xml 22 Sep 2008 06:58:39 -0000 1.6 +++ lams_tool_nb/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:19 -0000 1.7 @@ -11,5 +11,6 @@ classpath:/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/noticeboard/dbupdates/autopatchContext.xml Index: lams_tool_nb/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_nb/db/sql/db_version_insert.sql 23 Sep 2008 04:21:19 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:19 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:19 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_notebook/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_notebook/build.xml,v diff -u -r1.13 -r1.14 --- lams_tool_notebook/build.xml 10 Jun 2008 06:16:43 -0000 1.13 +++ lams_tool_notebook/build.xml 23 Sep 2008 04:21:22 -0000 1.14 @@ -103,6 +103,9 @@ + + + @@ -364,6 +367,16 @@ + + + + + + + + + + @@ -420,6 +433,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" Index: lams_tool_notebook/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_notebook/conf/xdoclet/web-settings.xml,v diff -u -r1.1 -r1.2 --- lams_tool_notebook/conf/xdoclet/web-settings.xml 20 Jul 2006 01:11:09 -0000 1.1 +++ lams_tool_notebook/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:22 -0000 1.2 @@ -14,6 +14,7 @@ classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml classpath:/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/notebook/dbupdates/autopatchContext.xml Index: lams_tool_notebook/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_notebook/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_notebook/db/sql/db_version_insert.sql 23 Sep 2008 04:21:22 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:22 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:22 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_sbmt/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_sbmt/build.xml,v diff -u -r1.47 -r1.48 --- lams_tool_sbmt/build.xml 10 Jun 2008 06:16:47 -0000 1.47 +++ lams_tool_sbmt/build.xml 23 Sep 2008 04:21:23 -0000 1.48 @@ -196,6 +196,8 @@ + + @@ -355,6 +357,16 @@ + + + + + + + + + + @@ -411,6 +423,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" Index: lams_tool_sbmt/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_sbmt/conf/xdoclet/web-settings.xml,v diff -u -r1.7 -r1.8 --- lams_tool_sbmt/conf/xdoclet/web-settings.xml 1 Jul 2006 03:39:19 -0000 1.7 +++ lams_tool_sbmt/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:23 -0000 1.8 @@ -10,6 +10,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/toolApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/sbmt/dbupdates/autopatchContext.xml Index: lams_tool_sbmt/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_sbmt/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_sbmt/db/sql/db_version_insert.sql 23 Sep 2008 04:21:23 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:23 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:23 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_scribe/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scribe/build.xml,v diff -u -r1.13 -r1.14 --- lams_tool_scribe/build.xml 10 Jun 2008 06:16:45 -0000 1.13 +++ lams_tool_scribe/build.xml 23 Sep 2008 04:21:21 -0000 1.14 @@ -103,6 +103,9 @@ + + + @@ -364,6 +367,16 @@ + + + + + + + + + + @@ -420,6 +433,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" toolWebUri="${product}.war" Index: lams_tool_scribe/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scribe/conf/xdoclet/web-settings.xml,v diff -u -r1.1 -r1.2 --- lams_tool_scribe/conf/xdoclet/web-settings.xml 15 Sep 2006 03:09:52 -0000 1.1 +++ lams_tool_scribe/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:22 -0000 1.2 @@ -14,6 +14,7 @@ classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml classpath:/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/scribe/dbupdates/autopatchContext.xml Index: lams_tool_scribe/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scribe/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_scribe/db/sql/db_version_insert.sql 23 Sep 2008 04:21:22 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:22 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:21 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_spreadsheet/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/build.xml,v diff -u -r1.1 -r1.2 --- lams_tool_spreadsheet/build.xml 4 Jul 2008 07:40:26 -0000 1.1 +++ lams_tool_spreadsheet/build.xml 23 Sep 2008 04:21:24 -0000 1.2 @@ -78,6 +78,8 @@ + + @@ -345,6 +347,16 @@ + + + + + + + + + + @@ -401,6 +413,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/spreadsheet/spreadsheetApplicationContext.xml" lamsEarPath="${jboss.deploy}" Index: lams_tool_spreadsheet/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_spreadsheet/db/sql/db_version_insert.sql 23 Sep 2008 04:21:25 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:25 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:24 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_spreadsheet/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_spreadsheet/web/WEB-INF/web.xml,v diff -u -r1.1 -r1.2 --- lams_tool_spreadsheet/web/WEB-INF/web.xml 4 Jul 2008 07:40:26 -0000 1.1 +++ lams_tool_spreadsheet/web/WEB-INF/web.xml 23 Sep 2008 04:21:25 -0000 1.2 @@ -18,6 +18,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/spreadsheet/spreadsheetApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/autopatchContext.xml Index: lams_tool_survey/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/build.xml,v diff -u -r1.13 -r1.14 --- lams_tool_survey/build.xml 10 Jun 2008 06:16:44 -0000 1.13 +++ lams_tool_survey/build.xml 23 Sep 2008 04:21:20 -0000 1.14 @@ -75,6 +75,8 @@ + + @@ -333,6 +335,16 @@ + + + + + + + + + + @@ -389,6 +401,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml" lamsEarPath="${jboss.deploy}" Index: lams_tool_survey/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_survey/db/sql/db_version_insert.sql 23 Sep 2008 04:21:20 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:20 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:20 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_survey/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/web/WEB-INF/web.xml,v diff -u -r1.7 -r1.8 --- lams_tool_survey/web/WEB-INF/web.xml 22 Sep 2008 05:29:21 -0000 1.7 +++ lams_tool_survey/web/WEB-INF/web.xml 23 Sep 2008 04:21:20 -0000 1.8 @@ -18,6 +18,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/survey/dbupdates/autopatchContext.xml Index: lams_tool_task/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_task/build.xml,v diff -u -r1.4 -r1.5 --- lams_tool_task/build.xml 10 Jun 2008 06:16:50 -0000 1.4 +++ lams_tool_task/build.xml 23 Sep 2008 04:21:25 -0000 1.5 @@ -79,6 +79,8 @@ + + @@ -336,6 +338,16 @@ + + + + + + + + + + @@ -393,6 +405,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/taskList/taskListApplicationContext.xml" lamsEarPath="${jboss.deploy}" Index: lams_tool_task/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_task/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_task/db/sql/db_version_insert.sql 23 Sep 2008 04:21:25 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:25 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:25 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_task/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_task/web/WEB-INF/web.xml,v diff -u -r1.2 -r1.3 --- lams_tool_task/web/WEB-INF/web.xml 22 Sep 2008 05:29:23 -0000 1.2 +++ lams_tool_task/web/WEB-INF/web.xml 23 Sep 2008 04:21:25 -0000 1.3 @@ -18,6 +18,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/taskList/taskListApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/taskList/dbupdates/autopatchContext.xml Index: lams_tool_vote/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/build.xml,v diff -u -r1.20 -r1.21 --- lams_tool_vote/build.xml 10 Jun 2008 06:16:46 -0000 1.20 +++ lams_tool_vote/build.xml 23 Sep 2008 04:21:26 -0000 1.21 @@ -156,6 +156,9 @@ + + + @@ -360,6 +363,16 @@ + + + + + + + + + + @@ -416,6 +429,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml" lamsEarPath="${jboss.deploy}" Index: lams_tool_vote/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_vote/db/sql/db_version_insert.sql 23 Sep 2008 04:21:26 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:26 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:27 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file Index: lams_tool_vote/web/WEB-INF/web.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/web/WEB-INF/web.xml,v diff -u -r1.14 -r1.15 --- lams_tool_vote/web/WEB-INF/web.xml 22 Sep 2008 05:29:20 -0000 1.14 +++ lams_tool_vote/web/WEB-INF/web.xml 23 Sep 2008 04:21:26 -0000 1.15 @@ -35,6 +35,7 @@ classpath:/org/lamsfoundation/lams/contentrepository/applicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/vote/dbupdates/autopatchContext.xml Index: lams_tool_wiki_orig/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wiki_orig/build.xml,v diff -u -r1.5 -r1.6 --- lams_tool_wiki_orig/build.xml 10 Jun 2008 06:16:51 -0000 1.5 +++ lams_tool_wiki_orig/build.xml 23 Sep 2008 04:21:24 -0000 1.6 @@ -75,6 +75,8 @@ + + @@ -334,6 +336,16 @@ + + + + + + + + + + @@ -391,6 +403,7 @@ toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" toolLibraryInsertScriptPath="${build.deploy}/sql/library_insert.sql" toolInsertScriptPath="${build.deploy}/sql/tool_insert.sql" + toolDBVersionScriptPath="${build.deploy}/sql/db_version_insert.sql" toolApplicationContextPath="/org/lamsfoundation/lams/tool/wiki/wikiApplicationContext.xml" lamsEarPath="${jboss.deploy}" toolContext="${toolContext}" Index: lams_tool_wiki_orig/conf/xdoclet/web-settings.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wiki_orig/conf/xdoclet/web-settings.xml,v diff -u -r1.5 -r1.6 --- lams_tool_wiki_orig/conf/xdoclet/web-settings.xml 22 Sep 2008 07:13:37 -0000 1.5 +++ lams_tool_wiki_orig/conf/xdoclet/web-settings.xml 23 Sep 2008 04:21:24 -0000 1.6 @@ -18,6 +18,7 @@ classpath:/org/lamsfoundation/lams/lesson/lessonApplicationContext.xml classpath:/org/lamsfoundation/lams/learning/learningApplicationContext.xml classpath:/org/lamsfoundation/lams/tool/wiki/wikiApplicationContext.xml + classpath:/org/lamsfoundation/lams/tool/wiki/dbupdates/autopatchContext.xml Index: lams_tool_wiki_orig/db/sql/db_version_insert.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wiki_orig/db/sql/db_version_insert.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_wiki_orig/db/sql/db_version_insert.sql 23 Sep 2008 04:21:24 -0000 1.1 @@ -0,0 +1,2 @@ +-- $Id: db_version_insert.sql,v 1.1 2008/09/23 04:21:24 jliew Exp $ +INSERT INTO patches VALUES ('@signature@', '@tool_version@', NOW(), 'F'); \ No newline at end of file Index: lams_tool_wiki_orig/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/autopatchContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_wiki_orig/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/autopatchContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_wiki_orig/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/autopatchContext.xml 23 Sep 2008 04:21:24 -0000 1.1 @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file