In-file control

There are two main control instructions (intended for SchemaLoader):

  • denoting Queries with -- QUERY START: and -- QUERY END: - each must be placed in own, separate file with the query being enclosed by the two of them, for example: 

    -- QUERY START:
call TigPutDBProperty('schema-version', '5.1');
-- QUERY END:

  • sourcing other file with -- LOAD FILE: <path to .sql file> - path must be on the same line, following control instruction, for example: 

    -- LOAD FILE: database/mysql-server-schema-7.0.0-schema.sql
Prev  Up  Next
  Home