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 -r1.5
--- openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql	8 Aug 2006 21:26:22 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql	7 Aug 2017 23:48:09 -0000	1.5
@@ -36,10 +36,8 @@
     package_key                     varchar(100)
                                     constraint dotlrn_applets_package_key_fk
                                     references apm_package_types (package_key),
-    active_p                        char(1)
-                                    default 't'
-                                    constraint dotlrn_applets_active_p_ck
-                                    check (active_p in ('t', 'f'))
+    active_p                        boolean
+                                    default true
                                     constraint dotlrn_applets_active_p_nn
                                     not null
 );
@@ -56,11 +54,11 @@
                                     constraint dotlrn_ca_applet_key_nn
                                     not null,
     -- this is the package_id of the package this applet represents
-    package_id                      integer,
-    active_p                        char(1)
-                                    default 't'
-                                    constraint dotlrn_ca_active_p_ck
-                                    check (active_p in ('t', 'f'))
+    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
                                     not null,
     constraint dotlrn_community_applets_pk
