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.8 -r1.9
--- openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql	21 Jan 2003 16:27:24 -0000	1.8
+++ openacs-4/packages/acs-lang/sql/oracle/ad-locales.sql	13 Feb 2003 15:03:50 -0000	1.9
@@ -162,11 +162,13 @@
  values ('TH_TH', 'Thai (TH)', 'th', 'TH', 'THAI', 'THAILAND', 'TH8TISASCII', 'TIS-620', 't');
 
 create table ad_locale_user_prefs (
-       user_id                        integer
-                                      primary key
-                                      references users (user_id),
-       locale                         varchar2(30) not null
-                                      constraint
-                                      trb_language_preference_lid_fk
-                                      references ad_locales (locale)
+  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
 );
