Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Reuse Database Schema

forums forums SQLyog Query Builder and Schema Designer Reuse Database Schema

  • This topic is empty.
Viewing 9 reply threads
  • Author
    Posts
    • #12436
      Stephan123
      Member

      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

    • #32596
      peterlaursen
      Participant

      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.

    • #32597
      peterlaursen
      Participant

      see image.

    • #32598
      Stephan123
      Member

      Sorry

    • #32599
      Stephan123
      Member
      '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

    • #32600
      peterlaursen
      Participant

      For me it works as I have described.

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

    • #32601
      Stephan123
      Member

      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

    • #32602
      peterlaursen
      Participant

      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

    • #32603
      Stephan123
      Member

      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]

    • #32604
      peterlaursen
      Participant

      Alter table .. 'advanced' option.

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

Viewing 9 reply threads
  • You must be logged in to reply to this topic.