[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
r5746 - trunk/gnue-appserver/samples
|
From: |
johannes |
|
Subject: |
r5746 - trunk/gnue-appserver/samples |
|
Date: |
Tue, 20 Apr 2004 07:12:09 -0500 (CDT) |
Author: johannes
Date: 2004-04-20 07:12:08 -0500 (Tue, 20 Apr 2004)
New Revision: 5746
Modified:
trunk/gnue-appserver/samples/base.gsd
trunk/gnue-appserver/samples/sample.gsd
Log:
Updated base- and sample.gsd to reflect recent changes
Modified: trunk/gnue-appserver/samples/base.gsd
===================================================================
--- trunk/gnue-appserver/samples/base.gsd 2004-04-20 09:35:35 UTC (rev
5745)
+++ trunk/gnue-appserver/samples/base.gsd 2004-04-20 12:12:08 UTC (rev
5746)
@@ -1,65 +1,71 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!-- Schema definition created by GNUe Appserver's Schema Support. -->
-<!-- run this file through gnue-schema to create SQL scripts -->
+<!-- Schema definition created by GNUe Appserver's Schema Support.
+ Run this file through gnue-schema to create SQL scripts -->
<schema author="Appserver SchemaSupport" title="Appserver Schema Dump"
version="1.0">
<tables>
- <table name="gnue_module">
+ <table name="gnue_class">
<fields>
<field name="gnue_comment" description="Comment" length="70"
type="string"/>
<field name="gnue_id" description="Object ID" length="32" nullable="N"
type="string"/>
- <field name="gnue_name" description="Name" length="35" nullable="N"
- type="string"/>
+ <field name="gnue_module" description="Module that defined this class"
+ length="32" nullable="N" type="string"/>
+ <field name="gnue_name" description="Classname without modulename"
+ length="35" nullable="N" type="string"/>
</fields>
- <constraints/>
<indexes/>
- <primarykey name="gnue_id_pk_gnue_module">
+ <constraints>
+ <constraint name="gnue_class_gnue_module_fk" type="foreignkey">
+ <constraintfield name="gnue_module"/>
+ <constraintref name="gnue_id" table="gnue_module"/>
+ </constraint>
+ </constraints>
+ <primarykey name="gnue_id_pk_gnue_class">
<pkfield name="gnue_id"/>
</primarykey>
</table>
- <table name="gnue_class">
+ <table name="gnue_module">
<fields>
<field name="gnue_comment" description="Comment" length="70"
type="string"/>
<field name="gnue_id" description="Object ID" length="32" nullable="N"
type="string"/>
- <field name="gnue_module" description="Module that defined this class"
- length="32" nullable="N" type="string"/>
- <field name="gnue_name" description="Classname without modulename"
- length="35" nullable="N" type="string"/>
+ <field name="gnue_name" description="Name" length="35" nullable="N"
+ type="string"/>
</fields>
+ <indexes/>
<constraints/>
- <indexes/>
- <primarykey name="gnue_id_pk_gnue_class">
+ <primarykey name="gnue_id_pk_gnue_module">
<pkfield name="gnue_id"/>
</primarykey>
</table>
- <table name="gnue_property">
+ <table name="gnue_parameter">
<fields>
- <field name="gnue_class" description="Class the property belongs to"
- length="32" nullable="N" type="string"/>
<field name="gnue_comment" description="Comment" length="70"
type="string"/>
<field name="gnue_id" description="Object ID" length="32" nullable="N"
type="string"/>
- <field name="gnue_length" description="Lenght of the property"
+ <field name="gnue_length" description="Lenght of the parameter"
length="6" type="number"/>
- <field name="gnue_module"
- description="Module that defined this property" length="32"
nullable="N" type="string"/>
- <field name="gnue_name" description="Propertyname without modulename"
+ <field name="gnue_name" description="Name of the parameter"
length="35" nullable="N" type="string"/>
- <field name="gnue_nullable"
- description="Property can contain NULL values" nullable="N"
type="boolean"/>
+ <field name="gnue_procedure"
+ description="Procedure the parameter belongs to" length="32"
nullable="N" type="string"/>
<field name="gnue_scale" description="Scale of numeric data"
length="4" type="number"/>
- <field name="gnue_type" description="Property type" length="35"
+ <field name="gnue_type" description="Parameter type" length="35"
nullable="N" type="string"/>
</fields>
- <constraints/>
<indexes/>
- <primarykey name="gnue_id_pk_gnue_property">
+ <constraints>
+ <constraint name="gnue_parameter_gnue_procedure_fk" type="foreignkey">
+ <constraintfield name="gnue_procedure"/>
+ <constraintref name="gnue_id" table="gnue_procedure"/>
+ </constraint>
+ </constraints>
+ <primarykey name="gnue_id_pk_gnue_parameter">
<pkfield name="gnue_id"/>
</primarykey>
</table>
@@ -77,37 +83,65 @@
type="string"/>
<field name="gnue_language" description="Procedure language"
length="10" nullable="N" type="string"/>
+ <field name="gnue_length"
+ description="Length of the procedures result" length="6"
type="number"/>
<field name="gnue_module"
description="Module that defined this procedure" length="32"
nullable="N" type="string"/>
<field name="gnue_name" description="Procedurename without modulename"
length="35" nullable="N" type="string"/>
+ <field name="gnue_scale" description="Scale of the procedures result"
+ length="4" type="number"/>
+ <field name="gnue_type" description="Type of the procedures result"
+ length="35" type="string"/>
</fields>
- <constraints/>
<indexes/>
+ <constraints>
+ <constraint name="gnue_procedure_gnue_class_fk" type="foreignkey">
+ <constraintfield name="gnue_class"/>
+ <constraintref name="gnue_id" table="gnue_class"/>
+ </constraint>
+ <constraint name="gnue_procedure_gnue_module_fk" type="foreignkey">
+ <constraintfield name="gnue_module"/>
+ <constraintref name="gnue_id" table="gnue_module"/>
+ </constraint>
+ </constraints>
<primarykey name="gnue_id_pk_gnue_procedure">
<pkfield name="gnue_id"/>
</primarykey>
</table>
- <table name="gnue_parameter">
+ <table name="gnue_property">
<fields>
+ <field name="gnue_class" description="Class the property belongs to"
+ length="32" nullable="N" type="string"/>
<field name="gnue_comment" description="Comment" length="70"
type="string"/>
<field name="gnue_id" description="Object ID" length="32" nullable="N"
type="string"/>
- <field name="gnue_length" description="Lenght of the parameter"
+ <field name="gnue_length" description="Lenght of the property"
length="6" type="number"/>
- <field name="gnue_name" description="Name of the parameter"
+ <field name="gnue_module"
+ description="Module that defined this property" length="32"
nullable="N" type="string"/>
+ <field name="gnue_name" description="Propertyname without modulename"
length="35" nullable="N" type="string"/>
- <field name="gnue_procedure"
- description="Procedure the parameter belongs to" length="32"
nullable="N" type="string"/>
+ <field name="gnue_nullable"
+ description="Property can contain NULL values" nullable="N"
type="boolean"/>
<field name="gnue_scale" description="Scale of numeric data"
length="4" type="number"/>
- <field name="gnue_type" description="Parameter type" length="35"
+ <field name="gnue_type" description="Property type" length="35"
nullable="N" type="string"/>
</fields>
- <constraints/>
<indexes/>
- <primarykey name="gnue_id_pk_gnue_parameter">
+ <constraints>
+ <constraint name="gnue_property_gnue_class_fk" type="foreignkey">
+ <constraintfield name="gnue_class"/>
+ <constraintref name="gnue_id" table="gnue_class"/>
+ </constraint>
+ <constraint name="gnue_property_gnue_module_fk" type="foreignkey">
+ <constraintfield name="gnue_module"/>
+ <constraintref name="gnue_id" table="gnue_module"/>
+ </constraint>
+ </constraints>
+ <primarykey name="gnue_id_pk_gnue_property">
<pkfield name="gnue_id"/>
</primarykey>
</table>
@@ -121,9 +155,9 @@
</definition>
<rows>
<row>
+ <value field="gnue_comment">GNU Enterprise System Management</value>
<value field="gnue_id">00000000000000000000000000000000</value>
<value field="gnue_name">gnue</value>
- <value field="gnue_comment">GNU Enterprise System Management</value>
</row>
</rows>
</tabledata>
@@ -136,34 +170,34 @@
</definition>
<rows>
<row>
- <value field="gnue_id">00000000000000000000000000000010</value>
+ <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">module</value>
- <value field="gnue_comment">GNU Enterprise Business Object
Module</value>
+ <value field="gnue_name">class</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000020</value>
+ <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">class</value>
- <value field="gnue_comment">GNU Enterprise Business Object
Class</value>
+ <value field="gnue_name">module</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000030</value>
+ <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">property</value>
- <value field="gnue_comment">GNU Enterprise Business Object
Property</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>
- <value field="gnue_comment">GNU Enterprise Business Object
Procedure</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000050</value>
+ <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">parameter</value>
- <value field="gnue_comment">GNU Enterprise Business Object Procedure
Parameter</value>
+ <value field="gnue_name">property</value>
</row>
</rows>
</tabledata>
@@ -181,315 +215,332 @@
</definition>
<rows>
<row>
- <value field="gnue_id">00000000000000000000000000000013</value>
+ <value field="gnue_class">00000000000000000000000000000020</value>
+ <value field="gnue_comment">Comment</value>
+ <value field="gnue_id">00000000000000000000000000000024</value>
+ <value field="gnue_length">70</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000010</value>
<value field="gnue_name">comment</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">70</value>
- <value field="gnue_comment">Comment</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000011</value>
+ <value field="gnue_class">00000000000000000000000000000020</value>
+ <value field="gnue_comment">Object ID</value>
+ <value field="gnue_id">00000000000000000000000000000021</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000010</value>
<value field="gnue_name">id</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">id</value>
- <value field="gnue_comment">Object ID</value>
+ </row>
+ <row>
+ <value field="gnue_class">00000000000000000000000000000020</value>
+ <value field="gnue_comment">Module that defined this class</value>
+ <value field="gnue_id">00000000000000000000000000000022</value>
+ <value field="gnue_module">00000000000000000000000000000000</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_id">00000000000000000000000000000012</value>
+ <value field="gnue_class">00000000000000000000000000000020</value>
+ <value field="gnue_comment">Classname without modulename</value>
+ <value field="gnue_id">00000000000000000000000000000023</value>
+ <value field="gnue_length">35</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000010</value>
<value field="gnue_name">name</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">35</value>
- <value field="gnue_comment">Name</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000024</value>
+ <value field="gnue_class">00000000000000000000000000000010</value>
+ <value field="gnue_comment">Comment</value>
+ <value field="gnue_id">00000000000000000000000000000013</value>
+ <value field="gnue_length">70</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000020</value>
<value field="gnue_name">comment</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">70</value>
- <value field="gnue_comment">Comment</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000021</value>
+ <value field="gnue_class">00000000000000000000000000000010</value>
+ <value field="gnue_comment">Object ID</value>
+ <value field="gnue_id">00000000000000000000000000000011</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000020</value>
<value field="gnue_name">id</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">id</value>
- <value field="gnue_comment">Object ID</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000022</value>
+ <value field="gnue_class">00000000000000000000000000000010</value>
+ <value field="gnue_comment">Name</value>
+ <value field="gnue_id">00000000000000000000000000000012</value>
+ <value field="gnue_length">35</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000020</value>
- <value field="gnue_name">module</value>
- <value field="gnue_type">gnue_module</value>
- <value field="gnue_comment">Module that defined this class</value>
+ <value field="gnue_name">name</value>
<value field="gnue_nullable">FALSE</value>
- </row>
- <row>
- <value field="gnue_id">00000000000000000000000000000023</value>
- <value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000020</value>
- <value field="gnue_name">name</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">35</value>
- <value field="gnue_comment">Classname without modulename</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000032</value>
+ <value field="gnue_class">00000000000000000000000000000050</value>
+ <value field="gnue_comment">Comment</value>
+ <value field="gnue_id">00000000000000000000000000000057</value>
+ <value field="gnue_length">70</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
- <value field="gnue_name">class</value>
- <value field="gnue_type">gnue_class</value>
- <value field="gnue_comment">Class the property belongs to</value>
- <value field="gnue_nullable">FALSE</value>
- </row>
- <row>
- <value field="gnue_id">00000000000000000000000000000038</value>
- <value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
<value field="gnue_name">comment</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">70</value>
- <value field="gnue_comment">Comment</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000031</value>
+ <value field="gnue_class">00000000000000000000000000000050</value>
+ <value field="gnue_comment">Object ID</value>
+ <value field="gnue_id">00000000000000000000000000000051</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
<value field="gnue_name">id</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">id</value>
- <value field="gnue_comment">Object ID</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000036</value>
+ <value field="gnue_class">00000000000000000000000000000050</value>
+ <value field="gnue_comment">Lenght of the parameter</value>
+ <value field="gnue_id">00000000000000000000000000000055</value>
+ <value field="gnue_length">6</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
<value field="gnue_name">length</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">number</value>
- <value field="gnue_length">6</value>
- <value field="gnue_comment">Lenght of the property</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000033</value>
+ <value field="gnue_class">00000000000000000000000000000050</value>
+ <value field="gnue_comment">Name of the parameter</value>
+ <value field="gnue_id">00000000000000000000000000000053</value>
+ <value field="gnue_length">35</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
- <value field="gnue_name">module</value>
- <value field="gnue_type">gnue_module</value>
- <value field="gnue_comment">Module that defined this property</value>
+ <value field="gnue_name">name</value>
<value field="gnue_nullable">FALSE</value>
- </row>
- <row>
- <value field="gnue_id">00000000000000000000000000000034</value>
- <value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
- <value field="gnue_name">name</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">35</value>
- <value field="gnue_comment">Propertyname without modulename</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000039</value>
+ <value field="gnue_class">00000000000000000000000000000050</value>
+ <value field="gnue_comment">Procedure the parameter belongs
to</value>
+ <value field="gnue_id">00000000000000000000000000000052</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
- <value field="gnue_name">nullable</value>
- <value field="gnue_type">boolean</value>
- <value field="gnue_comment">Property can contain NULL values</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_id">00000000000000000000000000000037</value>
+ <value field="gnue_class">00000000000000000000000000000050</value>
+ <value field="gnue_comment">Scale of numeric data</value>
+ <value field="gnue_id">00000000000000000000000000000056</value>
+ <value field="gnue_length">4</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
<value field="gnue_name">scale</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">number</value>
- <value field="gnue_length">4</value>
- <value field="gnue_comment">Scale of numeric data</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000035</value>
+ <value field="gnue_class">00000000000000000000000000000050</value>
+ <value field="gnue_comment">Parameter type</value>
+ <value field="gnue_id">00000000000000000000000000000054</value>
+ <value field="gnue_length">35</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000030</value>
<value field="gnue_name">type</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">35</value>
- <value field="gnue_comment">Property type</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Class the procedure belongs to</value>
<value field="gnue_id">00000000000000000000000000000042</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">class</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">gnue_class</value>
- <value field="gnue_comment">Class the procedure belongs to</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Procedure code</value>
<value field="gnue_id">00000000000000000000000000000046</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">code</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">string</value>
- <value field="gnue_comment">Procedure code</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Comment</value>
<value field="gnue_id">00000000000000000000000000000048</value>
+ <value field="gnue_length">70</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">comment</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">70</value>
- <value field="gnue_comment">Comment</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Compiled procedure code</value>
<value field="gnue_id">00000000000000000000000000000047</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">compiledcode</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">string</value>
- <value field="gnue_comment">Compiled procedure code</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Object ID</value>
<value field="gnue_id">00000000000000000000000000000041</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">id</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">id</value>
- <value field="gnue_comment">Object ID</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Procedure language</value>
<value field="gnue_id">00000000000000000000000000000045</value>
+ <value field="gnue_length">10</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">language</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">10</value>
- <value field="gnue_comment">Procedure language</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Length of the procedures result</value>
+ <value field="gnue_id">0000000000000000000000000000004A</value>
+ <value field="gnue_length">6</value>
+ <value field="gnue_module">00000000000000000000000000000000</value>
+ <value field="gnue_name">length</value>
+ <value field="gnue_nullable">TRUE</value>
+ <value field="gnue_type">number</value>
+ </row>
+ <row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Module that defined this
procedure</value>
<value field="gnue_id">00000000000000000000000000000043</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">module</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">gnue_module</value>
- <value field="gnue_comment">Module that defined this
procedure</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Procedurename without modulename</value>
<value field="gnue_id">00000000000000000000000000000044</value>
+ <value field="gnue_length">35</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000040</value>
<value field="gnue_name">name</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">string</value>
+ </row>
+ <row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Scale of the procedures result</value>
+ <value field="gnue_id">0000000000000000000000000000004B</value>
+ <value field="gnue_length">4</value>
+ <value field="gnue_module">00000000000000000000000000000000</value>
+ <value field="gnue_name">scale</value>
+ <value field="gnue_nullable">TRUE</value>
+ <value field="gnue_type">number</value>
+ </row>
+ <row>
+ <value field="gnue_class">00000000000000000000000000000040</value>
+ <value field="gnue_comment">Type of the procedures result</value>
+ <value field="gnue_id">00000000000000000000000000000049</value>
<value field="gnue_length">35</value>
- <value field="gnue_comment">Procedurename without modulename</value>
+ <value field="gnue_module">00000000000000000000000000000000</value>
+ <value field="gnue_name">type</value>
+ <value field="gnue_nullable">TRUE</value>
+ <value field="gnue_type">string</value>
+ </row>
+ <row>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Class the property belongs to</value>
+ <value field="gnue_id">00000000000000000000000000000032</value>
+ <value field="gnue_module">00000000000000000000000000000000</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_id">00000000000000000000000000000057</value>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Comment</value>
+ <value field="gnue_id">00000000000000000000000000000038</value>
+ <value field="gnue_length">70</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000050</value>
<value field="gnue_name">comment</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">70</value>
- <value field="gnue_comment">Comment</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000051</value>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Object ID</value>
+ <value field="gnue_id">00000000000000000000000000000031</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000050</value>
<value field="gnue_name">id</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">id</value>
- <value field="gnue_comment">Object ID</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000055</value>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Lenght of the property</value>
+ <value field="gnue_id">00000000000000000000000000000036</value>
+ <value field="gnue_length">6</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000050</value>
<value field="gnue_name">length</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">number</value>
- <value field="gnue_length">6</value>
- <value field="gnue_comment">Lenght of the parameter</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000053</value>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Module that defined this property</value>
+ <value field="gnue_id">00000000000000000000000000000033</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000050</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_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Propertyname without modulename</value>
+ <value field="gnue_id">00000000000000000000000000000034</value>
+ <value field="gnue_length">35</value>
+ <value field="gnue_module">00000000000000000000000000000000</value>
<value field="gnue_name">name</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">35</value>
- <value field="gnue_comment">Name of the parameter</value>
- <value field="gnue_nullable">FALSE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000052</value>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Property can contain NULL values</value>
+ <value field="gnue_id">00000000000000000000000000000039</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000050</value>
- <value field="gnue_name">procedure</value>
- <value field="gnue_type">gnue_procedure</value>
- <value field="gnue_comment">Procedure the parameter belongs
to</value>
+ <value field="gnue_name">nullable</value>
<value field="gnue_nullable">FALSE</value>
+ <value field="gnue_type">boolean</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000056</value>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Scale of numeric data</value>
+ <value field="gnue_id">00000000000000000000000000000037</value>
+ <value field="gnue_length">4</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000050</value>
<value field="gnue_name">scale</value>
+ <value field="gnue_nullable">TRUE</value>
<value field="gnue_type">number</value>
- <value field="gnue_length">4</value>
- <value field="gnue_comment">Scale of numeric data</value>
- <value field="gnue_nullable">TRUE</value>
</row>
<row>
- <value field="gnue_id">00000000000000000000000000000054</value>
+ <value field="gnue_class">00000000000000000000000000000030</value>
+ <value field="gnue_comment">Property type</value>
+ <value field="gnue_id">00000000000000000000000000000035</value>
+ <value field="gnue_length">35</value>
<value field="gnue_module">00000000000000000000000000000000</value>
- <value field="gnue_class">00000000000000000000000000000050</value>
<value field="gnue_name">type</value>
+ <value field="gnue_nullable">FALSE</value>
<value field="gnue_type">string</value>
- <value field="gnue_length">35</value>
- <value field="gnue_comment">Parameter type</value>
- <value field="gnue_nullable">FALSE</value>
</row>
</rows>
</tabledata>
- <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_compiledcode" type="string"/>
- <column field="gnue_id" type="string(32)"/>
- <column field="gnue_language" type="string(10)"/>
- <column field="gnue_module" type="string(32)"/>
- <column field="gnue_name" type="string(35)"/>
- </definition>
- <rows/>
- </tabledata>
</data>
</schema>
Modified: trunk/gnue-appserver/samples/sample.gsd
===================================================================
--- trunk/gnue-appserver/samples/sample.gsd 2004-04-20 09:35:35 UTC (rev
5745)
+++ trunk/gnue-appserver/samples/sample.gsd 2004-04-20 12:12:08 UTC (rev
5746)
@@ -19,8 +19,8 @@
<field name="gnue_id" description="Object ID" length="32" nullable="N"
type="string"/>
</fields>
+ <indexes/>
<constraints/>
- <indexes/>
<primarykey name="gnue_id_pk_address_country">
<pkfield name="gnue_id"/>
</primarykey>
@@ -33,8 +33,7 @@
<field name="address_city" description="City where the person lives"
length="35" type="string"/>
<field name="address_country"
- description="Country where the person lives" length="32"
- type="string"/>
+ description="Country where the person lives" length="32"
type="string"/>
<field name="address_human"
description="Whether the person is human or not"
type="boolean"/>
<field name="address_lastmeeting"
@@ -52,8 +51,13 @@
<field name="gnue_id" description="Object ID" length="32" nullable="N"
type="string"/>
</fields>
- <constraints/>
<indexes/>
+ <constraints>
+ <constraint name="address_person_address_country_fk" type="foreignkey">
+ <constraintfield name="address_country"/>
+ <constraintref name="gnue_id" table="address_country"/>
+ </constraint>
+ </constraints>
<primarykey name="gnue_id_pk_address_person">
<pkfield name="gnue_id"/>
</primarykey>
@@ -66,14 +70,10 @@
tablename="gnue_class"/>
<import-tabledata library="base.gsd" name="gnue_property_dump"
tablename="gnue_property"/>
- <import-tabledata library="base.gsd" name="gnue_procedure_dump"
- tablename="gnue_procedure"/>
<import-tabledata library="auth.gsd" name="gnue_class_dump"
tablename="gnue_class"/>
<import-tabledata library="auth.gsd" name="gnue_property_dump"
tablename="gnue_property"/>
- <import-tabledata library="auth.gsd" name="gnue_procedure_dump"
- tablename="gnue_procedure"/>
<tabledata name="gnue_module_dump" tablename="gnue_module">
<definition>
<column field="gnue_comment" type="string(70)"/>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- r5746 - trunk/gnue-appserver/samples,
johannes <=