# Import the panel/daemon MySQL schema and updates
ruby_block "import_schema" do
  block do
    ["panel", "daemon"].each do |db|
      i = 1
      sql = "#{panel[:multicraft][:web][:root]}/protected/data/#{db}/schema.mysql.sql"
      while File.exists?(sql) do
        e = Chef::Resource::Execute.new("mysql-import-multicraft")
        e.command = "#{panel['mysql']['mysql_bin']} -u root -p\"#{panel['mysql']['server_root_password']}\" -D #{panel[:multicraft][:db][:database]} < #{sql}"
        e.run_action :run
        sql = "#{panel[:multicraft][:web][:root]}/protected/data/#{db}/update.mysql.#{i}.sql"
        i += 1
      end
    end
  end
  action :create
end