Index: openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-create.sql,v diff -u -r1.1.2.2 -r1.1.2.2.2.1 --- openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-create.sql 13 Jun 2005 15:10:43 -0000 1.1.2.2 +++ openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-create.sql 22 Nov 2006 12:01:36 -0000 1.1.2.2.2.1 @@ -160,7 +160,7 @@ constraint lorsm_cmi_objectives_track_id_fk references lorsm_student_track (track_id) on delete cascade, - _count int, -- start with 0 + objectives_count int, -- start with 0 student_id varchar(100), id varchar(256), -- not mandatory, gettable, settable score_raw varchar(10), -- not mandatory, gettable, settable @@ -170,11 +170,11 @@ default 'not attempted', constraint lorsm_cmi_objectives_status_ck check (status in ('passed', 'completed', 'failed', 'incomplete', 'browsed', 'not attempted')), - constraint lorsm_cmi_objectives_id_pk primary key (track_id, _count) + constraint lorsm_cmi_objectives_id_pk primary key (track_id, objectives_count) ); -create index lorsm_cmi_objectives__stud_id_idx on lorsm_cmi_objectives (student_id); +create index lorsm_cmi_obj_stud_id_idx on lorsm_cmi_objectives (student_id); comment on table lorsm_cmi_objectives is ' Identifies how the student has performed on individual objectives covered in the SCO. @@ -252,7 +252,7 @@ text int -- not mandatory, gettable, settable ); -create index lorsm_cmi_student_preference__stud_id_idx on lorsm_cmi_student_preference (student_id); +create index lorsm_cmi_st_pref_stud_id_idx on lorsm_cmi_student_preference (student_id); comment on table lorsm_cmi_student_preference is ' Selected options that are appropriate for subsequent SCOs @@ -281,7 +281,7 @@ constraint lorsm_cmi_interactions_track_id_fk references lorsm_student_track (track_id) on delete cascade, - _count int, -- start with 0 + interactions_count int, -- start with 0 student_id varchar(100), id varchar(256), -- not mandatory, not gettable, settable time timestamptz, -- not mandatory, not gettable, settable @@ -294,7 +294,7 @@ correct_responses int, -- current number of elements in the cmi.correct_responses list constraint lorsm_cmi_interactions_type_ck check (type in ('true-false', 'choice', 'fill-in', 'matching', 'performance', 'sequencing', 'likert', 'numeric')), - constraint lorsm_cmi_interactions_id_pk primary key (track_id, _count) + constraint lorsm_cmi_interactions_id_pk primary key (track_id, interactions_count) ); create index lorsm_cmi_interactions__stud_id_idx on lorsm_cmi_interactions (student_id); @@ -340,49 +340,49 @@ -- cmi.interactions.objectives list -create table lorsm_cmi_interactions_objectives ( +create table lorsm_cmi_interact_objectives ( track_id int constraint lorsm_cmi_interactions_obj_track_id_fk references lorsm_student_track (track_id), interaction_num int, -- number in the interactions list - _count int, -- start with 0 + interactions_objectives_count int, -- start with 0 student_id varchar(100), id varchar(256), -- not mandatory, not gettable, settable - constraint lorsm_cmi_interactions_obj_id_pk primary key (track_id, interaction_num, _count) + constraint lorsm_cmi_interactions_obj_id_pk primary key (track_id, interaction_num, interactions_objectives_count) ); -create index lorsm_cmi_interactions_obj__stud_id_idx on lorsm_cmi_interactions_objectives (student_id); +create index lorsm_cmi_int_obj_stud_id_idx on lorsm_cmi_interact_objectives (student_id); -comment on table lorsm_cmi_interactions_objectives is ' +comment on table lorsm_cmi_interact_objectives is ' Identify a list of objectives that the interaction is for. '; -comment on column lorsm_cmi_interactions_objectives.id is ' +comment on column lorsm_cmi_interact_objectives.id is ' Developer created identifier for an objective. The SCO is responsible for determining this value. '; -- cmi.correct.responses.correct_responses list -create table lorsm_cmi_interactions_correct_responses ( +create table lorsm_cmi_int_correct_respons ( track_id int constraint lorsm_cmi_interactions_corr_track_id_fk references lorsm_student_track (track_id) on delete cascade, interaction_num int, -- number in the interactions list - _count int, -- start with 0 + correct_responses_count int, -- start with 0 student_id varchar(100), pattern varchar(256), -- not mandatory, not gettable, settable - constraint lorsm_cmi_interactions_corr_id_pk primary key (track_id, interaction_num, _count) + constraint lorsm_cmi_interactions_corr_id_pk primary key (track_id, interaction_num, correct_responses_count) ); -create index lorsm_cmi_interactions_corr__stud_id_idx on lorsm_cmi_interactions_correct_responses (student_id); +create index lorsm_cmi_interactions_corr__stud_id_idx on lorsm_cmi_int_correct_respons (student_id); -comment on table lorsm_cmi_interactions_correct_responses is ' +comment on table lorsm_cmi_int_correct_respons is ' Description of possible responses to the interaction. '; -comment on column lorsm_cmi_interactions_correct_responses.pattern is ' +comment on column lorsm_cmi_int_correct_respons.pattern is ' Description of possible student responses to the interaction provided by the SCO. There may be more than one correct response, and some responses may be more correct than others. The format is dependent on cmi.interactions.n.type. Index: openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-drop.sql,v diff -u -r1.1.2.2 -r1.1.2.2.2.1 --- openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-drop.sql 13 Jun 2005 15:10:43 -0000 1.1.2.2 +++ openacs-4/packages/lorsm/sql/postgresql/lorsm-cmi-drop.sql 22 Nov 2006 12:01:36 -0000 1.1.2.2.2.1 @@ -15,5 +15,6 @@ drop table lorsm_cmi_student_data; drop table lorsm_cmi_student_preference; drop table lorsm_cmi_interactions; -drop table lorsm_cmi_interactions_objectives; -drop table lorsm_cmi_interactions_correct_responses; +drop table lorsm_cmi_interact_objectives; +drop table lorsm_cmi_int_correct_respons; +drop table lorsm_course_presentation_fmts; Index: openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql,v diff -u -r1.3.2.2 -r1.3.2.2.2.1 --- openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql 5 May 2006 17:01:01 -0000 1.3.2.2 +++ openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql 22 Nov 2006 12:01:36 -0000 1.3.2.2.2.1 @@ -70,7 +70,7 @@ course_id int constraint lorsm_st_track_course_id_fk references ims_cp_manifests (man_id), - date timestamptz, + bookmark_date timestamptz, constraint lorsm_st_book_id_pk primary key (user_id, community_id, course_id) ); @@ -91,7 +91,7 @@ -- Course presentation formats -create table lorsm_course_presentation_formats ( +create table lorsm_course_presentation_fmts ( format_id integer constraint lorsm_cpformats_pk primary key, @@ -100,9 +100,9 @@ folder_name varchar(100) ); -create index lorsm_cpformats__format_id_idx on lorsm_course_presentation_formats (format_id); +create index lorsm_cpfmts__format_id_idx on lorsm_course_presentation_fmts (format_id); -comment on table lorsm_course_presentation_formats is ' +comment on table lorsm_course_presentation_fmts is ' This table stores the available presentation formats for the courses. Its contains the pretty name for the format, an id, and the folder in packages/lorsm/www/ where the presentation format is stored. Currently just two presentation formats exists, delivery and delivery-wihout-index, which we store on creation';