Index: openacs-4/contrib/packages/bcms/sql/postgresql/bcms-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/bcms/sql/postgresql/bcms-create.sql,v diff -u -r1.9 -r1.10 --- openacs-4/contrib/packages/bcms/sql/postgresql/bcms-create.sql 30 Oct 2003 15:08:11 -0000 1.9 +++ openacs-4/contrib/packages/bcms/sql/postgresql/bcms-create.sql 15 Apr 2004 16:16:52 -0000 1.10 @@ -1,28 +1,12 @@ -- -- bcms/sql/postgresql/bcms-create.sql -- --- @author +-- @author Jun Yamog -- @create-date 10 Aug 2002 -- @cvs-id $Id$ -- --- creates bcms content types --- TODO look into if we need to define the extra content types - --- this content type are just for convinience, bcms_page are the text pages, bcms_file are binary files --- bcms_images are for images ---select content_type__create_type ('bcms_page', 'content_revision', 'BCMS Page', 'BCMS Pages', 'cr_bcms_pages', 'page_id', null); ---select content_type__create_type ('bcms_file', 'content_revision', 'BCMS File', 'BCMS Files', 'cr_bcms_files', 'file_id', null); - --- bcms_links are external links... href values ---select content_type__create_type ('bcms_link', 'content_revision', 'BCMS Link', 'BCMS Links', 'cr_bcms_links', 'link_id', null); - --- bcms_nav nav links are used to build the navigation ---select acs_object_type__create_type ('bcms_navlink', 'BCMS Navigation Link', 'BCMS Navigation Links', 'content_item', 'cr_bcms_navlinks', 'navlink_id', null, 'f', null, null); ---select acs_attribute__create_attribute ('bcms_navlink', 'nav_object_id', 'integer', 'Navigation Object ID', 'Navigation Object IDs', null, null, null, 1, 1, null, 'type_specific', 'f'); ---select acs_attribute__create_attribute ('bcms_navlink', 'sort_key', 'integer', 'Sort Key', 'Sort Keys', null, null, null, 1, 1, null, 'type_specific', 'f'); - --- create the relations, bcms_page may relate to another page, file, image +-- create the relations select content_type__register_relation_type ('content_revision', 'content_revision', 'pages', '0', null); select content_type__register_relation_type ('content_revision', 'image', 'images', '0', null);