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 |
- |
|
|