Attachment 30949 Details for Bug 12781 – Bug 12781: DBIx::Class schema update 08/2014

[patch] Bug 12781: DBIx::Class schema update 08/2014

Bug-12781-DBIxClass-schema-update-082014.patch (text/plain), 23.47 KB, created by Tomás Cohen Arazi (tcohen) on 2014-08-18 16:15:13 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2014-08-18 16:15:13 UTC

Size: 23.47 KB

patch

obsolete

>From dd2ef1b21d90eb1b6ab8c13e122ce434ca7bd226 Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@gmail.com>
>Date: Mon, 18 Aug 2014 13:11:42 -0300
>Subject: [PATCH] Bug 12781: DBIx::Class schema update 08/2014
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
>---
> Koha/Schema/Result/Borrower.pm             | 94 ++++++++++++++++++++----------
> Koha/Schema/Result/BorrowerModification.pm | 94 ++++++++++++++++++++----------
> Koha/Schema/Result/BranchTransferLimit.pm  | 44 +++++++++-----
> Koha/Schema/Result/Category.pm             | 16 +++--
> Koha/Schema/Result/Collection.pm           | 52 ++++++++++++-----
> Koha/Schema/Result/CollectionsTracking.pm  | 16 +++--
> Koha/Schema/Result/Deletedborrower.pm      | 94 ++++++++++++++++++++----------
> Koha/Schema/Result/OldReserve.pm           | 11 ++--
> Koha/Schema/Result/Reserve.pm              | 11 ++--
> Koha/Schema/Result/Suggestion.pm           | 17 ++++--
> 10 files changed, 299 insertions(+), 150 deletions(-)
>
>diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
>index b1f9e6f..48102dd 100644
>--- a/Koha/Schema/Result/Borrower.pm
>+++ b/Koha/Schema/Result/Borrower.pm
>@@ -134,57 +134,67 @@ __PACKAGE__->table("borrowers");
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_streetnumber
>+=head2 B_streetnumber
> 
>+  accessor: 'b_streetnumber'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 10
> 
>-=head2 b_streettype
>+=head2 B_streettype
> 
>+  accessor: 'b_streettype'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 50
> 
>-=head2 b_address
>+=head2 B_address
> 
>+  accessor: 'b_address'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 100
> 
>-=head2 b_address2
>+=head2 B_address2
> 
>+  accessor: 'b_address2'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_city
>+=head2 B_city
> 
>+  accessor: 'b_city'
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>-=head2 b_state
>+=head2 B_state
> 
>+  accessor: 'b_state'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_zipcode
>+=head2 B_zipcode
> 
>+  accessor: 'b_zipcode'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 25
> 
>-=head2 b_country
>+=head2 B_country
> 
>+  accessor: 'b_country'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_email
>+=head2 B_email
> 
>+  accessor: 'b_email'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_phone
>+=head2 B_phone
> 
>+  accessor: 'b_phone'
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>@@ -442,26 +452,46 @@ __PACKAGE__->add_columns(
>   { data_type => "text", is_nullable => 1 },
>   "phonepro",
>   { data_type => "text", is_nullable => 1 },
>-  "b_streetnumber",
>-  { data_type => "varchar", is_nullable => 1, size => 10 },
>-  "b_streettype",
>-  { data_type => "varchar", is_nullable => 1, size => 50 },
>-  "b_address",
>-  { data_type => "varchar", is_nullable => 1, size => 100 },
>-  "b_address2",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_city",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "b_state",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_zipcode",
>-  { data_type => "varchar", is_nullable => 1, size => 25 },
>-  "b_country",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_email",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_phone",
>-  { data_type => "mediumtext", is_nullable => 1 },
>+  "B_streetnumber",
>+  {
>+    accessor => "b_streetnumber",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 10,
>+  },
>+  "B_streettype",
>+  {
>+    accessor => "b_streettype",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 50,
>+  },
>+  "B_address",
>+  {
>+    accessor => "b_address",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 100,
>+  },
>+  "B_address2",
>+  { accessor => "b_address2", data_type => "text", is_nullable => 1 },
>+  "B_city",
>+  { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
>+  "B_state",
>+  { accessor => "b_state", data_type => "text", is_nullable => 1 },
>+  "B_zipcode",
>+  {
>+    accessor => "b_zipcode",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 25,
>+  },
>+  "B_country",
>+  { accessor => "b_country", data_type => "text", is_nullable => 1 },
>+  "B_email",
>+  { accessor => "b_email", data_type => "text", is_nullable => 1 },
>+  "B_phone",
>+  { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
>   "dateofbirth",
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "branchcode",
>@@ -1072,8 +1102,8 @@ Composing rels: L</course_instructors> -> course
> __PACKAGE__->many_to_many("courses", "course_instructors", "course");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5cfpOojccKCoVRMj+0mWHg
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZzZiKYN4b/LuEARX4rawhA
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm
>index 08cf62b..b61c0c7 100644
>--- a/Koha/Schema/Result/BorrowerModification.pm
>+++ b/Koha/Schema/Result/BorrowerModification.pm
>@@ -148,57 +148,67 @@ __PACKAGE__->table("borrower_modifications");
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_streetnumber
>+=head2 B_streetnumber
> 
>+  accessor: 'b_streetnumber'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 10
> 
>-=head2 b_streettype
>+=head2 B_streettype
> 
>+  accessor: 'b_streettype'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 50
> 
>-=head2 b_address
>+=head2 B_address
> 
>+  accessor: 'b_address'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 100
> 
>-=head2 b_address2
>+=head2 B_address2
> 
>+  accessor: 'b_address2'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_city
>+=head2 B_city
> 
>+  accessor: 'b_city'
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>-=head2 b_state
>+=head2 B_state
> 
>+  accessor: 'b_state'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_zipcode
>+=head2 B_zipcode
> 
>+  accessor: 'b_zipcode'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 25
> 
>-=head2 b_country
>+=head2 B_country
> 
>+  accessor: 'b_country'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_email
>+=head2 B_email
> 
>+  accessor: 'b_email'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_phone
>+=head2 B_phone
> 
>+  accessor: 'b_phone'
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>@@ -460,26 +470,46 @@ __PACKAGE__->add_columns(
>   { data_type => "text", is_nullable => 1 },
>   "phonepro",
>   { data_type => "text", is_nullable => 1 },
>-  "b_streetnumber",
>-  { data_type => "varchar", is_nullable => 1, size => 10 },
>-  "b_streettype",
>-  { data_type => "varchar", is_nullable => 1, size => 50 },
>-  "b_address",
>-  { data_type => "varchar", is_nullable => 1, size => 100 },
>-  "b_address2",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_city",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "b_state",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_zipcode",
>-  { data_type => "varchar", is_nullable => 1, size => 25 },
>-  "b_country",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_email",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_phone",
>-  { data_type => "mediumtext", is_nullable => 1 },
>+  "B_streetnumber",
>+  {
>+    accessor => "b_streetnumber",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 10,
>+  },
>+  "B_streettype",
>+  {
>+    accessor => "b_streettype",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 50,
>+  },
>+  "B_address",
>+  {
>+    accessor => "b_address",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 100,
>+  },
>+  "B_address2",
>+  { accessor => "b_address2", data_type => "text", is_nullable => 1 },
>+  "B_city",
>+  { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
>+  "B_state",
>+  { accessor => "b_state", data_type => "text", is_nullable => 1 },
>+  "B_zipcode",
>+  {
>+    accessor => "b_zipcode",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 25,
>+  },
>+  "B_country",
>+  { accessor => "b_country", data_type => "text", is_nullable => 1 },
>+  "B_email",
>+  { accessor => "b_email", data_type => "text", is_nullable => 1 },
>+  "B_phone",
>+  { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
>   "dateofbirth",
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "branchcode",
>@@ -569,8 +599,8 @@ __PACKAGE__->add_columns(
> __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:11X5o3u4/EqPRVbQdtAuOA
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xUfsaCL/IR4h5U7AKHmFzw
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/BranchTransferLimit.pm b/Koha/Schema/Result/BranchTransferLimit.pm
>index 2c3011f..a704c68 100644
>--- a/Koha/Schema/Result/BranchTransferLimit.pm
>+++ b/Koha/Schema/Result/BranchTransferLimit.pm
>@@ -23,20 +23,23 @@ __PACKAGE__->table("branch_transfer_limits");
> 
> =head1 ACCESSORS
> 
>-=head2 limitid
>+=head2 limitId
> 
>+  accessor: 'limit_id'
>   data_type: 'integer'
>   is_auto_increment: 1
>   is_nullable: 0
> 
>-=head2 tobranch
>+=head2 toBranch
> 
>+  accessor: 'to_branch'
>   data_type: 'varchar'
>   is_nullable: 0
>   size: 10
> 
>-=head2 frombranch
>+=head2 fromBranch
> 
>+  accessor: 'from_branch'
>   data_type: 'varchar'
>   is_nullable: 0
>   size: 10
>@@ -56,12 +59,27 @@ __PACKAGE__->table("branch_transfer_limits");
> =cut
> 
> __PACKAGE__->add_columns(
>-  "limitid",
>-  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>-  "tobranch",
>-  { data_type => "varchar", is_nullable => 0, size => 10 },
>-  "frombranch",
>-  { data_type => "varchar", is_nullable => 0, size => 10 },
>+  "limitId",
>+  {
>+    accessor          => "limit_id",
>+    data_type         => "integer",
>+    is_auto_increment => 1,
>+    is_nullable       => 0,
>+  },
>+  "toBranch",
>+  {
>+    accessor => "to_branch",
>+    data_type => "varchar",
>+    is_nullable => 0,
>+    size => 10,
>+  },
>+  "fromBranch",
>+  {
>+    accessor => "from_branch",
>+    data_type => "varchar",
>+    is_nullable => 0,
>+    size => 10,
>+  },
>   "itemtype",
>   { data_type => "varchar", is_nullable => 1, size => 10 },
>   "ccode",
>@@ -72,17 +90,17 @@ __PACKAGE__->add_columns(
> 
> =over 4
> 
>-=item * L</limitid>
>+=item * L</limitId>
> 
> =back
> 
> =cut
> 
>-__PACKAGE__->set_primary_key("limitid");
>+__PACKAGE__->set_primary_key("limitId");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HN/uEtGTNOewMCqTQZ1Vew
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XPpJwcw5PRa7Fo7PRg32zg
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm
>index 424868f..4926587 100644
>--- a/Koha/Schema/Result/Category.pm
>+++ b/Koha/Schema/Result/Category.pm
>@@ -102,8 +102,9 @@ __PACKAGE__->table("categories");
>   is_nullable: 0
>   size: 1
> 
>-=head2 blockexpiredpatronopacactions
>+=head2 BlockExpiredPatronOpacActions
> 
>+  accessor: 'block_expired_patron_opac_actions'
>   data_type: 'tinyint'
>   default_value: -1
>   is_nullable: 0
>@@ -146,8 +147,13 @@ __PACKAGE__->add_columns(
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "category_type",
>   { data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },
>-  "blockexpiredpatronopacactions",
>-  { data_type => "tinyint", default_value => -1, is_nullable => 0 },
>+  "BlockExpiredPatronOpacActions",
>+  {
>+    accessor      => "block_expired_patron_opac_actions",
>+    data_type     => "tinyint",
>+    default_value => -1,
>+    is_nullable   => 0,
>+  },
>   "default_privacy",
>   {
>     data_type => "enum",
>@@ -247,8 +253,8 @@ __PACKAGE__->might_have(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-05-26 01:25:05
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7am0HIdPPQD5sZyKF4FipQ
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T4i7vp1kAZFXy6DiV1dqyw
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/Collection.pm b/Koha/Schema/Result/Collection.pm
>index 92b0f6c..4f435de 100644
>--- a/Koha/Schema/Result/Collection.pm
>+++ b/Koha/Schema/Result/Collection.pm
>@@ -23,26 +23,30 @@ __PACKAGE__->table("collections");
> 
> =head1 ACCESSORS
> 
>-=head2 colid
>+=head2 colId
> 
>+  accessor: 'col_id'
>   data_type: 'integer'
>   is_auto_increment: 1
>   is_nullable: 0
> 
>-=head2 coltitle
>+=head2 colTitle
> 
>+  accessor: 'col_title'
>   data_type: 'varchar'
>   default_value: (empty string)
>   is_nullable: 0
>   size: 100
> 
>-=head2 coldesc
>+=head2 colDesc
> 
>+  accessor: 'col_desc'
>   data_type: 'text'
>   is_nullable: 0
> 
>-=head2 colbranchcode
>+=head2 colBranchcode
> 
>+  accessor: 'col_branchcode'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 4
>@@ -52,31 +56,47 @@ branchcode for branch where item should be held.
> =cut
> 
> __PACKAGE__->add_columns(
>-  "colid",
>-  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>-  "coltitle",
>-  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
>-  "coldesc",
>-  { data_type => "text", is_nullable => 0 },
>-  "colbranchcode",
>-  { data_type => "varchar", is_nullable => 1, size => 4 },
>+  "colId",
>+  {
>+    accessor          => "col_id",
>+    data_type         => "integer",
>+    is_auto_increment => 1,
>+    is_nullable       => 0,
>+  },
>+  "colTitle",
>+  {
>+    accessor => "col_title",
>+    data_type => "varchar",
>+    default_value => "",
>+    is_nullable => 0,
>+    size => 100,
>+  },
>+  "colDesc",
>+  { accessor => "col_desc", data_type => "text", is_nullable => 0 },
>+  "colBranchcode",
>+  {
>+    accessor => "col_branchcode",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 4,
>+  },
> );
> 
> =head1 PRIMARY KEY
> 
> =over 4
> 
>-=item * L</colid>
>+=item * L</colId>
> 
> =back
> 
> =cut
> 
>-__PACKAGE__->set_primary_key("colid");
>+__PACKAGE__->set_primary_key("colId");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KNJIC+I4OdfXBAPM8zOB4A
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4QFGZYwbv0aj6eXdn7vO9A
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/CollectionsTracking.pm b/Koha/Schema/Result/CollectionsTracking.pm
>index c25bb06..4a55cbd 100644
>--- a/Koha/Schema/Result/CollectionsTracking.pm
>+++ b/Koha/Schema/Result/CollectionsTracking.pm
>@@ -29,8 +29,9 @@ __PACKAGE__->table("collections_tracking");
>   is_auto_increment: 1
>   is_nullable: 0
> 
>-=head2 colid
>+=head2 colId
> 
>+  accessor: 'col_id'
>   data_type: 'integer'
>   default_value: 0
>   is_nullable: 0
>@@ -50,8 +51,13 @@ items.itemnumber
> __PACKAGE__->add_columns(
>   "collections_tracking_id",
>   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>-  "colid",
>-  { data_type => "integer", default_value => 0, is_nullable => 0 },
>+  "colId",
>+  {
>+    accessor      => "col_id",
>+    data_type     => "integer",
>+    default_value => 0,
>+    is_nullable   => 0,
>+  },
>   "itemnumber",
>   { data_type => "integer", default_value => 0, is_nullable => 0 },
> );
>@@ -69,8 +75,8 @@ __PACKAGE__->add_columns(
> __PACKAGE__->set_primary_key("collections_tracking_id");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aV5bgiXNrskXo+q+WLuwPg
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:s8ZFSmMJt313bz3XdlhITQ
> 
> 
> # You can replace this text with custom code or comments, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
>index 9ede8ac..8c438ba 100644
>--- a/Koha/Schema/Result/Deletedborrower.pm
>+++ b/Koha/Schema/Result/Deletedborrower.pm
>@@ -134,57 +134,67 @@ __PACKAGE__->table("deletedborrowers");
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_streetnumber
>+=head2 B_streetnumber
> 
>+  accessor: 'b_streetnumber'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 10
> 
>-=head2 b_streettype
>+=head2 B_streettype
> 
>+  accessor: 'b_streettype'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 50
> 
>-=head2 b_address
>+=head2 B_address
> 
>+  accessor: 'b_address'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 100
> 
>-=head2 b_address2
>+=head2 B_address2
> 
>+  accessor: 'b_address2'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_city
>+=head2 B_city
> 
>+  accessor: 'b_city'
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>-=head2 b_state
>+=head2 B_state
> 
>+  accessor: 'b_state'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_zipcode
>+=head2 B_zipcode
> 
>+  accessor: 'b_zipcode'
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 25
> 
>-=head2 b_country
>+=head2 B_country
> 
>+  accessor: 'b_country'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_email
>+=head2 B_email
> 
>+  accessor: 'b_email'
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 b_phone
>+=head2 B_phone
> 
>+  accessor: 'b_phone'
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>@@ -440,26 +450,46 @@ __PACKAGE__->add_columns(
>   { data_type => "text", is_nullable => 1 },
>   "phonepro",
>   { data_type => "text", is_nullable => 1 },
>-  "b_streetnumber",
>-  { data_type => "varchar", is_nullable => 1, size => 10 },
>-  "b_streettype",
>-  { data_type => "varchar", is_nullable => 1, size => 50 },
>-  "b_address",
>-  { data_type => "varchar", is_nullable => 1, size => 100 },
>-  "b_address2",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_city",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "b_state",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_zipcode",
>-  { data_type => "varchar", is_nullable => 1, size => 25 },
>-  "b_country",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_email",
>-  { data_type => "text", is_nullable => 1 },
>-  "b_phone",
>-  { data_type => "mediumtext", is_nullable => 1 },
>+  "B_streetnumber",
>+  {
>+    accessor => "b_streetnumber",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 10,
>+  },
>+  "B_streettype",
>+  {
>+    accessor => "b_streettype",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 50,
>+  },
>+  "B_address",
>+  {
>+    accessor => "b_address",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 100,
>+  },
>+  "B_address2",
>+  { accessor => "b_address2", data_type => "text", is_nullable => 1 },
>+  "B_city",
>+  { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
>+  "B_state",
>+  { accessor => "b_state", data_type => "text", is_nullable => 1 },
>+  "B_zipcode",
>+  {
>+    accessor => "b_zipcode",
>+    data_type => "varchar",
>+    is_nullable => 1,
>+    size => 25,
>+  },
>+  "B_country",
>+  { accessor => "b_country", data_type => "text", is_nullable => 1 },
>+  "B_email",
>+  { accessor => "b_email", data_type => "text", is_nullable => 1 },
>+  "B_phone",
>+  { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
>   "dateofbirth",
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "branchcode",
>@@ -535,8 +565,8 @@ __PACKAGE__->add_columns(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yA/UeNpbYIUrX/iWsF0NLw
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cRaxMYFjVG7JB7AvsdCweg
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm
>index 942480f..1cd1f6c 100644
>--- a/Koha/Schema/Result/OldReserve.pm
>+++ b/Koha/Schema/Result/OldReserve.pm
>@@ -117,8 +117,9 @@ __PACKAGE__->table("old_reserves");
>   datetime_undef_if_invalid: 1
>   is_nullable: 1
> 
>-=head2 lowestpriority
>+=head2 lowestPriority
> 
>+  accessor: 'lowest_priority'
>   data_type: 'tinyint'
>   is_nullable: 0
> 
>@@ -174,8 +175,8 @@ __PACKAGE__->add_columns(
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "expirationdate",
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>-  "lowestpriority",
>-  { data_type => "tinyint", is_nullable => 0 },
>+  "lowestPriority",
>+  { accessor => "lowest_priority", data_type => "tinyint", is_nullable => 0 },
>   "suspend",
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "suspend_until",
>@@ -261,8 +262,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CMfQmK2sJxQB0FBb0X12ug
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bCHe3BGidrVm0LIlC6h+ow
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm
>index 184a854..16f951b 100644
>--- a/Koha/Schema/Result/Reserve.pm
>+++ b/Koha/Schema/Result/Reserve.pm
>@@ -121,8 +121,9 @@ __PACKAGE__->table("reserves");
>   datetime_undef_if_invalid: 1
>   is_nullable: 1
> 
>-=head2 lowestpriority
>+=head2 lowestPriority
> 
>+  accessor: 'lowest_priority'
>   data_type: 'tinyint'
>   is_nullable: 0
> 
>@@ -188,8 +189,8 @@ __PACKAGE__->add_columns(
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "expirationdate",
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>-  "lowestpriority",
>-  { data_type => "tinyint", is_nullable => 0 },
>+  "lowestPriority",
>+  { accessor => "lowest_priority", data_type => "tinyint", is_nullable => 0 },
>   "suspend",
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "suspend_until",
>@@ -285,8 +286,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ig/fobzvZf1OgAHZFtkyyQ
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jzng9D1Pns0I2PUF7Wssiw
> 
> __PACKAGE__->belongs_to(
>   "item",
>diff --git a/Koha/Schema/Result/Suggestion.pm b/Koha/Schema/Result/Suggestion.pm
>index c1ae103..d255bb1 100644
>--- a/Koha/Schema/Result/Suggestion.pm
>+++ b/Koha/Schema/Result/Suggestion.pm
>@@ -74,8 +74,9 @@ __PACKAGE__->table("suggestions");
>   datetime_undef_if_invalid: 1
>   is_nullable: 1
> 
>-=head2 status
>+=head2 STATUS
> 
>+  accessor: 'status'
>   data_type: 'varchar'
>   default_value: (empty string)
>   is_nullable: 0
>@@ -227,8 +228,14 @@ __PACKAGE__->add_columns(
>   { data_type => "integer", is_nullable => 1 },
>   "rejecteddate",
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>-  "status",
>-  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
>+  "STATUS",
>+  {
>+    accessor => "status",
>+    data_type => "varchar",
>+    default_value => "",
>+    is_nullable => 0,
>+    size => 10,
>+  },
>   "note",
>   { data_type => "mediumtext", is_nullable => 1 },
>   "author",
>@@ -293,8 +300,8 @@ __PACKAGE__->add_columns(
> __PACKAGE__->set_primary_key("suggestionid");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-12-13 01:10:43
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LJoqZVAeoZ0ra2BKxXRQMQ
>+# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tMbXZ1id2ls57UMp5jicFA
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

Attachments on bug 12781: 30948 | 30949 | 30963 | 30964 | 31014 | 31018