svn commit - mysqldoc@docsrva: r10242 - in trunk: . refman-6.0

[paul]

Author: paul
Date: 2008-03-14 20:59:25 +0100 (Fri, 14 Mar 2008)
New Revision: 10242

Log:
 r30001@frost:  paul | 2008-03-14 14:39:44 -0500
 Reformat create table statements (less bleed into TOC), cap keywords.


Modified:
   trunk/refman-6.0/se-falcon-core.xml
   trunk/refman-6.0/sql-syntax.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29996
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30059
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:30001
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30059


Modified: trunk/refman-6.0/se-falcon-core.xml
===================================================================
--- trunk/refman-6.0/se-falcon-core.xml	2008-03-14 19:57:01 UTC (rev 10241)
+++ trunk/refman-6.0/se-falcon-core.xml	2008-03-14 19:59:25 UTC (rev 10242)
Changed blocks: 2, Lines Added: 26, Lines Deleted: 6; 2123 bytes

@@ -851,27 +851,47 @@
       <literal>CREATE TABLE</literal> statement:
     </para>
 
-<programlisting>CREATE TABLE names (id INT, fname VARCHAR (20), lname VARCHAR (20)) ENGINE=Falcon</programlisting>
+<programlisting>
+CREATE TABLE names (
+    id    INT,
+    fname VARCHAR (20),
+    lname VARCHAR (20)
+) ENGINE=Falcon</programlisting>
 
     <para>
       Indexes can be created using all of the standard methods; for
       example you can explicitly specify an index on a column:
     </para>
 
-<programlisting>CREATE TABLE ids (id int, index (id)) ENGINE=Falcon</programlisting>
+<programlisting>
+CREATE TABLE ids (
+    id INT,
+    INDEX (id)
+) ENGINE=Falcon</programlisting>
 
     <para>
       Generate one as part of a primary key:
     </para>
 
-<programlisting>CREATE TABLE ids (id int),PRIMARY KEY (id) ENGINE=Falcon</programlisting>
+<programlisting>
+CREATE TABLE ids (
+    id INT,
+    PRIMARY KEY (id)
+) ENGINE=Falcon</programlisting>
 
     <para>
       Or you can create multi-key and multiple indexes:
     </para>
 
-<programlisting>CREATE TABLE t1 (id int NOT NULL,id2 int NOT NULL,id3 int NOT NULL,
-name CHAR(30),primary key (id,id2),index index_id3 (id3)) ENGINE=Falcon</programlisting>
+<programlisting>
+CREATE TABLE t1 (
+    id   INT NOT NULL,
+    id2  INT NOT NULL,
+    id3  INT NOT NULL,
+    name CHAR(30),
+    PRIMARY KEY (id,id2),
+    INDEX index_id3 (id3)
+) ENGINE=Falcon</programlisting>
 
     <para>
       To create a table within a specific tablespace, add the

@@ -903,7 +923,7 @@
 
     <note>
       <para>
-        In MySQL 6.0.3 and earleir, creating a tablespace with the same
+        In MySQL 6.0.3 and earlier, creating a tablespace with the same
         name would produce an error. Also, when dropping a file
         associated with a tablespace, the file itself is not physically
         deleted from the filesystem. In either case the error returned


Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml	2008-03-14 19:57:01 UTC (rev 10241)
+++ trunk/refman-6.0/sql-syntax.xml	2008-03-14 19:59:25 UTC (rev 10242)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 506 bytes

@@ -1929,7 +1929,7 @@
 </programlisting>
 
       <para>
-        This statement can be used either to add a new data file, or to
+        This statement can be used either to add a new data file to or 
         drop a data file from a tablespace.
       </para>