Genie framework/SearchLight.Migration problem creating composed primary key

New to Julia
1

Hello!

I am setting up GenieAuthorisation within a Genie App, I am setting up the 4 tables:

  • CreateTableRoles
  • CreateTablePermissions
  • CreateTableRolesUsers
  • CreateTablePermissionsRoles

within my module CreateTableRolesUsers, I want to declare a composed primary_key … I have tried different options, but nothing has worked so far, further more I get the Warning:

WARNING: could not import Migration.add_foreign_key into CreateTableRolesUsers

module CreateTableRolesUsers, looks like:

module CreateTableRolesUsers

import SearchLight.Migrations: create_table, column, primary_key, add_index, drop_table, add_foreign_key

function up()
  create_table(:rolesusers) do
    [
      column(:user_id, :string)
      column(:role_id, :integer) 
      primary_key([:user_id, :role_id])
    ]
  end

  add_foreign_key(:role_id, :roles, on_delete = :cascade)

  add_index(:rolesusers, :role_id)
  add_index(:rolesusers, :user_id)
end

function down()
  drop_table(:rolesusers)
end

end

and the error I get is:

julia> CreateTableRolesUsers.up()
ERROR: MethodError: no method matching column_id(::Vector{Symbol})

Closest candidates are:
  column_id()
   @ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:350
  column_id(::Union{String, Symbol})
   @ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:350
  column_id(::Union{String, Symbol}, ::Union{String, Symbol})
   @ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:350

Stacktrace:
 [1] (::Main.CreateTableRolesUsers.var"#1#2")()
   @ Main.CreateTableRolesUsers /Users/ANHERN1/Documents/amh/EstadisticaProbabilidad/genie_workspace/project-sim/sim/db/migrations/2021061519532446_create_table_roles_users.jl:7
 [2] create_table_sql(f::Main.CreateTableRolesUsers.var"#1#2", name::String, options::String)
   @ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:336
 [3] create_table(f::Function, name::Symbol, options::String)
   @ SearchLightSQLite ~/.julia/packages/SearchLightSQLite/9yRol/src/SearchLightSQLite.jl:329
 [4] up()
   @ Main.CreateTableRolesUsers /Users/ANHERN1/Documents/amh/EstadisticaProbabilidad/genie_workspace/project-sim/sim/db/migrations/2021061519532446_create_table_roles_users.jl:6
 [5] top-level scope
   @ REPL[125]:1

Any suggestions?
Thank you very much!