diff --git a/analytics/src/main/resources/com/ning/billing/analytics/ddl.sql b/analytics/src/main/resources/com/ning/billing/analytics/ddl.sql
index 102a442..4e219d4 100644
--- a/analytics/src/main/resources/com/ning/billing/analytics/ddl.sql
+++ b/analytics/src/main/resources/com/ning/billing/analytics/ddl.sql
@@ -9,30 +9,30 @@ create table bst (
, subscription_id char(36) not null
, requested_timestamp bigint not null
, event varchar(50) not null
-, prev_product_name varchar(32) default null
-, prev_product_type varchar(32) default null
-, prev_product_category varchar(32) default null
+, prev_product_name varchar(50) default null
+, prev_product_type varchar(50) default null
+, prev_product_category varchar(50) default null
, prev_slug varchar(50) default null
-, prev_phase varchar(32) default null
-, prev_billing_period varchar(32) default null
+, prev_phase varchar(50) default null
+, prev_billing_period varchar(50) default null
, prev_price numeric(10, 4) default 0
-, prev_price_list varchar(32) default null
+, prev_price_list varchar(50) default null
, prev_mrr numeric(10, 4) default 0
-, prev_currency varchar(32) default null
+, prev_currency varchar(50) default null
, prev_start_date bigint default null
-, prev_state varchar(32) default null
-, next_product_name varchar(32) default null
-, next_product_type varchar(32) default null
-, next_product_category varchar(32) default null
+, prev_state varchar(50) default null
+, next_product_name varchar(50) default null
+, next_product_type varchar(50) default null
+, next_product_category varchar(50) default null
, next_slug varchar(50) default null
-, next_phase varchar(32) default null
-, next_billing_period varchar(32) default null
+, next_phase varchar(50) default null
+, next_billing_period varchar(50) default null
, next_price numeric(10, 4) default 0
-, next_price_list varchar(32) default null
+, next_price_list varchar(50) default null
, next_mrr numeric(10, 4) default 0
-, next_currency varchar(32) default null
+, next_currency varchar(50) default null
, next_start_date bigint default null
-, next_state varchar(32) default null
+, next_state varchar(50) default null
, primary key(record_id)
) engine=innodb comment 'Business Subscription Transitions, track bundles lifecycle';
create index bst_key_index on bst (external_key, requested_timestamp asc);
@@ -48,11 +48,11 @@ create table bac (
, balance numeric(10, 4) default 0
, last_invoice_date bigint default null
, total_invoice_balance numeric(10, 4) default 0
-, last_payment_status varchar(100) default null
-, payment_method varchar(100) default null
-, credit_card_type varchar(32) default null
-, billing_address_country varchar(100) default null
-, currency char(3) default null
+, last_payment_status varchar(255) default null
+, payment_method varchar(50) default null
+, credit_card_type varchar(50) default null
+, billing_address_country varchar(50) default null
+, currency char(50) default null
, primary key(record_id)
) engine=innodb comment 'Business ACcounts, keep a record of all accounts';
create unique index bac_key_index on bac (account_key);
@@ -68,7 +68,7 @@ create table bin (
, account_key varchar(50) not null
, invoice_date bigint not null
, target_date bigint not null
-, currency char(3) not null
+, currency char(50) not null
, balance numeric(10, 4) default 0 comment 'amount_charged - amount_paid - amount_credited'
, amount_paid numeric(10, 4) default 0 comment 'Sums of the successful payments made for this invoice minus the refunds associated with this invoice'
, amount_charged numeric(10, 4) default 0 comment 'Sums of the invoice items amount'
@@ -84,18 +84,18 @@ create table bii (
, created_date bigint not null
, updated_date bigint not null
, invoice_id char(36) not null
-, item_type char(20) not null comment 'e.g. FIXED or RECURRING'
+, item_type char(50) not null comment 'e.g. FIXED or RECURRING'
, external_key varchar(50) not null comment 'Bundle external key'
-, product_name varchar(32) default null
-, product_type varchar(32) default null
-, product_category varchar(32) default null
+, product_name varchar(50) default null
+, product_type varchar(50) default null
+, product_category varchar(50) default null
, slug varchar(50) default null comment 'foo'
-, phase varchar(32) default null
-, billing_period varchar(32) default null
+, phase varchar(50) default null
+, billing_period varchar(50) default null
, start_date bigint default null
, end_date bigint default null
, amount numeric(10, 4) default 0
-, currency char(3) default null
+, currency char(50) default null
, primary key(record_id)
) engine=innodb comment 'Business Invoice Items, keep a record of all invoice items';
create unique index bii_key_index on bii (item_id);
@@ -106,21 +106,21 @@ create table bip (
, payment_id char(36) not null
, created_date bigint not null
, updated_date bigint not null
-, ext_payment_ref_id varchar(64) default null
+, ext_payment_ref_id varchar(255) default null
, account_key varchar(50) not null comment 'Account external key'
, invoice_id char(36) not null
, effective_date bigint default null
, amount numeric(10, 4) default 0
-, currency char(3) default null
-, payment_error varchar(256) default null
+, currency char(50) default null
+, payment_error varchar(255) default null
, processing_status varchar(50) default null
, requested_amount numeric(10, 4) default 0
-, plugin_name varchar(20) default null
-, payment_type varchar(20) default null
-, payment_method varchar(20) default null
-, card_type varchar(20) default null
-, card_country varchar(20) default null
-, invoice_payment_type varchar(24) default null
+, plugin_name varchar(50) default null
+, payment_type varchar(50) default null
+, payment_method varchar(50) default null
+, card_type varchar(50) default null
+, card_country varchar(50) default null
+, invoice_payment_type varchar(50) default null
, linked_invoice_payment_id char(36) default null
, primary key(record_id)
) engine=innodb comment 'Business Invoice Payments, track all payments';
@@ -144,7 +144,7 @@ create table bac_tags (
record_id int(11) unsigned not null auto_increment
, account_id char(36) not null
, account_key varchar(50) not null comment 'Account external key'
-, name varchar(20) not null
+, name varchar(50) not null
, primary key(record_id)
) engine=innodb comment 'Tags associated to accounts';
@@ -153,7 +153,7 @@ create table bac_fields (
record_id int(11) unsigned not null auto_increment
, account_id char(36) not null
, account_key varchar(50) not null comment 'Account external key'
-, name varchar(30) not null
+, name varchar(50) not null
, value varchar(255) default null
, primary key(record_id)
) engine=innodb comment 'Custom fields associated to accounts';
@@ -164,7 +164,7 @@ create table bst_tags (
, bundle_id char(36) not null
, external_key varchar(50) not null comment 'Bundle external key'
, account_key varchar(50) not null comment 'Account external key'
-, name varchar(20) not null
+, name varchar(50) not null
, primary key(record_id)
) engine=innodb comment 'Tags associated to bundles';
@@ -174,7 +174,7 @@ create table bst_fields (
, bundle_id char(36) not null
, external_key varchar(50) not null comment 'Bundle external key'
, account_key varchar(50) not null comment 'Account external key'
-, name varchar(30) not null
+, name varchar(50) not null
, value varchar(255) default null
, primary key(record_id)
) engine=innodb comment 'Custom fields associated to bundles';
@@ -183,7 +183,7 @@ drop table if exists bin_tags;
create table bin_tags (
record_id int(11) unsigned not null auto_increment
, invoice_id char(36) not null
-, name varchar(20) not null
+, name varchar(50) not null
, primary key(record_id)
) engine=innodb comment 'Tags associated to invoices';
@@ -191,7 +191,7 @@ drop table if exists bin_fields;
create table bin_fields (
record_id int(11) unsigned not null auto_increment
, invoice_id char(36) not null
-, name varchar(30) not null
+, name varchar(50) not null
, value varchar(255) default null
, primary key(record_id)
) engine=innodb comment 'Custom fields associated to invoices';
@@ -200,7 +200,7 @@ drop table if exists bip_tags;
create table bip_tags (
record_id int(11) unsigned not null auto_increment
, payment_id char(36) not null
-, name varchar(20) not null
+, name varchar(50) not null
, primary key(record_id)
) engine=innodb comment 'Tags associated to payments';
@@ -208,7 +208,7 @@ drop table if exists bip_fields;
create table bip_fields (
record_id int(11) unsigned not null auto_increment
, payment_id char(36) not null
-, name varchar(30) not null
+, name varchar(50) not null
, value varchar(255) default null
, primary key(record_id)
) engine=innodb comment 'Custom fields associated to payments';
