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, |