Index: openacs-4/packages/lors/sql/postgresql/upgrade/upgrade-0.6d-0.6d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/upgrade/upgrade-0.6d-0.6d3.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/lors/sql/postgresql/upgrade/upgrade-0.6d-0.6d3.sql 13 Jun 2005 15:10:41 -0000 1.1.2.1 +++ openacs-4/packages/lors/sql/postgresql/upgrade/upgrade-0.6d-0.6d3.sql 25 Oct 2005 10:25:00 -0000 1.1.2.2 @@ -12,25 +12,6 @@ drop table lors_available_presentation_formats; --- 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 tree presentation formats exists, delivery, delivery-wihout-index and delivery-bottom-bar, -which we store on creation'; - --Change presentation_id to format_id. alter table ims_cp_manifests rename column presentation_id to course_presentation_format; Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/lorsm/sql/postgresql/upgrade/upgrade-0.6d2-0.6d3.sql'. Fisheye: No comparison available. Pass `N' to diff?