Index: openacs-4/packages/file-storage/sql/oracle/file-storage-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/file-storage-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/file-storage/sql/oracle/file-storage-create.sql 30 Aug 2001 12:43:31 -0000 1.3 +++ openacs-4/packages/file-storage/sql/oracle/file-storage-create.sql 4 Sep 2001 01:25:11 -0000 1.4 @@ -6,6 +6,22 @@ -- @cvs-id $Id$ -- +-- +-- To enable site-wide search to distinguish CR items as File Storage items +-- we create an item subtype of content_item in the ACS Object Model +begin + acs_object_type.create_type ( + object_type => 'file_storage_item', + pretty_name => 'File Storage Item', + pretty_plural => 'File Storage Items', + supertype => 'content_item', + table_name => 'fs_root_folders', -- JS: Will not do anything, but we have to insert something + id_column => 'folder_id' -- JS: Same. + ); +end; +/ +show errors; + -- -- We need to create a root folder in the content repository for -- each instance of file storage Index: openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql 30 Aug 2001 12:40:38 -0000 1.4 +++ openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql 4 Sep 2001 01:24:49 -0000 1.5 @@ -6,6 +6,22 @@ -- @cvs-id $Id$ -- + +-- To enable site-wide search to distinguish CR items as File Storage items +-- we create an item subtype of content_item in the ACS Object Model + select acs_object_type__create_type ( + 'file_storage_item', -- object_type + 'File Storage Item', -- pretty_name + 'File Storage Items', -- pretty_plural + 'content_item', -- supertype + 'fs_root_folders', -- table_name (JS: Will not do anything, but we have to insert something) + 'folder_id', -- id_column (JS: Same) + null, -- package_name (default) + 'f', -- abstract_p (default) + null, -- type_extension_table (default) + 'content_item.get_title' -- name_method + ); + -- -- We need to create a root folder in the content repository for -- each instance of file storage