Index: lams_common/db/sql/insert_lams_unix_config_data.sql =================================================================== diff -u -r2f21856ec2ab85b47c93cfcc3fa2c8769be65077 -r626daa543c41c7bdf60d50acf8ec0a84e3ee723f --- lams_common/db/sql/insert_lams_unix_config_data.sql (.../insert_lams_unix_config_data.sql) (revision 2f21856ec2ab85b47c93cfcc3fa2c8769be65077) +++ lams_common/db/sql/insert_lams_unix_config_data.sql (.../insert_lams_unix_config_data.sql) (revision 626daa543c41c7bdf60d50acf8ec0a84e3ee723f) @@ -5,7 +5,7 @@ values ('ServerURLContextPath','lams/', 'config.server.url.context.path', 'config.header.system', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('Version','2.3.1', 'config.version', 'config.header.system', 'STRING', 1); +values ('Version','2.3.2', 'config.version', 'config.header.system', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('TempDir','/var/opt/lams/temp', 'config.temp.dir', 'config.header.system', 'STRING', 1); @@ -50,16 +50,16 @@ values ('AuthoringActivitiesColour', 'true', 'config.authoring.activities.colour', 'config.header.look.feel', 'BOOLEAN', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('AuthoringClientVersion','2.3.1.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1); +values ('AuthoringClientVersion','2.3.2.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('MonitorClientVersion','2.3.1.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1); +values ('MonitorClientVersion','2.3.2.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('LearnerClientVersion','2.3.1.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1); +values ('LearnerClientVersion','2.3.2.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('ServerVersionNumber','2.3.1.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1); +values ('ServerVersionNumber','2.3.2.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('ServerLanguage','en_AU', 'config.server.language', 'config.header.look.feel', 'STRING', 1); @@ -68,7 +68,7 @@ values ('ServerPageDirection','LTR', 'config.server.page.direction', 'config.header.look.feel', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('DictionaryDateCreated','2009-06-19', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1); +values ('DictionaryDateCreated','2009-08-28', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/', 'config.help.url', 'config.header.system', 'STRING', 1); Index: lams_common/db/sql/insert_lams_windows_config_data.sql =================================================================== diff -u -r2f21856ec2ab85b47c93cfcc3fa2c8769be65077 -r626daa543c41c7bdf60d50acf8ec0a84e3ee723f --- lams_common/db/sql/insert_lams_windows_config_data.sql (.../insert_lams_windows_config_data.sql) (revision 2f21856ec2ab85b47c93cfcc3fa2c8769be65077) +++ lams_common/db/sql/insert_lams_windows_config_data.sql (.../insert_lams_windows_config_data.sql) (revision 626daa543c41c7bdf60d50acf8ec0a84e3ee723f) @@ -5,7 +5,7 @@ values ('ServerURLContextPath','lams/', 'config.server.url.context.path', 'config.header.system', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('Version','2.3', 'config.version', 'config.header.system', 'STRING', 1); +values ('Version','2.3.2', 'config.version', 'config.header.system', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('TempDir','C:/lams/temp', 'config.temp.dir', 'config.header.system', 'STRING', 1); @@ -50,16 +50,16 @@ values ('AuthoringActivitiesColour', 'true', 'config.authoring.activities.colour', 'config.header.look.feel', 'BOOLEAN', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('AuthoringClientVersion','2.3.1.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1); +values ('AuthoringClientVersion','2.3.2.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('MonitorClientVersion','2.3.1.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1); +values ('MonitorClientVersion','2.3.2.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('LearnerClientVersion','2.3.1.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1); +values ('LearnerClientVersion','2.3.2.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('ServerVersionNumber','2.3.1.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1); +values ('ServerVersionNumber','2.3.2.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('ServerLanguage','en_AU', 'config.server.language', 'config.header.look.feel', 'STRING', 1); @@ -68,7 +68,7 @@ values ('ServerPageDirection','LTR', 'config.server.page.direction', 'config.header.look.feel', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) -values ('DictionaryDateCreated','2009-06-19', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1); +values ('DictionaryDateCreated','2009-08-28', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1); insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/', 'config.help.url', 'config.header.system', 'STRING', 1); Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030200_update232_version.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030200_update232_version.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030200_update232_version.sql (revision 626daa543c41c7bdf60d50acf8ec0a84e3ee723f) @@ -0,0 +1,12 @@ +-- SQL statements to set the database/lams version at 2.3.2 + +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; + +update lams_configuration set config_value='2.3.2' where config_key='Version'; +update lams_configuration set config_value='2.3.2.200908280000' where config_key='LearnerClientVersion' OR config_key='ServerVersionNumber' OR config_key='MonitorClientVersion' OR config_key='AuthoringClientVersion'; +update lams_configuration set config_value='2009-08-28' where config_key='DictionaryDateCreated'; + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; \ No newline at end of file