Index: openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql,v
diff -u -r1.22 -r1.23
--- openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql	23 Sep 2003 08:55:45 -0000	1.22
+++ openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql	1 Oct 2003 10:50:51 -0000	1.23
@@ -56,6 +56,18 @@
 select * from ad_locales
 where enabled_p = 't';  
 
+create table ad_locale_user_prefs (
+  user_id               integer
+                        constraint ad_locale_user_prefs_users_fk
+                        references users (user_id) on delete cascade,
+  package_id            integer
+                        constraint lang_package_l_u_package_id_fk
+                        references apm_packages(package_id) on delete cascade,
+  locale                varchar(30) not null
+                        constraint trb_language_preference_lid_fk
+                        references ad_locales (locale) on delete cascade
+);
+
 insert into ad_locales 
        (locale, label, language, country, nls_language, nls_territory, 
         nls_charset, mime_charset, default_p, enabled_p)