Index: openacs-4/packages/ref-us-counties/sql/postgresql/ref-us-counties-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-counties/sql/postgresql/ref-us-counties-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/ref-us-counties/sql/postgresql/ref-us-counties-create.sql	27 Aug 2001 23:08:56 -0000	1.1
+++ openacs-4/packages/ref-us-counties/sql/postgresql/ref-us-counties-create.sql	2 Sep 2001 17:06:29 -0000	1.2
@@ -11,17 +11,17 @@
                      references us_states(fips_state_code),
     fips_county_code char(6)  
                      constraint us_counties_county_code_nn not null,
-    name             varchar2(100)
+    name             varchar(100)
                      constraint us_counties_name_nn not null,
     state_abbrev     char(2)
                      constraint us_counties_state_abrrev_fk
                      references us_states(abbrev),
-    population       number,
-    housing_units    number,
-    land_area        number,
-    water_area       number,
-    latitude         number,
-    longitude        number,
+    population       numeric,
+    housing_units    numeric,
+    land_area        numeric,
+    water_area       numeric,
+    latitude         numeric,
+    longitude        numeric,
     --
     -- Primary key for this table is generated by combining the state
     -- and county FIPS codes.  County code are only unique within a given state.
@@ -42,7 +42,7 @@
 ';
 
 comment on column us_counties.name is '
-Name. Includes name of county. Counties don't nave a type, but do have
+Name. Includes name of county. Counties don''t nave a type, but do have
 the word "County" as part of the name.
 ';
 
@@ -80,10 +80,12 @@
 
 select acs_reference__new (
     'US_COUNTIES',
+    '1990-12-31',
     'US Census Bureau',
     'http://ftp.census.gov/geo/www/gazetteer/places.html',
-    to_date('1990-12-31','YYYY-MM-DD'),
-    sysdate()
+    now()
 );
 
+begin;
 \i ../common/ref-us-counties-data.sql
+end;