Index: openacs-4/packages/acs-person/sql/oracle/acs-person-sc-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-person/sql/oracle/Attic/acs-person-sc-create.sql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/acs-person/sql/oracle/acs-person-sc-create.sql 26 Sep 2002 03:32:07 -0000 1.1 +++ openacs-4/packages/acs-person/sql/oracle/acs-person-sc-create.sql 2 Oct 2002 03:20:14 -0000 1.1.2.1 @@ -6,15 +6,15 @@ select acs_sc_impl_alias__new( 'FtsContentProvider', -- impl_contract_name - 'contact', -- impl_name + 'acs_person', -- impl_name 'datasource', -- impl_operation_name 'acs_persons__datasource', -- impl_alias 'TCL' -- impl_pl ); -select acs_sc_impl_alias__new( +select acs_sc_impl_alias.new( 'FtsContentProvider', -- impl_contract_name - 'contact', -- impl_name + 'acs_person', -- impl_name 'url', -- impl_operation_name 'acs_persons__url', -- impl_alias 'TCL' -- impl_pl @@ -24,21 +24,21 @@ create function acs_persons__itrg () returns opaque as ' begin - perform search_observer__enqueue(new.contact_id,''INSERT''); + perform search_observer__enqueue(new.acs_person_id,''INSERT''); return new; end;' language 'plpgsql'; create function acs_persons__dtrg () returns opaque as ' begin - perform search_observer__enqueue(old.contact_id,''DELETE''); + perform search_observer__enqueue(old.acs_person_id,''DELETE''); return old; end;' language 'plpgsql'; create function acs_persons__utrg () returns opaque as ' begin - perform search_observer__enqueue(old.contact_id,''UPDATE''); + perform search_observer__enqueue(old.acs_person_id,''UPDATE''); return old; end;' language 'plpgsql'; Index: openacs-4/packages/acs-person/sql/postgresql/acs-person-sc-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-person/sql/postgresql/Attic/acs-person-sc-create.sql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/acs-person/sql/postgresql/acs-person-sc-create.sql 24 Sep 2002 05:24:47 -0000 1.1 +++ openacs-4/packages/acs-person/sql/postgresql/acs-person-sc-create.sql 2 Oct 2002 03:17:31 -0000 1.1.2.1 @@ -6,15 +6,15 @@ select acs_sc_impl_alias__new( 'FtsContentProvider', -- impl_contract_name - 'contact', -- impl_name + 'acs_person', -- impl_name 'datasource', -- impl_operation_name 'acs_persons__datasource', -- impl_alias 'TCL' -- impl_pl ); select acs_sc_impl_alias__new( 'FtsContentProvider', -- impl_contract_name - 'contact', -- impl_name + 'acs_person', -- impl_name 'url', -- impl_operation_name 'acs_persons__url', -- impl_alias 'TCL' -- impl_pl @@ -24,21 +24,21 @@ create function acs_persons__itrg () returns opaque as ' begin - perform search_observer__enqueue(new.contact_id,''INSERT''); + perform search_observer__enqueue(new.acs_person_id,''INSERT''); return new; end;' language 'plpgsql'; create function acs_persons__dtrg () returns opaque as ' begin - perform search_observer__enqueue(old.contact_id,''DELETE''); + perform search_observer__enqueue(old.acs_person_id,''DELETE''); return old; end;' language 'plpgsql'; create function acs_persons__utrg () returns opaque as ' begin - perform search_observer__enqueue(old.contact_id,''UPDATE''); + perform search_observer__enqueue(old.acs_person_id,''UPDATE''); return old; end;' language 'plpgsql'; @@ -51,8 +51,3 @@ create trigger acs_persons__utrg after update on acs_persons for each row execute procedure acs_persons__utrg (); - - - - -