Index: openacs-4/packages/ref-us-states/ref-us-states.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-states/ref-us-states.info,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-us-states/ref-us-states.info	27 Aug 2001 22:49:00 -0000	1.1
@@ -0,0 +1,33 @@
+<?xml version="1.0"?>
+<!-- Generated by the ACS Package Manager -->
+
+<package key="ref-us-states" url="http://www.mayuli.com/acs-repository/apm/packages/ref-us-states" type="apm_service">
+    <package-name>ACS Reference - US State</package-name>
+    <pretty-plural>ACS Reference - US State</pretty-plural>
+    <initial-install-p>f</initial-install-p>
+    <singleton-p>t</singleton-p>
+
+    <version name="0.1d" url="http://www.mayuli.com/acs-repository/download/apm/ref-us-states-0.1d.apm">
+    <database-support>
+        <database>oracle</database>
+        <database>postgresql</database>
+    </database-support>
+        <owner url="mailto:jon@jongriffin.com">Jon Griffin</owner>
+        <summary>This is all the US States.</summary>
+        <vendor url="www.mayuli.com">Mayuli Enterprises, LLC</vendor>
+        <description format="text/plain">This is all the US States.
+It is needed by many other packages.</description>
+
+        <requires url="acs-kernel" version="4.0"/>
+        <requires url="acs-reference" version="0.1"/>
+        <requires url="ref-language" version="0.1d"/>
+
+        <files>
+            <file type="package_spec" path="ref-us-states.info"/>
+        </files>
+        <parameters>
+        <!-- No version parameters -->
+        </parameters>
+
+    </version>
+</package>
Index: openacs-4/packages/ref-us-states/sql/common/ref-us-states-data.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-states/sql/common/Attic/ref-us-states-data.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-us-states/sql/common/ref-us-states-data.sql	27 Aug 2001 22:53:45 -0000	1.1
@@ -0,0 +1,78 @@
+-- packages/acs-reference/sql/common/us-states.sql
+--
+-- @author jon@jongriffin.com
+-- @creation-date 2000-11-28
+-- @cvs-id $Id: ref-us-states-data.sql,v 1.1 2001/08/27 22:53:45 jong Exp $
+
+insert into us_states values ('AL','ALABAMA','01');
+insert into us_states values ('AK','ALASKA','02');
+insert into us_states values ('AZ','ARIZONA','04');
+insert into us_states values ('AR','ARKANSAS','05');
+insert into us_states values ('CA','CALIFORNIA','06');
+insert into us_states values ('CO','COLORADO','08');
+insert into us_states values ('CT','CONNECTICUT','09');
+insert into us_states values ('DE','DELAWARE','10');
+insert into us_states values ('DC','DISTRICT OF COLUMBIA','11');
+insert into us_states values ('FL','FLORIDA','12');
+insert into us_states values ('GA','GEORGIA','13');
+insert into us_states values ('HI','HAWAII','15');
+insert into us_states values ('ID','IDAHO','16');
+insert into us_states values ('IL','ILLINOIS','17');
+insert into us_states values ('IN','INDIANA','18');
+insert into us_states values ('IA','IOWA','19');
+insert into us_states values ('KS','KANSAS','20');
+insert into us_states values ('KY','KENTUCKY','21');
+insert into us_states values ('LA','LOUISIANA','22');
+insert into us_states values ('ME','MAINE','23');
+insert into us_states values ('MD','MARYLAND','24');
+insert into us_states values ('MA','MASSACHUSETTS','25');
+insert into us_states values ('MI','MICHIGAN','26');
+insert into us_states values ('MN','MINNESOTA','27');
+insert into us_states values ('MS','MISSISSIPPI','28');
+insert into us_states values ('MO','MISSOURI','29');
+insert into us_states values ('MT','MONTANA','30');
+insert into us_states values ('NE','NEBRASKA','31');
+insert into us_states values ('NV','NEVADA','32');
+insert into us_states values ('NH','NEW HAMPSHIRE','33');
+insert into us_states values ('NJ','NEW JERSEY','34');
+insert into us_states values ('NM','NEW MEXICO','35');
+insert into us_states values ('NY','NEW YORK','36');
+insert into us_states values ('NC','NORTH CAROLINA','37');
+insert into us_states values ('ND','NORTH DAKOTA','38');
+insert into us_states values ('OH','OHIO','39');
+insert into us_states values ('OK','OKLAHOMA','40');
+insert into us_states values ('OR','OREGON','41');
+insert into us_states values ('PA','PENNSYLVANIA','42');
+insert into us_states values ('RI','RHODE ISLAND','44');
+insert into us_states values ('SC','SOUTH CAROLINA','45');
+insert into us_states values ('SD','SOUTH DAKOTA','46');
+insert into us_states values ('TN','TENNESSEE','47');
+insert into us_states values ('TX','TEXAS','48');
+insert into us_states values ('UT','UTAH','49');
+insert into us_states values ('VT','VERMONT','50');
+insert into us_states values ('VA','VIRGINIA','51');
+insert into us_states values ('WA','WASHINGTON','53');
+insert into us_states values ('WV','WEST VIRGINIA','54');
+insert into us_states values ('WI','WISCONSIN','55');
+insert into us_states values ('WY','WYOMING','56');
+insert into us_states values ('AS','AMERICAN SAMOA','60');
+insert into us_states values ('GU','GUAM','66');
+insert into us_states values ('MP','NORTHERN MARIANA ISLANDS','69');
+insert into us_states values ('PR','PUERTO RICO','72');
+insert into us_states values ('VI','VIRGIN ISLANDS','78');
+insert into us_states values ('FM','FED. STATES OF MICRONESIA','64');
+insert into us_states values ('UM','US MINOR OUTLYING ISLANDS','74');
+insert into us_states values ('67','JOHNSTON ATOLL','67');
+insert into us_states values ('MH','MARSHALL ISLANDS','68');
+insert into us_states values ('PW','PALAU','70');
+insert into us_states values ('71','MIDWAY ISLANDS','71');
+insert into us_states values ('76','NAVASSA ISLAND','76');
+insert into us_states values ('79','WAKE ISLAND','79');
+insert into us_states values ('81','BAKER ISLAND','81');
+insert into us_states values ('84','HOWLAND ISLAND','84');
+insert into us_states values ('86','JARVIS ISLAND','86');
+insert into us_states values ('89','KINGMAN REEF','89');
+insert into us_states values ('95','PALMYRA ATOLL','95');
+
+commit;
+
Index: openacs-4/packages/ref-us-states/sql/oracle/ref-us-states-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-states/sql/oracle/ref-us-states-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-us-states/sql/oracle/ref-us-states-create.sql	27 Aug 2001 22:52:33 -0000	1.1
@@ -0,0 +1,44 @@
+-- packages/ref-us-states/sql/oracle/ref-us-states-create.sql
+--
+-- @author jon@jongriffin.com
+-- @creation-date 2001-08-27		
+-- @cvs-id $Id: ref-us-states-create.sql,v 1.1 2001/08/27 22:52:33 jong Exp $
+
+create table us_states (
+    abbrev          char(2)
+                    constraint us_states_abbrev_pk primary key,
+    state_name      varchar2(100)
+	            constraint us_states_state_name_nn not null
+                    constraint us_states_state_name_uq unique,
+    fips_state_code char(2)
+                    constraint us_states_fips_state_code_uq unique
+);
+
+comment on table us_states is '
+This is the US states table.
+';
+
+comment on column us_states.abbrev is '
+This is the 2 letter abbreviation for states.
+';
+
+comment on column us_states.fips_state_code is '
+The FIPS code used by the USPS for certain delivery types.
+';
+
+-- add this table into the reference repository
+declare
+    v_id integer;
+begin
+    v_id := acs_reference.new(
+        table_name      => 'US_STATES',
+        source          => 'Internal',
+        source_url      => '',
+        last_update     => sysdate,
+        internal_data_p => 't',
+        effective_date  => sysdate
+    );
+commit;
+end;
+/
+@ '../common/ref-us-states-data.sql'
Index: openacs-4/packages/ref-us-states/sql/oracle/ref-us-states-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-states/sql/oracle/ref-us-states-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-us-states/sql/oracle/ref-us-states-drop.sql	27 Aug 2001 22:56:54 -0000	1.1
@@ -0,0 +1,34 @@
+-- Drop the ACS Reference US States data
+--
+-- @author jon@jongriffin.com
+-- @cvs-id $Id: ref-us-states-drop.sql,v 1.1 2001/08/27 22:56:54 jong Exp $
+
+set serveroutput on
+
+-- drop all associated tables and packages
+-- I am not sure this is a good idea since we have no way to register
+-- if any other packages are using this data.
+
+-- This will probably fail if their is a child table using this.
+-- I can probably make this cleaner also, but ... no time today
+
+declare
+    cursor refsrc_cur is
+	 select   table_name,
+                  package_name,
+                  repository_id
+	 from     acs_reference_repositories
+	 where upper(table_name) = 'US_STATES';
+begin
+    for rec in refsrc_cur loop
+	 dbms_output.put_line('Dropping ' || rec.table_name);
+	 execute immediate 'drop table ' || rec.table_name;
+	 if rec.package_name is not null then
+	     execute immediate 'drop package ' || rec.package_name;
+         end if;
+         acs_reference.delete(rec.repository_id);
+    end loop;
+end;
+/
+show errors
+
Index: openacs-4/packages/ref-us-states/sql/postgresql/ref-us-states-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-us-states/sql/postgresql/ref-us-states-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-us-states/sql/postgresql/ref-us-states-create.sql	27 Aug 2001 22:52:43 -0000	1.1
@@ -0,0 +1,40 @@
+-- packages/ref-us-states/sql/postgresql/ref-us-states-create.sql
+--
+-- @author jon@jongriffin.com
+-- @creation-date 2001-08-27
+-- @cvs-id $Id: ref-us-states-create.sql,v 1.1 2001/08/27 22:52:43 jong Exp $
+
+create table us_states (
+    abbrev          char(2)
+                    constraint us_states_abbrev_pk primary key,
+    state_name      varchar2(100)
+	            constraint us_states_state_name_nn not null
+                    constraint us_states_state_name_uq unique,
+    fips_state_code char(2)
+                    constraint us_states_fips_state_code_uq unique
+);
+
+comment on table us_states is '
+This is the US states table.
+';
+
+comment on column us_states.abbrev is '
+This is the 2 letter abbreviation for states.
+';
+
+comment on column us_states.fips_state_code is '
+The FIPS code used by the USPS for certain delivery types.
+';
+
+-- add this table into the reference repository
+select acs_reference__new (
+    table_name      => 'US_STATES',
+    source          => 'Internal',
+    source_url      => '',
+    last_update     => sysdate,
+    internal_data_p => 't',
+    effective_date  => sysdate
+);
+
+-- load the data
+\i ../common/ref-us-states-data.sql