Lines 598-603
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
598 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
598 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
599 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
599 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
600 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
600 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
|
|
601 |
`date_renewed` date default NULL, -- date the patron/borrower's card was last renewed |
601 |
`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 |
602 |
`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 |
602 |
`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 |
603 |
`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 |
603 |
`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) |
604 |
`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) |
Lines 1629-1634
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1629 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
1630 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
1630 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
1631 |
`dateenrolled` date default NULL, -- date the patron was added to Koha (YYYY-MM-DD) |
1631 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
1632 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
|
|
1633 |
`date_renewed` date default NULL, -- date the patron/borrower's card was last renewed |
1632 |
`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 |
1634 |
`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 |
1633 |
`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 |
1635 |
`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 |
1634 |
`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) |
1636 |
`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) |
Lines 3403-3408
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3403 |
`categorycode` varchar(10) DEFAULT NULL, |
3405 |
`categorycode` varchar(10) DEFAULT NULL, |
3404 |
`dateenrolled` date DEFAULT NULL, |
3406 |
`dateenrolled` date DEFAULT NULL, |
3405 |
`dateexpiry` date DEFAULT NULL, |
3407 |
`dateexpiry` date DEFAULT NULL, |
|
|
3408 |
`date_renewed` date default NULL, |
3406 |
`gonenoaddress` tinyint(1) DEFAULT NULL, |
3409 |
`gonenoaddress` tinyint(1) DEFAULT NULL, |
3407 |
`lost` tinyint(1) DEFAULT NULL, |
3410 |
`lost` tinyint(1) DEFAULT NULL, |
3408 |
`debarred` date DEFAULT NULL, |
3411 |
`debarred` date DEFAULT NULL, |