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

(-)a/installer/data/mysql/atomicupdate/bug_39325.pl (+109 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  => "39325",
6
    description => "Fix some spelling mistakes",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        # avaiable ==> available
12
        $dbh->do(
13
            q{
14
            UPDATE systempreferences
15
            SET explanation="If enabled, item fields in the MARC record will be made available to XSLT sheets. Otherwise they will be removed."
16
            WHERE variable="PassItemMarcToXSLT"
17
        }
18
        );
19
20
        # foriegn ==> foreign
21
        $dbh->do(
22
            q{
23
            ALTER TABLE deletedbiblio
24
            MODIFY `frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foreign key from the biblio_framework table to identify which framework was used in cataloging this record'
25
        }
26
        );
27
28
        # addres ==> address
29
        # attemps ==> attempts
30
        # profesionals ==> professionals
31
        $dbh->do(
32
            q{
33
            ALTER TABLE borrowers
34
            MODIFY `emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email address for your patron/borrower''s primary address',
35
            MODIFY `login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attempts',
36
            MODIFY `contactname` longtext DEFAULT NULL COMMENT 'used for children and professionals to include surname or last name of guarantor or organization name'
37
        }
38
        );
39
40
        # addres ==> address
41
        # attemps ==> attempts
42
        # profesionals ==> professionals
43
        $dbh->do(
44
            q{
45
            ALTER TABLE deletedborrowers
46
            MODIFY `emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email address for your patron/borrower''s primary address',
47
            MODIFY `login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attempts',
48
            MODIFY `contactname` longtext DEFAULT NULL COMMENT 'used for children and professionals to include surname or last name of guarantor or organization name'
49
        }
50
        );
51
52
        # agains ==> against
53
        $dbh->do(
54
            q{
55
            ALTER TABLE club_holds
56
            MODIFY `item_id` int(11) DEFAULT NULL COMMENT 'If item-level, the id for the item the hold has been placed against'
57
        }
58
        );
59
60
        # intented ==> intended
61
        $dbh->do(
62
            q{
63
            ALTER TABLE items
64
            MODIFY `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.'
65
        }
66
        );
67
68
        # intented ==> intended
69
        $dbh->do(
70
            q{
71
            ALTER TABLE deleteditems
72
            MODIFY `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.'
73
        }
74
        );
75
76
        # definining ==> defining
77
        $dbh->do(
78
            q{
79
            ALTER TABLE housebound_profile
80
            MODIFY `frequency` mediumtext NOT NULL COMMENT 'The Authorised_Value defining the pattern for delivery.'
81
        }
82
        );
83
84
        # goup ==> group
85
        $dbh->do(
86
            q{
87
            ALTER TABLE library_groups
88
            MODIFY `title` varchar(100) DEFAULT NULL COMMENT 'Short description of the group'
89
        }
90
        );
91
92
        # shoud ==> should
93
        $dbh->do(
94
            q{
95
            ALTER TABLE stockrotationstages
96
            MODIFY `duration` int(11) NOT NULL DEFAULT 4 COMMENT 'The number of days items should occupy this stage'
97
        }
98
        );
99
100
        # thist ==> this
101
        $dbh->do(
102
            q{
103
            ALTER TABLE virtualshelfshares
104
            MODIFY `invitekey` varchar(10) DEFAULT NULL COMMENT 'temporary string used in accepting the invitation to access this list; not-empty means that the invitation has not been accepted yet'
105
        }
106
        );
107
108
    },
109
};
(-)a/installer/data/mysql/db_revs/220600059.pl (-4 / +4 lines)
Lines 8-18 return { Link Here
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
9
10
        # Add PASSWORD_CHANGE notice
10
        # Add PASSWORD_CHANGE notice
11
        my $message = "Dear [% borrower.firstname %] [% borrower.surname %],\r\n\r\n"
12
            . "We want to notify you that your password has been changed. If you did not change it yourself (or requested that change), please contact library staff.\r\n\r\nYour library.";
11
        $dbh->do(
13
        $dbh->do(
12
            q{
14
            q{INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('members', 'PASSWORD_CHANGE', 'Notification of password change', 'Library account password change notification',?, 'email');},
13
            INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('members', 'PASSWORD_CHANGE', 'Notification of password change', 'Library account password change notification',
15
            $message
14
            "Dear [% borrower.firstname %] [% borrower.surname %],\r\n\r\new want to notify you that your password has been changed. If you did not change it yourself (or requested that change), please contact library staff.\r\n\r\nYour library.", 'email');
15
        }
16
        );
16
        );
17
17
18
        say $out "Added new letter 'PASSWORD_CHANGE' (email)";
18
        say $out "Added new letter 'PASSWORD_CHANGE' (email)";
(-)a/installer/data/mysql/kohastructure.sql (-13 / +13 lines)
Lines 1546-1552 CREATE TABLE `borrowers` ( Link Here
1546
  `phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address',
1546
  `phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address',
1547
  `mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address',
1547
  `mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address',
1548
  `fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address',
1548
  `fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address',
1549
  `emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email addres for your patron/borrower''s primary address',
1549
  `emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email address for your patron/borrower''s primary address',
1550
  `phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address',
1550
  `phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address',
1551
  `B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address',
1551
  `B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address',
1552
  `B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address',
1552
  `B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address',
Lines 1569-1575 CREATE TABLE `borrowers` ( Link Here
1569
  `lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card',
1569
  `lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card',
1570
  `debarred` date DEFAULT NULL COMMENT 'until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD)',
1570
  `debarred` date DEFAULT NULL COMMENT 'until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD)',
1571
  `debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of the patron',
1571
  `debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of the patron',
1572
  `contactname` longtext DEFAULT NULL COMMENT 'used for children and profesionals to include surname or last name of guarantor or organization name',
1572
  `contactname` longtext DEFAULT NULL COMMENT 'used for children and professionals to include surname or last name of guarantor or organization name',
1573
  `contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
1573
  `contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
1574
  `contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
1574
  `contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
1575
  `borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
1575
  `borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
Lines 1602-1608 CREATE TABLE `borrowers` ( Link Here
1602
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'time of last change could be useful for synchronization with external systems (among others)',
1602
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'time of last change could be useful for synchronization with external systems (among others)',
1603
  `lastseen` datetime DEFAULT NULL COMMENT 'last time a patron has been seen (connected at the OPAC or staff interface)',
1603
  `lastseen` datetime DEFAULT NULL COMMENT 'last time a patron has been seen (connected at the OPAC or staff interface)',
1604
  `lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang to use to send notices to this patron',
1604
  `lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang to use to send notices to this patron',
1605
  `login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attemps',
1605
  `login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attempts',
1606
  `overdrive_auth_token` mediumtext DEFAULT NULL COMMENT 'persist OverDrive auth token',
1606
  `overdrive_auth_token` mediumtext DEFAULT NULL COMMENT 'persist OverDrive auth token',
1607
  `anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization',
1607
  `anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization',
1608
  `autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal',
1608
  `autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal',
Lines 2037-2043 CREATE TABLE `club_holds` ( Link Here
2037
  `id` int(11) NOT NULL AUTO_INCREMENT,
2037
  `id` int(11) NOT NULL AUTO_INCREMENT,
2038
  `club_id` int(11) NOT NULL COMMENT 'id for the club the hold was generated for',
2038
  `club_id` int(11) NOT NULL COMMENT 'id for the club the hold was generated for',
2039
  `biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the hold has been placed against',
2039
  `biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the hold has been placed against',
2040
  `item_id` int(11) DEFAULT NULL COMMENT 'If item-level, the id for the item the hold has been placed agains',
2040
  `item_id` int(11) DEFAULT NULL COMMENT 'If item-level, the id for the item the hold has been placed against',
2041
  `date_created` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Timestamp for the placed hold',
2041
  `date_created` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Timestamp for the placed hold',
2042
  PRIMARY KEY (`id`),
2042
  PRIMARY KEY (`id`),
2043
  KEY `clubs_holds_ibfk_1` (`club_id`),
2043
  KEY `clubs_holds_ibfk_1` (`club_id`),
Lines 2582-2588 DROP TABLE IF EXISTS `deletedbiblio`; Link Here
2582
/*!40101 SET character_set_client = utf8 */;
2582
/*!40101 SET character_set_client = utf8 */;
2583
CREATE TABLE `deletedbiblio` (
2583
CREATE TABLE `deletedbiblio` (
2584
  `biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record',
2584
  `biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record',
2585
  `frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foriegn key from the biblio_framework table to identify which framework was used in cataloging this record',
2585
  `frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foreign key from the biblio_framework table to identify which framework was used in cataloging this record',
2586
  `author` longtext DEFAULT NULL COMMENT 'statement of responsibility from MARC record (100$a in MARC21)',
2586
  `author` longtext DEFAULT NULL COMMENT 'statement of responsibility from MARC record (100$a in MARC21)',
2587
  `title` longtext DEFAULT NULL COMMENT 'title (without the subtitle) from the MARC record (245$a in MARC21)',
2587
  `title` longtext DEFAULT NULL COMMENT 'title (without the subtitle) from the MARC record (245$a in MARC21)',
2588
  `medium` longtext DEFAULT NULL COMMENT 'medium from the MARC record (245$h in MARC21)',
2588
  `medium` longtext DEFAULT NULL COMMENT 'medium from the MARC record (245$h in MARC21)',
Lines 2707-2713 CREATE TABLE `deletedborrowers` ( Link Here
2707
  `phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address',
2707
  `phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address',
2708
  `mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address',
2708
  `mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address',
2709
  `fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address',
2709
  `fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address',
2710
  `emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email addres for your patron/borrower''s primary address',
2710
  `emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email address for your patron/borrower''s primary address',
2711
  `phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address',
2711
  `phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address',
2712
  `B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address',
2712
  `B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address',
2713
  `B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address',
2713
  `B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address',
Lines 2730-2736 CREATE TABLE `deletedborrowers` ( Link Here
2730
  `lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card',
2730
  `lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card',
2731
  `debarred` date DEFAULT NULL COMMENT 'until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD)',
2731
  `debarred` date DEFAULT NULL COMMENT 'until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD)',
2732
  `debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of patron',
2732
  `debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of patron',
2733
  `contactname` longtext DEFAULT NULL COMMENT 'used for children and profesionals to include surname or last name of guarantor or organization name',
2733
  `contactname` longtext DEFAULT NULL COMMENT 'used for children and professionals to include surname or last name of guarantor or organization name',
2734
  `contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
2734
  `contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor',
2735
  `contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
2735
  `contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor',
2736
  `borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
2736
  `borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface',
Lines 2829-2835 CREATE TABLE `deleteditems` ( Link Here
2829
  `enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)',
2829
  `enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)',
2830
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
2830
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
2831
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
2831
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
2832
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.',
2832
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.',
2833
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
2833
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
2834
  PRIMARY KEY (`itemnumber`),
2834
  PRIMARY KEY (`itemnumber`),
2835
  KEY `delitembarcodeidx` (`barcode`),
2835
  KEY `delitembarcodeidx` (`barcode`),
Lines 3521-3527 DROP TABLE IF EXISTS `housebound_profile`; Link Here
3521
CREATE TABLE `housebound_profile` (
3521
CREATE TABLE `housebound_profile` (
3522
  `borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower associated with this profile.',
3522
  `borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower associated with this profile.',
3523
  `day` mediumtext NOT NULL COMMENT 'The preferred day of the week for delivery.',
3523
  `day` mediumtext NOT NULL COMMENT 'The preferred day of the week for delivery.',
3524
  `frequency` mediumtext NOT NULL COMMENT 'The Authorised_Value definining the pattern for delivery.',
3524
  `frequency` mediumtext NOT NULL COMMENT 'The Authorised_Value defining the pattern for delivery.',
3525
  `fav_itemtypes` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred itemtypes.',
3525
  `fav_itemtypes` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred itemtypes.',
3526
  `fav_subjects` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred subjects.',
3526
  `fav_subjects` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred subjects.',
3527
  `fav_authors` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred authors.',
3527
  `fav_authors` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred authors.',
Lines 4150-4156 CREATE TABLE `items` ( Link Here
4150
  `enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)',
4150
  `enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)',
4151
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
4151
  `copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)',
4152
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
4152
  `stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)',
4153
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.',
4153
  `new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.',
4154
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
4154
  `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority',
4155
  PRIMARY KEY (`itemnumber`),
4155
  PRIMARY KEY (`itemnumber`),
4156
  UNIQUE KEY `itembarcodeidx` (`barcode`),
4156
  UNIQUE KEY `itembarcodeidx` (`barcode`),
Lines 4397-4403 CREATE TABLE `library_groups` ( Link Here
4397
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for each group',
4397
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for each group',
4398
  `parent_id` int(11) DEFAULT NULL COMMENT 'if this is a child group, the id of the parent group',
4398
  `parent_id` int(11) DEFAULT NULL COMMENT 'if this is a child group, the id of the parent group',
4399
  `branchcode` varchar(10) DEFAULT NULL COMMENT 'The branchcode of a branch belonging to the parent group',
4399
  `branchcode` varchar(10) DEFAULT NULL COMMENT 'The branchcode of a branch belonging to the parent group',
4400
  `title` varchar(100) DEFAULT NULL COMMENT 'Short description of the goup',
4400
  `title` varchar(100) DEFAULT NULL COMMENT 'Short description of the group',
4401
  `description` mediumtext DEFAULT NULL COMMENT 'Longer explanation of the group, if necessary',
4401
  `description` mediumtext DEFAULT NULL COMMENT 'Longer explanation of the group, if necessary',
4402
  `ft_hide_patron_info` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature ''Hide patron''s info'' for this group',
4402
  `ft_hide_patron_info` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature ''Hide patron''s info'' for this group',
4403
  `ft_limit_item_editing` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature "Limit item editing by group" for this group',
4403
  `ft_limit_item_editing` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature "Limit item editing by group" for this group',
Lines 6124-6130 CREATE TABLE `stockrotationstages` ( Link Here
6124
  `position` int(11) NOT NULL COMMENT 'The position of this stage within its rota',
6124
  `position` int(11) NOT NULL COMMENT 'The position of this stage within its rota',
6125
  `rota_id` int(11) NOT NULL COMMENT 'The rota this stage belongs to',
6125
  `rota_id` int(11) NOT NULL COMMENT 'The rota this stage belongs to',
6126
  `branchcode_id` varchar(10) NOT NULL COMMENT 'Branch this stage relates to',
6126
  `branchcode_id` varchar(10) NOT NULL COMMENT 'Branch this stage relates to',
6127
  `duration` int(11) NOT NULL DEFAULT 4 COMMENT 'The number of days items shoud occupy this stage',
6127
  `duration` int(11) NOT NULL DEFAULT 4 COMMENT 'The number of days items should occupy this stage',
6128
  PRIMARY KEY (`stage_id`),
6128
  PRIMARY KEY (`stage_id`),
6129
  KEY `stockrotationstages_rifk` (`rota_id`),
6129
  KEY `stockrotationstages_rifk` (`rota_id`),
6130
  KEY `stockrotationstages_bifk` (`branchcode_id`),
6130
  KEY `stockrotationstages_bifk` (`branchcode_id`),
Lines 6704-6710 CREATE TABLE `virtualshelfshares` ( Link Here
6704
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key',
6704
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key',
6705
  `shelfnumber` int(11) NOT NULL COMMENT 'foreign key for virtualshelves',
6705
  `shelfnumber` int(11) NOT NULL COMMENT 'foreign key for virtualshelves',
6706
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'borrower that accepted access to this list',
6706
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'borrower that accepted access to this list',
6707
  `invitekey` varchar(10) DEFAULT NULL COMMENT 'temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet',
6707
  `invitekey` varchar(10) DEFAULT NULL COMMENT 'temporary string used in accepting the invitation to access this list; not-empty means that the invitation has not been accepted yet',
6708
  `sharedate` datetime DEFAULT NULL COMMENT 'date of invitation or acceptance of invitation',
6708
  `sharedate` datetime DEFAULT NULL COMMENT 'date of invitation or acceptance of invitation',
6709
  PRIMARY KEY (`id`),
6709
  PRIMARY KEY (`id`),
6710
  KEY `virtualshelfshares_ibfk_1` (`shelfnumber`),
6710
  KEY `virtualshelfshares_ibfk_1` (`shelfnumber`),
(-)a/installer/data/mysql/mandatory/sysprefs.sql (-2 / +1 lines)
Lines 611-617 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
611
('OverdueNoticeFrom', 'cron', 'cron|item-issuebranch|item-homebranch', 'Organize and send overdue notices by item home library or checkout library', 'Choice'),
611
('OverdueNoticeFrom', 'cron', 'cron|item-issuebranch|item-homebranch', 'Organize and send overdue notices by item home library or checkout library', 'Choice'),
612
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
612
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
613
('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'),
613
('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'),
614
('PassItemMarcToXSLT','0',NULL,'If enabled, item fields in the MARC record will be made avaiable to XSLT sheets. Otherwise they will be removed.','YesNo'),
614
('PassItemMarcToXSLT','0',NULL,'If enabled, item fields in the MARC record will be made available to XSLT sheets. Otherwise they will be removed.','YesNo'),
615
('PatronAnonymizeDelay','',NULL,'Delay for anonymizing patrons', 'Integer'),
615
('PatronAnonymizeDelay','',NULL,'Delay for anonymizing patrons', 'Integer'),
616
('PatronAutoComplete','1','Try|Don\'t try','to guess the patron being entered while typing a patron search for circulation or patron search. Only returns the first 10 results at a time.','YesNo'),
616
('PatronAutoComplete','1','Try|Don\'t try','to guess the patron being entered while typing a patron search for circulation or patron search. Only returns the first 10 results at a time.','YesNo'),
617
('PatronDuplicateMatchingAddFields','surname|firstname|dateofbirth', NULL,'A list of fields separated by "|" to deduplicate patrons when created','Free'),
617
('PatronDuplicateMatchingAddFields','surname|firstname|dateofbirth', NULL,'A list of fields separated by "|" to deduplicate patrons when created','Free'),
618
- 

Return to bug 39325