Movatterモバイル変換

9.1.6.2.1 Adding Routine Groups to the Physical Schemata

9.1.6.2.2 Adding Routine Groups to an EER Diagram

9.1.6.2.3 The Routine Group Editor

Double-clicking theAdd Routine Group icon in thePhysical Schemata section of theMySQL Model page adds a routine group with the default name ofroutines1. If a routine group with this name already exists, the new routine group is namedroutines2.

Adding a new routine group automatically opens the routine groups editor docked at the bottom of the application. For information about using the routine groups editor, seeSection 9.1.6.2.3, “The Routine Group Editor”.

Right-clicking a routine group opens a pop-up menu with the following items:

TheEdit Routine Group item opens the routine group editor, which is described inSection 9.1.6.2.3, “The Routine Group Editor”.

The cut and paste items are useful for copying routine groups between different schemata.

Deleting a routine group from theMySQL Model page removes the group but does not remove any routines contained in that group.

Any routine groups added to thePhysical Schemata also show up in theCatalog palette on the right side of the application. They may be added to an EER diagram by dragging and dropping them from this palette.

To add routine groups to an EER Diagram, use theRoutine Groups tool on the vertical toolbar. Make sure that theEER Diagram tab is selected, then right-click the routine groups icon on the vertical toolbar. The routine groups icon is immediately above the lowest toolbar separator.

Clicking the mouse on this icon changes the mouse pointer to a routine group pointer. You can also change the mouse pointer to a routine pointer by pressing theG key.

Choosing theRoutine Group tool changes the contents of the toolbar that appears immediately below the menu bar. When theRoutine Groups pointer is active, this toolbar contains a schemata list and a color chart list. Use these lists to select the appropriate schema and color accent for the new routine group. Make sure that you associate the new routine group with a database. The color of your routine group can be changed later using theProperties palette.

Create a routine group by clicking anywhere on the EER Diagram canvas. This creates a new routine group with the default nameroutines1. To revert to the default mouse pointer, click the arrow icon at the top of the vertical toolbar.

Right-clicking a routine group opens a pop-up menu. With the exception of the delete option and rename options, these menu options function as described inSection 9.1.6.2.1, “Adding Routine Groups to the Physical Schemata”. There is no rename option, and the behavior of the delete option is determined by your MySQL Workbench options settings. For more information, seeSection 3.2.4, “Modeling Preferences”.

To invoke the routine group editor, double-click a routine group object on the EER Diagram canvas or double-click a routine group in thePhysical Schemata section on theMySQL Model page. This opens the routine group editor docked at the bottom of the application. Double-clicking the title bar undocks the editor. Do the same to redock it. Any number of routine groups may be open at the same time. Each additional routine group appears as a tab at the top of the routine editor,

Routine group andPrivileges tabs appear at the bottom of the routine editor. Navigate between different tabs using the mouse or from the keyboard by pressingControl+Alt+Tab.