Attachment 156333 Details for Bug 9525 – Bug 9525: DO NOT PUSH! Schema update

[patch] Bug 9525: DO NOT PUSH! Schema update

Bug-9525-DO-NOT-PUSH-Schema-update.patch (text/plain), 3.96 KB, created by Nick Clemens (kidclamp) on 2023-09-28 14:12:09 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2023-09-28 14:12:09 UTC

Size: 3.96 KB

patch

obsolete

>From 8a4ac2cf4785f742440b3dd6aeaa623498f2688d Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Wed, 26 Apr 2023 13:41:18 +0000
>Subject: [PATCH] Bug 9525: DO NOT PUSH! Schema update
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> Koha/Schema/Result/LibraryGroup.pm | 80 +++++++++++++++++-------------
> 1 file changed, 45 insertions(+), 35 deletions(-)
>
>diff --git a/Koha/Schema/Result/LibraryGroup.pm b/Koha/Schema/Result/LibraryGroup.pm
>index 9687b1d640..43120c92d5 100644
>--- a/Koha/Schema/Result/LibraryGroup.pm
>+++ b/Koha/Schema/Result/LibraryGroup.pm
>@@ -103,6 +103,14 @@ Use this group for opac side search groups
> 
> Use this group to identify libraries as pick up location for holds
> 
>+=head2 ft_local_float_group
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
>+Use this group to identify libraries as part of float group
>+
> =head2 created_on
> 
>   data_type: 'timestamp'
>@@ -123,39 +131,41 @@ Date and time of last
> =cut
> 
> __PACKAGE__->add_columns(
>-  "id",
>-  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>-  "parent_id",
>-  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>-  "branchcode",
>-  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>-  "title",
>-  { data_type => "varchar", is_nullable => 1, size => 100 },
>-  "description",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "ft_hide_patron_info",
>-  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>-  "ft_limit_item_editing",
>-  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>-  "ft_search_groups_opac",
>-  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>-  "ft_search_groups_staff",
>-  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>-  "ft_local_hold_group",
>-  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>-  "created_on",
>-  {
>-    data_type => "timestamp",
>-    datetime_undef_if_invalid => 1,
>-    is_nullable => 1,
>-  },
>-  "updated_on",
>-  {
>-    data_type => "timestamp",
>-    datetime_undef_if_invalid => 1,
>-    default_value => \"current_timestamp",
>-    is_nullable => 0,
>-  },
>+    "id",
>+    { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>+    "parent_id",
>+    { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+    "branchcode",
>+    { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>+    "title",
>+    { data_type => "varchar", is_nullable => 1, size => 100 },
>+    "description",
>+    { data_type => "mediumtext", is_nullable => 1 },
>+    "ft_hide_patron_info",
>+    { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+    "ft_limit_item_editing",
>+    { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+    "ft_search_groups_opac",
>+    { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+    "ft_search_groups_staff",
>+    { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+    "ft_local_hold_group",
>+    { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+    "ft_local_float_group",
>+    { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+    "created_on",
>+    {
>+        data_type                 => "timestamp",
>+        datetime_undef_if_invalid => 1,
>+        is_nullable               => 1,
>+    },
>+    "updated_on",
>+    {
>+        data_type                 => "timestamp",
>+        datetime_undef_if_invalid => 1,
>+        default_value             => \"current_timestamp",
>+        is_nullable               => 0,
>+    },
> );
> 
> =head1 PRIMARY KEY
>@@ -256,8 +266,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-02-01 19:02:36
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G6Q4trvkAM/xH1skCv+B6g
>+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-26 13:40:04
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xv3d1OfYdkaPaopTFVjgxQ
> 
> sub koha_object_class {
>     'Koha::Library::Group';
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 9525: 40077 | 40102 | 40103 | 44754 | 44756 | 44760 | 48310 | 100420 | 100421 | 100422 | 100741 | 100742 | 100743 | 103828 | 103829 | 103830 | 103831 | 112550 | 112551 | 112552 | 112553 | 124825 | 124826 | 124827 | 133071 | 133072 | 133073 | 139024 | 139025 | 139026 | 143740 | 143741 | 143742 | 143743 | 150241 | 150242 | 150243 | 150244 | 150245 | 150246 | 156330 | 156331 | 156332 | 156333 | 156334 | 156335 | 156336