Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 46 Next »

This page is a short record of the DDL schema changes, to help us manage the releases.

Since RC1

  • Removed columns weight and disabled from the table tl_lamc11_que_content (Multiple Choice Tool)
  • Removed column time_zone from the table tl_lamc11_usr_attempt (Multiple Choice Tool)
  • Added new lams_configuration table (lams.xml to DB)
  • alter table tl_lascrb11_user add started_activity bit;

Since RC1 Oct 20th

  • added column version int(11) not null to tl_lafrum11_tool_session;
  • added column report_submitted bit(1) to tl_lascrb11_session
  • tool version number updates (from '1.1' to '20061102')
  • tool default content updates
  • update tl_lascrb11_scribe set title='Scribe', instructions='Instructions', online_instructions="", offline_instructions="" where uid=1;

Since RC2 Nov 5th

  • removed voteChangable column from tl_lavote11_content
  • added lockWhenFinished tinyint(1) not null default 1 column to tl_laqa11_content
  • added showOtherAnswers tinyint(1) not null default 1 column to tl_laqa11_content
  • added randomize tinyint(1) not null default 0 column to tl_lamc11_content
  • added displayOrder int(5) column to tl_lamc11_options_content
  • tl_lavote11_content - lock_on_finish default 1 (not 0)
  • lams_tool - update laqa11/lavote11/lamc11 set version = 20061113
  • tl_lamc11_content - add column showMarks tinyint(1) not null default 0
  • lams_lesson - learner_exportport_avail TINYINT(1)
  • insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false');
  • Changed ServerVersionNumber to include 2.0 RC2
  • INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) VALUES (22, 'vi', 'VN', 'Tiếng Viá»?t', 'LTR');

Since November 22nd

  • update lams_role set name='GROUP MANAGER' where role_id=2;
  • update lams_role set description='Group Manager' where role_id=2;
  • update lams_role set name='GROUP ADMIN' where role_id=6;
  • update lams_role set description='Group Administrator' where role_id=6;
  • alter table lams_organisation add column archived_date datetime;
  • INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) VALUES (23, 'zh', 'TW', 'Chinese (Taiwan)', 'LTR');
  • update lams_configuration set config_value='2.0' where config_key='Version';
  • update lams_configuration set config_value='2.0.200612051427' where config_key='AuthoringClientVersion';
  • update lams_configuration set config_value='2.0.200612051427' where config_key='MonitorClientVersion';
  • update lams_configuration set config_value='2.0.200612051427' where config_key='LearnerClientVersion';
  • update lams_configuration set config_value='2.0.200612051427' where config_key='ServerVersionNumber';
  • update lams_configuration set config_value='2006-12-05' where config_key='DictionaryDateCreated';

From LAMS 2.0 to LAMS 2.0.1 Beta (lams2_0_1_beta 22 Feb 07)

  • 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:
    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_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
    

From LAMS 2.0.1 Beta to LAMS 2.0.1

  • All of the tools have a script that populates the 3 new columns in the lams_tool table. 
  • lams_common/db/sql/updatescripts/alter_201_ext.sql: changes external server orgs from root/course to course/class types, removes group manager from external users
  • summary of update scripts:
    lams_common/db/sql/updatescripts/alter_201_tool.sql
    lams_common/db/sql/updatescripts/alter_201_ext.sql
    

From LAMS 2.0.1  LAMS 2.0.2

lams_tool: The tool version for noticeboard, chat, scribe are now  20070315. Started change the classpath entry to the format "lams-tool-blah.jar", not "./lams-tool-blah.jar" - new installations will get it without "./" but upgraded versions from 2.0.2 will get a mixture of the two formats. Given that this change just makes the classpaths in the Manifest files shorter, it is not an essential change if upgrading a server.

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';

From LAMS 2.0.2  LAMS 2.0.3

  • Chat tool. Added new column room_created to the lachat11_session table. DDL Script to update tables is in lams_tool_chat\db\sql\updatescripts\updateTo20070524.sql. There is also a Java program that needs to be run to update existing data - see Anthony for details.
  • Core table changes: See the scripts
    • alter_203_editonfly.sql
    • alter_203_rams_theme.sql
    • alter_203_learner_progress.sql (for LDEV-1198)
    • alter_203_transition.sql (for LDEV-1229).
  • Tool changes - apart from the Chat tool (above) there are no database changes, but the min server setting (in the tool deploy) needs to be updated to the new server version as has the tool version, as all of the tools have had a code change due to the tool contract has changing in this version.
  • No labels