Author: tfischer Date: Fri Dec 28 19:50:38 2012 New Revision: 844158 Log: add dtd directory to torque site
Added: websites/production/db/content/torque/dtd/ websites/production/db/content/torque/dtd/database.dtd websites/production/db/content/torque/dtd/database_3_0_0.dtd websites/production/db/content/torque/dtd/database_3_0_1.dtd websites/production/db/content/torque/dtd/database_3_1.dtd websites/production/db/content/torque/dtd/database_3_2.dtd websites/production/db/content/torque/dtd/database_3_3.dtd Added: websites/production/db/content/torque/dtd/database.dtd ============================================================================== --- websites/production/db/content/torque/dtd/database.dtd (added) +++ websites/production/db/content/torque/dtd/database.dtd Fri Dec 28 19:50:38 2012 @@ -0,0 +1,195 @@ +<!-- + 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. +--> +<!-- + Torque XML database schema DTD + $Id: database.dtd 584517 2007-10-14 09:00:14Z tfischer $ +--> + +<!-- +For: database.defaultIdMethod and table.idMethod + +Do not use autoincrement or sequence. They are deprecated in favor of +using native which will use the Connection pool to determine +which database it is talking to (yes, it knows that) and then use +whatever native database methodology for insert increments that it can. +Otherwise, you should use idbroker or none. none is good if you have a +table that is just a join table. idbroker is good if you want a +centralized repository for brokering out clumps of id's in a database +agnostic way. +--> + +<!-- + +defaultJavaNamingMethod determines how a table or column name, +from the name attribute in the xml database file, is converted to a +Java class or method name. + + nochange - indicates not change is performed. + underscore - Underscores and dots are removed, first letter is + capitalized, first letter after an underscore + is capitalized, first letter after a dot is capitalized, + the rest of the letters are converted to lowercase. + underscoreOmitSchema - The section of the name before and including + the last dot in the name is removed. For the remaining part, + underscores are removed, first letter is capitalized, + first letter after an underscore is capitalized, + the rest of the letters are converted to lowercase. + javaname - same as underscore, but no letters are converted + to lowercase. +--> + +<!ELEMENT database (option*, external-schema*, domain*, table+)> +<!ATTLIST database + name CDATA #REQUIRED + defaultIdMethod (idbroker|native|none) "none" + defaultJavaType (object|primitive) "primitive" + package CDATA #IMPLIED + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + defaultJavaNamingMethod (nochange|underscore|underscoreOmitSchema|javaname) "underscore" + heavyIndexing (true|false) "false" +> + +<!ELEMENT option EMPTY> +<!ATTLIST option + key CDATA #REQUIRED + value CDATA #REQUIRED +> + +<!ELEMENT external-schema EMPTY> +<!ATTLIST external-schema + filename CDATA #REQUIRED +> + +<!ELEMENT domain EMPTY> +<!ATTLIST domain + name CDATA #REQUIRED + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) "VARCHAR" + size CDATA #IMPLIED + scale CDATA #IMPLIED + default CDATA #IMPLIED + description CDATA #IMPLIED +> + + +<!-- + note: the interface="true", requires that useManagers=true in the + properties file. +--> +<!ELEMENT table (option*,column+,(foreign-key|index|unique|id-method-parameter)*)> +<!ATTLIST table + name CDATA #REQUIRED + javaName CDATA #IMPLIED + idMethod (idbroker|native|none|null) "null" + skipSql (true|false) "false" + abstract (true|false) "false" + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + alias CDATA #IMPLIED + interface CDATA #IMPLIED + javaNamingMethod (nochange|underscore|underscoreOmitSchema|javaname) #IMPLIED + heavyIndexing (true|false) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT id-method-parameter EMPTY> +<!ATTLIST id-method-parameter + name CDATA "default" + value CDATA #REQUIRED +> + +<!ELEMENT column (option*, inheritance*)> +<!ATTLIST column + name CDATA #REQUIRED + javaName CDATA #IMPLIED + primaryKey (true|false) "false" + required (true|false) "false" + protected (true|false) "false" + domain CDATA #IMPLIED + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) #IMPLIED + javaType (object|primitive) #IMPLIED + size CDATA #IMPLIED + scale CDATA #IMPLIED + default CDATA #IMPLIED + autoIncrement (true|false) #IMPLIED + inheritance (single|false) "false" + inputValidator CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT inheritance EMPTY> +<!ATTLIST inheritance + key CDATA #REQUIRED + class CDATA #REQUIRED + extends CDATA #IMPLIED +> + +<!ELEMENT foreign-key (option*,reference+)> +<!ATTLIST foreign-key + foreignTable CDATA #REQUIRED + name CDATA #IMPLIED + onUpdate (cascade|setnull|restrict|none) "none" + onDelete (cascade|setnull|restrict|none) "none" +> + +<!ELEMENT reference EMPTY> +<!ATTLIST reference + local CDATA #REQUIRED + foreign CDATA #REQUIRED +> + +<!ELEMENT index (option*,index-column+)> +<!ATTLIST index + name CDATA #IMPLIED +> + +<!-- The index-column's size element is currently ignored + and will be removed in a further version. --> +<!ELEMENT index-column EMPTY> +<!ATTLIST index-column + name CDATA #REQUIRED + size CDATA #IMPLIED +> + +<!ELEMENT unique (option*,unique-column+)> +<!ATTLIST unique + name CDATA #IMPLIED +> + +<!ELEMENT unique-column EMPTY> +<!ATTLIST unique-column + name CDATA #REQUIRED +> Added: websites/production/db/content/torque/dtd/database_3_0_0.dtd ============================================================================== --- websites/production/db/content/torque/dtd/database_3_0_0.dtd (added) +++ websites/production/db/content/torque/dtd/database_3_0_0.dtd Fri Dec 28 19:50:38 2012 @@ -0,0 +1,150 @@ +<!-- + 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. +--> +<!-- + Torque XML database schema DTD + $Id: database.dtd,v 1.10 2001/12/27 20:49:32 jmcnally Exp $ +--> + +<!-- +For: database.defaultIdMethod and table.idMethod + +Do not use autoincrement or sequence. They are deprecated in favor of +using native which will use the Turbine Connection pool to determine +which database it is talking to (yes, it knows that) and then use +whatever native database methodology for insert increments that it can. +Otherwise, you should use idbroker or none. none is good if you have a +table that is just a join table. idbroker is good if you want a +centralized repository for brokering out clumps of id's in a database +agnostic way. +--> + +<!-- + +defaultJavaNamingMethod determines how a table or column name, +from the name attribute in the xml database file, is converted to a +Java class or method name. + + nochange - indicates not change is performed. + underscore - Underscores are removed, First letter is + capitalized, first letter after an underscore + is capitalized, the rest of the letters are + converted to lowercase. + javaname - same as underscore, but no letters are converted + to lowercase. +--> + +<!ELEMENT database (table+)> +<!ATTLIST database + name CDATA #IMPLIED + defaultIdMethod (idbroker|native|autoincrement|sequence|none) "none" + defaultJavaType (object|primitive) "primitive" + package CDATA #IMPLIED + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + defaultJavaNamingMethod (nochange|underscore|javaname) "underscore" + heavyIndexing (true|false) "false" +> + +<!ELEMENT table (column+,(foreign-key|index|unique|id-method-parameter)*)> +<!ATTLIST table + name CDATA #REQUIRED + javaName CDATA #IMPLIED + idMethod (idbroker|native|autoincrement|sequence|none|null) "null" + skipSql (true|false) "false" + abstract (true|false) "false" + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + alias CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + heavyIndexing (true|false) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT id-method-parameter EMPTY> +<!ATTLIST id-method-parameter + name CDATA "default" + value CDATA #REQUIRED +> + +<!ELEMENT column (inheritance*)> +<!ATTLIST column + name CDATA #REQUIRED + javaName CDATA #IMPLIED + primaryKey (true|false) "false" + required (true|false) "false" + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) "VARCHAR" + javaType (object|primitive) #IMPLIED + size CDATA #IMPLIED + default CDATA #IMPLIED + autoIncrement (true|false) "false" + inheritance (single|false) "false" + inputValidator CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT inheritance EMPTY> +<!ATTLIST inheritance + key CDATA #REQUIRED + class CDATA #REQUIRED + extends CDATA #IMPLIED +> + +<!ELEMENT foreign-key (reference+)> +<!ATTLIST foreign-key + foreignTable CDATA #REQUIRED + name CDATA #IMPLIED + onUpdate (cascade|setnull|restrict|none) "none" + onDelete (cascade|setnull|restrict|none) "none" +> + +<!ELEMENT reference EMPTY> +<!ATTLIST reference + local CDATA #REQUIRED + foreign CDATA #REQUIRED +> + +<!ELEMENT index (index-column+)> +<!ATTLIST index + name CDATA #IMPLIED +> + +<!ELEMENT index-column EMPTY> +<!ATTLIST index-column + name CDATA #REQUIRED + size CDATA #IMPLIED +> + +<!ELEMENT unique (unique-column+)> +<!ATTLIST unique + name CDATA #IMPLIED +> + +<!ELEMENT unique-column EMPTY> +<!ATTLIST unique-column + name CDATA #REQUIRED +> Added: websites/production/db/content/torque/dtd/database_3_0_1.dtd ============================================================================== --- websites/production/db/content/torque/dtd/database_3_0_1.dtd (added) +++ websites/production/db/content/torque/dtd/database_3_0_1.dtd Fri Dec 28 19:50:38 2012 @@ -0,0 +1,160 @@ +<!-- + 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. +--> +<!-- + Torque XML database schema DTD + $Id: database.dtd,v 1.13 2002/06/20 23:55:14 jmcnally Exp $ +--> + +<!-- +For: database.defaultIdMethod and table.idMethod + +Do not use autoincrement or sequence. They are deprecated in favor of +using native which will use the Turbine Connection pool to determine +which database it is talking to (yes, it knows that) and then use +whatever native database methodology for insert increments that it can. +Otherwise, you should use idbroker or none. none is good if you have a +table that is just a join table. idbroker is good if you want a +centralized repository for brokering out clumps of id's in a database +agnostic way. +--> + +<!-- + +defaultJavaNamingMethod determines how a table or column name, +from the name attribute in the xml database file, is converted to a +Java class or method name. + + nochange - indicates not change is performed. + underscore - Underscores are removed, First letter is + capitalized, first letter after an underscore + is capitalized, the rest of the letters are + converted to lowercase. + javaname - same as underscore, but no letters are converted + to lowercase. +--> + +<!ELEMENT database (external-schema*, table+)> +<!ATTLIST database + name CDATA #IMPLIED + defaultIdMethod (idbroker|native|autoincrement|sequence|none) "none" + defaultJavaType (object|primitive) "primitive" + package CDATA #IMPLIED + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + defaultJavaNamingMethod (nochange|underscore|javaname) "underscore" + heavyIndexing (true|false) "false" +> + +<!ELEMENT external-schema EMPTY> +<!ATTLIST external-schema + filename CDATA #REQUIRED +> + +<!-- + note: the interface="true", requires that useManagers=true in the + properties file. +--> +<!ELEMENT table (column+,(foreign-key|index|unique|id-method-parameter)*)> +<!ATTLIST table + name CDATA #REQUIRED + javaName CDATA #IMPLIED + idMethod (idbroker|native|autoincrement|sequence|none|null) "null" + skipSql (true|false) "false" + abstract (true|false) "false" + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + alias CDATA #IMPLIED + interface CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + heavyIndexing (true|false) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT id-method-parameter EMPTY> +<!ATTLIST id-method-parameter + name CDATA "default" + value CDATA #REQUIRED +> + +<!ELEMENT column (inheritance*)> +<!ATTLIST column + name CDATA #REQUIRED + javaName CDATA #IMPLIED + primaryKey (true|false) "false" + required (true|false) "false" + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) "VARCHAR" + javaType (object|primitive) #IMPLIED + size CDATA #IMPLIED + default CDATA #IMPLIED + autoIncrement (true|false) "false" + inheritance (single|false) "false" + inputValidator CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT inheritance EMPTY> +<!ATTLIST inheritance + key CDATA #REQUIRED + class CDATA #REQUIRED + extends CDATA #IMPLIED +> + +<!ELEMENT foreign-key (reference+)> +<!ATTLIST foreign-key + foreignTable CDATA #REQUIRED + name CDATA #IMPLIED + onUpdate (cascade|setnull|restrict|none) "none" + onDelete (cascade|setnull|restrict|none) "none" +> + +<!ELEMENT reference EMPTY> +<!ATTLIST reference + local CDATA #REQUIRED + foreign CDATA #REQUIRED +> + +<!ELEMENT index (index-column+)> +<!ATTLIST index + name CDATA #IMPLIED +> + +<!ELEMENT index-column EMPTY> +<!ATTLIST index-column + name CDATA #REQUIRED + size CDATA #IMPLIED +> + +<!ELEMENT unique (unique-column+)> +<!ATTLIST unique + name CDATA #IMPLIED +> + +<!ELEMENT unique-column EMPTY> +<!ATTLIST unique-column + name CDATA #REQUIRED +> Added: websites/production/db/content/torque/dtd/database_3_1.dtd ============================================================================== --- websites/production/db/content/torque/dtd/database_3_1.dtd (added) +++ websites/production/db/content/torque/dtd/database_3_1.dtd Fri Dec 28 19:50:38 2012 @@ -0,0 +1,160 @@ +<!-- + 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. +--> +<!-- + Torque XML database schema DTD + $Id: database.dtd,v 1.14 2003/01/08 16:43:57 henning Exp $ +--> + +<!-- +For: database.defaultIdMethod and table.idMethod + +Do not use autoincrement or sequence. They are deprecated in favor of +using native which will use the Connection pool to determine +which database it is talking to (yes, it knows that) and then use +whatever native database methodology for insert increments that it can. +Otherwise, you should use idbroker or none. none is good if you have a +table that is just a join table. idbroker is good if you want a +centralized repository for brokering out clumps of id's in a database +agnostic way. +--> + +<!-- + +defaultJavaNamingMethod determines how a table or column name, +from the name attribute in the xml database file, is converted to a +Java class or method name. + + nochange - indicates not change is performed. + underscore - Underscores are removed, First letter is + capitalized, first letter after an underscore + is capitalized, the rest of the letters are + converted to lowercase. + javaname - same as underscore, but no letters are converted + to lowercase. +--> + +<!ELEMENT database (external-schema*, table+)> +<!ATTLIST database + name CDATA #IMPLIED + defaultIdMethod (idbroker|native|autoincrement|sequence|none) "none" + defaultJavaType (object|primitive) "primitive" + package CDATA #IMPLIED + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + defaultJavaNamingMethod (nochange|underscore|javaname) "underscore" + heavyIndexing (true|false) "false" +> + +<!ELEMENT external-schema EMPTY> +<!ATTLIST external-schema + filename CDATA #REQUIRED +> + +<!-- + note: the interface="true", requires that useManagers=true in the + properties file. +--> +<!ELEMENT table (column+,(foreign-key|index|unique|id-method-parameter)*)> +<!ATTLIST table + name CDATA #REQUIRED + javaName CDATA #IMPLIED + idMethod (idbroker|native|autoincrement|sequence|none|null) "null" + skipSql (true|false) "false" + abstract (true|false) "false" + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + alias CDATA #IMPLIED + interface CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + heavyIndexing (true|false) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT id-method-parameter EMPTY> +<!ATTLIST id-method-parameter + name CDATA "default" + value CDATA #REQUIRED +> + +<!ELEMENT column (inheritance*)> +<!ATTLIST column + name CDATA #REQUIRED + javaName CDATA #IMPLIED + primaryKey (true|false) "false" + required (true|false) "false" + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) "VARCHAR" + javaType (object|primitive) #IMPLIED + size CDATA #IMPLIED + default CDATA #IMPLIED + autoIncrement (true|false) "false" + inheritance (single|false) "false" + inputValidator CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT inheritance EMPTY> +<!ATTLIST inheritance + key CDATA #REQUIRED + class CDATA #REQUIRED + extends CDATA #IMPLIED +> + +<!ELEMENT foreign-key (reference+)> +<!ATTLIST foreign-key + foreignTable CDATA #REQUIRED + name CDATA #IMPLIED + onUpdate (cascade|setnull|restrict|none) "none" + onDelete (cascade|setnull|restrict|none) "none" +> + +<!ELEMENT reference EMPTY> +<!ATTLIST reference + local CDATA #REQUIRED + foreign CDATA #REQUIRED +> + +<!ELEMENT index (index-column+)> +<!ATTLIST index + name CDATA #IMPLIED +> + +<!ELEMENT index-column EMPTY> +<!ATTLIST index-column + name CDATA #REQUIRED + size CDATA #IMPLIED +> + +<!ELEMENT unique (unique-column+)> +<!ATTLIST unique + name CDATA #IMPLIED +> + +<!ELEMENT unique-column EMPTY> +<!ATTLIST unique-column + name CDATA #REQUIRED +> Added: websites/production/db/content/torque/dtd/database_3_2.dtd ============================================================================== --- websites/production/db/content/torque/dtd/database_3_2.dtd (added) +++ websites/production/db/content/torque/dtd/database_3_2.dtd Fri Dec 28 19:50:38 2012 @@ -0,0 +1,187 @@ +<!-- + 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. +--> +<!-- + Torque XML database schema DTD + $Id: database.dtd,v 1.8 2005/06/27 21:34:10 tfischer Exp $ +--> + +<!-- +For: database.defaultIdMethod and table.idMethod + +Do not use autoincrement or sequence. They are deprecated in favor of +using native which will use the Connection pool to determine +which database it is talking to (yes, it knows that) and then use +whatever native database methodology for insert increments that it can. +Otherwise, you should use idbroker or none. none is good if you have a +table that is just a join table. idbroker is good if you want a +centralized repository for brokering out clumps of id's in a database +agnostic way. +--> + +<!-- + +defaultJavaNamingMethod determines how a table or column name, +from the name attribute in the xml database file, is converted to a +Java class or method name. + + nochange - indicates not change is performed. + underscore - Underscores and dots are removed, first letter is + capitalized, first letter after an underscore + is capitalized, first letter after a dot is capitalized, + the rest of the letters are converted to lowercase. + underscoreOmitSchema - The section of the name before and including + the last dot in the name is removed. For the remaining part, + underscores are removed, first letter is capitalized, + first letter after an underscore is capitalized, + the rest of the letters are converted to lowercase. + javaname - same as underscore, but no letters are converted + to lowercase. +--> + +<!ELEMENT database (external-schema*, domain*, table+)> +<!ATTLIST database + name CDATA #REQUIRED + defaultIdMethod (idbroker|native|none) "none" + defaultJavaType (object|primitive) "primitive" + package CDATA #IMPLIED + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + defaultJavaNamingMethod (nochange|underscore|underscoreOmitSchema|javaname) "underscore" + heavyIndexing (true|false) "false" +> + +<!ELEMENT external-schema EMPTY> +<!ATTLIST external-schema + filename CDATA #REQUIRED +> + +<!ELEMENT domain EMPTY> +<!ATTLIST domain + name CDATA #REQUIRED + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) "VARCHAR" + size CDATA #IMPLIED + scale CDATA #IMPLIED + default CDATA #IMPLIED + description CDATA #IMPLIED +> + + +<!-- + note: the interface="true", requires that useManagers=true in the + properties file. +--> +<!ELEMENT table (column+,(foreign-key|index|unique|id-method-parameter)*)> +<!ATTLIST table + name CDATA #REQUIRED + javaName CDATA #IMPLIED + idMethod (idbroker|native|none|null) "null" + skipSql (true|false) "false" + abstract (true|false) "false" + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + alias CDATA #IMPLIED + interface CDATA #IMPLIED + javaNamingMethod (nochange|underscore|underscoreOmitSchema|javaname) #IMPLIED + heavyIndexing (true|false) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT id-method-parameter EMPTY> +<!ATTLIST id-method-parameter + name CDATA "default" + value CDATA #REQUIRED +> + +<!ELEMENT column (inheritance*)> +<!ATTLIST column + name CDATA #REQUIRED + javaName CDATA #IMPLIED + primaryKey (true|false) "false" + required (true|false) "false" + protected (true|false) "false" + domain CDATA #IMPLIED + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) #IMPLIED + javaType (object|primitive) #IMPLIED + size CDATA #IMPLIED + scale CDATA #IMPLIED + default CDATA #IMPLIED + autoIncrement (true|false) #IMPLIED + inheritance (single|false) "false" + inputValidator CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT inheritance EMPTY> +<!ATTLIST inheritance + key CDATA #REQUIRED + class CDATA #REQUIRED + extends CDATA #IMPLIED +> + +<!ELEMENT foreign-key (reference+)> +<!ATTLIST foreign-key + foreignTable CDATA #REQUIRED + name CDATA #IMPLIED + onUpdate (cascade|setnull|restrict|none) "none" + onDelete (cascade|setnull|restrict|none) "none" +> + +<!ELEMENT reference EMPTY> +<!ATTLIST reference + local CDATA #REQUIRED + foreign CDATA #REQUIRED +> + +<!ELEMENT index (index-column+)> +<!ATTLIST index + name CDATA #IMPLIED +> + +<!ELEMENT index-column EMPTY> +<!ATTLIST index-column + name CDATA #REQUIRED + size CDATA #IMPLIED +> + +<!ELEMENT unique (unique-column+)> +<!ATTLIST unique + name CDATA #IMPLIED +> + +<!ELEMENT unique-column EMPTY> +<!ATTLIST unique-column + name CDATA #REQUIRED +> Added: websites/production/db/content/torque/dtd/database_3_3.dtd ============================================================================== --- websites/production/db/content/torque/dtd/database_3_3.dtd (added) +++ websites/production/db/content/torque/dtd/database_3_3.dtd Fri Dec 28 19:50:38 2012 @@ -0,0 +1,195 @@ +<!-- + 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. +--> +<!-- + Torque XML database schema DTD + $Id: database.dtd 584517 2007-10-14 09:00:14Z tfischer $ +--> + +<!-- +For: database.defaultIdMethod and table.idMethod + +Do not use autoincrement or sequence. They are deprecated in favor of +using native which will use the Connection pool to determine +which database it is talking to (yes, it knows that) and then use +whatever native database methodology for insert increments that it can. +Otherwise, you should use idbroker or none. none is good if you have a +table that is just a join table. idbroker is good if you want a +centralized repository for brokering out clumps of id's in a database +agnostic way. +--> + +<!-- + +defaultJavaNamingMethod determines how a table or column name, +from the name attribute in the xml database file, is converted to a +Java class or method name. + + nochange - indicates not change is performed. + underscore - Underscores and dots are removed, first letter is + capitalized, first letter after an underscore + is capitalized, first letter after a dot is capitalized, + the rest of the letters are converted to lowercase. + underscoreOmitSchema - The section of the name before and including + the last dot in the name is removed. For the remaining part, + underscores are removed, first letter is capitalized, + first letter after an underscore is capitalized, + the rest of the letters are converted to lowercase. + javaname - same as underscore, but no letters are converted + to lowercase. +--> + +<!ELEMENT database (option*, external-schema*, domain*, table+)> +<!ATTLIST database + name CDATA #REQUIRED + defaultIdMethod (idbroker|native|none) "none" + defaultJavaType (object|primitive) "primitive" + package CDATA #IMPLIED + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + defaultJavaNamingMethod (nochange|underscore|underscoreOmitSchema|javaname) "underscore" + heavyIndexing (true|false) "false" +> + +<!ELEMENT option EMPTY> +<!ATTLIST option + key CDATA #REQUIRED + value CDATA #REQUIRED +> + +<!ELEMENT external-schema EMPTY> +<!ATTLIST external-schema + filename CDATA #REQUIRED +> + +<!ELEMENT domain EMPTY> +<!ATTLIST domain + name CDATA #REQUIRED + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) "VARCHAR" + size CDATA #IMPLIED + scale CDATA #IMPLIED + default CDATA #IMPLIED + description CDATA #IMPLIED +> + + +<!-- + note: the interface="true", requires that useManagers=true in the + properties file. +--> +<!ELEMENT table (option*,column+,(foreign-key|index|unique|id-method-parameter)*)> +<!ATTLIST table + name CDATA #REQUIRED + javaName CDATA #IMPLIED + idMethod (idbroker|native|none|null) "null" + skipSql (true|false) "false" + abstract (true|false) "false" + baseClass CDATA #IMPLIED + basePeer CDATA #IMPLIED + alias CDATA #IMPLIED + interface CDATA #IMPLIED + javaNamingMethod (nochange|underscore|underscoreOmitSchema|javaname) #IMPLIED + heavyIndexing (true|false) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT id-method-parameter EMPTY> +<!ATTLIST id-method-parameter + name CDATA "default" + value CDATA #REQUIRED +> + +<!ELEMENT column (option*, inheritance*)> +<!ATTLIST column + name CDATA #REQUIRED + javaName CDATA #IMPLIED + primaryKey (true|false) "false" + required (true|false) "false" + protected (true|false) "false" + domain CDATA #IMPLIED + type + ( + BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT + | REAL | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR + | DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY + | NULL | OTHER | JAVA_OBJECT | DISTINCT | STRUCT | ARRAY + | BLOB | CLOB | REF | BOOLEANINT | BOOLEANCHAR + | DOUBLE + ) #IMPLIED + javaType (object|primitive) #IMPLIED + size CDATA #IMPLIED + scale CDATA #IMPLIED + default CDATA #IMPLIED + autoIncrement (true|false) #IMPLIED + inheritance (single|false) "false" + inputValidator CDATA #IMPLIED + javaNamingMethod (nochange|underscore|javaname) #IMPLIED + description CDATA #IMPLIED +> + +<!ELEMENT inheritance EMPTY> +<!ATTLIST inheritance + key CDATA #REQUIRED + class CDATA #REQUIRED + extends CDATA #IMPLIED +> + +<!ELEMENT foreign-key (option*,reference+)> +<!ATTLIST foreign-key + foreignTable CDATA #REQUIRED + name CDATA #IMPLIED + onUpdate (cascade|setnull|restrict|none) "none" + onDelete (cascade|setnull|restrict|none) "none" +> + +<!ELEMENT reference EMPTY> +<!ATTLIST reference + local CDATA #REQUIRED + foreign CDATA #REQUIRED +> + +<!ELEMENT index (option*,index-column+)> +<!ATTLIST index + name CDATA #IMPLIED +> + +<!-- The index-column's size element is currently ignored + and will be removed in a further version. --> +<!ELEMENT index-column EMPTY> +<!ATTLIST index-column + name CDATA #REQUIRED + size CDATA #IMPLIED +> + +<!ELEMENT unique (option*,unique-column+)> +<!ATTLIST unique + name CDATA #IMPLIED +> + +<!ELEMENT unique-column EMPTY> +<!ATTLIST unique-column + name CDATA #REQUIRED +>