- hosts: dbserver
  remote_user: root
  gather_facts: false
  vars_files:
  - vars.yaml
  - name: table_list put to array
    action: shell cat /usr/tables/table_list | grep -v "^center"
    register: tables
  - name: create tables
    command: mysql -u {{ mysql.username }} --password={{ mysql.password }} -D sys3 < /usr/tables/create.{{ item }}.sql
    with_items:
    - "{{ tables }}"