portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r450361 - in /portals/jetspeed-2/trunk/etc/sql/sandbox: ./ portlet-prefs-schema.xml
Date Wed, 27 Sep 2006 07:22:27 GMT
Author: taylor
Date: Wed Sep 27 00:22:27 2006
New Revision: 450361

URL: http://svn.apache.org/viewvc?view=rev&rev=450361
Log:
prototyping

Added:
    portals/jetspeed-2/trunk/etc/sql/sandbox/
    portals/jetspeed-2/trunk/etc/sql/sandbox/portlet-prefs-schema.xml

Added: portals/jetspeed-2/trunk/etc/sql/sandbox/portlet-prefs-schema.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/trunk/etc/sql/sandbox/portlet-prefs-schema.xml?view=auto&rev=450361
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/sandbox/portlet-prefs-schema.xml (added)
+++ portals/jetspeed-2/trunk/etc/sql/sandbox/portlet-prefs-schema.xml Wed Sep 27 00:22:27
2006
@@ -0,0 +1,47 @@
+<?xml version="1.0"?>
+<!--
+Copyright 2004 The Apache Software Foundation
+
+Licensed under the Apache License, Version 2.0 (the "License");
+you may not use this file except in compliance with the License.
+You may obtain a copy of the License at
+
+    http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_2.dtd">
+<!-- Autogenerated by JDBCToXMLSchema! -->
+<database name="j2">
+    
+    <table name="JET_ENTITY">
+        <column name="ENTITY_ID" primaryKey="true" required="true" size="100" type="VARCHAR"/>
+        <column name="APP_NAME" required="true" size="255" type="VARCHAR"/>
+        <column name="PORTLET_NAME" required="true" size="255" type="VARCHAR"/>
+        <unique name="UK_ENTITY_ID">
+            <unique-column name="ENTITY_ID"/>
+        </unique>
+    </table>
+    
+    <table name="JET_PREFS">
+        <column name="PREF_ID" primaryKey="true" required="true" type="INTEGER"/> 
      
+        <column name="ENTITY_ID" type="VARCHAR" required="true" size="100"/>
+        <column name="PREF_TYPE" type="VARCHAR" required="true" size="10"/>       

+        <column name="PRINCIPAL" type="VARCHAR" required="true" size="60"/>
+        <column name="PREF_NAME" type="VARCHAR" required="true" size="255"/>
+        <column name="PREF_VALUE" type="VARCHAR" required="true" size="255"/>     
  
+        <foreign-key foreignTable="JET_ENTITY" onDelete="cascade">
+            <reference foreign="ID" local="ENTITY"/>
+        </foreign-key>        
+        <index name="JET_PREFS_IX1">
+            <index-column name="ENTITY_ID"/>
+            <index-column name="PREF_TYPE"/>            
+            <index-column name="PRINCIPAL"/>                        
+        </index>        
+    </table>
+</database>
+



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


Mime
View raw message