r153 - in gnue-cddb: . scripts

[kilo]

Author: kilo
Date: 2004-12-03 02:35:23 -0600 (Fri, 03 Dec 2004)
New Revision: 153

Added:
   gnue-cddb/scripts/
   gnue-cddb/scripts/gnue.gsd
   gnue-cddb/scripts/setup-db.sh
   gnue-cddb/scripts/start-appserver
Log:
GNUe CDDB.
Added setup and appserver-starter scripts.

Added: gnue-cddb/scripts/gnue.gsd
===================================================================
--- gnue-cddb/scripts/gnue.gsd  2004-12-02 16:36:55 UTC (rev 152)
+++ gnue-cddb/scripts/gnue.gsd  2004-12-03 08:35:23 UTC (rev 153)
@@ -0,0 +1,955 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<!--
+  GNU Enterprise Application Server - Database Schema and Base Classes
+ 
+  Copyright 2001-2004 Free Software Foundation
+ 
+  This file is part of GNU Enterprise
+ 
+  GNU Enterprise is free software; you can redistribute it
+  and/or modify it under the terms of the GNU General Public
+  License as published by the Free Software Foundation; either
+  version 2, or (at your option) any later version.
+ 
+  GNU Enterprise is distributed in the hope that it will be
+  useful, but WITHOUT ANY WARRANTY; without even the implied
+  warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
+  PURPOSE. See the GNU General Public License for more details.
+ 
+  You should have received a copy of the GNU General Public
+  License along with program; see the file COPYING. If not,
+  write to the Free Software Foundation, Inc., 59 Temple Place
+  - Suite 330, Boston, MA 02111-1307, USA.
+ 
+  $Id: gnue.gsd 6590 2004-11-01 08:43:14Z johannes $
+
+  Run this file through gnue-schema to create and populate the database -->
+
+<schema author="Appserver SchemaSupport" title="Appserver Schema Dump"
+        version="1.0">
+  <tables>
+
+    <!-- ================================================================= -->
+    <!-- Modules                                                           -->
+    <!-- ================================================================= -->
+
+    <table name="gnue_module">
+      <fields>
+        <field name="gnue_comment" type="string" length="70"
+               description="Comment" />
+        <field name="gnue_id" type="string" length="32" nullable="N"
+               description="Object ID" />
+        <field name="gnue_name" type="string" length="35" nullable="N"
+               description="Name" />
+      </fields>
+      <indexes/>
+      <constraints/>
+      <primarykey name="pk_gnue_module">
+        <pkfield name="gnue_id"/>
+      </primarykey>
+    </table>
+
+
+    <!-- ================================================================= -->
+    <!-- Classes                                                           -->
+    <!-- ================================================================= -->
+
+    <table name="gnue_class">
+      <fields>
+        <field name="gnue_comment" type="string" length="70"
+               description="Comment" />
+        <field name="gnue_id" type="string" length="32" nullable="N"
+               description="Object ID" />
+        <field name="gnue_module" type="string" length="32" nullable="N"
+               description="Module that defined this class" />
+        <field name="gnue_name" type="string" length="35" nullable="N"
+               description="Classname without modulename" />
+        <field name="gnue_filter" type="string" length="32"
+               description="Filter-Class of the class" />
+      </fields>
+      <indexes/>
+      <constraints>
+        <constraint name="fk_gnue_class_gnue_module" type="foreignkey">
+          <constraintfield name="gnue_module"/>
+          <constraintref name="gnue_id" table="gnue_module"/>
+        </constraint>
+        <constraint name="fk_gnue_class_gnue_filter" type="foreignkey">
+          <constraintfield name="gnue_filter"/>
+          <constraintref name="gnue_id" table="gnue_class"/>
+        </constraint>
+      </constraints>
+      <primarykey name="pk_gnue_class">
+        <pkfield name="gnue_id"/>
+      </primarykey>
+    </table>
+
+    <!-- ================================================================= -->
+    <!-- Properties                                                        -->
+    <!-- ================================================================= -->
+
+    <table name="gnue_property">
+      <fields>
+        <field name="gnue_class" type="string" length="32" nullable="N"
+               description="Class the property belongs to" />
+        <field name="gnue_comment" type="string" length="70"
+               description="Comment" />
+        <field name="gnue_id" type="string" length="32" nullable="N"
+               description="Object ID" />
+        <field name="gnue_length" type="number" length="6" 
+               description="Lenght of the property" />
+        <field name="gnue_module" type="string" length="32" nullable="N"
+               description="Module that defined this property" />
+        <field name="gnue_name" type="string" length="35" nullable="N"
+               description="Propertyname without modulename" />
+        <field name="gnue_nullable" type="boolean" nullable="N"
+               description="Property can contain NULL values" />
+        <field name="gnue_scale" type="number" length="4" 
+               description="Scale of numeric data" />
+        <field name="gnue_type" type="string" length="35" nullable="N"
+               description="Property type" />
+      </fields>
+      <indexes/>
+      <constraints>
+        <constraint name="fk_gnue_property_gnue_class" type="foreignkey">
+          <constraintfield name="gnue_class"/>
+          <constraintref name="gnue_id" table="gnue_class"/>
+        </constraint>
+        <constraint name="fk_gnue_property_gnue_module" type="foreignkey">
+          <constraintfield name="gnue_module"/>
+          <constraintref name="gnue_id" table="gnue_module"/>
+        </constraint>
+      </constraints>
+      <primarykey name="pk_gnue_property">
+        <pkfield name="gnue_id"/>
+      </primarykey>
+    </table>
+
+    <!-- ================================================================= -->
+    <!-- Procedures                                                        -->
+    <!-- ================================================================= -->
+
+    <table name="gnue_procedure">
+      <fields>
+        <field name="gnue_class" type="string" length="32" nullable="N"
+               description="Class the procedure belongs to" />
+        <field name="gnue_code" type="string" nullable="N"
+               description="Procedure code" />
+        <field name="gnue_comment" type="string" length="70"
+               description="Comment" />
+        <field name="gnue_id" type="string" length="32" nullable="N"
+               description="Object ID" />
+        <field name="gnue_language" type="string" length="10" nullable="N"
+               description="Procedure language" />
+        <field name="gnue_length" type="number" length="6" 
+               description="Length of the procedures result" />
+        <field name="gnue_module" type="string" length="32" nullable="N"
+               description="Module that defined this procedure" />
+        <field name="gnue_name" type="string" length="35" nullable="N"
+               description="Procedurename without modulename" />
+        <field name="gnue_nullable" type="boolean" nullable="N"
+               description="Result of the procedure can contain NULL values" />
+        <field name="gnue_scale" type="number" length="4" 
+               description="Scale of the procedures result" />
+        <field name="gnue_type" type="string" length="35" 
+               description="Type of the procedures result" />
+      </fields>
+      <indexes/>
+      <constraints>
+        <constraint name="fk_gnue_procedure_gnue_class" type="foreignkey">
+          <constraintfield name="gnue_class"/>
+          <constraintref name="gnue_id" table="gnue_class"/>
+        </constraint>
+        <constraint name="fk_gnue_procedure_gnue_module" type="foreignkey">
+          <constraintfield name="gnue_module"/>
+          <constraintref name="gnue_id" table="gnue_module"/>
+        </constraint>
+      </constraints>
+      <primarykey name="pk_gnue_procedure">
+        <pkfield name="gnue_id"/>
+      </primarykey>
+    </table>
+
+    <!-- ================================================================= -->
+    <!-- Parameters of procedures                                          -->
+    <!-- ================================================================= -->
+
+    <table name="gnue_parameter">
+      <fields>
+        <field name="gnue_comment" type="string" length="70"
+               description="Comment" />
+        <field name="gnue_id" type="string" length="32" nullable="N"
+               description="Object ID" />
+        <field name="gnue_length" type="number" length="6" 
+               description="Lenght of the parameter" />
+        <field name="gnue_name" type="string" length="35" nullable="N"
+               description="Name of the parameter" />
+        <field name="gnue_procedure" type="string" length="32" nullable="N"
+               description="Procedure the parameter belongs to" />
+        <field name="gnue_scale" type="number" length="4" 
+               description="Scale of numeric data" />
+        <field name="gnue_type" type="string" length="35" nullable="N"
+               description="Parameter type" />
+      </fields>
+      <indexes/>
+      <constraints>
+        <constraint name="fk_gnue_parameter_gnue_procedure" type="foreignkey">
+          <constraintfield name="gnue_procedure"/>
+          <constraintref name="gnue_id" table="gnue_procedure"/>
+        </constraint>
+      </constraints>
+      <primarykey name="pk_gnue_parameter">
+        <pkfield name="gnue_id"/>
+      </primarykey>
+    </table>
+
+    <!-- ================================================================= -->
+    <!-- Labels                                                            -->
+    <!-- ================================================================= -->
+
+    <table name="gnue_label">
+      <fields>
+        <field name="gnue_id" type="string" length="32" nullable="N"
+               description="Object ID" />
+        <field name="gnue_property" type="string" length="32" 
+               description="The property the label belongs to"/>
+        <field name="gnue_procedure" type="string" length="32" 
+               description="The procedure the label belongs to"/>
+        <field name="gnue_language" type="string" length="5" nullable="N"
+               description="The language (locale) of this item"/>
+        <field name="gnue_page" type="string" length="35"
+               description="Name of the page"/>
+        <field name="gnue_label" type="string" length="35"
+               description="The label of the item"/>
+        <field name="gnue_position" type="number" length="6"
+               description="Position in the tabulator order"/>
+        <field name="gnue_search" type="number" length="6"
+               description="Position in the search order"/>
+        <field name="gnue_info" type="number" length="6" 
+               description="Position in the information field order"/>
+      </fields>
+      <indexes/>
+      <constraints>
+        <constraint name="fk_gnue_label_gnue_property" type="foreignkey">
+          <constraintfield name="gnue_property"/>
+          <constraintref name="gnue_id" table="gnue_property"/>
+        </constraint>
+      </constraints>
+      <primarykey name="pk_gnue_label">
+        <pkfield name="gnue_id"/>
+      </primarykey>
+    </table>
+
+    <!-- ============================================================ -->
+    <!-- Messages                                                     -->
+    <!-- ============================================================ -->
+    <table name="gnue_message">
+      <fields>
+        <field name="gnue_id" type="string" length="32" nullable="N"
+               description="Object ID"/>
+        <field name="gnue_module" type="string" length="32" nullable="N" 
+               description="Module that defined this property"/>
+        <field name="gnue_language" type="string" length="5" nullable="N"
+               description="The language (locale) of this item"/>
+        <field name="gnue_name" type="string" length="35" nullable="N"
+               description="Name of the message"/>
+        <field name="gnue_text" type="string" 
+               description="The text of the message"/>
+      </fields>
+      <indexes/>
+      <constraints>
+        <constraint name="fk_gnue_message_gnue_module" type="foreignkey">
+          <constraintfield name="gnue_module"/>
+          <constraintref name="gnue_id" table="gnue_module"/>
+        </constraint>
+      </constraints>
+      <primarykey name="pk_gnue_message">
+        <pkfield name="gnue_id"/>
+      </primarykey>
+    </table>
+
+  </tables>
+  <data>
+
+    <!-- ================================================================= -->
+    <!-- DATA: Modules                                                     -->
+    <!-- ================================================================= -->
+
+    <tabledata name="gnue_module_dump" tablename="gnue_module">
+      <definition>
+        <column field="gnue_comment" type="string(70)"/>
+        <column field="gnue_id" type="string(32)"/>
+        <column field="gnue_name" type="string(35)"/>
+      </definition>
+      <rows>
+        <row>
+          <value field="gnue_comment">GNU Enterprise System Management</value>
+          <value field="gnue_id">00000000000000000000000000000000</value>
+          <value field="gnue_name">gnue</value>
+        </row>
+      </rows>
+    </tabledata>
+
+    <!-- ================================================================= -->
+    <!-- DATA: Classes                                                     -->
+    <!-- ================================================================= -->
+
+    <tabledata name="gnue_class_dump" tablename="gnue_class">
+      <definition>
+        <column field="gnue_comment" type="string(70)"/>
+        <column field="gnue_id" type="string(32)"/>
+        <column field="gnue_module" type="string(32)"/>
+        <column field="gnue_name" type="string(35)"/>
+      </definition>
+      <rows>
+        <row>
+          <value field="gnue_comment">GNU Enterprise Business Object 
Class</value>
+          <value field="gnue_id">00000000000000000000000000000020</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">class</value>
+        </row>
+        <row>
+          <value field="gnue_comment">GNU Enterprise Business Object 
Module</value>
+          <value field="gnue_id">00000000000000000000000000000010</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">module</value>
+        </row>
+        <row>
+          <value field="gnue_comment">GNU Enterprise Business Object Procedure 
Parameter</value>
+          <value field="gnue_id">00000000000000000000000000000050</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">parameter</value>
+        </row>
+        <row>
+          <value field="gnue_comment">GNU Enterprise Business Object 
Procedure</value>
+          <value field="gnue_id">00000000000000000000000000000040</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">procedure</value>
+        </row>
+        <row>
+          <value field="gnue_comment">GNU Enterprise Business Object 
Property</value>
+          <value field="gnue_id">00000000000000000000000000000030</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">property</value>
+        </row>
+        <row>
+          <value field="gnue_comment">GNU Enterprise Business Object 
Label</value>
+          <value field="gnue_id">00000000000000000000000000000070</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">label</value>
+        </row>
+        <row>
+          <value field="gnue_comment">GNU Enterprise Messages</value>
+          <value field="gnue_id">00000000000000000000000000000080</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">message</value>
+        </row>
+      </rows>
+    </tabledata>
+
+    <!-- ================================================================= -->
+    <!-- DATA: Properties                                                  -->
+    <!-- ================================================================= -->
+
+    <tabledata name="gnue_property_dump" tablename="gnue_property">
+      <definition>
+        <column field="gnue_class" type="string(32)"/>
+        <column field="gnue_comment" type="string(70)"/>
+        <column field="gnue_id" type="string(32)"/>
+        <column field="gnue_length" type="number(6)"/>
+        <column field="gnue_module" type="string(32)"/>
+        <column field="gnue_name" type="string(35)"/>
+        <column field="gnue_nullable" type="boolean"/>
+        <column field="gnue_scale" type="number(4)"/>
+        <column field="gnue_type" type="string(35)"/>
+      </definition>
+      <rows>
+
+        <!-- ============================================================ -->
+        <!-- Properties of gnue_module                                    -->
+        <!-- ============================================================ -->
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000010</value>
+          <value field="gnue_id">00000000000000000000000000000011</value>
+          <value field="gnue_comment">Object ID</value>
+          <value field="gnue_name">id</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">id</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000010</value>
+          <value field="gnue_id">00000000000000000000000000000012</value>
+          <value field="gnue_comment">Name</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">name</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000010</value>
+          <value field="gnue_id">00000000000000000000000000000013</value>
+          <value field="gnue_comment">Comment</value>
+          <value field="gnue_length">70</value>
+          <value field="gnue_name">comment</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+        </row>
+
+        <!-- ============================================================ -->
+        <!-- Properties of gnue_class                                     -->
+        <!-- ============================================================ -->
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000020</value>
+          <value field="gnue_id">00000000000000000000000000000021</value>
+          <value field="gnue_comment">Object ID</value>
+          <value field="gnue_name">id</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">id</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000020</value>
+          <value field="gnue_id">00000000000000000000000000000022</value>
+          <value field="gnue_comment">Module that defined this class</value>
+          <value field="gnue_name">module</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">gnue_module</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000020</value>
+          <value field="gnue_id">00000000000000000000000000000023</value>
+          <value field="gnue_comment">Classname without modulename</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">name</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000020</value>
+          <value field="gnue_id">00000000000000000000000000000024</value>
+          <value field="gnue_comment">Comment</value>
+          <value field="gnue_length">70</value>
+          <value field="gnue_name">comment</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000020</value>
+          <value field="gnue_id">00000000000000000000000000000025</value>
+          <value field="gnue_comment">Filter-Class of the class</value>
+          <value field="gnue_name">filter</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">gnue_class</value>
+        </row>
+
+        <!-- ============================================================ -->
+        <!-- Properties of gnue_property                                  -->
+        <!-- ============================================================ -->
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000031</value>
+          <value field="gnue_comment">Object ID</value>
+          <value field="gnue_name">id</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">id</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000032</value>
+          <value field="gnue_comment">Class the property belongs to</value>
+          <value field="gnue_name">class</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">gnue_class</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000033</value>
+          <value field="gnue_comment">Module that defined this property</value>
+          <value field="gnue_name">module</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">gnue_module</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000034</value>
+          <value field="gnue_comment">Propertyname without modulename</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">name</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000035</value>
+          <value field="gnue_comment">Property type</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">type</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000036</value>
+          <value field="gnue_comment">Lenght of the property</value>
+          <value field="gnue_length">6</value>
+          <value field="gnue_name">length</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000037</value>
+          <value field="gnue_comment">Scale of numeric data</value>
+          <value field="gnue_length">4</value>
+          <value field="gnue_name">scale</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000038</value>
+          <value field="gnue_comment">Comment</value>
+          <value field="gnue_length">70</value>
+          <value field="gnue_name">comment</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000030</value>
+          <value field="gnue_id">00000000000000000000000000000039</value>
+          <value field="gnue_comment">Property can contain NULL values</value>
+          <value field="gnue_name">nullable</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">boolean</value>
+        </row>
+
+        <!-- ============================================================ -->
+        <!-- Properties of gnue_procedure                                 -->
+        <!-- ============================================================ -->
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000041</value>
+          <value field="gnue_comment">Object ID</value>
+          <value field="gnue_name">id</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">id</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000042</value>
+          <value field="gnue_comment">Class the procedure belongs to</value>
+          <value field="gnue_name">class</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">gnue_class</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000043</value>
+          <value field="gnue_comment">Module that defined this 
procedure</value>
+          <value field="gnue_name">module</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">gnue_module</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000044</value>
+          <value field="gnue_comment">Procedurename without modulename</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">name</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000045</value>
+          <value field="gnue_comment">Procedure language</value>
+          <value field="gnue_length">10</value>
+          <value field="gnue_name">language</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000046</value>
+          <value field="gnue_comment">Procedure code</value>
+          <value field="gnue_name">code</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000048</value>
+          <value field="gnue_comment">Comment</value>
+          <value field="gnue_length">70</value>
+          <value field="gnue_name">comment</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">00000000000000000000000000000049</value>
+          <value field="gnue_comment">Type of the procedures result</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">type</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">0000000000000000000000000000004A</value>
+          <value field="gnue_comment">Length of the procedures result</value>
+          <value field="gnue_length">6</value>
+          <value field="gnue_name">length</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">0000000000000000000000000000004B</value>
+          <value field="gnue_comment">Scale of the procedures result</value>
+          <value field="gnue_length">4</value>
+          <value field="gnue_name">scale</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000040</value>
+          <value field="gnue_id">0000000000000000000000000000004C</value>
+          <value field="gnue_comment">Result might contain NULL values</value>
+          <value field="gnue_name">nullable</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">boolean</value>
+        </row>
+
+        <!-- ============================================================ -->
+        <!-- Properties of gnue_prarameter                                -->
+        <!-- ============================================================ -->
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000050</value>
+          <value field="gnue_id">00000000000000000000000000000051</value>
+          <value field="gnue_comment">Object ID</value>
+          <value field="gnue_name">id</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">id</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000050</value>
+          <value field="gnue_id">00000000000000000000000000000052</value>
+          <value field="gnue_comment">Procedure the parameter belongs 
to</value>
+          <value field="gnue_name">procedure</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">gnue_procedure</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000050</value>
+          <value field="gnue_id">00000000000000000000000000000053</value>
+          <value field="gnue_comment">Name of the parameter</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">name</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000050</value>
+          <value field="gnue_id">00000000000000000000000000000054</value>
+          <value field="gnue_comment">Parameter type</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">type</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000050</value>
+          <value field="gnue_id">00000000000000000000000000000055</value>
+          <value field="gnue_comment">Lenght of the parameter</value>
+          <value field="gnue_length">6</value>
+          <value field="gnue_name">length</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000050</value>
+          <value field="gnue_id">00000000000000000000000000000056</value>
+          <value field="gnue_comment">Scale of numeric data</value>
+          <value field="gnue_length">4</value>
+          <value field="gnue_name">scale</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000050</value>
+          <value field="gnue_id">00000000000000000000000000000057</value>
+          <value field="gnue_comment">Comment</value>
+          <value field="gnue_length">70</value>
+          <value field="gnue_name">comment</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+        </row>
+
+        <!-- ============================================================ -->
+        <!-- Properties of gnue_label                                     -->
+        <!-- ============================================================ -->
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000071</value>
+          <value field="gnue_comment">Object ID</value>
+          <value field="gnue_name">id</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">id</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000072</value>
+          <value field="gnue_comment">The property the label belongs to</value>
+          <value field="gnue_name">property</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">gnue_property</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000073</value>
+          <value field="gnue_comment">The procedure the label belongs 
to</value>
+          <value field="gnue_name">procedure</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">gnue_procedure</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000074</value>
+          <value field="gnue_comment">The language (locale) of this 
item</value>
+          <value field="gnue_name">language</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+          <value field="gnue_length">5</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000075</value>
+          <value field="gnue_comment">The tab order position of the 
item</value>
+          <value field="gnue_name">position</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+          <value field="gnue_length">6</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000076</value>
+          <value field="gnue_comment">Name of the page</value>
+          <value field="gnue_name">page</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+          <value field="gnue_length">35</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000077</value>
+          <value field="gnue_comment">Label of the property</value>
+          <value field="gnue_name">label</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+          <value field="gnue_length">35</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000078</value>
+          <value field="gnue_comment">Search index of the label</value>
+          <value field="gnue_name">search</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+          <value field="gnue_length">6</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000070</value>
+          <value field="gnue_id">00000000000000000000000000000079</value>
+          <value field="gnue_comment">Info index of the label</value>
+          <value field="gnue_name">info</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">number</value>
+          <value field="gnue_length">6</value>
+        </row>
+
+        <!-- ============================================================ -->
+        <!-- Properties of gnue_message                                   -->
+        <!-- ============================================================ -->
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000080</value>
+          <value field="gnue_id">00000000000000000000000000000081</value>
+          <value field="gnue_comment">Object ID</value>
+          <value field="gnue_name">id</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">id</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000080</value>
+          <value field="gnue_id">00000000000000000000000000000082</value>
+          <value field="gnue_comment">Module that defined this message</value>
+          <value field="gnue_name">module</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">gnue_module</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000080</value>
+          <value field="gnue_id">00000000000000000000000000000083</value>
+          <value field="gnue_comment">The language of the message</value>
+          <value field="gnue_name">language</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+          <value field="gnue_length">5</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000080</value>
+          <value field="gnue_id">00000000000000000000000000000084</value>
+          <value field="gnue_comment">Name of the message</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_name">name</value>
+          <value field="gnue_nullable">FALSE</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_class">00000000000000000000000000000080</value>
+          <value field="gnue_id">00000000000000000000000000000085</value>
+          <value field="gnue_comment">Text of the message</value>
+          <value field="gnue_name">text</value>
+          <value field="gnue_type">string</value>
+          <value field="gnue_nullable">TRUE</value>
+        </row>
+
+      </rows>
+    </tabledata>
+
+    <!-- ============================================================ -->
+    <!-- DATA: Procedures                                             -->
+    <!-- ============================================================ -->
+    <tabledata name="gnue_procedure_dump" tablename="gnue_procedure">
+      <definition>
+        <column field="gnue_class" type="string(32)"/>
+        <column field="gnue_code" type="string"/>
+        <column field="gnue_comment" type="string(70)"/>
+        <column field="gnue_id" type="string(32)"/>
+        <column field="gnue_language" type="string(10)"/>
+        <column field="gnue_length" type="number(6)"/>
+        <column field="gnue_module" type="string(32)"/>
+        <column field="gnue_name" type="string(35)"/>
+        <column field="gnue_nullable" type="boolean"/>
+        <column field="gnue_scale" type="number(4)"/>
+        <column field="gnue_type" type="string(35)"/>
+      </definition>
+      <rows>
+        <row>
+          <value field="gnue_class">00000000000000000000000000000020</value>
+          <value field="gnue_comment">Generate GNUe Form Definition</value>
+          <value field="gnue_id">00000000000000000000000000007001</value>
+          <value field="gnue_language">python</value>
+          <value field="gnue_module">00000000000000000000000000000000</value>
+          <value field="gnue_name">form</value>
+          <value field="gnue_nullable">TRUE</value>
+          <value field="gnue_type">string</value>
+          <value field="gnue_code">
+            from gnue.appserver.generator.form import FormGenerator
+            formGen = FormGenerator (session, self, language, connection,
+                                     formwidth, formheight)
+            return formGen.run ()
+          </value>
+        </row>
+      </rows>
+    </tabledata>
+
+    <!-- ================================================================= -->
+    <!-- DATA: Parameters                                                  -->
+    <!-- ================================================================= -->
+
+    <tabledata name="gnue_parameter_dump" tablename="gnue_parameter">
+      <definition>
+        <column field="gnue_comment" type="string(70)"/>
+        <column field="gnue_id" type="string(32)"/>
+        <column field="gnue_length" type="number(6)"/>
+        <column field="gnue_name" type="string(35)"/>
+        <column field="gnue_procedure" type="string(32)"/>
+        <column field="gnue_scale" type="number(4)"/>
+        <column field="gnue_type" type="string(35)"/>
+      </definition>
+      <rows>
+        <row>
+          <value 
field="gnue_procedure">00000000000000000000000000007001</value>
+          <value field="gnue_id">00000000000000000000000000770001</value>
+          <value field="gnue_name">language</value>
+          <value field="gnue_comment">Langage (locale) for labels</value>
+          <value field="gnue_length">5</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value 
field="gnue_procedure">00000000000000000000000000007001</value>
+          <value field="gnue_id">00000000000000000000000000770002</value>
+          <value field="gnue_name">connection</value>
+          <value field="gnue_comment">Name of the connection to use</value>
+          <value field="gnue_length">35</value>
+          <value field="gnue_type">string</value>
+        </row>
+        <row>
+          <value 
field="gnue_procedure">00000000000000000000000000007001</value>
+          <value field="gnue_id">00000000000000000000000000770003</value>
+          <value field="gnue_name">formwidth</value>
+          <value field="gnue_comment">Maximum width of the form</value>
+          <value field="gnue_type">number</value>
+          <value field="gnue_length">4</value>
+        </row>
+        <row>
+          <value 
field="gnue_procedure">00000000000000000000000000007001</value>
+          <value field="gnue_id">00000000000000000000000000770004</value>
+          <value field="gnue_name">formheight</value>
+          <value field="gnue_comment">Maximum height of the form</value>
+          <value field="gnue_type">number</value>
+          <value field="gnue_length">4</value>
+        </row>
+      </rows>
+    </tabledata>
+  </data>
+</schema>

Added: gnue-cddb/scripts/setup-db.sh
===================================================================
--- gnue-cddb/scripts/setup-db.sh       2004-12-02 16:36:55 UTC (rev 152)
+++ gnue-cddb/scripts/setup-db.sh       2004-12-03 08:35:23 UTC (rev 153)
@@ -0,0 +1,9 @@
+#!/bin/sh
+
+gsscvs --connection=gnue-cddb --createdb gnue.gsd
+
+gcdcvs --connection=gnue-cddb ../schema/cddb.gcd ../schema/filedb.gcd
+gldcvs --connection=gnue-cddb ../schema/cddb-C.gld
+
+#standard data
+gsscvs --connection=gnue-cddb ../schema/gen.gsd


Property changes on: gnue-cddb/scripts/setup-db.sh
___________________________________________________________________
Name: svn:executable
   + *

Added: gnue-cddb/scripts/start-appserver
===================================================================
--- gnue-cddb/scripts/start-appserver   2004-12-02 16:36:55 UTC (rev 152)
+++ gnue-cddb/scripts/start-appserver   2004-12-03 08:35:23 UTC (rev 153)
@@ -0,0 +1,3 @@
+#!/bin/sh
+
+gacvs --database gnue-cddb -Z


Property changes on: gnue-cddb/scripts/start-appserver
___________________________________________________________________
Name: svn:executable
   + *