svn commit - mysqldoc@docsrva: r3494 - trunk/workbench

[plavin]

Author: plavin
Date: 2006-09-28 18:30:18 +0200 (Thu, 28 Sep 2006)
New Revision: 3494

Log:
start adding indices section

Modified:
   trunk/workbench/using.xml


Modified: trunk/workbench/using.xml
===================================================================
--- trunk/workbench/using.xml	2006-09-28 14:33:47 UTC (rev 3493)
+++ trunk/workbench/using.xml	2006-09-28 16:30:18 UTC (rev 3494)
Changed blocks: 2, Lines Added: 64, Lines Deleted: 3; 2206 bytes

@@ -34,7 +34,7 @@
 
     <para>
       However, to create a new schema right-click in the
-      <literal>Schemata</literal>. Choose the <literal>Create MySQL
+      <literal>Schemata</literal> tab. Choose the <literal>Create MySQL
       Schema</literal> option. This will create a schema called
       <literal>New Schema</literal> in the <literal>Object
       Tree</literal>.

@@ -204,8 +204,69 @@
 
       <title>Adding Indices</title>
 
-      <para></para>
-
+      <para>
+        To add an index, right click a table and choose
+        the <literal>Edit</literal> option.  This will open
+        the table edit window below the 
+        <literal>Main View</literal> tab.
+        Choose the <literal>indices</literal> tab.
+      </para>
+      
+      <para>
+        This will open a horizontally split screen, showing any existing
+        indices in the top half and the index properties in the lower half.
+      </para>
+      
+      <para>
+        To create a new index, double click  the 
+        <literal>Index Name</literal> column of an empty row
+        in the upper half of the table edit window and enter an appropriate name.
+      </para>
+      
+      <para>
+        Double clicking the <literal>Type</literal> column
+        and choose an index type from the drop down box. 
+        You may choose from:
+      </para>
+      
+      <itemizedlist>
+        
+        <listitem>
+          <para>
+            INDEX
+          </para>
+        </listitem>
+        
+        <listitem>
+          <para>
+            PRIMARY
+          </para>
+        </listitem>
+        
+        <listitem>
+          <para>
+            UNIQUE
+          </para>
+        </listitem>
+        
+        <listitem>
+          <para>
+            FULL TEXT
+          </para>
+        </listitem>
+        
+        <listitem>
+          <para>
+            SPACIAL
+          </para>
+        </listitem>
+              
+      </itemizedlist>
+      
+      <para>
+        
+      </para>
+      
     </section>
 
     <section>