Doc: Fix most qdoc errors in QtSql.

- Move 2 images from qtdoc.
- Add "make docs" command for qtsql
- Fix qdoc command usage errors.

Change-Id: Id2f0548d09ed8f77b2317863d443c19d1cccdd83
Reviewed-by: Lars Knoll <lars.knoll@nokia.com>

1 files changed, 570 insertions, 0 deletions

diff --git a/src/sql/doc/src/qsqldatatype-table.qdoc b/src/sql/doc/src/qsqldatatype-table.qdoc
new file mode 100644
index 0000000000..a7e03cf28f
--- /dev/null
+++ b/src/sql/doc/src/qsqldatatype-table.qdoc
@@ -0,0 +1,570 @@
+/****************************************************************************
+**
+** Copyright (C) 2012 Nokia Corporation and/or its subsidiary(-ies).
+** Contact: http://www.qt-project.org/
+**
+** This file is part of the documentation of the Qt Toolkit.
+**
+** $QT_BEGIN_LICENSE:FDL$
+** GNU Free Documentation License
+** Alternatively, this file may be used under the terms of the GNU Free
+** Documentation License version 1.3 as published by the Free Software
+** Foundation and appearing in the file included in the packaging of
+** this file.
+**
+** Other Usage
+** Alternatively, this file may be used in accordance with the terms
+** and conditions contained in a signed written agreement between you
+** and Nokia.
+**
+**
+**
+**
+**
+** $QT_END_LICENSE$
+**
+****************************************************************************/
+
+/*!
+  \page sql-types.html
+  \title Data Types for Qt-supported Database Systems
+  \brief Recommended data types for database systems
+  
+  \ingroup qt-sql
+
+  \section1 Recommended Data Types for Qt-Supported Database Systems
+
+  This table shows the recommended data types for extracting data from
+  the databases supported in Qt. Note that types used in Qt are not
+  necessarily valid as input types to a specific database
+  system. e.g., A double might work perfectly as input for floating
+  point records in a particular database, but not necessarily as a
+  storage format for output from that database, because it would be
+  stored with 64-bit precision in C++.
+
+  \tableofcontents
+
+  \section2 IBM DB2 Data Types
+
+  \table 90%
+    \header
+        \li IBM DB2 data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li SMALLINT
+        \li 16-bit signed integer
+        \li typedef qint16
+    \row
+        \li INTEGER
+        \li 32-bit signed integer
+        \li typedef qint32
+    \row
+        \li BIGINT
+        \li 64-bit signed integer
+        \li typedef qint64
+    \row
+        \li REAL
+        \li 32-bit Single-precision floating point
+        \li By default mapping to QString
+    \row
+        \li DOUBLE PRECISION
+        \li 64-bit Double-precision floating point
+        \li By default mapping to QString
+    \row
+        \li FLOAT
+        \li 64-bit Double-precision floating point
+        \li By default mapping to QString
+    \row
+        \li CHAR
+        \li Fixed-length, null-terminated character string
+        \li Mapped to QString
+    \row
+        \li VARCHAR
+        \li Null-terminated varying length string
+        \li Mapped to QString
+    \row
+        \li LONG VARCHAR
+        \li Not null-terminated varying length character string
+        \li Mapped to QString
+    \row
+        \li BLOB
+        \li Not null-terminated varying binary string with 4-byte string
+        length indicator
+        \li Mapped to QByteArray
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li DATE
+        \li Null-terminated character string of the following format:
+        yyyy-mm-dd
+        \li Mapped to QDate
+    \row
+        \li TIME
+        \li Null-terminated character string of the following format: hh.mm.ss
+        \li Mapped to QTime
+    \row
+        \li TIMESTAMP
+        \li Null-terminated character string of the following format: yyyy-mm-dd-hh.mm.ss.nnnnnn
+        \li Mapped to QDateTime
+  \endtable
+
+  \section2 Borland InterBase Data Types
+
+  \table 90%
+    \header
+        \li Borland InterBase data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li BOOLEAN
+        \li Boolean
+        \li bool
+    \row
+        \li TINYINT
+        \li 8 bit signed integer
+        \li typedef qint8
+    \row
+        \li SMALLINT
+        \li 16-bit signed integer
+        \li typedef qint16
+    \row
+        \li INTEGER
+        \li 32-bit signed integer
+        \li typedef qint32
+    \row
+        \li BIGINT LONG
+        \li 64-bit signed integer
+        \li typedef qint64
+    \row
+        \li REAL FLOAT
+        \li 32-bit floating point
+        \li By default mapping to QString
+    \row
+        \li FLOAT
+        \li 64-bit floating point
+        \li By default mapping to QString
+    \row
+        \li DOUBLE
+        \li 64-bit floating point
+        \li By default mapping to QString
+    \row
+        \li DOUBLE PRECISION
+        \li 64-bit Double-precision floating point
+        \li By default mapping to QString
+    \row
+        \li VARCHAR STRING
+        \li Character string, Unicode
+        \li Mapped to QString
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li DATE
+        \li Displays date. Format: 'yyyy-mm-dd'
+        \li Mapped to QDate
+    \row
+        \li TIME
+        \li Displays time. Format is 'hh:mm:ss' in 24-hour format
+        \li Mapped to QTime
+    \row
+        \li TIMESTAMP
+        \li Displays a timestamp. Format is 'yyyy-mm-dd hh:mm:ss'
+        \li Mapped to QDateTime
+  \endtable
+
+  \section2 MySQL Data Types
+
+  \table 90%
+    \header
+        \li MySQL data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li TINYINT
+        \li 8 bit signed integer
+        \li typedef qint8
+    \row
+        \li TINYINT UNSIGNED
+        \li 8 bit unsigned integer
+        \li typedef quint8
+    \row
+        \li SMALLINT
+        \li 16-bit signed integer
+        \li typedef qint16
+    \row
+        \li SMALLINT UNSIGNED
+        \li 16-bit unsigned integer
+        \li typedef quint16
+    \row
+        \li INT
+        \li 32-bit signed integer
+        \li typedef qint32
+    \row
+        \li INT UNSIGNED
+        \li 32-bit unsigned integer
+        \li typedef quint32
+    \row
+        \li BIGINT
+        \li 64-bit signed integer
+        \li typedef qint64
+    \row
+        \li FLOAT
+        \li 32-bit Floating Point
+        \li By default mapping to QString
+    \row
+        \li DOUBLE
+        \li 64-bit Floating Point
+        \li By default mapping to QString
+    \row
+        \li CHAR
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li VARCHAR
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li TINYTEXT
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li TEXT
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li MEDIUMTEXT
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li LONGTEXT
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li all BLOB types
+        \li BLOB
+        \li Mapped to QByteArray
+    \row
+        \li DATE
+        \li Date without Time
+        \li Mapped to QDate
+    \row
+        \li DATETIME
+        \li Date and Time
+        \li Mapped to QDateTime
+    \row
+        \li TIMESTAMP
+        \li Date and Time
+        \li Mapped to QDateTime
+    \row
+        \li TIME
+        \li Time
+        \li Mapped to QTime
+    \row
+        \li YEAR
+        \li Year (int)
+        \li Mapped to QDateTime
+    \row
+        \li ENUM
+        \li Enumeration of Value Set
+        \li Mapped to QString
+  \endtable
+
+  \section2 Oracle Call Interface Data Types
+
+  \table 90%
+    \header
+        \li Oracle Call Interface data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li NUMBER
+        \li FLOAT, DOUBLE, PRECISIONc REAL
+        \li By default mapping to QString
+    \row
+        \li NUMBER(38)
+        \li INTEGER INT SMALLINT
+        \li typedef qint8/16/32/64
+    \row
+        \li NUMBER(p,s)
+        \li NUMERIC(p,s) DECIMAL(p,s)a
+        \li By default mapping to QString
+    \row
+        \li NVARCHAR2(n)
+        \li Character string (NATIONAL CHARACTER VARYING(n) NATIONAL
+        CHAR VARYING(n) NCHAR VARYING(n))
+        \li Mapped to QString
+    \row
+        \li NCHAR(n)
+        \li Character string (NATIONAL CHARACTER(n) NATIONAL CHAR(n)
+        NCHAR(n))
+    \li Mapped to QString
+    \row
+        \li CHAR(n)
+        \li Character string (CHARACTER(n) CHAR(n))
+        \li Mapped to QString
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li BLOB
+        \li A binary large object
+        \li Mapped to QByteArray
+    \row
+        \li TIMESTAMP
+        \li Year, month, and day values of date, as well as hour, minute,
+        and second values of time
+        \li Mapped to QDateTime
+  \endtable
+
+  \section2 ODBC Data Types
+
+  \table 90%
+    \header
+        \li ODBC data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li BIT
+        \li Boolean
+        \li BOOL
+    \row
+        \li TINYINT
+        \li 8 bit integer
+        \li typedef qint8
+    \row
+        \li SMALLINT
+        \li 16-bit signed integer
+        \li typedef qint16
+    \row
+        \li INTEGER
+        \li 32-bit signed integer
+        \li typedef qint32
+    \row
+        \li BIGINT
+        \li 64-bit signed integer
+        \li typedef qint64
+    \row
+        \li REAL
+        \li 32-bit Single-precision floating point
+        \li By default mapping to QString
+    \row
+        \li FLOAT
+        \li 64-bit Double floating point
+        \li By default mapping to QString
+    \row
+        \li DOUBLE
+        \li 64-bit Double floating point
+        \li By default mapping to QString
+    \row
+        \li CHAR
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li VARCHAR
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li LONGVARCHAR
+        \li Character string
+        \li Mapped to QString
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li DATE
+        \li Character string
+        \li Mapped to QDate
+    \row
+        \li TIME
+        \li Character Time, Character string
+        \li Mapped to QTime
+    \row
+        \li TIMESTAMP
+        \li Character Time, Character string
+        \li Mapped to QDateTime
+  \endtable
+
+  \section2 PostgreSQL Data Types
+
+  \table 90%
+    \header
+        \li PostgreSQL data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li BOOLEAN
+        \li Boolean
+        \li bool
+    \row
+        \li SMALLINT
+        \li 16-bit signed integer
+        \li typedef qint16
+    \row
+        \li INTEGER
+        \li 32-bit signed integer
+        \li typedef qint32
+    \row
+        \li BIGINT
+        \li 64-bit signed integer
+        \li typedef qint64
+    \row
+        \li REAL
+        \li 32-bit variable-precision floating point
+        \li By default mapping to QString
+    \row
+        \li DOUBLE PRECISION
+        \li 64-bit variable-precision floating point
+        \li By default mapping to QString
+    \row
+        \li DECIMAL VARIABLE
+        \li user-specified precision, exact
+        \li Mapped to QString
+    \row
+        \li NUMERIC VARIABLE
+        \li user-specified precision, exact
+        \li Mapped to QString
+    \row
+        \li VARCHAR
+        \li variable-length character string
+        \li Mapped to QString
+    \row
+        \li CHARACTER
+        \li Character string of fixed-length
+        \li Mapped to QString
+    \row
+        \li TEXT
+        \li Character string of variable-length
+        \li Mapped to QString
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li TIMESTAMP
+        \li 8 bytes, both date and time
+        \li Mapped to QDateTime
+    \row
+        \li TIMESTAMP
+        \li 8 bytes, both date and time, with time zone
+        \li Mapped to QDateTime
+    \row
+        \li DATE
+        \li 4 bytes, dates only
+        \li Mapped to QDate
+    \row
+        \li TIME
+        \li 8 bytes, times of day only 00:00:00.00 - 23:59:59.99
+        \li Mapped to QTime
+    \row
+        \li TIME
+        \li 12 bytes times of day only, with time zone 00:00:00.00+12
+        \li Mapped to QDateTime
+  \endtable
+
+  \section2 QSQLITE SQLite version 3 Data Types
+
+  \table 90%
+    \header
+        \li QSQLITE SQLite version 3 data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li NULL
+        \li NULL value.
+        \li NULL
+    \row
+        \li INTEGER
+        \li Signed integer, stored in 8, 16, 24, 32, 48, or 64-bits
+        depending on the magnitude of the value.
+        \li typedef qint8/16/32/64
+    \row
+        \li REAL
+        \li 64-bit floating point value.
+        \li By default mapping to QString
+    \row
+        \li TEXT
+        \li Character string (UTF-8, UTF-16BE or UTF-16-LE).
+        \li Mapped to QString
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li BLOB
+        \li The value is a BLOB of data, stored exactly as it was input.
+        \li Mapped to QByteArray
+  \endtable
+
+  \section2 Sybase Adaptive Server Data Types
+
+  \table 90%
+    \header
+        \li Sybase Adaptive Server data type
+        \li SQL type description
+        \li Recommended input (C++ or Qt data type)
+    \row
+        \li BINARY
+        \li Describes a fixed-length binary value up to 255 bytes in size.
+        \li Mapped to QByteArray
+    \row
+        \li CHAR
+        \li Character String
+        \li Mapped to QString
+    \row
+        \li DATETIME
+        \li Date and time. Range: 1753-01-01 00:00:00 through 9999-12-31 23:59:59.
+        \li Mapped to QDateTime
+    \row
+        \li NCHAR
+        \li Character String of fixed length
+        \li Mapped to QString
+    \row
+        \li NVARACHAR
+        \li Character String of variable length
+        \li Mapped to QString
+    \row
+        \li VARCHAR
+        \li Character String of fixed length
+        \li Mapped to QString
+    \row
+        \li CLOB
+        \li Character large string object
+        \li Mapped to QString
+    \row
+        \li TIMESTAMP
+        \li A unique number within a database
+        \li Mapped to QString
+    \row
+        \li SMALLDATETIME
+        \li Date and time. Range: 1900-01-01 00:00 through 2079-12-31 23:59
+        \li Mapped to QDateTime
+    \row
+        \li UNICHAR
+        \li Character String of fixed length.(Unicode)
+        \li Mapped to QString
+    \row
+        \li UNIVARCHAR
+        \li Character String of variable length.(Unicode)
+        \li Mapped to QString
+    \row
+        \li VARBINARY
+        \li Describes a variable-length binary value up to 255 bytes in size
+        \li Mapped to QByteArray
+  \endtable
+
+  \section2 SQLite Version 2
+
+  SQLite version 2 is "typeless". This means that you can store any kind of
+  data you want in any column of any table, regardless of the declared
+  data type of that column. We recommend that you map the data to QString.
+*/