View | Details | Raw Unified | Return to bug 39835
Collapse All | Expand All

(-)a/Koha/Schema/Result/Aqbudget.pm (+4 lines)
Lines 369-374 __PACKAGE__->belongs_to( Link Here
369
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
369
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
370
);
370
);
371
371
372
__PACKAGE__->add_columns(
373
    '+budget_permission' => { is_boolean => 0 },
374
);
375
372
=head2 koha_object_class
376
=head2 koha_object_class
373
377
374
Missing POD for koha_object_class.
378
Missing POD for koha_object_class.
(-)a/Koha/Schema/Result/ColumnsSetting.pm (-1 / +4 lines)
Lines 98-103 __PACKAGE__->set_primary_key("module", "page", "tablename", "columnname"); Link Here
98
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-12-12 16:06:36
98
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-12-12 16:06:36
99
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IhREpW2PRxxFF9EYOGt2Qg
99
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IhREpW2PRxxFF9EYOGt2Qg
100
100
101
__PACKAGE__->add_columns(
102
    '+cannot_be_toggled' => { is_boolean => 1 },
103
    '+is_hidden' => { is_boolean => 1 },
104
);
101
105
102
# You can replace this text with custom code or comments, and it will be preserved on regeneration
103
1;
106
1;
(-)a/Koha/Schema/Result/CreatorLayout.pm (-2 / +5 lines)
Lines 219-224 __PACKAGE__->set_primary_key("layout_id"); Link Here
219
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-24 13:05:15
219
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-24 13:05:15
220
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W/ICw+9yY7wxZ0IgqqXcFg
220
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W/ICw+9yY7wxZ0IgqqXcFg
221
221
222
222
__PACKAGE__->add_columns(
223
# You can replace this text with custom content, and it will be preserved on regeneration
223
    '+guidebox' => { is_boolean => 0 },
224
    '+oblique_title' => { is_boolean => 0 },
225
    '+callnum_split' => { is_boolean => 0 },
226
);
224
1;
227
1;
(-)a/Koha/Schema/Result/Overduerule.pm (+6 lines)
Lines 198-203 __PACKAGE__->has_many( Link Here
198
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
198
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
199
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pORigxtC5qztZWHI29mZ/g
199
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pORigxtC5qztZWHI29mZ/g
200
200
201
__PACKAGE__->add_columns(
202
    '+debarred1' => { is_boolean => 1 },
203
    '+debarred2' => { is_boolean => 1 },
204
    '+debarred3' => { is_boolean => 1 },
205
);
206
201
=head2 koha_object_class
207
=head2 koha_object_class
202
208
203
Missing POD for koha_object_class.
209
Missing POD for koha_object_class.
(-)a/Koha/Schema/Result/OverduerulesTransportType.pm (-1 / +3 lines)
Lines 116-121 __PACKAGE__->belongs_to( Link Here
116
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-31 15:44:38
116
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-31 15:44:38
117
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GV2VZ1kIA9Fl8pQd0qkrjg
117
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GV2VZ1kIA9Fl8pQd0qkrjg
118
118
119
__PACKAGE__->add_columns(
120
    '+letternumber' => { is_boolean => 0 },
121
);
119
122
120
# You can replace this text with custom code or comments, and it will be preserved on regeneration
121
1;
123
1;
(-)a/Koha/Schema/Result/TagsApproval.pm (+4 lines)
Lines 135-140 __PACKAGE__->has_many( Link Here
135
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
135
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PR7rfXKXExWpmkdxcXRrbQ
136
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PR7rfXKXExWpmkdxcXRrbQ
137
137
138
__PACKAGE__->add_columns(
139
    '+approved' => { is_boolean => 0 },
140
);
141
138
=head2 koha_object_class
142
=head2 koha_object_class
139
143
140
Missing POD for koha_object_class.
144
Missing POD for koha_object_class.
(-)a/installer/data/mysql/atomicupdate/bug_39835.pl (+36 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "39835",
6
    description => "Switch datatype to TINYINT(1) when boolean",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        $dbh->do(
12
            q{
13
            ALTER TABLE `issues`
14
            MODIFY COLUMN `onsite_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag',
15
            MODIFY COLUMN `noteseen` tinyint(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null'
16
        }
17
        );
18
19
        $dbh->do(
20
            q{
21
            ALTER TABLE `old_issues`
22
            MODIFY COLUMN `onsite_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag',
23
            MODIFY COLUMN `noteseen` tinyint(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null'
24
        }
25
        );
26
27
        $dbh->do(
28
            q{
29
            ALTER TABLE `overduerules`
30
            MODIFY COLUMN `debarred1` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)',
31
            MODIFY COLUMN `debarred2` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)',
32
            MODIFY COLUMN `debarred3` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)'
33
        }
34
        );
35
    },
36
};
(-)a/installer/data/mysql/kohastructure.sql (-8 / +7 lines)
Lines 3986-3995 CREATE TABLE `issues` ( Link Here
3986
  `auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error',
3986
  `auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error',
3987
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched',
3987
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched',
3988
  `issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued',
3988
  `issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued',
3989
  `onsite_checkout` int(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag',
3989
  `onsite_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag',
3990
  `note` longtext DEFAULT NULL COMMENT 'issue note text',
3990
  `note` longtext DEFAULT NULL COMMENT 'issue note text',
3991
  `notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)',
3991
  `notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)',
3992
  `noteseen` int(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null',
3992
  `noteseen` tinyint(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null',
3993
  PRIMARY KEY (`issue_id`),
3993
  PRIMARY KEY (`issue_id`),
3994
  UNIQUE KEY `itemnumber` (`itemnumber`),
3994
  UNIQUE KEY `itemnumber` (`itemnumber`),
3995
  KEY `issuesborridx` (`borrowernumber`),
3995
  KEY `issuesborridx` (`borrowernumber`),
Lines 5041-5050 CREATE TABLE `old_issues` ( Link Here
5041
  `auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error',
5041
  `auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error',
5042
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched',
5042
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched',
5043
  `issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued',
5043
  `issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued',
5044
  `onsite_checkout` int(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag',
5044
  `onsite_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag',
5045
  `note` longtext DEFAULT NULL COMMENT 'issue note text',
5045
  `note` longtext DEFAULT NULL COMMENT 'issue note text',
5046
  `notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)',
5046
  `notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)',
5047
  `noteseen` int(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null',
5047
  `noteseen` tinyint(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null',
5048
  PRIMARY KEY (`issue_id`),
5048
  PRIMARY KEY (`issue_id`),
5049
  KEY `old_issuesborridx` (`borrowernumber`),
5049
  KEY `old_issuesborridx` (`borrowernumber`),
5050
  KEY `old_issuesitemidx` (`itemnumber`),
5050
  KEY `old_issuesitemidx` (`itemnumber`),
Lines 5120-5132 CREATE TABLE `overduerules` ( Link Here
5120
  `categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the categories table to define which patron category this rule is for',
5120
  `categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the categories table to define which patron category this rule is for',
5121
  `delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent',
5121
  `delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent',
5122
  `letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice',
5122
  `letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice',
5123
  `debarred1` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)',
5123
  `debarred1` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)',
5124
  `delay2` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the second notice is sent',
5124
  `delay2` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the second notice is sent',
5125
  `debarred2` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)',
5125
  `debarred2` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)',
5126
  `letter2` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the second notice',
5126
  `letter2` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the second notice',
5127
  `delay3` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the third notice is sent',
5127
  `delay3` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the third notice is sent',
5128
  `letter3` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the third notice',
5128
  `letter3` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the third notice',
5129
  `debarred3` int(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)',
5129
  `debarred3` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)',
5130
  PRIMARY KEY (`overduerules_id`),
5130
  PRIMARY KEY (`overduerules_id`),
5131
  UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`)
5131
  UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`)
5132
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5132
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5133
- 

Return to bug 39835