Index: openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql 30 Jan 2006 19:31:05 -0000 1.1 +++ openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql 13 Mar 2006 17:43:59 -0000 1.2 @@ -687,3 +687,36 @@ Feedback are items that are mapped to this table with the imsld_feedback_rel.'; +create table imsld_as_la_rels ( + rel_id integer + constraint imsld_as_la_rels_fk + references acs_rels + constraint imsld_as_la_rels_pk + primary key +); + +comment on table imsld_as_la_rels is ' +This table stores the information of the relationship between the activity structures and the learning activities.'; + +create table imsld_as_sa_rels ( + rel_id integer + constraint imsld_as_sa_rels_fk + references acs_rels + constraint imsld_as_sa_rels_pk + primary key +); + +comment on table imsld_as_sa_rels is ' +This table stores the information of the relationship between the activity structures and the support activities.'; + +create table imsld_as_as_rels ( + rel_id integer + constraint imsld_as_as_rels_fk + references acs_rels + constraint imsld_as_as_rels_pk + primary key +); + +comment on table imsld_as_as_rels is ' +This table stores the information of the relationship between the activity structures (between them).'; +