Set storage sql

hi
i want set storage to sql ( mysql )
but when i set sql for all storage only one table create in database and no data inserted to table ( table is empty) and the screen is black
i want get log of users in each room
i set this in config

    sql = { driver = "MySQL", database = "prosody", username = "root", password = "xxxx", host = "localhost" }
   storage = "sql"
1 Like