Index: openacs-4/packages/acs-subsite/sql/oracle/themes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/themes-create.sql,v
diff -u -r1.4.6.4 -r1.4.6.5
--- openacs-4/packages/acs-subsite/sql/oracle/themes-create.sql	12 Sep 2015 17:25:06 -0000	1.4.6.4
+++ openacs-4/packages/acs-subsite/sql/oracle/themes-create.sql	11 Feb 2017 21:54:38 -0000	1.4.6.5
@@ -10,22 +10,21 @@
 
 create table subsite_themes (
     key           varchar(100) 
-                  constraint subsite_themes_key_pk
-                  primary key,
+                  constraint subsite_themes_key_pk primary key,
     name          varchar(100) 
-                  constraint subsite_themes_name_nn
-                  not null,
+                  constraint subsite_themes_name_nn not null,
     template      varchar(200)
-                  constraint subsite_themes_template_nn
-                  not null,
+                  constraint subsite_themes_template_nn not null,
     css           varchar(2000),
     js            varchar(2000),
     form_template varchar(200),
     list_template varchar(200),
     list_filter_template varchar(200),
     dimensional_template varchar(200),
     resource_dir   varchar(200),
-    streaming_head varchar(200)
+    streaming_head varchar(200),
+    local_p        char(1) default 'f'
+                   constraint subsite_themes_local_p_ck check (local_p in ('t','f'))
 );
 
 -- Insert the old themes that were hard-wired into earlier versions of acs-subsite.
