Bugzilla – Attachment 63833 Details for
Bug 18690
Typos in Koha database description (Table "borrowers")
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18690 - Typos in Koha database description (Table "borrowers")
Bug-18690---Typos-in-Koha-database-description-Tab.patch (text/plain), 7.88 KB, created by
Marc Véron
on 2017-05-29 18:16:20 UTC
(
hide
)
Description:
Bug 18690 - Typos in Koha database description (Table "borrowers")
Filename:
MIME Type:
Creator:
Marc Véron
Created:
2017-05-29 18:16:20 UTC
Size:
7.88 KB
patch
obsolete
>From fdf8184288d27b2b07010febebb22e6f2571dbe4 Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Marc=20V=C3=A9ron?= <veron@veron.ch> >Date: Mon, 29 May 2017 20:13:03 +0200 >Subject: [PATCH] Bug 18690 - Typos in Koha database description (Table > "borrowers") > >This string patch fixes typos in kohastructure.sql as described in initial >comment. > >To test: >- Carefully verify that string changes make sense >--- > installer/data/mysql/kohastructure.sql | 30 +++++++++++++++--------------- > 1 file changed, 15 insertions(+), 15 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index c293b79..5b30d15 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -602,14 +602,14 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower > `dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) > `gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address > `lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card >- `debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYY-MM-DD) >+ `debarred` date default NULL, -- 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) > `debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron >- `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name >- `contactfirstname` text, -- used for children to include first name of guarentor >- `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor >- `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations >+ `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name >+ `contactfirstname` text, -- used for children to include first name of guarantor >+ `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor >+ `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations > `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client >- `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor >+ `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor > `sex` varchar(1) default NULL, -- patron/borrower's gender > `password` varchar(60) default NULL, -- patron/borrower's encrypted password > `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions >@@ -627,7 +627,7 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower > `altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower > `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower > `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower >- `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) >+ `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) > `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber > `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), > `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts >@@ -1638,16 +1638,16 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons > `dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) > `gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address > `lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card >- `debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYY-MM-DD) >+ `debarred` date default NULL, -- 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) > `debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron >- `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name >- `contactfirstname` text, -- used for children to include first name of guarentor >- `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor >- `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations >+ `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name >+ `contactfirstname` text, -- used for children to include first name of guarantor >+ `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor >+ `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations > `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client >- `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor >+ `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor > `sex` varchar(1) default NULL, -- patron/borrower's gender >- `password` varchar(60) default NULL, -- patron/borrower's encrypted password >+ `password` varchar(60) default NULL, -- patron/borrower's Bcrypt encrypted password > `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions > `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in > `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client >@@ -1663,7 +1663,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons > `altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower > `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower > `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower >- `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) >+ `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) > `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber > `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history > `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts >-- >2.1.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 18690
:
63833
|
63997