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 24 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)

Since RC1 Oct 20th

  • added column version int(11) 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

Since RC2 Nov 5th

  • removed voteChangable column from tl_lavote11_content
  • added lockWhenFinished column to tl_laqa11_content
  • added showOtherAnswers column to tl_laqa11_content
  • added randomize column to tl_lamc11_content
  • added displayOrder 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

  • 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
  • No labels