View | Details | Raw Unified | Return to bug 18336
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-311 / +310 lines)
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
- 

Return to bug 18336