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.1 -r1.2
--- openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql	4 Sep 2004 14:51:20 -0000	1.1
+++ openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql	21 Apr 2005 16:03:52 -0000	1.2
@@ -89,4 +89,23 @@
 Multiplicity: One bookmark per course/class/student
 ';
 
+-- Course presentation formats
+
+create table lorsm_course_presentation_formats (
+	format_id  			integer
+						constraint lorsm_cpformats_pk
+						primary key,
+	format_pretty_name	varchar(200),
+	format_name 		varchar(100),
+	folder_name			varchar(100)
+);
+
+create index lorsm_cpformats__format_id_idx on lorsm_course_presentation_formats (format_id);
+
+comment on table lorsm_course_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 format is stored.
+Currently just two presentation formats exists, delivery and delivery-wihout-index, which we store on creation';
+
+
 \i lorsm-packages.sql