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