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 -r1.23 -r1.24
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	17 Nov 2001 16:34:04 -0000	1.23
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	20 Nov 2001 18:48:21 -0000	1.24
@@ -126,7 +126,16 @@
 				not null,
 	theme_id		constraint portal_theme_id_fk
 				references portal_element_themes
-				not null
+				not null,
+	-- is this portal a portal template?
+	portal_template_p	char(1) default 'f'
+				constraint p_portal_template_p_ck
+				check(portal_template_p in ('f', 't')),
+	-- if it's a template, is it active?
+	template_active_p	char(1) default 'f'
+				constraint p_template_active_p_ck
+				check(template_active_p in ('f', 't'))
+
 );
 
 -- **** Portal Elements (PEs) ****