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 35 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.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.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

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