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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +5 lines)
Lines 568-574 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
568
DROP TABLE IF EXISTS `deletedborrowers`;
568
DROP TABLE IF EXISTS `deletedborrowers`;
569
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrowers you have deleted
569
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrowers you have deleted
570
  `borrowernumber` int(11) NOT NULL default 0, -- primary key, Koha assigned ID number for patrons/borrowers
570
  `borrowernumber` int(11) NOT NULL default 0, -- primary key, Koha assigned ID number for patrons/borrowers
571
  `cardnumber` varchar(16) default NULL, -- unique key, library assigned ID number for patrons/borrowers
571
  `cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers
572
  `surname` mediumtext NOT NULL, -- patron/borrower's last name (surname)
572
  `surname` mediumtext NOT NULL, -- patron/borrower's last name (surname)
573
  `firstname` text, -- patron/borrower's first name
573
  `firstname` text, -- patron/borrower's first name
574
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
574
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
Lines 1379-1385 CREATE TABLE pending_offline_operations ( Link Here
1379
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1379
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1380
  `action` varchar(10) NOT NULL,
1380
  `action` varchar(10) NOT NULL,
1381
  barcode varchar(20) DEFAULT NULL,
1381
  barcode varchar(20) DEFAULT NULL,
1382
  cardnumber varchar(16) DEFAULT NULL,
1382
  cardnumber varchar(32) DEFAULT NULL,
1383
  amount decimal(28,6) DEFAULT NULL,
1383
  amount decimal(28,6) DEFAULT NULL,
1384
  PRIMARY KEY (operationid)
1384
  PRIMARY KEY (operationid)
1385
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1385
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Lines 1608-1614 CREATE TABLE `sms_providers` ( Link Here
1608
DROP TABLE IF EXISTS `borrowers`;
1608
DROP TABLE IF EXISTS `borrowers`;
1609
CREATE TABLE `borrowers` ( -- this table includes information about your patrons/borrowers/members
1609
CREATE TABLE `borrowers` ( -- this table includes information about your patrons/borrowers/members
1610
  `borrowernumber` int(11) NOT NULL auto_increment, -- primary key, Koha assigned ID number for patrons/borrowers
1610
  `borrowernumber` int(11) NOT NULL auto_increment, -- primary key, Koha assigned ID number for patrons/borrowers
1611
  `cardnumber` varchar(16) default NULL, -- unique key, library assigned ID number for patrons/borrowers
1611
  `cardnumber` varchar(32) default NULL, -- unique key, library assigned ID number for patrons/borrowers
1612
  `surname` mediumtext NOT NULL, -- patron/borrower's last name (surname)
1612
  `surname` mediumtext NOT NULL, -- patron/borrower's last name (surname)
1613
  `firstname` text, -- patron/borrower's first name
1613
  `firstname` text, -- patron/borrower's first name
1614
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
1614
  `title` mediumtext, -- patron/borrower's title, for example: Mr. or Mrs.
Lines 2497-2503 CREATE TABLE `tmp_holdsqueue` ( Link Here
2497
  `firstname` text,
2497
  `firstname` text,
2498
  `phone` text,
2498
  `phone` text,
2499
  `borrowernumber` int(11) NOT NULL,
2499
  `borrowernumber` int(11) NOT NULL,
2500
  `cardnumber` varchar(16) default NULL,
2500
  `cardnumber` varchar(32) default NULL,
2501
  `reservedate` date default NULL,
2501
  `reservedate` date default NULL,
2502
  `title` mediumtext,
2502
  `title` mediumtext,
2503
  `itemcallnumber` varchar(255) default NULL,
2503
  `itemcallnumber` varchar(255) default NULL,
Lines 3405-3411 CREATE TABLE IF NOT EXISTS `borrower_modifications` ( Link Here
3405
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3405
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3406
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3406
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3407
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3407
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3408
  `cardnumber` varchar(16) DEFAULT NULL,
3408
  `cardnumber` varchar(32) DEFAULT NULL,
3409
  `surname` mediumtext,
3409
  `surname` mediumtext,
3410
  `firstname` text,
3410
  `firstname` text,
3411
  `title` mediumtext,
3411
  `title` mediumtext,
(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
Lines 93-99 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
93
('CalculateFinesOnReturn','1','','Switch to control if overdue fines are calculated on return or not','YesNo'),
93
('CalculateFinesOnReturn','1','','Switch to control if overdue fines are calculated on return or not','YesNo'),
94
('CalendarFirstDayOfWeek','0','0|1|2|3|4|5|6','Select the first day of week to use in the calendar.','Choice'),
94
('CalendarFirstDayOfWeek','0','0|1|2|3|4|5|6','Select the first day of week to use in the calendar.','Choice'),
95
('canreservefromotherbranches','1','','With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),
95
('canreservefromotherbranches','1','','With Independent branches on, can a user from one library place a hold on an item from another library','YesNo'),
96
('CardnumberLength', '', '', 'Set a length for card numbers.', 'Free'),
96
('CardnumberLength', '', '', 'Set a length for card numbers with a maximum of 32 characters.', 'Free'),
97
('casAuthentication','0','','Enable or disable CAS authentication','YesNo'),
97
('casAuthentication','0','','Enable or disable CAS authentication','YesNo'),
98
('casLogout','0','','Does a logout from Koha should also log the user out of CAS?','YesNo'),
98
('casLogout','0','','Does a logout from Koha should also log the user out of CAS?','YesNo'),
99
('casServerUrl','https://localhost:8443/cas','','URL of the cas server','Free'),
99
('casServerUrl','https://localhost:8443/cas','','URL of the cas server','Free'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-2 / +1 lines)
Lines 174-180 Patrons: Link Here
174
         - Card numbers for patrons must be
174
         - Card numbers for patrons must be
175
         - pref: CardnumberLength
175
         - pref: CardnumberLength
176
         - "characters long. The length can be a single number to specify an exact length, a range separated by a comma (i.e., 'Min,Max'), or a maximum with no minimum (i.e., ',Max')."
176
         - "characters long. The length can be a single number to specify an exact length, a range separated by a comma (i.e., 'Min,Max'), or a maximum with no minimum (i.e., ',Max')."
177
         - "If 'cardnumber' is included in the BorrowerMandatoryField list, the minimum length, if not specified here, defaults to one. Maximum cannot be bigger than the database field size."
177
         - "If 'cardnumber' is included in the BorrowerMandatoryField list, the minimum length, if not specified here, defaults to one. Maximum cannot be bigger than the database field size of 32."
178
     -
178
     -
179
         - pref: useDischarge
179
         - pref: useDischarge
180
           choices:
180
           choices:
181
- 

Return to bug 13178