Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/country.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/currency.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/language.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/acs-reference/sql/oracle/s-and-p.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/oracle/Attic/s-and-p.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-reference/sql/oracle/s-and-p.sql 17 Jul 2001 04:59:28 -0000 1.1 @@ -0,0 +1,47 @@ +-- packages/acs-reference/sql/oracle/s-and-p-data.sql +-- +-- @author jon@jongriffin.com +-- @creation-date 2000-11-21 +-- @cvs-id $Id: s-and-p.sql,v 1.1 2001/07/17 04:59:28 jong Exp $ + +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 +@@../common/s-and-p-data.sql + + Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/us-counties.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/us-states.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-reference/sql/oracle/us-zipcodes.sql'. Fisheye: No comparison available. Pass `N' to diff?