 , tenant_record_id bigint /*! unsigned */ default null
 , report_group varchar(50) not null
 , primary key(record_id)
-);
+) /*! CHARACTER SET utf8 COLLATE utf8_bin */;
 create index analytics_invoice_tags_account_id on analytics_invoice_tags(account_id);
 create index analytics_invoice_tags_account_record_id on analytics_invoice_tags(account_record_id);
 create index analytics_invoice_tags_tenant_account_record_id on analytics_invoice_tags(tenant_record_id, account_record_id);

, tenant_record_id bigint /*! unsigned */ default null
, report_group varchar(50) not null
, primary key(record_id)
);
create index analytics_payment_captures_invoice_payment_record_id on analytics_payment_captures(invoice_payment_record_id);
create index analytics_payment_captures_invoice_payment_id on analytics_payment_captures(invoice_payment_id);
create index analytics_payment_captures_invoice_id on analytics_payment_captures(invoice_id);

, refresh_frequency varchar(50) default null
, refresh_hour_of_day_gmt smallint default null
, primary key(record_id)
) /*! CHARACTER SET utf8 COLLATE utf8_bin */;
create unique index analytics_reports_report_name on analytics_reports(report_name);
