Index: openacs-4/packages/bookshelf/sql/postgresql/bookshelf-books-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bookshelf/sql/postgresql/bookshelf-books-create.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/bookshelf/sql/postgresql/bookshelf-books-create.sql 30 Sep 2002 18:10:54 -0000 1.1 +++ openacs-4/packages/bookshelf/sql/postgresql/bookshelf-books-create.sql 20 May 2004 20:23:02 -0000 1.1.4.1 @@ -19,7 +19,14 @@ book_author text, book_title text not null, main_entry text, + main_entry_mime_type varchar(200) default 'text/plain' + constraint bkshlf_book_main_mime_type_fk + references cr_mime_types; additional_entry text, + additional_entry_mime_type + varchar(200) default 'text/plain' + constraint book_additional_mime_type_fk + references cr_mime_types; excerpt text, publish_status varchar(50) not null constraint bookshelf_book_publish_ck