Index: openacs-4/packages/acs-reference/sql/oracle/language.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/oracle/Attic/language.sql,v diff -u -N --- openacs-4/packages/acs-reference/sql/oracle/language.sql 17 Jul 2001 04:59:28 -0000 1.3 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,49 +0,0 @@ --- packages/acs-reference/sql/common/language.sql --- --- @author jon@jongriffin.com --- @creation-date 2000-11-21 --- @cvs-id $Id: language.sql,v 1.3 2001/07/17 04:59:28 jong Exp $ --- - - --- ISO 639 -create table language_codes ( - language_id char(2) - constraint language_codes_language_id_pk - primary key, - name varchar(100) - constraint language_codes_name_uq - unique - constraint language_codes_name_nn - not null -); - -comment on table language_codes is ' - This is data from the ISO 639 standard on language codes. -'; - -comment on column language_codes.language_id is ' - This is the ISO standard language code -'; - -comment on column language_codes.name is ' - This is the English version of the language name. - I don''t want to get crazy here! -'; - --- now register this table with the repository -declare - v_id integer; -begin - v_id := acs_reference.new( - table_name => upper('language_codes'), - source => 'ISO 639', - source_url => 'http://www.iso.ch', - effective_date => sysdate - ); -commit; -end; -/ - --- data -@@../common/language-data \ No newline at end of file