Added: db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst?rev=1135031&view=auto ============================================================================== --- db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst (added) +++ db/ddlutils/trunk/src/site/sphinx/databases/oracle.rst Mon Jun 13 06:19:54 2011 @@ -0,0 +1,158 @@ +.. 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. + +.. _`Oracle database`: http://www.oracle.com/us/products/database/index.html +.. _`Oracle database documentation`: http://www.oracle.com/technetwork/indexes/documentation/index.html#database + +Oracle +====== + +DdlUtils has support for the `Oracle database`_ for versions 8.1.7 and above. + +Info about the datatypes and SQL elements supported in the individual versions can be found in the +Oracle SQL Reference which can be accessed via the `Oracle database documentation`_. + +DdlUtils provides different platforms for Oracle v8, v9, and v10. The v9 platform adds support for +the native ``TIMESTAMP`` type, and the v10 platform handles the recycle bin that was introduced in +version 10 of the Oracle database. + +Note that DdlUtils currently does not automatically detect the database version, so it will always +choose the v8 version. If you want to make use of the additional features, then you have to +specify the platform identifier manually. + +Constraints +----------- + +Platform identifier + | ``Oracle`` + | ``Oracle9`` + | ``Oracle10`` + +Recognized JDBC drivers + | ``oracle.jdbc.driver.OracleDriver`` + | ``oracle.jdbc.dnlddriver.OracleDriver`` + +Recognized JDBC sub protocols + | ``jdbc:oracle:thin`` + | ``jdbc:oracle:oci8`` + | ``jdbc:oracle:dnldthin`` + +Supports SQL comments + yes + +Supports delimited identifiers + yes + +Maximum identifier length + 30 + +Supports default values for ``LONG`` types + yes + +Supports non-unique indices + yes + +Supports non-primary key columns as identity columns + yes + +Allows ``INSERT``/``UPDATE`` statements to set values for identity columns + yes + +DdlUtils uses sequences for identity columns + yes + +DdlUtils can read back the auto-generated value of an identity column + yes + +DdlUtils can create a database via JDBC + no + +DdlUtils can drop a database via JDBC + no + +Datatypes +--------- + ++-----------------+--------------------------------+---------------------------------------------+ +|JDBC Type |Database Type |Additional comments | ++=================+================================+=============================================+ +|``ARRAY`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIGINT`` |``NUMBER(38)`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BINARY`` |``RAW`` |Oracle requires the specification of the size| +| | |for ``RAW`` columns. If no size was | +| | |specified, then 254 is used. Will be read | +| | |back as ``VARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIT`` |``NUMBER(1)`` |Oracle has no native boolean type. | ++-----------------+--------------------------------+---------------------------------------------+ +|``BLOB`` |``BLOB`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BOOLEAN`` |``NUMBER(1)`` |Oracle has no native boolean type. | ++-----------------+--------------------------------+---------------------------------------------+ +|``CHAR`` |``CHAR`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``CLOB`` |``CLOB`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATALINK`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATE`` |``DATE`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``DECIMAL`` |``NUMBER`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``DISTINCT`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DOUBLE`` |``DOUBLE PRECISION`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``FLOAT`` |``FLOAT`` |Will be read back as ``DOUBLE`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``INTEGER`` |``INTEGER`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``JAVA_OBJECT`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARBINARY``|``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARCHAR`` |``CLOB`` |Will be read back as ``CLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``NULL`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``NUMERIC`` |``NUMBER`` |Will be read back as ``DECIMAL`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``OTHER`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``REAL`` |``REAL`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``REF`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``SMALLINT`` |``NUMBER(5)`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``STRUCT`` |``BLOB`` |Will be read back as ``BLOB`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIME`` |``DATE`` |Will be read back as ``TIMESTAMP`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIMESTAMP`` |Oracle8: ``DATE`` |The TIMESTAMP native type is only supported | +| |Oracle9/10: ``TIMESTAMP`` |in Oracle 9 and above. | ++-----------------+--------------------------------+---------------------------------------------+ +|``TINYINT`` |``NUMBER(3)`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARBINARY`` |``RAW`` |Oracle requires the specification of the size| +| | |for ``RAW`` columns. If no size was | +| | |specified, then 254 is used. | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARCHAR`` |``VARCHAR2`` | | ++-----------------+--------------------------------+---------------------------------------------+
Added: db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst?rev=1135031&view=auto ============================================================================== --- db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst (added) +++ db/ddlutils/trunk/src/site/sphinx/databases/postgresql.rst Mon Jun 13 06:19:54 2011 @@ -0,0 +1,137 @@ +.. 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. + +.. _`PostgreSQL`: http://www.postgresql.org/ +.. _`Manual`: http://www.postgresql.org/docs/7.4/interactive/index.html + +PostgreSQL +========== + +DdlUtils supports `PostgreSQL`_ version 7.2.8 and newer. SQL syntax details and supported +datatypes are described in the `Manual`_. + +Constraints +----------- + +Platform identifier + ``PostgreSql`` + +Recognized JDBC drivers + ``org.postgresql.Driver`` + +Recognized JDBC sub protocols + ``jdbc:oracle:postgresql`` + +Supports SQL comments + yes + +Supports delimited identifiers + yes + +Maximum identifier length + 31 + +Supports default values for ``LONG`` types + yes + +Supports non-unique indices + yes + +Supports non-primary key columns as identity columns + yes + +Allows ``INSERT``/``UPDATE`` statements to set values for identity columns + yes + +DdlUtils uses sequences for identity columns + yes + +DdlUtils can read back the auto-generated value of an identity column + yes + +DdlUtils can create a database via JDBC + yes + +DdlUtils can drop a database via JDBC + yes + +Datatypes +--------- + ++-----------------+--------------------------------+---------------------------------------------+ +|JDBC Type |Database Type |Additional comments | ++=================+================================+=============================================+ +|``ARRAY`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIGINT`` |``BIGINT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BINARY`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIT`` |``BOOLEAN`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BLOB`` |``BYTEA`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BOOLEAN`` |``BOOLEAN`` |Will be read back as ``BIT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``CHAR`` |``CHAR`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``CLOB`` |``TEXT`` |Will be read back as ``LONGVARCHAR`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATALINK`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATE`` |``DATE`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``DECIMAL`` |``NUMERIC`` |Will be read back as ``NUMERIC`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DISTINCT`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DOUBLE`` |``DOUBLE PRECISION`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``FLOAT`` |``DOUBLE PRECISION`` |Will be read back as ``DOUBLE`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``INTEGER`` |``INTEGER`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``JAVA_OBJECT`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARBINARY``|``BYTEA`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARCHAR`` |``TEXT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``NULL`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``NUMERIC`` |``NUMERIC`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``OTHER`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``REAL`` |``REAL`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``REF`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``SMALLINT`` |``SMALLINT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``STRUCT`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIME`` |``TIME`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIMESTAMP`` |``TIMESTAMP`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``TINYINT`` |``SMALLINT`` |Will be read back as ``SMALLINT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARBINARY`` |``BYTEA`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARCHAR`` |``VARCHAR`` | | ++-----------------+--------------------------------+---------------------------------------------+ Added: db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst?rev=1135031&view=auto ============================================================================== --- db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst (added) +++ db/ddlutils/trunk/src/site/sphinx/databases/sqlserver.rst Mon Jun 13 06:19:54 2011 @@ -0,0 +1,152 @@ +.. 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. + +.. _`Microsoft SQL Server`: http://msdn2.microsoft.com/en-us/sql/default.aspx +.. _`Transact-SQL manual`: http://msdn.microsoft.com/en-us/library/Aa260642 + +SQL Server +========== + +The `Microsoft SQL Server`_ is supported form version 6.5 onwards. Information about the +versions prior to SQL Server 2000 however is difficult to find online, you'll have to resort +to the documentation accompanying the database. Information for version 2000 can be found +in the `Transact-SQL manual`_. + +If possible, you should use the newest driver available. The older JDBC drivers (for SQL Server 2000 and +older) provided my Microsoft, are known to be buggy and slow. The newer SQL Server drivers (2005 and newer) +are preferred and can also work with SQL Server 2000. + +Constraints +----------- + +Platform identifier + ``MsSql`` + +Recognized JDBC drivers + | ``com.microsoft.jdbc.sqlserver.SQLServerDriver`` + | ``com.microsoft.sqlserver.jdbc.SQLServerDriver`` + +Recognized JDBC sub protocols + | ``jdbc:microsoft:sqlserver`` + | ``jdbc:sqlserver`` + | ``jdbc:sqljdbc`` + +Supports SQL comments + yes + +Supports delimited identifiers + yes + +Maximum identifier length + 128 + +Supports default values for ``LONG`` types + yes + +Supports non-unique indices + yes + +Supports non-primary key columns as identity columns + yes + +Allows ``INSERT``/``UPDATE`` statements to set values for identity columns + yes + +DdlUtils uses sequences for identity columns + yes + +DdlUtils can read back the auto-generated value of an identity column + yes + +DdlUtils can create a database via JDBC + no + +DdlUtils can drop a database via JDBC + no + +Datatypes +--------- + ++-----------------+--------------------------------+---------------------------------------------+ +|JDBC Type |Database Type |Additional comments | ++=================+================================+=============================================+ +|``ARRAY`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIGINT`` |``DECIMAL(19,0)`` |A native BIGINT type is supported only since | +| | |SQL Server 2000 | ++-----------------+--------------------------------+---------------------------------------------+ +|``BINARY`` |``BINARY`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIT`` |``BIT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BLOB`` |``IMAGE`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BOOLEAN`` |``BIT`` |Will be read back as ``BIT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``CHAR`` |``CHAR`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``CLOB`` |``TEXT`` |Will be read back as ``LONGVARCHAR`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATALINK`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATE`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DECIMAL`` |``DECIMAL`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``DISTINCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DOUBLE`` |``FLOAT`` |Will be read back as ``FLOAT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``FLOAT`` |``FLOAT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``INTEGER`` |``INT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``JAVA_OBJECT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARBINARY``|``IMAGE`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARCHAR`` |``TEXT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``NULL`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``NUMERIC`` |``NUMERIC`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``OTHER`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``REAL`` |``REAL`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``REF`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``SMALLINT`` |``SMALLINT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``STRUCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIME`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIMESTAMP`` |``DATETIME`` |The native ``TIMESTAMP`` type of SQL Server | +| | |serves a different purpose: it provides a | +| | |counter that automatically increments upon | +| | |each insertion or update of the table. | ++-----------------+--------------------------------+---------------------------------------------+ +|``TINYINT`` |``SMALLINT`` |The native ``TINYINT`` type only supports | +| | |values between 0 and 255. Will be read back | +| | |as ``SMALLINT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARBINARY`` |``VARBINARY`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARCHAR`` |``VARCHAR`` | | ++-----------------+--------------------------------+---------------------------------------------+ Added: db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst?rev=1135031&view=auto ============================================================================== --- db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst (added) +++ db/ddlutils/trunk/src/site/sphinx/databases/sybase.rst Mon Jun 13 06:19:54 2011 @@ -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. + +.. _`SQL Server`: http://www.sybase.com/products/archivedproducts/sqlserver +.. _`Adaptive Server Enterprise`: http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise +.. _`Documentation search`: http://sybooks.sybase.com/nav/base.do +.. _`Documentation archive`: http://sybooks.sybase.com/nav/base.do?archive=1 + +Sybase +====== + +DdlUtils supports the Sybase products `SQL Server`_ from version 10.0 on, and +`Adaptive Server Enterprise`_ from version 11.5 on. The Sybase documentation for old versions +can be found in the `Documentation archive`_. The manuals for the current versions can be +found via the `Documentation search`_. + +Constraints +----------- + +Platform identifier + ``Sybase`` + +Recognized JDBC drivers + | ``com.sybase.jdbc2.jdbc.SybDriver`` + | ``com.sybase.jdbc.SybDriver`` + +Recognized JDBC sub protocols + ``jdbc:sybase:Tds`` + +Supports SQL comments + yes + +Supports delimited identifiers + yes + +Maximum identifier length + 28 + +Supports default values for ``LONG`` types + yes + +Supports non-unique indices + yes + +Supports non-primary key columns as identity columns + yes + +Allows ``INSERT``/``UPDATE`` statements to set values for identity columns + yes + +DdlUtils uses sequences for identity columns + no + +DdlUtils can read back the auto-generated value of an identity column + yes + +DdlUtils can create a database via JDBC + no + +DdlUtils can drop a database via JDBC + no + +Datatypes +--------- + ++-----------------+--------------------------------+---------------------------------------------+ +|JDBC Type |Database Type |Additional comments | ++=================+================================+=============================================+ +|``ARRAY`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIGINT`` |``DECIMAL(19,0)`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BINARY`` |``BINARY`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BIT`` |``SMALLINT`` |The native ``BIT`` type is rather limited | +| | |(cannot be NULL, cannot be indexed), hence | +| | |DdlUtils uses ``SMALLINT`` instead. Will be | +| | |read back as ``SMALLINT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``BLOB`` |``IMAGE`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``BOOLEAN`` |``SMALLINT`` |The native ``BIT`` type is rather limited | +| | |(cannot be NULL, cannot be indexed), hence | +| | |DdlUtils uses ``SMALLINT`` instead. Will be | +| | |read back as ``SMALLINT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``CHAR`` |``CHAR`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``CLOB`` |``TEXT`` |Will be read back as ``LONGVARCHAR`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATALINK`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DATE`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DECIMAL`` |``DECIMAL`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``DISTINCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``DOUBLE`` |``DOUBLE PRECISION`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``FLOAT`` |``DOUBLE PRECISION`` |Will be read back as ``FLOAT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``INTEGER`` |``INT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``JAVA_OBJECT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARBINARY``|``IMAGE`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``LONGVARCHAR`` |``TEXT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``NULL`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``NUMERIC`` |``NUMERIC`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``OTHER`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``REAL`` |``REAL`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``REF`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``SMALLINT`` |``SMALLINT`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``STRUCT`` |``IMAGE`` |Will be read back as ``LONGVARBINARY`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIME`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TIMESTAMP`` |``DATETIME`` |Will be read back as ``TIMESTAMP`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``TINYINT`` |``SMALLINT`` |The native ``TINYINT`` type only supports | +| | |values between 0 and 255. Will be read back | +| | |as ``SMALLINT`` | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARBINARY`` |``VARBINARY`` | | ++-----------------+--------------------------------+---------------------------------------------+ +|``VARCHAR`` |``VARCHAR`` | | ++-----------------+--------------------------------+---------------------------------------------+ Modified: db/ddlutils/trunk/src/site/sphinx/index.rst URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/site/sphinx/index.rst?rev=1135031&r1=1135030&r2=1135031&view=diff ============================================================================== --- db/ddlutils/trunk/src/site/sphinx/index.rst (original) +++ db/ddlutils/trunk/src/site/sphinx/index.rst Mon Jun 13 06:19:54 2011 @@ -26,4 +26,5 @@ DdlUtils documentation api-usage ant-tasks database-support + databases/index schema \ No newline at end of file