Index: openacs-4/packages/dotlrn/dotlrn.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/dotlrn.info,v
diff -u -r1.141.2.11 -r1.141.2.12
--- openacs-4/packages/dotlrn/dotlrn.info	20 Feb 2017 12:21:53 -0000	1.141.2.11
+++ openacs-4/packages/dotlrn/dotlrn.info	23 Feb 2017 19:04:15 -0000	1.141.2.12
@@ -7,15 +7,15 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="2.9.1b1" url="http://openacs.org/repository/download/apm/dotlrn-2.9.1b1.apm">
+    <version name="2.9.1b2" url="http://openacs.org/repository/download/apm/dotlrn-2.9.1b2.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>A Course Management System</summary>
         <release-date>2016-08-03</release-date>
         <vendor url="http://dotlrn.org">DotLRN Consortium</vendor>
 	<maturity>2</maturity>
         <description format="text/html">Course Management</description>
 
-        <provides url="dotlrn" version="2.9.1b1"/>
+        <provides url="dotlrn" version="2.9.1b2"/>
         <requires url="acs-kernel" version="5.9.1b1"/>
 	<requires url="acs-tcl" version="5.9.1b1"/>
         <requires url="acs-subsite" version="5.9.1b1"/>
Index: openacs-4/packages/dotlrn/sql/oracle/applets-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/applets-create.sql,v
diff -u -r1.4 -r1.4.10.1
--- openacs-4/packages/dotlrn/sql/oracle/applets-create.sql	8 Aug 2006 21:26:21 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/oracle/applets-create.sql	23 Feb 2017 19:04:15 -0000	1.4.10.1
@@ -53,7 +53,9 @@
                                     constraint dotlrn_ca_applet_key_nn
                                     not null,
     -- this is the package_id of the package this applet represents
-    package_id                      integer,
+    package_id                      integer
+                                    constraint dotlrn_ca_package_id_fk
+                                    references apm_packages (package_id),
     active_p                        char(1)
                                     default 't'
                                     constraint dotlrn_ca_active_p_ck
Index: openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql,v
diff -u -r1.4.10.1 -r1.4.10.2
--- openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql	15 May 2016 18:34:04 -0000	1.4.10.1
+++ openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql	23 Feb 2017 19:04:15 -0000	1.4.10.2
@@ -54,7 +54,9 @@
                                     constraint dotlrn_ca_applet_key_nn
                                     not null,
     -- this is the package_id of the package this applet represents
-    package_id                      integer,
+    package_id                      integer
+                                    constraint dotlrn_ca_package_id_fk
+                                    references apm_packages (package_id),
     active_p                        boolean
                                     default true
                                     constraint dotlrn_ca_active_p_nn