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.2.2.1 -r1.2.2.2
--- openacs-4/packages/acs-subsite/sql/oracle/themes-create.sql	16 May 2009 23:20:05 -0000	1.2.2.1
+++ openacs-4/packages/acs-subsite/sql/oracle/themes-create.sql	16 May 2009 23:33:55 -0000	1.2.2.2
@@ -9,19 +9,19 @@
 --  for these.
 
 create table subsite_themes (
-    key           varchar(4000) 
+    key           varchar(100) 
                   constraint subsite_themes_key_pk
                   primary key,
-    name          varchar(4000) 
+    name          varchar(100) 
                   constraint subsite_theme_name_nn
                   not null,
-    template      varchar(4000)
+    template      varchar(200)
                   constraint subsite_theme_template_nn
                   not null,
-    css           varchar(4000),
-    form_template varchar(4000),
-    list_template varchar(4000),
-    list_filter_template varchar(4000)
+    css           varchar(2000),
+    form_template varchar(200),
+    list_template varchar(200),
+    list_filter_template varchar(200)
 );
 
 -- Insert the old themes that were hard-wired into earlier versions of acs-subsite.