Index: openacs-4/packages/dotlrndoc/www/doc/left-to-finish-core.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrndoc/www/doc/Attic/left-to-finish-core.adp,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/dotlrndoc/www/doc/left-to-finish-core.adp	14 Nov 2001 05:47:59 -0000	1.1
+++ openacs-4/packages/dotlrndoc/www/doc/left-to-finish-core.adp	14 Nov 2001 19:40:25 -0000	1.2
@@ -1,16 +1,27 @@
 <%= [dotlrn_header "dotLRN Documentation: Left to Finish Core"] %>
 <h2>dotLRN: Left to Finish Core</h2>
 part of <a href=./>dotLRN Documentation</a>
-<hr><p>
+<hr>
+<p>
+<font size=-2>Last update: $Date$</font>
+<p>
 
 Here's what we need to do to finish core:
 
 <h3>Portal</h3>
 <ul>
-<li> Adjust buttons on portlets as a function of capabilities.
+<li> Adjust buttons on portlets as a function of capabilities
 <li> Implement portlet locking capability.
+<li> Implement cloning stuff.
 <li> Refactor some functionality as part of base portal package.
-<li> Clean up UI on configuration page.
+<li> Clean up UI on configuration page (change backlink)
+<li> add acs-service-contract support.
+<li> change theme data model to map to pages.
+<li> add roles and permissions (admin create|delete)
+     (from dotlrn_community API).
+<li> Remove render-element.tcl ::get_pretty_name other render cleanup
+<li> Params issues
+<li> code review (Monday, 11/19, 10am-12pm).
 </ul>
 
 <h3>dotLRN Core</h3>
@@ -20,23 +31,25 @@
 <li> Move administration to community-specific pages! Duh!
 <li> Allow for addition of users who haven't registered yet? Check that.
 <li> Automatically redirect single-community guests to the right location.
-<li> Fix registration bugs!
+<li> Fix registration/deregistration bugs!
+<li> Get clubs working
+<li> !! Figure out Relational Segments !!
 </ul>
 
-<h3>bboard</h3>
-<ul>
-<li> test a bit more
-<li> improve the portlet and make it NOT dependent on dotLRN
-<li> allow parameter editing for displaying certain information in portlet
-</ul>
-
 <h3>calendar</h3>
 <ul>
 <li> make group calendar work!
 <li> each user has *ONE* personal calendar, and has access to each community calendar.
 <li> calendar works as multi-package view in portlet.
 </ul>
 
+<h3>bboard</h3>
+<ul>
+<li> test a bit more
+<li> improve the portlet and make it NOT dependent on dotLRN
+<li> allow parameter editing for displaying certain information in portlet
+</ul>
+
 <h3>File Storage</h3>
 <ul>
 <li> Clean up UI big time
@@ -47,7 +60,12 @@
 
 <h3>FAQ</h3>
 <ul>
-<li> Clean up portlet UI
+<li> Clean up portlet UI (display list of FAQs)1
 </ul>
 
+<h3>News</h3>
+<ul>
+<li> make news multi-instance capable.
+</ul>
+
 <%= [dotlrn_footer] %>
Index: openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql,v
diff -u -N -r1.19 -r1.20
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	10 Nov 2001 20:17:21 -0000	1.19
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	14 Nov 2001 19:50:12 -0000	1.20
@@ -7,7 +7,6 @@
 
 -- **** PRIVILEGES ****
 begin
-
     -- multi portal admin privs
     acs_privilege.create_privilege('portal_create_portal');
     acs_privilege.create_privilege('portal_delete_portal');
@@ -23,26 +22,6 @@
 
 -- **** DATASOURCES ****
 
-create table portal_mime_types (
-	name		varchar(200)
-			constraint p_mime_types_name_pk primary key,
-	pretty_name	varchar(200)
-);
-
--- secure_p is for an extra layer of security. See defualts.sql
-create table portal_data_types (
-	name		varchar(200)
-			constraint p_data_types_name_pk primary key,
-	pretty_name	varchar(200),
-	secure_p	char(1) default 'f'
-			constraint p_data_types_secure_p_ck
-			check(secure_p in ('t', 'f'))
-);
-
-
--- XXX A central unresolved issue here is how to model the DS's
--- metadata, args, etc.  acs-service-contract?
-
 -- Some datasources need to be restricted and some do not.  The way we
 -- will handle this is a check at PE creation (DS binding) time, and
 -- of course, checks on the portal_id sent in.
@@ -158,13 +137,16 @@
 -- Restrict to party check? 
 -- Roles and perms issues? 
 create table portals (
-	portal_id	 	constraint p_portal_id_fk
+	portal_id	 	constraint portal_portal_id_fk
 				references acs_objects(object_id)
 				constraint p_portal_id_pk
 				primary key,
 	name			varchar(200) default 'Untitled' not null,
-	layout_id		constraint p_template_id_fk
+	layout_id		constraint portal_template_id_fk
 				references portal_layouts
+				not null,
+	theme_id		constraint portal_theme_id_fk
+				references portal_element_themes
 				not null
 );
 
@@ -192,9 +174,6 @@
 				references portal_datasources
 				on delete cascade
 				not null,
-	theme_id		constraint p_element_map_theme_id_fk
-				references portal_element_themes
-				not null,
 	region			varchar(20) not null,
 	sort_key		integer	not null,
 	state			varchar(6) default 'full'