Index: openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql	27 Aug 2001 04:45:18 -0000	1.1
@@ -0,0 +1,49 @@
+-- packages/ref-language/sql/oracle/ref-language-create.sql
+--
+-- @author jon@jongriffin.com
+-- @creation-date 2000-11-21
+-- @cvs-id $Id: ref-language-create.sql,v 1.1 2001/08/27 04:45:18 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/oracle/ref-language-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-language/sql/oracle/ref-language-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-language/sql/oracle/ref-language-drop.sql	27 Aug 2001 04:37:02 -0000	1.1
@@ -0,0 +1,34 @@
+-- Drop the ACS Reference Language data
+--
+-- @author jon@jongriffin.com
+-- @cvs-id $Id: ref-language-drop.sql,v 1.1 2001/08/27 04:37:02 jong Exp $
+
+set serveroutput on
+
+-- drop all associated tables and packages
+-- I am not sure this is a good idea since we have no way to register
+-- if any other packages are using this data.
+
+-- This will probably fail if their is a child table using this.
+-- I can probably make this cleaner also, but ... no time today
+
+declare
+    cursor refsrc_cur is
+	 select   table_name,
+                  package_name,
+                  repository_id
+	 from     acs_reference_repositories
+	 where table_name = 'language_codes'
+begin
+    for rec in refsrc_cur loop
+	 dbms_output.put_line('Dropping ' || rec.table_name);
+	 execute immediate 'drop table ' || rec.table_name;
+	 if rec.package_name is not null then
+	     execute immediate 'drop package ' || rec.package_name;
+         end if;
+         acs_reference.delete(rec.repository_id);
+    end loop;
+end;
+/
+show errors
+
Index: openacs-4/packages/ref-language/sql/postgresql/ref-language-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-language/sql/postgresql/ref-language-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ref-language/sql/postgresql/ref-language-drop.sql	27 Aug 2001 04:38:47 -0000	1.1
@@ -0,0 +1,34 @@
+-- Drop the ACS Reference Language data
+--
+-- @author jon@jongriffin.com
+-- @cvs-id $Id: ref-language-drop.sql,v 1.1 2001/08/27 04:38:47 jong Exp $
+
+set serveroutput on
+
+-- drop all associated tables and packages
+-- I am not sure this is a good idea since we have no way to register
+-- if any other packages are using this data.
+
+-- This will probably fail if their is a child table using this.
+-- I can probably make this cleaner also, but ... no time today
+
+declare
+    cursor refsrc_cur is
+	 select   table_name,
+                  package_name,
+                  repository_id
+	 from     acs_reference_repositories
+	 where table_name = 'language_codes'
+begin
+    for rec in refsrc_cur loop
+	 dbms_output.put_line('Dropping ' || rec.table_name);
+	 execute immediate 'drop table ' || rec.table_name;
+	 if rec.package_name is not null then
+	     execute immediate 'drop package ' || rec.package_name;
+         end if;
+         acs_reference.delete(rec.repository_id);
+    end loop;
+end;
+/
+show errors
+