Index: openacs-4/packages/curriculum-central/sql/postgresql/uos-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/sql/postgresql/uos-create.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/curriculum-central/sql/postgresql/uos-create.sql 15 Dec 2005 11:15:05 -0000 1.5 +++ openacs-4/packages/curriculum-central/sql/postgresql/uos-create.sql 3 Jan 2006 03:23:27 -0000 1.6 @@ -72,19 +72,11 @@ constraint cc_uos_rev_uos_name_nn not null, credit_value integer, semester varchar(32), - online_course_content varchar(256), unit_coordinator_id integer constraint cc_uos_rev_coordinator_id_fk references users(user_id) constraint cc_uos_rev_coordinator_id_nn not null, - contact_hours varchar(256), - assessments varchar(512), - core_uos_for varchar(512), - recommended_uos_for varchar(512), - prerequisites varchar(256), - objectives text, - outcomes text, activity_log text, activity_log_format varchar(256) ); @@ -101,7 +93,7 @@ ); -select define_function_args('cc_uos__new', 'uos_id,uos_code,uos_name,unit_coordinator_id,credit_value,semester,online_course_content,contact_hours,assessments,core_uos_for,recommended_uos_for,prerequisites,objectives,outcomes,activity_log,activity_log_format,creation_user,creation_ip,context_id,item_subtype;cc_uos,content_type;cc_uos_revision,object_type,package_id'); +select define_function_args('cc_uos__new', 'uos_id,uos_code,uos_name,unit_coordinator_id,credit_value,semester,activity_log,activity_log_format,creation_user,creation_ip,context_id,item_subtype;cc_uos,content_type;cc_uos_revision,object_type,package_id'); create function cc_uos__new( integer, -- uos_id @@ -110,14 +102,6 @@ integer, -- unit_coordinator_id integer, -- credit_value varchar, -- semester - varchar, -- online_course_content - varchar, -- contact_hours - varchar, -- assessments - varchar, -- core_uos_for - varchar, -- recommended_uos_for - varchar, -- prerequisites - text, -- objectives - text, -- outcomes text, -- activity_log varchar, -- activity_log_format integer, -- creation_user @@ -136,23 +120,15 @@ p_unit_coordinator_id alias for $4; p_credit_value alias for $5; p_semester alias for $6; - p_online_course_content alias for $7; - p_contact_hours alias for $8; - p_assessments alias for $9; - p_core_uos_for alias for $10; - p_recommended_uos_for alias for $11; - p_prerequisites alias for $12; - p_objectives alias for $13; - p_outcomes alias for $14; - p_activity_log alias for $15; - p_activity_log_format alias for $16; - p_creation_user alias for $17; - p_creation_ip alias for $18; - p_context_id alias for $19; - p_item_subtype alias for $20; - p_content_type alias for $21; - p_object_type alias for $22; - p_package_id alias for $23; + p_activity_log alias for $7; + p_activity_log_format alias for $8; + p_creation_user alias for $9; + p_creation_ip alias for $10; + p_context_id alias for $11; + p_item_subtype alias for $12; + p_content_type alias for $13; + p_object_type alias for $14; + p_package_id alias for $15; v_uos_id cc_uos.uos_id%TYPE; v_folder_id integer; @@ -197,15 +173,7 @@ p_uos_name, -- uos_name p_credit_value, -- credit_value p_semester, -- semester - p_online_course_content, -- online_course_content p_unit_coordinator_id, -- unit_coordinator_id - p_contact_hours, -- contact_hours - p_assessments, -- assessments - p_core_uos_for, -- core_uos_for - p_recommended_uos_for, -- recommended_uos_for - p_prerequisites, -- prerequisites - p_objectives, -- objectives - p_outcomes, -- outcomes p_activity_log, -- activity_log p_activity_log_format, -- activity_log_format now(), -- creation_date @@ -278,15 +246,7 @@ varchar, -- uos_name integer, -- credit_value varchar, -- semester - varchar, -- online_course_content integer, -- unit_coordinator_id - varchar, -- contact_hours - varchar, -- assessments - varchar, -- core_uos_for - varchar, -- recommended_uos_for - varchar, -- prerequisites - text, -- objectives - text, -- outcomes text, -- activity_log varchar, -- activity_log_format timestamptz, -- creation_date @@ -301,20 +261,12 @@ p_uos_name alias for $4; p_credit_value alias for $5; p_semester alias for $6; - p_online_course_content alias for $7; - p_unit_coordinator_id alias for $8; - p_contact_hours alias for $9; - p_assessments alias for $10; - p_core_uos_for alias for $11; - p_recommended_uos_for alias for $12; - p_prerequisites alias for $13; - p_objectives alias for $14; - p_outcomes alias for $15; - p_activity_log alias for $16; - p_activity_log_format alias for $17; - p_creation_date alias for $18; - p_creation_user alias for $19; - p_creation_ip alias for $20; + p_unit_coordinator_id alias for $7; + p_activity_log alias for $8; + p_activity_log_format alias for $9; + p_creation_date alias for $10; + p_creation_user alias for $11; + p_creation_ip alias for $12; v_revision_id integer; begin @@ -336,16 +288,26 @@ -- insert into the uos-specific revision table insert into cc_uos_revisions (uos_revision_id, uos_code, uos_name, credit_value, - semester, online_course_content, unit_coordinator_id, - contact_hours, assessments, core_uos_for, recommended_uos_for, - prerequisites, objectives, outcomes, activity_log, activity_log_format) + semester, unit_coordinator_id, activity_log, + activity_log_format) values (v_revision_id, p_uos_code, p_uos_name, p_credit_value, - p_semester, p_online_course_content, p_unit_coordinator_id, - p_contact_hours, p_assessments, p_core_uos_for, - p_recommended_uos_for, p_prerequisites, p_objectives, - p_outcomes, p_activity_log, p_activity_log_format); + p_semester, p_unit_coordinator_id, p_activity_log, + p_activity_log_format); return v_revision_id; end; ' language 'plpgsql'; + + +-- +-- +-- Create other UoS related tables. +-- +-- + +-- UoS Details +\i uos-detail-create.sql + +-- UoS Teaching and Learning +\i uos-tl-create.sql