Author: paul
Date: 2006-02-01 21:54:25 +0100 (Wed, 01 Feb 2006)
New Revision: 1173
Log:
r2775@kite-hub: paul | 2006-02-01 14:52:54 -0600
Add framework for EVENTS table description.
Modified:
trunk/
trunk/refman-5.1/information-schema.xml
trunk/refman-common/titles.en.ent
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7026
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2773
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7026
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2775
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2006-02-01 20:44:54 UTC (rev 1172)
+++ trunk/refman-5.1/information-schema.xml 2006-02-01 20:54:25 UTC (rev 1173)
@@ -3622,11 +3622,150 @@
</itemizedlist>
<remark role="todo">
- Add xref to SHOW PARTITIONS when that is implemented.
+ Add xref to SHOW PARTITIONS when that is documented.
</remark>
</section>
+ <section id="events-table">
+
+ <title>&title-events-table;</title>
+
+ <indexterm type="function">
+ <primary>EVENTS</primary>
+ <secondary>INFORMATION_SCHEMA table</secondary>
+ </indexterm>
+
+ <para>
+ The <literal>EVENTS</literal> table provides information about
+ event scheduler events.
+ </para>
+
+ <informaltable>
+ <tgroup cols="3">
+ <colspec colwidth="40*"/>
+ <colspec colwidth="30*"/>
+ <colspec colwidth="30*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold">Remarks</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>EVENT_CATALOG</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>EVENT_SCHEMA</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>EVENT_NAME</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>DEFINER</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>EVENT_BODY</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>EVENT_TYPE</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>EXECUTE_AT</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>INTERVAL_VALUE</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>INTERVAL_FIELD</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>SQL_MODE</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>STARTS</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>ENDS</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>STATUS</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>ON_COMPLETION</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>CREATED</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>LAST_ALTERED</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>LAST_EXECUTED</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>EVENT_COMMENT</literal></entry>
+ <entry/>
+ <entry/>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ <para>
+ <emphasis role="bold">Notes</emphasis>:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>EVENTS</literal> table was added in MySQL 5.1.6.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <remark role="todo">
+ Add xref to SHOW EVENTS when that is documented.
+ </remark>
+
+ </section>
+
<section id="other-information-schema-tables">
<title>&title-other-information-schema-tables;</title>
@@ -3700,6 +3839,7 @@
| COLUMNS |
| COLUMN_PRIVILEGES |
| ENGINES |
+| EVENTS |
| KEY_COLUMN_USAGE |
| PARTITIONS |
| PLUGINS |
Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent 2006-02-01 20:44:54 UTC (rev 1172)
+++ trunk/refman-common/titles.en.ent 2006-02-01 20:54:25 UTC (rev 1173)
@@ -357,6 +357,7 @@
<!ENTITY title-errors-in-4-0 "Issues in MySQL 4.0 Fixed in a Later Version">
<!ENTITY title-errors-in-4-1 "Issues in MySQL 4.1 Fixed in a Later Version">
<!ENTITY title-estimating-performance "Estimating Query Performance">
+<!ENTITY title-events-table "The <literal>INFORMATION_SCHEMA EVENTS</literal> Table">
<!ENTITY title-example-auto-increment "Using <literal>AUTO_INCREMENT</literal>">
<!ENTITY title-example-foreign-keys "Using Foreign Keys">
<!ENTITY title-example-maximum-column "The Maximum Value for a Column">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1173 - in trunk: . refman-5.1 refman-common | paul | 1 Feb |
