Author: plavin
Date: 2007-11-13 23:22:43 +0100 (Tue, 13 Nov 2007)
New Revision: 8699
Log:
Reformat, minor changes
Modified:
trunk/workbench-pro/tutorial.xml
Modified: trunk/workbench-pro/tutorial.xml
===================================================================
--- trunk/workbench-pro/tutorial.xml 2007-11-13 21:47:40 UTC (rev 8698)
+++ trunk/workbench-pro/tutorial.xml 2007-11-13 22:22:43 UTC (rev 8699)
Changed blocks: 5, Lines Added: 64, Lines Deleted: 41; 6299 bytes
@@ -9,8 +9,11 @@
<title>&workbench_pro; Tutorials</title>
- <para>
- <remark>Intro para?</remark>
+ <para>
+ <remark>
+ Intro para?
+ </remark>
+
Importing an SQL data definition script is a quick way to
familiarize yourself with &workbench;. For this purpose, use the
sakila database script found in the <literal>Example
@@ -24,11 +27,12 @@
<para>
After downloading the sakila file, extract it to a convenient
- location. Open &workbench; and find the <guimenuitem>Reverse Engineer MySQL
- Create Script</guimenuitem> menu option by first selecting
- <guimenu>File</guimenu> and then <guimenu>Import</guimenu>. Find
- and import the <filename>sakila-schema.sql</filename> file. This
- is the script that contains the data definition statements for the
+ location. Open &workbench; and find the <guimenuitem>Reverse
+ Engineer MySQL Create Script</guimenuitem> menu option by first
+ selecting <guimenu>File</guimenu> and then
+ <guimenu>Import</guimenu>. Find and import the
+ <filename>sakila-schema.sql</filename> file. This is the script
+ that contains the data definition statements for the
<literal>sakila</literal> database. The file filter for the file
open dialog window defaults to <literal>*.sql</literal> so you
should only be able to view files with the <literal>sql</literal>
@@ -47,8 +51,8 @@
<para>
Yo may also wish to remove the default schema tab,
<literal>mydb</literal>. Do this by selecting this tab and then
- clicking the <guibutton>-</guibutton> button to on the upper right in
- the <guilabel>Physical Schemata</guilabel> panel.
+ clicking the <guibutton>-</guibutton> button to on the upper right
+ in the <guilabel>Physical Schemata</guilabel> panel.
</para>
<para>
@@ -65,44 +69,47 @@
<literal>sakila</literal> datababase should be visible. Tables
appear at the top followed by views and then routines. There are
no routine groups in this schema, but you should see the
- <guilabel>Routine Groups</guilabel> section and an
- <literal>Add Group</literal> icon.
+ <guilabel>Routine Groups</guilabel> section and an <literal>Add
+ Group</literal> icon.
</para>
-
+
<section id="wbpro-creating-eer-diagram">
+
<title>Adding an EER Diagram</title>
-
+
<para>
- To create an EER diagram for the sakila database, first add
- an EER diagram by double clicking the <literal>Add Diagram</literal>
- icon in the <guilabel>EER Diagrams</guilabel> panel. This should open
- the <literal>EER Diagram</literal> canvas.
- <remark>How to get there otherwise</remark>
+ To create an EER diagram for the sakila database, first add an
+ EER diagram by double clicking the <literal>Add
+ Diagram</literal> icon in the <guilabel>EER Diagrams</guilabel>
+ panel. This should open the <literal>EER Diagram</literal>
+ canvas.
+
+ <remark>
+ How to get there otherwise
+ </remark>
</para>
-
+
<para>
- The <literal>EER Diagram</literal> canvas is where
- where object modelling takes place. To add a table to the
- canvas, select the <guilabel>Catalog</guilabel> tab
- in the middle panel on the right side of the application.
- This should display any schemata that appear in
- the <guilabel>MySQL Model</guilabel> tab.
+ The <literal>EER Diagram</literal> canvas is where where object
+ modelling takes place. To add a table to the canvas, select the
+ <guilabel>Catalog</guilabel> tab in the middle panel on the
+ right side of the application. This should display any schemata
+ that appear in the <guilabel>MySQL Model</guilabel> tab.
</para>
-
+
<para>
- Find the sakila schema and expand the view of its objects
- by clicking the <guibutton>+</guibutton> button
- to the left of the schema name. Expand the tables list
- in the same way.
+ Find the sakila schema and expand the view of its objects by
+ clicking the <guibutton>+</guibutton> button to the left of the
+ schema name. Expand the tables list in the same way.
</para>
-
+
<para>
- You can add tables to the EER canvas by picking them up from
- the <guilabel>Catalog</guilabel> panel and placing them on
- the canvas. Drop the <literal>address</literal> table and
- the <literal>city</literal> table onto the canvas.
+ You can add tables to the EER canvas by picking them up from the
+ <guilabel>Catalog</guilabel> panel and placing them on the
+ canvas. Drop the <literal>address</literal> table and the
+ <literal>city</literal> table onto the canvas.
</para>
-
+
<figure>
<title>Adding tables to the canvas</title>
<mediaobject>
@@ -114,13 +121,29 @@
</textobject>
</mediaobject>
</figure>
-
+
<para>
-
+ &workbench; automatically discovers that
+ <literal>address.city_id</literal> has been defined as a foreign
+ key referencing the <literal>city.city_id</literal> field. Drop
+ the <literal>country</literal> table onto the canvas and
+ immediately you should see the relationship between the
+ <literal>country</literal> table and the <literal>city</literal>
+ table.
</para>
-
- </section>
-
+
+ <para>
+ Choose the properties tab of the panel on the lower right and
+ then click one of the tables on the canvas. This displays the
+ properties of the table in the <literal>Properties</literal>
+ window. While a table is selected you can use the
+ <literal>Properties</literal> window to change a tables
+ properties. For example, entering <literal>#FF0000</literal> for
+ the color value will change the color accent to red.
+ </para>
+
+ </section>
+
</section>
<section id="wbpro-basic-modeling">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8699 - trunk/workbench-pro | plavin | 13 Nov |
