Index: openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql 4 Sep 2004 14:04:07 -0000 1.2 +++ openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql 23 Feb 2005 17:59:42 -0000 1.3 @@ -88,6 +88,21 @@ ----- -- Create tables ---- +-- Presentations +create table lors_available_presentation_formats ( + presentation_name varchar(100), + folder_name varchar(100), + presentation_id integer +); + +insert into lors_available_presentation_formats values ('Classic style','delivery_clasico',1); +insert into lors_available_presentation_formats values ('E-LANE style','delivery',2); + +comment on table lors_available_presentation_formats 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 is stored +by now, just two presentations, which we store on creation'; + -- Manifests create table ims_cp_manifests ( man_id integer @@ -106,7 +121,8 @@ isscorm boolean, folder_id integer, fs_package_id integer, - isshared boolean default 'f' not null + isshared boolean default 'f' not null, + presentation_id integer ); comment on table ims_cp_manifests is '