SQL Migrations

Database changes can be automatically deployed during server startup or on demand using CloudIO CLI.

SQL scripts must be named in io_YYYYMMDDHHmmss_some_description.sql format and placed under the respective application migration folder. Any metadata scripts that create or alter the metadata tables in cloudio schema must be placed under cloudio folder.

Note: File name must be unique. Once migrated any further changes to the script will be ignored.