Levure Importing an existing schema

Import an existing database schema into the database YAML file

1. Open your Levure application in the LiveCode IDE.
2. In the message box call dbconn_connect.
3. In the message box call sqlyogadev_saveSchemaToYAML;put the result.

You will now find a schema.yml file in your ./app/database folder. It contains a YAML represenation of the database. If any errors occurred they will be reported in the message box due to the addition of ;put the result.

Updating the database schema if it is modified

If you modify the database schema in a 3rd party application you will need to update the schema.yml file.

1. Open your Levure application in the LiveCode IDE.
2. In the message box call dbconn_connect.
3. In the message box call dbsynch_schemaWithDatabase.
4. In the message box call sqlyogadev_saveSchemaToYAML;put the result.

The ./app/database/schema.yml file will now be updated to match your database schema.