You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by tf...@apache.org on 2013/08/15 04:23:37 UTC
svn commit: r1514132 [2/2] - in
/db/torque/torque4/trunk/torque-templates/src/test:
java/org/apache/torque/templates/ resources/org/apache/torque/templates/
Added: db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-create.sql
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-create.sql?rev=1514132&view=auto
==============================================================================
--- db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-create.sql (added)
+++ db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-create.sql Thu Aug 15 02:23:36 2013
@@ -0,0 +1,19 @@
+## Licensed to the Apache Software Foundation (ASF) under one
+## or more contributor license agreements. See the NOTICE file
+## distributed with this work for additional information
+## regarding copyright ownership. The ASF licenses this file
+## to you 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.
+##
+drop database if exists bookstore;
+create database bookstore;
Added: db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-idtable-init.sql
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-idtable-init.sql?rev=1514132&view=auto
==============================================================================
--- db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-idtable-init.sql (added)
+++ db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema-idtable-init.sql Thu Aug 15 02:23:36 2013
@@ -0,0 +1,31 @@
+## Licensed to the Apache Software Foundation (ASF) under one
+## or more contributor license agreements. See the NOTICE file
+## distributed with this work for additional information
+## regarding copyright ownership. The ASF licenses this file
+## to you 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.
+##
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (103, 'a', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (104, 'b', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (105, 'r_ab', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (106, 'c', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (107, 'd', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (108, 'nopk', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (109, 'MULTIPK_SELF_REFTABLE', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (110, 'ifc_table', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (111, 'ifc_table2', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (112, 'INHERITANCE_TEST', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (113, 'ext_schema', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (114, 'extext_schema', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (115, 'qualified_name', 1000, 10);
+
Added: db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.html
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.html?rev=1514132&view=auto
==============================================================================
--- db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.html (added)
+++ db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.html Thu Aug 15 02:23:36 2013
@@ -0,0 +1,841 @@
+## Licensed to the Apache Software Foundation (ASF) under one
+## or more contributor license agreements. See the NOTICE file
+## distributed with this work for additional information
+## regarding copyright ownership. The ASF licenses this file
+## to you 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.
+##
+<html>
+<head>
+ <title>bookstore</title>
+ <link rel="stylesheet" type="text/css" href="datamodel.css">
+</head>
+
+<body class="normalFont">
+ <table class="summarytable">
+ <tr class="summaryhead">
+ <th class="summaryheadbackground summaryborder summaryheadtablename">Table Name</th>
+ <th class="summaryheadbackground summaryborder summaryheadjavaname">OM Class</th>
+ <th class="summaryheadbackground summaryborder summaryheaddescription">Description</th>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#a" class="link summarytablenamelink">a</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">A</td>
+ <td class="summarybackground summaryborder summarydescription"> A table</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#b" class="link summarytablenamelink">b</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">B</td>
+ <td class="summarybackground summaryborder summarydescription"> B table</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#r_ab" class="link summarytablenamelink">r_ab</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">RAb</td>
+ <td class="summarybackground summaryborder summarydescription"> r_ab table</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#c" class="link summarytablenamelink">c</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">C</td>
+ <td class="summarybackground summaryborder summarydescription"> c table contains fk to ar_ab, a and b</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#d" class="link summarytablenamelink">d</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">D</td>
+ <td class="summarybackground summaryborder summarydescription"> c table contains fk to ar_ab, a and b</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#nopk" class="link summarytablenamelink">nopk</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">Nopk</td>
+ <td class="summarybackground summaryborder summarydescription"> this table has no pk</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#MULTIPK_SELF_REFTABLE" class="link summarytablenamelink">MULTIPK_SELF_REFTABLE</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">MultipkSelfReftable</td>
+ <td class="summarybackground summaryborder summarydescription"> this table has no pk</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#ifc_table" class="link summarytablenamelink">ifc_table</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">IfcTable</td>
+ <td class="summarybackground summaryborder summarydescription"> this table implements an interface</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#ifc_table2" class="link summarytablenamelink">ifc_table2</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">IfcTable2</td>
+ <td class="summarybackground summaryborder summarydescription"> this table implements a local interface</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#INHERITANCE_TEST" class="link summarytablenamelink">INHERITANCE_TEST</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">InheritanceTest</td>
+ <td class="summarybackground summaryborder summarydescription"> Table to test inheritance</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#ext_schema" class="link summarytablenamelink">ext_schema</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">ExtSchema</td>
+ <td class="summarybackground summaryborder summarydescription"> Table to test inheritance</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#extext_schema" class="link summarytablenamelink">extext_schema</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">ExtextSchema</td>
+ <td class="summarybackground summaryborder summarydescription"> Table to test inheritance</td>
+ </tr>
+ <tr class=summaryrow">
+ <td class="summarybackground summaryborder summarytablename"><a href="#torque.qualified_name" class="link summarytablenamelink">torque.qualified_name</a></td>
+ <td class="summarybackground summaryborder summaryjavaname">QualifiedName</td>
+ <td class="summarybackground summaryborder summarydescription"> Table to test inheritance</td>
+ </tr>
+ </table>
+
+ <a name="a"/>
+<h2>a</h2>
+A table
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="aa_id">a_id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">AId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="aname">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 50 </td>
+ <td class="detailbackground detailborder detaildefault"> a_name</td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="b"/>
+<h2>b</h2>
+B table
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="bb_id">b_id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">BId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="bname">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 50 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="r_ab"/>
+<h2>r_ab</h2>
+r_ab table
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey foreignkey notnull" id="r_aba_id">a_id
+ <a href="#a" title="Foreign key to a.a_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">AId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey foreignkey notnull" id="r_abb_id">b_id
+ <a href="#b" title="Foreign key to b.b_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">BId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="r_abname">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 50 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="c"/>
+<h2>c</h2>
+c table contains fk to ar_ab, a and b
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="cc_id">c_id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">CId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname foreignkey notnull" id="ca_id">a_id
+ <a href="#r_ab" title="Foreign key to r_ab.a_id" class="link detailforeignkeylink">(fk)</a>
+ <a href="#a" title="Foreign key to a.a_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">AId</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname foreignkey notnull" id="cb_id">b_id
+ <a href="#r_ab" title="Foreign key to r_ab.b_id" class="link detailforeignkeylink">(fk)</a>
+ <a href="#b" title="Foreign key to b.b_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">BId</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="cname">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 50 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="d"/>
+<h2>d</h2>
+
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="dd_id">d_id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">DId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="dname">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 255 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey foreignkey notnull" id="db_id">b_id
+ <a href="#r_ab" title="Foreign key to r_ab.b_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> 255 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">BId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey foreignkey notnull" id="da_id">a_id
+ <a href="#a" title="Foreign key to a.a_id" class="link detailforeignkeylink">(fk)</a>
+ <a href="#r_ab" title="Foreign key to r_ab.a_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> 255 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">AId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="nopk"/>
+<h2>nopk</h2>
+this table has no pk
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="nopkintcol">intcol
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Intcol</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="nopkname">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 50 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="MULTIPK_SELF_REFTABLE"/>
+<h2>MULTIPK_SELF_REFTABLE</h2>
+
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="MULTIPK_SELF_REFTABLECOL1">COL1
+ </td>
+ <td class="detailbackground detailborder detailtype">java.math.BigDecimal</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Col1</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="MULTIPK_SELF_REFTABLECOL2">COL2
+ </td>
+ <td class="detailbackground detailborder detailtype">java.math.BigDecimal</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Col2</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname foreignkey notnull" id="MULTIPK_SELF_REFTABLEPARENT_COL1">PARENT_COL1
+ <a href="#MULTIPK_SELF_REFTABLE" title="Foreign key to MULTIPK_SELF_REFTABLE.COL1" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">java.math.BigDecimal</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ParentCol1</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname foreignkey notnull" id="MULTIPK_SELF_REFTABLEPARENT_COL2">PARENT_COL2
+ <a href="#MULTIPK_SELF_REFTABLE" title="Foreign key to MULTIPK_SELF_REFTABLE.COL2" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">java.math.BigDecimal</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ParentCol2</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="ifc_table"/>
+<h2>ifc_table</h2>
+this table implements an interface
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="ifc_tableid">id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ID</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="ifc_tablename">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 50 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="ifc_table2"/>
+<h2>ifc_table2</h2>
+this table implements a local interface
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="ifc_table2id">id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ID</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="ifc_table2name">name
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 50 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Name</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="INHERITANCE_TEST"/>
+<h2>INHERITANCE_TEST</h2>
+Table to test inheritance
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="INHERITANCE_TESTINHERITANCE_TEST">INHERITANCE_TEST
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">InheritanceTest</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="INHERITANCE_TESTCLASS_NAME">CLASS_NAME
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 1 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ClassName</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="INHERITANCE_TESTPAYLOAD_PARENT">PAYLOAD_PARENT
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 100 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">PayloadParent</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="INHERITANCE_TESTPAYLOAD_B">PAYLOAD_B
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 100 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">PayloadB</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="INHERITANCE_TESTPAYLOAD_C">PAYLOAD_C
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 100 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">PayloadC</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="INHERITANCE_TESTPAYLOAD_D">PAYLOAD_D
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 100 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">PayloadD</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="ext_schema"/>
+<h2>ext_schema</h2>
+
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="ext_schemaext_schema_id">ext_schema_id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ExtSchemaId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname foreignkey" id="ext_schemaext_id">ext_id
+ <a href="#ext" title="Foreign key to ext.ext_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ExtId</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="ext_schematest">test
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Test</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="extext_schema"/>
+<h2>extext_schema</h2>
+
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname primarykey notnull" id="extext_schemaextext_schema_id">extext_schema_id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ExtextSchemaId</td>
+ <td class="detailbackground detailborder detailpk"><center> X </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname foreignkey" id="extext_schemaextext_id">extext_id
+ <a href="#extext" title="Foreign key to extext.extext_id" class="link detailforeignkeylink">(fk)</a>
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">ExtextId</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> X </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname notnull" id="extext_schematest">test
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Test</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> X </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+<a name="torque.qualified_name"/>
+<h2>torque.qualified_name</h2>
+
+<p/>
+<table class="detailtable">
+ <tr class="detailhead">
+ <th class="detailheadbackground detailborder detailheadname">Name</th>
+ <th class="detailheadbackground detailborder detailheadtype">Type</th>
+ <th class="detailheadbackground detailborder detailheadsize">Size</th>
+ <th class="detailheadbackground detailborder detailheaddefault">Default</th>
+ <th class="detailheadbackground detailborder detailheadjavaname">JavaName</th>
+ <th class="detailheadbackground detailborder detailheadpk">PK</th>
+ <th class="detailheadbackground detailborder detailheadfk">FK</th>
+ <th class="detailheadbackground detailborder detailheadnotnull">not null</th>
+ <th class="detailheadbackground detailborder detailheaddescription">Description</th>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="torque.qualified_nameid">id
+ </td>
+ <td class="detailbackground detailborder detailtype">int</td>
+ <td class="detailbackground detailborder detailsize"> </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Id</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+ <tr class="detailrow">
+
+ <td class="detailbackground detailborder detailname" id="torque.qualified_namepayload">payload
+ </td>
+ <td class="detailbackground detailborder detailtype">String</td>
+ <td class="detailbackground detailborder detailsize"> 100 </td>
+ <td class="detailbackground detailborder detaildefault"> </td>
+ <td class="detailbackground detailborder detailjavaname">Payload</td>
+ <td class="detailbackground detailborder detailpk"><center> </center></td>
+ <td class="detailbackground detailborder detailfk"><center> </center></td>
+ <td class="detailbackground detailborder detailnotnull"><center> </center></td>
+ <td class="detailbackground detailborder detaildescription"> </td>
+ </tr>
+</table>
+
+</body>
+</html>
Added: db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.sql
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.sql?rev=1514132&view=auto
==============================================================================
--- db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.sql (added)
+++ db/torque/torque4/trunk/torque-templates/src/test/resources/org/apache/torque/templates/expected-schema.sql Thu Aug 15 02:23:36 2013
@@ -0,0 +1,315 @@
+## Licensed to the Apache Software Foundation (ASF) under one
+## or more contributor license agreements. See the NOTICE file
+## distributed with this work for additional information
+## regarding copyright ownership. The ASF licenses this file
+## to you 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.
+##
+-- -----------------------------------------------------------------------
+-- mysql SQL script for schema bookstore
+-- -----------------------------------------------------------------------
+
+
+ALTER TABLE r_ab
+ DROP FOREIGN KEY r_ab_FK_1;
+
+
+ALTER TABLE r_ab
+ DROP FOREIGN KEY r_ab_FK_2;
+
+
+ALTER TABLE c
+ DROP FOREIGN KEY c_FK_1;
+
+
+ALTER TABLE c
+ DROP FOREIGN KEY c_FK_2;
+
+
+ALTER TABLE c
+ DROP FOREIGN KEY c_FK_3;
+
+
+ALTER TABLE d
+ DROP FOREIGN KEY d_FK_1;
+
+
+ALTER TABLE d
+ DROP FOREIGN KEY d_FK_2;
+
+
+ALTER TABLE MULTIPK_SELF_REFTABLE
+ DROP FOREIGN KEY MULTIPK_SELF_REFTABLE_FK_1;
+
+
+ALTER TABLE ext_schema
+ DROP FOREIGN KEY ext_schema_FK_1;
+
+
+ALTER TABLE extext_schema
+ DROP FOREIGN KEY extext_schema_FK_1;
+
+
+drop table if exists extext;
+drop table if exists ext;
+drop table if exists a;
+drop table if exists b;
+drop table if exists r_ab;
+drop table if exists c;
+drop table if exists d;
+drop table if exists nopk;
+drop table if exists MULTIPK_SELF_REFTABLE;
+drop table if exists ifc_table;
+drop table if exists ifc_table2;
+drop table if exists INHERITANCE_TEST;
+drop table if exists ext_schema;
+drop table if exists extext_schema;
+drop table if exists torque.qualified_name;
+
+# -----------------------------------------------------------------------
+# extext
+# -----------------------------------------------------------------------
+CREATE TABLE extext
+(
+ extext_id INTEGER NOT NULL AUTO_INCREMENT,
+ test VARCHAR(15) NOT NULL,
+ PRIMARY KEY(extext_id)
+);
+
+
+# -----------------------------------------------------------------------
+# ext
+# -----------------------------------------------------------------------
+CREATE TABLE ext
+(
+ ext_id INTEGER NOT NULL AUTO_INCREMENT,
+ test VARCHAR(15) NOT NULL,
+ PRIMARY KEY(ext_id)
+);
+
+
+# -----------------------------------------------------------------------
+# a
+# -----------------------------------------------------------------------
+CREATE TABLE a
+(
+ a_id INTEGER NOT NULL AUTO_INCREMENT,
+ name VARCHAR(50) default 'a_name' NOT NULL,
+ PRIMARY KEY(a_id),
+ INDEX NAME_IDX(name)
+);
+
+
+# -----------------------------------------------------------------------
+# b
+# -----------------------------------------------------------------------
+CREATE TABLE b
+(
+ b_id INTEGER NOT NULL AUTO_INCREMENT,
+ name VARCHAR(50) NOT NULL,
+ PRIMARY KEY(b_id),
+ UNIQUE NAME_UNQ (name)
+);
+
+
+# -----------------------------------------------------------------------
+# r_ab
+# -----------------------------------------------------------------------
+CREATE TABLE r_ab
+(
+ a_id INTEGER NOT NULL,
+ b_id INTEGER NOT NULL,
+ name VARCHAR(50) NOT NULL,
+ PRIMARY KEY(a_id, b_id)
+);
+
+
+# -----------------------------------------------------------------------
+# c
+# -----------------------------------------------------------------------
+CREATE TABLE c
+(
+ c_id INTEGER NOT NULL AUTO_INCREMENT,
+ a_id INTEGER NOT NULL,
+ b_id INTEGER NOT NULL,
+ name VARCHAR(50) NOT NULL,
+ PRIMARY KEY(c_id)
+);
+
+
+# -----------------------------------------------------------------------
+# d
+# -----------------------------------------------------------------------
+CREATE TABLE d
+(
+ d_id INTEGER NOT NULL,
+ name VARCHAR(255) NOT NULL,
+ b_id INTEGER NOT NULL,
+ a_id INTEGER NOT NULL,
+ PRIMARY KEY(d_id, b_id, a_id)
+);
+
+
+# -----------------------------------------------------------------------
+# nopk
+# -----------------------------------------------------------------------
+CREATE TABLE nopk
+(
+ intcol INTEGER,
+ name VARCHAR(50)
+);
+
+
+# -----------------------------------------------------------------------
+# MULTIPK_SELF_REFTABLE
+# -----------------------------------------------------------------------
+CREATE TABLE MULTIPK_SELF_REFTABLE
+(
+ COL1 DECIMAL NOT NULL,
+ COL2 DECIMAL NOT NULL,
+ PARENT_COL1 DECIMAL NOT NULL,
+ PARENT_COL2 DECIMAL NOT NULL,
+ PRIMARY KEY(COL1, COL2)
+);
+
+
+# -----------------------------------------------------------------------
+# ifc_table
+# -----------------------------------------------------------------------
+CREATE TABLE ifc_table
+(
+ id INTEGER NOT NULL,
+ name VARCHAR(50),
+ PRIMARY KEY(id)
+);
+
+
+# -----------------------------------------------------------------------
+# ifc_table2
+# -----------------------------------------------------------------------
+CREATE TABLE ifc_table2
+(
+ id INTEGER NOT NULL,
+ name VARCHAR(50),
+ PRIMARY KEY(id)
+);
+
+
+# -----------------------------------------------------------------------
+# INHERITANCE_TEST
+# -----------------------------------------------------------------------
+CREATE TABLE INHERITANCE_TEST
+(
+ INHERITANCE_TEST INTEGER NOT NULL AUTO_INCREMENT,
+ CLASS_NAME CHAR(1),
+ PAYLOAD_PARENT VARCHAR(100) NOT NULL,
+ PAYLOAD_B VARCHAR(100),
+ PAYLOAD_C VARCHAR(100),
+ PAYLOAD_D VARCHAR(100),
+ PRIMARY KEY(INHERITANCE_TEST)
+);
+
+
+# -----------------------------------------------------------------------
+# ext_schema
+# -----------------------------------------------------------------------
+CREATE TABLE ext_schema
+(
+ ext_schema_id INTEGER NOT NULL AUTO_INCREMENT,
+ ext_id INTEGER,
+ test INTEGER NOT NULL,
+ PRIMARY KEY(ext_schema_id),
+ INDEX index_ext_id(ext_id)
+);
+
+
+# -----------------------------------------------------------------------
+# extext_schema
+# -----------------------------------------------------------------------
+CREATE TABLE extext_schema
+(
+ extext_schema_id INTEGER NOT NULL AUTO_INCREMENT,
+ extext_id INTEGER,
+ test INTEGER NOT NULL,
+ PRIMARY KEY(extext_schema_id)
+);
+
+
+# -----------------------------------------------------------------------
+# torque.qualified_name
+# -----------------------------------------------------------------------
+CREATE TABLE torque.qualified_name
+(
+ id INTEGER,
+ payload VARCHAR(100)
+);
+
+ALTER TABLE r_ab
+ ADD CONSTRAINT r_ab_FK_1
+ FOREIGN KEY (a_id)
+ REFERENCES a (a_id);
+
+ALTER TABLE r_ab
+ ADD CONSTRAINT r_ab_FK_2
+ FOREIGN KEY (b_id)
+ REFERENCES b (b_id);
+
+ALTER TABLE c
+ ADD CONSTRAINT c_FK_1
+ FOREIGN KEY (a_id, b_id)
+ REFERENCES r_ab (a_id, b_id);
+
+ALTER TABLE c
+ ADD CONSTRAINT c_FK_2
+ FOREIGN KEY (a_id)
+ REFERENCES a (a_id);
+
+ALTER TABLE c
+ ADD CONSTRAINT c_FK_3
+ FOREIGN KEY (b_id)
+ REFERENCES b (b_id);
+
+ALTER TABLE d
+ ADD CONSTRAINT d_FK_1
+ FOREIGN KEY (a_id)
+ REFERENCES a (a_id);
+
+ALTER TABLE d
+ ADD CONSTRAINT d_FK_2
+ FOREIGN KEY (a_id, b_id)
+ REFERENCES r_ab (a_id, b_id);
+
+ALTER TABLE MULTIPK_SELF_REFTABLE
+ ADD CONSTRAINT MULTIPK_SELF_REFTABLE_FK_1
+ FOREIGN KEY (PARENT_COL1, PARENT_COL2)
+ REFERENCES MULTIPK_SELF_REFTABLE (COL1, COL2);
+
+ALTER TABLE ext_schema
+ ADD CONSTRAINT ext_schema_FK_1
+ FOREIGN KEY (ext_id)
+ REFERENCES ext (ext_id);
+
+ALTER TABLE extext_schema
+ ADD CONSTRAINT extext_schema_FK_1
+ FOREIGN KEY (extext_id)
+ REFERENCES extext (extext_id);
+
+CREATE OR REPLACE VIEW a_b AS
+ SELECT
+ a.a_id AS a_id,
+ a.name AS a_name,
+ b.b_id AS b_id,
+ b.name AS b_name
+ from a join r_ab on a.a_id=r_ab.a_id join b on r_ab.b_id=b.b_id;
+
+
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org