Return-Path: 
 <jetspeed-dev-return-23858-apmail-portals-jetspeed-dev-archive=portals.apache.org@portals.apache.org>
Delivered-To: apmail-portals-jetspeed-dev-archive@www.apache.org
Received: (qmail 71467 invoked from network); 18 Oct 2005 17:27:51 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 18 Oct 2005 17:27:51 -0000
Received: (qmail 81777 invoked by uid 500); 18 Oct 2005 17:27:45 -0000
Delivered-To: apmail-portals-jetspeed-dev-archive@portals.apache.org
Received: (qmail 81658 invoked by uid 500); 18 Oct 2005 17:27:44 -0000
Mailing-List: contact jetspeed-dev-help@portals.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jetspeed-dev-help@portals.apache.org>
List-Unsubscribe: <mailto:jetspeed-dev-unsubscribe@portals.apache.org>
List-Post: <mailto:jetspeed-dev@portals.apache.org>
List-Id: <jetspeed-dev.portals.apache.org>
Reply-To: "Jetspeed Developers List" <jetspeed-dev@portals.apache.org>
Delivered-To: mailing list jetspeed-dev@portals.apache.org
Received: (qmail 81558 invoked by uid 99); 18 Oct 2005 17:27:44 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Oct 2005 10:27:44 -0700
X-ASF-Spam-Status: No, hits=-9.4 required=10.0
	tests=ALL_TRUSTED,NO_REAL_NAME,UPPERCASE_25_50
X-Spam-Check-By: apache.org
Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194)
    by apache.org (qpsmtpd/0.29) with SMTP; Tue, 18 Oct 2005 10:27:44 -0700
Received: (qmail 70989 invoked by uid 65534); 18 Oct 2005 17:27:23 -0000
Message-ID: <20051018172723.70988.qmail@minotaur.apache.org>
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r326175 -
 /portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml
Date: Tue, 18 Oct 2005 17:27:22 -0000
To: jetspeed-dev@portals.apache.org
From: rwatler@apache.org
X-Mailer: svnmailer-1.0.5
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Author: rwatler
Date: Tue Oct 18 10:27:20 2005
New Revision: 326175

URL: http://svn.apache.org/viewcvs?rev=326175&view=rev
Log:
cleanup and shorten page key width

Modified:
    portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml

Modified: portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml?rev=326175&r1=326174&r2=326175&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml (original)
+++ portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml Tue Oct 18 10:27:20 2005
@@ -24,7 +24,7 @@
     <table name="FOLDER">
         <column name="FOLDER_ID" primaryKey="true" required="true" type="INTEGER"/>
 		<column name="PARENT_ID" type="INTEGER"/>
-        <column name="PATH" required="true" size="255" type="VARCHAR"/>
+        <column name="PATH" required="true" size="160" type="VARCHAR"/>
         <column name="NAME" required="true" size="80" type="VARCHAR"/>
         <column name="TITLE" size="100" type="VARCHAR"/>
 		<foreign-key foreignTable="FOLDER" onDelete="cascade">
@@ -33,6 +33,9 @@
 		<index name="IX_FOLDER_1">
 			<index-column name="PARENT_ID"/>
 		</index>
+		<unique name="UN_FOLDER_1">
+			<unique-column name="PATH"/>
+		</unique>
     </table>
     
     <!--
@@ -42,7 +45,7 @@
     <table name="PAGE">
         <column name="PAGE_ID" primaryKey="true" required="true" type="INTEGER"/>
 		<column name="PARENT_ID" type="INTEGER"/>
-        <column name="PATH" required="true" size="255" type="VARCHAR"/>
+        <column name="PATH" required="true" size="160" type="VARCHAR"/>
         <column name="NAME" required="true" size="80" type="VARCHAR"/>
         <column name="TITLE" size="100" type="VARCHAR"/>
         <column name="SKIN" size="80" type="VARCHAR"/>
@@ -50,10 +53,10 @@
         <column name="DEFAULT_FRAGMENT_DECORATOR" size="80" type="VARCHAR"/>
         <column name="SUBSITE" size="40" type="VARCHAR"/>
         <column name="PRINCIPAL" size="40" type="VARCHAR"/>
-        <column name="PRINCIPAL_TYPE" size="40" type="VARCHAR"/>
-        <column name="MEDIATYPE" size="40" type="VARCHAR"/>
-        <column name="LOCALE" size="40" type="VARCHAR"/>
-        <column name="EXT_LOCATOR_NAME" size="40" type="VARCHAR"/>
+        <column name="PRINCIPAL_TYPE" size="15" type="VARCHAR"/>
+        <column name="MEDIATYPE" size="15" type="VARCHAR"/>
+        <column name="LOCALE" size="10" type="VARCHAR"/>
+        <column name="EXT_LOCATOR_NAME" size="15" type="VARCHAR"/>
         <column name="EXT_LOCATOR_VALUE" size="40" type="VARCHAR"/>
 		<foreign-key foreignTable="FOLDER" onDelete="cascade">
 			<reference foreign="FOLDER_ID" local="PARENT_ID"/>
@@ -80,7 +83,7 @@
     <table name="FRAGMENT">
         <column name="FRAGMENT_ID" primaryKey="true" required="true" type="INTEGER"/>
 		<column name="PARENT_ID" type="INTEGER"/>
-		<column name="PAGE_ID" type="VARCHAR" size="255"/>
+		<column name="PAGE_ID" type="INTEGER"/>
         <column name="NAME" size="100" type="VARCHAR"/>
         <column name="TITLE" size="100" type="VARCHAR"/>
         <column name="TYPE" size="40" type="VARCHAR"/>
@@ -89,7 +92,7 @@
         <column name="STATE" size="40" type="VARCHAR"/>
         <column name="LAYOUT_ROW" type="INTEGER"/>
         <column name="LAYOUT_COLUMN" type="INTEGER"/>
-        <column name="LAYOUT_WIDTH" type="INTEGER"/>
+        <column name="LAYOUT_WIDTHS" size="20" type="VARCHAR"/>
         <column name="EXT_PROPERTY_NAME_1" size="40" type="VARCHAR"/>
         <column name="EXT_PROPERTY_VALUE_1" size="80" type="VARCHAR"/>
         <column name="EXT_PROPERTY_NAME_2" size="40" type="VARCHAR"/>



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org