Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-classes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-classes-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-classes-create.sql	20 Sep 2001 18:54:51 -0000	1.1
@@ -0,0 +1,28 @@
+
+--
+-- The DotLRN basic system
+-- copyright 2001, OpenForce, Inc.
+-- distributed under the GNU GPL v2
+--
+-- for Oracle 8/8i. (We're guessing 9i works, too).
+--
+-- ben@openforce.net
+-- started August 18th, 2001
+--
+
+create table dotlrn_classes (
+       class_key		    constraint dotlrn_class_class_key_fk
+				    references dotlrn_community_types(community_type)
+				    constraint dotlrn_class_class_key_pk
+				    primary key
+);
+
+create table dotlrn_class_instances (
+       class_instance_id	    constraint dotlrn_class_i_id_fk
+				    references dotlrn_communities(community_id)
+				    constraint dotlrn_class_i_id_pk
+				    primary key,
+       class_key		    constraint dotlrn_class_i_class_key_fk
+				    references dotlrn_classes(class_key)
+);
+
Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-communities-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-communities-create.sql	20 Sep 2001 18:54:51 -0000	1.1
@@ -0,0 +1,41 @@
+
+--
+-- The DotLRN communities construct
+-- copyright 2001, OpenForce, Inc.
+-- distributed under the GNU GPL v2
+--
+-- for Oracle 8/8i. (We're guessing 9i works, too).
+--
+-- ben@openforce.net
+-- started September 20th, 2001 (redone)
+--
+
+create table dotlrn_community_types (
+       community_type		    not null
+				    constraint dlrn_comm_type_pk primary key
+				    constraint dlrn_comm_type_fk
+				    references group_types (group_type),
+       pretty_name		    varchar(100) not null,
+       description		    varchar(4000),
+       node_id			    constraint dlrn_comm_type_node_id_fk
+				    references site_nodes(node_id),
+       supertype		    constraint dlrn_comm_supertype_fk
+				    references dotlrn_community_types(community_type)
+);
+       
+
+create table dotlrn_communities (
+       community_id		not null
+				constraint dlrn_comm_id_pk primary key
+				constraint dlrn_comm_id_fk
+				references groups(group_id),
+       community_type		not null
+				constraint dlrn_comm_id_type_fk
+				references dotlrn_community_types(community_type),
+       community_key		varchar(100) not null
+				constraint dlrn_comm_key_un unique,
+       pretty_name		varchar(100) not null,
+       description		varchar(4000),
+       node_id			constraint dlrn_comm_node_id_fk
+				references site_nodes(node_id)
+);
Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql	20 Sep 2001 18:29:35 -0000	1.1
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql	20 Sep 2001 18:54:51 -0000	1.2
@@ -10,41 +10,6 @@
 -- started August 18th, 2001
 --
 
--- Since a lot of stuff needs to happen to set up a group type,
--- this isn't going to be done at the data model level, it's going to
--- be done in Tcl. Woohoo.
-
-
--- We do need some basic data model to represent classes, class instances
--- and the associated information there
-
-create table dotlrn_classes (
-       class_key		    constraint dotlrn_class_class_key_fk
-				    references group_types(group_type)
-				    constraint dotlrn_class_class_key_pk
-				    primary key,
-       node_id			    constraint dotlrn_class_node_id_fk
-				    references site_nodes (node_id)
-);
-
-create table dotlrn_class_instances (
-       class_instance_id	    constraint dotlrn_class_i_id_fk
-				    references groups(group_id)
-				    constraint dotlrn_class_i_id_pk
-				    primary key,
-       class_instance_key	    varchar(100) not null 
-				    constraint dotlrn_class_i_key_un unique,
-       class_key		    constraint dotlrn_class_i_class_key_fk
-				    references dotlrn_classes(class_key),
-       node_id			    constraint dotlrn_class_i_node_id_fk
-				    references site_nodes(node_id)
-);
-
-create table dotlrn_class_inst_applets (
-       class_instance_id	    constraint dotlrn_class_i_app_inst_fk
-				    references dotlrn_class_instances(class_instance_id),
-       applet			    varchar(200) not null,
-       constraint dotlrn_class_inst_app_pk primary key (class_instance_id, applet),
-       node_id		            constraint dotlrn_c_i_app_node_id_fk
-				    references site_nodes(node_id)
-);
+@dotlrn-communities-create.sql
+@dotlrn-clubs-create.sql
+@dotlrn-classes-create.sql