Index: openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	8 Jul 2002 21:04:16 -0000	1.1
+++ openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	13 Jul 2002 00:13:09 -0000	1.2
@@ -135,43 +135,4 @@
     where dotlrn_communities.community_id = groups.group_id
     and groups.join_policy <> 'closed';
 
-create table dotlrn_applets (
-    applet_id                   integer
-                                constraint dotlrn_applets_applet_pk 
-                                primary key,
-    applet_key                  varchar(100)
-                                constraint dotlrn_applets_applet_key_nn
-                                not null
-                                constraint dotlrn_applets_applet_key_uk
-                                unique,
-    status                      char(10)
-                                default 'active'
-                                constraint dotlrn_applets_status_nn
-                                not null
-                                constraint dotlrn_applets_status_ck
-                                check (status in ('active','inactive'))
-);
-
-create table dotlrn_community_applets (
-    community_id                integer
-                                constraint dotlrn_ca_community_id_nn
-                                not null
-                                constraint dotlrn_ca_community_id_fk
-                                references dotlrn_communities_all (community_id),
-    applet_id                   integer
-                                constraint dotlrn_ca_applet_key_nn
-                                not null
-                                references dotlrn_applets (applet_id),
-    -- 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'))
-                                constraint dotlrn_ca_active_p_nn
-                                not null,
-    constraint dotlrn_community_applets_pk 
-    primary key (community_id, applet_id)
-);
-
 \i communities-tree-create.sql
