Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/ref-language/sql/oracle/language.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/ref-language/sql/oracle/ref-language.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-language/sql/oracle/Attic/ref-language.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/ref-language/sql/oracle/ref-language.sql 27 Aug 2001 04:36:50 -0000 1.1 @@ -0,0 +1,49 @@ +-- packages/ref-language/sql/oracle/language.sql +-- +-- @author jon@jongriffin.com +-- @creation-date 2000-11-21 +-- @cvs-id $Id: ref-language.sql,v 1.1 2001/08/27 04:36:50 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 Index: openacs-4/packages/ref-language/sql/postgresql/ref-language.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-language/sql/postgresql/Attic/ref-language.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/ref-language/sql/postgresql/ref-language.sql 27 Aug 2001 04:38:40 -0000 1.1 @@ -0,0 +1,44 @@ +-- packages/ref-language/sql/postgresql/language.sql +-- +-- @author jon@jongriffin.com +-- @creation-date 2000-11-21 +-- @cvs-id $Id: ref-language.sql,v 1.1 2001/08/27 04:38:40 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 +select acs_reference__new( + 'LANGUAGE_CODES', + 'ISO 639', + 'http://www.iso.ch', + null, -- last update + sysdate() +); + +-- data +/i ../common/language-data \ No newline at end of file