Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Changed size of locale_id column from TINYINT(4) to INTEGER. This required changing three tables - lams_supported_locale, lams_user and lams_organisation. A script to update a 2.0 database can be found in lams_common/sql/update/alter_201_locale_id.sql
  • alter table lams_lesson add column learner_exportport_avail tinyint(1);
  • Added a new column "image_directory" to the table lams_css_theme_ve. A script to update a 2.0 database can be found in lams_common/sql/update/alter_201_theme.sql. This includes code to set up the appropriate values for the current default theme.
  • Script alter_201_system_tool_user_workspace.sql:
    • Updated the Learner Progress URL for grouping - data change rather than ddl change.
    • Added new column change_password to lams_user, defaults to 0 (false). Script also sets an initial value of 0 for any existing users in the system
  • Survey Tool: Changed column for text entry answers from varchar(255) to text. Script is updateTo20070208. Also updated the tool version (to 20070208) in the tool table entry in tool_insert.sql script.
  • Extend the length of the login name to from varchar(20) to varchar(255). This requires changes to the following projects:
    • lams_common. Update done as part of the alter_201_system_tool_user_workspace.sql update.
    • lams_workspace_folder. Increased size of name field from varchar(64) to varchar(255). Update done as part of the alter_201_system_tool_user_workspace.sql update
    • lams_tool_lamc. Updated both the login and fullname columns. Script updateTo20070214.sql, changed build.properties to have new version number (20070214)
    • lams_tool_laqa. Updated both the login and fullname columns. Script updateTo20070214.sql, changed build.properties to have new version number (20070214)
    • lams_tool_nb. Updated both the login and fullname columns. Script updateTo20070214.sql, changed build.properties to have new version number (20070214)
    • lams_tool_vote. Updated both the login and fullname columns. Script updateTo20070214.sql, changed build.properties to have new version number (20070214)
  • Added 3 new columns to lams_tool table - see alter_201_tool.sql
  • summary of update scripts:
    No Format
    lams_common/db/sql/updatescripts/alter_201_locale_id.sql
    
    lams_common/db/sql/updatescripts/alter_201_theme.sql
    
    lams_common/db/sql/updatescripts/alter_201_system_tool_user_workspace.sql
     
    lams_common/db/sql/updatescripts/alter_201_tool.sql
     
    lams_tool_survey/db/sql/updatescripts/updateto20070220.sql
    
    lams_tool_lamc/db/sql/updatescripts/updateto20070214.sql
    
    lams_tool_laqa/db/sql/updatescripts/updateto20070214.sql
    
    lams_tool_nb/db/sql/updatescripts/updateto20070214.sql
    
    lams_tool_vote/db/sql/updatescripts/updateto20070214.sql
    

...

No Format
lams_tool_nb/db/sql/updatescripts/updateTo20070315.sql
 
lams_tool_chat/db/sql/updatescripts/updateTo20070315.sql
 
lams_tool_scribe/db/sql/updatescripts/updateTo20070315.sql
No Format
update lams_tool set tool_version=20070315 where tool_signature='lanb11';
 
update lams_tool set tool_version=20070315 where tool_signature='lachat11';
 
update lams_tool set tool_version=20070315 where tool_signature='lascrb11';
 
update lams_configuration set config_value='2.0.2' where config_key='Version';
 
update lams_configuration set config_value='2.0.2.200703270000' where config_key='AuthoringClientVersion';
 
update lams_configuration set config_value='2.0.2.200703270000' where config_key='MonitorClientVersion';
 
update lams_configuration set config_value='2.0.2.200703270000' where config_key='LearnerClientVersion';
 
update lams_configuration set config_value='2.0.2.200703270000' where config_key='ServerVersionNumber';
 
update lams_configuration set config_value='2007-03-08' where config_key='DictionaryDateCreated';

...

No Format
javac -cp "commons-logging.jar:hibernate3.jar:mysql-connector-java-3.1.12-bin.jar:." UpdateLAMS202Chat.java
 
java -cp "commons-logging.jar:hibernate3.jar:mysql-connector-java-3.1.12-bin.jar:." UpdateLAMS202Chat conference.localhost

...

No Format
update lams_configuration set config_value='2.0.3' where config_key='Version';
 
update lams_configuration set config_value='2.0.3.200706040000' where config_key='AuthoringClientVersion';
 
update lams_configuration set config_value='2.0.3.200706040000' where config_key='MonitorClientVersion';
 
update lams_configuration set config_value='2.0.3.200706040000' where config_key='LearnerClientVersion';
 
update lams_configuration set config_value='2.0.3.200706040000' where config_key='ServerVersionNumber';
 
update lams_configuration set config_value='2007-05-24' where config_key='DictionaryDateCreated';

...

No Format
titleaddition to alter_204_editonfly.sql on June 07
INSERT INTO lams_system_tool (system_tool_id, learning_activity_type_id, tool_display_name, description,
 	 
learner_url, learner_preview_url, learner_progress_url, export_pfolio_learner_url,
 	 
export_pfolio_class_url, monitor_url, contribute_url, create_date_time)

VALUES (5, 9, 'System Gate', 'Gate: Opens under system control.',
 	
'learning/gate.do?method=knockGate', 'learning/gate.do?method=knockGate', null, null,
 	 
'monitoring/gateExportPortfolio?mode=teacher', 'monitoring/gate.do?method=viewGate',
 	
'monitoring/gate.do?method=viewGate', now()	

);

From LAMS 2.0.3/2.0.4 to 2.0.6

...

  • alter_21_branching.sql
    • Core tables: alter_21_branching.sql (LDEV-1109). New rows in some of the core tables and a new table added.
    • 26 new ldap related rows in lams_configuration.
    • 1 new row for the learner progress batch size in lams_configuration.
    • All rows in lams_configuration updated to include decriptions and their headings.
    • index page stuff for collapsible courses and lesson sorting
  • lams-www: WEB-INF/lams.tld and WEB-INF/tags/* have been updated - take all the files.
  • jsmath has been updated: Basically update everything except the fonts subfolder. That would make it easiest. The fonts folder is almost never updated (on the jsmath website, it's a separate download). It's also where most of the small 1kb files come from, so should help cut down the size. (see Jun-Dir for more details)
  • Multiple Choice Tool: tl_lamc11_que_usr has two new columns (last_attempt_order, last_attempt_total_mark) and the version number is now 20070820. The update script is updateTo20070820.sql. Performance improvements to learning and monitoring. One change to the I18N files.
  • Scribe: tl_lascrb11_scribe has one new column (aggregated_reports) and the version number is now 20071113.
  • updated login-config.xml; lamsauthentication.xml is deprecated.
  • Added a new folder to lams-www: web/help. In this folder, we add pdf files (as "troubleshoot-<language>_<locale>.pdf"). These files are then retrieved to a help link in the login page see LDEV-907 for further details.
  • Alter21Integration.java (LDEV-1284). Modifies integration orgs and adds workspaces. Run like this (the arguments in the 2nd line are db name, db user, and db password):
    No Format
    javac -cp "/usr/local/jboss-4.0.2/server/default/deploy/lams.ear/mysql-connector-java-3.1.12-bin.jar:." Alter21Integration.java
      
    java -cp "/usr/local/jboss-4.0.2/server/default/deploy/lams.ear/mysql-connector-java-3.1.12-bin.jar:." Alter21Integration lams lams lamsdemo
    
  • log4j.xml file has had the date format changed. Get the new file and change the logging to INFO level.

...

  • LDEV-1579, LDEV-1594: New column added to lams_tool table supports_outputs. Should be 1 for forum, mcq and voting, 0 for all other tools. Forum, mcq and voting tool also updated.
  • LDEV-1597: New column in voting to control whether or not to show the voting results. (updateTo20080326.sql, replacing updateTo20080108.sql)
  • LDEV-1598: Added four new configuration settings for adjusting screen (pop-up window) sizes. (included in alter_21_branching.sql)
  • LDEV-273: Added (non-unique) index on the lams_user.email field, as the Forgot password logic is to allow lookup on email address only.
  • Copyright.jsp (in lams_www) has been updated
  • The following configuration items were marked as mandatory when they shouldn't have been. The alter_21_branching.sql script has been modified. LamsSupportEmail , SMTPServer , XmppAdmin, XmppConference, XmppDomain, XmppPassword.
  • LDEV-1702: Added correct Japanese characters for the language description in lams_supported_locale. The sql update command was put in the alter_21_groupings_fckeditor.sql script for the update.