svn commit - mysqldoc@docsrva: r909 - in trunk: refman-4.1 refman-5.0 refman-5.1

[mhillyer]

Author: mhillyer
Date: 2006-01-18 22:30:47 +0100 (Wed, 18 Jan 2006)
New Revision: 909

Log:
Fix error in sample CREATE TABLE statements.

Modified:
   trunk/refman-4.1/data-types.xml
   trunk/refman-5.0/data-types.xml
   trunk/refman-5.1/data-types.xml

Modified: trunk/refman-4.1/data-types.xml
===================================================================
--- trunk/refman-4.1/data-types.xml	2006-01-18 21:11:43 UTC (rev 908)
+++ trunk/refman-4.1/data-types.xml	2006-01-18 21:30:47 UTC (rev 909)
@@ -3396,7 +3396,7 @@
         </para>
 
 <programlisting>
-CREATE TABLE t (ts NULL DEFAULT CURRENT_TIMESTAMP);
+CREATE TABLE t (ts TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP);
 </programlisting>
 
         <para>
@@ -3406,8 +3406,8 @@
         </para>
 
 <programlisting>
-CREATE TABLE t1 (ts NULL DEFAULT NULL);
-CREATE TABLE t2 (ts NULL DEFAULT '0000-00-00 00:00:00');
+CREATE TABLE t1 (ts TIMESTAMP NULL DEFAULT NULL);
+CREATE TABLE t2 (ts TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00');
 </programlisting>
 
         <para>

Modified: trunk/refman-5.0/data-types.xml
===================================================================
--- trunk/refman-5.0/data-types.xml	2006-01-18 21:11:43 UTC (rev 908)
+++ trunk/refman-5.0/data-types.xml	2006-01-18 21:30:47 UTC (rev 909)
@@ -3101,7 +3101,7 @@
         </para>
 
 <programlisting>
-CREATE TABLE t (ts NULL DEFAULT CURRENT_TIMESTAMP);
+CREATE TABLE t (ts TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP);
 </programlisting>
 
         <para>
@@ -3111,8 +3111,8 @@
         </para>
 
 <programlisting>
-CREATE TABLE t1 (ts NULL DEFAULT NULL);
-CREATE TABLE t2 (ts NULL DEFAULT '0000-00-00 00:00:00');
+CREATE TABLE t1 (ts TIMESTAMP NULL DEFAULT NULL);
+CREATE TABLE t2 (ts TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00');
 </programlisting>
 
         <para>

Modified: trunk/refman-5.1/data-types.xml
===================================================================
--- trunk/refman-5.1/data-types.xml	2006-01-18 21:11:43 UTC (rev 908)
+++ trunk/refman-5.1/data-types.xml	2006-01-18 21:30:47 UTC (rev 909)
@@ -2992,7 +2992,7 @@
         </para>
 
 <programlisting>
-CREATE TABLE t (ts NULL DEFAULT CURRENT_TIMESTAMP);
+CREATE TABLE t (ts TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP);
 </programlisting>
 
         <para>
@@ -3002,8 +3002,8 @@
         </para>
 
 <programlisting>
-CREATE TABLE t1 (ts NULL DEFAULT NULL);
-CREATE TABLE t2 (ts NULL DEFAULT '0000-00-00 00:00:00');
+CREATE TABLE t1 (ts TIMESTAMP NULL DEFAULT NULL);
+CREATE TABLE t2 (ts TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00');
 </programlisting>
 
         <para>