Author: paul
Date: 2006-02-21 04:26:21 +0100 (Tue, 21 Feb 2006)
New Revision: 1413
Log:
r7999@frost: paul | 2006-02-20 21:25:36 -0600
Mark some non-standard tables and columns as such.
Eliminate some stylistic inconsistencies.
Modified:
trunk/
trunk/refman-5.1/information-schema.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7998
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3439
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7999
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3439
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2006-02-21 03:26:01 UTC (rev 1412)
+++ trunk/refman-5.1/information-schema.xml 2006-02-21 03:26:21 UTC (rev 1413)
@@ -584,7 +584,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -1067,7 +1067,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -1268,7 +1268,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -1361,7 +1361,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -1435,7 +1435,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -1536,7 +1536,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -1645,7 +1645,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -2157,7 +2157,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -2287,7 +2287,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -2755,7 +2755,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -2874,7 +2874,7 @@
</informaltable>
<para>
- Notes:
+ <emphasis role="bold">Notes</emphasis>:
</para>
<itemizedlist>
@@ -3317,16 +3317,11 @@
<listitem>
<para>
- This is a non-standard table.
+ The <literal>PLUGINS</literal> table is a non-standard table.
+ It was added in MySQL 5.1.5.
</para>
</listitem>
- <listitem>
- <para>
- The <literal>PLUGINS</literal> table was added in MySQL 5.1.5.
- </para>
- </listitem>
-
</itemizedlist>
<remark role="todo">
@@ -3403,16 +3398,11 @@
<listitem>
<para>
- This is a non-standard table.
+ The <literal>ENGINES</literal> table is a non-standard table.
+ It was added in MySQL 5.1.5.
</para>
</listitem>
- <listitem>
- <para>
- The <literal>ENGINES</literal> table was added in MySQL 5.1.5.
- </para>
- </listitem>
-
</itemizedlist>
<para>
@@ -3450,127 +3440,127 @@
<row>
<entry><literal>TABLE_CATALOG</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_SCHEMA</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PARTITION_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>SUBPARTITION_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PARTITION_ORDINAL_POSITION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>SUBPARTITION_ORDINAL_POSITION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PARTITION_METHOD</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>SUBPARTITION_METHOD</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PARTITION_EXPRESSION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>SUBPARTITION_EXPRESSION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PARTITION_DESCRIPTION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_ROWS</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>AVG_ROW_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>DATA_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>MAX_DATA_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>INDEX_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>DATA_FREE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CREATE_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>UPDATE_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CHECK_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CHECKSUM</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>PARTITION_COMMENT</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>NODEGROUP</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLESPACE_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -3584,8 +3574,8 @@
<listitem>
<para>
- The <literal>PARTITIONS</literal> table was added in MySQL
- 5.1.6.
+ The <literal>PARTITIONS</literal> table is a non-standard
+ table. It was added in MySQL 5.1.6.
</para>
</listitem>
@@ -3639,92 +3629,92 @@
<row>
<entry><literal>EVENT_CATALOG</literal></entry>
<entry/>
- <entry><literal>NULL</literal></entry>
+ <entry><literal>NULL</literal>, MySQL extension</entry>
</row>
<row>
<entry><literal>EVENT_SCHEMA</literal></entry>
<entry><literal>Db</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>EVENT_NAME</literal></entry>
<entry><literal>Name</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>DEFINER</literal></entry>
<entry><literal>Definer</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>EVENT_BODY</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>EVENT_TYPE</literal></entry>
<entry><literal>Type</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>EXECUTE_AT</literal></entry>
<entry><literal>Execute at</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>INTERVAL_VALUE</literal></entry>
<entry><literal>Interval value</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>INTERVAL_FIELD</literal></entry>
<entry><literal>Interval field</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>SQL_MODE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>STARTS</literal></entry>
<entry><literal>Starts</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>ENDS</literal></entry>
<entry><literal>Ends</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>STATUS</literal></entry>
<entry><literal>Status</literal></entry>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>ON_COMPLETION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CREATED</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>LAST_ALTERED</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>LAST_EXECUTED</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>EVENT_COMMENT</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -3738,6 +3728,13 @@
<listitem>
<para>
+ The <literal>EVENTS</literal> table is a non-standard table.
+ It was added in MySQL 5.1.6.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>EVENT_CATALOG</literal>: The value of this column is
always <literal>NULL</literal>.
</para>
@@ -4036,192 +4033,192 @@
<row>
<entry><literal>FILE_ID</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>FILE_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>FILE_TYPE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLESPACE_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_CATALOG</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_SCHEMA</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>LOGFILE_GROUP_NAME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>LOGFILE_GROUP_NUMBER</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>ENGINE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>FULLTEXT_KEYS</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>DELETED_ROWS</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>UPDATE_COUNT</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>FREE_EXTENTS</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TOTAL_EXTENTS</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>EXTENT_SIZE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>INITIAL_SIZE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>MAXIMUM_SIZE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>AUTOEXTEND_SIZE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CREATION_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>LAST_UPDATE_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>LAST_ACCESS_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>RECOVER_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TRANSACTION_COUNTER</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>VERSION</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>ROW_FORMAT</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>TABLE_ROWS</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>AVG_ROW_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>DATA_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>MAX_DATA_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>INDEX_LENGTH</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>DATA_FREE</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CREATE_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>UPDATE_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CHECK_TIME</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>CHECKSUM</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>STATUS</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
<row>
<entry><literal>EXTRA</literal></entry>
<entry/>
- <entry/>
+ <entry>MySQL extension</entry>
</row>
</tbody>
</tgroup>
@@ -4235,7 +4232,8 @@
<listitem>
<para>
- The <literal>FILES</literal> table was added in MySQL 5.1.6.
+ The <literal>FILES</literal> table is a non-standard table. It
+ was added in MySQL 5.1.6.
</para>
</listitem>
@@ -4325,8 +4323,8 @@
<listitem>
<para>
- The <literal>PROCESSLIST</literal> table was added in MySQL
- 5.1.7.
+ The <literal>PROCESSLIST</literal> table is a non-standard
+ table. It was added in MySQL 5.1.7.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1413 - in trunk: . refman-5.1 | paul | 21 Feb |
