Reuse Database Schema

[Stephan123]

Hello !

I created a database schema.

This database diagram I have an xml – file saved.

How can I resist using the schema ?

When i open the xml file 'File' -> 'Open'

I see the contents of the xml file.

How can I see the database schema ?

Your sincerly

Stephan

[peterlaursen]

Was this XML file created using the SQLyog 'Schema Designer' or some other program or just handwritten?

If the 'Schema Designer' was used then first open a Schema Designer tab. Once this is the active tab file..open will display the schema as graphics and not as text.

[peterlaursen]

see image.

[Stephan123]

Sorry

[Stephan123]

'Stephan123' wrote:

Hello !

Thanks for the answer.

In SQLYog i have one tab.

This tab is a 'schema designer' tab.

Now i open the xml file.

'File' -> 'Open'

A new query tab is open.

I see in this query tab the content of the xml file.

What is wrong ?

Here is the content of the xml file:

---

Code:

db1154036-hotels

82
29
121
158
CREATE TABLE `board_types` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`properties_id` INT(11) NOT NULL COMMENT 'Verknüpfung zur Tabelle ''properties''',
`code` VARCHAR(10) DEFAULT NULL,
`name` VARCHAR(45) DEFAULT NULL,
`description` VARCHAR(45) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_board_types_properties1` (`properties_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COMMENT='Tabelle der Verpflegungstypen'

259
34
134
158
CREATE TABLE `boardtype_prices` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`date_from` DATE DEFAULT NULL,
`date_to` DATE DEFAULT NULL,
`amount` FLOAT DEFAULT NULL,
`board_types_id` INT(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_boardtype_prices_board_types1` (`board_types_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COMMENT='Wenn separate eine Verpflegung zugebucht wird'

---

Your sincerly

Stephan

[peterlaursen]

For me it works as I have described.

What is your program version? Are you using the TRIAL?

[Stephan123]

Hello !

Thanks for the help.

I have found the error.

The extension of the xml file was wrong.

The correct extension is 'schemaxml'.

In the moment i test the designer.

I miss two things.

Where can I see or enter the table information ?

Where I can highlight areas of color ?

Your sincerly

Stephan

[peterlaursen]

1) Where can I see or enter the table information ?

Right-click in the canvas .. add table to bild a new table and right-click on an existing table .. alter table to see and edit parameters for an existing table.

2) Where I can highlight areas of color ?

Not possible. I have added to here: http://code.google.com/p/sqlyog/issues/detail?id=1642

[Stephan123]

Hello !

I've tried changing the comments.

The change of column comments worked.

Where can I see table comment ?

And where can i edit the table comment ?

In the moment i see the column comments in the 'query editor' -> 'info' .

I have a dream …

Is there a way to see the comments for the columns and the table in the

schema designer.

Here a little image.

Your sincerly

Stephan[attachment=1630:table.jpg]

[peterlaursen]

Alter table .. 'advanced' option.

This is the same whether you use Schema designer or not.

[Author]

Posts