Index: openacs-4/packages/postal-address/postal-address.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postal-address/postal-address.info,v diff -u -r1.2 -r1.3 --- openacs-4/packages/postal-address/postal-address.info 11 Dec 2003 21:40:10 -0000 1.2 +++ openacs-4/packages/postal-address/postal-address.info 27 May 2007 12:19:10 -0000 1.3 @@ -7,22 +7,25 @@ f f - + oracle postgresql - Jon Griffin + Malte Sussdorff An implementation of HR-XML's address standard. - Mayuli Enterprises, LLC This is an implementation of HR-XML's address standard.<p>Originally part of Contacts-Lite, now a service. - + + - + - + + + + Index: openacs-4/packages/postal-address/sql/postgresql/postal-address-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postal-address/sql/postgresql/postal-address-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/postal-address/sql/postgresql/postal-address-create.sql 13 Mar 2003 21:52:22 -0000 1.1 +++ openacs-4/packages/postal-address/sql/postgresql/postal-address-create.sql 27 May 2007 12:19:11 -0000 1.2 @@ -34,17 +34,13 @@ party_id integer constraint postal_owner_id_fk references parties (party_id), - delivery_address varchar (1000) - constraint postal_address_delivery_nn - not null, + delivery_address varchar (1000), postal_code varchar (30), municipality varchar (100), region varchar (100), country_code char (2) constraint postal_addresses_country_fk - references countries (iso) - constraint postal_addresses_country_nn - not null, + references countries (iso), additional_text varchar(100), postal_type integer constraint postal_addresses_type_fk Index: openacs-4/packages/postal-address/sql/postgresql/postal-address-plsql.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/postal-address/sql/postgresql/postal-address-plsql.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/postal-address/sql/postgresql/postal-address-plsql.sql 13 Mar 2003 21:52:22 -0000 1.1 +++ openacs-4/packages/postal-address/sql/postgresql/postal-address-plsql.sql 27 May 2007 12:19:11 -0000 1.2 @@ -30,8 +30,9 @@ drop function inline_0 (); ------ start of oacs new proc -create or replace function postal_address__new ( varchar,integer,char,varchar,varchar, -integer,varchar,integer,varchar,integer,varchar,integer ) +select define_function_args('postal_address__new','additional_text,address_id,country_code,delivery_address,municipality,party_id,postal_code,postal_type,region,creation_user,creation_ip,context_id'); + +create or replace function postal_address__new ( varchar,integer,char,varchar,varchar,integer,varchar,integer,varchar,integer,varchar,integer ) returns integer as ' declare p_additional_text alias for $1; -- comment @@ -51,7 +52,7 @@ v_address_id postal_addresses.address_id%TYPE; begin v_address_id := acs_object__new ( - null, + p_address_id, ''postal_address'', now(), p_creation_user,