Lines 26-35
CREATE TABLE `auth_header` (
Link Here
|
26 |
`datecreated` date default NULL, |
26 |
`datecreated` date default NULL, |
27 |
`modification_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
27 |
`modification_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
28 |
`origincode` varchar(20) default NULL, |
28 |
`origincode` varchar(20) default NULL, |
29 |
`authtrees` mediumtext, |
29 |
`authtrees` LONGTEXT, |
30 |
`marc` blob, |
30 |
`marc` blob, |
31 |
`linkid` bigint(20) default NULL, |
31 |
`linkid` bigint(20) default NULL, |
32 |
`marcxml` longtext NOT NULL, |
32 |
`marcxml` LONGTEXT NOT NULL, |
33 |
PRIMARY KEY (`authid`), |
33 |
PRIMARY KEY (`authid`), |
34 |
KEY `origincode` (`origincode`) |
34 |
KEY `origincode` (`origincode`) |
35 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
35 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 43-49
CREATE TABLE `auth_types` (
Link Here
|
43 |
`authtypecode` varchar(10) NOT NULL default '', |
43 |
`authtypecode` varchar(10) NOT NULL default '', |
44 |
`authtypetext` varchar(255) NOT NULL default '', |
44 |
`authtypetext` varchar(255) NOT NULL default '', |
45 |
`auth_tag_to_report` varchar(3) NOT NULL default '', |
45 |
`auth_tag_to_report` varchar(3) NOT NULL default '', |
46 |
`summary` mediumtext NOT NULL, |
46 |
`summary` LONGTEXT NOT NULL, |
47 |
PRIMARY KEY (`authtypecode`) |
47 |
PRIMARY KEY (`authtypecode`) |
48 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
48 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
49 |
|
49 |
|
Lines 69-75
CREATE TABLE `auth_subfield_structure` (
Link Here
|
69 |
`linkid` tinyint(1) NOT NULL default 0, |
69 |
`linkid` tinyint(1) NOT NULL default 0, |
70 |
`kohafield` varchar(45) NULL default '', |
70 |
`kohafield` varchar(45) NULL default '', |
71 |
`frameworkcode` varchar(10) NOT NULL default '', |
71 |
`frameworkcode` varchar(10) NOT NULL default '', |
72 |
`defaultvalue` TEXT, |
72 |
`defaultvalue` MEDIUMTEXT, |
73 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
73 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
74 |
KEY `tab` (`authtypecode`,`tab`), |
74 |
KEY `tab` (`authtypecode`,`tab`), |
75 |
CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
75 |
CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
Lines 130-145
DROP TABLE IF EXISTS `biblio`;
Link Here
|
130 |
CREATE TABLE `biblio` ( -- table that stores bibliographic information |
130 |
CREATE TABLE `biblio` ( -- table that stores bibliographic information |
131 |
`biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record |
131 |
`biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record |
132 |
`frameworkcode` varchar(4) NOT NULL default '', -- foreign key from the biblio_framework table to identify which framework was used in cataloging this record |
132 |
`frameworkcode` varchar(4) NOT NULL default '', -- foreign key from the biblio_framework table to identify which framework was used in cataloging this record |
133 |
`author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21) |
133 |
`author` LONGTEXT, -- statement of responsibility from MARC record (100$a in MARC21) |
134 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
134 |
`title` LONGTEXT, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
135 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
135 |
`unititle` LONGTEXT, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
136 |
`notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
136 |
`notes` LONGTEXT, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
137 |
`serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial |
137 |
`serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial |
138 |
`seriestitle` mediumtext, |
138 |
`seriestitle` LONGTEXT, |
139 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
139 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
140 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
140 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
141 |
`datecreated` DATE NOT NULL, -- the date this record was added to Koha |
141 |
`datecreated` DATE NOT NULL, -- the date this record was added to Koha |
142 |
`abstract` mediumtext, -- summary from the MARC record (520$a in MARC21) |
142 |
`abstract` LONGTEXT, -- summary from the MARC record (520$a in MARC21) |
143 |
PRIMARY KEY (`biblionumber`), |
143 |
PRIMARY KEY (`biblionumber`), |
144 |
KEY `blbnoidx` (`biblionumber`) |
144 |
KEY `blbnoidx` (`biblionumber`) |
145 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
145 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 163-191
DROP TABLE IF EXISTS `biblioitems`;
Link Here
|
163 |
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Koha |
163 |
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Koha |
164 |
`biblioitemnumber` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha |
164 |
`biblioitemnumber` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha |
165 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table |
165 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table |
166 |
`volume` mediumtext, |
166 |
`volume` LONGTEXT, |
167 |
`number` mediumtext, |
167 |
`number` LONGTEXT, |
168 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
168 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
169 |
`isbn` mediumtext, -- ISBN (MARC21 020$a) |
169 |
`isbn` LONGTEXT, -- ISBN (MARC21 020$a) |
170 |
`issn` mediumtext, -- ISSN (MARC21 022$a) |
170 |
`issn` LONGTEXT, -- ISSN (MARC21 022$a) |
171 |
`ean` mediumtext default NULL, |
171 |
`ean` LONGTEXT default NULL, |
172 |
`publicationyear` text, |
172 |
`publicationyear` MEDIUMTEXT, |
173 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
173 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
174 |
`volumedate` date default NULL, |
174 |
`volumedate` date default NULL, |
175 |
`volumedesc` text, -- volume information (MARC21 362$a) |
175 |
`volumedesc` MEDIUMTEXT, -- volume information (MARC21 362$a) |
176 |
`collectiontitle` mediumtext default NULL, |
176 |
`collectiontitle` LONGTEXT default NULL, |
177 |
`collectionissn` text default NULL, |
177 |
`collectionissn` MEDIUMTEXT default NULL, |
178 |
`collectionvolume` mediumtext default NULL, |
178 |
`collectionvolume` LONGTEXT default NULL, |
179 |
`editionstatement` text default NULL, |
179 |
`editionstatement` MEDIUMTEXT default NULL, |
180 |
`editionresponsibility` text default NULL, |
180 |
`editionresponsibility` MEDIUMTEXT default NULL, |
181 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
181 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
182 |
`illus` varchar(255) default NULL, -- illustrations (MARC21 300$b) |
182 |
`illus` varchar(255) default NULL, -- illustrations (MARC21 300$b) |
183 |
`pages` varchar(255) default NULL, -- number of pages (MARC21 300$c) |
183 |
`pages` varchar(255) default NULL, -- number of pages (MARC21 300$c) |
184 |
`notes` mediumtext, |
184 |
`notes` LONGTEXT, |
185 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
185 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
186 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
186 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
187 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
187 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
188 |
`url` text default NULL, -- url (MARC21 856$u) |
188 |
`url` MEDIUMTEXT default NULL, -- url (MARC21 856$u) |
189 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
189 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
190 |
`cn_class` varchar(30) default NULL, |
190 |
`cn_class` varchar(30) default NULL, |
191 |
`cn_item` varchar(10) default NULL, |
191 |
`cn_item` varchar(10) default NULL, |
Lines 246-270
CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( -- holds information a
Link Here
|
246 |
DROP TABLE IF EXISTS `branches`; |
246 |
DROP TABLE IF EXISTS `branches`; |
247 |
CREATE TABLE `branches` ( -- information about your libraries or branches are stored here |
247 |
CREATE TABLE `branches` ( -- information about your libraries or branches are stored here |
248 |
`branchcode` varchar(10) NOT NULL default '', -- a unique key assigned to each branch |
248 |
`branchcode` varchar(10) NOT NULL default '', -- a unique key assigned to each branch |
249 |
`branchname` mediumtext NOT NULL, -- the name of your library or branch |
249 |
`branchname` LONGTEXT NOT NULL, -- the name of your library or branch |
250 |
`branchaddress1` mediumtext, -- the first address line of for your library or branch |
250 |
`branchaddress1` LONGTEXT, -- the first address line of for your library or branch |
251 |
`branchaddress2` mediumtext, -- the second address line of for your library or branch |
251 |
`branchaddress2` LONGTEXT, -- the second address line of for your library or branch |
252 |
`branchaddress3` mediumtext, -- the third address line of for your library or branch |
252 |
`branchaddress3` LONGTEXT, -- the third address line of for your library or branch |
253 |
`branchzip` varchar(25) default NULL, -- the zip or postal code for your library or branch |
253 |
`branchzip` varchar(25) default NULL, -- the zip or postal code for your library or branch |
254 |
`branchcity` mediumtext, -- the city or province for your library or branch |
254 |
`branchcity` LONGTEXT, -- the city or province for your library or branch |
255 |
`branchstate` mediumtext, -- the state for your library or branch |
255 |
`branchstate` LONGTEXT, -- the state for your library or branch |
256 |
`branchcountry` text, -- the county for your library or branch |
256 |
`branchcountry` MEDIUMTEXT, -- the county for your library or branch |
257 |
`branchphone` mediumtext, -- the primary phone for your library or branch |
257 |
`branchphone` LONGTEXT, -- the primary phone for your library or branch |
258 |
`branchfax` mediumtext, -- the fax number for your library or branch |
258 |
`branchfax` LONGTEXT, -- the fax number for your library or branch |
259 |
`branchemail` mediumtext, -- the primary email address for your library or branch |
259 |
`branchemail` LONGTEXT, -- the primary email address for your library or branch |
260 |
`branchreplyto` mediumtext, -- the email to be used as a Reply-To |
260 |
`branchreplyto` LONGTEXT, -- the email to be used as a Reply-To |
261 |
`branchreturnpath` mediumtext, -- the email to be used as Return-Path |
261 |
`branchreturnpath` LONGTEXT, -- the email to be used as Return-Path |
262 |
`branchurl` mediumtext, -- the URL for your library or branch's website |
262 |
`branchurl` LONGTEXT, -- the URL for your library or branch's website |
263 |
`issuing` tinyint(4) default NULL, -- unused in Koha |
263 |
`issuing` tinyint(4) default NULL, -- unused in Koha |
264 |
`branchip` varchar(15) default NULL, -- the IP address for your library or branch |
264 |
`branchip` varchar(15) default NULL, -- the IP address for your library or branch |
265 |
`branchprinter` varchar(100) default NULL, -- unused in Koha |
265 |
`branchprinter` varchar(100) default NULL, -- unused in Koha |
266 |
`branchnotes` mediumtext, -- notes related to your library or branch |
266 |
`branchnotes` LONGTEXT, -- notes related to your library or branch |
267 |
opac_info text, -- HTML that displays in OPAC |
267 |
opac_info MEDIUMTEXT, -- HTML that displays in OPAC |
268 |
`geolocation` VARCHAR(255) default NULL, -- geolocation of your library |
268 |
`geolocation` VARCHAR(255) default NULL, -- geolocation of your library |
269 |
`marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode |
269 |
`marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode |
270 |
PRIMARY KEY (`branchcode`) |
270 |
PRIMARY KEY (`branchcode`) |
Lines 289-295
CREATE TABLE `browser` (
Link Here
|
289 |
DROP TABLE IF EXISTS `categories`; |
289 |
DROP TABLE IF EXISTS `categories`; |
290 |
CREATE TABLE `categories` ( -- this table shows information related to Koha patron categories |
290 |
CREATE TABLE `categories` ( -- this table shows information related to Koha patron categories |
291 |
`categorycode` varchar(10) NOT NULL default '', -- unique primary key used to idenfity the patron category |
291 |
`categorycode` varchar(10) NOT NULL default '', -- unique primary key used to idenfity the patron category |
292 |
`description` mediumtext, -- description of the patron category |
292 |
`description` LONGTEXT, -- description of the patron category |
293 |
`enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set) |
293 |
`enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set) |
294 |
`enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set) |
294 |
`enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set) |
295 |
`upperagelimit` smallint(6) default NULL, -- age limit for the patron |
295 |
`upperagelimit` smallint(6) default NULL, -- age limit for the patron |
Lines 316-322
DROP TABLE IF EXISTS collections;
Link Here
|
316 |
CREATE TABLE collections ( |
316 |
CREATE TABLE collections ( |
317 |
colId integer(11) NOT NULL auto_increment, |
317 |
colId integer(11) NOT NULL auto_increment, |
318 |
colTitle varchar(100) NOT NULL DEFAULT '', |
318 |
colTitle varchar(100) NOT NULL DEFAULT '', |
319 |
colDesc text NOT NULL, |
319 |
colDesc MEDIUMTEXT NOT NULL, |
320 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
320 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
321 |
PRIMARY KEY (colId) |
321 |
PRIMARY KEY (colId) |
322 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
322 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 423-429
CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choo
Link Here
|
423 |
DROP TABLE IF EXISTS `class_sort_rules`; |
423 |
DROP TABLE IF EXISTS `class_sort_rules`; |
424 |
CREATE TABLE `class_sort_rules` ( |
424 |
CREATE TABLE `class_sort_rules` ( |
425 |
`class_sort_rule` varchar(10) NOT NULL default '', |
425 |
`class_sort_rule` varchar(10) NOT NULL default '', |
426 |
`description` mediumtext, |
426 |
`description` LONGTEXT, |
427 |
`sort_routine` varchar(30) NOT NULL default '', |
427 |
`sort_routine` varchar(30) NOT NULL default '', |
428 |
PRIMARY KEY (`class_sort_rule`), |
428 |
PRIMARY KEY (`class_sort_rule`), |
429 |
UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`) |
429 |
UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`) |
Lines 436-442
CREATE TABLE `class_sort_rules` (
Link Here
|
436 |
DROP TABLE IF EXISTS `class_sources`; |
436 |
DROP TABLE IF EXISTS `class_sources`; |
437 |
CREATE TABLE `class_sources` ( |
437 |
CREATE TABLE `class_sources` ( |
438 |
`cn_source` varchar(10) NOT NULL default '', |
438 |
`cn_source` varchar(10) NOT NULL default '', |
439 |
`description` mediumtext, |
439 |
`description` LONGTEXT, |
440 |
`used` tinyint(4) NOT NULL default 0, |
440 |
`used` tinyint(4) NOT NULL default 0, |
441 |
`class_sort_rule` varchar(10) NOT NULL default '', |
441 |
`class_sort_rule` varchar(10) NOT NULL default '', |
442 |
PRIMARY KEY (`cn_source`), |
442 |
PRIMARY KEY (`cn_source`), |
Lines 469-484
DROP TABLE IF EXISTS `deletedbiblio`;
Link Here
|
469 |
CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records that have been deleted |
469 |
CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records that have been deleted |
470 |
`biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record |
470 |
`biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record |
471 |
`frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record |
471 |
`frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record |
472 |
`author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21) |
472 |
`author` LONGTEXT, -- statement of responsibility from MARC record (100$a in MARC21) |
473 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
473 |
`title` LONGTEXT, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
474 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
474 |
`unititle` LONGTEXT, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
475 |
`notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
475 |
`notes` LONGTEXT, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
476 |
`serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial |
476 |
`serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial |
477 |
`seriestitle` mediumtext, |
477 |
`seriestitle` LONGTEXT, |
478 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
478 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
479 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
479 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
480 |
`datecreated` DATE NOT NULL, -- the date this record was added to Koha |
480 |
`datecreated` DATE NOT NULL, -- the date this record was added to Koha |
481 |
`abstract` mediumtext, -- summary from the MARC record (520$a in MARC21) |
481 |
`abstract` LONGTEXT, -- summary from the MARC record (520$a in MARC21) |
482 |
PRIMARY KEY (`biblionumber`), |
482 |
PRIMARY KEY (`biblionumber`), |
483 |
KEY `blbnoidx` (`biblionumber`) |
483 |
KEY `blbnoidx` (`biblionumber`) |
484 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
484 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 491-519
DROP TABLE IF EXISTS `deletedbiblioitems`;
Link Here
|
491 |
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records that have been deleted |
491 |
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records that have been deleted |
492 |
`biblioitemnumber` int(11) NOT NULL default 0, -- primary key, unique identifier assigned by Koha |
492 |
`biblioitemnumber` int(11) NOT NULL default 0, -- primary key, unique identifier assigned by Koha |
493 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table |
493 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table |
494 |
`volume` mediumtext, |
494 |
`volume` LONGTEXT, |
495 |
`number` mediumtext, |
495 |
`number` LONGTEXT, |
496 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
496 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
497 |
`isbn` mediumtext default NULL, -- ISBN (MARC21 020$a) |
497 |
`isbn` LONGTEXT default NULL, -- ISBN (MARC21 020$a) |
498 |
`issn` mediumtext default NULL, -- ISSN (MARC21 022$a) |
498 |
`issn` LONGTEXT default NULL, -- ISSN (MARC21 022$a) |
499 |
`ean` mediumtext default NULL, |
499 |
`ean` LONGTEXT default NULL, |
500 |
`publicationyear` text, |
500 |
`publicationyear` MEDIUMTEXT, |
501 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
501 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
502 |
`volumedate` date default NULL, |
502 |
`volumedate` date default NULL, |
503 |
`volumedesc` text, -- volume information (MARC21 362$a) |
503 |
`volumedesc` MEDIUMTEXT, -- volume information (MARC21 362$a) |
504 |
`collectiontitle` mediumtext default NULL, |
504 |
`collectiontitle` LONGTEXT default NULL, |
505 |
`collectionissn` text default NULL, |
505 |
`collectionissn` MEDIUMTEXT default NULL, |
506 |
`collectionvolume` mediumtext default NULL, |
506 |
`collectionvolume` LONGTEXT default NULL, |
507 |
`editionstatement` text default NULL, |
507 |
`editionstatement` MEDIUMTEXT default NULL, |
508 |
`editionresponsibility` text default NULL, |
508 |
`editionresponsibility` MEDIUMTEXT default NULL, |
509 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
509 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
510 |
`illus` varchar(255) default NULL, -- illustrations (MARC21 300$b) |
510 |
`illus` varchar(255) default NULL, -- illustrations (MARC21 300$b) |
511 |
`pages` varchar(255) default NULL, -- number of pages (MARC21 300$c) |
511 |
`pages` varchar(255) default NULL, -- number of pages (MARC21 300$c) |
512 |
`notes` mediumtext, |
512 |
`notes` LONGTEXT, |
513 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
513 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
514 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
514 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
515 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
515 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
516 |
`url` text default NULL, -- url (MARC21 856$u) |
516 |
`url` MEDIUMTEXT default NULL, -- url (MARC21 856$u) |
517 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
517 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
518 |
`cn_class` varchar(30) default NULL, |
518 |
`cn_class` varchar(30) default NULL, |
519 |
`cn_item` varchar(10) default NULL, |
519 |
`cn_item` varchar(10) default NULL, |
Lines 539-573
DROP TABLE IF EXISTS `deletedborrowers`;
Link Here
|
539 |
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrowers you have deleted |
539 |
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrowers you have deleted |
540 |
`borrowernumber` int(11) NOT NULL default 0, -- primary key, Koha assigned ID number for patrons/borrowers |
540 |
`borrowernumber` int(11) NOT NULL default 0, -- primary key, Koha assigned ID number for patrons/borrowers |
541 |
`cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers |
541 |
`cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers |
542 |
`surname` mediumtext, -- patron/borrower's last name (surname) |
542 |
`surname` LONGTEXT, -- patron/borrower's last name (surname) |
543 |
`firstname` text, -- patron/borrower's first name |
543 |
`firstname` MEDIUMTEXT, -- patron/borrower's first name |
544 |
`title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs. |
544 |
`title` LONGTEXT, -- patron/borrower's title, for example: Mr. or Mrs. |
545 |
`othernames` mediumtext, -- any other names associated with the patron/borrower |
545 |
`othernames` LONGTEXT, -- any other names associated with the patron/borrower |
546 |
`initials` text, -- initials for your patron/borrower |
546 |
`initials` MEDIUMTEXT, -- initials for your patron/borrower |
547 |
`streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address |
547 |
`streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address |
548 |
`streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address |
548 |
`streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address |
549 |
`address` mediumtext, -- the first address line for your patron/borrower's primary address |
549 |
`address` LONGTEXT, -- the first address line for your patron/borrower's primary address |
550 |
`address2` text, -- the second address line for your patron/borrower's primary address |
550 |
`address2` MEDIUMTEXT, -- the second address line for your patron/borrower's primary address |
551 |
`city` mediumtext, -- the city or town for your patron/borrower's primary address |
551 |
`city` LONGTEXT, -- the city or town for your patron/borrower's primary address |
552 |
`state` text default NULL, -- the state or province for your patron/borrower's primary address |
552 |
`state` MEDIUMTEXT default NULL, -- the state or province for your patron/borrower's primary address |
553 |
`zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address |
553 |
`zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address |
554 |
`country` text, -- the country for your patron/borrower's primary address |
554 |
`country` MEDIUMTEXT, -- the country for your patron/borrower's primary address |
555 |
`email` mediumtext, -- the primary email address for your patron/borrower's primary address |
555 |
`email` LONGTEXT, -- the primary email address for your patron/borrower's primary address |
556 |
`phone` text, -- the primary phone number for your patron/borrower's primary address |
556 |
`phone` MEDIUMTEXT, -- the primary phone number for your patron/borrower's primary address |
557 |
`mobile` varchar(50) default NULL, -- the other phone number for your patron/borrower's primary address |
557 |
`mobile` varchar(50) default NULL, -- the other phone number for your patron/borrower's primary address |
558 |
`fax` mediumtext, -- the fax number for your patron/borrower's primary address |
558 |
`fax` LONGTEXT, -- the fax number for your patron/borrower's primary address |
559 |
`emailpro` text, -- the secondary email addres for your patron/borrower's primary address |
559 |
`emailpro` MEDIUMTEXT, -- the secondary email addres for your patron/borrower's primary address |
560 |
`phonepro` text, -- the secondary phone number for your patron/borrower's primary address |
560 |
`phonepro` MEDIUMTEXT, -- the secondary phone number for your patron/borrower's primary address |
561 |
`B_streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's alternate address |
561 |
`B_streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's alternate address |
562 |
`B_streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's alternate address |
562 |
`B_streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's alternate address |
563 |
`B_address` varchar(100) default NULL, -- the first address line for your patron/borrower's alternate address |
563 |
`B_address` varchar(100) default NULL, -- the first address line for your patron/borrower's alternate address |
564 |
`B_address2` text default NULL, -- the second address line for your patron/borrower's alternate address |
564 |
`B_address2` MEDIUMTEXT default NULL, -- the second address line for your patron/borrower's alternate address |
565 |
`B_city` mediumtext, -- the city or town for your patron/borrower's alternate address |
565 |
`B_city` LONGTEXT, -- the city or town for your patron/borrower's alternate address |
566 |
`B_state` text default NULL, -- the state for your patron/borrower's alternate address |
566 |
`B_state` MEDIUMTEXT default NULL, -- the state for your patron/borrower's alternate address |
567 |
`B_zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's alternate address |
567 |
`B_zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's alternate address |
568 |
`B_country` text, -- the country for your patron/borrower's alternate address |
568 |
`B_country` MEDIUMTEXT, -- the country for your patron/borrower's alternate address |
569 |
`B_email` text, -- the patron/borrower's alternate email address |
569 |
`B_email` MEDIUMTEXT, -- the patron/borrower's alternate email address |
570 |
`B_phone` mediumtext, -- the patron/borrower's alternate phone number |
570 |
`B_phone` LONGTEXT, -- the patron/borrower's alternate phone number |
571 |
`dateofbirth` date default NULL, -- the patron/borrower's date of birth (YYYY-MM-DD) |
571 |
`dateofbirth` date default NULL, -- the patron/borrower's date of birth (YYYY-MM-DD) |
572 |
`branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, includes the code of the patron/borrower's home branch |
572 |
`branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, includes the code of the patron/borrower's home branch |
573 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
573 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
Lines 578-594
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
578 |
`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 |
578 |
`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 |
579 |
`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 (YYYY-MM-DD) |
579 |
`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 (YYYY-MM-DD) |
580 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron |
580 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron |
581 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name |
581 |
`contactname` LONGTEXT, -- used for children and profesionals to include surname or last name of guarantor or organization name |
582 |
`contactfirstname` text, -- used for children to include first name of guarantor |
582 |
`contactfirstname` MEDIUMTEXT, -- used for children to include first name of guarantor |
583 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor |
583 |
`contacttitle` MEDIUMTEXT, -- used for children to include title (Mr., Mrs., etc) of guarantor |
584 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
584 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
585 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
585 |
`borrowernotes` LONGTEXT, -- a note on the patron/borrower's account that is only visible in the staff client |
586 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
586 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
587 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
587 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
588 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
588 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
589 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
589 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
590 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
590 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
591 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
591 |
`opacnote` LONGTEXT, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
592 |
`contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address |
592 |
`contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address |
593 |
`sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
593 |
`sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
594 |
`sort2` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
594 |
`sort2` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
Lines 597-605
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
597 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
597 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
598 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
598 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
599 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
599 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
600 |
`altcontactstate` text default NULL, -- the state for the alternate contact for the patron/borrower |
600 |
`altcontactstate` MEDIUMTEXT default NULL, -- the state for the alternate contact for the patron/borrower |
601 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
601 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
602 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
602 |
`altcontactcountry` MEDIUMTEXT default NULL, -- the country for the alternate contact for the patron/borrower |
603 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
603 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
604 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
604 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
605 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
605 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
Lines 610-616
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
610 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
610 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
611 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
611 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
612 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
612 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
613 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
613 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
614 |
KEY borrowernumber (borrowernumber), |
614 |
KEY borrowernumber (borrowernumber), |
615 |
KEY `cardnumber` (`cardnumber`), |
615 |
KEY `cardnumber` (`cardnumber`), |
616 |
KEY `sms_provider_id` (`sms_provider_id`) |
616 |
KEY `sms_provider_id` (`sms_provider_id`) |
Lines 627-633
CREATE TABLE `deleteditems` (
Link Here
|
627 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
627 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
628 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
628 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
629 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
629 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
630 |
`booksellerid` mediumtext default NULL, -- where the item was purchased (MARC21 952$e) |
630 |
`booksellerid` LONGTEXT default NULL, -- where the item was purchased (MARC21 952$e) |
631 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
631 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
632 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
632 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
633 |
`replacementprice` decimal(8,2) default NULL, -- cost the library charges to replace the item if it has been marked lost (MARC21 952$v) |
633 |
`replacementprice` decimal(8,2) default NULL, -- cost the library charges to replace the item if it has been marked lost (MARC21 952$v) |
Lines 647-656
CREATE TABLE `deleteditems` (
Link Here
|
647 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
647 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
648 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
648 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
649 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
649 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
650 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
650 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) |
651 |
`itemnotes_nonpublic` mediumtext default NULL, |
651 |
`itemnotes_nonpublic` LONGTEXT default NULL, |
652 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
652 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
653 |
`paidfor` mediumtext, |
653 |
`paidfor` LONGTEXT, |
654 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
654 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
655 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
655 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
656 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
656 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
Lines 658-668
CREATE TABLE `deleteditems` (
Link Here
|
658 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
658 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
659 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
659 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
660 |
`ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
660 |
`ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
661 |
`materials` text default NULL, -- materials specified (MARC21 952$3) |
661 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
662 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
662 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
663 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
663 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
664 |
`more_subfields_xml` longtext default NULL, -- additional 952 subfields in XML format |
664 |
`more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format |
665 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
665 |
`enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
666 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
666 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
667 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
667 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
668 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
668 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
Lines 685-692
DROP TABLE IF EXISTS `export_format`;
Link Here
|
685 |
CREATE TABLE `export_format` ( |
685 |
CREATE TABLE `export_format` ( |
686 |
`export_format_id` int(11) NOT NULL auto_increment, |
686 |
`export_format_id` int(11) NOT NULL auto_increment, |
687 |
`profile` varchar(255) NOT NULL, |
687 |
`profile` varchar(255) NOT NULL, |
688 |
`description` mediumtext NOT NULL, |
688 |
`description` LONGTEXT NOT NULL, |
689 |
`content` mediumtext NOT NULL, |
689 |
`content` LONGTEXT NOT NULL, |
690 |
`csv_separator` varchar(2) NOT NULL DEFAULT ',', |
690 |
`csv_separator` varchar(2) NOT NULL DEFAULT ',', |
691 |
`field_separator` varchar(2), |
691 |
`field_separator` varchar(2), |
692 |
`subfield_separator` varchar(2), |
692 |
`subfield_separator` varchar(2), |
Lines 716-722
CREATE TABLE `import_batches` ( -- information about batches of marc records tha
Link Here
|
716 |
`batch_type` enum('batch', 'z3950', 'webservice') NOT NULL default 'batch', -- where this batch has come from |
716 |
`batch_type` enum('batch', 'z3950', 'webservice') NOT NULL default 'batch', -- where this batch has come from |
717 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch |
717 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch |
718 |
`file_name` varchar(100), -- the name of the file uploaded |
718 |
`file_name` varchar(100), -- the name of the file uploaded |
719 |
`comments` mediumtext, -- any comments added when the file was uploaded |
719 |
`comments` LONGTEXT, -- any comments added when the file was uploaded |
720 |
PRIMARY KEY (`import_batch_id`), |
720 |
PRIMARY KEY (`import_batch_id`), |
721 |
KEY `branchcode` (`branchcode`) |
721 |
KEY `branchcode` (`branchcode`) |
722 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
722 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 734-745
CREATE TABLE `import_records` (
Link Here
|
734 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, |
734 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, |
735 |
`import_date` DATE default NULL, |
735 |
`import_date` DATE default NULL, |
736 |
`marc` longblob NOT NULL, |
736 |
`marc` longblob NOT NULL, |
737 |
`marcxml` longtext NOT NULL, |
737 |
`marcxml` LONGTEXT NOT NULL, |
738 |
`marcxml_old` longtext NOT NULL, |
738 |
`marcxml_old` LONGTEXT NOT NULL, |
739 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', |
739 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', |
740 |
`overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match', |
740 |
`overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match', |
741 |
`status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged', |
741 |
`status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged', |
742 |
`import_error` mediumtext, |
742 |
`import_error` LONGTEXT, |
743 |
`encoding` varchar(40) NOT NULL default '', |
743 |
`encoding` varchar(40) NOT NULL default '', |
744 |
`z3950random` varchar(40) default NULL, |
744 |
`z3950random` varchar(40) default NULL, |
745 |
PRIMARY KEY (`import_record_id`), |
745 |
PRIMARY KEY (`import_record_id`), |
Lines 812-819
CREATE TABLE `import_items` (
Link Here
|
812 |
`itemnumber` int(11) default NULL, |
812 |
`itemnumber` int(11) default NULL, |
813 |
`branchcode` varchar(10) default NULL, |
813 |
`branchcode` varchar(10) default NULL, |
814 |
`status` enum('error', 'staged', 'imported', 'reverted', 'ignored') NOT NULL default 'staged', |
814 |
`status` enum('error', 'staged', 'imported', 'reverted', 'ignored') NOT NULL default 'staged', |
815 |
`marcxml` longtext NOT NULL, |
815 |
`marcxml` LONGTEXT NOT NULL, |
816 |
`import_error` mediumtext, |
816 |
`import_error` LONGTEXT, |
817 |
PRIMARY KEY (`import_items_id`), |
817 |
PRIMARY KEY (`import_items_id`), |
818 |
CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`) |
818 |
CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`) |
819 |
REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
819 |
REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
Lines 887-893
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
887 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
887 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
888 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
888 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
889 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
889 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
890 |
`booksellerid` mediumtext default NULL, -- where the item was purchased (MARC21 952$e) |
890 |
`booksellerid` LONGTEXT default NULL, -- where the item was purchased (MARC21 952$e) |
891 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
891 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
892 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
892 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
893 |
`replacementprice` decimal(8,2) default NULL, -- cost the library charges to replace the item if it has been marked lost (MARC21 952$v) |
893 |
`replacementprice` decimal(8,2) default NULL, -- cost the library charges to replace the item if it has been marked lost (MARC21 952$v) |
Lines 907-916
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
907 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
907 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
908 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
908 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
909 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
909 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
910 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
910 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) |
911 |
`itemnotes_nonpublic` mediumtext default NULL, |
911 |
`itemnotes_nonpublic` LONGTEXT default NULL, |
912 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
912 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
913 |
`paidfor` mediumtext, |
913 |
`paidfor` LONGTEXT, |
914 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
914 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
915 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
915 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
916 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
916 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
Lines 918-928
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
918 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
918 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
919 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
919 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
920 |
`ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
920 |
`ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
921 |
`materials` text default NULL, -- materials specified (MARC21 952$3) |
921 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
922 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
922 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
923 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
923 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
924 |
`more_subfields_xml` longtext default NULL, -- additional 952 subfields in XML format |
924 |
`more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format |
925 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
925 |
`enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
926 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
926 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
927 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
927 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
928 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
928 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
Lines 951-963
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
951 |
DROP TABLE IF EXISTS `itemtypes`; |
951 |
DROP TABLE IF EXISTS `itemtypes`; |
952 |
CREATE TABLE `itemtypes` ( -- defines the item types |
952 |
CREATE TABLE `itemtypes` ( -- defines the item types |
953 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
953 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
954 |
description mediumtext, -- a plain text explanation of the item type |
954 |
description LONGTEXT, -- a plain text explanation of the item type |
955 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
955 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
956 |
defaultreplacecost decimal(28,6) default NULL, -- default replacement cost |
956 |
defaultreplacecost decimal(28,6) default NULL, -- default replacement cost |
957 |
processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied |
957 |
processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied |
958 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |
958 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |
959 |
imageurl varchar(200) default NULL, -- URL for the item type icon |
959 |
imageurl varchar(200) default NULL, -- URL for the item type icon |
960 |
summary text, -- information from the summary field, may include HTML |
960 |
summary MEDIUMTEXT, -- information from the summary field, may include HTML |
961 |
checkinmsg VARCHAR(255), -- message that is displayed when an item with the given item type is checked in |
961 |
checkinmsg VARCHAR(255), -- message that is displayed when an item with the given item type is checked in |
962 |
checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL, -- type (CSS class) for the checkinmsg, can be "alert" or "message" |
962 |
checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL, -- type (CSS class) for the checkinmsg, can be "alert" or "message" |
963 |
sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype |
963 |
sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype |
Lines 994-1000
CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
Link Here
|
994 |
`frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from |
994 |
`frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from |
995 |
`datearrived` datetime default NULL, -- the date the transfer arrived at its destination |
995 |
`datearrived` datetime default NULL, -- the date the transfer arrived at its destination |
996 |
`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to |
996 |
`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to |
997 |
`comments` mediumtext, -- any comments related to the transfer |
997 |
`comments` LONGTEXT, -- any comments related to the transfer |
998 |
PRIMARY KEY (`branchtransfer_id`), |
998 |
PRIMARY KEY (`branchtransfer_id`), |
999 |
KEY `frombranch` (`frombranch`), |
999 |
KEY `frombranch` (`frombranch`), |
1000 |
KEY `tobranch` (`tobranch`), |
1000 |
KEY `tobranch` (`tobranch`), |
Lines 1059-1065
CREATE TABLE `creator_layouts` (
Link Here
|
1059 |
`callnum_split` int(1) DEFAULT '0', |
1059 |
`callnum_split` int(1) DEFAULT '0', |
1060 |
`text_justify` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'L', |
1060 |
`text_justify` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'L', |
1061 |
`format_string` varchar(210) NOT NULL DEFAULT 'barcode', |
1061 |
`format_string` varchar(210) NOT NULL DEFAULT 'barcode', |
1062 |
`layout_xml` text NOT NULL, |
1062 |
`layout_xml` MEDIUMTEXT NOT NULL, |
1063 |
`creator` char(15) NOT NULL DEFAULT 'Labels', |
1063 |
`creator` char(15) NOT NULL DEFAULT 'Labels', |
1064 |
PRIMARY KEY (`layout_id`) |
1064 |
PRIMARY KEY (`layout_id`) |
1065 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1065 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 1116-1122
CREATE TABLE `marc_subfield_structure` (
Link Here
|
1116 |
`frameworkcode` varchar(4) NOT NULL default '', |
1116 |
`frameworkcode` varchar(4) NOT NULL default '', |
1117 |
`seealso` varchar(1100) default NULL, |
1117 |
`seealso` varchar(1100) default NULL, |
1118 |
`link` varchar(80) default NULL, |
1118 |
`link` varchar(80) default NULL, |
1119 |
`defaultvalue` text default NULL, |
1119 |
`defaultvalue` MEDIUMTEXT default NULL, |
1120 |
`maxlength` int(4) NOT NULL DEFAULT '9999', |
1120 |
`maxlength` int(4) NOT NULL DEFAULT '9999', |
1121 |
PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), |
1121 |
PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), |
1122 |
KEY `kohafield_2` (`kohafield`), |
1122 |
KEY `kohafield_2` (`kohafield`), |
Lines 1243-1249
CREATE TABLE `need_merge_authorities` ( -- keeping track of authority records st
Link Here
|
1243 |
`id` int NOT NULL auto_increment PRIMARY KEY, -- unique id |
1243 |
`id` int NOT NULL auto_increment PRIMARY KEY, -- unique id |
1244 |
`authid` bigint NOT NULL, -- reference to original authority record |
1244 |
`authid` bigint NOT NULL, -- reference to original authority record |
1245 |
`authid_new` bigint, -- reference to optional new authority record |
1245 |
`authid_new` bigint, -- reference to optional new authority record |
1246 |
`reportxml` text, -- xml showing original reporting tag |
1246 |
`reportxml` MEDIUMTEXT, -- xml showing original reporting tag |
1247 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date and time last modified |
1247 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date and time last modified |
1248 |
`done` tinyint DEFAULT 0 -- indication whether merge has been executed (0=not done, 1=done, 2=in progress) |
1248 |
`done` tinyint DEFAULT 0 -- indication whether merge has been executed (0=not done, 1=done, 2=in progress) |
1249 |
-- Note: authid and authid_new should NOT be FOREIGN keys ! |
1249 |
-- Note: authid and authid_new should NOT be FOREIGN keys ! |
Lines 1384-1390
CREATE TABLE `repeatable_holidays` ( -- information for the days the library is
Link Here
|
1384 |
`day` smallint(6) default NULL, -- day of the month this closing is on |
1384 |
`day` smallint(6) default NULL, -- day of the month this closing is on |
1385 |
`month` smallint(6) default NULL, -- month this closing is in |
1385 |
`month` smallint(6) default NULL, -- month this closing is in |
1386 |
`title` varchar(50) NOT NULL default '', -- title of this closing |
1386 |
`title` varchar(50) NOT NULL default '', -- title of this closing |
1387 |
`description` text NOT NULL, -- description for this closing |
1387 |
`description` MEDIUMTEXT NOT NULL, -- description for this closing |
1388 |
PRIMARY KEY (`id`) |
1388 |
PRIMARY KEY (`id`) |
1389 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1389 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1390 |
|
1390 |
|
Lines 1396-1405
DROP TABLE IF EXISTS `reports_dictionary`;
Link Here
|
1396 |
CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for use in reports |
1396 |
CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for use in reports |
1397 |
`id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
1397 |
`id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
1398 |
`name` varchar(255) default NULL, -- name for this definition |
1398 |
`name` varchar(255) default NULL, -- name for this definition |
1399 |
`description` text, -- description for this definition |
1399 |
`description` MEDIUMTEXT, -- description for this definition |
1400 |
`date_created` datetime default NULL, -- date and time this definition was created |
1400 |
`date_created` datetime default NULL, -- date and time this definition was created |
1401 |
`date_modified` datetime default NULL, -- date and time this definition was last modified |
1401 |
`date_modified` datetime default NULL, -- date and time this definition was last modified |
1402 |
`saved_sql` text, -- SQL snippet for us in reports |
1402 |
`saved_sql` MEDIUMTEXT, -- SQL snippet for us in reports |
1403 |
report_area varchar(6) DEFAULT NULL, -- Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts) |
1403 |
report_area varchar(6) DEFAULT NULL, -- Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts) |
1404 |
PRIMARY KEY (id), |
1404 |
PRIMARY KEY (id), |
1405 |
KEY dictionary_area_idx (report_area) |
1405 |
KEY dictionary_area_idx (report_area) |
Lines 1415-1425
CREATE TABLE saved_sql ( -- saved sql reports
Link Here
|
1415 |
`borrowernumber` int(11) default NULL, -- the staff member who created this report (borrowers.borrowernumber) |
1415 |
`borrowernumber` int(11) default NULL, -- the staff member who created this report (borrowers.borrowernumber) |
1416 |
`date_created` datetime default NULL, -- the date this report was created |
1416 |
`date_created` datetime default NULL, -- the date this report was created |
1417 |
`last_modified` datetime default NULL, -- the date this report was last edited |
1417 |
`last_modified` datetime default NULL, -- the date this report was last edited |
1418 |
`savedsql` text, -- the SQL for this report |
1418 |
`savedsql` MEDIUMTEXT, -- the SQL for this report |
1419 |
`last_run` datetime default NULL, |
1419 |
`last_run` datetime default NULL, |
1420 |
`report_name` varchar(255) NOT NULL default '', -- the name of this report |
1420 |
`report_name` varchar(255) NOT NULL default '', -- the name of this report |
1421 |
`type` varchar(255) default NULL, -- always 1 for tabular |
1421 |
`type` varchar(255) default NULL, -- always 1 for tabular |
1422 |
`notes` text, -- the notes or description given to this report |
1422 |
`notes` MEDIUMTEXT, -- the notes or description given to this report |
1423 |
`cache_expiry` int NOT NULL default 300, |
1423 |
`cache_expiry` int NOT NULL default 300, |
1424 |
`public` boolean NOT NULL default FALSE, |
1424 |
`public` boolean NOT NULL default FALSE, |
1425 |
report_area varchar(6) default NULL, |
1425 |
report_area varchar(6) default NULL, |
Lines 1439-1445
DROP TABLE IF EXISTS `saved_reports`;
Link Here
|
1439 |
CREATE TABLE saved_reports ( |
1439 |
CREATE TABLE saved_reports ( |
1440 |
`id` int(11) NOT NULL auto_increment, |
1440 |
`id` int(11) NOT NULL auto_increment, |
1441 |
`report_id` int(11) default NULL, |
1441 |
`report_id` int(11) default NULL, |
1442 |
`report` longtext, |
1442 |
`report` LONGTEXT, |
1443 |
`date_run` datetime default NULL, |
1443 |
`date_run` datetime default NULL, |
1444 |
PRIMARY KEY (`id`) |
1444 |
PRIMARY KEY (`id`) |
1445 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1445 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 1468-1474
CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history
Link Here
|
1468 |
`userid` int(11) NOT NULL, -- the patron who performed the search (borrowers.borrowernumber) |
1468 |
`userid` int(11) NOT NULL, -- the patron who performed the search (borrowers.borrowernumber) |
1469 |
`sessionid` varchar(32) NOT NULL, -- a system generated session id |
1469 |
`sessionid` varchar(32) NOT NULL, -- a system generated session id |
1470 |
`query_desc` varchar(255) NOT NULL, -- the search that was performed |
1470 |
`query_desc` varchar(255) NOT NULL, -- the search that was performed |
1471 |
`query_cgi` text NOT NULL, -- the string to append to the search url to rerun the search |
1471 |
`query_cgi` MEDIUMTEXT NOT NULL, -- the string to append to the search url to rerun the search |
1472 |
`type` varchar(16) NOT NULL DEFAULT 'biblio', -- search type, must be 'biblio' or 'authority' |
1472 |
`type` varchar(16) NOT NULL DEFAULT 'biblio', -- search type, must be 'biblio' or 'authority' |
1473 |
`total` int(11) NOT NULL, -- the total of results found |
1473 |
`total` int(11) NOT NULL, -- the total of results found |
1474 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1474 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
Lines 1523-1534
CREATE TABLE `serial` ( -- issues related to subscriptions
Link Here
|
1523 |
`serialseq_z` varchar( 100 ) NULL DEFAULT NULL, -- third part of issue information |
1523 |
`serialseq_z` varchar( 100 ) NULL DEFAULT NULL, -- third part of issue information |
1524 |
`status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) |
1524 |
`status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) |
1525 |
`planneddate` date default NULL, -- date expected |
1525 |
`planneddate` date default NULL, -- date expected |
1526 |
`notes` text, -- notes |
1526 |
`notes` MEDIUMTEXT, -- notes |
1527 |
`publisheddate` date default NULL, -- date published |
1527 |
`publisheddate` date default NULL, -- date published |
1528 |
publisheddatetext varchar(100) default NULL, -- date published (descriptive) |
1528 |
publisheddatetext varchar(100) default NULL, -- date published (descriptive) |
1529 |
`claimdate` date default NULL, -- date claimed |
1529 |
`claimdate` date default NULL, -- date claimed |
1530 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1530 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1531 |
`routingnotes` text, -- notes from the routing list |
1531 |
`routingnotes` MEDIUMTEXT, -- notes from the routing list |
1532 |
PRIMARY KEY (`serialid`) |
1532 |
PRIMARY KEY (`serialid`) |
1533 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1533 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1534 |
|
1534 |
|
Lines 1539-1545
CREATE TABLE `serial` ( -- issues related to subscriptions
Link Here
|
1539 |
DROP TABLE IF EXISTS sessions; |
1539 |
DROP TABLE IF EXISTS sessions; |
1540 |
CREATE TABLE sessions ( |
1540 |
CREATE TABLE sessions ( |
1541 |
`id` varchar(32) NOT NULL, |
1541 |
`id` varchar(32) NOT NULL, |
1542 |
`a_session` mediumtext NOT NULL, |
1542 |
`a_session` LONGTEXT NOT NULL, |
1543 |
PRIMARY KEY (`id`) |
1543 |
PRIMARY KEY (`id`) |
1544 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1544 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1545 |
|
1545 |
|
Lines 1564-1598
DROP TABLE IF EXISTS `borrowers`;
Link Here
|
1564 |
CREATE TABLE `borrowers` ( -- this table includes information about your patrons/borrowers/members |
1564 |
CREATE TABLE `borrowers` ( -- this table includes information about your patrons/borrowers/members |
1565 |
`borrowernumber` int(11) NOT NULL auto_increment, -- primary key, Koha assigned ID number for patrons/borrowers |
1565 |
`borrowernumber` int(11) NOT NULL auto_increment, -- primary key, Koha assigned ID number for patrons/borrowers |
1566 |
`cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers |
1566 |
`cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers |
1567 |
`surname` mediumtext, -- patron/borrower's last name (surname) |
1567 |
`surname` LONGTEXT, -- patron/borrower's last name (surname) |
1568 |
`firstname` text, -- patron/borrower's first name |
1568 |
`firstname` MEDIUMTEXT, -- patron/borrower's first name |
1569 |
`title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs. |
1569 |
`title` LONGTEXT, -- patron/borrower's title, for example: Mr. or Mrs. |
1570 |
`othernames` mediumtext, -- any other names associated with the patron/borrower |
1570 |
`othernames` LONGTEXT, -- any other names associated with the patron/borrower |
1571 |
`initials` text, -- initials for your patron/borrower |
1571 |
`initials` MEDIUMTEXT, -- initials for your patron/borrower |
1572 |
`streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address |
1572 |
`streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's primary address |
1573 |
`streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address |
1573 |
`streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's primary address |
1574 |
`address` mediumtext, -- the first address line for your patron/borrower's primary address |
1574 |
`address` LONGTEXT, -- the first address line for your patron/borrower's primary address |
1575 |
`address2` text, -- the second address line for your patron/borrower's primary address |
1575 |
`address2` MEDIUMTEXT, -- the second address line for your patron/borrower's primary address |
1576 |
`city` mediumtext, -- the city or town for your patron/borrower's primary address |
1576 |
`city` LONGTEXT, -- the city or town for your patron/borrower's primary address |
1577 |
`state` text default NULL, -- the state or province for your patron/borrower's primary address |
1577 |
`state` MEDIUMTEXT default NULL, -- the state or province for your patron/borrower's primary address |
1578 |
`zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address |
1578 |
`zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's primary address |
1579 |
`country` text, -- the country for your patron/borrower's primary address |
1579 |
`country` MEDIUMTEXT, -- the country for your patron/borrower's primary address |
1580 |
`email` mediumtext, -- the primary email address for your patron/borrower's primary address |
1580 |
`email` LONGTEXT, -- the primary email address for your patron/borrower's primary address |
1581 |
`phone` text, -- the primary phone number for your patron/borrower's primary address |
1581 |
`phone` MEDIUMTEXT, -- the primary phone number for your patron/borrower's primary address |
1582 |
`mobile` varchar(50) default NULL, -- the other phone number for your patron/borrower's primary address |
1582 |
`mobile` varchar(50) default NULL, -- the other phone number for your patron/borrower's primary address |
1583 |
`fax` mediumtext, -- the fax number for your patron/borrower's primary address |
1583 |
`fax` LONGTEXT, -- the fax number for your patron/borrower's primary address |
1584 |
`emailpro` text, -- the secondary email addres for your patron/borrower's primary address |
1584 |
`emailpro` MEDIUMTEXT, -- the secondary email addres for your patron/borrower's primary address |
1585 |
`phonepro` text, -- the secondary phone number for your patron/borrower's primary address |
1585 |
`phonepro` MEDIUMTEXT, -- the secondary phone number for your patron/borrower's primary address |
1586 |
`B_streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's alternate address |
1586 |
`B_streetnumber` varchar(10) default NULL, -- the house number for your patron/borrower's alternate address |
1587 |
`B_streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's alternate address |
1587 |
`B_streettype` varchar(50) default NULL, -- the street type (Rd., Blvd, etc) for your patron/borrower's alternate address |
1588 |
`B_address` varchar(100) default NULL, -- the first address line for your patron/borrower's alternate address |
1588 |
`B_address` varchar(100) default NULL, -- the first address line for your patron/borrower's alternate address |
1589 |
`B_address2` text default NULL, -- the second address line for your patron/borrower's alternate address |
1589 |
`B_address2` MEDIUMTEXT default NULL, -- the second address line for your patron/borrower's alternate address |
1590 |
`B_city` mediumtext, -- the city or town for your patron/borrower's alternate address |
1590 |
`B_city` LONGTEXT, -- the city or town for your patron/borrower's alternate address |
1591 |
`B_state` text default NULL, -- the state for your patron/borrower's alternate address |
1591 |
`B_state` MEDIUMTEXT default NULL, -- the state for your patron/borrower's alternate address |
1592 |
`B_zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's alternate address |
1592 |
`B_zipcode` varchar(25) default NULL, -- the zip or postal code for your patron/borrower's alternate address |
1593 |
`B_country` text, -- the country for your patron/borrower's alternate address |
1593 |
`B_country` MEDIUMTEXT, -- the country for your patron/borrower's alternate address |
1594 |
`B_email` text, -- the patron/borrower's alternate email address |
1594 |
`B_email` MEDIUMTEXT, -- the patron/borrower's alternate email address |
1595 |
`B_phone` mediumtext, -- the patron/borrower's alternate phone number |
1595 |
`B_phone` LONGTEXT, -- the patron/borrower's alternate phone number |
1596 |
`dateofbirth` date default NULL, -- the patron/borrower's date of birth (YYYY-MM-DD) |
1596 |
`dateofbirth` date default NULL, -- the patron/borrower's date of birth (YYYY-MM-DD) |
1597 |
`branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, includes the code of the patron/borrower's home branch |
1597 |
`branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, includes the code of the patron/borrower's home branch |
1598 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
1598 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the categories table, includes the code of the patron category |
Lines 1603-1619
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1603 |
`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 |
1603 |
`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 |
1604 |
`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 (YYYY-MM-DD) |
1604 |
`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 (YYYY-MM-DD) |
1605 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron |
1605 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron |
1606 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name |
1606 |
`contactname` LONGTEXT, -- used for children and profesionals to include surname or last name of guarantor or organization name |
1607 |
`contactfirstname` text, -- used for children to include first name of guarantor |
1607 |
`contactfirstname` MEDIUMTEXT, -- used for children to include first name of guarantor |
1608 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor |
1608 |
`contacttitle` MEDIUMTEXT, -- used for children to include title (Mr., Mrs., etc) of guarantor |
1609 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
1609 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
1610 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
1610 |
`borrowernotes` LONGTEXT, -- a note on the patron/borrower's account that is only visible in the staff client |
1611 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
1611 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
1612 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
1612 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
1613 |
`password` varchar(60) default NULL, -- patron/borrower's Bcrypt encrypted password |
1613 |
`password` varchar(60) default NULL, -- patron/borrower's Bcrypt encrypted password |
1614 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
1614 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
1615 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
1615 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
1616 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
1616 |
`opacnote` LONGTEXT, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
1617 |
`contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address |
1617 |
`contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address |
1618 |
`sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
1618 |
`sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
1619 |
`sort2` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
1619 |
`sort2` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
Lines 1622-1630
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1622 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
1622 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
1623 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
1623 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
1624 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
1624 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
1625 |
`altcontactstate` text default NULL, -- the state for the alternate contact for the patron/borrower |
1625 |
`altcontactstate` MEDIUMTEXT default NULL, -- the state for the alternate contact for the patron/borrower |
1626 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
1626 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
1627 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
1627 |
`altcontactcountry` MEDIUMTEXT default NULL, -- the country for the alternate contact for the patron/borrower |
1628 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
1628 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
1629 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
1629 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
1630 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
1630 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
Lines 1635-1641
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1635 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
1635 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
1636 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1636 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1637 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1637 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1638 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
1638 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1639 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1639 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1640 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1640 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1641 |
KEY `categorycode` (`categorycode`), |
1641 |
KEY `categorycode` (`categorycode`), |
Lines 1679-1685
CREATE TABLE borrower_debarments ( -- tracks restrictions on the patron's record
Link Here
|
1679 |
borrowernumber int(11) NOT NULL, -- foreign key for borrowers.borrowernumber for patron who is restricted |
1679 |
borrowernumber int(11) NOT NULL, -- foreign key for borrowers.borrowernumber for patron who is restricted |
1680 |
expiration date DEFAULT NULL, -- expiration date of the restriction |
1680 |
expiration date DEFAULT NULL, -- expiration date of the restriction |
1681 |
`type` enum('SUSPENSION','OVERDUES','MANUAL','DISCHARGE') NOT NULL DEFAULT 'MANUAL', -- type of restriction |
1681 |
`type` enum('SUSPENSION','OVERDUES','MANUAL','DISCHARGE') NOT NULL DEFAULT 'MANUAL', -- type of restriction |
1682 |
`comment` text, -- comments about the restriction |
1682 |
`comment` MEDIUMTEXT, -- comments about the restriction |
1683 |
manager_id int(11) DEFAULT NULL, -- foreign key for borrowers.borrowernumber for the librarian managing the restriction |
1683 |
manager_id int(11) DEFAULT NULL, -- foreign key for borrowers.borrowernumber for the librarian managing the restriction |
1684 |
created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date the restriction was added |
1684 |
created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date the restriction was added |
1685 |
updated timestamp NULL DEFAULT NULL, -- date the restriction was updated |
1685 |
updated timestamp NULL DEFAULT NULL, -- date the restriction was updated |
Lines 1726-1732
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1726 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1726 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1727 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1727 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1728 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1728 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1729 |
`note` mediumtext default NULL, -- issue note text |
1729 |
`note` LONGTEXT default NULL, -- issue note text |
1730 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1730 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1731 |
PRIMARY KEY (`issue_id`), |
1731 |
PRIMARY KEY (`issue_id`), |
1732 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1732 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
Lines 1757-1763
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1757 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1757 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1758 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1758 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1759 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1759 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1760 |
`note` mediumtext default NULL, -- issue note text |
1760 |
`note` LONGTEXT default NULL, -- issue note text |
1761 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1761 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1762 |
PRIMARY KEY (`issue_id`), |
1762 |
PRIMARY KEY (`issue_id`), |
1763 |
KEY `old_issuesborridx` (`borrowernumber`), |
1763 |
KEY `old_issuesborridx` (`borrowernumber`), |
Lines 1819-1825
CREATE TABLE `opac_news` ( -- data from the news tool
Link Here
|
1819 |
`idnew` int(10) unsigned NOT NULL auto_increment, -- unique identifier for the news article |
1819 |
`idnew` int(10) unsigned NOT NULL auto_increment, -- unique identifier for the news article |
1820 |
`branchcode` varchar(10) default NULL, -- branch code users to create branch specific news, NULL is every branch. |
1820 |
`branchcode` varchar(10) default NULL, -- branch code users to create branch specific news, NULL is every branch. |
1821 |
`title` varchar(250) NOT NULL default '', -- title of the news article |
1821 |
`title` varchar(250) NOT NULL default '', -- title of the news article |
1822 |
`content` text NOT NULL, -- the body of your news article |
1822 |
`content` MEDIUMTEXT NOT NULL, -- the body of your news article |
1823 |
`lang` varchar(25) NOT NULL default '', -- location for the article (koha is the staff client, slip is the circulation receipt and language codes are for the opac) |
1823 |
`lang` varchar(25) NOT NULL default '', -- location for the article (koha is the staff client, slip is the circulation receipt and language codes are for the opac) |
1824 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- pulibcation date and time |
1824 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- pulibcation date and time |
1825 |
`expirationdate` date default NULL, -- date the article is set to expire or no longer be visible |
1825 |
`expirationdate` date default NULL, -- date the article is set to expire or no longer be visible |
Lines 1858-1864
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1858 |
`notificationdate` date default NULL, -- currently unused |
1858 |
`notificationdate` date default NULL, -- currently unused |
1859 |
`reminderdate` date default NULL, -- currently unused |
1859 |
`reminderdate` date default NULL, -- currently unused |
1860 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1860 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1861 |
`reservenotes` mediumtext, -- notes related to this hold |
1861 |
`reservenotes` LONGTEXT, -- notes related to this hold |
1862 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1862 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1863 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1863 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1864 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1864 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
Lines 1897-1903
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1897 |
`notificationdate` date default NULL, -- currently unused |
1897 |
`notificationdate` date default NULL, -- currently unused |
1898 |
`reminderdate` date default NULL, -- currently unused |
1898 |
`reminderdate` date default NULL, -- currently unused |
1899 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1899 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1900 |
`reservenotes` mediumtext, -- notes related to this hold |
1900 |
`reservenotes` LONGTEXT, -- notes related to this hold |
1901 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1901 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1902 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1902 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1903 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1903 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
Lines 1933-1939
CREATE TABLE `reviews` ( -- patron opac comments
Link Here
|
1933 |
`reviewid` int(11) NOT NULL auto_increment, -- unique identifier for this comment |
1933 |
`reviewid` int(11) NOT NULL auto_increment, -- unique identifier for this comment |
1934 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron left this comment |
1934 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron left this comment |
1935 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bibliographic record this comment is for |
1935 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bibliographic record this comment is for |
1936 |
`review` text, -- the body of the comment |
1936 |
`review` MEDIUMTEXT, -- the body of the comment |
1937 |
`approved` tinyint(4) default 0, -- whether this comment has been approved by a librarian (1 for yes, 0 for no) |
1937 |
`approved` tinyint(4) default 0, -- whether this comment has been approved by a librarian (1 for yes, 0 for no) |
1938 |
`datereviewed` datetime default NULL, -- the date the comment was left |
1938 |
`datereviewed` datetime default NULL, -- the date the comment was left |
1939 |
PRIMARY KEY (`reviewid`), |
1939 |
PRIMARY KEY (`reviewid`), |
Lines 1954-1960
CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings
Link Here
|
1954 |
`year` smallint(6) NOT NULL default 0, -- year this closing is in |
1954 |
`year` smallint(6) NOT NULL default 0, -- year this closing is in |
1955 |
`isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) |
1955 |
`isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) |
1956 |
`title` varchar(50) NOT NULL default '', -- title for this closing |
1956 |
`title` varchar(50) NOT NULL default '', -- title for this closing |
1957 |
`description` text NOT NULL, -- description of this closing |
1957 |
`description` MEDIUMTEXT NOT NULL, -- description of this closing |
1958 |
PRIMARY KEY (`id`) |
1958 |
PRIMARY KEY (`id`) |
1959 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1959 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1960 |
|
1960 |
|
Lines 1969-1975
CREATE TABLE `statistics` ( -- information related to transactions (circulation
Link Here
|
1969 |
`proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code) |
1969 |
`proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code) |
1970 |
`value` double(16,4) default NULL, -- monetary value associated with the transaction |
1970 |
`value` double(16,4) default NULL, -- monetary value associated with the transaction |
1971 |
`type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*) |
1971 |
`type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*) |
1972 |
`other` mediumtext, -- used by SIP |
1972 |
`other` LONGTEXT, -- used by SIP |
1973 |
`usercode` varchar(10) default NULL, -- unused in Koha |
1973 |
`usercode` varchar(10) default NULL, -- unused in Koha |
1974 |
`itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item |
1974 |
`itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item |
1975 |
`itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type |
1975 |
`itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type |
Lines 1996-2002
CREATE TABLE `statistics` ( -- information related to transactions (circulation
Link Here
|
1996 |
DROP TABLE IF EXISTS subscription_frequencies; |
1996 |
DROP TABLE IF EXISTS subscription_frequencies; |
1997 |
CREATE TABLE subscription_frequencies ( |
1997 |
CREATE TABLE subscription_frequencies ( |
1998 |
id INTEGER NOT NULL AUTO_INCREMENT, |
1998 |
id INTEGER NOT NULL AUTO_INCREMENT, |
1999 |
description TEXT NOT NULL, |
1999 |
description MEDIUMTEXT NOT NULL, |
2000 |
displayorder INT DEFAULT NULL, |
2000 |
displayorder INT DEFAULT NULL, |
2001 |
unit ENUM('day','week','month','year') DEFAULT NULL, |
2001 |
unit ENUM('day','week','month','year') DEFAULT NULL, |
2002 |
unitsperissue INTEGER NOT NULL DEFAULT '1', |
2002 |
unitsperissue INTEGER NOT NULL DEFAULT '1', |
Lines 2013-2019
CREATE TABLE subscription_numberpatterns (
Link Here
|
2013 |
id INTEGER NOT NULL AUTO_INCREMENT, |
2013 |
id INTEGER NOT NULL AUTO_INCREMENT, |
2014 |
label VARCHAR(255) NOT NULL, |
2014 |
label VARCHAR(255) NOT NULL, |
2015 |
displayorder INTEGER DEFAULT NULL, |
2015 |
displayorder INTEGER DEFAULT NULL, |
2016 |
description TEXT NOT NULL, |
2016 |
description MEDIUMTEXT NOT NULL, |
2017 |
numberingmethod VARCHAR(255) NOT NULL, |
2017 |
numberingmethod VARCHAR(255) NOT NULL, |
2018 |
label1 VARCHAR(255) DEFAULT NULL, |
2018 |
label1 VARCHAR(255) DEFAULT NULL, |
2019 |
add1 INTEGER DEFAULT NULL, |
2019 |
add1 INTEGER DEFAULT NULL, |
Lines 2054-2060
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
2054 |
`numberlength` int(11) default 0, -- subscription length in weeks (will not be filled in if monthlength or weeklength is set) |
2054 |
`numberlength` int(11) default 0, -- subscription length in weeks (will not be filled in if monthlength or weeklength is set) |
2055 |
`periodicity` integer default null, -- frequency type links to subscription_frequencies.id |
2055 |
`periodicity` integer default null, -- frequency type links to subscription_frequencies.id |
2056 |
countissuesperunit INTEGER NOT NULL DEFAULT 1, |
2056 |
countissuesperunit INTEGER NOT NULL DEFAULT 1, |
2057 |
`notes` mediumtext, -- notes |
2057 |
`notes` LONGTEXT, -- notes |
2058 |
`status` varchar(100) NOT NULL default '', -- status of this subscription |
2058 |
`status` varchar(100) NOT NULL default '', -- status of this subscription |
2059 |
`lastvalue1` int(11) default NULL, |
2059 |
`lastvalue1` int(11) default NULL, |
2060 |
`innerloop1` int(11) default 0, |
2060 |
`innerloop1` int(11) default 0, |
Lines 2064-2077
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
2064 |
`innerloop3` int(11) default 0, |
2064 |
`innerloop3` int(11) default 0, |
2065 |
`firstacquidate` date default NULL, -- first issue received date |
2065 |
`firstacquidate` date default NULL, -- first issue received date |
2066 |
`manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually |
2066 |
`manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually |
2067 |
`irregularity` text, -- any irregularities in the subscription |
2067 |
`irregularity` MEDIUMTEXT, -- any irregularities in the subscription |
2068 |
skip_serialseq BOOLEAN NOT NULL DEFAULT 0, |
2068 |
skip_serialseq BOOLEAN NOT NULL DEFAULT 0, |
2069 |
`letter` varchar(20) default NULL, |
2069 |
`letter` varchar(20) default NULL, |
2070 |
`numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id |
2070 |
`numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id |
2071 |
locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly |
2071 |
locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly |
2072 |
`distributedto` text, |
2072 |
`distributedto` MEDIUMTEXT, |
2073 |
`internalnotes` longtext, |
2073 |
`internalnotes` LONGTEXT, |
2074 |
`callnumber` text, -- default call number |
2074 |
`callnumber` MEDIUMTEXT, -- default call number |
2075 |
`location` varchar(80) NULL default '', -- default shelving location (items.location) |
2075 |
`location` varchar(80) NULL default '', -- default shelving location (items.location) |
2076 |
`branchcode` varchar(10) NOT NULL default '', -- default branches (items.homebranch) |
2076 |
`branchcode` varchar(10) NOT NULL default '', -- default branches (items.homebranch) |
2077 |
`lastbranch` varchar(10), |
2077 |
`lastbranch` varchar(10), |
Lines 2099-2106
CREATE TABLE `subscriptionhistory` (
Link Here
|
2099 |
`subscriptionid` int(11) NOT NULL default 0, |
2099 |
`subscriptionid` int(11) NOT NULL default 0, |
2100 |
`histstartdate` date default NULL, |
2100 |
`histstartdate` date default NULL, |
2101 |
`histenddate` date default NULL, |
2101 |
`histenddate` date default NULL, |
2102 |
`missinglist` longtext NOT NULL, |
2102 |
`missinglist` LONGTEXT NOT NULL, |
2103 |
`recievedlist` longtext NOT NULL, |
2103 |
`recievedlist` LONGTEXT NOT NULL, |
2104 |
`opacnote` varchar(150) NOT NULL default '', |
2104 |
`opacnote` varchar(150) NOT NULL default '', |
2105 |
`librariannote` varchar(150) NOT NULL default '', |
2105 |
`librariannote` varchar(150) NOT NULL default '', |
2106 |
PRIMARY KEY (`subscriptionid`), |
2106 |
PRIMARY KEY (`subscriptionid`), |
Lines 2132-2140
CREATE TABLE `subscriptionroutinglist` ( -- information related to the routing l
Link Here
|
2132 |
DROP TABLE IF EXISTS `systempreferences`; |
2132 |
DROP TABLE IF EXISTS `systempreferences`; |
2133 |
CREATE TABLE `systempreferences` ( -- global system preferences |
2133 |
CREATE TABLE `systempreferences` ( -- global system preferences |
2134 |
`variable` varchar(50) NOT NULL default '', -- system preference name |
2134 |
`variable` varchar(50) NOT NULL default '', -- system preference name |
2135 |
`value` text, -- system preference values |
2135 |
`value` MEDIUMTEXT, -- system preference values |
2136 |
`options` mediumtext, -- options for multiple choice system preferences |
2136 |
`options` LONGTEXT, -- options for multiple choice system preferences |
2137 |
`explanation` text, -- descriptive text for the system preference |
2137 |
`explanation` MEDIUMTEXT, -- descriptive text for the system preference |
2138 |
`type` varchar(20) default NULL, -- type of question this preference asks (multiple choice, plain text, yes or no, etc) |
2138 |
`type` varchar(20) default NULL, -- type of question this preference asks (multiple choice, plain text, yes or no, etc) |
2139 |
PRIMARY KEY (`variable`) |
2139 |
PRIMARY KEY (`variable`) |
2140 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2140 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 2282-2298
CREATE TABLE `z3950servers` ( -- connection information for the Z39.50 targets u
Link Here
|
2282 |
`db` varchar(255) default NULL, -- target's database name |
2282 |
`db` varchar(255) default NULL, -- target's database name |
2283 |
`userid` varchar(255) default NULL, -- username needed to log in to target |
2283 |
`userid` varchar(255) default NULL, -- username needed to log in to target |
2284 |
`password` varchar(255) default NULL, -- password needed to log in to target |
2284 |
`password` varchar(255) default NULL, -- password needed to log in to target |
2285 |
`servername` mediumtext NOT NULL, -- name given to the target by the library |
2285 |
`servername` LONGTEXT NOT NULL, -- name given to the target by the library |
2286 |
`checked` smallint(6) default NULL, -- whether this target is checked by default (1 for yes, 0 for no) |
2286 |
`checked` smallint(6) default NULL, -- whether this target is checked by default (1 for yes, 0 for no) |
2287 |
`rank` int(11) default NULL, -- where this target appears in the list of targets |
2287 |
`rank` int(11) default NULL, -- where this target appears in the list of targets |
2288 |
`syntax` varchar(80) default NULL, -- marc format provided by this target |
2288 |
`syntax` varchar(80) default NULL, -- marc format provided by this target |
2289 |
`timeout` int(11) NOT NULL DEFAULT '0', -- number of seconds before Koha stops trying to access this server |
2289 |
`timeout` int(11) NOT NULL DEFAULT '0', -- number of seconds before Koha stops trying to access this server |
2290 |
`servertype` enum('zed','sru') NOT NULL default 'zed', -- zed means z39.50 server |
2290 |
`servertype` enum('zed','sru') NOT NULL default 'zed', -- zed means z39.50 server |
2291 |
`encoding` text default NULL, -- characters encoding provided by this target |
2291 |
`encoding` MEDIUMTEXT default NULL, -- characters encoding provided by this target |
2292 |
`recordtype` enum('authority','biblio') NOT NULL default 'biblio', -- server contains bibliographic or authority records |
2292 |
`recordtype` enum('authority','biblio') NOT NULL default 'biblio', -- server contains bibliographic or authority records |
2293 |
`sru_options` varchar(255) default NULL, -- options like sru=get, sru_version=1.1; will be passed to the server via ZOOM |
2293 |
`sru_options` varchar(255) default NULL, -- options like sru=get, sru_version=1.1; will be passed to the server via ZOOM |
2294 |
`sru_fields` mediumtext default NULL, -- contains the mapping between the Z3950 search fields and the specific SRU server indexes |
2294 |
`sru_fields` LONGTEXT default NULL, -- contains the mapping between the Z3950 search fields and the specific SRU server indexes |
2295 |
`add_xslt` mediumtext default NULL, -- zero or more paths to XSLT files to be processed on the search results |
2295 |
`add_xslt` LONGTEXT default NULL, -- zero or more paths to XSLT files to be processed on the search results |
2296 |
PRIMARY KEY (`id`) |
2296 |
PRIMARY KEY (`id`) |
2297 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2297 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2298 |
|
2298 |
|
Lines 2449-2465
CREATE TABLE `tmp_holdsqueue` (
Link Here
|
2449 |
`biblionumber` int(11) default NULL, |
2449 |
`biblionumber` int(11) default NULL, |
2450 |
`itemnumber` int(11) default NULL, |
2450 |
`itemnumber` int(11) default NULL, |
2451 |
`barcode` varchar(20) default NULL, |
2451 |
`barcode` varchar(20) default NULL, |
2452 |
`surname` mediumtext NOT NULL, |
2452 |
`surname` LONGTEXT NOT NULL, |
2453 |
`firstname` text, |
2453 |
`firstname` MEDIUMTEXT, |
2454 |
`phone` text, |
2454 |
`phone` MEDIUMTEXT, |
2455 |
`borrowernumber` int(11) NOT NULL, |
2455 |
`borrowernumber` int(11) NOT NULL, |
2456 |
`cardnumber` varchar(32) default NULL, |
2456 |
`cardnumber` varchar(32) default NULL, |
2457 |
`reservedate` date default NULL, |
2457 |
`reservedate` date default NULL, |
2458 |
`title` mediumtext, |
2458 |
`title` LONGTEXT, |
2459 |
`itemcallnumber` varchar(255) default NULL, |
2459 |
`itemcallnumber` varchar(255) default NULL, |
2460 |
`holdingbranch` varchar(10) default NULL, |
2460 |
`holdingbranch` varchar(10) default NULL, |
2461 |
`pickbranch` varchar(10) default NULL, |
2461 |
`pickbranch` varchar(10) default NULL, |
2462 |
`notes` text, |
2462 |
`notes` MEDIUMTEXT, |
2463 |
`item_level_request` tinyint(4) NOT NULL default 0 |
2463 |
`item_level_request` tinyint(4) NOT NULL default 0 |
2464 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2464 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2465 |
|
2465 |
|
Lines 2481-2496
DROP TABLE IF EXISTS `message_queue`;
Link Here
|
2481 |
CREATE TABLE `message_queue` ( |
2481 |
CREATE TABLE `message_queue` ( |
2482 |
`message_id` int(11) NOT NULL auto_increment, |
2482 |
`message_id` int(11) NOT NULL auto_increment, |
2483 |
`borrowernumber` int(11) default NULL, |
2483 |
`borrowernumber` int(11) default NULL, |
2484 |
`subject` text, |
2484 |
`subject` MEDIUMTEXT, |
2485 |
`content` text, |
2485 |
`content` MEDIUMTEXT, |
2486 |
`metadata` text DEFAULT NULL, |
2486 |
`metadata` MEDIUMTEXT DEFAULT NULL, |
2487 |
`letter_code` varchar(64) DEFAULT NULL, |
2487 |
`letter_code` varchar(64) DEFAULT NULL, |
2488 |
`message_transport_type` varchar(20) NOT NULL, |
2488 |
`message_transport_type` varchar(20) NOT NULL, |
2489 |
`status` enum('sent','pending','failed','deleted') NOT NULL default 'pending', |
2489 |
`status` enum('sent','pending','failed','deleted') NOT NULL default 'pending', |
2490 |
`time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2490 |
`time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2491 |
`to_address` mediumtext, |
2491 |
`to_address` LONGTEXT, |
2492 |
`from_address` mediumtext, |
2492 |
`from_address` LONGTEXT, |
2493 |
`content_type` text, |
2493 |
`content_type` MEDIUMTEXT, |
2494 |
PRIMARY KEY `message_id` (`message_id`), |
2494 |
PRIMARY KEY `message_id` (`message_id`), |
2495 |
KEY `borrowernumber` (`borrowernumber`), |
2495 |
KEY `borrowernumber` (`borrowernumber`), |
2496 |
KEY `message_transport_type` (`message_transport_type`), |
2496 |
KEY `message_transport_type` (`message_transport_type`), |
Lines 2510-2516
CREATE TABLE `letter` ( -- table for all notice templates in Koha
Link Here
|
2510 |
`name` varchar(100) NOT NULL default '', -- plain text name for this notice or slip |
2510 |
`name` varchar(100) NOT NULL default '', -- plain text name for this notice or slip |
2511 |
`is_html` tinyint(1) default 0, -- does this notice or slip use HTML (1 for yes, 0 for no) |
2511 |
`is_html` tinyint(1) default 0, -- does this notice or slip use HTML (1 for yes, 0 for no) |
2512 |
`title` varchar(200) NOT NULL default '', -- subject line of the notice |
2512 |
`title` varchar(200) NOT NULL default '', -- subject line of the notice |
2513 |
`content` text, -- body text for the notice or slip |
2513 |
`content` MEDIUMTEXT, -- body text for the notice or slip |
2514 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice |
2514 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email', -- transport type for this notice |
2515 |
`lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice |
2515 |
`lang` varchar(25) NOT NULL DEFAULT 'default', -- lang of the notice |
2516 |
PRIMARY KEY (`module`,`code`, `branchcode`, `message_transport_type`, `lang`), |
2516 |
PRIMARY KEY (`module`,`code`, `branchcode`, `message_transport_type`, `lang`), |
Lines 2656-2662
CREATE TABLE `messages` ( -- circulation messages left via the patron's check ou
Link Here
|
2656 |
`borrowernumber` int(11) NOT NULL, -- foreign key linking this message to the borrowers table |
2656 |
`borrowernumber` int(11) NOT NULL, -- foreign key linking this message to the borrowers table |
2657 |
`branchcode` varchar(10) default NULL, -- foreign key linking the message to the branches table |
2657 |
`branchcode` varchar(10) default NULL, -- foreign key linking the message to the branches table |
2658 |
`message_type` varchar(1) NOT NULL, -- whether the message is for the librarians (L) or the patron (B) |
2658 |
`message_type` varchar(1) NOT NULL, -- whether the message is for the librarians (L) or the patron (B) |
2659 |
`message` text NOT NULL, -- the text of the message |
2659 |
`message` MEDIUMTEXT NOT NULL, -- the text of the message |
2660 |
`message_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- the date and time the message was written |
2660 |
`message_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- the date and time the message was written |
2661 |
`manager_id` int(11) default NULL, -- creator of message |
2661 |
`manager_id` int(11) default NULL, -- creator of message |
2662 |
PRIMARY KEY (`message_id`), |
2662 |
PRIMARY KEY (`message_id`), |
Lines 2676-2688
CREATE TABLE `accountlines` (
Link Here
|
2676 |
`itemnumber` int(11) default NULL, |
2676 |
`itemnumber` int(11) default NULL, |
2677 |
`date` date default NULL, |
2677 |
`date` date default NULL, |
2678 |
`amount` decimal(28,6) default NULL, |
2678 |
`amount` decimal(28,6) default NULL, |
2679 |
`description` mediumtext, |
2679 |
`description` LONGTEXT, |
2680 |
`dispute` mediumtext, |
2680 |
`dispute` LONGTEXT, |
2681 |
`accounttype` varchar(5) default NULL, |
2681 |
`accounttype` varchar(5) default NULL, |
2682 |
`amountoutstanding` decimal(28,6) default NULL, |
2682 |
`amountoutstanding` decimal(28,6) default NULL, |
2683 |
`lastincrement` decimal(28,6) default NULL, |
2683 |
`lastincrement` decimal(28,6) default NULL, |
2684 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2684 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2685 |
`note` text NULL default NULL, |
2685 |
`note` MEDIUMTEXT NULL default NULL, |
2686 |
`manager_id` int(11) NULL, |
2686 |
`manager_id` int(11) NULL, |
2687 |
PRIMARY KEY (`accountlines_id`), |
2687 |
PRIMARY KEY (`accountlines_id`), |
2688 |
KEY `acctsborridx` (`borrowernumber`), |
2688 |
KEY `acctsborridx` (`borrowernumber`), |
Lines 2729-2738
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the
Link Here
|
2729 |
`action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action |
2729 |
`action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action |
2730 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time the action took place |
2730 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time the action took place |
2731 |
`user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) |
2731 |
`user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) |
2732 |
`module` text, -- the module this action was taken against |
2732 |
`module` MEDIUMTEXT, -- the module this action was taken against |
2733 |
`action` text, -- the action (includes things like DELETED, ADDED, MODIFY, etc) |
2733 |
`action` MEDIUMTEXT, -- the action (includes things like DELETED, ADDED, MODIFY, etc) |
2734 |
`object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc) |
2734 |
`object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc) |
2735 |
`info` text, -- information about the action (usually includes SQL statement) |
2735 |
`info` MEDIUMTEXT, -- information about the action (usually includes SQL statement) |
2736 |
`interface` VARCHAR(30) DEFAULT NULL, -- the context this action was taken in |
2736 |
`interface` VARCHAR(30) DEFAULT NULL, -- the context this action was taken in |
2737 |
PRIMARY KEY (`action_id`), |
2737 |
PRIMARY KEY (`action_id`), |
2738 |
KEY `timestamp_idx` (`timestamp`), |
2738 |
KEY `timestamp_idx` (`timestamp`), |
Lines 2766-2785
CREATE TABLE `alert` (
Link Here
|
2766 |
DROP TABLE IF EXISTS `aqbooksellers`; |
2766 |
DROP TABLE IF EXISTS `aqbooksellers`; |
2767 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
2767 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
2768 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
2768 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
2769 |
`name` mediumtext NOT NULL, -- vendor name |
2769 |
`name` LONGTEXT NOT NULL, -- vendor name |
2770 |
`address1` mediumtext, -- first line of vendor physical address |
2770 |
`address1` LONGTEXT, -- first line of vendor physical address |
2771 |
`address2` mediumtext, -- second line of vendor physical address |
2771 |
`address2` LONGTEXT, -- second line of vendor physical address |
2772 |
`address3` mediumtext, -- third line of vendor physical address |
2772 |
`address3` LONGTEXT, -- third line of vendor physical address |
2773 |
`address4` mediumtext, -- fourth line of vendor physical address |
2773 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
2774 |
`phone` varchar(30) default NULL, -- vendor phone number |
2774 |
`phone` varchar(30) default NULL, -- vendor phone number |
2775 |
`accountnumber` mediumtext, -- unused in Koha |
2775 |
`accountnumber` LONGTEXT, -- unused in Koha |
2776 |
`othersupplier` mediumtext, -- unused in Koha |
2776 |
`othersupplier` LONGTEXT, -- unused in Koha |
2777 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
2777 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
2778 |
`booksellerfax` mediumtext, -- vendor fax number |
2778 |
`booksellerfax` LONGTEXT, -- vendor fax number |
2779 |
`notes` mediumtext, -- order notes |
2779 |
`notes` LONGTEXT, -- order notes |
2780 |
`bookselleremail` mediumtext, -- vendor email |
2780 |
`bookselleremail` LONGTEXT, -- vendor email |
2781 |
`booksellerurl` mediumtext, -- unused in Koha |
2781 |
`booksellerurl` LONGTEXT, -- unused in Koha |
2782 |
`postal` mediumtext, -- vendor postal address (all lines) |
2782 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
2783 |
`url` varchar(255) default NULL, -- vendor web address |
2783 |
`url` varchar(255) default NULL, -- vendor web address |
2784 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
2784 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
2785 |
`listprice` varchar(10) default NULL, -- currency code for list prices |
2785 |
`listprice` varchar(10) default NULL, -- currency code for list prices |
Lines 2810-2816
CREATE TABLE `aqbasketgroups` (
Link Here
|
2810 |
`closed` tinyint(1) default NULL, |
2810 |
`closed` tinyint(1) default NULL, |
2811 |
`booksellerid` int(11) NOT NULL, |
2811 |
`booksellerid` int(11) NOT NULL, |
2812 |
`deliveryplace` varchar(10) default NULL, |
2812 |
`deliveryplace` varchar(10) default NULL, |
2813 |
`freedeliveryplace` text default NULL, |
2813 |
`freedeliveryplace` MEDIUMTEXT default NULL, |
2814 |
`deliverycomment` varchar(255) default NULL, |
2814 |
`deliverycomment` varchar(255) default NULL, |
2815 |
`billingplace` varchar(10) default NULL, |
2815 |
`billingplace` varchar(10) default NULL, |
2816 |
PRIMARY KEY (`id`), |
2816 |
PRIMARY KEY (`id`), |
Lines 2832-2838
CREATE TABLE `aqbudgets` ( -- information related to Funds
Link Here
|
2832 |
`budget_amount` decimal(28,6) NULL default '0.00', -- total amount for this fund |
2832 |
`budget_amount` decimal(28,6) NULL default '0.00', -- total amount for this fund |
2833 |
`budget_encumb` decimal(28,6) NULL default '0.00', -- not used in the code |
2833 |
`budget_encumb` decimal(28,6) NULL default '0.00', -- not used in the code |
2834 |
`budget_expend` decimal(28,6) NULL default '0.00', -- not used in the code |
2834 |
`budget_expend` decimal(28,6) NULL default '0.00', -- not used in the code |
2835 |
`budget_notes` mediumtext, -- notes related to this fund |
2835 |
`budget_notes` LONGTEXT, -- notes related to this fund |
2836 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this fund was last touched (created or modified) |
2836 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this fund was last touched (created or modified) |
2837 |
`budget_period_id` int(11) default NULL, -- id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) |
2837 |
`budget_period_id` int(11) default NULL, -- id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) |
2838 |
`sort1_authcat` varchar(80) default NULL, -- statistical category for this fund |
2838 |
`sort1_authcat` varchar(80) default NULL, -- statistical category for this fund |
Lines 2875-2881
CREATE TABLE `aqbudgetperiods` ( -- information related to Budgets
Link Here
|
2875 |
`budget_period_startdate` date NOT NULL, -- date when the budget starts |
2875 |
`budget_period_startdate` date NOT NULL, -- date when the budget starts |
2876 |
`budget_period_enddate` date NOT NULL, -- date when the budget ends |
2876 |
`budget_period_enddate` date NOT NULL, -- date when the budget ends |
2877 |
`budget_period_active` tinyint(1) default '0', -- whether this budget is active or not (1 for yes, 0 for no) |
2877 |
`budget_period_active` tinyint(1) default '0', -- whether this budget is active or not (1 for yes, 0 for no) |
2878 |
`budget_period_description` mediumtext, -- description assigned to this budget |
2878 |
`budget_period_description` LONGTEXT, -- description assigned to this budget |
2879 |
`budget_period_total` decimal(28,6), -- total amount available in this budget |
2879 |
`budget_period_total` decimal(28,6), -- total amount available in this budget |
2880 |
`budget_period_locked` tinyint(1) default NULL, -- whether this budget is locked or not (1 for yes, 0 for no) |
2880 |
`budget_period_locked` tinyint(1) default NULL, -- whether this budget is locked or not (1 for yes, 0 for no) |
2881 |
`sort1_authcat` varchar(10) default NULL, -- statistical category for this budget |
2881 |
`sort1_authcat` varchar(10) default NULL, -- statistical category for this budget |
Lines 2914-2920
CREATE TABLE aqcontacts (
Link Here
|
2914 |
altphone varchar(100) default NULL, -- contact's alternate phone number |
2914 |
altphone varchar(100) default NULL, -- contact's alternate phone number |
2915 |
fax varchar(100) default NULL, -- contact's fax number |
2915 |
fax varchar(100) default NULL, -- contact's fax number |
2916 |
email varchar(100) default NULL, -- contact's email address |
2916 |
email varchar(100) default NULL, -- contact's email address |
2917 |
notes mediumtext, -- notes related to the contact |
2917 |
notes LONGTEXT, -- notes related to the contact |
2918 |
orderacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisition orders |
2918 |
orderacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisition orders |
2919 |
claimacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims |
2919 |
claimacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims |
2920 |
claimissues BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive serial claims |
2920 |
claimissues BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive serial claims |
Lines 2936-2942
CREATE TABLE `aqcontract` (
Link Here
|
2936 |
`contractstartdate` date default NULL, |
2936 |
`contractstartdate` date default NULL, |
2937 |
`contractenddate` date default NULL, |
2937 |
`contractenddate` date default NULL, |
2938 |
`contractname` varchar(50) default NULL, |
2938 |
`contractname` varchar(50) default NULL, |
2939 |
`contractdescription` mediumtext, |
2939 |
`contractdescription` LONGTEXT, |
2940 |
`booksellerid` int(11) not NULL, |
2940 |
`booksellerid` int(11) not NULL, |
2941 |
PRIMARY KEY (`contractnumber`), |
2941 |
PRIMARY KEY (`contractnumber`), |
2942 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
2942 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
Lines 2951-2964
DROP TABLE IF EXISTS `aqbasket`;
Link Here
|
2951 |
CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions |
2951 |
CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions |
2952 |
`basketno` int(11) NOT NULL auto_increment, -- primary key, Koha defined number |
2952 |
`basketno` int(11) NOT NULL auto_increment, -- primary key, Koha defined number |
2953 |
`basketname` varchar(50) default NULL, -- name given to the basket at creation |
2953 |
`basketname` varchar(50) default NULL, -- name given to the basket at creation |
2954 |
`note` mediumtext, -- the internal note added at basket creation |
2954 |
`note` LONGTEXT, -- the internal note added at basket creation |
2955 |
`booksellernote` mediumtext, -- the vendor note added at basket creation |
2955 |
`booksellernote` LONGTEXT, -- the vendor note added at basket creation |
2956 |
`contractnumber` int(11), -- links this basket to the aqcontract table (aqcontract.contractnumber) |
2956 |
`contractnumber` int(11), -- links this basket to the aqcontract table (aqcontract.contractnumber) |
2957 |
`creationdate` date default NULL, -- the date the basket was created |
2957 |
`creationdate` date default NULL, -- the date the basket was created |
2958 |
`closedate` date default NULL, -- the date the basket was closed |
2958 |
`closedate` date default NULL, -- the date the basket was closed |
2959 |
`booksellerid` int(11) NOT NULL default 1, -- the Koha assigned ID for the vendor (aqbooksellers.id) |
2959 |
`booksellerid` int(11) NOT NULL default 1, -- the Koha assigned ID for the vendor (aqbooksellers.id) |
2960 |
`authorisedby` varchar(10) default NULL, -- the borrowernumber of the person who created the basket |
2960 |
`authorisedby` varchar(10) default NULL, -- the borrowernumber of the person who created the basket |
2961 |
`booksellerinvoicenumber` mediumtext, -- appears to always be NULL |
2961 |
`booksellerinvoicenumber` LONGTEXT, -- appears to always be NULL |
2962 |
`basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id) |
2962 |
`basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id) |
2963 |
`deliveryplace` varchar(10) default NULL, -- basket delivery place |
2963 |
`deliveryplace` varchar(10) default NULL, -- basket delivery place |
2964 |
`billingplace` varchar(10) default NULL, -- basket billing place |
2964 |
`billingplace` varchar(10) default NULL, -- basket billing place |
Lines 3005-3011
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
3005 |
rejectedby INT(11) default NULL, -- borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table |
3005 |
rejectedby INT(11) default NULL, -- borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table |
3006 |
rejecteddate date default NULL, -- date the suggestion was marked as rejected |
3006 |
rejecteddate date default NULL, -- date the suggestion was marked as rejected |
3007 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) |
3007 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) |
3008 |
`note` mediumtext, -- note entered on the suggestion |
3008 |
`note` LONGTEXT, -- note entered on the suggestion |
3009 |
`author` varchar(80) default NULL, -- author of the suggested item |
3009 |
`author` varchar(80) default NULL, -- author of the suggested item |
3010 |
`title` varchar(255) default NULL, -- title of the suggested item |
3010 |
`title` varchar(255) default NULL, -- title of the suggested item |
3011 |
`copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item |
3011 |
`copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item |
Lines 3016-3026
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
3016 |
`place` varchar(255) default NULL, -- publication place of the suggested item |
3016 |
`place` varchar(255) default NULL, -- publication place of the suggested item |
3017 |
`isbn` varchar(30) default NULL, -- isbn of the suggested item |
3017 |
`isbn` varchar(30) default NULL, -- isbn of the suggested item |
3018 |
`biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered |
3018 |
`biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered |
3019 |
`reason` text, -- reason for accepting or rejecting the suggestion |
3019 |
`reason` MEDIUMTEXT, -- reason for accepting or rejecting the suggestion |
3020 |
`patronreason` text, -- reason for making the suggestion |
3020 |
`patronreason` MEDIUMTEXT, -- reason for making the suggestion |
3021 |
budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table |
3021 |
budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table |
3022 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
3022 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
3023 |
collectiontitle text default NULL, -- collection name for the suggested item |
3023 |
collectiontitle MEDIUMTEXT default NULL, -- collection name for the suggested item |
3024 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
3024 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
3025 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
3025 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
3026 |
currency VARCHAR(10) default NULL, -- suggested currency for the suggested price |
3026 |
currency VARCHAR(10) default NULL, -- suggested currency for the suggested price |
Lines 3042-3055
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
3042 |
DROP TABLE IF EXISTS vendor_edi_accounts; |
3042 |
DROP TABLE IF EXISTS vendor_edi_accounts; |
3043 |
CREATE TABLE IF NOT EXISTS vendor_edi_accounts ( |
3043 |
CREATE TABLE IF NOT EXISTS vendor_edi_accounts ( |
3044 |
id INT(11) NOT NULL auto_increment, |
3044 |
id INT(11) NOT NULL auto_increment, |
3045 |
description TEXT NOT NULL, |
3045 |
description MEDIUMTEXT NOT NULL, |
3046 |
host VARCHAR(40), |
3046 |
host VARCHAR(40), |
3047 |
username VARCHAR(40), |
3047 |
username VARCHAR(40), |
3048 |
password VARCHAR(40), |
3048 |
password VARCHAR(40), |
3049 |
last_activity DATE, |
3049 |
last_activity DATE, |
3050 |
vendor_id INT(11) REFERENCES aqbooksellers( id ), |
3050 |
vendor_id INT(11) REFERENCES aqbooksellers( id ), |
3051 |
download_directory TEXT, |
3051 |
download_directory MEDIUMTEXT, |
3052 |
upload_directory TEXT, |
3052 |
upload_directory MEDIUMTEXT, |
3053 |
san VARCHAR(20), |
3053 |
san VARCHAR(20), |
3054 |
id_code_qualifier VARCHAR(3) default '14', |
3054 |
id_code_qualifier VARCHAR(3) default '14', |
3055 |
transport VARCHAR(6) default 'FTP', |
3055 |
transport VARCHAR(6) default 'FTP', |
Lines 3078-3087
CREATE TABLE IF NOT EXISTS edifact_messages (
Link Here
|
3078 |
transfer_date DATE, |
3078 |
transfer_date DATE, |
3079 |
vendor_id INT(11) REFERENCES aqbooksellers( id ), |
3079 |
vendor_id INT(11) REFERENCES aqbooksellers( id ), |
3080 |
edi_acct INTEGER REFERENCES vendor_edi_accounts( id ), |
3080 |
edi_acct INTEGER REFERENCES vendor_edi_accounts( id ), |
3081 |
status TEXT, |
3081 |
status MEDIUMTEXT, |
3082 |
basketno INT(11) REFERENCES aqbasket( basketno), |
3082 |
basketno INT(11) REFERENCES aqbasket( basketno), |
3083 |
raw_msg MEDIUMTEXT, |
3083 |
raw_msg LONGTEXT, |
3084 |
filename TEXT, |
3084 |
filename MEDIUMTEXT, |
3085 |
deleted BOOLEAN NOT NULL DEFAULT 0, |
3085 |
deleted BOOLEAN NOT NULL DEFAULT 0, |
3086 |
PRIMARY KEY (id), |
3086 |
PRIMARY KEY (id), |
3087 |
KEY vendorid ( vendor_id), |
3087 |
KEY vendorid ( vendor_id), |
Lines 3099-3105
CREATE TABLE IF NOT EXISTS edifact_messages (
Link Here
|
3099 |
DROP TABLE IF EXISTS aqinvoices; |
3099 |
DROP TABLE IF EXISTS aqinvoices; |
3100 |
CREATE TABLE aqinvoices ( |
3100 |
CREATE TABLE aqinvoices ( |
3101 |
invoiceid int(11) NOT NULL AUTO_INCREMENT, -- ID of the invoice, primary key |
3101 |
invoiceid int(11) NOT NULL AUTO_INCREMENT, -- ID of the invoice, primary key |
3102 |
invoicenumber mediumtext NOT NULL, -- Name of invoice |
3102 |
invoicenumber LONGTEXT NOT NULL, -- Name of invoice |
3103 |
booksellerid int(11) NOT NULL, -- foreign key to aqbooksellers |
3103 |
booksellerid int(11) NOT NULL, -- foreign key to aqbooksellers |
3104 |
shipmentdate date default NULL, -- date of shipment |
3104 |
shipmentdate date default NULL, -- date of shipment |
3105 |
billingdate date default NULL, -- date of billing |
3105 |
billingdate date default NULL, -- date of billing |
Lines 3133-3142
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3133 |
`unitprice_tax_included` decimal(28,6) default NULL, -- the unit price including tax (on receiving) |
3133 |
`unitprice_tax_included` decimal(28,6) default NULL, -- the unit price including tax (on receiving) |
3134 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3134 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3135 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3135 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3136 |
`cancellationreason` text default NULL, -- reason of cancellation |
3136 |
`cancellationreason` MEDIUMTEXT default NULL, -- reason of cancellation |
3137 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |
3137 |
`order_internalnote` LONGTEXT, -- notes related to this order line, made for staff |
3138 |
`order_vendornote` mediumtext, -- notes related to this order line, made for vendor |
3138 |
`order_vendornote` LONGTEXT, -- notes related to this order line, made for vendor |
3139 |
`purchaseordernumber` mediumtext, -- not used? always NULL |
3139 |
`purchaseordernumber` LONGTEXT, -- not used? always NULL |
3140 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3140 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3141 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |
3141 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |
3142 |
`rrp` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
3142 |
`rrp` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
Lines 3167-3173
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3167 |
line_item_id varchar(35) default NULL, -- Supplier's article id for Edifact orderline |
3167 |
line_item_id varchar(35) default NULL, -- Supplier's article id for Edifact orderline |
3168 |
suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref |
3168 |
suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref |
3169 |
suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI' |
3169 |
suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI' |
3170 |
`suppliers_report` text COLLATE utf8mb4_unicode_ci, -- reports received from suppliers |
3170 |
`suppliers_report` MEDIUMTEXT COLLATE utf8mb4_unicode_ci, -- reports received from suppliers |
3171 |
PRIMARY KEY (`ordernumber`), |
3171 |
PRIMARY KEY (`ordernumber`), |
3172 |
KEY `basketno` (`basketno`), |
3172 |
KEY `basketno` (`basketno`), |
3173 |
KEY `biblionumber` (`biblionumber`), |
3173 |
KEY `biblionumber` (`biblionumber`), |
Lines 3308-3315
CREATE TABLE ratings ( -- information related to the star ratings in the OPAC
Link Here
|
3308 |
DROP TABLE IF EXISTS quotes; |
3308 |
DROP TABLE IF EXISTS quotes; |
3309 |
CREATE TABLE `quotes` ( -- data for the quote of the day feature |
3309 |
CREATE TABLE `quotes` ( -- data for the quote of the day feature |
3310 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote |
3310 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote |
3311 |
`source` text DEFAULT NULL, -- source/credit for the quote |
3311 |
`source` MEDIUMTEXT DEFAULT NULL, -- source/credit for the quote |
3312 |
`text` mediumtext NOT NULL, -- text of the quote |
3312 |
`text` LONGTEXT NOT NULL, -- text of the quote |
3313 |
`timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac |
3313 |
`timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac |
3314 |
PRIMARY KEY (`id`) |
3314 |
PRIMARY KEY (`id`) |
3315 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3315 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 3360-3394
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3360 |
`verification_token` varchar(255) NOT NULL DEFAULT '', |
3360 |
`verification_token` varchar(255) NOT NULL DEFAULT '', |
3361 |
`borrowernumber` int(11) NOT NULL DEFAULT '0', |
3361 |
`borrowernumber` int(11) NOT NULL DEFAULT '0', |
3362 |
`cardnumber` varchar(32) DEFAULT NULL, |
3362 |
`cardnumber` varchar(32) DEFAULT NULL, |
3363 |
`surname` mediumtext, |
3363 |
`surname` LONGTEXT, |
3364 |
`firstname` text, |
3364 |
`firstname` MEDIUMTEXT, |
3365 |
`title` mediumtext, |
3365 |
`title` LONGTEXT, |
3366 |
`othernames` mediumtext, |
3366 |
`othernames` LONGTEXT, |
3367 |
`initials` text, |
3367 |
`initials` MEDIUMTEXT, |
3368 |
`streetnumber` varchar(10) DEFAULT NULL, |
3368 |
`streetnumber` varchar(10) DEFAULT NULL, |
3369 |
`streettype` varchar(50) DEFAULT NULL, |
3369 |
`streettype` varchar(50) DEFAULT NULL, |
3370 |
`address` mediumtext, |
3370 |
`address` LONGTEXT, |
3371 |
`address2` text, |
3371 |
`address2` MEDIUMTEXT, |
3372 |
`city` mediumtext, |
3372 |
`city` LONGTEXT, |
3373 |
`state` text, |
3373 |
`state` MEDIUMTEXT, |
3374 |
`zipcode` varchar(25) DEFAULT NULL, |
3374 |
`zipcode` varchar(25) DEFAULT NULL, |
3375 |
`country` text, |
3375 |
`country` MEDIUMTEXT, |
3376 |
`email` mediumtext, |
3376 |
`email` LONGTEXT, |
3377 |
`phone` text, |
3377 |
`phone` MEDIUMTEXT, |
3378 |
`mobile` varchar(50) DEFAULT NULL, |
3378 |
`mobile` varchar(50) DEFAULT NULL, |
3379 |
`fax` mediumtext, |
3379 |
`fax` LONGTEXT, |
3380 |
`emailpro` text, |
3380 |
`emailpro` MEDIUMTEXT, |
3381 |
`phonepro` text, |
3381 |
`phonepro` MEDIUMTEXT, |
3382 |
`B_streetnumber` varchar(10) DEFAULT NULL, |
3382 |
`B_streetnumber` varchar(10) DEFAULT NULL, |
3383 |
`B_streettype` varchar(50) DEFAULT NULL, |
3383 |
`B_streettype` varchar(50) DEFAULT NULL, |
3384 |
`B_address` varchar(100) DEFAULT NULL, |
3384 |
`B_address` varchar(100) DEFAULT NULL, |
3385 |
`B_address2` text, |
3385 |
`B_address2` MEDIUMTEXT, |
3386 |
`B_city` mediumtext, |
3386 |
`B_city` LONGTEXT, |
3387 |
`B_state` text, |
3387 |
`B_state` MEDIUMTEXT, |
3388 |
`B_zipcode` varchar(25) DEFAULT NULL, |
3388 |
`B_zipcode` varchar(25) DEFAULT NULL, |
3389 |
`B_country` text, |
3389 |
`B_country` MEDIUMTEXT, |
3390 |
`B_email` text, |
3390 |
`B_email` MEDIUMTEXT, |
3391 |
`B_phone` mediumtext, |
3391 |
`B_phone` LONGTEXT, |
3392 |
`dateofbirth` date DEFAULT NULL, |
3392 |
`dateofbirth` date DEFAULT NULL, |
3393 |
`branchcode` varchar(10) DEFAULT NULL, |
3393 |
`branchcode` varchar(10) DEFAULT NULL, |
3394 |
`categorycode` varchar(10) DEFAULT NULL, |
3394 |
`categorycode` varchar(10) DEFAULT NULL, |
Lines 3399-3415
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3399 |
`lost` tinyint(1) DEFAULT NULL, |
3399 |
`lost` tinyint(1) DEFAULT NULL, |
3400 |
`debarred` date DEFAULT NULL, |
3400 |
`debarred` date DEFAULT NULL, |
3401 |
`debarredcomment` varchar(255) DEFAULT NULL, |
3401 |
`debarredcomment` varchar(255) DEFAULT NULL, |
3402 |
`contactname` mediumtext, |
3402 |
`contactname` LONGTEXT, |
3403 |
`contactfirstname` text, |
3403 |
`contactfirstname` MEDIUMTEXT, |
3404 |
`contacttitle` text, |
3404 |
`contacttitle` MEDIUMTEXT, |
3405 |
`guarantorid` int(11) DEFAULT NULL, |
3405 |
`guarantorid` int(11) DEFAULT NULL, |
3406 |
`borrowernotes` mediumtext, |
3406 |
`borrowernotes` LONGTEXT, |
3407 |
`relationship` varchar(100) DEFAULT NULL, |
3407 |
`relationship` varchar(100) DEFAULT NULL, |
3408 |
`sex` varchar(1) DEFAULT NULL, |
3408 |
`sex` varchar(1) DEFAULT NULL, |
3409 |
`password` varchar(30) DEFAULT NULL, |
3409 |
`password` varchar(30) DEFAULT NULL, |
3410 |
`flags` int(11) DEFAULT NULL, |
3410 |
`flags` int(11) DEFAULT NULL, |
3411 |
`userid` varchar(75) DEFAULT NULL, |
3411 |
`userid` varchar(75) DEFAULT NULL, |
3412 |
`opacnote` mediumtext, |
3412 |
`opacnote` LONGTEXT, |
3413 |
`contactnote` varchar(255) DEFAULT NULL, |
3413 |
`contactnote` varchar(255) DEFAULT NULL, |
3414 |
`sort1` varchar(80) DEFAULT NULL, |
3414 |
`sort1` varchar(80) DEFAULT NULL, |
3415 |
`sort2` varchar(80) DEFAULT NULL, |
3415 |
`sort2` varchar(80) DEFAULT NULL, |
Lines 3418-3430
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3418 |
`altcontactaddress1` varchar(255) DEFAULT NULL, |
3418 |
`altcontactaddress1` varchar(255) DEFAULT NULL, |
3419 |
`altcontactaddress2` varchar(255) DEFAULT NULL, |
3419 |
`altcontactaddress2` varchar(255) DEFAULT NULL, |
3420 |
`altcontactaddress3` varchar(255) DEFAULT NULL, |
3420 |
`altcontactaddress3` varchar(255) DEFAULT NULL, |
3421 |
`altcontactstate` text, |
3421 |
`altcontactstate` MEDIUMTEXT, |
3422 |
`altcontactzipcode` varchar(50) DEFAULT NULL, |
3422 |
`altcontactzipcode` varchar(50) DEFAULT NULL, |
3423 |
`altcontactcountry` text, |
3423 |
`altcontactcountry` MEDIUMTEXT, |
3424 |
`altcontactphone` varchar(50) DEFAULT NULL, |
3424 |
`altcontactphone` varchar(50) DEFAULT NULL, |
3425 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3425 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3426 |
`privacy` int(11) DEFAULT NULL, |
3426 |
`privacy` int(11) DEFAULT NULL, |
3427 |
`extended_attributes` text DEFAULT NULL, |
3427 |
`extended_attributes` MEDIUMTEXT DEFAULT NULL, |
3428 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
3428 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
3429 |
KEY `verification_token` (`verification_token` (191)), |
3429 |
KEY `verification_token` (`verification_token` (191)), |
3430 |
KEY `borrowernumber` (`borrowernumber`) |
3430 |
KEY `borrowernumber` (`borrowernumber`) |
Lines 3438-3445
DROP TABLE IF EXISTS uploaded_files;
Link Here
|
3438 |
CREATE TABLE uploaded_files ( |
3438 |
CREATE TABLE uploaded_files ( |
3439 |
id int(11) NOT NULL AUTO_INCREMENT, |
3439 |
id int(11) NOT NULL AUTO_INCREMENT, |
3440 |
hashvalue CHAR(40) NOT NULL, |
3440 |
hashvalue CHAR(40) NOT NULL, |
3441 |
filename TEXT NOT NULL, |
3441 |
filename MEDIUMTEXT NOT NULL, |
3442 |
dir TEXT NOT NULL, |
3442 |
dir MEDIUMTEXT NOT NULL, |
3443 |
filesize int(11), |
3443 |
filesize int(11), |
3444 |
dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3444 |
dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3445 |
uploadcategorycode tinytext, |
3445 |
uploadcategorycode tinytext, |
Lines 3460-3466
CREATE TABLE linktracker (
Link Here
|
3460 |
biblionumber int(11) DEFAULT NULL, -- biblionumber of the record the link is from |
3460 |
biblionumber int(11) DEFAULT NULL, -- biblionumber of the record the link is from |
3461 |
itemnumber int(11) DEFAULT NULL, -- itemnumber if applicable that the link was from |
3461 |
itemnumber int(11) DEFAULT NULL, -- itemnumber if applicable that the link was from |
3462 |
borrowernumber int(11) DEFAULT NULL, -- borrowernumber who clicked the link |
3462 |
borrowernumber int(11) DEFAULT NULL, -- borrowernumber who clicked the link |
3463 |
url text, -- the link itself |
3463 |
url MEDIUMTEXT, -- the link itself |
3464 |
timeclicked datetime DEFAULT NULL, -- the date and time the link was clicked |
3464 |
timeclicked datetime DEFAULT NULL, -- the date and time the link was clicked |
3465 |
PRIMARY KEY (id), |
3465 |
PRIMARY KEY (id), |
3466 |
KEY bibidx (biblionumber), |
3466 |
KEY bibidx (biblionumber), |
Lines 3476-3482
CREATE TABLE linktracker (
Link Here
|
3476 |
CREATE TABLE IF NOT EXISTS plugin_data ( |
3476 |
CREATE TABLE IF NOT EXISTS plugin_data ( |
3477 |
plugin_class varchar(255) NOT NULL, |
3477 |
plugin_class varchar(255) NOT NULL, |
3478 |
plugin_key varchar(255) NOT NULL, |
3478 |
plugin_key varchar(255) NOT NULL, |
3479 |
plugin_value text, |
3479 |
plugin_value MEDIUMTEXT, |
3480 |
PRIMARY KEY ( `plugin_class` (191), `plugin_key` (191) ) |
3480 |
PRIMARY KEY ( `plugin_class` (191), `plugin_key` (191) ) |
3481 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3481 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3482 |
|
3482 |
|
Lines 3526-3532
ALTER TABLE `patron_list_patrons`
Link Here
|
3526 |
|
3526 |
|
3527 |
CREATE TABLE IF NOT EXISTS marc_modification_templates ( |
3527 |
CREATE TABLE IF NOT EXISTS marc_modification_templates ( |
3528 |
template_id int(11) NOT NULL AUTO_INCREMENT, |
3528 |
template_id int(11) NOT NULL AUTO_INCREMENT, |
3529 |
name text NOT NULL, |
3529 |
name MEDIUMTEXT NOT NULL, |
3530 |
PRIMARY KEY (template_id) |
3530 |
PRIMARY KEY (template_id) |
3531 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3531 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3532 |
|
3532 |
|
Lines 3545-3560
CREATE TABLE IF NOT EXISTS marc_modification_template_actions (
Link Here
|
3545 |
field_value varchar(100) DEFAULT NULL, |
3545 |
field_value varchar(100) DEFAULT NULL, |
3546 |
to_field varchar(3) DEFAULT NULL, |
3546 |
to_field varchar(3) DEFAULT NULL, |
3547 |
to_subfield varchar(1) DEFAULT NULL, |
3547 |
to_subfield varchar(1) DEFAULT NULL, |
3548 |
to_regex_search text, |
3548 |
to_regex_search MEDIUMTEXT, |
3549 |
to_regex_replace text, |
3549 |
to_regex_replace MEDIUMTEXT, |
3550 |
to_regex_modifiers varchar(8) DEFAULT '', |
3550 |
to_regex_modifiers varchar(8) DEFAULT '', |
3551 |
conditional enum('if','unless') DEFAULT NULL, |
3551 |
conditional enum('if','unless') DEFAULT NULL, |
3552 |
conditional_field varchar(3) DEFAULT NULL, |
3552 |
conditional_field varchar(3) DEFAULT NULL, |
3553 |
conditional_subfield varchar(1) DEFAULT NULL, |
3553 |
conditional_subfield varchar(1) DEFAULT NULL, |
3554 |
conditional_comparison enum('exists','not_exists','equals','not_equals') DEFAULT NULL, |
3554 |
conditional_comparison enum('exists','not_exists','equals','not_equals') DEFAULT NULL, |
3555 |
conditional_value text, |
3555 |
conditional_value MEDIUMTEXT, |
3556 |
conditional_regex tinyint(1) NOT NULL DEFAULT '0', |
3556 |
conditional_regex tinyint(1) NOT NULL DEFAULT '0', |
3557 |
description text, |
3557 |
description MEDIUMTEXT, |
3558 |
PRIMARY KEY (mmta_id), |
3558 |
PRIMARY KEY (mmta_id), |
3559 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3559 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3560 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3560 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 3666-3672
CREATE TABLE `localization` (
Link Here
|
3666 |
entity varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, |
3666 |
entity varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, |
3667 |
code varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, |
3667 |
code varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, |
3668 |
lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key |
3668 |
lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key |
3669 |
translation text COLLATE utf8mb4_unicode_ci, |
3669 |
translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci, |
3670 |
PRIMARY KEY (localization_id), |
3670 |
PRIMARY KEY (localization_id), |
3671 |
UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`) |
3671 |
UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`) |
3672 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3672 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 3714-3721
CREATE TABLE `courses` (
Link Here
|
3714 |
`section` varchar(255) DEFAULT NULL, -- the 'section' of a course |
3714 |
`section` varchar(255) DEFAULT NULL, -- the 'section' of a course |
3715 |
`course_name` varchar(255) DEFAULT NULL, -- the name of the course |
3715 |
`course_name` varchar(255) DEFAULT NULL, -- the name of the course |
3716 |
`term` varchar(80) DEFAULT NULL, -- the authorised value for the TERM |
3716 |
`term` varchar(80) DEFAULT NULL, -- the authorised value for the TERM |
3717 |
`staff_note` mediumtext, -- the text of the staff only note |
3717 |
`staff_note` LONGTEXT, -- the text of the staff only note |
3718 |
`public_note` mediumtext, -- the text of the public / opac note |
3718 |
`public_note` LONGTEXT, -- the text of the public / opac note |
3719 |
`students_count` varchar(20) DEFAULT NULL, -- how many students will be taking this course/section |
3719 |
`students_count` varchar(20) DEFAULT NULL, -- how many students will be taking this course/section |
3720 |
`enabled` enum('yes','no') NOT NULL DEFAULT 'yes', -- determines whether the course is active |
3720 |
`enabled` enum('yes','no') NOT NULL DEFAULT 'yes', -- determines whether the course is active |
3721 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3721 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
Lines 3787-3794
CREATE TABLE `course_reserves` (
Link Here
|
3787 |
`cr_id` int(11) NOT NULL AUTO_INCREMENT, |
3787 |
`cr_id` int(11) NOT NULL AUTO_INCREMENT, |
3788 |
`course_id` int(11) NOT NULL, -- foreign key to link to courses.course_id |
3788 |
`course_id` int(11) NOT NULL, -- foreign key to link to courses.course_id |
3789 |
`ci_id` int(11) NOT NULL, -- foreign key to link to courses_items.ci_id |
3789 |
`ci_id` int(11) NOT NULL, -- foreign key to link to courses_items.ci_id |
3790 |
`staff_note` mediumtext, -- staff only note |
3790 |
`staff_note` LONGTEXT, -- staff only note |
3791 |
`public_note` mediumtext, -- public, OPAC visible note |
3791 |
`public_note` LONGTEXT, -- public, OPAC visible note |
3792 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3792 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3793 |
PRIMARY KEY (`cr_id`), |
3793 |
PRIMARY KEY (`cr_id`), |
3794 |
UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), |
3794 |
UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), |
Lines 3832-3844
CREATE TABLE `hold_fill_targets` (
Link Here
|
3832 |
DROP TABLE IF EXISTS `housebound_profile`; |
3832 |
DROP TABLE IF EXISTS `housebound_profile`; |
3833 |
CREATE TABLE `housebound_profile` ( |
3833 |
CREATE TABLE `housebound_profile` ( |
3834 |
`borrowernumber` int(11) NOT NULL, -- Number of the borrower associated with this profile. |
3834 |
`borrowernumber` int(11) NOT NULL, -- Number of the borrower associated with this profile. |
3835 |
`day` text NOT NULL, -- The preferred day of the week for delivery. |
3835 |
`day` MEDIUMTEXT NOT NULL, -- The preferred day of the week for delivery. |
3836 |
`frequency` text NOT NULL, -- The Authorised_Value definining the pattern for delivery. |
3836 |
`frequency` MEDIUMTEXT NOT NULL, -- The Authorised_Value definining the pattern for delivery. |
3837 |
`fav_itemtypes` text default NULL, -- Free text describing preferred itemtypes. |
3837 |
`fav_itemtypes` MEDIUMTEXT default NULL, -- Free text describing preferred itemtypes. |
3838 |
`fav_subjects` text default NULL, -- Free text describing preferred subjects. |
3838 |
`fav_subjects` MEDIUMTEXT default NULL, -- Free text describing preferred subjects. |
3839 |
`fav_authors` text default NULL, -- Free text describing preferred authors. |
3839 |
`fav_authors` MEDIUMTEXT default NULL, -- Free text describing preferred authors. |
3840 |
`referral` text default NULL, -- Free text indicating how the borrower was added to the service. |
3840 |
`referral` MEDIUMTEXT default NULL, -- Free text indicating how the borrower was added to the service. |
3841 |
`notes` text default NULL, -- Free text for additional notes. |
3841 |
`notes` MEDIUMTEXT default NULL, -- Free text for additional notes. |
3842 |
PRIMARY KEY (`borrowernumber`), |
3842 |
PRIMARY KEY (`borrowernumber`), |
3843 |
CONSTRAINT `housebound_profile_bnfk` |
3843 |
CONSTRAINT `housebound_profile_bnfk` |
3844 |
FOREIGN KEY (`borrowernumber`) |
3844 |
FOREIGN KEY (`borrowernumber`) |
Lines 3900-3915
CREATE TABLE `article_requests` (
Link Here
|
3900 |
`biblionumber` int(11) NOT NULL, |
3900 |
`biblionumber` int(11) NOT NULL, |
3901 |
`itemnumber` int(11) DEFAULT NULL, |
3901 |
`itemnumber` int(11) DEFAULT NULL, |
3902 |
`branchcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3902 |
`branchcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3903 |
`title` text, |
3903 |
`title` MEDIUMTEXT, |
3904 |
`author` text, |
3904 |
`author` MEDIUMTEXT, |
3905 |
`volume` text, |
3905 |
`volume` MEDIUMTEXT, |
3906 |
`issue` text, |
3906 |
`issue` MEDIUMTEXT, |
3907 |
`date` text, |
3907 |
`date` MEDIUMTEXT, |
3908 |
`pages` text, |
3908 |
`pages` MEDIUMTEXT, |
3909 |
`chapters` text, |
3909 |
`chapters` MEDIUMTEXT, |
3910 |
`patron_notes` text, |
3910 |
`patron_notes` MEDIUMTEXT, |
3911 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
3911 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
3912 |
`notes` text, |
3912 |
`notes` MEDIUMTEXT, |
3913 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3913 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3914 |
`updated_on` timestamp NULL DEFAULT NULL, |
3914 |
`updated_on` timestamp NULL DEFAULT NULL, |
3915 |
PRIMARY KEY (`id`), |
3915 |
PRIMARY KEY (`id`), |
Lines 3966-3972
CREATE TABLE deletedbiblio_metadata (
Link Here
|
3966 |
CREATE TABLE IF NOT EXISTS club_templates ( |
3966 |
CREATE TABLE IF NOT EXISTS club_templates ( |
3967 |
id int(11) NOT NULL AUTO_INCREMENT, |
3967 |
id int(11) NOT NULL AUTO_INCREMENT, |
3968 |
`name` tinytext NOT NULL, |
3968 |
`name` tinytext NOT NULL, |
3969 |
description text, |
3969 |
description MEDIUMTEXT, |
3970 |
is_enrollable_from_opac tinyint(1) NOT NULL DEFAULT '0', |
3970 |
is_enrollable_from_opac tinyint(1) NOT NULL DEFAULT '0', |
3971 |
is_email_required tinyint(1) NOT NULL DEFAULT '0', |
3971 |
is_email_required tinyint(1) NOT NULL DEFAULT '0', |
3972 |
branchcode varchar(10) NULL DEFAULT NULL, |
3972 |
branchcode varchar(10) NULL DEFAULT NULL, |
Lines 3986-3992
CREATE TABLE IF NOT EXISTS clubs (
Link Here
|
3986 |
id int(11) NOT NULL AUTO_INCREMENT, |
3986 |
id int(11) NOT NULL AUTO_INCREMENT, |
3987 |
club_template_id int(11) NOT NULL, |
3987 |
club_template_id int(11) NOT NULL, |
3988 |
`name` tinytext NOT NULL, |
3988 |
`name` tinytext NOT NULL, |
3989 |
description text, |
3989 |
description MEDIUMTEXT, |
3990 |
date_start date DEFAULT NULL, |
3990 |
date_start date DEFAULT NULL, |
3991 |
date_end date DEFAULT NULL, |
3991 |
date_end date DEFAULT NULL, |
3992 |
branchcode varchar(10) NULL DEFAULT NULL, |
3992 |
branchcode varchar(10) NULL DEFAULT NULL, |
Lines 4029-4035
CREATE TABLE IF NOT EXISTS club_template_enrollment_fields (
Link Here
|
4029 |
id int(11) NOT NULL AUTO_INCREMENT, |
4029 |
id int(11) NOT NULL AUTO_INCREMENT, |
4030 |
club_template_id int(11) NOT NULL, |
4030 |
club_template_id int(11) NOT NULL, |
4031 |
`name` tinytext NOT NULL, |
4031 |
`name` tinytext NOT NULL, |
4032 |
description text, |
4032 |
description MEDIUMTEXT, |
4033 |
authorised_value_category varchar(16) DEFAULT NULL, |
4033 |
authorised_value_category varchar(16) DEFAULT NULL, |
4034 |
PRIMARY KEY (id), |
4034 |
PRIMARY KEY (id), |
4035 |
KEY club_template_id (club_template_id), |
4035 |
KEY club_template_id (club_template_id), |
Lines 4044-4050
CREATE TABLE IF NOT EXISTS club_enrollment_fields (
Link Here
|
4044 |
id int(11) NOT NULL AUTO_INCREMENT, |
4044 |
id int(11) NOT NULL AUTO_INCREMENT, |
4045 |
club_enrollment_id int(11) NOT NULL, |
4045 |
club_enrollment_id int(11) NOT NULL, |
4046 |
club_template_enrollment_field_id int(11) NOT NULL, |
4046 |
club_template_enrollment_field_id int(11) NOT NULL, |
4047 |
`value` text NOT NULL, |
4047 |
`value` MEDIUMTEXT NOT NULL, |
4048 |
PRIMARY KEY (id), |
4048 |
PRIMARY KEY (id), |
4049 |
KEY club_enrollment_id (club_enrollment_id), |
4049 |
KEY club_enrollment_id (club_enrollment_id), |
4050 |
KEY club_template_enrollment_field_id (club_template_enrollment_field_id), |
4050 |
KEY club_template_enrollment_field_id (club_template_enrollment_field_id), |
Lines 4060-4066
CREATE TABLE IF NOT EXISTS club_template_fields (
Link Here
|
4060 |
id int(11) NOT NULL AUTO_INCREMENT, |
4060 |
id int(11) NOT NULL AUTO_INCREMENT, |
4061 |
club_template_id int(11) NOT NULL, |
4061 |
club_template_id int(11) NOT NULL, |
4062 |
`name` tinytext NOT NULL, |
4062 |
`name` tinytext NOT NULL, |
4063 |
description text, |
4063 |
description MEDIUMTEXT, |
4064 |
authorised_value_category varchar(16) DEFAULT NULL, |
4064 |
authorised_value_category varchar(16) DEFAULT NULL, |
4065 |
PRIMARY KEY (id), |
4065 |
PRIMARY KEY (id), |
4066 |
KEY club_template_id (club_template_id), |
4066 |
KEY club_template_id (club_template_id), |
Lines 4075-4081
CREATE TABLE IF NOT EXISTS club_fields (
Link Here
|
4075 |
id int(11) NOT NULL AUTO_INCREMENT, |
4075 |
id int(11) NOT NULL AUTO_INCREMENT, |
4076 |
club_template_field_id int(11) NOT NULL, |
4076 |
club_template_field_id int(11) NOT NULL, |
4077 |
club_id int(11) NOT NULL, |
4077 |
club_id int(11) NOT NULL, |
4078 |
`value` text, |
4078 |
`value` MEDIUMTEXT, |
4079 |
PRIMARY KEY (id), |
4079 |
PRIMARY KEY (id), |
4080 |
KEY club_template_field_id (club_template_field_id), |
4080 |
KEY club_template_field_id (club_template_field_id), |
4081 |
KEY club_id (club_id), |
4081 |
KEY club_id (club_id), |
Lines 4102-4109
CREATE TABLE illrequests (
Link Here
|
4102 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4102 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4103 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4103 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4104 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
4104 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
4105 |
notesopac text DEFAULT NULL, -- Patron notes attached to request |
4105 |
notesopac MEDIUMTEXT DEFAULT NULL, -- Patron notes attached to request |
4106 |
notesstaff text DEFAULT NULL, -- Staff notes attached to request |
4106 |
notesstaff MEDIUMTEXT DEFAULT NULL, -- Staff notes attached to request |
4107 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4107 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4108 |
backend varchar(20) DEFAULT NULL, -- The backend used to create request |
4108 |
backend varchar(20) DEFAULT NULL, -- The backend used to create request |
4109 |
CONSTRAINT `illrequests_bnfk` |
4109 |
CONSTRAINT `illrequests_bnfk` |
Lines 4124-4130
DROP TABLE IF EXISTS `illrequestattributes`;
Link Here
|
4124 |
CREATE TABLE illrequestattributes ( |
4124 |
CREATE TABLE illrequestattributes ( |
4125 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
4125 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
4126 |
type varchar(200) NOT NULL, -- API ILL property name |
4126 |
type varchar(200) NOT NULL, -- API ILL property name |
4127 |
value text NOT NULL, -- API ILL property value |
4127 |
value MEDIUMTEXT NOT NULL, -- API ILL property value |
4128 |
PRIMARY KEY (`illrequest_id`, `type` (191)), |
4128 |
PRIMARY KEY (`illrequest_id`, `type` (191)), |
4129 |
CONSTRAINT `illrequestattributes_ifk` |
4129 |
CONSTRAINT `illrequestattributes_ifk` |
4130 |
FOREIGN KEY (illrequest_id) |
4130 |
FOREIGN KEY (illrequest_id) |
Lines 4142-4148
CREATE TABLE library_groups (
Link Here
|
4142 |
parent_id INT(11) NULL DEFAULT NULL, -- if this is a child group, the id of the parent group |
4142 |
parent_id INT(11) NULL DEFAULT NULL, -- if this is a child group, the id of the parent group |
4143 |
branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group |
4143 |
branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group |
4144 |
title VARCHAR(100) NULL DEFAULT NULL, -- Short description of the goup |
4144 |
title VARCHAR(100) NULL DEFAULT NULL, -- Short description of the goup |
4145 |
description TEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary |
4145 |
description MEDIUMTEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary |
4146 |
ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group |
4146 |
ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group |
4147 |
ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups |
4147 |
ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups |
4148 |
ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups |
4148 |
ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups |
4149 |
- |
|
|