Index: openacs-4/packages/contacts/sql/postgresql/contacts-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-create.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/contacts/sql/postgresql/contacts-create.sql 20 Jun 2005 16:48:36 -0000 1.5 +++ openacs-4/packages/contacts/sql/postgresql/contacts-create.sql 30 Jun 2005 00:01:09 -0000 1.6 @@ -20,9 +20,9 @@ select content_type__create_type ( 'contact_party_revision', -- content_type 'content_revision', -- supertype - '#contacts.Party_Revision#', -- pretty_name - '#contacts.Party_Revisions#', -- pretty_plural - 'contact_party_revisions', -- table_name (should this be pm_task?) + '#contacts.Party_Revision#', -- pretty_name + '#contacts.Party_Revisions#', -- pretty_plural + 'contact_party_revisions', -- table_name 'party_revision_id', -- id_column 'contact_party_revision__name' -- name_method ); @@ -140,8 +140,9 @@ constraint organization_rels_rel_id_pk primary key ); + \i contacts-package-create.sql \i contacts-search-create.sql +\i contacts-messages-create.sql - Index: openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql 18 May 2005 16:45:49 -0000 1.3 +++ openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql 30 Jun 2005 00:01:09 -0000 1.4 @@ -77,7 +77,7 @@ insert into cr_items (item_id,parent_id,name,content_type) values - (p_party_id,contact_party_revision__folder_id(),p_party_id::varchar,''contact_party_revision''); + (p_party_id,contact__folder_id(),p_party_id::varchar,''contact_party_revision''); end if; return p_party_id; @@ -99,9 +99,7 @@ return v_name; end;' language 'plpgsql'; - - -create or replace function contact_party_revision__folder_id () returns integer +create or replace function contact__folder_id () returns integer as ' declare v_folder_id integer; @@ -124,6 +122,8 @@ return v_folder_id; end;' language 'plpgsql'; +select content_folder__register_content_type(contact__folder_id(),'content_revision','t'); + create or replace function contact__name ( varchar, -- first_names varchar, -- last_name