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
- Removed row from lams_configuration (LamsHome)
- Added new row to lams_configuration (AuthoringActivitiesColour)
- Added column version to tl_lascrb11_session (Scribe Tool)
- Added new row to lams_role, lams_privilege, and lams_role_privilege (author admin) http://lamscvs.melcoe.mq.edu.au/cgi-bin/viewcvs.cgi/lams_common/db/sql/insert_types_data.sql.diff?r1=text&tr1=1.57&r2=text&tr2=1.58&diff_format=h
- Removed row from lams_configuration (FileManagerDir)
- Added new row to lams_configuration (AllowDirectLessonLaunch)
Modified rows in lams_configuration ([Author|Monitor|Learner]ClientVersion)
- 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 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