How to auto define schema using Docker Compose

[Skada13]

Hi, what is the best way to auto define schema using Docker Compose?

Here'is a part of my compose file where the surreal service is running:

surrealdb:
    image: surrealdb/surrealdb:latest
    container_name: surrealdb
    ports:
      - 8000:8000
    volumes:
      - ./database:/database
    command: start --log debug --user root --pass root rocksdb:/database

I'd like to create a namespace, a database, and necessary tables (if they don't exist of course), but I don't know how I can do that.

I have an example of init.surql file that describes what I need to define on start of the service:

-- init.surql

DEFINE NAMESPACE IF NOT EXISTS test_namespace;

USE NS test_namespace;

DEFINE DATABASE IF NOT EXISTS test_database;

USE DB test_database;

DEFINE TABLE IF NOT EXISTS users SCHEMAFULL;
DEFINE FIELD name ON TABLE users TYPE string;
DEFINE FIELD email ON TABLE users TYPE string;

DEFINE TABLE IF NOT EXISTS teams SCHEMAFULL;
DEFINE FIELD name ON TABLE teams TYPE string;

DEFINE FIELD users ON TABLE teams TYPE array<record<users>>;

[Skada13]

Well, I found the answer in SurrealDB Discord community: I need to pass the init.surql via command --import-file with start command.