Index: openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql 17 Jul 2003 01:10:40 -0000 1.3 +++ openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql 19 May 2007 06:55:54 -0000 1.4 @@ -46,41 +46,3 @@ end; / --- This is the translated mapping of country names - -create table country_names ( - -- lookup into the countries table - iso char(2) - constraint country_names_iso_fk - references countries (iso), - -- lookup into the language_codes table - language_code - constraint country_names_language_code_fk - references language_codes (language_id), - -- the translated name - name varchar(100) -); - -comment on table country_names is ' - This is the translated mapping of country names and language codes. -'; - -comment on column country_names.language_code is ' - This is a lookup into the iso languages table. -'; - --- I need to know the easy way to add extended chars in sqlplus then I can add french and spanish - --- add this table into the reference repository -declare - v_id integer; -begin - v_id := acs_reference.new( - table_name => 'COUNTRY_NAMES', - source => 'Internal', - source_url => '', - effective_date => sysdate - ); -commit; -end; -/