taylor      2004/05/11 22:09:00

  Modified:    src/schema registry-schema.xml
  Log:
  During creation of SQL scripts, the FK from SECURITY_ROLE to WEB_APP was referencing 
a non existent table,
  causing the db.create.test script to fail under HSQL
  
  Revision  Changes    Path
  1.11      +8 -8      jakarta-jetspeed-2/src/schema/registry-schema.xml
  
  Index: registry-schema.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/src/schema/registry-schema.xml,v
  retrieving revision 1.10
  retrieving revision 1.11
  diff -u -r1.10 -r1.11
  --- registry-schema.xml       10 May 2004 17:43:28 -0000      1.10
  +++ registry-schema.xml       12 May 2004 05:09:00 -0000      1.11
  @@ -186,14 +186,6 @@
           </unique>
       </table>
   
  -    <!--
  -       Create Web Application Table
  -    -->
  -    <table name="WEB_APPLICATION">
  -        <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
  -        <column name="CONTEXT_ROOT" required="true" size="255" type="VARCHAR"/>
  -    </table>
  -
       <!--                                                                   
          Security Role                                                        
       -->                                                                     
  @@ -206,5 +198,13 @@
               <reference foreign="ID" local="WEB_APPLICATION_ID"/>            
           </foreign-key>                                                      
       </table>                                                                
  +
  +    <!--
  +       Create Web Application Table
  +    -->
  +    <table name="WEB_APPLICATION">
  +        <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
  +        <column name="CONTEXT_ROOT" required="true" size="255" type="VARCHAR"/>
  +    </table>
                            
   </database>
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to