Index: openacs-4/packages/acs-reference/sql/common/s-and-p-data.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/s-and-p-data.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-reference/sql/common/s-and-p-data.sql	17 Jul 2001 01:45:41 -0000	1.1
+++ openacs-4/packages/acs-reference/sql/common/s-and-p-data.sql	17 Jul 2001 05:03:55 -0000	1.2
@@ -4,47 +4,6 @@
 -- @creation-date 2000-11-21
 -- @cvs-id $Id$
 
-create table long_term_issue_ratings (
-    -- this is the sort key
-    rank  integer
-        constraint long_term_issue_rank_pk
-        primary key,
-    -- the actual rating
-    rating char(4)
-        constraint long_term_issue_rating_uq
-        unique
-        constraint long_term_issue_rating_nn
-        not null,
-    description varchar2(1000)
-);
-
-comment on table long_term_issue_ratings is '
-    This is a sample of some of the non-standards based standards.
-    It is the Standard y Poor''s credit ratings.
-';
-
-comment on column long_term_issue_ratings.rank is '
-    This is the rank with AAA+ being highest.
-';
-
--- now register this table with the repository
-
-declare
-    v_id integer;
-begin
-    v_id := acs_reference.new(
-        table_name     => 'LONG_TERM_ISSUE_RATINGS',
-        source         => 'Standard '||chr(38)||' Poor''s',
-        source_url     => 'http://www.standardandpoors.com/ratings/corporates/index.htm',
-        effective_date => sysdate
-    );
-end;
-/
-
--- now add data
-
-set feedback off;
-
 insert into long_term_issue_ratings
  values (1,'AAA','An obligation rated ''AAA'' has the highest rating assigned by Standard '||chr(38) ||' Poor''s. The obligor''s capacity to meet its financial commitment on the obligation is extremely strong.');
     
@@ -117,7 +76,6 @@
 insert into long_term_issue_ratings
  values (24,'N.R.','This indicates that no rating has been requested, that there is insufficient information on which to base a rating, or that Standard '||chr(38)||' Poor''s does not rate a particular obligation as a matter of policy.');
 
-set feedback on;
 commit;
 
   
Index: openacs-4/packages/acs-reference/sql/common/timezone-data.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/timezone-data.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-reference/sql/common/timezone-data.sql	17 Jul 2001 01:45:41 -0000	1.1
+++ openacs-4/packages/acs-reference/sql/common/timezone-data.sql	17 Jul 2001 05:03:55 -0000	1.2
@@ -4,8 +4,6 @@
 -- 
 -- @cvs-id $Id$
 
-set feedback off;
-
 begin
     timezone.new('Africa/Abidjan','+000000');
     timezone.new('Africa/Accra','+000000');
@@ -532,4 +530,3 @@
 /
 show errors
 
-set feedback on;
Index: openacs-4/packages/acs-reference/sql/common/us-states.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/us-states.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-reference/sql/common/us-states.sql	17 Jul 2001 01:45:44 -0000	1.1
+++ openacs-4/packages/acs-reference/sql/common/us-states.sql	17 Jul 2001 05:03:55 -0000	1.2
@@ -4,48 +4,6 @@
 -- @creation-date 2000-11-28
 -- @cvs-id $Id$
 
-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;
-/
-
--- Some data
-
-set feedback off;
-
 insert into us_states values ('AL','ALABAMA','01');
 insert into us_states values ('AK','ALASKA','02');
 insert into us_states values ('AZ','ARIZONA','04');
@@ -116,7 +74,5 @@
 insert into us_states values ('89','KINGMAN REEF','89');
 insert into us_states values ('95','PALMYRA ATOLL','95');
 
-set feedback on;
-
 commit;
 
Index: openacs-4/packages/acs-reference/sql/common/us-zipcodes-data.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/us-zipcodes-data.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-reference/sql/common/us-zipcodes-data.sql	17 Jul 2001 01:45:44 -0000	1.1
+++ openacs-4/packages/acs-reference/sql/common/us-zipcodes-data.sql	17 Jul 2001 05:03:55 -0000	1.2
@@ -5,8 +5,6 @@
 --
 -- $Id$
 
-set feedback off;
-
 insert into us_zipcodes values ('00210','PORTSMOUTH','33','015',+43.005895,-071.013202);
 insert into us_zipcodes values ('00211','PORTSMOUTH','33','015',+43.005895,-071.013202);
 insert into us_zipcodes values ('00212','PORTSMOUTH','33','015',+43.005895,-071.013202);
@@ -42200,6 +42198,5 @@
 insert into us_zipcodes values ('99929','WRANGELL','02','280',+56.449893,-132.364407);
 insert into us_zipcodes values ('99950','KETCHIKAN','02','130',+55.542007,-131.432682);
 
-set feedback on;
-
+commit;
 -- End of US Zipcode Database (42192 records)