opsview-core-3.20131016.0.14175 utf8 patch

opsview-core-3.20131016.0.14175.utf8.patch

--- lib/Opsview/Keyword.pm.orig	2014-02-26 12:34:43.925685716 +0900
+++ lib/Opsview/Keyword.pm	2014-02-26 12:45:36.000000000 +0900
@@ -25,7 +25,7 @@
 use strict;
 
 __PACKAGE__->table( "keywords" );
-
+__PACKAGE__->utf8_columns(qw/description/);
 __PACKAGE__->columns( Primary => qw/id/ );
 __PACKAGE__->columns(
     Essential => qw/name description enabled style exclude_handled/ );

--- lib/Opsview/Schema/Contacts.pm.orig	2014-02-26 12:34:50.097716374 +0900
+++ lib/Opsview/Schema/Contacts.pm	2014-02-26 12:45:15.000000000 +0900
@@ -84,6 +84,7 @@
         size          => 11
     },
 );
+__PACKAGE__->utf8_columns(qw/description/);
 __PACKAGE__->set_primary_key( "id" );
 __PACKAGE__->add_unique_constraint( "name", ["name"] );
 __PACKAGE__->belongs_to( "role", "Opsview::Schema::Roles", { id => "role" } );

--- lib/Opsview/Schema/Keywords.pm.orig	2014-02-26 12:34:56.325747259 +0900
+++ lib/Opsview/Schema/Keywords.pm	2014-02-26 12:44:53.000000000 +0900
@@ -87,6 +87,7 @@
         size          => 1
     },
 );
+__PACKAGE__->utf8_columns(qw/name description/);
 __PACKAGE__->set_primary_key( "id" );
 __PACKAGE__->add_unique_constraint( "name", ["name"] );
 __PACKAGE__->has_many(

--- lib/Opsview/Schema/Servicechecks.pm.orig	2014-02-26 12:35:01.861774709 +0900
+++ lib/Opsview/Schema/Servicechecks.pm	2014-02-26 12:44:18.000000000 +0900
@@ -5,7 +5,7 @@
 
 use base qw/Opsview::DBIx::Class Opsview::ServiceBase/;
 
-__PACKAGE__->load_components(qw/+Opsview::DBIx::Class::Common Validation Core/);
+__PACKAGE__->load_components(qw/+Opsview::DBIx::Class::Common Validation UTF8Columns Core/);
 __PACKAGE__->table( __PACKAGE__->opsviewdb . ".servicechecks" );
 __PACKAGE__->add_columns(
     "id",
@@ -246,6 +246,7 @@
         size          => 1
     },
 );
+__PACKAGE__->utf8_columns(qw/description/);
 __PACKAGE__->set_primary_key( "id" );
 __PACKAGE__->add_unique_constraint( "name", ["name"] );
 __PACKAGE__->has_many(

--- lib/Opsview/Servicecheck.pm.orig	2014-02-26 12:35:09.269811447 +0900
+++ lib/Opsview/Servicecheck.pm	2014-02-26 12:43:50.000000000 +0900
@@ -28,7 +28,7 @@
 our $VERSION = '$Revision: 2700 $';
 
 __PACKAGE__->table( "servicechecks" );
-
+__PACKAGE__->utf8_columns(qw/description/);
 __PACKAGE__->columns( Primary => qw/id/, );
 
 # See Host.pm re: number of columns in Essential

--- lib/Runtime/Downtime.pm.orig	2014-02-26 12:35:18.029854881 +0900
+++ lib/Runtime/Downtime.pm	2014-02-26 12:43:31.000000000 +0900
@@ -27,7 +27,7 @@
 use strict;
 
 __PACKAGE__->table( "nagios_scheduleddowntime" );
-
+__PACKAGE__->utf8_columns(qw/comment_data/);
 __PACKAGE__->columns( Primary => qw/scheduleddowntime_id/ );
 __PACKAGE__->columns(
     Essential => qw/

--- lib/Runtime/Hostdowntime.pm.orig	2014-02-26 12:35:27.417901436 +0900
+++ lib/Runtime/Hostdowntime.pm	2014-02-26 12:43:20.000000000 +0900
@@ -27,7 +27,7 @@
 use strict;
 
 __PACKAGE__->table( "nagios_scheduleddowntime" );
-
+__PACKAGE__->utf8_columns(qw/comment_data/);
 __PACKAGE__->columns( Primary => qw/scheduleddowntime_id/ );
 __PACKAGE__->columns(
     Essential => qw/

--- lib/Runtime/Schema/NagiosStatehistory.pm.orig	2014-02-26 12:35:33.561931865 +0900
+++ lib/Runtime/Schema/NagiosStatehistory.pm	2014-02-26 12:39:13.000000000 +0900
@@ -25,7 +25,7 @@
 
 use base 'DBIx::Class';
 
-__PACKAGE__->load_components(qw/InflateColumn::DateTime Core/);
+__PACKAGE__->load_components(qw/UTF8Columns InflateColumn::DateTime Core/);
 __PACKAGE__->table( "nagios_statehistory" );
 __PACKAGE__->add_columns(
     "statehistory_id",
@@ -135,6 +135,7 @@
         size          => 65535
     },
 );
+__PACKAGE__->utf8_columns(qw/output/);
 __PACKAGE__->set_primary_key( "statehistory_id" );
 
 # Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-07-16 21:25:16

--- lib/Runtime/Servicedowntime.pm.orig	2014-02-26 12:35:47.550001313 +0900
+++ lib/Runtime/Servicedowntime.pm	2014-02-26 12:40:48.000000000 +0900
@@ -27,7 +27,7 @@
 use strict;
 
 __PACKAGE__->table( "nagios_scheduleddowntime" );
-
+__PACKAGE__->utf8_columns(qw/comment_data/);
 __PACKAGE__->columns( Primary => qw/scheduleddowntime_id/ );
 __PACKAGE__->columns(
     Essential => qw/

--- lib/Runtime/Servicestatus.pm.orig	2014-02-26 12:35:54.562035948 +0900
+++ lib/Runtime/Servicestatus.pm	2014-02-26 12:42:15.000000000 +0900
@@ -26,7 +26,7 @@
 use strict;
 
 __PACKAGE__->table( "nagios_servicestatus" );
-
+__PACKAGE__->utf8_columns( qw/output/ );
 __PACKAGE__->columns( Primary => qw/service_object_id/ );
 __PACKAGE__->columns( Essential =>
       qw/output last_check next_check current_state scheduled_downtime_depth problem_has_been_acknowledged/

--- lib/Runtime.pm.orig	2014-02-26 12:36:04.890086876 +0900
+++ lib/Runtime.pm	2014-02-26 12:42:27.000000000 +0900
@@ -26,6 +26,7 @@
 use Class::DBI::Sweet;
 use base "Exporter", 'Class::DBI::Sweet', "Opsview::Base", "ClassDBIExtras";
 use Opsview::Config;
+use Class::DBI::utf8 qw(-nosearch);
 
 use Carp;
 use Exporter;