title: Flyway database migration to multiple schemas
body: <p>I've set up a migration script for my multi-tenant application. the problem was. it's only generating the scripts for the first tenant/schema I've specified on the parameter. Here's my sql script</p>
  
  <pre><code>drop table if exists ADMIN_ACCOUNT cascade;
  
  drop table if exists PERSON_NAME cascade;
  
  drop table if exists USER_ACCOUNT cascade;
  
  create table ADMIN_ACCOUNT (
      id int8 not null,
      created_date timestamp,
      PASSWORD varchar(255),
      USERNAME varchar(255),
      membershipType varchar(255),
      NAME_ID int8,
      primary key (id)
  );
  
  create table PERSON_NAME (
      id int8 not null,
      created_date timestamp,
      FIRST_NAME varchar(255),
      LAST_NAME varchar(255),
      MIDDLE_NAME varchar(255),
      account_id int8,
      primary key (id)
  );
  
  create table USER_ACCOUNT (
      id int8 not null,
      created_date timestamp,
      PASSWORD varchar(255),
      USERNAME varchar(255),
      ROLE varchar(255),
      TENANT_CODE varchar(255),
      NAME_ID int8,
      primary key (id)
  );
  
  alter table ADMIN_ACCOUNT
  add constraint FK_fil1krx8k0osj713tg44ia0vu
  foreign key (NAME_ID)
  references PERSON_NAME;
  
  alter table PERSON_NAME
  add constraint FK_hc1g7pa0rseytw9o1pcuo0mpw
  foreign key (account_id)
  references USER_ACCOUNT;
  
  alter table USER_ACCOUNT
  add constraint FK_ib2pk4at20vxm3onaoro6ry2r
  foreign key (NAME_ID)
  references PERSON_NAME;
  </code></pre>
  
  <p>Here's the command I have entered to flyway <code>mvn compile flyway:migrate -Dflyway.schemas=tenant3,tenant4,tenant5 -Dflyway.baselineOnMigrate=true</code> </p>
  
  <p>It's only generating the tables for the first tenant which is tenant3.</p>
  
  <p>Is this a bug? or am Missing something?</p>