killbill-aplcache

diff --git a/account/src/main/resources/org/killbill/billing/account/migration/V20160915180903__parent_account_456.sql b/account/src/main/resources/org/killbill/billing/account/migration/V20160915180903__parent_account_456.sql
new file mode 100644
index 0000000..889ece8
--- /dev/null
+++ b/account/src/main/resources/org/killbill/billing/account/migration/V20160915180903__parent_account_456.sql
@@ -0,0 +1,5 @@
+alter table accounts add column parent_account_id varchar(36) DEFAULT NULL after billing_cycle_day_local;
+alter table accounts add column is_payment_delegated_to_parent boolean DEFAULT FALSE after parent_account_id;
+
+alter table account_history add column parent_account_id varchar(36) DEFAULT NULL after billing_cycle_day_local;
+alter table account_history add column is_payment_delegated_to_parent boolean DEFAULT FALSE after parent_account_id;

diff --git a/invoice/src/main/resources/org/killbill/billing/invoice/migration/V20160915180903__invoice_status_459.sql b/invoice/src/main/resources/org/killbill/billing/invoice/migration/V20160915180903__invoice_status_459.sql
new file mode 100644
index 0000000..4f9a09b
--- /dev/null
+++ b/invoice/src/main/resources/org/killbill/billing/invoice/migration/V20160915180903__invoice_status_459.sql
@@ -0,0 +1,2 @@
+alter table invoices add column status varchar(15) NOT NULL after currency;
+update invoices set status = 'COMMITTED';
\ No newline at end of file

diff --git a/subscription/src/main/resources/org/killbill/billing/subscription/migration/V20160915180903__cleanup_499.sql b/subscription/src/main/resources/org/killbill/billing/subscription/migration/V20160915180903__cleanup_499.sql
new file mode 100644
index 0000000..89dfedb
--- /dev/null
+++ b/subscription/src/main/resources/org/killbill/billing/subscription/migration/V20160915180903__cleanup_499.sql
@@ -0,0 +1,4 @@
+alter table subscriptions drop column active_version;
+alter table subscriptions add column migrated bool NOT NULL default FALSE after charged_through_date;
+alter table subscription_events drop column requested_date;
+alter table subscription_events drop column current_version;

diff --git a/subscription/src/main/resources/org/killbill/billing/subscription/migration/V20160915180904__bcd_546.sql b/subscription/src/main/resources/org/killbill/billing/subscription/migration/V20160915180904__bcd_546.sql
new file mode 100644
index 0000000..4280909
--- /dev/null
+++ b/subscription/src/main/resources/org/killbill/billing/subscription/migration/V20160915180904__bcd_546.sql
@@ -0,0 +1,2 @@
+alter table subscription_events change event_type event_type varchar(15) NOT NULL;
+alter table subscription_events add column billing_cycle_day_local int DEFAULT NULL after price_list_name;
\ No newline at end of file

diff --git a/usage/src/main/resources/org/killbill/billing/usage/migration/V20160915180903__tracking_id_502.sql b/usage/src/main/resources/org/killbill/billing/usage/migration/V20160915180903__tracking_id_502.sql
new file mode 100644
index 0000000..591631d
--- /dev/null
+++ b/usage/src/main/resources/org/killbill/billing/usage/migration/V20160915180903__tracking_id_502.sql
@@ -0,0 +1,3 @@
+alter table rolled_up_usage add column tracking_id varchar(128) NOT NULL after amount;
+alter table rolled_up_usage change subscription_id subscription_id varchar(36) not null;
+alter table rolled_up_usage change unit_type unit_type varchar(255) not null;