Lines 642-648
CREATE TABLE `deletedbiblioitems` (
Link Here
|
642 |
DROP TABLE IF EXISTS `deletedborrowers`; |
642 |
DROP TABLE IF EXISTS `deletedborrowers`; |
643 |
CREATE TABLE `deletedborrowers` ( |
643 |
CREATE TABLE `deletedborrowers` ( |
644 |
`borrowernumber` int(11) NOT NULL default 0, |
644 |
`borrowernumber` int(11) NOT NULL default 0, |
645 |
`cardnumber` varchar(9) NOT NULL default '', |
645 |
`cardnumber` varchar(16) NOT NULL default '', |
646 |
`surname` mediumtext NOT NULL, |
646 |
`surname` mediumtext NOT NULL, |
647 |
`firstname` text, |
647 |
`firstname` text, |
648 |
`title` mediumtext, |
648 |
`title` mediumtext, |
Lines 703-708
CREATE TABLE `deletedborrowers` (
Link Here
|
703 |
`altcontactcountry` text default NULL, |
703 |
`altcontactcountry` text default NULL, |
704 |
`altcontactphone` varchar(50) default NULL, |
704 |
`altcontactphone` varchar(50) default NULL, |
705 |
`smsalertnumber` varchar(50) default NULL, |
705 |
`smsalertnumber` varchar(50) default NULL, |
|
|
706 |
`privacy` integer(11) DEFAULT '1' NOT NULL, |
706 |
KEY `borrowernumber` (`borrowernumber`), |
707 |
KEY `borrowernumber` (`borrowernumber`), |
707 |
KEY `cardnumber` (`cardnumber`) |
708 |
KEY `cardnumber` (`cardnumber`) |
708 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
709 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |