killbill-aplcache

diff --git a/beatrix/src/main/resources/org/killbill/billing/beatrix/ddl.sql b/beatrix/src/main/resources/org/killbill/billing/beatrix/ddl.sql
index 84ae5cd..ea42987 100644
--- a/beatrix/src/main/resources/org/killbill/billing/beatrix/ddl.sql
+++ b/beatrix/src/main/resources/org/killbill/billing/beatrix/ddl.sql
@@ -11,7 +11,7 @@ CREATE TABLE bus_ext_events (
     processing_owner char(50) DEFAULT NULL,
     processing_available_date datetime DEFAULT NULL,
     processing_state varchar(14) DEFAULT 'AVAILABLE',
-    error_count int(11) /*! unsigned */ DEFAULT 0,
+    error_count int /*! unsigned */ DEFAULT 0,
     search_key1 bigint /*! unsigned */ not null,
     search_key2 bigint /*! unsigned */ not null default 0,
     PRIMARY KEY(record_id)
@@ -30,7 +30,7 @@ CREATE TABLE bus_ext_events_history (
     processing_owner char(50) DEFAULT NULL,
     processing_available_date datetime DEFAULT NULL,
     processing_state varchar(14) DEFAULT 'AVAILABLE',
-    error_count int(11) /*! unsigned */ DEFAULT 0,
+    error_count int /*! unsigned */ DEFAULT 0,
     search_key1 bigint /*! unsigned */ not null,
     search_key2 bigint /*! unsigned */ not null default 0,
     PRIMARY KEY(record_id)

diff --git a/subscription/src/main/resources/org/killbill/billing/subscription/ddl.sql b/subscription/src/main/resources/org/killbill/billing/subscription/ddl.sql
index d560d34..812e4df 100644
--- a/subscription/src/main/resources/org/killbill/billing/subscription/ddl.sql
+++ b/subscription/src/main/resources/org/killbill/billing/subscription/ddl.sql
@@ -12,7 +12,7 @@ CREATE TABLE subscription_events (
     plan_name varchar(64) DEFAULT NULL,
     phase_name varchar(128) DEFAULT NULL,
     price_list_name varchar(64) DEFAULT NULL,
-    current_version int(11) DEFAULT 1,
+    current_version int DEFAULT 1,
     is_active bool DEFAULT 1,
     created_by varchar(50) NOT NULL,
     created_date datetime NOT NULL,
@@ -35,7 +35,7 @@ CREATE TABLE subscriptions (
     category varchar(32) NOT NULL,
     start_date datetime NOT NULL,
     bundle_start_date datetime NOT NULL,
-    active_version int(11) DEFAULT 1,
+    active_version int DEFAULT 1,
     charged_through_date datetime DEFAULT NULL,
     created_by varchar(50) NOT NULL,
     created_date datetime NOT NULL,

diff --git a/util/src/main/resources/cleanAccount.sql b/util/src/main/resources/cleanAccount.sql
index ceb8bd4..cc74695 100644
--- a/util/src/main/resources/cleanAccount.sql
+++ b/util/src/main/resources/cleanAccount.sql
@@ -3,7 +3,7 @@ DELIMITER //
 CREATE PROCEDURE cleanAccount(p_account_key char(36))
 BEGIN
 
-    DECLARE v_account_record_id int(11) /*! unsigned */;
+    DECLARE v_account_record_id bigint /*! unsigned */;
 
     select record_id from accounts WHERE external_key = p_account_key into v_account_record_id;
 

diff --git a/util/src/main/resources/org/killbill/billing/util/ddl.sql b/util/src/main/resources/org/killbill/billing/util/ddl.sql
index 4962d59..a4e8031 100644
--- a/util/src/main/resources/org/killbill/billing/util/ddl.sql
+++ b/util/src/main/resources/org/killbill/billing/util/ddl.sql
@@ -159,7 +159,7 @@ CREATE TABLE notifications (
     processing_owner char(50) DEFAULT NULL,
     processing_available_date datetime DEFAULT NULL,
     processing_state varchar(14) DEFAULT 'AVAILABLE',
-    error_count int(11) /*! unsigned */ DEFAULT 0,
+    error_count int /*! unsigned */ DEFAULT 0,
     search_key1 bigint /*! unsigned */ not null,
     search_key2 bigint /*! unsigned */ not null default 0,
     queue_name char(64) NOT NULL,
@@ -183,7 +183,7 @@ CREATE TABLE notifications_history (
     processing_owner char(50) DEFAULT NULL,
     processing_available_date datetime DEFAULT NULL,
     processing_state varchar(14) DEFAULT 'AVAILABLE',
-    error_count int(11) /*! unsigned */ DEFAULT 0,
+    error_count int /*! unsigned */ DEFAULT 0,
     search_key1 bigint /*! unsigned */ not null,
     search_key2 bigint /*! unsigned */ not null default 0,
     queue_name char(64) NOT NULL,
@@ -203,7 +203,7 @@ CREATE TABLE bus_events (
     processing_owner char(50) DEFAULT NULL,
     processing_available_date datetime DEFAULT NULL,
     processing_state varchar(14) DEFAULT 'AVAILABLE',
-    error_count int(11) /*! unsigned */ DEFAULT 0,
+    error_count int /*! unsigned */ DEFAULT 0,
     search_key1 bigint /*! unsigned */ not null,
     search_key2 bigint /*! unsigned */ not null default 0,
     PRIMARY KEY(record_id)
@@ -222,7 +222,7 @@ CREATE TABLE bus_events_history (
     processing_owner char(50) DEFAULT NULL,
     processing_available_date datetime DEFAULT NULL,
     processing_state varchar(14) DEFAULT 'AVAILABLE',
-    error_count int(11) /*! unsigned */ DEFAULT 0,
+    error_count int /*! unsigned */ DEFAULT 0,
     search_key1 bigint /*! unsigned */ not null,
     search_key2 bigint /*! unsigned */ not null default 0,
     PRIMARY KEY(record_id)
@@ -233,7 +233,7 @@ create table sessions (
   record_id serial unique
 , start_timestamp datetime not null
 , last_access_time datetime default null
-, timeout int(11)
+, timeout int
 , host varchar(100) default null
 , session_data mediumblob default null
 , primary key(record_id)