Index: openacs-4/packages/ecommerce/sql/oracle/ecommerce-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/oracle/ecommerce-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/ecommerce/sql/oracle/ecommerce-create.sql	20 Aug 2001 04:12:17 -0000	1.4
+++ openacs-4/packages/ecommerce/sql/oracle/ecommerce-create.sql	22 Oct 2001 06:48:49 -0000	1.5
@@ -526,13 +526,13 @@
         city            varchar(100),
         -- state
         -- Jerry, we'll need to creat the states table as part of this
-        usps_abbrev     char(2) references states,
+        usps_abbrev     char(2) references us_states(abbrev),
         -- big enough to hold zip+4 with dash
         zip_code        varchar(10),
         phone           varchar(30),
         -- for international addresses
         -- Jerry, same for country_codes
-        country_code    char(2) references country_codes(iso),
+        country_code    char(2) references countries(iso),
         -- this can be the province or region for an international address
         full_state_name varchar(30),
         -- D for day, E for evening
@@ -1597,7 +1597,7 @@
 -- this is populated by the rules the administrator sets in packages/ecommerce/www/admin]/sales-tax.tcl
 create table ec_sales_tax_by_state (
        -- Jerry
-        usps_abbrev             not null primary key references states,
+        usps_abbrev             not null primary key references us_states(abbrev),
         -- this a decimal number equal to the percentage tax divided by 100
         tax_rate                number not null,
         -- charge tax on shipping?
@@ -1655,14 +1655,14 @@
         city                    varchar(100),
         -- state
         -- Jerry
-        usps_abbrev     char(2) references states,
+        usps_abbrev     char(2) references us_states(abbrev),
         -- big enough to hold zip+4 with dash
         zip_code                varchar(10),
         phone                   varchar(30),
         fax                     varchar(30),
         -- for international addresses
         -- Jerry
-        country_code            char(2) references country_codes(iso),
+        country_code            char(2) references countries(iso),
         --national, local, international
         reach                   varchar(15) check (reach in ('national','local','international','regional','web')),
         url                     varchar(200),
@@ -1762,15 +1762,15 @@
         -- state
         -- Jerry
 	-- usps_abbrev reinstated by wtem@olywa.net
-        usps_abbrev     char(2) references states,
+        usps_abbrev     char(2) references us_states(abbrev),
         -- big enough 0to hold zip+4 with dash
         zip_code                varchar(10),
         phone                   varchar(30),
         fax                     varchar(30),
         -- for international addresses
         -- Jerry
 	-- country_code reinstated by wtem@olywa.net
-        country_code            char(2) references country_codes(iso),
+        country_code            char(2) references countries(iso),
         url                     varchar(200),
         financing_policy        varchar(4000),
         return_policy           varchar(4000),