Lines 1546-1552
CREATE TABLE `borrowers` (
Link Here
|
1546 |
`phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address', |
1546 |
`phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address', |
1547 |
`mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address', |
1547 |
`mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address', |
1548 |
`fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address', |
1548 |
`fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address', |
1549 |
`emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email addres for your patron/borrower''s primary address', |
1549 |
`emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email address for your patron/borrower''s primary address', |
1550 |
`phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address', |
1550 |
`phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address', |
1551 |
`B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address', |
1551 |
`B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address', |
1552 |
`B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address', |
1552 |
`B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address', |
Lines 1569-1575
CREATE TABLE `borrowers` (
Link Here
|
1569 |
`lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card', |
1569 |
`lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card', |
1570 |
`debarred` date DEFAULT NULL COMMENT '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)', |
1570 |
`debarred` date DEFAULT NULL COMMENT '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)', |
1571 |
`debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of the patron', |
1571 |
`debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of the patron', |
1572 |
`contactname` longtext DEFAULT NULL COMMENT 'used for children and profesionals to include surname or last name of guarantor or organization name', |
1572 |
`contactname` longtext DEFAULT NULL COMMENT 'used for children and professionals to include surname or last name of guarantor or organization name', |
1573 |
`contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
1573 |
`contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
1574 |
`contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
1574 |
`contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
1575 |
`borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
1575 |
`borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
Lines 1602-1608
CREATE TABLE `borrowers` (
Link Here
|
1602 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'time of last change could be useful for synchronization with external systems (among others)', |
1602 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'time of last change could be useful for synchronization with external systems (among others)', |
1603 |
`lastseen` datetime DEFAULT NULL COMMENT 'last time a patron has been seen (connected at the OPAC or staff interface)', |
1603 |
`lastseen` datetime DEFAULT NULL COMMENT 'last time a patron has been seen (connected at the OPAC or staff interface)', |
1604 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang to use to send notices to this patron', |
1604 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang to use to send notices to this patron', |
1605 |
`login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attemps', |
1605 |
`login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attempts', |
1606 |
`overdrive_auth_token` mediumtext DEFAULT NULL COMMENT 'persist OverDrive auth token', |
1606 |
`overdrive_auth_token` mediumtext DEFAULT NULL COMMENT 'persist OverDrive auth token', |
1607 |
`anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization', |
1607 |
`anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization', |
1608 |
`autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal', |
1608 |
`autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal', |
Lines 2037-2043
CREATE TABLE `club_holds` (
Link Here
|
2037 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2037 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
2038 |
`club_id` int(11) NOT NULL COMMENT 'id for the club the hold was generated for', |
2038 |
`club_id` int(11) NOT NULL COMMENT 'id for the club the hold was generated for', |
2039 |
`biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the hold has been placed against', |
2039 |
`biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the hold has been placed against', |
2040 |
`item_id` int(11) DEFAULT NULL COMMENT 'If item-level, the id for the item the hold has been placed agains', |
2040 |
`item_id` int(11) DEFAULT NULL COMMENT 'If item-level, the id for the item the hold has been placed against', |
2041 |
`date_created` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Timestamp for the placed hold', |
2041 |
`date_created` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Timestamp for the placed hold', |
2042 |
PRIMARY KEY (`id`), |
2042 |
PRIMARY KEY (`id`), |
2043 |
KEY `clubs_holds_ibfk_1` (`club_id`), |
2043 |
KEY `clubs_holds_ibfk_1` (`club_id`), |
Lines 2582-2588
DROP TABLE IF EXISTS `deletedbiblio`;
Link Here
|
2582 |
/*!40101 SET character_set_client = utf8 */; |
2582 |
/*!40101 SET character_set_client = utf8 */; |
2583 |
CREATE TABLE `deletedbiblio` ( |
2583 |
CREATE TABLE `deletedbiblio` ( |
2584 |
`biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record', |
2584 |
`biblionumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned to each bibliographic record', |
2585 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foriegn key from the biblio_framework table to identify which framework was used in cataloging this record', |
2585 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'foreign key from the biblio_framework table to identify which framework was used in cataloging this record', |
2586 |
`author` longtext DEFAULT NULL COMMENT 'statement of responsibility from MARC record (100$a in MARC21)', |
2586 |
`author` longtext DEFAULT NULL COMMENT 'statement of responsibility from MARC record (100$a in MARC21)', |
2587 |
`title` longtext DEFAULT NULL COMMENT 'title (without the subtitle) from the MARC record (245$a in MARC21)', |
2587 |
`title` longtext DEFAULT NULL COMMENT 'title (without the subtitle) from the MARC record (245$a in MARC21)', |
2588 |
`medium` longtext DEFAULT NULL COMMENT 'medium from the MARC record (245$h in MARC21)', |
2588 |
`medium` longtext DEFAULT NULL COMMENT 'medium from the MARC record (245$h in MARC21)', |
Lines 2707-2713
CREATE TABLE `deletedborrowers` (
Link Here
|
2707 |
`phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address', |
2707 |
`phone` mediumtext DEFAULT NULL COMMENT 'the primary phone number for your patron/borrower''s primary address', |
2708 |
`mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address', |
2708 |
`mobile` tinytext DEFAULT NULL COMMENT 'the other phone number for your patron/borrower''s primary address', |
2709 |
`fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address', |
2709 |
`fax` longtext DEFAULT NULL COMMENT 'the fax number for your patron/borrower''s primary address', |
2710 |
`emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email addres for your patron/borrower''s primary address', |
2710 |
`emailpro` mediumtext DEFAULT NULL COMMENT 'the secondary email address for your patron/borrower''s primary address', |
2711 |
`phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address', |
2711 |
`phonepro` mediumtext DEFAULT NULL COMMENT 'the secondary phone number for your patron/borrower''s primary address', |
2712 |
`B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address', |
2712 |
`B_streetnumber` tinytext DEFAULT NULL COMMENT 'the house number for your patron/borrower''s alternate address', |
2713 |
`B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address', |
2713 |
`B_streettype` tinytext DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s alternate address', |
Lines 2730-2736
CREATE TABLE `deletedborrowers` (
Link Here
|
2730 |
`lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card', |
2730 |
`lost` tinyint(1) DEFAULT NULL COMMENT 'set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card', |
2731 |
`debarred` date DEFAULT NULL COMMENT '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)', |
2731 |
`debarred` date DEFAULT NULL COMMENT '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)', |
2732 |
`debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of patron', |
2732 |
`debarredcomment` varchar(255) DEFAULT NULL COMMENT 'comment on the stop of patron', |
2733 |
`contactname` longtext DEFAULT NULL COMMENT 'used for children and profesionals to include surname or last name of guarantor or organization name', |
2733 |
`contactname` longtext DEFAULT NULL COMMENT 'used for children and professionals to include surname or last name of guarantor or organization name', |
2734 |
`contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
2734 |
`contactfirstname` mediumtext DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
2735 |
`contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
2735 |
`contacttitle` mediumtext DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
2736 |
`borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
2736 |
`borrowernotes` longtext DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
Lines 2829-2835
CREATE TABLE `deleteditems` (
Link Here
|
2829 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
2829 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
2830 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
2830 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
2831 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2831 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2832 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', |
2832 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.', |
2833 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
2833 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
2834 |
PRIMARY KEY (`itemnumber`), |
2834 |
PRIMARY KEY (`itemnumber`), |
2835 |
KEY `delitembarcodeidx` (`barcode`), |
2835 |
KEY `delitembarcodeidx` (`barcode`), |
Lines 3521-3527
DROP TABLE IF EXISTS `housebound_profile`;
Link Here
|
3521 |
CREATE TABLE `housebound_profile` ( |
3521 |
CREATE TABLE `housebound_profile` ( |
3522 |
`borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower associated with this profile.', |
3522 |
`borrowernumber` int(11) NOT NULL COMMENT 'Number of the borrower associated with this profile.', |
3523 |
`day` mediumtext NOT NULL COMMENT 'The preferred day of the week for delivery.', |
3523 |
`day` mediumtext NOT NULL COMMENT 'The preferred day of the week for delivery.', |
3524 |
`frequency` mediumtext NOT NULL COMMENT 'The Authorised_Value definining the pattern for delivery.', |
3524 |
`frequency` mediumtext NOT NULL COMMENT 'The Authorised_Value defining the pattern for delivery.', |
3525 |
`fav_itemtypes` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred itemtypes.', |
3525 |
`fav_itemtypes` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred itemtypes.', |
3526 |
`fav_subjects` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred subjects.', |
3526 |
`fav_subjects` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred subjects.', |
3527 |
`fav_authors` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred authors.', |
3527 |
`fav_authors` mediumtext DEFAULT NULL COMMENT 'Free text describing preferred authors.', |
Lines 4150-4156
CREATE TABLE `items` (
Link Here
|
4150 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
4150 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
4151 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
4151 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
4152 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4152 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4153 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', |
4153 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.', |
4154 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
4154 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
4155 |
PRIMARY KEY (`itemnumber`), |
4155 |
PRIMARY KEY (`itemnumber`), |
4156 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
4156 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
Lines 4397-4403
CREATE TABLE `library_groups` (
Link Here
|
4397 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for each group', |
4397 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for each group', |
4398 |
`parent_id` int(11) DEFAULT NULL COMMENT 'if this is a child group, the id of the parent group', |
4398 |
`parent_id` int(11) DEFAULT NULL COMMENT 'if this is a child group, the id of the parent group', |
4399 |
`branchcode` varchar(10) DEFAULT NULL COMMENT 'The branchcode of a branch belonging to the parent group', |
4399 |
`branchcode` varchar(10) DEFAULT NULL COMMENT 'The branchcode of a branch belonging to the parent group', |
4400 |
`title` varchar(100) DEFAULT NULL COMMENT 'Short description of the goup', |
4400 |
`title` varchar(100) DEFAULT NULL COMMENT 'Short description of the group', |
4401 |
`description` mediumtext DEFAULT NULL COMMENT 'Longer explanation of the group, if necessary', |
4401 |
`description` mediumtext DEFAULT NULL COMMENT 'Longer explanation of the group, if necessary', |
4402 |
`ft_hide_patron_info` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature ''Hide patron''s info'' for this group', |
4402 |
`ft_hide_patron_info` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature ''Hide patron''s info'' for this group', |
4403 |
`ft_limit_item_editing` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature "Limit item editing by group" for this group', |
4403 |
`ft_limit_item_editing` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Turn on the feature "Limit item editing by group" for this group', |
Lines 6124-6130
CREATE TABLE `stockrotationstages` (
Link Here
|
6124 |
`position` int(11) NOT NULL COMMENT 'The position of this stage within its rota', |
6124 |
`position` int(11) NOT NULL COMMENT 'The position of this stage within its rota', |
6125 |
`rota_id` int(11) NOT NULL COMMENT 'The rota this stage belongs to', |
6125 |
`rota_id` int(11) NOT NULL COMMENT 'The rota this stage belongs to', |
6126 |
`branchcode_id` varchar(10) NOT NULL COMMENT 'Branch this stage relates to', |
6126 |
`branchcode_id` varchar(10) NOT NULL COMMENT 'Branch this stage relates to', |
6127 |
`duration` int(11) NOT NULL DEFAULT 4 COMMENT 'The number of days items shoud occupy this stage', |
6127 |
`duration` int(11) NOT NULL DEFAULT 4 COMMENT 'The number of days items should occupy this stage', |
6128 |
PRIMARY KEY (`stage_id`), |
6128 |
PRIMARY KEY (`stage_id`), |
6129 |
KEY `stockrotationstages_rifk` (`rota_id`), |
6129 |
KEY `stockrotationstages_rifk` (`rota_id`), |
6130 |
KEY `stockrotationstages_bifk` (`branchcode_id`), |
6130 |
KEY `stockrotationstages_bifk` (`branchcode_id`), |
Lines 6704-6710
CREATE TABLE `virtualshelfshares` (
Link Here
|
6704 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key', |
6704 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key', |
6705 |
`shelfnumber` int(11) NOT NULL COMMENT 'foreign key for virtualshelves', |
6705 |
`shelfnumber` int(11) NOT NULL COMMENT 'foreign key for virtualshelves', |
6706 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'borrower that accepted access to this list', |
6706 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'borrower that accepted access to this list', |
6707 |
`invitekey` varchar(10) DEFAULT NULL COMMENT 'temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet', |
6707 |
`invitekey` varchar(10) DEFAULT NULL COMMENT 'temporary string used in accepting the invitation to access this list; not-empty means that the invitation has not been accepted yet', |
6708 |
`sharedate` datetime DEFAULT NULL COMMENT 'date of invitation or acceptance of invitation', |
6708 |
`sharedate` datetime DEFAULT NULL COMMENT 'date of invitation or acceptance of invitation', |
6709 |
PRIMARY KEY (`id`), |
6709 |
PRIMARY KEY (`id`), |
6710 |
KEY `virtualshelfshares_ibfk_1` (`shelfnumber`), |
6710 |
KEY `virtualshelfshares_ibfk_1` (`shelfnumber`), |