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

(-)a/installer/data/mysql/atomicupdate/bug_20144_update_borrowers_table.sql (+2 lines)
Line 0 Link Here
1
ALTER TABLE borrowers MODIFY surname MEDIUMTEXT, MODIFY address MEDIUMTEXT, MODIFY city MEDIUMTEXT;
2
ALTER TABLE deletedborrowers MODIFY surname MEDIUMTEXT, MODIFY address MEDIUMTEXT, MODIFY city MEDIUMTEXT;
(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
Lines 569-584 DROP TABLE IF EXISTS `deletedborrowers`; Link Here
569
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrowers you have deleted
569
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrowers you have deleted
570
  `borrowernumber` int(11) NOT NULL default 0, -- primary key, Koha assigned ID number for patrons/borrowers
570
  `borrowernumber` int(11) NOT NULL default 0, -- primary key, Koha assigned ID number for patrons/borrowers
571
  `cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers
571
  `cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers
572
  `surname` mediumtext NOT NULL, -- patron/borrower's last name (surname)
572
  `surname` mediumtext, -- patron/borrower's last name (surname)
573
  `firstname` text, -- patron/borrower's first name
573
  `firstname` text, -- patron/borrower's first name
574
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
574
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
575
  `othernames` mediumtext, -- any other names associated with the patron/borrower
575
  `othernames` mediumtext, -- any other names associated with the patron/borrower
576
  `initials` text, -- initials for your patron/borrower
576
  `initials` text, -- initials for your patron/borrower
577
  `streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address
577
  `streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address
578
  `streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address
578
  `streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address
579
  `address` mediumtext NOT NULL, -- the first address line for your patron/borrower's primary address
579
  `address` mediumtext, -- the first address line for your patron/borrower's primary address
580
  `address2` text, -- the second address line for your patron/borrower's primary address
580
  `address2` text, -- the second address line for your patron/borrower's primary address
581
  `city` mediumtext NOT NULL, -- the city or town for your patron/borrower's primary address
581
  `city` mediumtext, -- the city or town for your patron/borrower's primary address
582
  `state` text default NULL, -- the state or province for your patron/borrower's primary address
582
  `state` text default NULL, -- the state or province for your patron/borrower's primary address
583
  `zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address
583
  `zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address
584
  `country` text, -- the country for your patron/borrower's primary address
584
  `country` text, -- the country for your patron/borrower's primary address
Lines 1594-1609 DROP TABLE IF EXISTS `borrowers`; Link Here
1594
CREATE TABLE `borrowers` ( -- this table includes information about your patrons/borrowers/members
1594
CREATE TABLE `borrowers` ( -- this table includes information about your patrons/borrowers/members
1595
  `borrowernumber` int(11) NOT NULL auto_increment, -- primary key, Koha assigned ID number for patrons/borrowers
1595
  `borrowernumber` int(11) NOT NULL auto_increment, -- primary key, Koha assigned ID number for patrons/borrowers
1596
  `cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers
1596
  `cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers
1597
  `surname` mediumtext NOT NULL, -- patron/borrower's last name (surname)
1597
  `surname` mediumtext, -- patron/borrower's last name (surname)
1598
  `firstname` text, -- patron/borrower's first name
1598
  `firstname` text, -- patron/borrower's first name
1599
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
1599
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
1600
  `othernames` mediumtext, -- any other names associated with the patron/borrower
1600
  `othernames` mediumtext, -- any other names associated with the patron/borrower
1601
  `initials` text, -- initials for your patron/borrower
1601
  `initials` text, -- initials for your patron/borrower
1602
  `streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address
1602
  `streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address
1603
  `streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address
1603
  `streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address
1604
  `address` mediumtext NOT NULL, -- the first address line for your patron/borrower's primary address
1604
  `address` mediumtext, -- the first address line for your patron/borrower's primary address
1605
  `address2` text, -- the second address line for your patron/borrower's primary address
1605
  `address2` text, -- the second address line for your patron/borrower's primary address
1606
  `city` mediumtext NOT NULL, -- the city or town for your patron/borrower's primary address
1606
  `city` mediumtext, -- the city or town for your patron/borrower's primary address
1607
  `state` text default NULL, -- the state or province for your patron/borrower's primary address
1607
  `state` text default NULL, -- the state or province for your patron/borrower's primary address
1608
  `zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address
1608
  `zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address
1609
  `country` text, -- the country for your patron/borrower's primary address
1609
  `country` text, -- the country for your patron/borrower's primary address
1610
- 

Return to bug 20144