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,