Index: openacs-4/packages/ref-gifi/sql/oracle/ref-gifi-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-gifi/sql/oracle/ref-gifi-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ref-gifi/sql/oracle/ref-gifi-create.sql 15 Nov 2005 06:04:00 -0000 1.1 +++ openacs-4/packages/ref-gifi/sql/oracle/ref-gifi-create.sql 22 Nov 2005 08:46:25 -0000 1.2 @@ -7,7 +7,7 @@ -- gifi_registry contains GIFIs available through ref-gifi package create table gifi_templates ( - -- gifi abbreviation or code, a reference which is used to match key in gifi_template_columns + -- gifi abbreviation or code, a reference which is used to match key in gifi_template_accounts code char(30) constraint gifi_template_pk primary key, @@ -39,29 +39,29 @@ end; / -create table gifi_template_columns ( +create table gifi_template_accounts ( -- gifi abbreviation or code, a reference which is used to match key in gifi_templates -- there should be a constraint added here that points to gifi_templates.code code char(30), -- gifi title, should contain a two letter reference to entity/country published title varchar(300) not null, - -- accno, account number for one column/item in the gifi + -- accno, account reference or number accno varchar(100) not null ); -comment on table gifi_template_columns is ' - This table contains the gifis available from ref-gifi package +comment on table gifi_template_accounts is ' + This table contains the gifi data available for each template in ref-gifi package '; -- add this table into the reference repository declare v_id integer; begin v_id := acs_reference.new( - table_name => 'GIFI_TEMPLATE_COLUMNS', + table_name => 'GIFI_TEMPLATE_ACCOUNTS', source => 'GIFI PUBLISHERS', source_url => 'http://openacs.org/doc/current/ref-gifi', last_update => to_date('2005-09-28','YYYY-MM-DD'),