Lines 1326-1332
CREATE TABLE saved_sql ( -- saved sql reports
Link Here
|
1326 |
`type` varchar(255) default NULL, -- always 1 for tabular |
1326 |
`type` varchar(255) default NULL, -- always 1 for tabular |
1327 |
`notes` MEDIUMTEXT, -- the notes or description given to this report |
1327 |
`notes` MEDIUMTEXT, -- the notes or description given to this report |
1328 |
`cache_expiry` int NOT NULL default 300, |
1328 |
`cache_expiry` int NOT NULL default 300, |
1329 |
`public` boolean NOT NULL default FALSE, |
1329 |
`public` tinyint(1) NOT NULL default FALSE, |
1330 |
report_area varchar(6) default NULL, |
1330 |
report_area varchar(6) default NULL, |
1331 |
report_group varchar(80) default NULL, |
1331 |
report_group varchar(80) default NULL, |
1332 |
report_subgroup varchar(80) default NULL, |
1332 |
report_subgroup varchar(80) default NULL, |
Lines 1411-1419
CREATE TABLE `search_marc_to_field` (
Link Here
|
1411 |
search tinyint(1) NOT NULL DEFAULT 1, |
1411 |
search tinyint(1) NOT NULL DEFAULT 1, |
1412 |
search_marc_map_id int(11) NOT NULL, |
1412 |
search_marc_map_id int(11) NOT NULL, |
1413 |
search_field_id int(11) NOT NULL, |
1413 |
search_field_id int(11) NOT NULL, |
1414 |
facet boolean DEFAULT FALSE COMMENT 'true if a facet field should be generated for this', |
1414 |
facet tinyint(1) DEFAULT FALSE COMMENT 'true if a facet field should be generated for this', |
1415 |
suggestible boolean DEFAULT FALSE COMMENT 'true if this field can be used to generate suggestions for browse', |
1415 |
suggestible tinyint(1) DEFAULT FALSE COMMENT 'true if this field can be used to generate suggestions for browse', |
1416 |
sort boolean DEFAULT NULL COMMENT 'true/false creates special sort handling, null doesn''t', |
1416 |
sort tinyint(1) DEFAULT NULL COMMENT 'true/false creates special sort handling, null doesn''t', |
1417 |
PRIMARY KEY(search_marc_map_id, search_field_id), |
1417 |
PRIMARY KEY(search_marc_map_id, search_field_id), |
1418 |
FOREIGN KEY(search_marc_map_id) REFERENCES search_marc_map(id) ON DELETE CASCADE ON UPDATE CASCADE, |
1418 |
FOREIGN KEY(search_marc_map_id) REFERENCES search_marc_map(id) ON DELETE CASCADE ON UPDATE CASCADE, |
1419 |
FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE |
1419 |
FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE |
Lines 1635-1641
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1635 |
`returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues |
1635 |
`returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues |
1636 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1636 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1637 |
`renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed |
1637 |
`renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed |
1638 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1638 |
`auto_renew` tinyint(1) default FALSE, -- automatic renewal |
1639 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1639 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1640 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1640 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1641 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1641 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
Lines 1667-1673
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1667 |
`returndate` datetime default NULL, -- date the item was returned |
1667 |
`returndate` datetime default NULL, -- date the item was returned |
1668 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1668 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1669 |
`renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed |
1669 |
`renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed |
1670 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1670 |
`auto_renew` tinyint(1) default FALSE, -- automatic renewal |
1671 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1671 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1672 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1672 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1673 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1673 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
Lines 1783-1792
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1783 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1783 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1784 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1784 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1785 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, |
1785 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, |
1786 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1786 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, |
1787 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1787 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1788 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1788 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1789 |
`item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1789 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1790 |
PRIMARY KEY (`reserve_id`), |
1790 |
PRIMARY KEY (`reserve_id`), |
1791 |
KEY priorityfoundidx (priority,found), |
1791 |
KEY priorityfoundidx (priority,found), |
1792 |
KEY `borrowernumber` (`borrowernumber`), |
1792 |
KEY `borrowernumber` (`borrowernumber`), |
Lines 1823-1832
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1823 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1823 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1824 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1824 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1825 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1825 |
`lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1826 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1826 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1827 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1827 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1828 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1828 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1829 |
`item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1829 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1830 |
PRIMARY KEY (`reserve_id`), |
1830 |
PRIMARY KEY (`reserve_id`), |
1831 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1831 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1832 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1832 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
Lines 1979-1985
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
1979 |
`firstacquidate` date default NULL, -- first issue received date |
1979 |
`firstacquidate` date default NULL, -- first issue received date |
1980 |
`manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually |
1980 |
`manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually |
1981 |
`irregularity` MEDIUMTEXT, -- any irregularities in the subscription |
1981 |
`irregularity` MEDIUMTEXT, -- any irregularities in the subscription |
1982 |
skip_serialseq BOOLEAN NOT NULL DEFAULT 0, |
1982 |
skip_serialseq tinyint(1) NOT NULL DEFAULT 0, |
1983 |
`letter` varchar(20) default NULL, |
1983 |
`letter` varchar(20) default NULL, |
1984 |
`numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id |
1984 |
`numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id |
1985 |
locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly |
1985 |
locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly |
Lines 2922-2932
CREATE TABLE aqcontacts (
Link Here
|
2922 |
fax varchar(100) default NULL, -- contact's fax number |
2922 |
fax varchar(100) default NULL, -- contact's fax number |
2923 |
email varchar(100) default NULL, -- contact's email address |
2923 |
email varchar(100) default NULL, -- contact's email address |
2924 |
notes LONGTEXT, -- notes related to the contact |
2924 |
notes LONGTEXT, -- notes related to the contact |
2925 |
orderacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisition orders |
2925 |
orderacquisition tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive acquisition orders |
2926 |
claimacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims |
2926 |
claimacquisition tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims |
2927 |
claimissues BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive serial claims |
2927 |
claimissues tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive serial claims |
2928 |
acqprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for acquisitions messages |
2928 |
acqprimary tinyint(1) NOT NULL DEFAULT 0, -- is this the primary contact for acquisitions messages |
2929 |
serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages |
2929 |
serialsprimary tinyint(1) NOT NULL DEFAULT 0, -- is this the primary contact for serials messages |
2930 |
booksellerid int(11) not NULL, |
2930 |
booksellerid int(11) not NULL, |
2931 |
PRIMARY KEY (id), |
2931 |
PRIMARY KEY (id), |
2932 |
CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid) |
2932 |
CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid) |
Lines 3102-3108
CREATE TABLE IF NOT EXISTS edifact_messages (
Link Here
|
3102 |
basketno INT(11) REFERENCES aqbasket( basketno), |
3102 |
basketno INT(11) REFERENCES aqbasket( basketno), |
3103 |
raw_msg LONGTEXT, |
3103 |
raw_msg LONGTEXT, |
3104 |
filename MEDIUMTEXT, |
3104 |
filename MEDIUMTEXT, |
3105 |
deleted BOOLEAN NOT NULL DEFAULT 0, |
3105 |
deleted tinyint(1) NOT NULL DEFAULT 0, |
3106 |
PRIMARY KEY (id), |
3106 |
PRIMARY KEY (id), |
3107 |
KEY vendorid ( vendor_id), |
3107 |
KEY vendorid ( vendor_id), |
3108 |
KEY ediacct (edi_acct), |
3108 |
KEY ediacct (edi_acct), |
3109 |
- |
|
|