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

(-)a/installer/data/mysql/kohastructure.sql (-16 / +15 lines)
Lines 602-615 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
602
  `dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD)
602
  `dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD)
603
  `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
603
  `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
604
  `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
604
  `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
605
  `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)
605
  `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)
606
  `debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron
606
  `debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron
607
  `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name
607
  `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name
608
  `contactfirstname` text, -- used for children to include first name of guarentor
608
  `contactfirstname` text, -- used for children to include first name of guarantor
609
  `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor
609
  `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor
610
  `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations
610
  `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations
611
  `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client
611
  `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client
612
  `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor
612
  `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor
613
  `sex` varchar(1) default NULL, -- patron/borrower's gender
613
  `sex` varchar(1) default NULL, -- patron/borrower's gender
614
  `password` varchar(60) default NULL, -- patron/borrower's encrypted password
614
  `password` varchar(60) default NULL, -- patron/borrower's encrypted password
615
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
615
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
Lines 627-633 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
627
  `altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower
627
  `altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower
628
  `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower
628
  `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower
629
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
629
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
630
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
630
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
631
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
631
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
632
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
632
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
633
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
633
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
Lines 1639-1654 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1639
  `dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD)
1639
  `dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD)
1640
  `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
1640
  `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
1641
  `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
1641
  `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
1642
  `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)
1642
  `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)
1643
  `debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron
1643
  `debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron
1644
  `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name
1644
  `contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name
1645
  `contactfirstname` text, -- used for children to include first name of guarentor
1645
  `contactfirstname` text, -- used for children to include first name of guarantor
1646
  `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor
1646
  `contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor
1647
  `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations
1647
  `guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations
1648
  `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client
1648
  `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client
1649
  `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor
1649
  `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor
1650
  `sex` varchar(1) default NULL, -- patron/borrower's gender
1650
  `sex` varchar(1) default NULL, -- patron/borrower's gender
1651
  `password` varchar(60) default NULL, -- patron/borrower's encrypted password
1651
  `password` varchar(60) default NULL, -- patron/borrower's Bcrypt encrypted password
1652
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
1652
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
1653
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
1653
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
1654
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
1654
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
Lines 1664-1670 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1664
  `altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower
1664
  `altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower
1665
  `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower
1665
  `altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower
1666
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
1666
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
1667
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
1667
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
1668
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
1668
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
1669
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
1669
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
1670
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
1670
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
1671
- 

Return to bug 18690