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 -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;
 
   
