Index: openacs-4/packages/ref-us-zipcodes/sql/oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-zipcodes/sql/oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ref-us-zipcodes/sql/oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql	25 Sep 2003 23:53:55 -0000	1.1
+++ openacs-4/packages/ref-us-zipcodes/sql/oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql	26 Sep 2003 00:10:29 -0000	1.2
@@ -1,2 +1,13 @@
+-- update the table info
+    update acs_reference_repositories
+    set table_name    = 'US_ZIPCODES',
+        package_name   = 'US_ZIPCODE',
+        source         = 'US Census Bureau',
+        source_url     = 'http://www.census.gov/geo/www/tiger/zip1999.html',
+        last_update    = to_date('2000-01-01','YYYY-MM-DD'),
+        effective_date = sysdate
+    where table_name = 'US_ZIPCODES';
+
+
 -- load data
 @ '../../common/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql'
Index: openacs-4/packages/ref-us-zipcodes/sql/postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-zipcodes/sql/postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ref-us-zipcodes/sql/postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql	25 Sep 2003 23:53:44 -0000	1.1
+++ openacs-4/packages/ref-us-zipcodes/sql/postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql	26 Sep 2003 00:11:00 -0000	1.2
@@ -1,5 +1,15 @@
 -- load data
+-- update the table info
+    update acs_reference_repositories
+    set table_name    = 'US_ZIPCODES',
+        package_name   = 'US_ZIPCODE',
+        source         = 'US Census Bureau',
+        source_url     = 'http://www.census.gov/geo/www/tiger/zip1999.html',
+        last_update    = to_date('2000-01-01','YYYY-MM-DD'),
+        effective_date = now()
+    where table_name = 'US_ZIPCODES';
 
+
 begin;
 \i ../../common/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
 end;